flipside

    swap pair
    datavortexswap pair
    Updated 8 days ago
    WITH swap_events AS (
    SELECT
    tx_hash,
    origin_to_address AS pool_address,
    block_timestamp
    FROM
    ink.core.ez_decoded_event_logs
    WHERE
    event_name = 'Swap'
    AND origin_to_address = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
    AND block_timestamp IS NOT NULL
    AND tx_succeeded = TRUE
    ),
    token_transfers AS (
    SELECT
    tx_hash,
    contract_address,
    symbol,
    amount_usd
    FROM
    ink.core.ez_token_transfers
    ),
    transfers_with_index AS (
    SELECT
    tx_hash,
    contract_address,
    symbol,
    amount_usd,
    ROW_NUMBER() OVER (
    PARTITION BY tx_hash
    ORDER BY
    LOWER(symbol) ASC
    ) AS symbol_index
    FROM
    token_transfers
    ),
    Last run: 8 days ago
    PAIR
    TOTAL_DISTINCT_SWAPS
    TOTAL_VOLUME_USD
    1
    		PURPLE-WETH479812576115.28
    2
    		AK47-WETH422241154753.32
    3
    		IAGENT-WETH247661075898.96
    4
    		USD₮0-WETH105284912441.74
    5
    		SHROOMY-WETH22089638113.8
    6
    		PRL-WETH28698636132.34
    7
    		nsfi-WETH919459720.58
    8
    		MYST-WETH2646337950.92
    9
    		RCN-WETH5646334766.4
    10
    		CYPHER-WETH2113330257.62
    10
    308B
    5s