PapasotgoBTC daily redeem
Updated 2023-01-02
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 Redeemed_BTC,
COUNT(DISTINCT(asset_receiver)) as Users,
asset_id
FROM
algorand.asset_transfer_transaction
WHERE
(
asset_id = '386192725'
--asset_id = '386195940'
)
AND
asset_receiver = 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4'
GROUP BY block_day,asset_id
ORDER BY block_day
Run a query to Download Data