TIME | TRANSACTIONS | OFFER_MAKERS | OFFER_AMOUNT | |
|---|---|---|---|---|
1 | 2025-01-02 00:00:00.000 | 1244 | 16 | 4106.8051 |
2 | 2025-01-01 00:00:00.000 | 21 | 16 | 53.8292 |
3 | 2024-12-31 00:00:00.000 | 49 | 8 | 157.9384 |
4 | 2024-12-30 00:00:00.000 | 20 | 9 | 62.4556 |
5 | 2024-12-29 00:00:00.000 | 216 | 10 | 873.0819 |
freemartianDaily Offer
Updated 2025-01-03
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 listing_api as (
SELECT livequery.live.udf_api(
'https://raw.githubusercontent.com/mehdimarjan/Opensea/refs/heads/main/listing.json'
) AS response
),
offer_api as (
SELECT livequery.live.udf_api(
'https://raw.githubusercontent.com/mehdimarjan/Opensea/refs/heads/main/offer.json'
) AS response
),
offer_data AS(
SELECT
to_timestamp(value:event_timestamp) AS offer_time,
value:order_hash AS order_hash,
to_timestamp(value:start_date) AS start_date,
to_timestamp(value:expiration_date) AS expiration_date,
value:maker AS maker,
value:order_type as type,
value:payment:quantity/pow(10,18) AS offer_amount,
FROM offer_api, LATERAL FLATTEN (input => response:data)
GROUP BY ALL
ORDER BY 1 DESC
)
SELECT
offer_time::date AS time,
count(order_hash) AS transactions,
count(DISTINCT maker) AS offer_makers,
SUM(offer_amount) AS offer_amount
FROM offer_data
group BY 1
Last run: 3 months ago
5
216B
2s