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,

origin_from_address AS user,

symbol,

amount,

amount * price AS amount_usd

FROM ethereum.core.ez_token_transfers

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

WHERE contract_address = '0x86b5780b606940eb59a062aa85a07959518c0161'

AND origin_to_address = '0xe2acf9f80a2756e51d1e53f9f41583c84279fb1f'

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

SELECT

date_trunc('hour',block_timestamp) AS time,

count(tx_hash) AS transactions,

count(DISTINCT user) AS users,

sum(amount) AS staked_amount,

sum(amount_usd) AS staked_amount_usd,

SUM(staked_amount) OVER (ORDER BY time ASC) AS cum_staked_amount,

SUM(staked_amount_usd) OVER (ORDER BY time ASC) AS cum_staked_amount_usd

FROM datas

GROUP BY 1