SELECT

DISTINCT

FROM_ADDRESS as address

FROM

ethereum.core.fact_transactions

-- WHERE FROM_ADDRESS='0x8e3eedf2c8655c442f0c1cc0a58160250becf03c'

where date(BLOCK_TIMESTAMP) >= DATEADD(day, 0, '{{param_oifG}}')

AND date(BLOCK_TIMESTAMP) <= DATEADD(day, 0, '{{param_oifG}}')

-- and NONCE=0

),

tgt_addr_obs_age as(

SELECT

a.FROM_ADDRESS as address

,DATEDIFF(day,min(a.BLOCK_TIMESTAMP),date('{{param_oifG}}')) as wallet_age

FROM

ethereum.core.fact_transactions a

inner join tgt_addr_obs b

on a.FROM_ADDRESS=b.address

GROUP BY a.FROM_ADDRESS

),

gas_use_obs as(

SELECT

FROM_ADDRESS

,sum(TX_FEE)*1600 as TX_FEE_AMOUNT

FROM

ethereum.core.fact_transactions

where date(BLOCK_TIMESTAMP) >= DATEADD(day, 0, '{{param_oifG}}')

AND date(BLOCK_TIMESTAMP) <= DATEADD(day, 0, '{{param_oifG}}')

group by FROM_ADDRESS

),

block_amount_in_out_obs as(

SELECT

TOKEN_IN

,TOKEN_OUT