sinahosseinzadehUntitled Query
Updated 2022-08-06
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
›
⌄
select 'L1 to L2' as type,
t1.block_timestamp::date as date,
count (distinct t1.tx_hash) as TX_Count,
count (distinct t1.origin_from_address) as Bridgers,
sum (amount) as Volume,
sum (volume) over (order by date) as Cumulative_Volume
From ethereum.core.ez_eth_transfers t1
where (t1.ORIGIN_TO_ADDRESS = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' or t1.ORIGIN_TO_ADDRESS = '0x52ec2f3d7c5977a8e558c8d9c6000b615098e8fc')
and t1.block_timestamp >= '2022-07-01' and t1.block_timestamp < '2022-08-01'
group by 1,2
UNION
select 'L2 to L1' as type,
t1.block_timestamp::date as date,
count (distinct t1.tx_hash) as TX_Count,
count (distinct t1.origin_from_address) as Bridgers,
sum (amount) as Volume,
sum (volume) over (order by date) as Cumulative_Volume
From ethereum.core.ez_token_transfers t1
where t1.ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
and t1.block_timestamp >= '2022-07-01' and t1.block_timestamp < '2022-08-01'
group by 1,2
order by 2
Run a query to Download Data