Sandeshbase opensea
Updated 2023-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select date_trunc('hour',el.block_timestamp) as dte,
el.contract_address as nft_address,
nft.project_name,
count(distinct el.tx_hash) as sales
from base.core.fact_event_logs el
left join base.core.ez_nft_transfers nft
on el.contract_address = nft.nft_address
where 1=1
-- and el.tx_hash=lower('0xf64b54637a2f2320b8c2db16e6f43f0b301f6fbc67e91f0a0170fcd832c249f3')
and el.origin_to_address='0x00000000000000adc04c56bf30ac9d3c0aaf14dc'
and el.origin_to_address!=contract_address
group by dte, el.contract_address,nft.project_name
Run a query to Download Data