event_from,

block_timestamp,

price_usd,

token_id

from ethereum.nft_events

where contract_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' and event_type = 'sale' and block_timestamp between '2021-07-31' and '2021-08-31' and price_usd is not null

and event_from in ('0xff4c60814adc5ee4cdf9a57e0944b1e4678ff09c','0x0f0eae91990140c560d4156db4f00c854dc8f09e','0x38ca81849baf9b22301af89d203e095536d3066e','0xe1d29d0a39962a9a8d2a297ebe82e166f8b8ec18','0x8f01ce31da22ee7182200428b36b5dec5bfdaebd')

and block_timestamp between '2021-07-01' and '2021-08-31'),

collection as (SELECT

token_metadata:curation_status::string as series,

token_metadata:collection_name::string as collections,

token_id

from ethereum.nft_metadata

where contract_address in ('0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270', '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a')

)

select a.event_from, b.series, b.collections, sum(a.price_usd) as volume, count(a.token_id) as Counts

from sales a

join collection b on a.token_id = b.token_id

group by 1,2,3

order by 5 desc

limit 20