takeabreath$RAY Buys vs Sells copy
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 $RAY Buys vs Sells @ https://flipsidecrypto.xyz/edit/queries/49342c80-86dc-4aca-a75e-2aedc83f07a4
-- forked from $SLND Buys vs Sells @ https://flipsidecrypto.xyz/edit/queries/a5102f01-8bc9-458d-9506-d1222a8aeb3d
-- 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 = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R'
THEN swaps.swap_from_amount * prices.close
ELSE NULL
END AS amount_out_usd,
CASE
WHEN swaps.swap_to_mint = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R'
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 = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R'
WHERE
(swaps.swap_from_mint = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' OR swaps.swap_to_mint = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R')
AND swaps.block_timestamp > DATE('2022-11-27')
AND swaps.succeeded = TRUE
),
other_swaps AS (
SELECT
Run a query to Download Data