SELECT

timestamp::date AS datee,

symbol,

AVG(price_usd) AS usdprice

FROM

near.price.fact_prices

GROUP BY

1, 2

),

deposit AS (

SELECT

block_timestamp,

CASE

WHEN a.symbol = 'ETH' THEN 'WETH'

WHEN symbol = 'sFRAX' THEN 'FRAX'

ELSE symbol

END AS symbol,

CASE

WHEN symbol IN ('WBTC', 'DAI', 'USDt', 'FRAX', 'ETH', 'USDC', 'BRRR', 'USN', 'USDT.e', 'AURORA', 'USDC.e', 'sFRAX', 'WOO') THEN amount_raw / POW(10, 18)

ELSE amount_raw / POW(10, 24)

END AS amount,

tx_hash,

sender_id

FROM

near.defi.ez_lending a

WHERE

actions IN ('deposit', 'deposit_to_reserve')

AND platform = 'burrow'

AND symbol IN ('sFRAX', 'WBTC', 'DAI', 'USDt', 'FRAX', 'ETH', 'USDC', 'BRRR', 'USN', 'USDT.e', 'AURORA', 'USDC.e', 'LINEAR', 'WOO', 'wNEAR', 'STNEAR')

),

borrow AS (

SELECT

block_timestamp,

CASE

WHEN a.symbol = 'ETH' THEN 'WETH'