SELECT

tk.*,

SYMBOL,

NAME

FROM

(

SELECT

tx.from_address as ua,

tr.to_address as token_holder_address,

tr.contract_address as token_address,

tx.tx_hash,

tx.block_timestamp,

tr.RAW_AMOUNT / pow(10, 18) as amount

FROM

blast.core.fact_transactions tx

inner join blast.core.fact_token_transfers tr on tx.tx_hash = tr.tx_hash

and tr.from_address = '0x0000000000000000000000000000000000000000'

where

tx.to_address = lower('0x4AE5E86c262af721E13d6c863780Da35D0d9cbd1')

and tx.STATUS = 'SUCCESS'

) as tk

inner join blast.core.dim_contracts cn on tk.token_Address = cn.address

),

all_trades as (

SELECT

tx.tx_hash,

'Buy' as actions,

tx.from_address,

et.AMOUNT_USD as AMOUNT_USD,

tk.CONTRACT_ADDRESS,

tk.raw_amount / pow(10, 18) as amount,

tk.symbol,

'Tornado Luancher' as source

FROM

blast.core.fact_transactions tx