SpecterBladeswap summary
Updated 2024-06-22
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
›
⌄
WITH Bladeswap AS (
SELECT Block_timestamp, tx_hash,
-- origin_from_address,
-- origin_to_address,
contract_address,
-- topics,
DECODED_LOG --[0] AS Topics
FROM blast.core.fact_decoded_event_logs
WHERE contract_address = lower('0x10F6b147D51f7578F760065DF7f174c3bc95382c')
--AND tx_status = 'SUCCESS'
--AND origin_from_address = lower('0x992C7F4bDdcEE56a6e4bB6b0727116DFC909d79F')
ORDER BY Block_timestamp desc
LIMIT 20;)
cte_notcoin AS (
SELECT
value[0]:"name"::STRING AS Name,
value[0]:"symbol"::STRING AS Symbol,
value[0]:"quote":"USD":"price"::FLOAT AS price,
'NOTCOIN'::STRING AS source_table
FROM NOTCOIN,
LATERAL FLATTEN(input => resp:data:data) AS flattened_data
)
QueryRunArchived: QueryRun has been archived