Yousefi_1994Aurora Plus - Total Fees ($USD) Saved
Updated 2023-08-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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