ThatGuyNounsDAO - Lil Nouns - 1. num of daily NFT
Updated 2022-07-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- NounsDaoExecuter 0xd5f279ff9eb21c6d40c8f345a66f2751c4eea1fb
-- Nouns Treasury 0x0BC3807Ec262cB779b38D65b38158acC3bfedE10
-- Lil Nouns NFT 0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b
with daily_prices AS (
SELECT BLOCK_TIMESTAMP::date as date, avg(PRICE) as price, avg(PRICE_USD) as price_usd
FROM ethereum.core.ez_nft_sales
WHERE NFT_ADDRESS = lower('0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b') and PLATFORM_NAME = 'opensea'
GROUP BY 1
)
SELECT BLOCK_TIMESTAMP::date as date, COUNT(*) as COUNT
FROM ethereum.core.ez_nft_transfers
WHERE nft_to_address = lower('0x0BC3807Ec262cB779b38D65b38158acC3bfedE10')
and NFT_ADDRESS = lower('0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b')
GROUP BY 1
ORDER BY 1 DESC
Run a query to Download Data