with raw as (

select

block_timestamp,

event_index,

tokenid,

nft_to_address

from ethereum.nft.ez_nft_transfers

where nft_address = '0xbd3531da5cf5857e7cfaa92426877b022e612cf8'

and block_timestamp::date >= '2021-07-22'

),

all_tokenid as (

select

distinct tokenid as tokenid

from raw

),

all_dates as (

select

date_day as day

from crosschain.core.dim_dates

where date_day::date between '2021-07-22' and current_date()::date

),

full_list as (

select

day,

tokenid