fanta1)GARD been minted by day
    Updated 2022-04-18
    with tbl1 as
    (
    select sum(asset_amount/1e6) as GARD_amounts,date(block_timestamp::date) as dt from algorand.asset_transfer_transaction
    where sender='J2E2XXS4FTW3POVNZIHRIHTFRGOWEWX65NFYIVYIA27HUK63NWT65OLB2Y' and asset_id=684649988
    group by dt
    )

    ,tbl2 as
    (
    select count(distinct asset_receiver) as GARD_wallets ,date(block_timestamp::date) as dt from algorand.asset_transfer_transaction
    where sender='J2E2XXS4FTW3POVNZIHRIHTFRGOWEWX65NFYIVYIA27HUK63NWT65OLB2Y' and asset_id=684649988
    group by dt
    )

    ,tbl3 as
    (
    select sum(fee) as fee from algorand.transactions
    where asset_id=684649988
    )

    ,tbl4 as
    (
    select sum(fee) as fee,date(block_timestamp::date) as dt from algorand.transactions
    where asset_id=684649988
    group by dt
    )
    ,tbl5 as
    (
    select sum(amount) as algo from algorand.payment_transaction
    where receiver='MTMJ5ADRK3CFG3HGUI7FS4Y55WGCUO5CRUMVNBZ7FW5IIG6T3IU2VJHUMM'
    )

    select GARD_amounts,GARD_wallets,tbl1.dt from tbl1 inner join tbl2
    on tbl1.dt=tbl2.dt
    Run a query to Download Data