zpencerDAO Token Addresses
Updated 2025-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from DAO Creation Data @ https://flipsidecrypto.xyz/studio/queries/71b21508-6c3f-4b85-b545-053630e94d98
-- with events as (
-- select *
-- from solana.core.fact_events fe
-- where tx_id in (
-- select distinct tx_id
-- from solana.core.fact_events
-- where program_id = '8qQwPgMtbjKUcPo8YVh8kbHSgK82P66bTjiGTZ6WPQBK' -- daos.fun program
-- and succeeded = TRUE
-- )
-- and index = 1
-- and program_id = '4FqThZWv3QKWkSyXCDmATpWkpEiCHq5yhkdGWpSEDAZM'
-- ),
-- token_creation as (
-- select distinct e.instruction:accounts[3]::STRING as dao_token, min(e.block_timestamp) as create_event_timestamp
-- from events e
-- group by e.instruction:accounts[3]::STRING
-- )
-- select create_event_timestamp::DATE as create_date, count(dao_token) as DAOS_created
-- from token_creation
-- group by create_event_timestamp::DATE
-- order by 1
WITH tab1 AS (
SELECT
*,
ARRAY_SIZE(inner_instruction['instructions'])
FROM
solana.core.fact_events
WHERE
program_id = '4FqThZWv3QKWkSyXCDmATpWkpEiCHq5yhkdGWpSEDAZM'
AND ARRAY_SIZE(inner_instruction['instructions']) = 20
AND block_timestamp > '2024-09-01'
)
SELECT
QueryRunArchived: QueryRun has been archived