KaskoazulPlanetwatch
Updated 2022-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
--WITH Daily_Wallets AS (
SELECT
DATE_TRUNC('DAY', block_timestamp) as DATE,
asset_receiver as WALLET
FROM
algorand.asset_transfer_transaction
WHERE
sender = 'ZW3ISEHZUHPO7OZGMKLKIIMKVICOUDRCERI454I3DB2BH52HGLSO67W754'
AND asset_id = '27165954'
AND asset_amount > 0
GROUP BY 1, 2
ORDER BY 2
--)
Run a query to Download Data