krom1ME S1 All Txs
Updated 2025-04-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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH price AS (
SELECT
price
FROM
solana.price.ez_prices_hourly
WHERE
token_address = 'So11111111111111111111111111111111111111112'
ORDER BY
hour DESC
LIMIT 1
),
nft AS (
SELECT
mint,
nft_collection_name
FROM
solana.nft.dim_nft_metadata
)
SELECT
block_timestamp AS date,
tx_id,
CASE
WHEN seller = '{{wallet}}' THEN 'Sell'
WHEN purchaser = '{{wallet}}' THEN 'Buy'
END AS action,
COALESCE(nft.nft_collection_name, f.mint) AS Collection,
sales_amount,
sales_amount * p.price AS usd_value
FROM
solana.nft.fact_nft_sales f
JOIN
price p
JOIN
nft
Last run: about 2 months ago
...
113
19KB
9s