nickpayiatis_Untitled Query
Updated 2022-11-21
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select label, address, asset_name, sum(amount) as trans
from algorand.core.dim_label l
inner join algorand.core.ez_transfer t on t.asset_sender = l.address
where label_type = 'cex'
and label ilike 'coinbase'
and block_timestamp::date > '2022-11-15'
and asset_name = 'ALGO'
group by label, address, asset_name
order by trans desc
Run a query to Download Data