ErsvanUser and amount $CRUMB rewards in airdrop
Updated 2022-06-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH TID (ID) AS(
SELECT ASSET_ID FROM flipside_prod_db.algorand.asset WHERE CREATOR_ADDRESS = 'GOOSECHXVEKJ4SO43NTW5HXOIGLFGC2SQDAVWQGJCN576ODJ5SECV6MUOM' AND ASSET_DELETED = FALSE
),
TAd (Ad) AS (
SELECT
DISTINCT ADDRESS
FROM
flipside_prod_db.algorand.account_asset
JOIN TID ON ASSET_ID = ID
WHERE AMOUNT != 0
),
TTd (DAY_DATE,ADDRESS,AMOUNT) AS (
SELECT
DISTINCT
DATE_TRUNC('day', block_timestamp) AS DAY_DATE,
ASSET_RECEIVER,
ASSET_AMOUNT
FROM
flipside_prod_db.algorand.asset_transfer_transaction
JOIN TAd ON Ad = ASSET_RECEIVER
WHERE
ASSET_ID = 751294723
AND ASSET_AMOUNT != 0
AND SENDER ='R6HMZIHUFPPFOOKO2ZBFA3M5ZGZ27ON67BOAIPTPQRPICNV75BWDLNFALE'
)
SELECT
ADDRESS,
SUM(AMOUNT) AS AMOUNT
FROM
TTd
WHERE
DAYOFWEEK(DAY_DATE) = 1
GROUP BY ADDRESS
Run a query to Download Data