jackguylol_300
Updated 2022-09-26
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
date_trunc('day',block_timestamp) as day,
-- MOMENT_TIER,
avg(price)
FROM flow.core.ez_nft_sales
LEFT outer JOIN flow.core.dim_allday_metadata
ON flow.core.dim_allday_metadata.nft_id = flow.core.ez_nft_sales.nft_id
WHERE flow.core.ez_nft_sales.nft_collection LIKE '%AllDay'
--AND team LIKE '{{team}}'
GROUP BY 1,2
Run a query to Download Data