select

block_timestamp,

event_index,

from_address,

to_address,

amount

from bsc.core.ez_token_transfers

where block_timestamp::date >= '2025-01-01'

and contract_address = lower('0x7d814b9eD370Ec0a502EdC3267393bF62d891B62') -- virtuals

),

all_address as (

select

distinct to_address as address

from raw

),

all_dates as (

select

date_day::date as day

from crosschain.core.dim_dates

where date_day between '2025-01-01' and current_date()::date

),

full_list as (

select

day,

address

from all_dates cross join all_address

),

direction as (

select

block_timestamp,

block_timestamp::date as day,