takeabreath$SLND Buys vs Sells
Updated 2024-04-03
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
›
⌄
-- forked from $SLND Volume, Trade Count, Avg Trade Size, Turnover Rate @ https://flipsidecrypto.xyz/edit/queries/d1e9d4f1-e4f8-481b-93d1-8bea6420ddb9
-- forked from Solend Prices @ https://flipsidecrypto.xyz/edit/queries/fd354036-93ee-411a-838b-fb465f098270
WITH slnd_swaps AS (
SELECT
swaps.block_timestamp,
swaps.tx_id,
prices.close,
CASE
WHEN swaps.swap_from_mint = 'SLNDpmoWTVADgEdndyvWzroNL7zSi1dF9PC3xHGtPwp'
THEN swaps.swap_from_amount * prices.close
ELSE NULL
END AS amount_out_usd,
CASE
WHEN swaps.swap_to_mint = 'SLNDpmoWTVADgEdndyvWzroNL7zSi1dF9PC3xHGtPwp'
THEN swaps.swap_to_amount * prices.close
ELSE NULL
END AS amount_in_usd
FROM solana.defi.fact_swaps AS swaps
LEFT JOIN solana.price.ez_token_prices_hourly AS prices
ON DATE_TRUNC('hour', swaps.block_timestamp) = prices.recorded_hour
AND prices.token_address = 'SLNDpmoWTVADgEdndyvWzroNL7zSi1dF9PC3xHGtPwp'
WHERE
(swaps.swap_from_mint = 'SLNDpmoWTVADgEdndyvWzroNL7zSi1dF9PC3xHGtPwp' OR swaps.swap_to_mint = 'SLNDpmoWTVADgEdndyvWzroNL7zSi1dF9PC3xHGtPwp')
AND swaps.block_timestamp > DATE('2022-11-27')
AND swaps.succeeded = TRUE
),
other_swaps AS (
SELECT
swaps.block_timestamp,
swaps.tx_id,
prices.close,
CASE
QueryRunArchived: QueryRun has been archived