rain_syndicaSAMO Airdrop Recipients
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH
airdrops AS (
SELECT
*
FROM solana.core.fact_transfers
WHERE block_timestamp < '2021-05-30'
AND block_timestamp >= '2021-04-23'
AND tx_from = 'samohexDip23Xe39eKrndWG25QWSnnckUa2Yc3iEe9v'
AND mint = '7xKXtg2CW87d97TXJSDpbD5jBkheTqA83TZRuJosgAsU'
-- ORDER BY block_timestamp DESC
)
SELECT
date_trunc(day, block_timestamp) AS day,
SUM(amount) AS amount,
COUNT(DISTINCT tx_to) AS num_recipients
FROM airdrops
WHERE day = TO_DATE('2021-04-23')
GROUP BY 1
ORDER BY 1