NFT_SALES_VOLUME | |
|---|---|
1 | 7.4433 |
jackguy2023-08-03 07:06 PM
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
›
⌄
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
sum(ETH_VALUE) nft_sales_volume
FROM tab2 as a
LEFT outer JOIN tab1 as b
on a.tx_hash = b.tx
Last run: about 1 year agoAuto-refreshes every 3 hours
1
10B
62s