superflyUntitled Query
Updated 2023-02-05
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
›
⌄
WITH swaps AS (
SELECT
TO_CURRENCY AS taddress,
(TO_AMOUNT/POW(10, TO_DECIMAL)) AS amount,
block_timestamp AS time,
TRADER
from osmosis.core.fact_swaps
WHERE time BETWEEN '2023-01-01' AND '2023-01-30'
HAVING amount > 4000
),
labels AS (
SELECT
CURRENCY AS taddress,
RECORDED_HOUR AS time,
SYMBOL,
PRICE
FROM osmosis.core.ez_prices
WHERE time BETWEEN '2023-01-01' AND '2023-01-30'
)
SELECT
l.SYMBOL,
s.amount AS number_of_tokens,
l.PRICE,
s.amount*l.PRICE AS usd_value,
l.time,
s.TRADER,
s.taddress
FROM swaps s
LEFT JOIN labels l USING (taddress)
WHERE usd_value>500
ORDER BY 4 DESC
LIMIT 100;
Run a query to Download Data