jackguyy-labs 1
Updated 2023-05-02
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
›
⌄
SELECT
block_timestamp as sales_time,
price_usd
FROM ethereum.core.ez_nft_sales
--WHERE project_name LIKE 'Board Ape Yach Club'
WHERE not price_usd is NULL
AND( project_name LIKE '{{collection}}'
OR
nft_address LIKE CASE
when '{{collection}}' LIKE 'cryptopunks' then lower('0xb7F7F6C52F2e2fdb1963Eab30438024864c313F6')
when '{{collection}}' LIKE 'the otherside' then lower('0x34d85c9CDeB23FA97cb08333b511ac86E1C4E258')
when '{{collection}}' LIKE 'meebits' then lower('0x7Bd29408f11D2bFC23c34f18275bBf23bB716Bc7')
when '{{collection}}' LIKE 'boredapekennelclub' then lower('0xba30E5F9Bb24caa003E9f2f0497Ad287FDF95623')
else '22' end
)
AND block_timestamp > CURRENT_DATE - {{ fist_day }}
--GROUP BY 1
--ORDER by 2 DESC
--boredapeyachtclub
--mutantapeyachtclub
--cryptopunks
--the otherside
--meebits
--boredapekennelclub
Run a query to Download Data