2024-05-05 12:03 PM

freemartian2024-05-05 12:03 PM

Updated 2024-12-04

-- -- supply usdc: 0x0a42ec80da270d2f60f04b2ddfa893ed4a5dd014d7c56c70df734abaa3f14fef

-- -- withdraw usdc: 0xc1565c4f7a88aa5aec4fadb616a2536c5971ea1185d714999504bbdc81460d46

-- -- borrow move usdc: 0x00908f7e32298bd727c1b5688754c57568c1f4afb4636f12c1e61d61fa154d15

-- --repay: 0xa8716872714f3651cfc3608f647c843eec5909694573098e56a80100ee1ccbf1

-- -- supply

-- WITH supply AS (

-- SELECT block_timestamp, tx_hash

-- FROM aptos.core.fact_events

-- WHERE event_type = '0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::lending::SupplyEvent'

-- -- AND tx_hash = '0x0a42ec80da270d2f60f04b2ddfa893ed4a5dd014d7c56c70df734abaa3f14fef'

-- ORDER BY block_timestamp DESC

-- -- LIMIT 500

-- ),

-- decimals AS (

-- SELECT symbol,

-- decimals

-- FROM aptos.price.ez_hourly_token_prices

-- GROUP BY 1,2

-- ),

-- prices AS (

-- SELECT

-- hour::date AS day,

-- symbol,

-- decimals,

-- AVG(price) AS price

-- FROM aptos.price.ez_hourly_token_prices

-- GROUP BY 1,2,3

-- ),

-- transactions AS (

QueryRunArchived: QueryRun has been archived

flipside