greyswanOrca_test
Updated 2023-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
solana.core.dim_nft_metadataSELECT
address_name AS swapped_to_token,
COUNT(tx_id) AS count_tx_id
FROM solana.core.fact_swaps a
LEFT JOIN solana.core.dim_labels b
ON a.swap_to_mint = b.address
WHERE swap_from_mint = 'So11111111111111111111111111111111111111112'
AND succeeded = 'TRUE'
AND swap_program ilike 'orca%'
AND block_timestamp >= current_date - 30
GROUP BY swapped_to_token
ORDER BY count_tx_id DESC
LIMIT 3
Run a query to Download Data