mo115magpie
Updated 2024-04-24
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
›
⌄
select
'Arbitrum' as network
, sum(AMOUNT_USD)as total_USD
,count(distinct TX_HASH) as txs
, count(distinct FROM_ADDRESS) as wallets
from arbitrum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS = '0xcf32c5bb41f7a302298a2d2072155800871baad3'
and TO_ADDRESS = '0xe8eda9dfedb228aa0cfd2c2f809a4418d0319eb2'
and BLOCK_TIMESTAMP >= '2024-04-22'
union
select
'Polygon' as network
, sum(AMOUNT_USD)as total_USD
,count(distinct TX_HASH) as txs
, count(distinct FROM_ADDRESS) as wallets
from polygon.core.ez_token_transfers
where ORIGIN_TO_ADDRESS = '0xcf32c5bb41f7a302298a2d2072155800871baad3'
and TO_ADDRESS = '0xe8eda9dfedb228aa0cfd2c2f809a4418d0319eb2'
and BLOCK_TIMESTAMP >= '2024-04-22'
union
select
'Optimism' as network
, sum(AMOUNT_USD)as total_USD
,count(distinct TX_HASH) as txs
, count(distinct FROM_ADDRESS) as wallets
from optimism.core.ez_token_transfers
where ORIGIN_TO_ADDRESS = '0xcf32c5bb41f7a302298a2d2072155800871baad3'
and TO_ADDRESS = '0xe8eda9dfedb228aa0cfd2c2f809a4418d0319eb2'
and BLOCK_TIMESTAMP >= '2024-04-22'
union
QueryRunArchived: QueryRun has been archived