Abolfazl_771025Untitled Query
Updated 2023-02-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with main as (
select
DISTINCT a.tx_hash,
a.block_timestamp,
a.origin_from_address as sender,
'Arbitrum' as from_chain,
avg(a.RAW_AMOUNT/power(10, 6)) as volume
from arbitrum.core.fact_token_transfers a join arbitrum.core.fact_event_logs b on a.tx_hash=b.tx_hash
where b.contract_address LIKE lower('0xe432150cce91c13a887f7D836923d5597adD8E31')
group by 1,2,3,4
union
select
DISTINCT a.tx_hash,
a.block_timestamp,
a.origin_from_address as sender,
'Polygon' as from_chain,
avg(a.RAW_AMOUNT/power(10, 6)) as volume
from polygon.core.fact_token_transfers a join polygon.core.fact_event_logs b on a.tx_hash=b.tx_hash
where b.contract_address LIKE lower('0x6f015F16De9fC8791b234eF68D486d2bF203FBA8')
and EVENT_NAME like null
group by 1,2,3,4
union
select
DISTINCT a.tx_hash,
a.block_timestamp,
a.origin_from_address as sender,
'Binance smart chain' as from_chain,
avg(a.RAW_AMOUNT/power(10, 6)) as volume
from bsc.core.fact_token_transfers a join bsc.core.fact_event_logs b on a.tx_hash=b.tx_hash
where b.contract_address LIKE lower('0x304acf330bbE08d1e512eefaa92F6a57871fD895')
and EVENT_NAME like null
group by 1,2,3,4
union
select
DISTINCT a.tx_hash,
a.block_timestamp,
Run a query to Download Data