DAY | TRANSACTIONS | SELLER | BUYER | ETH_VALUE | QUANTITY | MAX_SELL_PRICE | MIN_SELL_PRICE | |
|---|---|---|---|---|---|---|---|---|
1 | 2025-02-15 00:00:00.000 | 33 | 24 | 22 | 306.95 | 33 | 9.85 | 9 |
2 | 2025-02-14 00:00:00.000 | 105 | 75 | 54 | 952.505878 | 105 | 10.899 | 7.95 |
3 | 2025-02-13 00:00:00.000 | 53 | 42 | 24 | 415.826959 | 53 | 8.3 | 7.33 |
4 | 2025-02-12 00:00:00.000 | 20 | 14 | 16 | 157.8039 | 20 | 8.3 | 7.35 |
5 | 2025-02-09 00:00:00.000 | 24 | 9 | 17 | 151.385 | 24 | 7.195 | 5.32 |
6 | 2025-02-10 00:00:00.000 | 26 | 24 | 17 | 179.1978 | 26 | 7.5 | 5.85 |
7 | 2025-02-08 00:00:00.000 | 9 | 8 | 7 | 64.097999 | 9 | 7.329999 | 6.78 |
8 | 2025-02-07 00:00:00.000 | 15 | 13 | 12 | 107.443981 | 15 | 7.32 | 6.86 |
9 | 2025-02-04 00:00:00.000 | 15 | 14 | 14 | 92.42698 | 15 | 6.79 | 5.71 |
10 | 2025-02-06 00:00:00.000 | 14 | 12 | 12 | 95.07099299 | 14 | 6.968998 | 6.42 |
11 | 2025-02-02 00:00:00.000 | 30 | 26 | 24 | 158.706 | 30 | 5.99 | 4.75 |
12 | 2025-02-01 00:00:00.000 | 15 | 11 | 13 | 93.48 | 15 | 6.69 | 5.25 |
13 | 2025-01-30 00:00:00.000 | 5 | 5 | 3 | 34.011999 | 5 | 7.046 | 6.44 |
14 | 2025-01-28 00:00:00.000 | 5 | 5 | 4 | 33.9669 | 5 | 7.2569 | 6.67 |
15 | 2025-01-22 00:00:00.000 | 47 | 36 | 27 | 357.757969 | 47 | 9.79 | 5.1 |
16 | 2025-01-05 00:00:00.000 | 11 | 10 | 7 | 43.577098 | 11 | 4.086 | 3.75 |
17 | 2025-01-24 00:00:00.000 | 15 | 13 | 13 | 127.559997 | 15 | 8.8 | 8.2 |
18 | 2025-01-19 00:00:00.000 | 17 | 15 | 12 | 106.57899199 | 17 | 6.998994 | 5.74 |
19 | 2025-01-03 00:00:00.000 | 15 | 14 | 10 | 55.572488 | 15 | 4.198 | 0.0015 |
20 | 2025-01-26 00:00:00.000 | 3 | 3 | 3 | 23.05 | 3 | 7.85 | 7.6 |
freemartianDaily Trade
Updated 8 days ago
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 sapes_api as (
SELECT livequery.live.udf_api(
'https://raw.githubusercontent.com/mehdimarjan/Opensea/refs/heads/main/sale.json'
) AS response
),
datas AS(
SELECT
to_timestamp(value:closing_date) AS block_timestamp,
value:transaction AS tx_hash,
value:event_type AS event,
value:protocol_address AS protocol_address,
value:nft:identifier AS identifier,
value:nft:collection AS collection,
value:chain AS chain,
value:buyer AS buyer,
value:seller AS seller,
(value:payment:quantity) / pow(10,18) AS price,
-- ROUND(((value:payment:quantity) / pow(10,18)),8) AS price,
value:quantity AS qty
FROM sapes_api, LATERAL FLATTEN (input => response:data)
where event = 'sale'
GROUP BY ALL
ORDER BY 1 DESC
)
SELECT
block_timestamp::date AS day,
count(tx_hash) AS transactions,
count(DISTINCT seller) AS seller,
count(DISTINCT buyer) AS buyer,
SUM(price) AS eth_value,
SUM(qty) AS quantity,
max(price) AS max_sell_price,
min(price) AS min_sell_price,
FROM datas
Last run: 8 days agoAuto-refreshes every 1 hour
57
3KB
367s