fantaNumber of minted gALGO3
    Updated 2022-04-18
    with tbl1 as (select sum(amount)
    from
    algorand.payment_transaction
    where
    to_date(block_timestamp) >='2022-03-31 12:00:00' and to_date(block_timestamp) <='2022-04-14 6:00:00'
    and receiver='RXI3PCQNQKI3WJ2XM4ORAJRLXLYYYJFZVCO4F3LIZD56RPPZLGX2UVQ5LU')

    , tbl2 as (select sum(amount), to_date(block_timestamp) as blockdate
    from
    algorand.payment_transaction
    where
    to_date(block_timestamp) >='2022-03-31 12:00:00' and to_date(block_timestamp) <='2022-04-14 6:00:00'
    and receiver='RXI3PCQNQKI3WJ2XM4ORAJRLXLYYYJFZVCO4F3LIZD56RPPZLGX2UVQ5LU'
    group by blockdate)

    , tbl3 as (select sum(amount), to_date(block_timestamp) as blockdate
    from
    algorand.payment_transaction
    where
    receiver='RXI3PCQNQKI3WJ2XM4ORAJRLXLYYYJFZVCO4F3LIZD56RPPZLGX2UVQ5LU'
    group by blockdate)
    select * from tb
    Run a query to Download Data