Updated 2022-12-08
    --creator :: https://app.flipsidecrypto.com/velocity/queries/88e69da5-8f54-4c4f-8b71-fe44d5d7491f
    with Bri as (select
    BLOCK_TIMESTAMP::date as date,
    'Solana -> Ethereum' as type,
    substring(INPUT_DATA, 202, 1) as chain_id,
    symbol,
    count(DISTINCT tx_hash) as tx_cnt,
    count(DISTINCT from_address) as user_cnt,
    sum(amount_usd) as volume,
    sum(tx_cnt) over (order by date asc ) as cum_tx_cnt,
    sum(user_cnt) over (order by date asc) as cum_user_cnt,
    sum(volume) over (order by date asc) as cum_vol
    from ethereum.core.fact_transactions join ethereum.core.ez_token_transfers USING(tx_hash)
    where to_address in (lower('0x3ee18b2214aff97000d974cf647e7c347e8fa585'))
    and origin_function_signature = '0xc6878519'
    and chain_id = '1'
    and date >= '2022-10-01'
    group by 1,2,3,4),
    top_10 as (select *,
    row_number() over (partition by date order by tx_cnt desc) as Rank
    from Bri)
    select * from top_10
    where Rank <= 10
    Run a query to Download Data