MLDZMNpepe7
Updated 2023-06-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- forked from fbba3 @ https://flipsidecrypto.xyz/edit/queries/68f89235-500f-4140-80a7-812813fbfa72
select
BLOCK_TIMESTAMP::date date ,
count(distinct USER_ADDRESS) as holder ,
sum(balance) as balances
from
ethereum.core.fact_token_balances
where
CONTRACT_ADDRESS ilike '0x6982508145454ce325ddbe47a25d4ec3d2311933'
and
date >= CURRENT_DATE - 30
group by 1
Run a query to Download Data