nickpayiatis_Untitled Query
    Updated 2022-11-21
    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