PapasotgoETH daily mint
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
date_trunc('day',block_timestamp) as block_day,
SUM(asset_amount)/100000000 as Minted_ETH,
COUNT(DISTINCT(asset_receiver)) as Users,
asset_id
FROM
algorand.asset_transfer_transaction
WHERE
(
-- asset_id = '386192725' OR
asset_id = '386195940'
)
AND
sender = 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4'
GROUP BY block_day,asset_id
ORDER BY block_day
Run a query to Download Data