daedunamulmemeSlerf
Updated 2024-07-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH
tableSolanaTransfers AS
(
SELECT * FROM solana.core.fact_transfers WHERE block_timestamp >= '2024-01-01'
)
,
memeSlerfUniques AS
(
SELECT DATE_TRUNC( 'day' , block_timestamp ) AS Day , COUNT( DISTINCT tx_to ) AS Uniques
FROM tableSolanaTransfers
WHERE mint LIKE '7BgBvyjrZX1YKz4oh9mjb8ZScatkkwb8DzFx7LoiVkM3'
GROUP BY Day
)
SELECT * FROM memeSlerfUniques ORDER BY Day DESC
QueryRunArchived: QueryRun has been archived