DAY | Daily trading volume | Cumulative trading volume | Unique traders | Trades | |
|---|---|---|---|---|---|
1 | 2024-12-08 00:00:00.000 | 33.524976831 | 1243380.55138387 | 2 | 2 |
2 | 2024-10-23 00:00:00.000 | 77.866768536 | 1243347.02640703 | 3 | 3 |
3 | 2024-10-22 00:00:00.000 | 46.576277067 | 1243269.1596385 | 8 | 9 |
4 | 2024-10-21 00:00:00.000 | 369.304049159 | 1243222.58336143 | 9 | 9 |
5 | 2024-10-20 00:00:00.000 | 4804.51783427 | 1242853.27931227 | 22 | 44 |
6 | 2024-10-19 00:00:00.000 | 953.597441163 | 1238048.761478 | 5 | 5 |
7 | 2024-10-18 00:00:00.000 | 1199.269041427 | 1237095.16403684 | 14 | 16 |
8 | 2024-10-17 00:00:00.000 | 663.344790927 | 1235895.89499541 | 11 | 12 |
9 | 2024-10-16 00:00:00.000 | 1124.667457578 | 1235232.55020449 | 11 | 12 |
10 | 2024-10-15 00:00:00.000 | 841.488697957 | 1234107.88274691 | 10 | 11 |
11 | 2024-10-14 00:00:00.000 | 207.863254928 | 1233266.39404895 | 5 | 6 |
12 | 2024-10-13 00:00:00.000 | 299.524474547 | 1233058.53079402 | 7 | 7 |
13 | 2024-10-12 00:00:00.000 | 289.827549753 | 1232759.00631948 | 7 | 7 |
14 | 2024-10-11 00:00:00.000 | 852.142529924 | 1232469.17876972 | 18 | 19 |
15 | 2024-10-10 00:00:00.000 | 356.553217287 | 1231617.0362398 | 10 | 10 |
16 | 2024-10-09 00:00:00.000 | 220.109923882 | 1231260.48302251 | 12 | 14 |
17 | 2024-10-08 00:00:00.000 | 640.943004482 | 1231040.37309863 | 20 | 26 |
18 | 2024-10-07 00:00:00.000 | 3479.504494769 | 1230399.43009415 | 35 | 39 |
19 | 2024-10-06 00:00:00.000 | 2696.256592813 | 1226919.92559938 | 48 | 53 |
20 | 2024-10-05 00:00:00.000 | 11976.323968734 | 1224223.66900657 | 60 | 68 |
MLDZMN$GREED trading
Updated 2025-01-28
999
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 Thruster_V2 as (
with pool_created as (
select
contract_address,
REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}') as segmented_data,
lower('0x' || substr(topics[1]::string, 27, 40) :: string) as token0,
lower('0x' || substr(topics[2]::string, 27, 40) :: string) as token1,
lower('0x' || substr(segmented_data[0]::string, 25, 40 ) :: string) as pool_address
from blast.core.fact_event_logs
WHERE topics[0] = '0x0d3648bd0f6ba80134a33ba9275ac585d9d315f0ad8355cddefde31afa28d0e9'
and tx_status = 'SUCCESS'
and contract_address IN ('0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13', '0x37836821a2c03c171fb1a595767f4a16e2b93fc4') -- ThrusterFactory V2
)
,
swap as (
select
block_timestamp,
block_number,
origin_from_address,
origin_to_address,
ORIGIN_FUNCTION_SIGNATURE,
tx_hash,
event_index,
contract_address,
lower('0x' || substr(topics[1]::string, 27, 40) :: string) as sender, -- thruster - v2 (0.3% - 1%)
lower('0x' || substr(topics[2]::string, 27, 40) :: string) as address_to,
REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}') as segmented_data,
livequery.utils.udf_hex_to_int(segmented_data[0]::string) :: int as amount0In,
livequery.utils.udf_hex_to_int(segmented_data[1]::string) :: int as amount1In,
livequery.utils.udf_hex_to_int(segmented_data[2]::string) :: int as amount0Out,
livequery.utils.udf_hex_to_int(segmented_data[3]::string) :: int as amount1Out
from blast.core.fact_event_logs
where topics[0]::string = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'
and block_timestamp::date >= '2024-02-28'
and tx_status = 'SUCCESS'
Last run: about 1 month agoAuto-refreshes every 12 hours
...
136
9KB
144s