Since we are considering Gas Price in relation to the transactions, we need to extract the gas price metrics from ethereum.transactions.

Then, to measure the deposit/borrowing metrics, we can extract the data from aave.deposits and aave.borrowings.

In order to tally the AAVE borrowings and deposits transactions its gas fee price, we can use the inner join function. So this will give us the gas price for each AAVE transactions on ethereum.

Finally, we are to tabulate in terms of days by using date_trunc function. The data will be represented in terms of average corresponding metrics.

So essentially:

          1- extract gas price metrics from ethereum.transactions
          2- extract deposits and borrowing metrics from aave.borrowings and aave.deposits
          3- Use inner join to tally the gas price with borrowing/deposits transactions 
          4- use date_trunc and avg to tabulate the values in terms of day

The Gas Price remains below 35 M till Aug 3rd, with some exception of surge on June 22nd and , Jul 6th and Jul 15th. After Aug 3rd, the Gas price show increasing trend till Sept 7th, the dropped with the lowest gas fee of 50 M which still higher than June to early August gas price. On Oct 24th , the Gas fee shows increasing trend again until Oct 28th.

What can be observe is that when the average token deposited is high, the average gas price increases on the next day.

2.0 Analysis

1.0 How it works

2.1 Deposits and Gas Price

The below chart and the following table visualize the metrics of deposits and gas price by day

2.2 Borrowing and Gas Price

The Gas Price remained below 70 M till Aug 23rd. The gas price increase till Sept 7th at 10 M , before steady dropping to 43.7 M on Sept 25th. A sharp spice of gas price were shown on Nov 2nd.

On the day, where there are high borrowing, the gas price shows increased value on the next day.

The below chart and the following table visualize the metrics of borrowings and gas price by day

3.0 Conclusion

When there are increasing borrowing/deposit of AAVE, the gas fee increases on each next transaction day, and vice versa