SELECT

price AS current_price

FROM(

SELECT

hour,

price,

RANK() OVER(ORDER BY hour DESC) AS rank

FROM arbitrum.price.ez_prices_hourly

WHERE token_address = '0x000d636bd52bfc1b3a699165ef5aa340bea8939c'

ORDER BY 1 DESC, hour DESC

) AS a

WHERE rank = 1

),

receivers AS (

SELECT

to_address AS receiver,

SUM(amount) AS received_volume_odg,

SUM(amount * current_price) AS received_volume_usd

FROM arbitrum.core.ez_token_transfers, price

WHERE contract_address = '0x000d636bd52bfc1b3a699165ef5aa340bea8939c'

AND to_address NOT IN (SELECT address FROM arbitrum.core.dim_contracts)

AND to_address <> '0x0000000000000000000000000000000000000000'

AND amount IS NOT NULL

GROUP BY 1

),

senders AS (

SELECT

from_address AS sender,

SUM(amount) AS sent_volume_odg,

SUM(amount * current_price) AS sent_volume_usd

FROM arbitrum.core.ez_token_transfers , price

WHERE contract_address = '0x000d636bd52bfc1b3a699165ef5aa340bea8939c'

--AND from_address NOT IN (SELECT address FROM arbitrum.core.dim_contracts)

AND from_address <> '0x0000000000000000000000000000000000000000'

AND amount IS NOT NULL