HOUR | NFT_SALES_VOLUME | |
|---|---|---|
1 | 2023-08-12 20:00:00.000 | 0.0249 |
2 | 2023-08-18 02:00:00.000 | 0.0074 |
3 | 2023-09-29 16:00:00.000 | 0.0032 |
4 | 2023-09-06 14:00:00.000 | 0.0052 |
5 | 2023-08-18 14:00:00.000 | 0.0442 |
6 | 2023-09-17 20:00:00.000 | 0.0012 |
7 | 2023-08-19 21:00:00.000 | 0.0511 |
8 | 2023-08-18 08:00:00.000 | 0.0157 |
9 | 2023-08-19 09:00:00.000 | 0.0003 |
10 | 2023-08-08 12:00:00.000 | 0.0002 |
11 | 2023-12-03 14:00:00.000 | 0.0019 |
12 | 2023-09-02 11:00:00.000 | 0.0012 |
13 | 2023-09-12 05:00:00.000 | 0.0012 |
14 | 2023-08-10 13:00:00.000 | 0.0037 |
15 | 2023-08-24 14:00:00.000 | 0.001 |
16 | 2023-08-17 04:00:00.000 | 0.0699 |
17 | 2023-08-17 06:00:00.000 | 0.0073 |
18 | 2023-08-12 03:00:00.000 | 0.0003 |
19 | 2023-08-15 08:00:00.000 | 0.007 |
20 | 2023-09-28 23:00:00.000 | 0.0024 |
jackguyBase NFT Sales cbNFT marketplace
Updated 2024-01-30
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
›
⌄
with tab1 as (
SELECT
tx_hash as tx,
eth_value
FROM base.core.fact_transactions
), tab2 as (
SELECT
block_timestamp,
tx_hash,
FULL_DECODED_LOG['data'][6]['value'] as token_address,
FULL_DECODED_LOG['data'][1]['value'] as seller,
FULL_DECODED_LOG['data'][2]['value'] as buyer
FROM base.core.ez_decoded_event_logs
WHERE FULL_DECODED_LOG:name LIKE 'ERC721OrderFilled'
AND contract_address LIKE lower('0xdef1c0ded9bec7f1a1670819833240f027b25eff')
ORDER by block_timestamp
)
SELECT
date_trunc('hour', block_timestamp) as hour,
sum(ETH_VALUE) nft_sales_volume
FROM tab2 as a
LEFT outer JOIN tab1 as b
on a.tx_hash = b.tx
GROUP BY 1
Last run: about 1 year agoAuto-refreshes every 3 hours
...
819
28KB
28s