Deebs-DeFi-j9fRbzLargest ATOM buy orders in last 7 days
Updated 2023-04-19
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 swaps AS (
SELECT
TO_CURRENCY AS taddress,
(TO_AMOUNT/POW(10, TO_DECIMAL)) AS amount1,
block_timestamp AS time,
TRADER,
POOL_IDS AS pool
from osmosis.core.fact_swaps
WHERE time > CURRENT_DATE - 7
AND taddress='ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2'
--OR FROM_CURRENCY='ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2'
AND TRADER NOT IN('osmo1mpxsmgcptzq676eqpst27ulm4ymuqedspjtzc3')
),
labels AS (
SELECT
CURRENCY AS taddress,
RECORDED_HOUR AS time,
SYMBOL AS bought_token,
PRICE
FROM osmosis.core.ez_prices
WHERE time > CURRENT_DATE - 7
)
SELECT
s.pool,
l.bought_token,
s.amount1 AS number_of_tokens,
l.PRICE,
s.amount1*l.PRICE AS buy_usd_value,
l.time,
s.TRADER,
s.taddress
FROM swaps s
LEFT JOIN labels l USING (taddress)
WHERE buy_usd_value>1
Run a query to Download Data