nat_nomadcompare dex trades 1
Updated 2023-04-18
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
›
⌄
WITH eth_swaps AS (
SELECT
TX_HASH,
AMOUNT_IN AS amount_in_eth,
AMOUNT_IN_USD AS amount_in_usd_eth,
AMOUNT_OUT AS amount_out_eth,
AMOUNT_OUT_USD AS amount_out_usd_eth
FROM ethereum.core.ez_dex_swaps
),
crosschain_swaps AS (
SELECT
TX_HASH,
AMOUNT_IN AS amount_in_crosschain,
AMOUNT_IN_USD AS amount_in_usd_crosschain,
AMOUNT_OUT AS amount_out_crosschain,
AMOUNT_OUT_USD AS amount_out_usd_crosschain
FROM crosschain.defi.ez_swaps
WHERE BLOCKCHAIN = 'Ethereum'
)
SELECT
eth_swaps.TX_HASH,
eth_swaps.amount_in_eth,
eth_swaps.amount_in_usd_eth,
eth_swaps.amount_out_eth,
eth_swaps.amount_out_usd_eth,
crosschain_swaps.amount_in_crosschain,
crosschain_swaps.amount_in_usd_crosschain,
crosschain_swaps.amount_out_crosschain,
crosschain_swaps.amount_out_usd_crosschain
FROM eth_swaps
JOIN crosschain_swaps ON eth_swaps.TX_HASH = crosschain_swaps.TX_HASH
WHERE eth_swaps.amount_in_eth <> crosschain_swaps.amount_in_crosschain
OR eth_swaps.amount_in_usd_eth <> crosschain_swaps.amount_in_usd_crosschain
OR eth_swaps.amount_out_eth <> crosschain_swaps.amount_out_crosschain
Run a query to Download Data