Yousefi_1994Aurora Plus - Total Fees ($USD) Saved
    Updated 2023-08-30
    with aurora_plus_users_transactions as (
    select
    block_timestamp,
    tx_hash,
    from_address
    from aurora.core.fact_transactions
    where tx_fee = 0
    and gas_price = 0
    and status = 'SUCCESS'
    ),
    aurora_plus_users_first_transactions as (
    select
    from_address,
    min(block_timestamp) as first_transactions_date
    from aurora_plus_users_transactions
    group by from_address
    having first_transactions_date >= '2022-05-17'
    and first_transactions_date < '2023-07-20'
    ),
    aurora_plus_users_transactions_2 as (
    select
    from_address,
    count(distinct tx_hash) as number_of_transaction
    from aurora_plus_users_transactions transactions
    where from_address in (select from_address from aurora_plus_users_first_transactions)
    group by from_address
    having number_of_transaction > 1
    ),
    aurora_transactions_fee as (
    select
    block_timestamp,
    tx_hash,
    tx_fee
    from aurora.core.fact_transactions
    where tx_fee != 0
    ),
    Run a query to Download Data