amelia-leeUntitled Query
    Updated 2022-08-11
    select
    SYMBOL as token,
    count(a.tx_hash) as no_txn,
    sum(AMOUNT_USD) as volume
    from ethereum.core.fact_transactions a join ethereum.core.ez_token_transfers b on a.tx_hash=b.tx_hash
    where substring(a.INPUT_DATA, 202, 1)='1'
    and a.ORIGIN_FUNCTION_SIGNATURE in ('0xc6878519') -- Solana to Ethereum
    and a.TO_ADDRESS='0x3ee18b2214aff97000d974cf647e7c347e8fa585'
    and a.STATUS='SUCCESS'
    and a.BLOCK_TIMESTAMP>=CURRENT_DATE-90
    group by 1 having volume is not null
    order by 2 desc limit 10

    --MLD_ZMN
    --second
    Run a query to Download Data