LTirrellHelium Mints by Hotspot Collection copy
Updated 2023-05-31
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 anduril / Helium Mints by Hotspot Collection @ https://flipsidecrypto.xyz/anduril/q/2023-05-01-02-24-pm-9oHRFb
-- forked from Helium Compressed NFT Mints - Totals @ https://flipsidecrypto.xyz/edit/queries/06aac6fb-7234-43ae-acea-6fb5ab722bd8
with
helium_bgum_txs as (
select
date(block_timestamp) as date,
tx_id,
program_id,
signers[0] as deployer, -- fee_payer
f.value:accounts[1]::string as collector, --hotspot owner
f.value:accounts[8]::string as collection_address, --hotspot
f.value:accounts[9]::string as collection_metadata
from
solana.core.fact_events e
inner join lateral flatten(input => inner_instruction:instructions) f
where
date(block_timestamp) >= '2023-04-17'
and program_id in (
'hemjuPXBpNvggtaUnN1MwT3wrdhttKEfosTcc2P9Pg8',
'1atrmQs3eq1N2FEYWu6tyTXbCjP4uQwExpjtnhXtS8h'
)
and f.value:programId = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
and succeeded
and tx_id = 'n19gBirHKtP8EmfcrkM3iPm9p4JxY8HouWxxdkTBb2LBusvux5u9p87VbN54eBkUxJJAQzLwHmRw1xwcdb5gC79'
--limit 10
)
-- ,
-- select distinct collection_address from helium_bgum_txs order by collection_address
-- (chatGPT these for labels table)
select
*
FROM
helium_bgum_txs
limit 100
Run a query to Download Data