KaskoazulUSDC Transfer volume fees :(
Updated 2022-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with Algorand as (
select block_timestamp::date as fecha,
count(distinct tx_id) as txs,
round(sum(tx_message:txn:aamt/pow(10,6)),2) as daily_vol,
round(daily_vol / txs, 2) as avg_tx,
round(sum(fee), 3) as daily_fees,
round(daily_fees / txs, 5) as avg_fee
from algorand.transactions
where asset_id = '31566704'
and tx_type_name = 'asset transfer'
and fecha >= '2022-01-01'
group by 1
order by 1
),
Solana_data as (
select tf.block_timestamp::date as fecha,
tf.tx_id,
tf.amount,
tc.fee/pow(10,9) as fee
from solana.fact_transfers tf
left join solana.fact_transactions tc
on tf.tx_id = tc.tx_id
where mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and fecha >= '2022-01-01'
limit 500
),
Solana as (
select fecha,
count(distinct tx_id) as txs,
round(sum(amount),2) as daily_vol,
round(daily_vol / txs, 2) as avg_tx,
round(sum(fee), 3) as daily_fees,
daily_fees / txs as avg_fee
from Solana_data
Run a query to Download Data