flipside

    Daily Volume Per Platform swap copy
    hessDaily Volume Per Platform swap copy
    Updated 2024-06-24
    with transfer_carbon as ( select block_timestamp,
    tx_hash,
    origin_from_address,
    TX_POSITION as EVENT_INDEX,
    'WSEI' as contract_address,
    from_address,
    to_address,
    'WSEI' as symbol,
    AMOUNT_PRECISE as amount
    from sei.core_evm.ez_native_transfers
    UNION all
    select block_timestamp,
    tx_hash,
    origin_from_address,
    EVENT_INDEX,
    contract_address,
    from_address,
    to_address,
    symbol,
    amount
    from sei.core_evm.ez_token_transfers)
    ,
    base_carbon as ( select block_timestamp,
    tx_hash,
    origin_from_address::string as swapper,
    contract_address,
    symbol,
    amount,
    to_address,
    event_index,
    from_address
    from transfer_carbon
    where tx_hash in (select tx_hash
    from sei.core_evm.fact_event_logs
    where topics[0]::string = '0x76af224a143865a50b41496e1a73622698692c565c1214bc862f18e22d829c5e'
    )
    QueryRunArchived: QueryRun has been archived