lanoKaiaswap Monthly Volume
Updated 2024-11-08
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 kkulp_klay as (
select
block_timestamp,
tx_hash,
ORIGIN_FROM_ADDRESS,
ethereum.public.udf_hex_to_int('s2c', segmented[0]::string)::int as direction,
-- ethereum.public.udf_hex_to_int('s2c', segmented[1]::string)::int/1e18 as amountX,
ethereum.public.udf_hex_to_int('s2c', segmented[2]::string)::int/1e18 as amount
from (
select
block_timestamp,
tx_hash,
ORIGIN_FROM_ADDRESS,
regexp_substr_all(SUBSTR(data, 3, len(data)), '.{64}') AS segmented,
FROM kaia.core.fact_event_logs
WHERE topics[0] = '0x0fe977d619f8172f7fdbe8bb8928ef80952817d96936509f67d66346bc4cd10f'
and contract_address = '0xd37243e3ee3064046380c57e1073cde53761369a'
and tx_succeeded = 'TRUE'
)
),
klay_usdt as (
select
block_timestamp,
tx_hash,
ORIGIN_FROM_ADDRESS,
ethereum.public.udf_hex_to_int('s2c', segmented[0]::string)::int as direction,
ethereum.public.udf_hex_to_int('s2c', segmented[1]::string)::int/1e18 as amount
-- ethereum.public.udf_hex_to_int('s2c', segmented[2]::string)::int/1e18 as amount
from (
select
block_timestamp,
tx_hash,
ORIGIN_FROM_ADDRESS,
regexp_substr_all(SUBSTR(data, 3, len(data)), '.{64}') AS segmented,
FROM kaia.core.fact_event_logs
QueryRunArchived: QueryRun has been archived