Switchboard22q1_v2_unique_pid_count
Updated 2023-12-18
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
›
⌄
WITH t0 AS (
SELECT
DISTINCT tx_id,
ixn.value:programId::TEXT AS pid
FROM
solana.core.fact_transactions t,
lateral flatten (input => instructions) ixn
WHERE
t.block_timestamp BETWEEN '2022-03-01' AND '2022-03-31'
AND succeeded
AND ixn.value:programId != 'SW1TCH7qEPTdLsDHRgPuMQjbQxKdH2aBStViMFnt64f'
AND ixn.value:programId != 'ComputeBudget111111111111111111111111111111'
AND ixn.value:programId != 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL'
AND ixn.value:programId != 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
AND ixn.value:programId != '11111111111111111111111111111111'
AND ixn.value:programId != 'AddressLookupTab1e1111111111111111111111111'
),
t1 AS (
SELECT
DISTINCT tx_id,
key.value:pubkey::TEXT AS pubkey
FROM
solana.core.fact_transactions t,
lateral flatten (input => account_keys) key
WHERE
t.block_timestamp BETWEEN '2022-03-01' AND '2022-03-31'
AND succeeded
),
t2 AS (
SELECT livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/v1/queries/6b9a6694-05b1-4c09-b68b-c9453c4353ba/data/latest'
):data AS data
),
Run a query to Download Data