boomer77Ecumonopolis sales top
Updated 2021-09-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with sale as (select tx_id, token_id, price
from ethereum.nft_events
where contract_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
and event_type = 'sale' and price < 100 and token_id in (select token_id
from ethereum.nft_metadata
where contract_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
and lower(token_name) LIKE '%ecumenopolis%')),
name as (select token_id, token_name
from ethereum.nft_metadata
where contract_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
and lower(token_name) LIKE '%ecumenopolis%')
select b.token_name, a.price
from sale a
join name b on a.token_id = b.token_id
group by 1,2
order by 2 desc
limit 10
Run a query to Download Data