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 ('0x0001A500A6B18995B03f44bb040A5fFc28E45CB0')

),

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 >= '2022-06-30'

and DATE_DAY<current_date

),

base_data AS (

SELECT

days,

address

FROM all_days

LEFT JOIN all_addresses ON TRUE

),