daedunamulmemePepe
Updated 2024-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH
tableEthereumTransfers AS
(
SELECT * FROM ethereum.core.fact_token_transfers WHERE block_timestamp >= '2022-10-01'
)
,
memePepeUniques AS
(
SELECT DATE_TRUNC( 'day' , block_timestamp ) AS Day , COUNT( DISTINCT to_address ) AS Uniques
FROM tableEthereumTransfers
WHERE contract_address LIKE '0x6982508145454ce325ddbe47a25d4ec3d2311933'
GROUP BY Day
)
SELECT * FROM memePepeUniques ORDER BY Day DESC
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived