tricky-plum copy

Mrftitricky-plum copy

Updated 10 hours ago

-- forked from tricky-plum @ https://flipsidecrypto.xyz/studio/queries/4486e2a6-3c7a-4a9f-bd79-e1ad1a68e6fc

WITH assettbl AS (

SELECT

origin_from_address AS user,

DATE_TRUNC('day', block_timestamp) AS date,

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 10 hours agoAuto-refreshes every 12 hours

100

6KB

179s