mz0111HOP BRIDGE
Updated 2022-10-03
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
›
⌄
--credit to HBD
SELECT
"Date",
"Period",
sum("Daily Number of bridge") as "bridge count",
sum("Daily Amount Bridged") as "bridge volume",
sum("Daily Amount Bridged (USD Scale)") as "USD bridge volume"
FROM
((select
block_timestamp::date as "Date",
case
when block_number < '15537351' then 'Pre-Merge'
when block_number >= '15537351' then 'Post-Merge' end as "Period",
count(distinct TX_HASH) as "Daily Number of bridge",
sum(amount) as "Daily Amount Bridged",
sum(amount_usd) as "Daily Amount Bridged (USD Scale)"
from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS in (
'0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2',
'0x3e4a3a4796d16c0cd582c382691998f7c06420b6',
'0x3666f603cc164936c1b87e207f36beba4ac5f18a',
'0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1')
and block_Timestamp >= CURRENT_DATE - 36
group by 1 , 2
order by 1)
union all
(select
block_timestamp::date as "Date",
case
when block_number < '15537351' then 'Pre-Merge'
when block_number >= '15537351' then 'Post-Merge' end as "Period",
count(distinct TX_HASH) as "Daily Number of bridge",
sum(amount) as "Daily Amount Bridged",
sum(amount_usd) as "Daily Amount Bridged (USD Scale)"
Run a query to Download Data