amelia-leeUntitled Query
Updated 2022-08-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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