daniel_onchain$goat**
Updated 2024-10-18Copy Reference Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
count(DISTINCT tx_id) as swaps,
count(DISTINCT swapper) as swappers,
sum(CASE when SWAP_FROM_MINT = 'CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump' then SWAP_FROM_AMOUNT else SWAP_TO_AMOUNT end) as Goat_volume
FROM solana.defi.fact_swaps
WHERE SWAP_FROM_MINT = 'CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump'
OR SWAP_TO_MINT = 'CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump'
QueryRunArchived: QueryRun has been archived