KaskoazulUntitled Query
Updated 2022-04-17
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 A as (
select ft.tx_id,
ft.amount,
ft.tx_from,
ft.tx_to,
fe.event_type,
fe.program_id,
fe.instruction
from solana.fact_transactions ft
inner join solana.dim_labels fe
on ft.tx_id = fe.tx_id
where mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'
)
select *
from A
select *
from solana.dim_labels
where address_name like '%Stable%' = 'SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ'
--label in ('saber')--'jupiter', 'solend', 'raydium', 'parrot', 'mercurial', 'saber', 'atrix', 'mango%', 'marinade', 'serum')
select *
from solana.fact_transactions
where tx_id in ('2oZMN23yvPusE821TRmFy3xzi5XT2uvX66FLMvwcYh89zMxC9sQiE8jyiX8WfxEjLsmCAyig4XuKmksCtv4KcoZL', '3tcnpFeXJ2nBMAVHfRqQxhuW7XYBGWERPQ8QcXum3AmVpAfuzwn6kjtkpT8BFJEcZwBrNFqy45YUGVQFj3166pkL')
('641ydSgkhRQPsDuSjrx8GqhqdqksBfC4su1Hzi9vx2H4Cv779fnNBAef8TLHFJtEYZ3YxuJuttVfVfYpPSsShTPG', '4hSL6cDMUMXa6S4ZrFUdk19MiqcTHxezASHzVJSAFqfAQjJARHYQLtZn4SRWtJUK9j2xasTCMDsaDra77exs5ZU7',
'EK1FYQmathD33o677Mh21fpTk9D6LWLzjb4V2GSWYkta6UaBfgTgv1wbrxey2A55DKefCQhXeDVkHpbHY7VmY7j')
select *
from solana.
where tx_to = '6YjT74rmcfCpw8LSjPNx5JTmZoYLGrTKnf9arfSgZ4SR'
Run a query to Download Data