tricky-plum copy copy

Mrftitricky-plum copy copy

Updated 7 hours ago

-- forked from tricky-plum copy @ https://flipsidecrypto.xyz/studio/queries/6de67de4-814f-4c0e-b898-b5f7bb8e88fd

WITH assettbl AS (

SELECT

origin_from_address AS user,

DATE_TRUNC('day', block_timestamp) AS date, -- Include the date column

CASE

WHEN contract_name = 'EVK Vault eswETH-1' THEN 'SWETH'

WHEN contract_name = 'EVK Vault epzETH-1' THEN 'PZETH'

WHEN contract_name = 'EVK Vault eweETH-1' THEN 'WEETH'

WHEN contract_name = 'EVK Vault eezETH-1' THEN 'EZETH'

WHEN contract_name = 'EVK Vault eWETH-1' THEN 'WETH'

WHEN contract_name = 'EVK Vault ersETH-1' THEN 'RSETH'

WHEN contract_name = 'EVK Vault erswETH-1' THEN 'RSWETH'

WHEN contract_name = 'EVK Vault ewstETH-1' THEN 'WSTETH'

END AS token,

contract_address,

event_name,

SUM(decoded_log:assets / POW(10, 18)) AS amount

FROM

swell.core.ez_decoded_event_logs

WHERE

event_name IN ('Deposit', 'Borrow', 'Repay', 'Withdraw')

AND origin_to_address = '0x08739cbede6e28e387685ba20e6409bd16969cde'

GROUP BY 1, 2, 3, 4, 5

pricetbl AS (

SELECT

DATE_TRUNC('day', hour) AS date,

symbol,

AVG(price) AS price

FROM

crosschain.price.ez_prices_hourly

WHERE

blockchain = 'ethereum'

GROUP BY 1, 2

Last run: about 7 hours agoAuto-refreshes every 12 hours

100

7KB