jfoUsers going Wormhole > ETH and what tokens they hold
Updated 2022-06-23
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 data_sol as (
select
instruction:accounts[0] as address
from
solana.core.fact_events
where
program_id = 'wormDTUJ6AWPNvk59vGQbDvGJmqbDTdgWgAqcLBCgUb'
and
inner_instruction:instructions[0]:parsed:type = 'burn'
and
-- YEAR(block_timestamp::date) = 2022
-- and
succeeded = true
group by 1
)
, data_user_programs as (
select
b.address,
case when label is null then program_id else label end as labeling
from
solana.core.fact_events a join data_sol b on a.instruction:accounts[0] = b.address
left join solana.core.dim_labels c on a.program_id = c.address
where
succeeded = true
and
program_id not in (
'wormDTUJ6AWPNvk59vGQbDvGJmqbDTdgWgAqcLBCgUb', -- exclude wormhole
'worm2ZoG2kUd4vFXhvjh93UUH596ayRfgQ2MgjNMTth', -- exclude wormhole
'DeJBGdMFa1uynnnKiwrVioatTuHmNLpyFKnmB5kaFdzQ', -- Phantom wallet program id for trasnfer https://docs.phantom.app/resources/faq
'4MNPdKu9wFMvEeZBMt3Eipfs5ovVWTJb31pEXDJAAxX5' -- transfer token program
) -- exclude wormhole program id
group by 1, 2
)
select
CASE
when labeling = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K' then 'Magic Eden V2'
Run a query to Download Data