LTirrellSOL Deposited per Collection Created copy
Updated 2023-05-31
999
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 marqu / SOL Deposited per Collection Created @ https://flipsidecrypto.xyz/marqu/q/2023-04-19-02-13-pm-VKt2gj
with
compressed_txs as (
select distinct block_timestamp, tx_id, 'collection_mint' as label
from solana.core.fact_events
inner join lateral flatten(input => inner_instruction :instructions) f
where succeeded
and program_id = 'SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu' -- Squads
and signers[0] = 'hprdnjkbziK8NqhThmAn5Gu4XqrBbctX8du4PfJdgvW' -- Helium Multisig
and f.value :programId = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s'
and array_size(f.value :accounts) = 6
and block_timestamp >= '2023-04-18'
union all
select distinct block_timestamp, tx_id, 'token_mint' as label
from solana.core.fact_events
inner join lateral flatten (input => inner_instruction :instructions) f
where succeeded
and program_id = '1atrmQs3eq1N2FEYWu6tyTXbCjP4uQwExpjtnhXtS8h' -- lazy_transactions
and f.value :programId = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY' -- bubblegum
and block_timestamp > '2023-04-18'
),
-- tx_fees as (
-- select
-- block_timestamp,
-- fee / pow(10,9) as sol,
-- 'Tx. Fee' as label_fee
-- from compressed_txs
Run a query to Download Data