DATE | BLOCKCHAIN | Volume(USD) | # of Trades | |
|---|---|---|---|---|
1 | 2024-07-14 00:00:00.000 | Blast | 199493.723491656 | 105 |
2 | 2024-12-07 00:00:00.000 | Blast | 176.37293285 | 7 |
3 | 2024-03-03 00:00:00.000 | Blast | 50508.049216607 | 156 |
4 | 2024-04-16 00:00:00.000 | Blast | 3898296.60418715 | 1723 |
5 | 2024-04-19 00:00:00.000 | Blast | 4394523.84067782 | 3473 |
6 | 2024-05-14 00:00:00.000 | Blast | 3542816.5338589 | 1416 |
7 | 2024-05-21 00:00:00.000 | Blast | 1567622.61403723 | 1075 |
8 | 2024-06-13 00:00:00.000 | Blast | 808273.925567788 | 464 |
9 | 2024-03-13 00:00:00.000 | Blast | 72628.426829001 | 51 |
10 | 2024-09-23 00:00:00.000 | Blast | 5.995920613 | 26 |
11 | 2025-01-04 00:00:00.000 | Arbitrum | 10394.6024 | 1 |
12 | 2024-12-01 00:00:00.000 | Arbitrum | 15624.951790923 | 7 |
13 | 2024-11-05 00:00:00.000 | Blast | 13.992219276 | 1 |
14 | 2024-11-14 00:00:00.000 | Arbitrum | 741.485234858 | 3 |
15 | 2024-12-16 00:00:00.000 | Arbitrum | 21689.303149626 | 6 |
16 | 2024-09-25 00:00:00.000 | Arbitrum | 23.10895 | 2 |
17 | 2024-08-08 00:00:00.000 | Arbitrum | 12.341540501 | 3 |
18 | 2024-09-19 00:00:00.000 | Arbitrum | 415.943501263 | 3 |
19 | 2025-01-18 00:00:00.000 | Arbitrum | 555.409089062 | 2 |
20 | 2024-10-24 00:00:00.000 | Blast | 4.710695474 | 1 |
rezarwzbasic volume and trade transaction copy
Updated 2025-04-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 all_trades as (
select
'Blast' as blockchain,
tr1.tx_hash,
lo.block_timestamp,
tr1.symbol as in_token,
tr2.symbol as out_token,
tr1.AMOUNT_USD as amount_in,
tr2.AMOUNT_USD as amount_out,
lo.decoded_log:taker as taker,
CASE
when amount_in is not null then amount_in
else amount_out
end as volume_usd,
CASE
WHEN in_token < out_token THEN in_token || '-' || out_token
ELSE out_token || '-' || in_token
END AS Pairs_trade
from
Blast.core.ez_decoded_event_logs lo
left join Blast.core.ez_token_transfers tr1 on lo.tx_hash = tr1.tx_hash
left join Blast.core.ez_token_transfers tr2 on tr1.tx_hash = tr2.tx_hash
where
lo.contract_address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'
and lo.event_name = 'OrderComplete'
and tr1.from_Address = tr1.origin_from_address
and tr1.to_Address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'
and tr2.from_Address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'
and tr2.to_Address = tr2.origin_from_address
union all
select
'Arbitrum' as blockchain,
tr1.tx_hash,
lo.block_timestamp,
tr1.symbol as in_token,
tr2.symbol as out_token,
Last run: 15 days agoAuto-refreshes every 24 hours
...
281
15KB
335s