select

date(block_timestamp) as date ,

tx_hash,

event_type,

seller_address,

buyer_address,

nft_address,

tokenid,

currency_symbol,

price,

price_usd

from optimism.core.ez_nft_sales

where nft_address = lower('0x9c7305eb78a432ced5C4D14Cac27E8Ed569A2e26')

and event_type = 'sale'

),

locks as(

select

tx_hash,

token_id,

velo_amount,

velo_amount_usd

from

optimism.velodrome.ez_velo_locks

),

lock_and_sale as(

select

s.*,

l.*

-- token_id l,

-- velo_amount l,

-- velo_amount_usd l

from all_sales l