BLOCK_NUMBER | BLOCK_TIMESTAMP | TX_HASH | TX_POSITION | EVENT_INDEX | CONTRACT_ADDRESS | TOPICS | TOPIC_0 | TOPIC_1 | TOPIC_2 | TOPIC_3 | DATA | EVENT_REMOVED | ORIGIN_FROM_ADDRESS | ORIGIN_TO_ADDRESS | ORIGIN_FUNCTION_SIGNATURE | TX_SUCCEEDED | FACT_EVENT_LOGS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 3136467 | 2025-02-07 23:07:17.000 | 0x19af037b7adce1ab60ac42a442830880e4c94eecfcda58abbf036a891936cd8d | 1 | 0 | 0xa6cb988942610f6731e664379d15ffcfbf282b44 | ["0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925","0... | 0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925 | 0x000000000000000000000000ee2d5d352725a0abc6f7cd05c23243aa61a4da4d | 0x000000000000000000000000aaaaaaaa82812f0a1f274016514ba2ca933bf24d | 0x0000000000000000000000000000000000000000000000000008b12346c77fce | FALSE | 0xee2d5d352725a0abc6f7cd05c23243aa61a4da4d | 0xa6cb988942610f6731e664379d15ffcfbf282b44 | 0x095ea7b3 | TRUE | 02ea369158ed0445fb3161f990905f74 | 2025-02-08 00:29:15.254 | 2025-02-08 00:29:15.254 |
Snipermultiple-aquamarine
Updated 2025-02-08
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
›
⌄
select
*
-- sum(TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') [0] :: STRING)):: STRING)/pow (10,18) AS toTokenFee_
-- sum(TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') [2] :: STRING)):: STRING) / pow(10,18) as fromAmount,
-- sum(TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') [3] :: STRING)):: STRING) / pow(10,18) as toAmount
-- count (DISTINCT a.tx_hash) as tx
-- regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data
-- -- ,CONCAT('0x', SUBSTR(topics [1] :: STRING, 10+17, 40)) AS sender
-- -- ,CONCAT('0x', SUBSTR(topics [2] :: STRING, 10+17, 40)) AS to_address
-- ,CONCAT('0x', SUBSTR(segmented_data [0] :: STRING, 10+15, 40)) AS fromToken
-- ,CONCAT('0x', SUBSTR(segmented_data [1] :: STRING, 10+15, 40)) AS toToken
-- ,TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [2] :: STRING)):: STRING AS fromAmount
-- ,TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [3] :: STRING)):: STRING AS toAmount
-- ,TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [4] :: STRING)):: STRING AS toTokenFee
-- ,TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [0] :: STRING)):: STRING AS toTokenFee_
-- from swell.core.fact_transactions a LEFT OUTER join swell.core.fact_event_logs b on a.tx_hash = b.tx_hash
from swell.core.fact_event_logs
-- 0x1a73d53dae51fbb95059733b6929befab03d5b989c6351ad2f9a6883d357b9e8
-- 0xb359b890445606432b803b895ade2b8903dcd2bb81fffaa14a407a563e8117ad
--0x1571699a7ea6a76b9945aeb73c6538108653a8a4030b6281cf53e5cc143288c9
--0x5687128b04a232018c7f454327772bb82bf1c8b7587171d8f8439e10fb5553da
where
tx_hash = '0x19af037b7adce1ab60ac42a442830880e4c94eecfcda58abbf036a891936cd8d'
-- and
-- CONTRACT_ADDRESS ='0xa6cb988942610f6731e664379d15ffcfbf282b44'
-- CONCAT('0x', SUBSTR(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') [1] :: STRING, 10+15, 40)) = null
-- and
-- a.to_address = '0xa6cb988942610f6731e664379d15ffcfbf282b44'
-- select
-- *
-- from
-- swell.core.dim_contracts
-- where
-- address = '0xa6cb988942610f6731e664379d15ffcfbf282b44'
Last run: 3 months ago
1
846B
1s