daedunamulwtfIonet
Updated 2024-08-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from memeWif @ https://flipsidecrypto.xyz/edit/queries/c700d201-07f9-414a-837d-284090464dff
WITH
tableSolanaTransfers AS
(
SELECT * FROM solana.core.fact_transfers WHERE block_timestamp >= '2024-05-01'
)
,
wtfIonetUnique AS
(
SELECT DATE_TRUNC( 'day' , block_timestamp ) AS Day , COUNT( DISTINCT tx_to ) AS Uniques
FROM tableSolanaTransfers
WHERE mint LIKE 'BZLbGTNCSFfoth2GYDtwr7e4imWzpR5jqcUuGEwr646K'
GROUP BY Day
)
SELECT * FROM wtfIonetUnique ORDER BY Day DESC
QueryRunArchived: QueryRun has been archived