greyswanOrca_test
    Updated 2023-01-30
    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