RayyykTransaction count and percentage of assets being bridged from Ethereum to Solana over time via Wormhole
    Updated 2022-06-16
    with table_1 as (select date(block_timestamp) as day,
    inner_instruction:instructions[3]:parsed:info:mint as address,
    count(distinct(tx_id)) as tx_count
    from solana.core.fact_events
    where program_id = 'wormDTUJ6AWPNvk59vGQbDvGJmqbDTdgWgAqcLBCgUb'
    group by 1,2),

    table_2 as (select day,
    address_name,
    tx_count
    from table_1 g
    left join solana.core.dim_labels h on g.address = h.address
    where address_name is not null)

    select day,
    address_name,
    tx_count
    from table_2
    where address_name not ilike '%tether%'
    and (address_name ilike '%eth%'
    or address_name in ('celsius (wormhole)', 'dai stablecoin (wormhole)','wormhole-wrapped lido dao token', 'frax (wormhole)', 'sushitoken (wormhole)'))
    order by 1
    Run a query to Download Data