Ask or search…
⌃K

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