LI.FILIFI
Updated 2025-01-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with txns as (
SELECT distinct tx_hash
FROM bsc.core.ez_decoded_event_logs
WHERE origin_to_address in ('0x82dc0ec7d058ab7053a75c8a35ea34705cf6788d', '0xb300000b72deaeb607a12d5f54773d1c19c7028d')
AND block_timestamp >= '2024-09-25'
AND origin_function_signature IN ('0x849ce572','0xb36532d8')
)
SELECT
from bsc.core.ez_decoded_event_logs
where tx_hash in (SELECT tx_hash from txns)
and event_name = 'LiFiGenericSwapCompleted'
GROUP BY 1
order by 2 desc
UNION
SELECT
from bsc.core.ez_decoded_event_logs
where tx_hash in (SELECT tx_hash from txns)
and event_name = 'LiFiTransferStarted'
GROUP BY 1
order by 2 desc
QueryRunArchived: QueryRun has been archived