iam_lerikdominant-magenta
Updated 2024-10-01
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 * FROM
ethereum.defi.ez_dex_swaps
WHERE contract_address = LOWER('0x24B8c320A4505057cb1e4808D200535ec5320817')
LIMIT 10
-- WITH Pal_latest_Price AS (
-- SELECT
-- hour AS Hour,
-- Price
-- FROM
-- ethereum.price.ez_prices_hourly
-- WHERE
-- token_address = LOWER('0x13E4b8CfFe704d3De6F19E52b201d92c21EC18bD')
-- QUALIFY ROW_NUMBER() OVER (ORDER BY hour DESC) = 1
-- ),
-- WITH Pal_latest_Price AS (
-- SELECT
-- hour AS Hour,
-- Price
-- FROM
-- ethereum.price.ez_prices_hourly
-- WHERE
-- token_address = LOWER('0x13E4b8CfFe704d3De6F19E52b201d92c21EC18bD')
-- QUALIFY ROW_NUMBER() OVER (ORDER BY hour DESC) = 1
-- )
-- WITH amount_in (
-- SELECT
-- date_trunc('Hour', a.block_timestamp) AS hour_trunc
-- , a.tx_hash
-- , a.symbol_in
QueryRunArchived: QueryRun has been archived