headitmanagerTotal number of Bridge transactions per day
Updated 2022-07-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with total_count_Bridge as (select count(*) from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
and block_timestamp::date > current_date - interval '90 days'
)
, total_count_Bridge_daily as (select count(*),block_timestamp::date from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
and block_timestamp::date > current_date - interval '90 days'
group by block_timestamp::date
)
,total_gas_Bridge as (select sum(GAS_USED)/1e18 from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
and block_timestamp::date > current_date - interval '90 days'
)
, total_gas_daily as (select sum(GAS_USED)/1e18,block_timestamp::date from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
and block_timestamp::date > current_date - interval '90 days'
group by block_timestamp::date
)
,total_fee_Bridge as (select sum(TRANSACTION_FEE)/1e18 from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
and block_timestamp::date > current_date - interval '90 days'
)
, total_fee_daily as (select sum(TRANSACTION_FEE)/1e18,block_timestamp::date from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
and block_timestamp::date > current_date - interval '90 days'
group by block_timestamp::date
)
select * from total_count_Bridge_daily
Run a query to Download Data