DATE | SOURCE_CHAIN | RECEIVERS | AMOUNT | AMOUNT_USD | |
|---|---|---|---|---|---|
1 | 2025-02-01 00:00:00.000 | Ethereum | 27 | 640.175029467 | 1921674.03150752 |
2 | 2025-05-01 00:00:00.000 | Linea | 1 | 0.0069 | 18.152943344 |
3 | 2025-01-01 00:00:00.000 | Optimism | 913 | 177.262122073 | 601024.620560049 |
4 | 2025-01-01 00:00:00.000 | BSC | 60 | 7.018881728 | 24138.38358085 |
5 | 2025-01-01 00:00:00.000 | Sei | 70 | 21.396779584 | 72634.678929181 |
6 | 2024-12-01 00:00:00.000 | Ethereum | 76 | 1650.964329357 | 5956025.61224948 |
7 | 2024-12-01 00:00:00.000 | Zircuit | 26 | 859.218666721 | 3682151.37961706 |
8 | 2025-03-01 00:00:00.000 | Optimism | 44 | 6.187182321 | 12942.580199145 |
9 | 2024-12-01 00:00:00.000 | B2 Network | 125 | 600.064396296 | 59178809.943055 |
10 | 2025-03-01 00:00:00.000 | Other | 193 | 31.046760741 | 66264.342075788 |
11 | 2025-03-01 00:00:00.000 | Zircuit | 25 | 3.297729233 | 6687.77237343 |
12 | 2024-12-01 00:00:00.000 | Linea | 86 | 390.006574945 | 1372978.3863895 |
13 | 2025-01-01 00:00:00.000 | Blast | 61 | 14.574196537 | 48810.14539328 |
14 | 2025-04-01 00:00:00.000 | Arbitrum | 10 | 5.455315559 | 9528.283029313 |
15 | 2025-05-01 00:00:00.000 | Sei | 1 | 0.0171 | 44.587054781 |
16 | 2025-01-01 00:00:00.000 | Other | 262 | 20.808653829 | 83983.666038042 |
17 | 2025-03-01 00:00:00.000 | Arbitrum | 42 | 16.074891298 | 32121.099238088 |
18 | 2025-05-01 00:00:00.000 | Mode | 1 | 12.563401605 | 33998.08413019 |
19 | 2024-12-01 00:00:00.000 | Mode | 49 | 484.545819249 | 1690825.74899725 |
20 | 2025-01-01 00:00:00.000 | B2 Network | 497 | 50.210705121 | 4725576.82745372 |
Sbhn_NPvisible-emerald
Updated 2025-05-19
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
›
⌄
with price as (
select hour::date as datee,
symbol,
avg(price) as usdprice
from crosschain.price.ez_prices_hourly
where symbol in ('UBTC','EZETH','PZETH')
group by 1,2
)
select date_trunc('month',block_timestamp) as date,
case when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '223' then 'B2 Network'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '1' then 'Ethereum'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '48900' then 'Zircuit'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '42161' then 'Arbitrum'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '34443' then 'Mode'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '59144' then 'Linea'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '10' then 'Optimism'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '8453' then 'Base'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '81457' then 'Blast'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '1329' then 'Sei'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '56' then 'BSC'
else 'Other' end as source_chain,
count(distinct concat('0x', right(topic_2,40))) as receivers,
sum(ethereum.public.udf_hex_to_int(substr(data,3,len(data))) / pow(10,18)) as amount,
sum((ethereum.public.udf_hex_to_int(substr(data,3,len(data))) / pow(10,18))*usdprice) as amount_usd
from swell.core.fact_event_logs
join price on block_timestamp::date =datee and symbol=case when contract_address = '0xa166219df110bda97b91e65d4bb4aae4159978b9' then 'EZETH'
when contract_address = '0x982abbb04f91acc47ad0cb0a11f29d50c5007934' then 'PZETH'
when contract_address = '0xfa3198ecf05303a6d96e57a45e6c815055d255b1' then 'UBTC' end
where topic_0 = '0xba20947a325f450d232530e5f5fce293e7963499d5309a07cee84a269f2f15a6'
and contract_address in ('0xfa3198ecf05303a6d96e57a45e6c815055d255b1','0x982abbb04f91acc47ad0cb0a11f29d50c5007934','0xa166219df110bda97b91e65d4bb4aae4159978b9')
and origin_to_address = '0x3a464f746d23ab22155710f44db16dca53e0775e'
group by 1,2
Last run: 26 days ago
70
5KB
24s