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

Artemis Dashboard

​
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 nameDescriptions
FUNDAMENTAL_DATA_BY_CHAINTop level chain view for 6 supported EVM chains
FUNDAMENTAL_DATA_BY_CATEGORYActivity by sector category
FUNDAMENTAL_DATA_BY_NAMESPACEActivity by “namespace” - colloquially these are dApps
FUNDAMENTAL_DATA_BY_CONTRACTActivity at the contract layer. Rolls up to the “namespace” level when possible
NAMESPACESAll “namespaces” Artemis has tagged
CONTRACTSContract Artemis has tagged - often used in conjunction with NAMESPACES