FROM_ADDRESS

,TO_ADDRESS

, t.BLOCK_TIMESTAMP

, date_trunc('day', t.BLOCK_TIMESTAMP) AS day

, RAW_AMOUNT/1e18 AS volume_transferred

from ethereum.core.fact_token_transfers t

where CONTRACT_ADDRESS = lower ('0x3b50805453023a91a8bf641e279401a0b23fa6f9')

),

all_addresses AS (

SELECT

distinct TO_ADDRESS AS address

FROM raw_transfers

),

min_day as (

SELECT cast(date_trunc('day', MIN(day)) as date) as mday FROM raw_transfers

),

all_days AS (

SELECT DATE_DAY as days

FROM ethereum.core.dim_dates

where DATE_DAY >= '2024-04-30'

and DATE_DAY<current_date

),

base_data AS (

SELECT

days,

address

FROM all_days

LEFT JOIN all_addresses ON TRUE

),