flipside

    handicapped-fuchsia
    datavortexhandicapped-fuchsia
    Updated 2025-03-06
    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
    ),

    amounts_with_index AS (
    Last run: 2 months ago
    SYMBOL
    TOTAL_DISTINCT_SWAPS
    TOTAL_VOLUME_USD
    1
    		PURPLE370572445088.62
    2
    		AK47330861154180.3
    3
    		IAGENT190021083836.34
    4
    		PRL23618626499.56
    5
    		SHROOMY15751555172.32
    6
    		USD₮045893541273.62
    7
    		nsfi791471136.82
    8
    		CYPHER1754348009.44
    9
    		MYST2190347723.5
    10
    		RCN4386331087.4
    10
    256B
    2s