BlockTrackerswap 2
Updated 2024-06-11
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
›
⌄
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.ez_decoded_event_logs
where topics[0]::string = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'
and block_timestamp::date >= '2024-02-28'
and tx_status = 'SUCCESS'
limit 10
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.ez_decoded_event_logs
WHERE topics[0] = '0x0d3648bd0f6ba80134a33ba9275ac585d9d315f0ad8355cddefde31afa28d0e9'
and tx_status = 'SUCCESS'
QueryRunArchived: QueryRun has been archived