Abolfazl_771025Dexalot subnet transaction
    Updated 2023-03-09
    select
    date_trunc('week',a.block_timestamp) as date,
    event_name as event,
    count(a.tx_hash) as tx_count,
    sum(tx_count) over (order by date) as cum_tx,
    count(DISTINCT FROM_ADDRESS) as users_count,
    sum(users_count) over (order by date) as cum_user,
    sum(avax_value) as volume,
    sum(volume) over (order by date) as cum_value,
    sum(TX_FEE) / count(a.tx_hash) as tx_fee_p
    from avalanche.core.fact_transactions a join avalanche.core.fact_event_logs b on a.tx_hash = b.tx_hash
    where a.tx_hash in (select tx_hash from avalanche.core.fact_token_transfers a join avalanche.core.dim_contracts b on a.contract_address = b.address
    where symbol = 'ALOT')
    and event_name is not null
    group by 1,2
    Run a query to Download Data