CarlOwOs(1) Quixotic NFT Dashboard
Updated 2022-07-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT block_timestamp::DATE AS date
, SUM(tokenflow_eth.hextoint(substr(data, 67, 64))*pow(10, -18)) AS volume
, COUNT(*) AS sales
, COUNT(DISTINCT origin_from_address) AS buyers
FROM optimism.core.fact_event_logs
WHERE topics[0] = '0x70ba0d31158674eea8365d0f7b9ac70e552cc28b8bb848664e4feb939c6578f8'
AND origin_to_address = '0x3f9da045b0f77d707ea4061110339c4ea8ecfa70'
AND block_timestamp >= CURRENT_DATE -30
GROUP BY 1
--0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef NFT collection
--0x70ba0d31158674eea8365d0f7b9ac70e552cc28b8bb848664e4feb939c6578f8 eth transfer sale
--marketplace charges 2.5%
Run a query to Download Data