Page cover image

Blockchain Activity Monitor

Schema: BAM

This schema contains active user, transaction, gas, and token transfer volumes for apps and contracts tagged on Artemis' Blockchain Activity Monitor

Sample Query

// Pull active users, transactions, and new users for AAVE
select 
    date, 
    chain,
    dau,
    transactions,
    new_users 
from 
    bam.fundamental_data_by_namespace
where namespace = 'aave'


// Pull transactions by category for Ethereum
select 
    date, category, sum(transactions) transactions
from 
    bam.fundamental_data_by_category
where chain = 'ethereum'
GROUP BY 
    1, 2
ORDER by 
    2, 1
Table name
Descriptions

FUNDAMENTAL_DATA_BY_CHAIN

Top level chain view for 6 supported EVM chains

FUNDAMENTAL_DATA_BY_CATEGORY

Activity by sector category

FUNDAMENTAL_DATA_BY_NAMESPACE

Activity by "namespace" - colloquially these are dApps

FUNDAMENTAL_DATA_BY_CONTRACT

Activity at the contract layer. Rolls up to the "namespace" level when possible

NAMESPACES

All "namespaces" Artemis has tagged

CONTRACTS

Contract Artemis has tagged - often used in conjunction with NAMESPACES

Last updated