KingTigerMafia-7mwRZbPopular NFT transaction volume
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH genesiskami AS (
SELECT block_timestamp::date AS date, COUNT(DISTINCT tx_hash) AS tx_count
FROM optimism.core.ez_nft_sales
WHERE date >= '2022-07-01' AND nft_address = '0xb91b2276bd5a98994bf1f496e3886f688f8d4581'
GROUP BY 1
ORDER BY 1 ASC
), mirror AS (
SELECT block_timestamp::date AS date, COUNT(DISTINCT tx_hash) AS tx_count
FROM optimism.core.ez_nft_sales
WHERE date >= '2022-07-01' AND nft_address = '0xa95579592078783b409803ddc75bb402c217a924'
GROUP BY 1
ORDER BY 1 ASC
)
SELECT m.date, SUM(m.tx_count) as mirror_count, SUM(g.tx_count) as genesiskami_count
FROM mirror m FULL OUTER JOIN genesiskami g on m.date = g.date
GROUP BY 1
ORDER BY 1 ASC
-- 0xb91b2276bd5a98994bf1f496e3886f688f8d4581 genesiskami
-- 0xa95579592078783b409803ddc75bb402c217a924 mirror wnft optimism collective: hello world
Run a query to Download Data