SELECT hour, price

FROM ethereum.price.ez_prices_hourly

WHERE token_address = '0xfe0c30065b384f05761f15d0cc899d4f9f9cc0eb'

AND hour::date >= '2024-07-18'

),

datas AS (

SELECT

block_timestamp,

tx_hash,

to_address AS user,

symbol,

amount,

amount_usd,

'Ethereum' AS chain

FROM ethereum.core.ez_token_transfers

WHERE from_address = '0x64776b0907b839e759f91a5a328ea143067ddcd7'

AND origin_function_signature = '0x2e7ba6ef'

AND block_timestamp::date >= '2024-07-18'

AND has_price = TRUE

SELECT

block_timestamp,

tx_hash,

to_address AS user,

symbol,

amount,

amount * price AS amount_usd,

'Arbitrum' AS chain

FROM arbitrum.core.ez_token_transfers

LEFT JOIN prices ON (hour = date_trunc('hour',block_timestamp))

WHERE origin_function_signature = '0x2e7ba6ef'

AND from_address = '0xc5fde679f52e9bd896ab1dee5265f9a80c672512'

AND block_timestamp::date >= '2024-07-18'