jfoMonthly Bridge Volume from Ethereum > Solana via Wormhole Per-Category Token
    Updated 2022-06-27
    with data_token_transfer as (
    select
    substring(input_data, 202, 1), tx_hash
    from
    ethereum.core.fact_transactions
    where
    to_address = '0x3ee18b2214aff97000d974cf647e7c347e8fa585'
    and
    origin_function_signature = '0x0f5287b0' -- tokenTransfer
    and
    status = 'SUCCESS'
    and
    substring(input_data, 202, 1)::string = '1' -- solana
    )
    , data_token as (
    select
    block_timestamp::date as date,
    sum(amount_usd) as total
    from
    ethereum.core.ez_token_transfers
    where
    tx_hash in (select tx_hash from data_token_transfer)
    and
    to_address = '0x3ee18b2214aff97000d974cf647e7c347e8fa585'
    group by 1
    )
    , eth_price as (
    select
    hour,
    price
    from
    ethereum.core.fact_hourly_token_prices
    where
    token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    )
    , data_eth as (
    Run a query to Download Data