PapasotGard daily burns
Updated 2022-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date_trunc('day',block_timestamp) as block_day,
SUM(asset_amount)/1000000 as Gard_returns,
COUNT(DISTINCT(asset_receiver)) as Users
FROM
algorand.asset_transfer_transaction
WHERE
asset_id = 684649988
AND
asset_receiver = 'J2E2XXS4FTW3POVNZIHRIHTFRGOWEWX65NFYIVYIA27HUK63NWT65OLB2Y'
AND
block_timestamp > '2022-4-1'
GROUP BY block_day
order by block_day
Run a query to Download Data