samUntitled Query
Updated 2022-09-23Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
distinct l.label as swap_from_mint_label
-- distinct l.address_name as swap_from_mint_label_address
from solana.core.fact_swaps s
left join solana.core.dim_labels l on s.swap_from_mint = l.address
where block_timestamp >= '2022-09-01'
and swap_program = 'orca'
limit 100
select
distinct swap_program
from solana.core.fact_swaps
Run a query to Download Data