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

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 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