fantaNumber of minted gALGO3
Updated 2022-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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