andreafiandroToken Life (multi)
Updated 2024-01-14
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
›
⌄
-- forked from Token Life (single) @ https://flipsidecrypto.xyz/edit/queries/2749f230-b71e-407f-92a7-2eb2fe4f11b2
SELECT
block_timestamp,
swap_from_amount,
swap_from_mint,
swap_to_amount,
swap_to_mint,
CASE
WHEN SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112' THEN 'buy'
ELSE 'sell'
END AS side,
CASE
WHEN SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112' THEN SWAP_FROM_AMOUNT / SWAP_TO_AMOUNT
ELSE SWAP_TO_AMOUNT / SWAP_FROM_AMOUNT
END AS price
FROM
solana.defi.fact_swaps
WHERE
succeeded = TRUE
AND swap_from_mint in('g5a5repqymmrttvaanoqgaetk3tpwaj5bjhfxe8kjmkt','8tdzc9dqnv9qdp7jvdxpexhztms9uflebu7xmn85y9ck')
or swap_to_mint in ('g5a5repqymmrttvaanoqgaetk3tpwaj5bjhfxe8kjmkt','8tdzc9dqnv9qdp7jvdxpexhztms9uflebu7xmn85y9ck')
ORDER BY
block_timestamp
QueryRunArchived: QueryRun has been archived