eferEthereum - Swaps
Updated 2023-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- 1M (1 month), 2M (2 months), 3M (3 months)
WITH variables AS (
SELECT
CASE
WHEN '{{Time_range}}'='1M (1 month)' THEN '30'
WHEN '{{Time_range}}'='2M (2 months)' THEN '60'
WHEN '{{Time_range}}'='3M (3 months)' THEN '90'
ELSE '0'
END AS range
), SWAPS AS (
SELECT
TX_HASH
FROM
ethereum.sushi.ez_swaps
)
SELECT DISTINCT(STATUS) FROM ethereum.core.fact_transactions
-- WHERE TX_HASH in (SELECT * FROM SWAPS)
Run a query to Download Data