Updated 8 days ago
    with

    pricet as (
    select
    hour::date as dt,
    token_address,
    avg(price) as token_price_usd
    from
    aptos.price.ez_prices_hourly
    group by 1, 2
    ),

    main as (
    select
    tx_hash,
    block_timestamp,
    event_data:amount as amount_unadj,
    event_data:coin_name as token_address,
    event_data:signer_address as user,
    'Supply' as event_name
    from
    aptos.core.fact_events
    where
    payload_function like '0x2fe576faa841347a9b1b32c869685deb75a15e3f62dfe37cbd6d52cc403a16f6::pool::lend%'
    and event_type = '0x2fe576faa841347a9b1b32c869685deb75a15e3f62dfe37cbd6d52cc403a16f6::pool::LendEvent'
    and success

    union all

    select
    tx_hash,
    block_timestamp,
    event_data:amount as amount_unadj,
    event_data:coin_name as token_address,
    event_data:signer_address as user,
    'Withdraw' as event_name
    Last run: 8 days ago
    EVENT_NAME
    TRANSACTIONS
    USERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    Withdraw436824789618761318.42013216028.009802361
    2
    Supply503076154623455128.2958515155.949248732
    2
    112B
    31s