Echelon 04

par_rnEchelon 04

Updated 2025-01-17

WITH price AS (

SELECT

hour::DATE AS datee,

token_address,

AVG(price) AS usdprice,

MAX(decimals) AS decimals

FROM

aptos.price.ez_prices_hourly

GROUP BY

1, 2

supply_info AS (

SELECT

DISTINCT x.tx_hash,

x.block_timestamp,

token_address AS asset,

event_data:account_addr AS user,

event_data:amount AS amt

FROM

aptos.core.fact_events x

JOIN

aptos.core.fact_transfers y

ON x.tx_hash = y.tx_hash

WHERE

payload_function IN (

'0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::scripts::supply',

'0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::scripts::supply_fa'

)

AND event_resource = 'SupplyEvent'

AND event_module = 'lending'

AND transfer_event = 'WithdrawEvent'

amount_supplied_by_asset AS (

SELECT

Last run: 3 months ago

314B

41s

flipside