0xCd2d8965A1D3cb529B2E4C3AF6C558676e362739DAOs dot fun copy
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- forked from jackguy / DAOs dot fun copy @ https://flipsidecrypto.xyz/jackguy/q/m8ac0G8U8r__/daos-dot-fun-copy
-- forked from DAOs dot fun @ https://flipsidecrypto.xyz/studio/queries/0801849a-9ba9-4fd8-a667-3b8876ecc674
with tab1 as (
SELECT *
from solana.core.fact_events
where program_id like '4FqThZWv3QKWkSyXCDmATpWkpEiCHq5yhkdGWpSEDAZM'
and ARRAY_SIZE(inner_instruction['instructions']) = 20
)
SELECT
date(block_timestamp) as day,
count(*) as new_tokens,
sum(new_daos) over (order by day) as total_tokens
from tab1
GROUP BY 1
order by 1 DESC