op_tx as (

select

date_trunc('minute', block_timestamp) as date,

from_address,

to_address,

tx_hash,

contract_address,

raw_amount / pow(10, 18) as amount

from

optimism.core.fact_token_transfers

where

contract_address = '0x4200000000000000000000000000000000000042'

),

labels as (

select

address,

address_name,

label_subtype,

label_type

from

optimism.core.dim_labels

),

txlabel as (

select

o.*,

l.*

from

op_tx o

left join labels l on o.to_address = l.address

),

labeled_tx as (

select

date,

from_address,

to_address,