current_price AS (

SELECT

hour, symbol, price, rank() over(ORDER BY hour DESC) AS rank

FROM base.price.ez_prices_hourly

WHERE token_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'

qualify rank = 1

),

first_dist AS(

SELECT block_timestamp, tx_hash, to_address AS user, amount AS first_amount_received,

FROM base.core.ez_token_transfers

WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'

AND tx_hash = '0xe930bba69e4c165a44197088b25f890b37de23c182f992c0834fa8843407c9f0'

ORDER BY event_index ASC

),

lps AS(

block_timestamp,

tx_hash,

from_address AS user,

to_address AS lp_address,

amount AS fdream_amount,

'Add 🟢' AS funciton

FROM base.core.ez_token_transfers

WHERE

contract_address = lower('0x0521AaA7C96E25afeE79FDd4f1Bb48F008aE4eac')

AND to_address = lower('0x0ebcEE3165654d9c52dd6D438423bE76F2Df1b0E')

UNION ALL

block_timestamp,

tx_hash,

to_address AS user,

from_address AS lp_address,

-amount AS fdream_amount,

'Remove 🔴' AS funciton