andreafiandroToken Life (single)
Updated 2024-01-08
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
›
⌄
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 = '9ZoH3ssTQBJNVidsLo49q3buDidreiZc9g3NeETP3F2s'
or swap_to_mint = '9ZoH3ssTQBJNVidsLo49q3buDidreiZc9g3NeETP3F2s'
ORDER BY
block_timestamp
QueryRunArchived: QueryRun has been archived