madhurim2023-11-18 07:50 PM
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
SUM(s.total_fees) AS Total_fees, SUM(s.total_fees_usd) AS Total_fees_dollar,
SUM (s.creator_fee) AS Creator_fee,
SUM (s.creator_fee_usd) AS Creator_fee_dollar
FROM
ethereum.nft.dim_nft_metadata AS m, ethereum.nft.ez_nft_sales AS s
WHERE
m.project_name LIKE ('%art%blocks')
AND m.token_name LIKE ('%fidenza%')
AND s. tokenid = m. token_id
AND s.platform_name LIKE ('opensea')
AND s.block_timestamp BETWEEN '{{start_date}}'
AND '{{end_date}}';
Run a query to Download Data