Abolfazl_771025Dexalot subnet transaction
Updated 2023-03-09Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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