vendettaBenqi USD Volume ~ Daily
    Updated 2024-09-01
    with AVAXPricet as (
    select hour::date as day,
    avg (price) as AVAXPrice
    from ethereum.price.ez_prices_hourly
    where symbol = 'WAVAX'
    group by 1),

    WBTCPricet as (
    select hour::date as day,
    avg (price) as WBTCPrice
    from ethereum.price.ez_prices_hourly
    where symbol = 'WBTC'
    group by 1),

    WETHPricet as (
    select hour::date as day,
    avg (price) as WETHPrice
    from ethereum.price.ez_prices_hourly
    where symbol = 'WETH'
    group by 1),

    LINKPricet as (
    select hour::date as day,
    avg (price) as LINKPrice
    from ethereum.price.ez_prices_hourly
    where symbol = 'LINK'
    group by 1),

    Maintable as (
    select tx_hash,
    origin_from_address as User,
    block_timestamp,
    case when event_name = 'Mint' then 'Deposit (Supply)'
    when event_name = 'Borrow' then 'Borrow'
    when event_name = 'RepayBorrow' then 'Repay'
    when event_name = 'Redeem' then 'Withdrawal (Redeem)'
    Last run: about 1 month ago
    DATE
    ACTION_TYPE
    TOKEN_SYMBOL
    TX_COUNT
    USERS_COUNT
    VOL
    1
    2025-01-01 00:00:00.000RepayUSDC1343298105156196.154341
    2
    2024-10-01 00:00:00.000Withdrawal (Redeem)LINK.e17111501427.4516517
    3
    2023-09-01 00:00:00.000BorrowBTC.b95473576765.77363232
    4
    2024-11-01 00:00:00.000Withdrawal (Redeem)BTC.b31815655606966.1101796
    5
    2024-03-01 00:00:00.000BorrowUSDC.e12861571806.479819
    6
    2024-06-01 00:00:00.000Withdrawal (Redeem)AVAX7602699962447.7124421
    7
    2024-04-01 00:00:00.000Deposit (Supply)DAI.e432839514.946710655
    8
    2024-10-01 00:00:00.000RepayUSDT.e107320699.549325
    9
    2023-09-01 00:00:00.000BorrowUSDT.e3259
    10
    2024-02-01 00:00:00.000Borrow416154
    11
    2023-09-01 00:00:00.000Withdrawal (Redeem)AVAX5902102867070.27009557
    12
    2024-05-01 00:00:00.000Withdrawal (Redeem)USDC56424714215431.653207
    13
    2024-10-01 00:00:00.000Deposit (Supply)BTC.b22410725092741.2840817
    14
    2024-09-01 00:00:00.000Withdrawal (Redeem)WETH.e5836718583.648581087
    15
    2024-02-01 00:00:00.000Deposit (Supply)USDT.e10864917.145888
    16
    2025-01-01 00:00:00.000Withdrawal (Redeem)LINK.e764857.459964372
    17
    2023-08-01 00:00:00.000Borrow27785
    18
    2023-12-01 00:00:00.000Deposit (Supply)LINK.e8741602020.019211761
    19
    2024-06-01 00:00:00.000Deposit (Supply)BTC.b159813879588.24479517
    20
    2023-12-01 00:00:00.000Withdrawal (Redeem)WBTC.e78391460692.49670196
    ...
    785
    55KB
    31s