from polygon.core.ez_nft_transfers

where project_name = 'HellCats'),

pay as (select *

from polygon.core.ez_matic_transfers

where tx_hash in (select tx_hash from hc) and identifier = 'CALL_ORIGIN'),

hcsales as (select a.block_timestamp, a.event_index, a.event_type, a.nft_address,

a.nft_from_address,a.nft_to_address, a.project_name, a.tokenid, a.tx_hash,

b.amount, b.amount_usd

from hc a

left join pay b on a.tx_hash = b.tx_hash

where b.amount is not null

order by 1 desc)

select date_trunc('day', block_timestamp) as dt, min(amount) as sales_floor, min(amount_usd) as sales_floor_usd

from hcsales

group by 1