KaskoazulUSDC Transfer volume high stakes
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,
sender,
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'
and sender in ('ZG54ZBZ5LVWV3MTGOPDSKCBL5LEQTAPUTN5OQQZUMTAYV3JIICA7G3RJZE', '2UEQTE5QDNXPI7M3TU44G6SYKLFWLPQO7EBZM7K7MHMQQMFI4QJPLHQFHM')
group by 1, 2
order by 1
),
Solana as (
select block_timestamp::date as fecha,
count(distinct tx_id) as txs,
round(sum(amount),2) as daily_vol,
round(daily_vol / txs, 2) as avg_tx
from solana.fact_transfers
where mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and fecha >= '2022-01-01'
group by 1
order by 1
),
Ethereum as (
select block_timestamp::date as fecha,
count(distinct tx_id) as txs,
round(sum(amount),2) as daily_vol,
round(sum(amount_usd),2) as daily_vol_usd,
round(daily_vol / txs, 2) as avg_tx
Run a query to Download Data