realistplatform sale share
Updated 2024-09-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with base as (
SELECT
--block_timestamp::date as date ,
date_trunc('month', block_timestamp) as date,
platform_name,
count(*) as sales_count,
FROM ethereum.nft.ez_nft_sales
WHERE nft_address = lower('0x86486fE85545b57D06330acf1f3D63bb7b790cB4')
GROUP BY 1,2
--ORDER BY 3
)
SELECT
date,
platform_name,
sum(sales_count) as platform_volume
from base
GROUP BY all
ORDER BY 1
QueryRunArchived: QueryRun has been archived