In this notebook we perform Exploratory Data Analysis (EDA) on FIL's gas fee mechanism. The goal is to observe the gas fee as a signal and attempt to understand what may be driving it.
Note: this description is copied from the official Filecoin documentation
Executing messages, for example by including transactions or proofs in the chain, consumes both computation and storage resources on the network. Gas is a measure of resources consumed by messages. The gas consumed by a message directly affects the cost that the sender has to pay for it to be included in a new block by a miner.
Historically in other blockchains, miners specify a GasFee in a unit of native currency and then pay the block producing miners a priority fee based on how much gas is consumed by the message. Filecoin works similarly, except an amount of the fees is burned (sent to an irrecoverable address) to compensate for the network expenditure of resources, since all nodes need to validate the messages. The idea is based on Ethereum's EIP1559.
The amount of fees burned in the Filecoin network comes given by a dynamic BaseFee which gets automatically adjusted according to the network congestion parameters (block sizes). The current value can be obtained from one of the block explorers or by inspecting the current head.
Additionally, a number of gas-related parameters are attached to each message and determine the amount of rewards that miners get. Here's an overview of the terms and concepts:
GasUsage: the amount of gas that a message's execution actually consumes. Current protocol does not know how much gas a message will exactly consume ahead of execution, but it can be estimated (see prices (opens new window)). GasUsage measured in units of Gas.
BaseFee: the amount of FIL that gets burned per unit of gas consumed for the execution of every message. It is measured in units of attoFIL/Gas.
GasLimit: the limit on the amount of gas that a message's execution can consume, estimated and specified by a message sender. It is measured in units of Gas. The sum of GasLimit for all messages included in a block must not exceed the BlockGasLimit. Messages will fail to execute if they run out of Gas, and any effects of the execution will be reverted.
GasFeeCap: the maximum token amount that a sender is willing to pay per GasUnit for including a message in a block. It is measured in units of attoFIL/Gas. A message sender must have a minimum balance of GasFeeCap * GasLimit when sending a message, even though not all of that will be consumed. GasFeeCap can serve as a safeguard against high, unexpected BaseFee fluctuations.
GasPremium: a priority fee that is paid to the block-producing miner. This is capped by GasFeeCap. The BaseFee has a higher priority. It is measured in units of attoFIL/Gas and can be as low as 1 attoFIL/Gas.
Overestimation burn: an additional amount of gas to burn that grows larger when the difference between GasLimit and GasUsage is large.
The total cost of a message for a sender will be:
An important detail is that a message will always pay the burn fee, regardless of the GasFeeCap used. Thus, a low GasFeeCap may result in a reduced GasPremium or even a negative one! In that case, the miners that include a message will have to pay the needed amounts out of their own pockets, which means they are unlikely to include such messages in new blocks.
Filecoin implementations may choose the heuristics of how their miners select messages for inclusion in new blocks, but they will usually attempt to maximize the miner's rewards.

# import libraries
from sqlalchemy import create_engine
import pandas as pd
from datetime import datetime
from statsmodels.tsa.api import VAR
from sklearn.preprocessing import StandardScaler
from statsmodels.tsa.stattools import adfuller
from math import sqrt
import matplotlib.pyplot as plt
import seaborn as sns
import scipy.stats as stats
import numpy as np
import seaborn as sns
from Cryptoeconomics_signal_processing import time_analysis, fourier_transform, phase_shift_overlay
%matplotlib inline
# load connection string
CONN_STRING_PATH = '../config/sentinel_conn_string_andrew.txt'
with open(CONN_STRING_PATH, 'r') as fid:
conn_string = fid.read()
# create database connection.
connection = create_engine(conn_string, pool_recycle=3600).connect()
Below we download hourly averages from the messages and mesage_gas_economy table from May 1st, 2021 to present (last refreshed 6/28/2021). After downloading the data, we few the first and lasts 5 rows, and perform basic statistics on the data.
derived_gas_outputs¶Derived gas costs resulting from execution of a message in the VM.
| Name | Type | Nullable | Description |
|---|---|---|---|
actor_name |
text |
NO | Human readable identifier for the type of the actor. |
base_fee_burn |
text |
NO | The amount of FIL (in attoFIL) to burn as a result of the base fee. It is parent_base_fee (or gas_fee_cap if smaller) multiplied by gas_used. Note: successfull window PoSt messages are not charged this burn. |
cid |
text |
NO | CID of the message. |
exit_code |
bigint |
NO | The exit code that was returned as a result of executing the message. Exit code 0 indicates success. Codes 0-15 are reserved for use by the runtime. Codes 16-31 are common codes shared by different actors. Codes 32+ are actor specific. |
from |
text |
NO | Address of actor that sent the message. |
gas_burned |
bigint |
NO | The overestimated units of gas to burn. It is a portion of the difference between gas_limit and gas_used. |
gas_fee_cap |
text |
NO | The maximum price that the message sender is willing to pay per unit of gas. |
gas_limit |
bigint |
YES | A hard limit on the amount of gas (i.e., number of units of gas) that a message’s execution should be allowed to consume on chain. It is measured in units of gas. |
gas_premium |
text |
NO | The price per unit of gas (measured in attoFIL/gas) that the message sender is willing to pay (on top of the BaseFee) to "tip" the miner that will include this message in a block. |
gas_refund |
bigint |
NO | The overestimated units of gas to refund. It is a portion of the difference between gas_limit and gas_used. |
gas_used |
bigint |
NO | A measure of the amount of resources (or units of gas) consumed, in order to execute a message. |
height |
bigint |
NO | Epoch this message was executed at. |
method |
bigint |
YES | The method number to invoke. Only unique to the actor the method is being invoked on. A method number of 0 is a plain token transfer - no method exectution. |
miner_penalty |
text |
NO | Any penalty fees (in attoFIL) the miner incured while executing the message. |
miner_tip |
text |
NO | The amount of FIL (in attoFIL) the miner receives for executing the message. Typically it is gas_premium * gas_limit but may be lower if the total fees exceed the gas_fee_cap. |
nonce |
bigint |
YES | The message nonce, which protects against duplicate messages and multiple messages with the same values. |
over_estimation_burn |
text |
NO | The fee to pay (in attoFIL) for overestimating the gas used to execute a message. The overestimated gas to burn (gas_burned) is a portion of the difference between gas_limit and gas_used. The over_estimation_burn value is gas_burned * parent_base_fee. |
parent_base_fee |
text |
NO | The set price per unit of gas (measured in attoFIL/gas unit) to be burned (sent to an unrecoverable address) for every message execution. |
refund |
text |
NO | The amount of FIL (in attoFIL) to refund to the message sender after base fee, miner tip and overestimation amounts have been deducted. |
size_bytes |
bigint |
YES | Size in bytes of the serialized message. |
state_root |
text |
NO | CID of the parent state root. |
to |
text |
NO | Address of actor that received the message. |
value |
text |
NO | The FIL value transferred (attoFIL) to the message receiver. |
message_gas_economy¶Gas economics for all messages in all blocks at each epoch.
| Name | Type | Nullable | Description |
|---|---|---|---|
base_fee |
double precision |
NO | The set price per unit of gas (measured in attoFIL/gas unit) to be burned (sent to an unrecoverable address) for every message execution. |
base_fee_change_log |
double precision |
NO | The logarithm of the change between new and old base fee. |
gas_capacity_ratio |
double precision |
YES | The gas_limit_unique_total / target gas limit total for all blocks. |
gas_fill_ratio |
double precision |
YES | The gas_limit_total / target gas limit total for all blocks. |
gas_limit_total |
bigint |
NO | The sum of all the gas limits. |
gas_limit_unique_total |
bigint |
YES | The sum of all the gas limits of unique messages. |
gas_waste_ratio |
double precision |
YES | (gas_limit_total - gas_limit_unique_total) / target gas limit total for all blocks. |
height |
bigint |
NO | Epoch these economics apply to. |
state_root |
text |
NO | CID of the parent state root at this epoch. |
messages¶Validated on-chain messages by their CID and their metadata.
| Name | Type | Nullable | Description |
|---|---|---|---|
cid |
text |
NO | CID of the message. |
from |
text |
NO | Address of the actor that sent the message. |
gas_fee_cap |
text |
NO | The maximum price that the message sender is willing to pay per unit of gas. |
gas_limit |
bigint |
NO | - |
gas_premium |
text |
NO | The price per unit of gas (measured in attoFIL/gas) that the message sender is willing to pay (on top of the BaseFee) to "tip" the miner that will include this message in a block. |
height |
bigint |
NO | Epoch this message was executed at. |
method |
bigint |
YES | The method number invoked on the recipient actor. Only unique to the actor the method is being invoked on. A method number of 0 is a plain token transfer - no method exectution. |
nonce |
bigint |
NO | The message nonce, which protects against duplicate messages and multiple messages with the same values. |
size_bytes |
bigint |
NO | Size of the serialized message in bytes. |
to |
text |
NO | Address of the actor that received the message. |
value |
text |
NO | Amount of FIL (in attoFIL) transferred by this message. |
We will focus on analyzing the methods by actor type using the derived gas outputs table. The data is very large, so we will perform individul SQL queries in order to obtain all of the required data.
# # message level data
QUERY = """
SELECT
to_timestamp(height_to_unix(d.height)) AS timestamp,
d.actor_name,
d.base_fee_burn,
d.cid,
d.exit_code,
d.from,
d.gas_burned,
d.gas_fee_cap,
d.gas_limit,
d.gas_premium,
d.gas_refund,
d.gas_used,
d.height,
d.method,
d.miner_penalty,
d.miner_tip,
d.nonce,
d.over_estimation_burn,
d.parent_base_fee,
d.refund,
d.size_bytes,
d.state_root,
d.to,
d.value
FROM derived_gas_outputs d
WHERE
to_timestamp(height_to_unix(d.height)) BETWEEN '2021-06-01' AND '2021-06-02'
"""
derived_gas_outputs_message_level = (pd.read_sql(QUERY, connection))
For June 1 and June 2, what are the number of transactions by actor type?
derived_gas_outputs_message_level.actor_name.value_counts()
fil/4/storageminer 1481249 fil/4/account 30867 fil/4/storagemarket 2468 fil/4/multisig 1447 <unknown> 106 fil/4/storagepower 105 fil/4/paymentchannel 13 Name: actor_name, dtype: int64
# # message level data
QUERY = """
SELECT DISTINCT
d.actor_name,
d.method
FROM derived_gas_outputs d
WHERE
to_timestamp(height_to_unix(d.height)) BETWEEN '2021-06-01' AND '2021-06-30'
GROUP BY
d.actor_name,
d.method
"""
derived_gas_outputs_message_level_actors = (pd.read_sql(QUERY, connection))
Count of all actor types and methods used during June.
derived_gas_outputs_message_level_actors
| actor_name | method | |
|---|---|---|
| 0 | fil/4/account | 0 |
| 1 | fil/4/account | 2 |
| 2 | fil/4/account | 3 |
| 3 | fil/4/account | 5 |
| 4 | fil/4/init | 2 |
| 5 | fil/4/multisig | 0 |
| 6 | fil/4/multisig | 2 |
| 7 | fil/4/multisig | 3 |
| 8 | fil/4/paymentchannel | 0 |
| 9 | fil/4/storagemarket | 2 |
| 10 | fil/4/storagemarket | 3 |
| 11 | fil/4/storagemarket | 4 |
| 12 | fil/4/storageminer | 0 |
| 13 | fil/4/storageminer | 3 |
| 14 | fil/4/storageminer | 4 |
| 15 | fil/4/storageminer | 5 |
| 16 | fil/4/storageminer | 6 |
| 17 | fil/4/storageminer | 7 |
| 18 | fil/4/storageminer | 8 |
| 19 | fil/4/storageminer | 9 |
| 20 | fil/4/storageminer | 10 |
| 21 | fil/4/storageminer | 11 |
| 22 | fil/4/storageminer | 15 |
| 23 | fil/4/storageminer | 16 |
| 24 | fil/4/storageminer | 18 |
| 25 | fil/4/storageminer | 20 |
| 26 | fil/4/storageminer | 21 |
| 27 | fil/4/storageminer | 22 |
| 28 | fil/4/storageminer | 23 |
| 29 | fil/4/storageminer | 24 |
| 30 | fil/4/storagepower | 2 |
| 31 | fil/4/verifiedregistry | 4 |
| 32 | <unknown> | 0 |
| 33 | <unknown> | 1 |
# # message level data
QUERY = """
SELECT
d.base_fee_burn,
d.exit_code,
d.gas_burned,
d.gas_fee_cap,
d.gas_limit,
d.gas_premium,
d.gas_refund,
d.gas_used,
d.height,
d.method,
d.miner_penalty,
d.miner_tip,
d.nonce,
d.over_estimation_burn,
d.parent_base_fee,
d.refund
FROM derived_gas_outputs d
WHERE
to_timestamp(height_to_unix(d.height)) BETWEEN '2021-06-01' AND '2021-06-30'
AND d.actor_name = 'fil/4/storagemarket'
"""
derived_gas_outputs_message_level_storage_market = (pd.read_sql(QUERY, connection))
derived_gas_outputs_message_level_storage_market.describe()
| base_fee_burn | exit_code | gas_burned | gas_fee_cap | gas_limit | gas_premium | gas_refund | gas_used | height | method | miner_penalty | miner_tip | nonce | over_estimation_burn | parent_base_fee | refund | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | 6.162100e+04 | 61621.000000 | 6.162100e+04 | 6.162100e+04 | 6.162100e+04 | 6.162100e+04 | 6.162100e+04 | 6.162100e+04 | 61621.000000 | 61621.000000 | 6.162100e+04 | 6.162100e+04 | 6.162100e+04 | 6.162100e+04 | 6.162100e+04 | 6.162100e+04 |
| mean | 4.077972e+16 | 0.010029 | 3.149639e+06 | 4.907266e+09 | 9.461527e+07 | 5.401222e+05 | 1.593134e+07 | 7.553429e+07 | 846308.565603 | 2.701660 | 3.712199e+10 | 5.211299e+13 | 4.294501e+04 | 1.772818e+15 | 5.151027e+08 | 3.931660e+17 |
| std | 8.308884e+16 | 0.407687 | 3.708446e+07 | 5.702000e+09 | 1.364981e+08 | 3.220969e+07 | 2.230157e+07 | 1.049736e+08 | 23904.654520 | 0.954238 | 8.437992e+12 | 5.624881e+15 | 1.095876e+05 | 3.217716e+16 | 5.082366e+08 | 6.334691e+17 |
| min | 1.060004e+09 | 0.000000 | 0.000000e+00 | 9.923600e+04 | 4.990251e+06 | 9.785700e+04 | 0.000000e+00 | 3.164190e+05 | 806640.000000 | 2.000000 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 1.000000e+02 | 0.000000e+00 |
| 25% | 1.610871e+15 | 0.000000 | 3.749990e+05 | 8.400163e+08 | 1.342555e+07 | 9.990800e+04 | 2.248854e+06 | 1.080154e+07 | 825870.000000 | 2.000000 | 0.000000e+00 | 1.354255e+12 | 1.164900e+04 | 5.657481e+13 | 8.416376e+07 | 1.751587e+16 |
| 50% | 7.358929e+15 | 0.000000 | 3.800620e+05 | 4.844441e+09 | 1.359130e+07 | 1.004860e+05 | 2.277422e+06 | 1.093414e+07 | 844469.000000 | 2.000000 | 0.000000e+00 | 3.530529e+12 | 3.041800e+04 | 2.530612e+14 | 4.118912e+08 | 7.686502e+16 |
| 75% | 2.545670e+16 | 0.000000 | 4.481954e+06 | 6.277822e+09 | 1.513857e+08 | 2.040790e+05 | 2.570593e+07 | 1.189982e+08 | 866511.000000 | 4.000000 | 0.000000e+00 | 2.670426e+13 | 3.466600e+04 | 8.453336e+14 | 8.856992e+08 | 2.828606e+17 |
| max | 1.505270e+18 | 19.000000 | 8.749464e+09 | 1.898583e+11 | 9.021040e+09 | 5.032031e+09 | 1.244673e+08 | 5.589476e+08 | 890160.000000 | 4.000000 | 2.084783e+15 | 1.358518e+18 | 2.454082e+06 | 7.594399e+18 | 6.273926e+09 | 6.907386e+18 |
# derived_gas_outputs_message_level_storage_market.plot(x='height',y='gas_used',c='method',kind='scatter')
derived_gas_outputs_message_level_storage_market.hist(column='gas_used',by='method')
plt.title('Distributions of Storage Market Gased used by method')
Text(0.5, 1.0, 'Distributions of Storage Market Gased used by method')
QUERY = """
SELECT
to_timestamp(height_to_unix(g.height)) as timestamp,
g.base_fee,
g.base_fee_change_log,
g.gas_capacity_ratio,
g.gas_fill_ratio,
g.gas_limit_total,
g.gas_limit_unique_total,
g.gas_waste_ratio
FROM message_gas_economy g
WHERE
to_timestamp(height_to_unix(g.height)) BETWEEN '2021-06-02' AND '2021-06-05'
ORDER BY
timestamp ASC
"""
message_gas_economy = (pd.read_sql(QUERY, connection))
# Use state root and parent state root to combine, height if not available
message_gas_economy.head()
| timestamp | base_fee | base_fee_change_log | gas_capacity_ratio | gas_fill_ratio | gas_limit_total | gas_limit_unique_total | gas_waste_ratio | |
|---|---|---|---|---|---|---|---|---|
| 0 | 2021-06-02 00:00:00+00:00 | 2.600000e-16 | -0.257298 | 0.764315 | 1.998053 | 5.994159e+10 | 2.292944e+10 | 1.233738 |
| 1 | 2021-06-02 00:00:30+00:00 | 2.490000e-16 | -0.367020 | 0.678527 | 1.988991 | 5.966973e+10 | 2.035580e+10 | 1.310464 |
| 2 | 2021-06-02 00:01:00+00:00 | 2.520000e-16 | 0.101680 | 1.113587 | 1.999106 | 3.998213e+10 | 2.227174e+10 | 0.885519 |
| 3 | 2021-06-02 00:01:30+00:00 | 2.630000e-16 | 0.362743 | 1.351031 | 1.999886 | 2.999829e+10 | 2.026547e+10 | 0.648855 |
| 4 | 2021-06-02 00:02:00+00:00 | 2.540000e-16 | -0.295626 | 0.739098 | 1.995247 | 6.983364e+10 | 2.586842e+10 | 1.256149 |
QUERY = """
SELECT
to_timestamp(height_to_unix(m.height)) as timestamp,
m.from,
m.gas_fee_cap,
m.method,
m.to
FROM messages m
WHERE
to_timestamp(height_to_unix(m.height)) BETWEEN '2021-06-02' AND '2021-06-05'
"""
messages = (pd.read_sql(QUERY, connection))
When examining the data, we developed the following two questions:
Workflow:
1. Verify sampling intervals
2. Verify distributions. If not normal, poisson, etc
To answer these questions, we will calculate the timestamp difference and create a histogram of the time differences and determine if we have equal time sampling or not.
messages['time'] = messages['timestamp'].apply(lambda x: x.value)
time_analysis(messages,'time')
messages.describe()
| gas_fee_cap | method | time | timestampDiff | |
|---|---|---|---|---|
| count | 4.644615e+06 | 4.644615e+06 | 4.644615e+06 | 4.644615e+06 |
| mean | 7.670292e+09 | 6.318362e+00 | 1.622721e+18 | 2.240659e+07 |
| std | 8.734661e+10 | 1.078328e+00 | 7.637262e+13 | 3.439053e+11 |
| min | 1.000000e+02 | 0.000000e+00 | 1.622592e+18 | -1.738800e+14 |
| 25% | 9.399679e+06 | 6.000000e+00 | 1.622653e+18 | 0.000000e+00 |
| 50% | 1.926023e+09 | 6.000000e+00 | 1.622722e+18 | 0.000000e+00 |
| 75% | 5.000000e+09 | 7.000000e+00 | 1.622788e+18 | 0.000000e+00 |
| max | 1.170783e+14 | 2.300000e+01 | 1.622851e+18 | 1.738800e+14 |
messages['method'].value_counts()
6 2197377 7 2173655 5 170165 0 85902 2 10074 11 3792 4 1653 16 1402 3 337 9 136 23 58 20 28 18 17 21 14 8 4 22 1 Name: method, dtype: int64
Data is method id crossed with actor id. We don't know what they respresent. We need to blow out to understand, this is overly flat. Need two separate keys, one for method, one for actor.
Below is currently all we have to go on:
https://github.com/filecoin-project/specs-actors/tree/master/actors/builtin
messages['method'].hist()
<AxesSubplot:>
If this lookup table is correct, the vast majority of transactions are 6,7 and 5; which are RemoveSigner, SwapSigner, and AddSigner, respectively.
messages['from'].value_counts()
f3qcmmkbobbp6ed4psyvny6zsia5v32dlxnvpfgxsvpjtaptjyuapmd3i5zr2353fqe7a2kowceis65iyjzsoq 88709
f3vqd3cenprn6xdt73igrjukq5a7nh5rgjgajw5iev6snhv76o2sqmlgzbvq4vyje5ulrjriicsln6tz3xgimq 68142
f3ucq7fmnfoa3jsum7qjoeyz2gflwdcq4g44eiojll6lnlqe7wbx24tjvg5v4zfniwjk6cuo2l3mceq2we6kea 63760
f3sfemh6sz2zkrei23ra4fng4kjqr5tek4bleyxbrvcyndxvutmep27orixnjunm5cwqq25x4xlbup3jqbt3ua 52469
f3q2crv5dhkobq7y7fzgmfot7dtxbwe26r6wzp7ny43f5233tdzvzabdup2knjc46g6ogfi5zesn34byxhjaha 51858
...
f1etek4anvon2oby5smufuwy6ptlab3bva4pprpwi 1
f1sn2xg6yil5cht3pyftbgkxb7khz7bvhvozkzzri 1
f14ll6y5xuhdkddzzzjnxwoeghzxj5qteykb5nsda 1
f1zlba45ayd4d5gyyhw3jbw5tqpfwjbl7u25ucfrq 1
f1bwhjiifl77szahorzvigsqxano4t53dlszddevq 1
Name: from, Length: 33612, dtype: int64
messages['to'].value_counts()
f0755327 88856
f0764901 88802
f0688165 74596
f0463143 68439
f0724216 66924
...
f1o4vuaoekmcimfshxpzieln2vg6zuog74fbwn5wi 1
f17ijzaycegynkvttqvwjwwrcfn5h4bvy22tzljha 1
f1r6ju4dm7563a3hrqfd2oqvnce7sycyd3sy35yti 1
f13q7ecgqj32dyrggup74x5i4brirsxexfujyo2ai 1
f1zidvendbbjpp42exjfigdqfzdrzgkvjkxgxut5i 1
Name: to, Length: 37333, dtype: int64
messages['gas_fee_cap'] = messages['gas_fee_cap'].astype(float)
messages.plot(x='timestamp',y='gas_fee_cap')
<AxesSubplot:xlabel='timestamp'>
We will continue to focus on the derived_gas_outputs table with SQL queries to understand the why behind transactions as we do not have actor information easily accessible from the messages table.
message_gas_economy.describe()
| base_fee | base_fee_change_log | gas_capacity_ratio | gas_fill_ratio | gas_limit_total | gas_limit_unique_total | gas_waste_ratio | |
|---|---|---|---|---|---|---|---|
| count | 8.580000e+03 | 8580.000000 | 8580.000000 | 8580.000000 | 8.580000e+03 | 8.580000e+03 | 8580.000000 |
| mean | 1.474750e-10 | 0.000378 | 1.008772 | 1.966365 | 4.784484e+10 | 2.117030e+10 | 0.957592 |
| std | 2.446596e-10 | 0.386090 | 0.372284 | 0.080264 | 2.162609e+10 | 5.598819e+09 | 0.366611 |
| min | 1.000000e-16 | -0.827117 | 0.257397 | 0.526751 | 3.227862e+09 | 3.227862e+09 | 0.000000 |
| 25% | 9.066125e-14 | -0.285272 | 0.733050 | 1.975605 | 2.994499e+10 | 1.774505e+10 | 0.758082 |
| 50% | 1.523809e-11 | -0.057982 | 0.941155 | 1.988402 | 4.886860e+10 | 2.093772e+10 | 1.022318 |
| 75% | 2.322379e-10 | 0.219020 | 1.212218 | 1.994668 | 5.976858e+10 | 2.428649e+10 | 1.227833 |
| max | 1.961212e-09 | 1.000000 | 2.000000 | 2.000000 | 1.392380e+11 | 6.030551e+10 | 1.719983 |
message_gas_economy, decomposed_base_fee = fourier_transform(message_gas_economy,'base_fee',10)
Fourier Transform of base_fee with 10 components.
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
message_gas_economy, decomposed_base_fee_change_log = fourier_transform(message_gas_economy,'base_fee_change_log',10)
Fourier Transform of base_fee_change_log with 10 components.
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
message_gas_economy, decomposed_gas_capacity_ratio = fourier_transform(message_gas_economy,'gas_capacity_ratio',10)
Fourier Transform of gas_capacity_ratio with 10 components.
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
message_gas_economy, decomposed_gas_fill_ratio = fourier_transform(message_gas_economy,'gas_fill_ratio',10)
Fourier Transform of gas_fill_ratio with 10 components.
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
message_gas_economy, decomposed_gas_limit_total = fourier_transform(message_gas_economy,'gas_limit_total',10)
Fourier Transform of gas_limit_total with 10 components.
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
message_gas_economy, decomposed_gas_limit_unique_total = fourier_transform(message_gas_economy,'gas_limit_unique_total',10)
Fourier Transform of gas_limit_unique_total with 10 components.
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
message_gas_economy, decomposed_gas_waste_ratio = fourier_transform(message_gas_economy,'gas_waste_ratio',10)
Fourier Transform of gas_waste_ratio with 10 components.
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
/opt/anaconda3/lib/python3.8/site-packages/numpy/core/_asarray.py:83: ComplexWarning: Casting complex values to real discards the imaginary part return array(a, dtype, copy=False, order=order)
https://github.com/filecoin-project/sentinel/blob/master/docs/db.md
chain_economics¶Economic summaries per state root CID.
| Name | Type | Nullable | Description |
|---|---|---|---|
burnt_fil |
text |
NO | Total FIL (attoFIL) burned as part of penalties and on-chain computations. |
circulating_fil |
text |
NO | The amount of FIL (attoFIL) circulating and tradeable in the economy. The basis for Market Cap calculations. |
locked_fil |
text |
NO | The amount of FIL (attoFIL) locked as part of mining, deals, and other mechanisms. |
mined_fil |
text |
NO | The amount of FIL (attoFIL) that has been mined by storage miners. |
parent_state_root |
text |
NO | CID of the parent state root. |
vested_fil |
text |
NO | Total amount of FIL (attoFIL) that is vested from genesis allocation. |
chain_powers¶Power summaries from the Power actor.
| Name | Type | Nullable | Description |
|---|---|---|---|
height |
bigint |
NO | Epoch this power summary applies to. |
miner_count |
bigint |
YES | Total number of miners. |
participating_miner_count |
bigint |
YES | Total number of miners with power above the minimum miner threshold. |
qa_smoothed_position_estimate |
text |
NO | Total power smoothed position estimate - Alpha Beta Filter "position" (value) estimate in Q.128 format. |
qa_smoothed_velocity_estimate |
text |
NO | Total power smoothed velocity estimate - Alpha Beta Filter "velocity" (rate of change of value) estimate in Q.128 format. |
state_root |
text |
NO | CID of the parent state root. |
total_pledge_collateral |
text |
NO | Total locked FIL (attoFIL) miners have pledged as collateral in order to participate in the economy. |
total_qa_bytes_committed |
text |
NO | Total provably committed, quality adjusted storage power in bytes. Quality adjusted power is a weighted average of the quality of its space and it is based on the size, duration and quality of its deals. |
total_qa_bytes_power |
text |
NO | Total quality adjusted storage power in bytes in the network. Quality adjusted power is a weighted average of the quality of its space and it is based on the size, duration and quality of its deals. |
total_raw_bytes_committed |
text |
NO | Total provably committed storage power in bytes. Raw byte power is the size of a sector in bytes. |
total_raw_bytes_power |
text |
NO | Total storage power in bytes in the network. Raw byte power is the size of a sector in bytes. |
chain_rewards¶Reward summaries from the Reward actor.
| Name | Type | Nullable | Description |
|---|---|---|---|
cum_sum_baseline |
text |
NO | Target that CumsumRealized needs to reach for EffectiveNetworkTime to increase. It is measured in byte-epochs (space * time) representing power committed to the network for some duration. |
cum_sum_realized |
text |
NO | Cumulative sum of network power capped by BaselinePower(epoch). It is measured in byte-epochs (space * time) representing power committed to the network for some duration. |
effective_baseline_power |
text |
NO | The baseline power (in bytes) at the EffectiveNetworkTime epoch. |
effective_network_time |
bigint |
YES | Ceiling of real effective network time "theta" based on CumsumBaselinePower(theta) == CumsumRealizedPower. Theta captures the notion of how much the network has progressed in its baseline and in advancing network time. |
height |
bigint |
NO | Epoch this rewards summary applies to. |
new_baseline_power |
text |
NO | The baseline power (in bytes) the network is targeting. |
new_reward |
text |
YES | The reward to be paid in per WinCount to block producers. The actual reward total paid out depends on the number of winners in any round. This value is recomputed every non-null epoch and used in the next non-null epoch. |
new_reward_smoothed_position_estimate |
text |
NO | Smoothed reward position estimate - Alpha Beta Filter "position" (value) estimate in Q.128 format. |
new_reward_smoothed_velocity_estimate |
text |
NO | Smoothed reward velocity estimate - Alpha Beta Filter "velocity" (rate of change of value) estimate in Q.128 format. |
state_root |
text |
NO | CID of the parent state root. |
total_mined_reward |
text |
NO | The total FIL (attoFIL) awarded to block miners. |
QUERY = """
SELECT
to_timestamp(height_to_unix(cr.height)) as timestamp,
cr.cum_sum_baseline,
cr.cum_sum_realized,
cr.effective_baseline_power,
cr.effective_network_time,
cr.new_baseline_power,
cr.new_reward,
cr.new_reward_smoothed_position_estimate,
cr.new_reward_smoothed_velocity_estimate,
cr.total_mined_reward,
cp.miner_count,
cp.participating_miner_count,
cp.qa_smoothed_position_estimate,
cp.qa_smoothed_velocity_estimate,
cp.state_root,
cp.total_pledge_collateral,
cp.total_qa_bytes_committed,
cp.total_qa_bytes_power,
cp.total_raw_bytes_committed,
cp.total_raw_bytes_power,
ce.burnt_fil,
ce.circulating_fil,
ce.locked_fil,
ce.mined_fil,
ce.vested_fil
FROM chain_rewards cr
LEFT JOIN chain_powers cp
ON cr.state_root = cp.state_root
LEFT JOIN chain_economics ce
ON cr.state_root = ce.parent_state_root
WHERE
to_timestamp(height_to_unix(cr.height)) BETWEEN '2021-06-01' AND '2021-07-01'
"""
chain_economics = (pd.read_sql(QUERY, connection))
chain_economics[['cum_sum_baseline', 'cum_sum_realized',
'effective_baseline_power', 'effective_network_time',
'new_baseline_power','new_reward_smoothed_position_estimate',
'new_reward_smoothed_velocity_estimate', 'total_mined_reward',
'miner_count', 'participating_miner_count',
'qa_smoothed_position_estimate','qa_smoothed_velocity_estimate','total_pledge_collateral', 'total_qa_bytes_committed',
'total_qa_bytes_power', 'total_raw_bytes_committed',
'total_raw_bytes_power', 'burnt_fil', 'circulating_fil', 'locked_fil',
'mined_fil', 'vested_fil']] = chain_economics[['cum_sum_baseline', 'cum_sum_realized',
'effective_baseline_power', 'effective_network_time',
'new_baseline_power','new_reward_smoothed_position_estimate',
'new_reward_smoothed_velocity_estimate', 'total_mined_reward',
'miner_count', 'participating_miner_count',
'qa_smoothed_position_estimate','qa_smoothed_velocity_estimate', 'total_pledge_collateral', 'total_qa_bytes_committed',
'total_qa_bytes_power', 'total_raw_bytes_committed',
'total_raw_bytes_power', 'burnt_fil', 'circulating_fil', 'locked_fil',
'mined_fil', 'vested_fil']].astype(float)
chain_economics.describe()
| cum_sum_baseline | cum_sum_realized | effective_baseline_power | effective_network_time | new_baseline_power | new_reward | new_reward_smoothed_position_estimate | new_reward_smoothed_velocity_estimate | total_mined_reward | miner_count | ... | total_pledge_collateral | total_qa_bytes_committed | total_qa_bytes_power | total_raw_bytes_committed | total_raw_bytes_power | burnt_fil | circulating_fil | locked_fil | mined_fil | vested_fil | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 85259.000000 | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 85259.000000 | ... | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 | 8.525900e+04 |
| mean | 2.117221e+24 | 2.117219e+24 | 4.284956e+18 | 597601.800772 | 5.059368e+18 | 1.264016e+20 | 4.301223e+58 | -9.164505e+51 | 7.589834e+25 | 541555.566146 | ... | 8.272870e+25 | 7.396019e+18 | 7.395577e+18 | 7.393683e+18 | 7.393252e+18 | 2.646491e+25 | 1.350217e+26 | 8.273785e+25 | 7.589834e+25 | 1.512595e+26 |
| std | 1.258826e+23 | 1.258826e+23 | 8.300527e+16 | 29376.941196 | 8.300524e+16 | 6.686428e+17 | 2.275268e+56 | 1.384736e+50 | 3.085544e+24 | 468.881553 | ... | 2.469818e+24 | 3.621160e+17 | 3.621347e+17 | 3.619564e+17 | 3.619715e+17 | 2.952578e+23 | 3.479301e+24 | 2.470447e+24 | 3.085544e+24 | 3.153654e+24 |
| min | 1.901761e+24 | 1.901758e+24 | 4.142884e+18 | 546751.000000 | 4.917297e+18 | 1.252452e+20 | 4.261871e+58 | -9.407656e+51 | 7.054874e+25 | 541144.000000 | ... | 7.830897e+25 | 6.721132e+18 | 6.720618e+18 | 6.719005e+18 | 6.718506e+18 | 2.604027e+25 | 1.290679e+26 | 7.831719e+25 | 7.054874e+25 | 1.458100e+26 |
| 25% | 2.008047e+24 | 2.008046e+24 | 4.212968e+18 | 572191.500000 | 4.987381e+18 | 1.258254e+20 | 4.281616e+58 | -9.283836e+51 | 7.322973e+25 | 541366.000000 | ... | 8.061695e+25 | 7.109558e+18 | 7.109093e+18 | 7.107348e+18 | 7.106899e+18 | 2.613655e+25 | 1.320648e+26 | 8.062548e+25 | 7.322973e+25 | 1.485305e+26 |
| 50% | 2.115896e+24 | 2.115894e+24 | 4.284082e+18 | 597577.000000 | 5.058495e+18 | 1.263982e+20 | 4.301104e+58 | -9.162910e+51 | 7.589920e+25 | 541488.000000 | ... | 8.279218e+25 | 7.407435e+18 | 7.407039e+18 | 7.405115e+18 | 7.404737e+18 | 2.647754e+25 | 1.349388e+26 | 8.280132e+25 | 7.589920e+25 | 1.512521e+26 |
| 75% | 2.225168e+24 | 2.225168e+24 | 4.356134e+18 | 622871.500000 | 5.130548e+18 | 1.269790e+20 | 4.320868e+58 | -9.044957e+51 | 7.855009e+25 | 541575.000000 | ... | 8.486375e+25 | 7.703864e+18 | 7.703419e+18 | 7.701365e+18 | 7.700921e+18 | 2.676042e+25 | 1.379530e+26 | 8.487347e+25 | 7.855009e+25 | 1.539710e+26 |
| max | 2.338950e+24 | 2.338948e+24 | 4.431161e+18 | 648769.000000 | 5.205574e+18 | 1.275672e+20 | 4.340886e+58 | -8.926758e+51 | 8.125866e+25 | 544363.000000 | ... | 8.679158e+25 | 7.992995e+18 | 7.992564e+18 | 7.990300e+18 | 7.989885e+18 | 2.685054e+25 | 1.414348e+26 | 8.680170e+25 | 8.125866e+25 | 1.567617e+26 |
8 rows × 23 columns
chain_economics.fillna(0,inplace=True)
chain_economics['time'] = chain_economics['timestamp'].apply(lambda x: x.value)
time_analysis(chain_economics,'time')
timestamps = chain_economics.timestamp.values
del chain_economics['timestamp']
del chain_economics['state_root']
del chain_economics['timestampDiff']
chain_economics.hist(bins=30, figsize=(15, 10))
array([[<AxesSubplot:title={'center':'cum_sum_baseline'}>,
<AxesSubplot:title={'center':'cum_sum_realized'}>,
<AxesSubplot:title={'center':'effective_baseline_power'}>,
<AxesSubplot:title={'center':'effective_network_time'}>,
<AxesSubplot:title={'center':'new_baseline_power'}>],
[<AxesSubplot:title={'center':'new_reward'}>,
<AxesSubplot:title={'center':'new_reward_smoothed_position_estimate'}>,
<AxesSubplot:title={'center':'new_reward_smoothed_velocity_estimate'}>,
<AxesSubplot:title={'center':'total_mined_reward'}>,
<AxesSubplot:title={'center':'miner_count'}>],
[<AxesSubplot:title={'center':'participating_miner_count'}>,
<AxesSubplot:title={'center':'qa_smoothed_position_estimate'}>,
<AxesSubplot:title={'center':'qa_smoothed_velocity_estimate'}>,
<AxesSubplot:title={'center':'total_pledge_collateral'}>,
<AxesSubplot:title={'center':'total_qa_bytes_committed'}>],
[<AxesSubplot:title={'center':'total_qa_bytes_power'}>,
<AxesSubplot:title={'center':'total_raw_bytes_committed'}>,
<AxesSubplot:title={'center':'total_raw_bytes_power'}>,
<AxesSubplot:title={'center':'burnt_fil'}>,
<AxesSubplot:title={'center':'circulating_fil'}>],
[<AxesSubplot:title={'center':'locked_fil'}>,
<AxesSubplot:title={'center':'mined_fil'}>,
<AxesSubplot:title={'center':'vested_fil'}>,
<AxesSubplot:title={'center':'time'}>, <AxesSubplot:>]],
dtype=object)
# normally distribute
log_differenced = pd.DataFrame()
## Difference and log values
for i in chain_economics.columns:
try:
log_differenced[i +'_log_differenced'] = np.log(chain_economics[i]).diff()
except:
print('Error with:{}'.format(i))
/opt/anaconda3/lib/python3.8/site-packages/pandas/core/arraylike.py:364: RuntimeWarning: invalid value encountered in log result = getattr(ufunc, method)(*inputs, **kwargs)
# replace any NA values with zero
log_differenced.fillna(0,inplace=True)
log_differenced.hist(bins=30, figsize=(15, 10))
array([[<AxesSubplot:title={'center':'cum_sum_baseline_log_differenced'}>,
<AxesSubplot:title={'center':'cum_sum_realized_log_differenced'}>,
<AxesSubplot:title={'center':'effective_baseline_power_log_differenced'}>,
<AxesSubplot:title={'center':'effective_network_time_log_differenced'}>,
<AxesSubplot:title={'center':'new_baseline_power_log_differenced'}>],
[<AxesSubplot:title={'center':'new_reward_log_differenced'}>,
<AxesSubplot:title={'center':'new_reward_smoothed_position_estimate_log_differenced'}>,
<AxesSubplot:title={'center':'new_reward_smoothed_velocity_estimate_log_differenced'}>,
<AxesSubplot:title={'center':'total_mined_reward_log_differenced'}>,
<AxesSubplot:title={'center':'miner_count_log_differenced'}>],
[<AxesSubplot:title={'center':'participating_miner_count_log_differenced'}>,
<AxesSubplot:title={'center':'qa_smoothed_position_estimate_log_differenced'}>,
<AxesSubplot:title={'center':'qa_smoothed_velocity_estimate_log_differenced'}>,
<AxesSubplot:title={'center':'total_pledge_collateral_log_differenced'}>,
<AxesSubplot:title={'center':'total_qa_bytes_committed_log_differenced'}>],
[<AxesSubplot:title={'center':'total_qa_bytes_power_log_differenced'}>,
<AxesSubplot:title={'center':'total_raw_bytes_committed_log_differenced'}>,
<AxesSubplot:title={'center':'total_raw_bytes_power_log_differenced'}>,
<AxesSubplot:title={'center':'burnt_fil_log_differenced'}>,
<AxesSubplot:title={'center':'circulating_fil_log_differenced'}>],
[<AxesSubplot:title={'center':'locked_fil_log_differenced'}>,
<AxesSubplot:title={'center':'mined_fil_log_differenced'}>,
<AxesSubplot:title={'center':'vested_fil_log_differenced'}>,
<AxesSubplot:title={'center':'time_log_differenced'}>,
<AxesSubplot:>]], dtype=object)
As a final check prior to modeling, we will run the Augmented Dickey-Fuller test to ensure that our data is stationary (non-unit root - A unit root is a stochastic trend in a time series). The test's hypothesis are:
for i in log_differenced.columns:
print(i)
result = adfuller(log_differenced[i].values)
print('ADF Statistic: %f' % result[0])
print('p-value: %f' % result[1])
if result[1] > 0.05:
decision = "fail to reject - unit root present"
else:
decision = "reject, no unit root present"
print(decision)
print('----------------------------------')
cum_sum_baseline_log_differenced ADF Statistic: -42.616286 p-value: 0.000000 reject, no unit root present ---------------------------------- cum_sum_realized_log_differenced ADF Statistic: -42.616288 p-value: 0.000000 reject, no unit root present ---------------------------------- effective_baseline_power_log_differenced ADF Statistic: -42.756111 p-value: 0.000000 reject, no unit root present ---------------------------------- effective_network_time_log_differenced ADF Statistic: -42.584411 p-value: 0.000000 reject, no unit root present ---------------------------------- new_baseline_power_log_differenced ADF Statistic: -42.766353 p-value: 0.000000 reject, no unit root present ---------------------------------- new_reward_log_differenced ADF Statistic: -42.732455 p-value: 0.000000 reject, no unit root present ---------------------------------- new_reward_smoothed_position_estimate_log_differenced ADF Statistic: -42.732460 p-value: 0.000000 reject, no unit root present ---------------------------------- new_reward_smoothed_velocity_estimate_log_differenced
/opt/anaconda3/lib/python3.8/site-packages/statsmodels/regression/linear_model.py:903: RuntimeWarning: divide by zero encountered in log llf = -nobs2*np.log(2*np.pi) - nobs2*np.log(ssr / nobs) - nobs2
ADF Statistic: nan p-value: nan reject, no unit root present ---------------------------------- total_mined_reward_log_differenced ADF Statistic: -42.598322 p-value: 0.000000 reject, no unit root present ---------------------------------- miner_count_log_differenced ADF Statistic: -43.960423 p-value: 0.000000 reject, no unit root present ---------------------------------- participating_miner_count_log_differenced ADF Statistic: -41.754532 p-value: 0.000000 reject, no unit root present ---------------------------------- qa_smoothed_position_estimate_log_differenced ADF Statistic: -41.972755 p-value: 0.000000 reject, no unit root present ---------------------------------- qa_smoothed_velocity_estimate_log_differenced ADF Statistic: -29.128841 p-value: 0.000000 reject, no unit root present ---------------------------------- total_pledge_collateral_log_differenced ADF Statistic: -42.422216 p-value: 0.000000 reject, no unit root present ---------------------------------- total_qa_bytes_committed_log_differenced ADF Statistic: -41.957639 p-value: 0.000000 reject, no unit root present ---------------------------------- total_qa_bytes_power_log_differenced ADF Statistic: -41.957249 p-value: 0.000000 reject, no unit root present ---------------------------------- total_raw_bytes_committed_log_differenced ADF Statistic: -41.957256 p-value: 0.000000 reject, no unit root present ---------------------------------- total_raw_bytes_power_log_differenced ADF Statistic: -41.956858 p-value: 0.000000 reject, no unit root present ---------------------------------- burnt_fil_log_differenced ADF Statistic: -41.641283 p-value: 0.000000 reject, no unit root present ---------------------------------- circulating_fil_log_differenced ADF Statistic: -42.880082 p-value: 0.000000 reject, no unit root present ---------------------------------- locked_fil_log_differenced ADF Statistic: -42.422274 p-value: 0.000000 reject, no unit root present ---------------------------------- mined_fil_log_differenced ADF Statistic: -42.598322 p-value: 0.000000 reject, no unit root present ---------------------------------- vested_fil_log_differenced ADF Statistic: -42.694020 p-value: 0.000000 reject, no unit root present ---------------------------------- time_log_differenced ADF Statistic: -42.764751 p-value: 0.000000 reject, no unit root present ----------------------------------
# removed several columns because of VAR errors
log_differenced_subset = log_differenced[['cum_sum_baseline_log_differenced', 'cum_sum_realized_log_differenced',
'effective_baseline_power_log_differenced','effective_network_time_log_differenced',
'new_baseline_power_log_differenced','total_mined_reward_log_differenced',
'miner_count_log_differenced','participating_miner_count_log_differenced',
'qa_smoothed_position_estimate_log_differenced','qa_smoothed_velocity_estimate_log_differenced',
'total_pledge_collateral_log_differenced','total_qa_bytes_committed_log_differenced',
'total_qa_bytes_power_log_differenced','total_raw_bytes_committed_log_differenced',
'total_raw_bytes_power_log_differenced','burnt_fil_log_differenced','circulating_fil_log_differenced',
'locked_fil_log_differenced','vested_fil_log_differenced']]
# var model
aic = []
for i in range(1,16):
model = VAR(log_differenced_subset)
results = model.fit(i)
aic.append(results.aic)
plt.figure(figsize=(10, 8))
plt.plot(aic, 'r+')
plt.legend(['AIC'])
plt.xlabel('Autocorrelation Lag')
plt.ylabel('AIC')
plt.title('Plot of sweeps over lag depths over AIC Loss function')
plt.show()
# instantiate the var model object from statsmodels
model = VAR(log_differenced_subset)
# fit model with determined lag values
results = model.fit(4)
results.summary()
Summary of Regression Results
==================================
Model: VAR
Method: OLS
Date: Mon, 09, Aug, 2021
Time: 14:43:23
--------------------------------------------------------------------
No. of Equations: 19.0000 BIC: -481.427
Nobs: 85255.0 HQIC: -481.538
Log likelihood: 1.82319e+07 FPE: 7.06629e-210
AIC: -481.588 Det(Omega_mle): 6.94285e-210
--------------------------------------------------------------------
Results for equation cum_sum_baseline_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000017 0.009 0.993
L1.cum_sum_baseline_log_differenced 14599.097968 4839.103413 3.017 0.003
L1.cum_sum_realized_log_differenced -123.598688 588.423076 -0.210 0.834
L1.effective_baseline_power_log_differenced -8285.051948 2406.932943 -3.442 0.001
L1.effective_network_time_log_differenced -14333.636188 5107.361547 -2.806 0.005
L1.new_baseline_power_log_differenced 119.627556 2136.697713 0.056 0.955
L1.total_mined_reward_log_differenced 121.101608 53.555185 2.261 0.024
L1.miner_count_log_differenced 0.876370 0.461036 1.901 0.057
L1.participating_miner_count_log_differenced 0.930315 0.113096 8.226 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.640999 0.267535 2.396 0.017
L1.qa_smoothed_velocity_estimate_log_differenced -0.004605 0.001568 -2.937 0.003
L1.total_pledge_collateral_log_differenced -9351.582277 1547.196992 -6.044 0.000
L1.total_qa_bytes_committed_log_differenced -4314.853324 749.409735 -5.758 0.000
L1.total_qa_bytes_power_log_differenced 3605.840936 743.479677 4.850 0.000
L1.total_raw_bytes_committed_log_differenced 4654.694709 750.757738 6.200 0.000
L1.total_raw_bytes_power_log_differenced -3945.521406 744.706335 -5.298 0.000
L1.burnt_fil_log_differenced -33.931504 19.562884 -1.734 0.083
L1.circulating_fil_log_differenced -167.878640 99.572478 -1.686 0.092
L1.locked_fil_log_differenced 9252.364886 1527.802464 6.056 0.000
L1.vested_fil_log_differenced 229.708705 245.645923 0.935 0.350
L2.cum_sum_baseline_log_differenced 34226.982592 5107.084992 6.702 0.000
L2.cum_sum_realized_log_differenced 72.798849 631.626773 0.115 0.908
L2.effective_baseline_power_log_differenced -19064.653319 2526.175573 -7.547 0.000
L2.effective_network_time_log_differenced -33895.468189 5402.357139 -6.274 0.000
L2.new_baseline_power_log_differenced -367.726755 2303.349059 -0.160 0.873
L2.total_mined_reward_log_differenced -36.486894 53.496523 -0.682 0.495
L2.miner_count_log_differenced 0.230174 0.461428 0.499 0.618
L2.participating_miner_count_log_differenced 0.398151 0.113089 3.521 0.000
L2.qa_smoothed_position_estimate_log_differenced 1.200750 0.267062 4.496 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.001365 0.001599 0.854 0.393
L2.total_pledge_collateral_log_differenced -7251.986652 1551.410061 -4.674 0.000
L2.total_qa_bytes_committed_log_differenced -3463.036188 750.661462 -4.613 0.000
L2.total_qa_bytes_power_log_differenced 2839.643858 744.406268 3.815 0.000
L2.total_raw_bytes_committed_log_differenced 3334.555543 751.702089 4.436 0.000
L2.total_raw_bytes_power_log_differenced -2712.185030 745.334905 -3.639 0.000
L2.burnt_fil_log_differenced 28.386030 19.546396 1.452 0.146
L2.circulating_fil_log_differenced 122.616224 99.484551 1.233 0.218
L2.locked_fil_log_differenced 7332.953915 1532.062911 4.786 0.000
L2.vested_fil_log_differenced -143.829167 289.487250 -0.497 0.619
L3.cum_sum_baseline_log_differenced 3131.522359 5102.495723 0.614 0.539
L3.cum_sum_realized_log_differenced 13.760471 631.446520 0.022 0.983
L3.effective_baseline_power_log_differenced -1705.910101 2527.783705 -0.675 0.500
L3.effective_network_time_log_differenced -3085.106865 5396.579369 -0.572 0.568
L3.new_baseline_power_log_differenced 58.070452 2302.427361 0.025 0.980
L3.total_mined_reward_log_differenced 105.499706 53.457272 1.974 0.048
L3.miner_count_log_differenced 0.624708 0.461671 1.353 0.176
L3.participating_miner_count_log_differenced -0.097219 0.113100 -0.860 0.390
L3.qa_smoothed_position_estimate_log_differenced -0.422182 0.267066 -1.581 0.114
L3.qa_smoothed_velocity_estimate_log_differenced 0.003498 0.001599 2.188 0.029
L3.total_pledge_collateral_log_differenced 273.899747 1551.316327 0.177 0.860
L3.total_qa_bytes_committed_log_differenced -203.071863 750.228669 -0.271 0.787
L3.total_qa_bytes_power_log_differenced 56.794830 744.002187 0.076 0.939
L3.total_raw_bytes_committed_log_differenced -180.692848 751.215298 -0.241 0.810
L3.total_raw_bytes_power_log_differenced 327.581860 744.876326 0.440 0.660
L3.burnt_fil_log_differenced -48.681078 19.534968 -2.492 0.013
L3.circulating_fil_log_differenced -250.965646 99.426031 -2.524 0.012
L3.locked_fil_log_differenced -421.973383 1531.959515 -0.275 0.783
L3.vested_fil_log_differenced 181.855653 289.275637 0.629 0.530
L4.cum_sum_baseline_log_differenced 5545.585682 4826.249611 1.149 0.251
L4.cum_sum_realized_log_differenced 93.362686 588.367403 0.159 0.874
L4.effective_baseline_power_log_differenced -2602.798549 2405.273392 -1.082 0.279
L4.effective_network_time_log_differenced -5647.126730 5093.262655 -1.109 0.268
L4.new_baseline_power_log_differenced -536.325802 2135.974758 -0.251 0.802
L4.total_mined_reward_log_differenced 346.598805 53.493301 6.479 0.000
L4.miner_count_log_differenced 1.760502 0.461637 3.814 0.000
L4.participating_miner_count_log_differenced 0.348774 0.113032 3.086 0.002
L4.qa_smoothed_position_estimate_log_differenced -1.290534 0.266758 -4.838 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.001023 0.001565 0.654 0.513
L4.total_pledge_collateral_log_differenced -4763.168125 1549.931696 -3.073 0.002
L4.total_qa_bytes_committed_log_differenced 565.638427 748.384788 0.756 0.450
L4.total_qa_bytes_power_log_differenced -1117.379038 742.347155 -1.505 0.132
L4.total_raw_bytes_committed_log_differenced -367.187415 749.455270 -0.490 0.624
L4.total_raw_bytes_power_log_differenced 918.202465 743.303132 1.235 0.217
L4.burnt_fil_log_differenced -120.139694 19.557992 -6.143 0.000
L4.circulating_fil_log_differenced -620.856480 99.535641 -6.238 0.000
L4.locked_fil_log_differenced 4397.979460 1530.515890 2.874 0.004
L4.vested_fil_log_differenced 748.795137 244.516792 3.062 0.002
===================================================================================================================
Results for equation cum_sum_realized_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000017 0.009 0.993
L1.cum_sum_baseline_log_differenced 14600.152315 4839.106315 3.017 0.003
L1.cum_sum_realized_log_differenced -124.242445 588.423428 -0.211 0.833
L1.effective_baseline_power_log_differenced -8285.112424 2406.934387 -3.442 0.001
L1.effective_network_time_log_differenced -14334.042446 5107.364611 -2.807 0.005
L1.new_baseline_power_log_differenced 119.457368 2136.698995 0.056 0.955
L1.total_mined_reward_log_differenced 121.107742 53.555217 2.261 0.024
L1.miner_count_log_differenced 0.876420 0.461037 1.901 0.057
L1.participating_miner_count_log_differenced 0.930315 0.113096 8.226 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.640969 0.267535 2.396 0.017
L1.qa_smoothed_velocity_estimate_log_differenced -0.004605 0.001568 -2.937 0.003
L1.total_pledge_collateral_log_differenced -9351.489385 1547.197920 -6.044 0.000
L1.total_qa_bytes_committed_log_differenced -4314.809969 749.410184 -5.758 0.000
L1.total_qa_bytes_power_log_differenced 3605.804405 743.480123 4.850 0.000
L1.total_raw_bytes_committed_log_differenced 4654.650064 750.758188 6.200 0.000
L1.total_raw_bytes_power_log_differenced -3945.483575 744.706782 -5.298 0.000
L1.burnt_fil_log_differenced -33.933340 19.562895 -1.735 0.083
L1.circulating_fil_log_differenced -167.888765 99.572537 -1.686 0.092
L1.locked_fil_log_differenced 9252.265977 1527.803380 6.056 0.000
L1.vested_fil_log_differenced 229.695541 245.646070 0.935 0.350
L2.cum_sum_baseline_log_differenced 34223.075124 5107.088055 6.701 0.000
L2.cum_sum_realized_log_differenced 71.092829 631.627152 0.113 0.910
L2.effective_baseline_power_log_differenced -19064.876233 2526.177088 -7.547 0.000
L2.effective_network_time_log_differenced -33889.850002 5402.360380 -6.273 0.000
L2.new_baseline_power_log_differenced -363.947513 2303.350441 -0.158 0.874
L2.total_mined_reward_log_differenced -36.495658 53.496555 -0.682 0.495
L2.miner_count_log_differenced 0.230187 0.461429 0.499 0.618
L2.participating_miner_count_log_differenced 0.398137 0.113089 3.521 0.000
L2.qa_smoothed_position_estimate_log_differenced 1.200779 0.267062 4.496 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.001365 0.001599 0.854 0.393
L2.total_pledge_collateral_log_differenced -7251.745681 1551.410992 -4.674 0.000
L2.total_qa_bytes_committed_log_differenced -3463.003617 750.661913 -4.613 0.000
L2.total_qa_bytes_power_log_differenced 2839.608888 744.406714 3.815 0.000
L2.total_raw_bytes_committed_log_differenced 3334.537404 751.702540 4.436 0.000
L2.total_raw_bytes_power_log_differenced -2712.164509 745.335352 -3.639 0.000
L2.burnt_fil_log_differenced 28.389370 19.546408 1.452 0.146
L2.circulating_fil_log_differenced 122.633425 99.484611 1.233 0.218
L2.locked_fil_log_differenced 7332.723451 1532.063830 4.786 0.000
L2.vested_fil_log_differenced -143.849224 289.487423 -0.497 0.619
L3.cum_sum_baseline_log_differenced 3126.114691 5102.498783 0.613 0.540
L3.cum_sum_realized_log_differenced 11.597284 631.446899 0.018 0.985
L3.effective_baseline_power_log_differenced -1706.549243 2527.785221 -0.675 0.500
L3.effective_network_time_log_differenced -3077.528779 5396.582606 -0.570 0.568
L3.new_baseline_power_log_differenced 63.526648 2302.428742 0.028 0.978
L3.total_mined_reward_log_differenced 105.505659 53.457304 1.974 0.048
L3.miner_count_log_differenced 0.624688 0.461671 1.353 0.176
L3.participating_miner_count_log_differenced -0.097201 0.113100 -0.859 0.390
L3.qa_smoothed_position_estimate_log_differenced -0.422100 0.267066 -1.581 0.114
L3.qa_smoothed_velocity_estimate_log_differenced 0.003498 0.001599 2.188 0.029
L3.total_pledge_collateral_log_differenced 273.724451 1551.317257 0.176 0.860
L3.total_qa_bytes_committed_log_differenced -203.040278 750.229119 -0.271 0.787
L3.total_qa_bytes_power_log_differenced 56.761025 744.002633 0.076 0.939
L3.total_raw_bytes_committed_log_differenced -180.722046 751.215749 -0.241 0.810
L3.total_raw_bytes_power_log_differenced 327.613215 744.876773 0.440 0.660
L3.burnt_fil_log_differenced -48.683649 19.534980 -2.492 0.013
L3.circulating_fil_log_differenced -250.978252 99.426091 -2.524 0.012
L3.locked_fil_log_differenced -421.805611 1531.960434 -0.275 0.783
L3.vested_fil_log_differenced 181.902592 289.275811 0.629 0.529
L4.cum_sum_baseline_log_differenced 5535.662187 4826.252506 1.147 0.251
L4.cum_sum_realized_log_differenced 90.104678 588.367756 0.153 0.878
L4.effective_baseline_power_log_differenced -2604.014091 2405.274835 -1.083 0.279
L4.effective_network_time_log_differenced -5633.927870 5093.265710 -1.106 0.269
L4.new_baseline_power_log_differenced -526.707339 2135.976039 -0.247 0.805
L4.total_mined_reward_log_differenced 346.597559 53.493333 6.479 0.000
L4.miner_count_log_differenced 1.760556 0.461638 3.814 0.000
L4.participating_miner_count_log_differenced 0.348772 0.113032 3.086 0.002
L4.qa_smoothed_position_estimate_log_differenced -1.290527 0.266758 -4.838 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.001023 0.001565 0.654 0.513
L4.total_pledge_collateral_log_differenced -4762.940395 1549.932625 -3.073 0.002
L4.total_qa_bytes_committed_log_differenced 565.768946 748.385237 0.756 0.450
L4.total_qa_bytes_power_log_differenced -1117.513483 742.347600 -1.505 0.132
L4.total_raw_bytes_committed_log_differenced -367.321857 749.455720 -0.490 0.624
L4.total_raw_bytes_power_log_differenced 918.340855 743.303578 1.235 0.217
L4.burnt_fil_log_differenced -120.138848 19.558003 -6.143 0.000
L4.circulating_fil_log_differenced -620.852295 99.535701 -6.237 0.000
L4.locked_fil_log_differenced 4397.754154 1530.516808 2.873 0.004
L4.vested_fil_log_differenced 748.833085 244.516939 3.062 0.002
===================================================================================================================
Results for equation effective_baseline_power_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000006 0.009 0.992
L1.cum_sum_baseline_log_differenced 4901.353921 1596.339945 3.070 0.002
L1.cum_sum_realized_log_differenced -37.216881 194.111012 -0.192 0.848
L1.effective_baseline_power_log_differenced -2771.372868 794.007252 -3.490 0.000
L1.effective_network_time_log_differenced -4816.639907 1684.833854 -2.859 0.004
L1.new_baseline_power_log_differenced 24.263612 704.861132 0.034 0.973
L1.total_mined_reward_log_differenced 38.977228 17.666967 2.206 0.027
L1.miner_count_log_differenced 0.286870 0.152088 1.886 0.059
L1.participating_miner_count_log_differenced 0.310308 0.037308 8.317 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.206629 0.088255 2.341 0.019
L1.qa_smoothed_velocity_estimate_log_differenced -0.001491 0.000517 -2.883 0.004
L1.total_pledge_collateral_log_differenced -3060.980411 510.394623 -5.997 0.000
L1.total_qa_bytes_committed_log_differenced -1439.548372 247.217840 -5.823 0.000
L1.total_qa_bytes_power_log_differenced 1209.915197 245.261613 4.933 0.000
L1.total_raw_bytes_committed_log_differenced 1552.304079 247.662524 6.268 0.000
L1.total_raw_bytes_power_log_differenced -1322.613968 245.666267 -5.384 0.000
L1.burnt_fil_log_differenced -10.885852 6.453471 -1.687 0.092
L1.circulating_fil_log_differenced -53.794724 32.847309 -1.638 0.101
L1.locked_fil_log_differenced 3029.253507 503.996690 6.010 0.000
L1.vested_fil_log_differenced 75.976327 81.034515 0.938 0.348
L2.cum_sum_baseline_log_differenced 11443.516129 1684.742623 6.792 0.000
L2.cum_sum_realized_log_differenced 26.110661 208.363195 0.125 0.900
L2.effective_baseline_power_log_differenced -6369.632299 833.343417 -7.643 0.000
L2.effective_network_time_log_differenced -11334.446856 1782.148006 -6.360 0.000
L2.new_baseline_power_log_differenced -128.961978 759.836647 -0.170 0.865
L2.total_mined_reward_log_differenced -12.035183 17.647615 -0.682 0.495
L2.miner_count_log_differenced 0.069208 0.152218 0.455 0.649
L2.participating_miner_count_log_differenced 0.132286 0.037306 3.546 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.399451 0.088099 4.534 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.000452 0.000527 0.858 0.391
L2.total_pledge_collateral_log_differenced -2372.730280 511.784445 -4.636 0.000
L2.total_qa_bytes_committed_log_differenced -1146.637454 247.630764 -4.630 0.000
L2.total_qa_bytes_power_log_differenced 943.989989 245.567280 3.844 0.000
L2.total_raw_bytes_committed_log_differenced 1103.580849 247.974050 4.450 0.000
L2.total_raw_bytes_power_log_differenced -901.275751 245.873622 -3.666 0.000
L2.burnt_fil_log_differenced 9.386025 6.448032 1.456 0.145
L2.circulating_fil_log_differenced 40.401751 32.818303 1.231 0.218
L2.locked_fil_log_differenced 2399.448592 505.402141 4.748 0.000
L2.vested_fil_log_differenced -47.405596 95.497042 -0.496 0.620
L3.cum_sum_baseline_log_differenced 1073.106235 1683.228699 0.638 0.524
L3.cum_sum_realized_log_differenced 2.076959 208.303733 0.010 0.992
L3.effective_baseline_power_log_differenced -592.889085 833.873914 -0.711 0.477
L3.effective_network_time_log_differenced -1054.540304 1780.242016 -0.592 0.554
L3.new_baseline_power_log_differenced 28.905204 759.532594 0.038 0.970
L3.total_mined_reward_log_differenced 34.465435 17.634667 1.954 0.051
L3.miner_count_log_differenced 0.205637 0.152297 1.350 0.177
L3.participating_miner_count_log_differenced -0.034042 0.037310 -0.912 0.362
L3.qa_smoothed_position_estimate_log_differenced -0.145107 0.088101 -1.647 0.100
L3.qa_smoothed_velocity_estimate_log_differenced 0.001151 0.000527 2.183 0.029
L3.total_pledge_collateral_log_differenced 117.233149 511.753523 0.229 0.819
L3.total_qa_bytes_committed_log_differenced -88.996041 247.487993 -0.360 0.719
L3.total_qa_bytes_power_log_differenced 42.472753 245.433980 0.173 0.863
L3.total_raw_bytes_committed_log_differenced -38.319559 247.813466 -0.155 0.877
L3.total_raw_bytes_power_log_differenced 85.050795 245.722344 0.346 0.729
L3.burnt_fil_log_differenced -15.992484 6.444262 -2.482 0.013
L3.circulating_fil_log_differenced -82.497833 32.798998 -2.515 0.012
L3.locked_fil_log_differenced -165.878518 505.368032 -0.328 0.743
L3.vested_fil_log_differenced 59.815748 95.427234 0.627 0.531
L4.cum_sum_baseline_log_differenced 1893.481459 1592.099689 1.189 0.234
L4.cum_sum_realized_log_differenced 27.127456 194.092646 0.140 0.889
L4.effective_baseline_power_log_differenced -904.268738 793.459794 -1.140 0.254
L4.effective_network_time_log_differenced -1922.486858 1680.182863 -1.144 0.253
L4.new_baseline_power_log_differenced -165.682156 704.622641 -0.235 0.814
L4.total_mined_reward_log_differenced 113.894863 17.646553 6.454 0.000
L4.miner_count_log_differenced 0.580770 0.152287 3.814 0.000
L4.participating_miner_count_log_differenced 0.115878 0.037287 3.108 0.002
L4.qa_smoothed_position_estimate_log_differenced -0.425983 0.087999 -4.841 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000335 0.000516 0.650 0.516
L4.total_pledge_collateral_log_differenced -1549.470430 511.296756 -3.030 0.002
L4.total_qa_bytes_committed_log_differenced 181.710631 246.879727 0.736 0.462
L4.total_qa_bytes_power_log_differenced -361.930170 244.888012 -1.478 0.139
L4.total_raw_bytes_committed_log_differenced -117.209407 247.232862 -0.474 0.635
L4.total_raw_bytes_power_log_differenced 297.191942 245.203373 1.212 0.226
L4.burnt_fil_log_differenced -39.520856 6.451857 -6.126 0.000
L4.circulating_fil_log_differenced -204.314347 32.835157 -6.222 0.000
L4.locked_fil_log_differenced 1429.332141 504.891804 2.831 0.005
L4.vested_fil_log_differenced 248.455766 80.662034 3.080 0.002
===================================================================================================================
Results for equation effective_network_time_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000014 0.009 0.993
L1.cum_sum_baseline_log_differenced 11981.602428 3987.852617 3.005 0.003
L1.cum_sum_realized_log_differenced -103.896563 484.913072 -0.214 0.830
L1.effective_baseline_power_log_differenced -6805.454111 1983.527323 -3.431 0.001
L1.effective_network_time_log_differenced -11761.202425 4208.921235 -2.794 0.005
L1.new_baseline_power_log_differenced 107.312949 1760.829402 0.061 0.951
L1.total_mined_reward_log_differenced 100.352554 44.134247 2.274 0.023
L1.miner_count_log_differenced 0.723458 0.379935 1.904 0.057
L1.participating_miner_count_log_differenced 0.764682 0.093201 8.205 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.531006 0.220473 2.408 0.016
L1.qa_smoothed_velocity_estimate_log_differenced -0.003811 0.001292 -2.949 0.003
L1.total_pledge_collateral_log_differenced -7719.970861 1275.028253 -6.055 0.000
L1.total_qa_bytes_committed_log_differenced -3546.433935 617.580431 -5.742 0.000
L1.total_qa_bytes_power_log_differenced 2959.726664 612.693535 4.831 0.000
L1.total_raw_bytes_committed_log_differenced 3826.115828 618.691306 6.184 0.000
L1.total_raw_bytes_power_log_differenced -3239.278179 613.704410 -5.278 0.000
L1.burnt_fil_log_differenced -28.138007 16.121560 -1.745 0.081
L1.circulating_fil_log_differenced -139.251472 82.056598 -1.697 0.090
L1.locked_fil_log_differenced 7637.634421 1259.045433 6.066 0.000
L1.vested_fil_log_differenced 189.179406 202.434140 0.935 0.350
L2.cum_sum_baseline_log_differenced 28117.847392 4208.693328 6.681 0.000
L2.cum_sum_realized_log_differenced 58.786787 520.516770 0.113 0.910
L2.effective_baseline_power_log_differenced -15664.402281 2081.793880 -7.524 0.000
L2.effective_network_time_log_differenced -27844.486866 4452.023902 -6.254 0.000
L2.new_baseline_power_log_differenced -298.632595 1898.164968 -0.157 0.875
L2.total_mined_reward_log_differenced -30.067751 44.085904 -0.682 0.495
L2.miner_count_log_differenced 0.193529 0.380258 0.509 0.611
L2.participating_miner_count_log_differenced 0.327562 0.093195 3.515 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.987580 0.220083 4.487 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.001124 0.001317 0.853 0.394
L2.total_pledge_collateral_log_differenced -5987.325557 1278.500198 -4.683 0.000
L2.total_qa_bytes_committed_log_differenced -2851.340547 618.611966 -4.609 0.000
L2.total_qa_bytes_power_log_differenced 2335.908591 613.457128 3.808 0.000
L2.total_raw_bytes_committed_log_differenced 2745.850372 619.469535 4.433 0.000
L2.total_raw_bytes_power_log_differenced -2231.257429 614.222408 -3.633 0.000
L2.burnt_fil_log_differenced 23.379085 16.107973 1.451 0.147
L2.circulating_fil_log_differenced 101.069465 81.984139 1.233 0.218
L2.locked_fil_log_differenced 6054.042124 1262.556422 4.795 0.000
L2.vested_fil_log_differenced -118.545259 238.563302 -0.497 0.619
L3.cum_sum_baseline_log_differenced 2557.659660 4204.911362 0.608 0.543
L3.cum_sum_realized_log_differenced 12.749264 520.368226 0.025 0.980
L3.effective_baseline_power_log_differenced -1388.537645 2083.119124 -0.667 0.505
L3.effective_network_time_log_differenced -2521.273415 4447.262504 -0.567 0.571
L3.new_baseline_power_log_differenced 42.270750 1897.405406 0.022 0.982
L3.total_mined_reward_log_differenced 87.132535 44.053558 1.978 0.048
L3.miner_count_log_differenced 0.515052 0.380458 1.354 0.176
L3.participating_miner_count_log_differenced -0.078982 0.093205 -0.847 0.397
L3.qa_smoothed_position_estimate_log_differenced -0.344552 0.220086 -1.566 0.117
L3.qa_smoothed_velocity_estimate_log_differenced 0.002884 0.001317 2.189 0.029
L3.total_pledge_collateral_log_differenced 210.291088 1278.422953 0.164 0.869
L3.total_qa_bytes_committed_log_differenced -154.714384 618.255306 -0.250 0.802
L3.total_qa_bytes_power_log_differenced 33.181244 613.124130 0.054 0.957
L3.total_raw_bytes_committed_log_differenced -161.121253 619.068376 -0.260 0.795
L3.total_raw_bytes_power_log_differenced 283.155216 613.844498 0.461 0.645
L3.burnt_fil_log_differenced -40.154799 16.098555 -2.494 0.013
L3.circulating_fil_log_differenced -206.980436 81.935913 -2.526 0.012
L3.locked_fil_log_differenced -332.429759 1262.471214 -0.263 0.792
L3.vested_fil_log_differenced 149.963980 238.388914 0.629 0.529
L4.cum_sum_baseline_log_differenced 4533.180713 3977.259938 1.140 0.254
L4.cum_sum_realized_log_differenced 79.033492 484.867193 0.163 0.871
L4.effective_baseline_power_log_differenced -2118.725433 1982.159705 -1.069 0.285
L4.effective_network_time_log_differenced -4619.423521 4197.302491 -1.101 0.271
L4.new_baseline_power_log_differenced -448.383124 1760.233622 -0.255 0.799
L4.total_mined_reward_log_differenced 285.874995 44.083249 6.485 0.000
L4.miner_count_log_differenced 1.450752 0.380430 3.813 0.000
L4.participating_miner_count_log_differenced 0.286941 0.093148 3.080 0.002
L4.qa_smoothed_position_estimate_log_differenced -1.063334 0.219833 -4.837 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000845 0.001289 0.655 0.512
L4.total_pledge_collateral_log_differenced -3937.668778 1277.281893 -3.083 0.002
L4.total_qa_bytes_committed_log_differenced 468.931008 616.735784 0.760 0.447
L4.total_qa_bytes_power_log_differenced -924.625793 611.760236 -1.511 0.131
L4.total_raw_bytes_committed_log_differenced -304.840744 617.617957 -0.494 0.622
L4.total_raw_bytes_power_log_differenced 759.936266 612.548046 1.241 0.215
L4.burnt_fil_log_differenced -99.067265 16.117529 -6.147 0.000
L4.circulating_fil_log_differenced -511.913334 82.026242 -6.241 0.000
L4.locked_fil_log_differenced 3636.537808 1261.281539 2.883 0.004
L4.vested_fil_log_differenced 616.234066 201.503635 3.058 0.002
===================================================================================================================
Results for equation new_baseline_power_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000005 0.010 0.992
L1.cum_sum_baseline_log_differenced 4161.852480 1353.393966 3.075 0.002
L1.cum_sum_realized_log_differenced -31.298826 164.569378 -0.190 0.849
L1.effective_baseline_power_log_differenced -2351.900157 673.167784 -3.494 0.000
L1.effective_network_time_log_differenced -4090.242633 1428.420042 -2.863 0.004
L1.new_baseline_power_log_differenced 18.812885 597.588757 0.031 0.975
L1.total_mined_reward_log_differenced 32.985818 14.978242 2.202 0.028
L1.miner_count_log_differenced 0.243091 0.128942 1.885 0.059
L1.participating_miner_count_log_differenced 0.263293 0.031631 8.324 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.174849 0.074824 2.337 0.019
L1.qa_smoothed_velocity_estimate_log_differenced -0.001262 0.000438 -2.879 0.004
L1.total_pledge_collateral_log_differenced -2593.650604 432.717984 -5.994 0.000
L1.total_qa_bytes_committed_log_differenced -1221.473938 209.593912 -5.828 0.000
L1.total_qa_bytes_power_log_differenced 1027.052214 207.935401 4.939 0.000
L1.total_raw_bytes_committed_log_differenced 1317.105248 209.970919 6.273 0.000
L1.total_raw_bytes_power_log_differenced -1122.634987 208.278471 -5.390 0.000
L1.burnt_fil_log_differenced -9.210269 5.471321 -1.683 0.092
L1.circulating_fil_log_differenced -45.510654 27.848297 -1.634 0.102
L1.locked_fil_log_differenced 2566.813684 427.293748 6.007 0.000
L1.vested_fil_log_differenced 64.422792 68.701923 0.938 0.348
L2.cum_sum_baseline_log_differenced 9710.828600 1428.342696 6.799 0.000
L2.cum_sum_realized_log_differenced 21.987756 176.652531 0.124 0.901
L2.effective_baseline_power_log_differenced -5405.070939 706.517403 -7.650 0.000
L2.effective_network_time_log_differenced -9618.100789 1510.924015 -6.366 0.000
L2.new_baseline_power_log_differenced -109.458889 644.197582 -0.170 0.865
L2.total_mined_reward_log_differenced -10.206661 14.961836 -0.682 0.495
L2.miner_count_log_differenced 0.058262 0.129052 0.451 0.652
L2.participating_miner_count_log_differenced 0.112206 0.031628 3.548 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.338868 0.074691 4.537 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.000384 0.000447 0.858 0.391
L2.total_pledge_collateral_log_differenced -2010.302538 433.896290 -4.633 0.000
L2.total_qa_bytes_committed_log_differenced -972.360519 209.943993 -4.632 0.000
L2.total_qa_bytes_power_log_differenced 800.739573 208.194549 3.846 0.000
L2.total_raw_bytes_committed_log_differenced 935.818879 210.235034 4.451 0.000
L2.total_raw_bytes_power_log_differenced -764.488522 208.454269 -3.667 0.000
L2.burnt_fil_log_differenced 7.960158 5.466710 1.456 0.145
L2.circulating_fil_log_differenced 34.256487 27.823706 1.231 0.218
L2.locked_fil_log_differenced 2032.958973 428.485305 4.745 0.000
L2.vested_fil_log_differenced -40.197472 80.963407 -0.496 0.620
L3.cum_sum_baseline_log_differenced 911.418833 1427.059175 0.639 0.523
L3.cum_sum_realized_log_differenced 1.191227 176.602118 0.007 0.995
L3.effective_baseline_power_log_differenced -504.581902 706.967164 -0.714 0.475
L3.effective_network_time_log_differenced -895.060055 1509.308096 -0.593 0.553
L3.new_baseline_power_log_differenced 25.967833 643.939803 0.040 0.968
L3.total_mined_reward_log_differenced 29.199179 14.950858 1.953 0.051
L3.miner_count_log_differenced 0.174307 0.129119 1.350 0.177
L3.participating_miner_count_log_differenced -0.028982 0.031632 -0.916 0.360
L3.qa_smoothed_position_estimate_log_differenced -0.123372 0.074693 -1.652 0.099
L3.qa_smoothed_velocity_estimate_log_differenced 0.000976 0.000447 2.182 0.029
L3.total_pledge_collateral_log_differenced 101.033412 433.870074 0.233 0.816
L3.total_qa_bytes_committed_log_differenced -76.835612 209.822950 -0.366 0.714
L3.total_qa_bytes_power_log_differenced 37.499663 208.081536 0.180 0.857
L3.total_raw_bytes_committed_log_differenced -31.145809 210.098889 -0.148 0.882
L3.total_raw_bytes_power_log_differenced 70.658429 208.326014 0.339 0.734
L3.burnt_fil_log_differenced -13.554503 5.463514 -2.481 0.013
L3.circulating_fil_log_differenced -69.924483 27.807339 -2.515 0.012
L3.locked_fil_log_differenced -142.262979 428.456387 -0.332 0.740
L3.vested_fil_log_differenced 50.710021 80.904223 0.627 0.531
L4.cum_sum_baseline_log_differenced 1607.157038 1349.799032 1.191 0.234
L4.cum_sum_realized_log_differenced 22.033104 164.553808 0.134 0.893
L4.effective_baseline_power_log_differenced -769.731675 672.703643 -1.144 0.253
L4.effective_network_time_log_differenced -1630.727903 1424.476883 -1.145 0.252
L4.new_baseline_power_log_differenced -137.693918 597.386562 -0.230 0.818
L4.total_mined_reward_log_differenced 96.529090 14.960935 6.452 0.000
L4.miner_count_log_differenced 0.492404 0.129110 3.814 0.000
L4.participating_miner_count_log_differenced 0.098292 0.031613 3.109 0.002
L4.qa_smoothed_position_estimate_log_differenced -0.361163 0.074607 -4.841 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000284 0.000438 0.649 0.516
L4.total_pledge_collateral_log_differenced -1312.202092 433.482822 -3.027 0.002
L4.total_qa_bytes_committed_log_differenced 153.772882 209.307256 0.735 0.463
L4.total_qa_bytes_power_log_differenced -306.453502 207.618659 -1.476 0.140
L4.total_raw_bytes_committed_log_differenced -99.151576 209.606647 -0.473 0.636
L4.total_raw_bytes_power_log_differenced 251.631429 207.886025 1.210 0.226
L4.burnt_fil_log_differenced -33.497454 5.469953 -6.124 0.000
L4.circulating_fil_log_differenced -173.179730 27.837995 -6.221 0.000
L4.locked_fil_log_differenced 1210.373750 428.052636 2.828 0.005
L4.vested_fil_log_differenced 210.733944 68.386129 3.082 0.002
===================================================================================================================
Results for equation total_mined_reward_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000012 0.009 0.993
L1.cum_sum_baseline_log_differenced 9927.648368 3300.400166 3.008 0.003
L1.cum_sum_realized_log_differenced -85.876865 401.320544 -0.214 0.831
L1.effective_baseline_power_log_differenced -5637.028637 1641.593743 -3.434 0.001
L1.effective_network_time_log_differenced -9745.239470 3483.359511 -2.798 0.005
L1.new_baseline_power_log_differenced 86.463562 1457.285965 0.059 0.953
L1.total_mined_reward_log_differenced 82.845584 36.526093 2.268 0.023
L1.miner_count_log_differenced 0.597692 0.314439 1.901 0.057
L1.participating_miner_count_log_differenced 0.633543 0.077134 8.213 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.438517 0.182466 2.403 0.016
L1.qa_smoothed_velocity_estimate_log_differenced -0.003147 0.001069 -2.943 0.003
L1.total_pledge_collateral_log_differenced -6379.872317 1055.230437 -6.046 0.000
L1.total_qa_bytes_committed_log_differenced -2938.250229 511.117825 -5.749 0.000
L1.total_qa_bytes_power_log_differenced 2454.062288 507.073365 4.840 0.000
L1.total_raw_bytes_committed_log_differenced 3169.713129 512.037200 6.190 0.000
L1.total_raw_bytes_power_log_differenced -2685.416860 507.909979 -5.287 0.000
L1.burnt_fil_log_differenced -23.236572 13.342419 -1.742 0.082
L1.circulating_fil_log_differenced -114.979617 67.911138 -1.693 0.090
L1.locked_fil_log_differenced 6311.900882 1042.002841 6.057 0.000
L1.vested_fil_log_differenced 156.610759 167.537202 0.935 0.350
L2.cum_sum_baseline_log_differenced 23314.192428 3483.170892 6.693 0.000
L2.cum_sum_realized_log_differenced 48.179653 430.786641 0.112 0.911
L2.effective_baseline_power_log_differenced -12988.428335 1722.920460 -7.539 0.000
L2.effective_network_time_log_differenced -23086.941957 3684.554529 -6.266 0.000
L2.new_baseline_power_log_differenced -247.239974 1570.946716 -0.157 0.875
L2.total_mined_reward_log_differenced -24.978179 36.486084 -0.685 0.494
L2.miner_count_log_differenced 0.158030 0.314707 0.502 0.616
L2.participating_miner_count_log_differenced 0.271531 0.077129 3.520 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.818512 0.182143 4.494 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.000933 0.001090 0.856 0.392
L2.total_pledge_collateral_log_differenced -4947.878176 1058.103865 -4.676 0.000
L2.total_qa_bytes_committed_log_differenced -2361.061901 511.971538 -4.612 0.000
L2.total_qa_bytes_power_log_differenced 1935.367872 507.705325 3.812 0.000
L2.total_raw_bytes_committed_log_differenced 2273.335052 512.681273 4.434 0.000
L2.total_raw_bytes_power_log_differenced -1848.337322 508.338680 -3.636 0.000
L2.burnt_fil_log_differenced 19.376731 13.331174 1.453 0.146
L2.circulating_fil_log_differenced 83.742666 67.851170 1.234 0.217
L2.locked_fil_log_differenced 5003.165454 1044.908582 4.788 0.000
L2.vested_fil_log_differenced -98.026378 197.438179 -0.496 0.620
L3.cum_sum_baseline_log_differenced 2121.032102 3480.040886 0.609 0.542
L3.cum_sum_realized_log_differenced 8.663706 430.663704 0.020 0.984
L3.effective_baseline_power_log_differenced -1155.433014 1724.017250 -0.670 0.503
L3.effective_network_time_log_differenced -2088.858721 3680.613933 -0.568 0.570
L3.new_baseline_power_log_differenced 40.488302 1570.318093 0.026 0.979
L3.total_mined_reward_log_differenced 72.160246 36.459314 1.979 0.048
L3.miner_count_log_differenced 0.425511 0.314872 1.351 0.177
L3.participating_miner_count_log_differenced -0.065687 0.077137 -0.852 0.394
L3.qa_smoothed_position_estimate_log_differenced -0.286377 0.182146 -1.572 0.116
L3.qa_smoothed_velocity_estimate_log_differenced 0.002386 0.001090 2.189 0.029
L3.total_pledge_collateral_log_differenced 182.372991 1058.039935 0.172 0.863
L3.total_qa_bytes_committed_log_differenced -130.673541 511.676360 -0.255 0.798
L3.total_qa_bytes_power_log_differenced 30.647000 507.429731 0.060 0.952
L3.total_raw_bytes_committed_log_differenced -131.019192 512.349268 -0.256 0.798
L3.total_raw_bytes_power_log_differenced 231.461360 508.025917 0.456 0.649
L3.burnt_fil_log_differenced -33.268914 13.323380 -2.497 0.013
L3.circulating_fil_log_differenced -171.500049 67.811258 -2.529 0.011
L3.locked_fil_log_differenced -283.574374 1044.838063 -0.271 0.786
L3.vested_fil_log_differenced 124.351466 197.293854 0.630 0.529
L4.cum_sum_baseline_log_differenced 3754.407102 3291.633523 1.141 0.254
L4.cum_sum_realized_log_differenced 62.128501 401.282574 0.155 0.877
L4.effective_baseline_power_log_differenced -1762.440168 1640.461884 -1.074 0.283
L4.effective_network_time_log_differenced -3822.343033 3473.743683 -1.100 0.271
L4.new_baseline_power_log_differenced -361.219178 1456.792890 -0.248 0.804
L4.total_mined_reward_log_differenced 236.448270 36.483887 6.481 0.000
L4.miner_count_log_differenced 1.200396 0.314849 3.813 0.000
L4.participating_miner_count_log_differenced 0.237785 0.077091 3.084 0.002
L4.qa_smoothed_position_estimate_log_differenced -0.880720 0.181936 -4.841 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000697 0.001067 0.653 0.514
L4.total_pledge_collateral_log_differenced -3251.687396 1057.095579 -3.076 0.002
L4.total_qa_bytes_committed_log_differenced 387.355292 510.418784 0.759 0.448
L4.total_qa_bytes_power_log_differenced -763.960010 506.300954 -1.509 0.131
L4.total_raw_bytes_committed_log_differenced -251.786393 511.148882 -0.493 0.622
L4.total_raw_bytes_power_log_differenced 627.895324 506.952956 1.239 0.216
L4.burnt_fil_log_differenced -81.961569 13.339082 -6.144 0.000
L4.circulating_fil_log_differenced -423.538221 67.886015 -6.239 0.000
L4.locked_fil_log_differenced 3002.549789 1043.853472 2.876 0.004
L4.vested_fil_log_differenced 510.471994 166.767104 3.061 0.002
===================================================================================================================
Results for equation miner_count_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000001 0.006 0.996
L1.cum_sum_baseline_log_differenced 1332.897832 212.989078 6.258 0.000
L1.cum_sum_realized_log_differenced 29.018455 25.898948 1.120 0.263
L1.effective_baseline_power_log_differenced -658.584846 105.939135 -6.217 0.000
L1.effective_network_time_log_differenced -1349.851363 224.796235 -6.005 0.000
L1.new_baseline_power_log_differenced -131.171569 94.044958 -1.395 0.163
L1.total_mined_reward_log_differenced 2.293139 2.357187 0.973 0.331
L1.miner_count_log_differenced -0.016992 0.020292 -0.837 0.402
L1.participating_miner_count_log_differenced 0.038961 0.004978 7.827 0.000
L1.qa_smoothed_position_estimate_log_differenced -0.026323 0.011775 -2.235 0.025
L1.qa_smoothed_velocity_estimate_log_differenced -0.000063 0.000069 -0.916 0.360
L1.total_pledge_collateral_log_differenced -458.376660 68.098578 -6.731 0.000
L1.total_qa_bytes_committed_log_differenced -289.485904 32.984641 -8.776 0.000
L1.total_qa_bytes_power_log_differenced 268.394775 32.723634 8.202 0.000
L1.total_raw_bytes_committed_log_differenced 300.257152 33.043972 9.087 0.000
L1.total_raw_bytes_power_log_differenced -279.101830 32.777625 -8.515 0.000
L1.burnt_fil_log_differenced -0.526589 0.861044 -0.612 0.541
L1.circulating_fil_log_differenced -2.549285 4.382599 -0.582 0.561
L1.locked_fil_log_differenced 457.001047 67.244944 6.796 0.000
L1.vested_fil_log_differenced 13.185574 10.811899 1.220 0.223
L2.cum_sum_baseline_log_differenced 1817.381245 224.784063 8.085 0.000
L2.cum_sum_realized_log_differenced 21.096029 27.800523 0.759 0.448
L2.effective_baseline_power_log_differenced -966.364820 111.187499 -8.691 0.000
L2.effective_network_time_log_differenced -1817.474038 237.780219 -7.644 0.000
L2.new_baseline_power_log_differenced -78.558208 101.379977 -0.775 0.438
L2.total_mined_reward_log_differenced -0.086521 2.354605 -0.037 0.971
L2.miner_count_log_differenced -0.058312 0.020309 -2.871 0.004
L2.participating_miner_count_log_differenced 0.018435 0.004977 3.704 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.066155 0.011754 5.628 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.000064 0.000070 0.916 0.360
L2.total_pledge_collateral_log_differenced -285.499579 68.284013 -4.181 0.000
L2.total_qa_bytes_committed_log_differenced -170.688695 33.039735 -5.166 0.000
L2.total_qa_bytes_power_log_differenced 153.828809 32.764418 4.695 0.000
L2.total_raw_bytes_committed_log_differenced 169.528585 33.085537 5.124 0.000
L2.total_raw_bytes_power_log_differenced -152.732798 32.805291 -4.656 0.000
L2.burnt_fil_log_differenced 0.788915 0.860318 0.917 0.359
L2.circulating_fil_log_differenced 2.812123 4.378729 0.642 0.521
L2.locked_fil_log_differenced 287.504631 67.432464 4.264 0.000
L2.vested_fil_log_differenced -6.621438 12.741539 -0.520 0.603
L3.cum_sum_baseline_log_differenced 296.664322 224.582070 1.321 0.187
L3.cum_sum_realized_log_differenced -18.798515 27.792589 -0.676 0.499
L3.effective_baseline_power_log_differenced -220.914318 111.258280 -1.986 0.047
L3.effective_network_time_log_differenced -271.901535 237.525915 -1.145 0.252
L3.new_baseline_power_log_differenced 75.946090 101.339409 0.749 0.454
L3.total_mined_reward_log_differenced 4.072940 2.352877 1.731 0.083
L3.miner_count_log_differenced -0.005993 0.020320 -0.295 0.768
L3.participating_miner_count_log_differenced -0.010907 0.004978 -2.191 0.028
L3.qa_smoothed_position_estimate_log_differenced -0.044868 0.011755 -3.817 0.000
L3.qa_smoothed_velocity_estimate_log_differenced 0.000084 0.000070 1.188 0.235
L3.total_pledge_collateral_log_differenced 43.455206 68.279887 0.636 0.524
L3.total_qa_bytes_committed_log_differenced -114.084532 33.020686 -3.455 0.001
L3.total_qa_bytes_power_log_differenced 111.778406 32.746632 3.413 0.001
L3.total_raw_bytes_committed_log_differenced 100.438951 33.064111 3.038 0.002
L3.total_raw_bytes_power_log_differenced -98.074658 32.785107 -2.991 0.003
L3.burnt_fil_log_differenced -2.137068 0.859815 -2.485 0.013
L3.circulating_fil_log_differenced -11.159240 4.376153 -2.550 0.011
L3.locked_fil_log_differenced -49.966111 67.427913 -0.741 0.459
L3.vested_fil_log_differenced 10.144475 12.732225 0.797 0.426
L4.cum_sum_baseline_log_differenced 514.865676 212.423329 2.424 0.015
L4.cum_sum_realized_log_differenced 3.923734 25.896498 0.152 0.880
L4.effective_baseline_power_log_differenced -267.358042 105.866091 -2.525 0.012
L4.effective_network_time_log_differenced -516.063526 224.175684 -2.302 0.021
L4.new_baseline_power_log_differenced -30.276115 94.013138 -0.322 0.747
L4.total_mined_reward_log_differenced 10.279746 2.354463 4.366 0.000
L4.miner_count_log_differenced 0.065753 0.020319 3.236 0.001
L4.participating_miner_count_log_differenced 0.013585 0.004975 2.731 0.006
L4.qa_smoothed_position_estimate_log_differenced -0.060218 0.011741 -5.129 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000044 0.000069 0.634 0.526
L4.total_pledge_collateral_log_differenced -105.123697 68.218944 -1.541 0.123
L4.total_qa_bytes_committed_log_differenced -21.986283 32.939529 -0.667 0.504
L4.total_qa_bytes_power_log_differenced 4.489510 32.673787 0.137 0.891
L4.total_raw_bytes_committed_log_differenced 26.828082 32.986645 0.813 0.416
L4.total_raw_bytes_power_log_differenced -9.332493 32.715864 -0.285 0.775
L4.burnt_fil_log_differenced -3.634212 0.860829 -4.222 0.000
L4.circulating_fil_log_differenced -19.101411 4.380978 -4.360 0.000
L4.locked_fil_log_differenced 94.133078 67.364373 1.397 0.162
L4.vested_fil_log_differenced 30.295369 10.762202 2.815 0.005
===================================================================================================================
Results for equation participating_miner_count_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000006 0.010 0.992
L1.cum_sum_baseline_log_differenced 3717.383132 1694.890414 2.193 0.028
L1.cum_sum_realized_log_differenced -98.895967 206.094507 -0.480 0.631
L1.effective_baseline_power_log_differenced -2264.572053 843.025500 -2.686 0.007
L1.effective_network_time_log_differenced -3582.545363 1788.847518 -2.003 0.045
L1.new_baseline_power_log_differenced 258.034688 748.375921 0.345 0.730
L1.total_mined_reward_log_differenced 52.894603 18.757642 2.820 0.005
L1.miner_count_log_differenced 0.421069 0.161477 2.608 0.009
L1.participating_miner_count_log_differenced 0.296257 0.039612 7.479 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.307094 0.093704 3.277 0.001
L1.qa_smoothed_velocity_estimate_log_differenced -0.001714 0.000549 -3.122 0.002
L1.total_pledge_collateral_log_differenced -3361.910260 541.903970 -6.204 0.000
L1.total_qa_bytes_committed_log_differenced -1356.734365 262.479899 -5.169 0.000
L1.total_qa_bytes_power_log_differenced 1099.708089 260.402903 4.223 0.000
L1.total_raw_bytes_committed_log_differenced 1488.235665 262.952036 5.660 0.000
L1.total_raw_bytes_power_log_differenced -1231.249544 260.832539 -4.720 0.000
L1.burnt_fil_log_differenced -15.479714 6.851878 -2.259 0.024
L1.circulating_fil_log_differenced -76.525442 34.875146 -2.194 0.028
L1.locked_fil_log_differenced 3316.170848 535.111059 6.197 0.000
L1.vested_fil_log_differenced 88.398880 86.037202 1.027 0.304
L2.cum_sum_baseline_log_differenced 10975.427980 1788.750654 6.136 0.000
L2.cum_sum_realized_log_differenced 12.068942 221.226552 0.055 0.956
L2.effective_baseline_power_log_differenced -6156.755272 884.790094 -6.958 0.000
L2.effective_network_time_log_differenced -10851.683389 1892.169385 -5.735 0.000
L2.new_baseline_power_log_differenced -45.029592 806.745363 -0.056 0.955
L2.total_mined_reward_log_differenced -19.541913 18.737096 -1.043 0.297
L2.miner_count_log_differenced 0.146559 0.161615 0.907 0.364
L2.participating_miner_count_log_differenced 0.106021 0.039609 2.677 0.007
L2.qa_smoothed_position_estimate_log_differenced 0.421132 0.093538 4.502 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.000560 0.000560 1.000 0.317
L2.total_pledge_collateral_log_differenced -2710.574503 543.379593 -4.988 0.000
L2.total_qa_bytes_committed_log_differenced -1143.644598 262.918315 -4.350 0.000
L2.total_qa_bytes_power_log_differenced 912.990766 260.727441 3.502 0.000
L2.total_raw_bytes_committed_log_differenced 1104.735023 263.282793 4.196 0.000
L2.total_raw_bytes_power_log_differenced -874.426147 261.052695 -3.350 0.001
L2.burnt_fil_log_differenced 11.966149 6.846103 1.748 0.080
L2.circulating_fil_log_differenced 54.195545 34.844350 1.555 0.120
L2.locked_fil_log_differenced 2745.537173 536.603275 5.117 0.000
L2.vested_fil_log_differenced -89.726308 101.392577 -0.885 0.376
L3.cum_sum_baseline_log_differenced -22.185461 1787.143268 -0.012 0.990
L3.cum_sum_realized_log_differenced 7.975540 221.163419 0.036 0.971
L3.effective_baseline_power_log_differenced 48.818092 885.353340 0.055 0.956
L3.effective_network_time_log_differenced 20.688573 1890.145728 0.011 0.991
L3.new_baseline_power_log_differenced 18.335109 806.422539 0.023 0.982
L3.total_mined_reward_log_differenced 55.506961 18.723348 2.965 0.003
L3.miner_count_log_differenced 0.331471 0.161700 2.050 0.040
L3.participating_miner_count_log_differenced -0.064271 0.039613 -1.622 0.105
L3.qa_smoothed_position_estimate_log_differenced -0.096842 0.093540 -1.035 0.301
L3.qa_smoothed_velocity_estimate_log_differenced 0.001131 0.000560 2.019 0.043
L3.total_pledge_collateral_log_differenced -180.379678 543.346762 -0.332 0.740
L3.total_qa_bytes_committed_log_differenced 137.281298 262.766730 0.522 0.601
L3.total_qa_bytes_power_log_differenced -198.772020 260.585912 -0.763 0.446
L3.total_raw_bytes_committed_log_differenced -270.610654 263.112296 -1.028 0.304
L3.total_raw_bytes_power_log_differenced 332.254137 260.892078 1.274 0.203
L3.burnt_fil_log_differenced -23.560249 6.842100 -3.443 0.001
L3.circulating_fil_log_differenced -120.530780 34.823853 -3.461 0.001
L3.locked_fil_log_differenced 108.425243 536.567061 0.202 0.840
L3.vested_fil_log_differenced 87.911417 101.318460 0.868 0.386
L4.cum_sum_baseline_log_differenced 1303.083398 1690.388385 0.771 0.441
L4.cum_sum_realized_log_differenced 24.818281 206.075007 0.120 0.904
L4.effective_baseline_power_log_differenced -572.280378 842.444244 -0.679 0.497
L4.effective_network_time_log_differenced -1337.767644 1783.909397 -0.750 0.453
L4.new_baseline_power_log_differenced -151.162315 748.122706 -0.202 0.840
L4.total_mined_reward_log_differenced 126.231382 18.735967 6.737 0.000
L4.miner_count_log_differenced 0.623763 0.161688 3.858 0.000
L4.participating_miner_count_log_differenced 0.094209 0.039589 2.380 0.017
L4.qa_smoothed_position_estimate_log_differenced -0.395931 0.093432 -4.238 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000405 0.000548 0.738 0.460
L4.total_pledge_collateral_log_differenced -1706.919395 542.861797 -3.144 0.002
L4.total_qa_bytes_committed_log_differenced 362.397043 262.120913 1.383 0.167
L4.total_qa_bytes_power_log_differenced -562.596822 260.006239 -2.164 0.030
L4.total_raw_bytes_committed_log_differenced -291.526765 262.495848 -1.111 0.267
L4.total_raw_bytes_power_log_differenced 491.432939 260.341069 1.888 0.059
L4.burnt_fil_log_differenced -43.835254 6.850164 -6.399 0.000
L4.circulating_fil_log_differenced -226.095915 34.862244 -6.485 0.000
L4.locked_fil_log_differenced 1573.685156 536.061433 2.936 0.003
L4.vested_fil_log_differenced 264.755343 85.641726 3.091 0.002
===================================================================================================================
Results for equation qa_smoothed_position_estimate_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000013 0.009 0.993
L1.cum_sum_baseline_log_differenced 10339.223174 3783.773587 2.733 0.006
L1.cum_sum_realized_log_differenced -144.088610 460.097564 -0.313 0.754
L1.effective_baseline_power_log_differenced -6003.904448 1882.019977 -3.190 0.001
L1.effective_network_time_log_differenced -10092.345550 3993.528981 -2.527 0.011
L1.new_baseline_power_log_differenced 281.301487 1670.718660 0.168 0.866
L1.total_mined_reward_log_differenced 91.390306 41.875669 2.182 0.029
L1.miner_count_log_differenced 0.729173 0.360492 2.023 0.043
L1.participating_miner_count_log_differenced 0.721484 0.088432 8.159 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.540606 0.209190 2.584 0.010
L1.qa_smoothed_velocity_estimate_log_differenced -0.003603 0.001226 -2.939 0.003
L1.total_pledge_collateral_log_differenced -7041.734458 1209.778467 -5.821 0.000
L1.total_qa_bytes_committed_log_differenced -3260.714939 585.975648 -5.565 0.000
L1.total_qa_bytes_power_log_differenced 2708.292808 581.338840 4.659 0.000
L1.total_raw_bytes_committed_log_differenced 3527.999067 587.029674 6.010 0.000
L1.total_raw_bytes_power_log_differenced -2975.494013 582.297984 -5.110 0.000
L1.burnt_fil_log_differenced -25.598822 15.296537 -1.674 0.094
L1.circulating_fil_log_differenced -126.229159 77.857338 -1.621 0.105
L1.locked_fil_log_differenced 6967.331482 1194.613571 5.832 0.000
L1.vested_fil_log_differenced 161.752217 192.074539 0.842 0.400
L2.cum_sum_baseline_log_differenced 26045.475411 3993.312737 6.522 0.000
L2.cum_sum_realized_log_differenced 8.806063 493.879237 0.018 0.986
L2.effective_baseline_power_log_differenced -14628.493146 1975.257727 -7.406 0.000
L2.effective_network_time_log_differenced -25744.239080 4224.190827 -6.094 0.000
L2.new_baseline_power_log_differenced -113.355711 1801.026055 -0.063 0.950
L2.total_mined_reward_log_differenced -25.472071 41.829800 -0.609 0.543
L2.miner_count_log_differenced 0.197671 0.360798 0.548 0.584
L2.participating_miner_count_log_differenced 0.310905 0.088426 3.516 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.909979 0.208820 4.358 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.001020 0.001250 0.816 0.414
L2.total_pledge_collateral_log_differenced -5606.243716 1213.072735 -4.622 0.000
L2.total_qa_bytes_committed_log_differenced -2692.216262 586.954394 -4.587 0.000
L2.total_qa_bytes_power_log_differenced 2204.143314 582.063356 3.787 0.000
L2.total_raw_bytes_committed_log_differenced 2592.534080 587.768077 4.411 0.000
L2.total_raw_bytes_power_log_differenced -2105.226593 582.789473 -3.612 0.000
L2.burnt_fil_log_differenced 20.859810 15.283645 1.365 0.172
L2.circulating_fil_log_differenced 89.426627 77.788587 1.150 0.250
L2.locked_fil_log_differenced 5665.590072 1197.944884 4.729 0.000
L2.vested_fil_log_differenced -106.659153 226.354784 -0.471 0.637
L3.cum_sum_baseline_log_differenced 2586.066530 3989.724314 0.648 0.517
L3.cum_sum_realized_log_differenced -2.483664 493.738294 -0.005 0.996
L3.effective_baseline_power_log_differenced -1441.986222 1976.515152 -0.730 0.466
L3.effective_network_time_log_differenced -2534.009393 4219.673095 -0.601 0.548
L3.new_baseline_power_log_differenced 90.114387 1800.305364 0.050 0.960
L3.total_mined_reward_log_differenced 82.131450 41.799109 1.965 0.049
L3.miner_count_log_differenced 0.491203 0.360988 1.361 0.174
L3.participating_miner_count_log_differenced -0.064377 0.088435 -0.728 0.467
L3.qa_smoothed_position_estimate_log_differenced -0.303517 0.208823 -1.453 0.146
L3.qa_smoothed_velocity_estimate_log_differenced 0.002676 0.001250 2.141 0.032
L3.total_pledge_collateral_log_differenced 164.999620 1212.999443 0.136 0.892
L3.total_qa_bytes_committed_log_differenced -132.026995 586.615986 -0.225 0.822
L3.total_qa_bytes_power_log_differenced 15.732529 581.747399 0.027 0.978
L3.total_raw_bytes_committed_log_differenced -164.136180 587.387448 -0.279 0.780
L3.total_raw_bytes_power_log_differenced 280.879011 582.430902 0.482 0.630
L3.burnt_fil_log_differenced -37.741709 15.274709 -2.471 0.013
L3.circulating_fil_log_differenced -194.705260 77.742829 -2.504 0.012
L3.locked_fil_log_differenced -279.722731 1197.864037 -0.234 0.815
L3.vested_fil_log_differenced 137.129293 226.189321 0.606 0.544
L4.cum_sum_baseline_log_differenced 3985.318658 3773.722990 1.056 0.291
L4.cum_sum_realized_log_differenced 47.920640 460.054032 0.104 0.917
L4.effective_baseline_power_log_differenced -1906.035807 1880.722347 -1.013 0.311
L4.effective_network_time_log_differenced -4040.150011 3982.504828 -1.014 0.310
L4.new_baseline_power_log_differenced -316.338725 1670.153370 -0.189 0.850
L4.total_mined_reward_log_differenced 270.963088 41.827282 6.478 0.000
L4.miner_count_log_differenced 1.357276 0.360962 3.760 0.000
L4.participating_miner_count_log_differenced 0.263883 0.088381 2.986 0.003
L4.qa_smoothed_position_estimate_log_differenced -1.037812 0.208583 -4.976 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000821 0.001223 0.671 0.502
L4.total_pledge_collateral_log_differenced -3732.448907 1211.916777 -3.080 0.002
L4.total_qa_bytes_committed_log_differenced 425.859444 585.174226 0.728 0.467
L4.total_qa_bytes_power_log_differenced -855.906734 580.453302 -1.475 0.140
L4.total_raw_bytes_committed_log_differenced -269.431176 586.011253 -0.460 0.646
L4.total_raw_bytes_power_log_differenced 698.912689 581.200797 1.203 0.229
L4.burnt_fil_log_differenced -93.992349 15.292711 -6.146 0.000
L4.circulating_fil_log_differenced -485.491780 77.828535 -6.238 0.000
L4.locked_fil_log_differenced 3446.834652 1196.735243 2.880 0.004
L4.vested_fil_log_differenced 572.089295 191.191653 2.992 0.003
===================================================================================================================
Results for equation qa_smoothed_velocity_estimate_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const -0.000008 0.000062 -0.131 0.895
L1.cum_sum_baseline_log_differenced -155007.117702 17432.147819 -8.892 0.000
L1.cum_sum_realized_log_differenced 277.480313 2119.706309 0.131 0.896
L1.effective_baseline_power_log_differenced 87682.672747 8670.616699 10.113 0.000
L1.effective_network_time_log_differenced 152833.324607 18398.507712 8.307 0.000
L1.new_baseline_power_log_differenced 456.417029 7697.134615 0.059 0.953
L1.total_mined_reward_log_differenced 143.678566 192.924561 0.745 0.456
L1.miner_count_log_differenced 3.740017 1.660815 2.252 0.024
L1.participating_miner_count_log_differenced 0.783090 0.407411 1.922 0.055
L1.qa_smoothed_position_estimate_log_differenced 0.493463 0.963755 0.512 0.609
L1.qa_smoothed_velocity_estimate_log_differenced 0.225239 0.005648 39.882 0.000
L1.total_pledge_collateral_log_differenced 77868.571563 5573.546247 13.971 0.000
L1.total_qa_bytes_committed_log_differenced 34877.176566 2699.636722 12.919 0.000
L1.total_qa_bytes_power_log_differenced -31146.809109 2678.274574 -11.629 0.000
L1.total_raw_bytes_committed_log_differenced -34866.572382 2704.492702 -12.892 0.000
L1.total_raw_bytes_power_log_differenced 31127.140491 2682.693426 11.603 0.000
L1.burnt_fil_log_differenced -45.383659 70.472369 -0.644 0.520
L1.circulating_fil_log_differenced -188.857033 358.694989 -0.527 0.599
L1.locked_fil_log_differenced -77949.634361 5503.680354 -14.163 0.000
L1.vested_fil_log_differenced -630.341877 884.902775 -0.712 0.476
L2.cum_sum_baseline_log_differenced -124218.069826 18397.511461 -6.752 0.000
L2.cum_sum_realized_log_differenced -584.416176 2275.341181 -0.257 0.797
L2.effective_baseline_power_log_differenced 68675.946525 9100.170474 7.547 0.000
L2.effective_network_time_log_differenced 123154.856282 19461.185305 6.328 0.000
L2.new_baseline_power_log_differenced 2885.781131 8297.471216 0.348 0.728
L2.total_mined_reward_log_differenced 1593.663858 192.713239 8.270 0.000
L2.miner_count_log_differenced -2.321861 1.662227 -1.397 0.162
L2.participating_miner_count_log_differenced -0.031877 0.407384 -0.078 0.938
L2.qa_smoothed_position_estimate_log_differenced -6.549872 0.962050 -6.808 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.088736 0.005759 15.409 0.000
L2.total_pledge_collateral_log_differenced 34765.515758 5588.723202 6.221 0.000
L2.total_qa_bytes_committed_log_differenced 18823.373284 2704.145883 6.961 0.000
L2.total_qa_bytes_power_log_differenced -16398.368432 2681.612479 -6.115 0.000
L2.total_raw_bytes_committed_log_differenced -18489.250839 2707.894585 -6.828 0.000
L2.total_raw_bytes_power_log_differenced 16067.469033 2684.957755 5.984 0.000
L2.burnt_fil_log_differenced -596.209520 70.412976 -8.467 0.000
L2.circulating_fil_log_differenced -2992.828369 358.378247 -8.351 0.000
L2.locked_fil_log_differenced -36585.352746 5519.027979 -6.629 0.000
L2.vested_fil_log_differenced 3113.163757 1042.834612 2.985 0.003
L3.cum_sum_baseline_log_differenced -19068.889406 18380.979306 -1.037 0.300
L3.cum_sum_realized_log_differenced 1063.219106 2274.691847 0.467 0.640
L3.effective_baseline_power_log_differenced 13734.516498 9105.963531 1.508 0.131
L3.effective_network_time_log_differenced 17481.328304 19440.371751 0.899 0.369
L3.new_baseline_power_log_differenced -4424.683220 8294.150936 -0.533 0.594
L3.total_mined_reward_log_differenced 69.149651 192.571843 0.359 0.720
L3.miner_count_log_differenced -0.219964 1.663099 -0.132 0.895
L3.participating_miner_count_log_differenced 1.374882 0.407427 3.375 0.001
L3.qa_smoothed_position_estimate_log_differenced 2.361986 0.962066 2.455 0.014
L3.qa_smoothed_velocity_estimate_log_differenced 0.048776 0.005759 8.470 0.000
L3.total_pledge_collateral_log_differenced 2473.959221 5588.385537 0.443 0.658
L3.total_qa_bytes_committed_log_differenced 3148.397645 2702.586809 1.165 0.244
L3.total_qa_bytes_power_log_differenced -2419.926706 2680.156838 -0.903 0.367
L3.total_raw_bytes_committed_log_differenced -1549.996179 2706.140994 -0.573 0.567
L3.total_raw_bytes_power_log_differenced 815.716248 2683.305794 0.304 0.761
L3.burnt_fil_log_differenced 14.750322 70.371806 0.210 0.834
L3.circulating_fil_log_differenced 104.331876 358.167437 0.291 0.771
L3.locked_fil_log_differenced -2392.322925 5518.655512 -0.433 0.665
L3.vested_fil_log_differenced 490.535805 1042.072309 0.471 0.638
L4.cum_sum_baseline_log_differenced -1768.135401 17385.843917 -0.102 0.919
L4.cum_sum_realized_log_differenced 987.398625 2119.505756 0.466 0.641
L4.effective_baseline_power_log_differenced 3643.067623 8664.638413 0.420 0.674
L4.effective_network_time_log_differenced 622.431463 18347.718557 0.034 0.973
L4.new_baseline_power_log_differenced -3526.940221 7694.530276 -0.458 0.647
L4.total_mined_reward_log_differenced 378.822204 192.701634 1.966 0.049
L4.miner_count_log_differenced -5.101466 1.662980 -3.068 0.002
L4.participating_miner_count_log_differenced -0.186650 0.407179 -0.458 0.647
L4.qa_smoothed_position_estimate_log_differenced 9.194079 0.960956 9.568 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.048930 0.005636 8.681 0.000
L4.total_pledge_collateral_log_differenced 26497.072053 5583.397609 4.746 0.000
L4.total_qa_bytes_committed_log_differenced 7183.619151 2695.944504 2.665 0.008
L4.total_qa_bytes_power_log_differenced -5089.896113 2674.194831 -1.903 0.057
L4.total_raw_bytes_committed_log_differenced -8196.500851 2699.800757 -3.036 0.002
L4.total_raw_bytes_power_log_differenced 6103.265085 2677.638597 2.279 0.023
L4.burnt_fil_log_differenced -129.444963 70.454745 -1.837 0.066
L4.circulating_fil_log_differenced -677.924499 358.562291 -1.891 0.059
L4.locked_fil_log_differenced -26910.947725 5513.455068 -4.881 0.000
L4.vested_fil_log_differenced 894.247627 880.835249 1.015 0.310
===================================================================================================================
Results for equation total_pledge_collateral_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000008 0.009 0.993
L1.cum_sum_baseline_log_differenced 6781.887100 2365.355914 2.867 0.004
L1.cum_sum_realized_log_differenced -73.209279 287.621463 -0.255 0.799
L1.effective_baseline_power_log_differenced -3884.710320 1176.509900 -3.302 0.001
L1.effective_network_time_log_differenced -6642.457340 2496.480610 -2.661 0.008
L1.new_baseline_power_log_differenced 110.493987 1044.418798 0.106 0.916
L1.total_mined_reward_log_differenced 61.084097 26.177798 2.333 0.020
L1.miner_count_log_differenced 0.436929 0.225355 1.939 0.053
L1.participating_miner_count_log_differenced 0.446225 0.055281 8.072 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.334928 0.130771 2.561 0.010
L1.qa_smoothed_velocity_estimate_log_differenced -0.002329 0.000766 -3.039 0.002
L1.total_pledge_collateral_log_differenced -4566.025846 756.270582 -6.038 0.000
L1.total_qa_bytes_committed_log_differenced -2047.605459 366.311814 -5.590 0.000
L1.total_qa_bytes_power_log_differenced 1692.993371 363.413199 4.659 0.000
L1.total_raw_bytes_committed_log_differenced 2212.606292 366.970718 6.029 0.000
L1.total_raw_bytes_power_log_differenced -1857.937781 364.012790 -5.104 0.000
L1.burnt_fil_log_differenced -17.158998 9.562346 -1.794 0.073
L1.circulating_fil_log_differenced -85.005919 48.671072 -1.747 0.081
L1.locked_fil_log_differenced 4515.613190 746.790528 6.047 0.000
L1.vested_fil_log_differenced 110.045445 120.071837 0.916 0.359
L2.cum_sum_baseline_log_differenced 16337.922943 2496.345429 6.545 0.000
L2.cum_sum_realized_log_differenced 28.846328 308.739449 0.093 0.926
L2.effective_baseline_power_log_differenced -9113.996494 1234.795750 -7.381 0.000
L2.effective_network_time_log_differenced -16173.858627 2640.674587 -6.125 0.000
L2.new_baseline_power_log_differenced -157.726197 1125.878051 -0.140 0.889
L2.total_mined_reward_log_differenced -18.155900 26.149124 -0.694 0.487
L2.miner_count_log_differenced 0.136630 0.225546 0.606 0.545
L2.participating_miner_count_log_differenced 0.192512 0.055278 3.483 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.576933 0.130540 4.420 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.000654 0.000781 0.836 0.403
L2.total_pledge_collateral_log_differenced -3565.994530 758.329932 -4.702 0.000
L2.total_qa_bytes_committed_log_differenced -1678.612049 366.923659 -4.575 0.000
L2.total_qa_bytes_power_log_differenced 1367.294228 363.866117 3.758 0.000
L2.total_raw_bytes_committed_log_differenced 1616.101944 367.432317 4.398 0.000
L2.total_raw_bytes_power_log_differenced -1305.269330 364.320035 -3.583 0.000
L2.burnt_fil_log_differenced 13.944198 9.554287 1.459 0.144
L2.circulating_fil_log_differenced 60.650146 48.628093 1.247 0.212
L2.locked_fil_log_differenced 3605.907724 748.873036 4.815 0.000
L2.vested_fil_log_differenced -70.081911 141.501497 -0.495 0.620
L3.cum_sum_baseline_log_differenced 1429.184707 2494.102193 0.573 0.567
L3.cum_sum_realized_log_differenced 14.485718 308.651342 0.047 0.963
L3.effective_baseline_power_log_differenced -752.029186 1235.581806 -0.609 0.543
L3.effective_network_time_log_differenced -1416.362503 2637.850411 -0.537 0.591
L3.new_baseline_power_log_differenced -3.866671 1125.427524 -0.003 0.997
L3.total_mined_reward_log_differenced 51.703486 26.129938 1.979 0.048
L3.miner_count_log_differenced 0.303918 0.225665 1.347 0.178
L3.participating_miner_count_log_differenced -0.040954 0.055283 -0.741 0.459
L3.qa_smoothed_position_estimate_log_differenced -0.188906 0.130542 -1.447 0.148
L3.qa_smoothed_velocity_estimate_log_differenced 0.001724 0.000781 2.206 0.027
L3.total_pledge_collateral_log_differenced 88.935022 758.284115 0.117 0.907
L3.total_qa_bytes_committed_log_differenced -37.386282 366.712109 -0.102 0.919
L3.total_qa_bytes_power_log_differenced -37.492059 363.668602 -0.103 0.918
L3.total_raw_bytes_committed_log_differenced -148.539692 367.194374 -0.405 0.686
L3.total_raw_bytes_power_log_differenced 223.697257 364.095882 0.614 0.539
L3.burnt_fil_log_differenced -23.646926 9.548701 -2.476 0.013
L3.circulating_fil_log_differenced -121.800450 48.599488 -2.506 0.012
L3.locked_fil_log_differenced -160.886741 748.822497 -0.215 0.830
L3.vested_fil_log_differenced 87.587766 141.398061 0.619 0.536
L4.cum_sum_baseline_log_differenced 2509.514454 2359.072970 1.064 0.287
L4.cum_sum_realized_log_differenced 51.605262 287.594250 0.179 0.858
L4.effective_baseline_power_log_differenced -1142.431043 1175.698710 -0.972 0.331
L4.effective_network_time_log_differenced -2567.591154 2489.589065 -1.031 0.302
L4.new_baseline_power_log_differenced -280.471845 1044.065418 -0.269 0.788
L4.total_mined_reward_log_differenced 170.549332 26.147550 6.523 0.000
L4.miner_count_log_differenced 0.858130 0.225649 3.803 0.000
L4.participating_miner_count_log_differenced 0.169092 0.055250 3.061 0.002
L4.qa_smoothed_position_estimate_log_differenced -0.626254 0.130392 -4.803 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000497 0.000765 0.650 0.516
L4.total_pledge_collateral_log_differenced -2379.154881 757.607306 -3.140 0.002
L4.total_qa_bytes_committed_log_differenced 293.097287 365.810819 0.801 0.423
L4.total_qa_bytes_power_log_differenced -567.105971 362.859621 -1.563 0.118
L4.total_raw_bytes_committed_log_differenced -193.873350 366.334072 -0.529 0.597
L4.total_raw_bytes_power_log_differenced 467.515605 363.326904 1.287 0.198
L4.burnt_fil_log_differenced -58.998466 9.559955 -6.171 0.000
L4.circulating_fil_log_differenced -304.670256 48.653066 -6.262 0.000
L4.locked_fil_log_differenced 2199.802108 748.116852 2.940 0.003
L4.vested_fil_log_differenced 362.910297 119.519917 3.036 0.002
===================================================================================================================
Results for equation total_qa_bytes_committed_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000013 0.008 0.993
L1.cum_sum_baseline_log_differenced 9716.040688 3771.967114 2.576 0.010
L1.cum_sum_realized_log_differenced -143.748083 458.661926 -0.313 0.754
L1.effective_baseline_power_log_differenced -5655.426868 1876.147528 -3.014 0.003
L1.effective_network_time_log_differenced -9475.854144 3981.068010 -2.380 0.017
L1.new_baseline_power_log_differenced 289.952089 1665.505532 0.174 0.862
L1.total_mined_reward_log_differenced 88.563668 41.745005 2.122 0.034
L1.miner_count_log_differenced 0.748832 0.359367 2.084 0.037
L1.participating_miner_count_log_differenced 0.723838 0.088156 8.211 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.612580 0.208537 2.938 0.003
L1.qa_smoothed_velocity_estimate_log_differenced -0.003719 0.001222 -3.043 0.002
L1.total_pledge_collateral_log_differenced -6733.619864 1206.003607 -5.583 0.000
L1.total_qa_bytes_committed_log_differenced -3219.159809 584.147234 -5.511 0.000
L1.total_qa_bytes_power_log_differenced 2676.360650 579.524894 4.618 0.000
L1.total_raw_bytes_committed_log_differenced 3488.380168 585.197971 5.961 0.000
L1.total_raw_bytes_power_log_differenced -2945.585710 580.481045 -5.074 0.000
L1.burnt_fil_log_differenced -24.638700 15.248807 -1.616 0.106
L1.circulating_fil_log_differenced -121.182126 77.614401 -1.561 0.118
L1.locked_fil_log_differenced 6662.378464 1190.886029 5.594 0.000
L1.vested_fil_log_differenced 148.803507 191.475210 0.777 0.437
L2.cum_sum_baseline_log_differenced 25773.875440 3980.852441 6.474 0.000
L2.cum_sum_realized_log_differenced 22.926214 492.338190 0.047 0.963
L2.effective_baseline_power_log_differenced -14441.998824 1969.094349 -7.334 0.000
L2.effective_network_time_log_differenced -25489.009464 4211.010125 -6.053 0.000
L2.new_baseline_power_log_differenced -149.650170 1795.406331 -0.083 0.934
L2.total_mined_reward_log_differenced -25.515050 41.699279 -0.612 0.541
L2.miner_count_log_differenced 0.194370 0.359673 0.540 0.589
L2.participating_miner_count_log_differenced 0.306346 0.088150 3.475 0.001
L2.qa_smoothed_position_estimate_log_differenced 0.972450 0.208168 4.671 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.001013 0.001246 0.813 0.416
L2.total_pledge_collateral_log_differenced -5514.823216 1209.287596 -4.560 0.000
L2.total_qa_bytes_committed_log_differenced -2644.053155 585.122926 -4.519 0.000
L2.total_qa_bytes_power_log_differenced 2162.326208 580.247149 3.727 0.000
L2.total_raw_bytes_committed_log_differenced 2543.525047 585.934070 4.341 0.000
L2.total_raw_bytes_power_log_differenced -2062.638635 580.971000 -3.550 0.000
L2.burnt_fil_log_differenced 20.788967 15.235956 1.364 0.172
L2.circulating_fil_log_differenced 89.184121 77.545864 1.150 0.250
L2.locked_fil_log_differenced 5574.189870 1194.206948 4.668 0.000
L2.vested_fil_log_differenced -118.165801 225.648492 -0.524 0.601
L3.cum_sum_baseline_log_differenced 1613.365189 3977.275214 0.406 0.685
L3.cum_sum_realized_log_differenced 15.383742 492.197687 0.031 0.975
L3.effective_baseline_power_log_differenced -848.027090 1970.347850 -0.430 0.667
L3.effective_network_time_log_differenced -1590.613059 4206.506489 -0.378 0.705
L3.new_baseline_power_log_differenced 41.819513 1794.687889 0.023 0.981
L3.total_mined_reward_log_differenced 85.486485 41.668684 2.052 0.040
L3.miner_count_log_differenced 0.520661 0.359861 1.447 0.148
L3.participating_miner_count_log_differenced -0.075006 0.088159 -0.851 0.395
L3.qa_smoothed_position_estimate_log_differenced -0.262986 0.208172 -1.263 0.206
L3.qa_smoothed_velocity_estimate_log_differenced 0.002702 0.001246 2.168 0.030
L3.total_pledge_collateral_log_differenced 364.359048 1209.214532 0.301 0.763
L3.total_qa_bytes_committed_log_differenced -15.562120 584.785574 -0.027 0.979
L3.total_qa_bytes_power_log_differenced -95.901321 579.932178 -0.165 0.869
L3.total_raw_bytes_committed_log_differenced -280.558419 585.554628 -0.479 0.632
L3.total_raw_bytes_power_log_differenced 392.414974 580.613549 0.676 0.499
L3.burnt_fil_log_differenced -38.714217 15.227047 -2.542 0.011
L3.circulating_fil_log_differenced -199.150697 77.500249 -2.570 0.010
L3.locked_fil_log_differenced -481.978273 1194.126353 -0.404 0.686
L3.vested_fil_log_differenced 126.612126 225.483545 0.562 0.574
L4.cum_sum_baseline_log_differenced 3678.183870 3761.947878 0.978 0.328
L4.cum_sum_realized_log_differenced 46.815734 458.618530 0.102 0.919
L4.effective_baseline_power_log_differenced -1737.690177 1874.853947 -0.927 0.354
L4.effective_network_time_log_differenced -3735.207422 3970.078256 -0.941 0.347
L4.new_baseline_power_log_differenced -308.587404 1664.942006 -0.185 0.853
L4.total_mined_reward_log_differenced 269.796651 41.696768 6.470 0.000
L4.miner_count_log_differenced 1.347998 0.359835 3.746 0.000
L4.participating_miner_count_log_differenced 0.260542 0.088105 2.957 0.003
L4.qa_smoothed_position_estimate_log_differenced -1.047132 0.207932 -5.036 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000816 0.001220 0.669 0.503
L4.total_pledge_collateral_log_differenced -3617.689332 1208.135244 -2.994 0.003
L4.total_qa_bytes_committed_log_differenced 453.881641 583.348312 0.778 0.437
L4.total_qa_bytes_power_log_differenced -882.575962 578.642119 -1.525 0.127
L4.total_raw_bytes_committed_log_differenced -302.728588 584.182728 -0.518 0.604
L4.total_raw_bytes_power_log_differenced 730.832561 579.387281 1.261 0.207
L4.burnt_fil_log_differenced -93.571296 15.244994 -6.138 0.000
L4.circulating_fil_log_differenced -483.234733 77.585687 -6.228 0.000
L4.locked_fil_log_differenced 3333.447603 1193.001081 2.794 0.005
L4.vested_fil_log_differenced 567.341953 190.595079 2.977 0.003
===================================================================================================================
Results for equation total_qa_bytes_power_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000013 0.008 0.993
L1.cum_sum_baseline_log_differenced 9716.348592 3772.310507 2.576 0.010
L1.cum_sum_realized_log_differenced -143.823983 458.703681 -0.314 0.754
L1.effective_baseline_power_log_differenced -5655.781144 1876.318330 -3.014 0.003
L1.effective_network_time_log_differenced -9476.082684 3981.430440 -2.380 0.017
L1.new_baseline_power_log_differenced 290.187160 1665.657157 0.174 0.862
L1.total_mined_reward_log_differenced 88.570932 41.748805 2.122 0.034
L1.miner_count_log_differenced 0.748881 0.359400 2.084 0.037
L1.participating_miner_count_log_differenced 0.723864 0.088164 8.210 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.612638 0.208556 2.938 0.003
L1.qa_smoothed_velocity_estimate_log_differenced -0.003719 0.001222 -3.043 0.002
L1.total_pledge_collateral_log_differenced -6734.552497 1206.113400 -5.584 0.000
L1.total_qa_bytes_committed_log_differenced -3219.349770 584.200414 -5.511 0.000
L1.total_qa_bytes_power_log_differenced 2676.487155 579.577653 4.618 0.000
L1.total_raw_bytes_committed_log_differenced 3488.603721 585.251246 5.961 0.000
L1.total_raw_bytes_power_log_differenced -2945.745804 580.533891 -5.074 0.000
L1.burnt_fil_log_differenced -24.640806 15.250195 -1.616 0.106
L1.circulating_fil_log_differenced -121.192050 77.621466 -1.561 0.118
L1.locked_fil_log_differenced 6663.304326 1190.994446 5.595 0.000
L1.vested_fil_log_differenced 148.833213 191.492642 0.777 0.437
L2.cum_sum_baseline_log_differenced 25774.645808 3981.214851 6.474 0.000
L2.cum_sum_realized_log_differenced 22.923541 492.383012 0.047 0.963
L2.effective_baseline_power_log_differenced -14442.439340 1969.273612 -7.334 0.000
L2.effective_network_time_log_differenced -25489.767507 4211.393488 -6.053 0.000
L2.new_baseline_power_log_differenced -149.661399 1795.569781 -0.083 0.934
L2.total_mined_reward_log_differenced -25.540665 41.703075 -0.612 0.540
L2.miner_count_log_differenced 0.194519 0.359705 0.541 0.589
L2.participating_miner_count_log_differenced 0.306363 0.088158 3.475 0.001
L2.qa_smoothed_position_estimate_log_differenced 0.972537 0.208187 4.671 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.001014 0.001246 0.813 0.416
L2.total_pledge_collateral_log_differenced -5515.057328 1209.397687 -4.560 0.000
L2.total_qa_bytes_committed_log_differenced -2644.225312 585.176195 -4.519 0.000
L2.total_qa_bytes_power_log_differenced 2162.444507 580.299974 3.726 0.000
L2.total_raw_bytes_committed_log_differenced 2543.693675 585.987412 4.341 0.000
L2.total_raw_bytes_power_log_differenced -2062.753479 581.023891 -3.550 0.000
L2.burnt_fil_log_differenced 20.799194 15.237343 1.365 0.172
L2.circulating_fil_log_differenced 89.235549 77.552924 1.151 0.250
L2.locked_fil_log_differenced 5574.454867 1194.315666 4.667 0.000
L2.vested_fil_log_differenced -118.213766 225.669034 -0.524 0.600
L3.cum_sum_baseline_log_differenced 1612.124490 3977.637299 0.405 0.685
L3.cum_sum_realized_log_differenced 15.369152 492.242496 0.031 0.975
L3.effective_baseline_power_log_differenced -847.359819 1970.527227 -0.430 0.667
L3.effective_network_time_log_differenced -1589.371467 4206.889442 -0.378 0.706
L3.new_baseline_power_log_differenced 41.858195 1794.851274 0.023 0.981
L3.total_mined_reward_log_differenced 85.479243 41.672477 2.051 0.040
L3.miner_count_log_differenced 0.520753 0.359894 1.447 0.148
L3.participating_miner_count_log_differenced -0.074998 0.088167 -0.851 0.395
L3.qa_smoothed_position_estimate_log_differenced -0.262981 0.208191 -1.263 0.207
L3.qa_smoothed_velocity_estimate_log_differenced 0.002702 0.001246 2.168 0.030
L3.total_pledge_collateral_log_differenced 364.525269 1209.324617 0.301 0.763
L3.total_qa_bytes_committed_log_differenced -15.408788 584.838812 -0.026 0.979
L3.total_qa_bytes_power_log_differenced -96.077219 579.984974 -0.166 0.868
L3.total_raw_bytes_committed_log_differenced -280.716774 585.607936 -0.479 0.632
L3.total_raw_bytes_power_log_differenced 392.595902 580.666407 0.676 0.499
L3.burnt_fil_log_differenced -38.712263 15.228434 -2.542 0.011
L3.circulating_fil_log_differenced -199.140293 77.507304 -2.569 0.010
L3.locked_fil_log_differenced -482.138842 1194.235064 -0.404 0.686
L3.vested_fil_log_differenced 126.607566 225.504072 0.561 0.574
L4.cum_sum_baseline_log_differenced 3678.355494 3762.290359 0.978 0.328
L4.cum_sum_realized_log_differenced 46.798561 458.660282 0.102 0.919
L4.effective_baseline_power_log_differenced -1737.816326 1875.024631 -0.927 0.354
L4.effective_network_time_log_differenced -3735.362813 3970.439685 -0.941 0.347
L4.new_baseline_power_log_differenced -308.552446 1665.093579 -0.185 0.853
L4.total_mined_reward_log_differenced 269.808320 41.700564 6.470 0.000
L4.miner_count_log_differenced 1.348160 0.359868 3.746 0.000
L4.participating_miner_count_log_differenced 0.260576 0.088113 2.957 0.003
L4.qa_smoothed_position_estimate_log_differenced -1.047203 0.207951 -5.036 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000816 0.001220 0.669 0.504
L4.total_pledge_collateral_log_differenced -3618.384247 1208.245231 -2.995 0.003
L4.total_qa_bytes_committed_log_differenced 453.995200 583.401419 0.778 0.436
L4.total_qa_bytes_power_log_differenced -882.737954 578.694798 -1.525 0.127
L4.total_raw_bytes_committed_log_differenced -302.808303 584.235911 -0.518 0.604
L4.total_raw_bytes_power_log_differenced 730.960648 579.440028 1.261 0.207
L4.burnt_fil_log_differenced -93.575230 15.246382 -6.138 0.000
L4.circulating_fil_log_differenced -483.255138 77.592751 -6.228 0.000
L4.locked_fil_log_differenced 3334.129696 1193.109690 2.794 0.005
L4.vested_fil_log_differenced 567.380423 190.612431 2.977 0.003
===================================================================================================================
Results for equation total_raw_bytes_committed_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000013 0.008 0.993
L1.cum_sum_baseline_log_differenced 9712.512621 3771.247797 2.575 0.010
L1.cum_sum_realized_log_differenced -143.702541 458.574459 -0.313 0.754
L1.effective_baseline_power_log_differenced -5653.361799 1875.789746 -3.014 0.003
L1.effective_network_time_log_differenced -9472.405996 3980.308818 -2.380 0.017
L1.new_baseline_power_log_differenced 289.887581 1665.187920 0.174 0.862
L1.total_mined_reward_log_differenced 88.558664 41.737044 2.122 0.034
L1.miner_count_log_differenced 0.748839 0.359299 2.084 0.037
L1.participating_miner_count_log_differenced 0.723645 0.088139 8.210 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.612501 0.208497 2.938 0.003
L1.qa_smoothed_velocity_estimate_log_differenced -0.003718 0.001222 -3.043 0.002
L1.total_pledge_collateral_log_differenced -6731.661726 1205.773622 -5.583 0.000
L1.total_qa_bytes_committed_log_differenced -3217.918734 584.035837 -5.510 0.000
L1.total_qa_bytes_power_log_differenced 2675.239654 579.414378 4.617 0.000
L1.total_raw_bytes_committed_log_differenced 3487.060177 585.086373 5.960 0.000
L1.total_raw_bytes_power_log_differenced -2944.385859 580.370347 -5.073 0.000
L1.burnt_fil_log_differenced -24.637028 15.245899 -1.616 0.106
L1.circulating_fil_log_differenced -121.176399 77.599599 -1.562 0.118
L1.locked_fil_log_differenced 6660.423286 1190.658927 5.594 0.000
L1.vested_fil_log_differenced 148.739092 191.438696 0.777 0.437
L2.cum_sum_baseline_log_differenced 25766.607558 3980.093291 6.474 0.000
L2.cum_sum_realized_log_differenced 22.894392 492.244301 0.047 0.963
L2.effective_baseline_power_log_differenced -14438.009881 1968.718841 -7.334 0.000
L2.effective_network_time_log_differenced -25481.789915 4210.207083 -6.052 0.000
L2.new_baseline_power_log_differenced -149.479657 1795.063946 -0.083 0.934
L2.total_mined_reward_log_differenced -25.514476 41.691327 -0.612 0.541
L2.miner_count_log_differenced 0.194299 0.359604 0.540 0.589
L2.participating_miner_count_log_differenced 0.306227 0.088133 3.475 0.001
L2.qa_smoothed_position_estimate_log_differenced 0.972181 0.208129 4.671 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.001013 0.001246 0.813 0.416
L2.total_pledge_collateral_log_differenced -5513.623781 1209.056984 -4.560 0.000
L2.total_qa_bytes_committed_log_differenced -2643.385119 585.011343 -4.519 0.000
L2.total_qa_bytes_power_log_differenced 2161.763729 580.136496 3.726 0.000
L2.total_raw_bytes_committed_log_differenced 2542.871864 585.822332 4.341 0.000
L2.total_raw_bytes_power_log_differenced -2062.090733 580.860209 -3.550 0.000
L2.burnt_fil_log_differenced 20.785810 15.233050 1.365 0.172
L2.circulating_fil_log_differenced 89.172753 77.531076 1.150 0.250
L2.locked_fil_log_differenced 5572.981918 1193.979212 4.668 0.000
L2.vested_fil_log_differenced -118.176441 225.605460 -0.524 0.600
L3.cum_sum_baseline_log_differenced 1612.747847 3976.516746 0.406 0.685
L3.cum_sum_realized_log_differenced 15.558501 492.103825 0.032 0.975
L3.effective_baseline_power_log_differenced -847.205939 1969.972104 -0.430 0.667
L3.effective_network_time_log_differenced -1590.187196 4205.704306 -0.378 0.705
L3.new_baseline_power_log_differenced 41.169912 1794.345641 0.023 0.982
L3.total_mined_reward_log_differenced 85.455766 41.660738 2.051 0.040
L3.miner_count_log_differenced 0.520643 0.359793 1.447 0.148
L3.participating_miner_count_log_differenced -0.074979 0.088142 -0.851 0.395
L3.qa_smoothed_position_estimate_log_differenced -0.262887 0.208132 -1.263 0.207
L3.qa_smoothed_velocity_estimate_log_differenced 0.002701 0.001246 2.168 0.030
L3.total_pledge_collateral_log_differenced 363.963280 1208.983934 0.301 0.763
L3.total_qa_bytes_committed_log_differenced -15.331247 584.674055 -0.026 0.979
L3.total_qa_bytes_power_log_differenced -96.106230 579.821585 -0.166 0.868
L3.total_raw_bytes_committed_log_differenced -280.740568 585.442962 -0.480 0.632
L3.total_raw_bytes_power_log_differenced 392.571030 580.502826 0.676 0.499
L3.burnt_fil_log_differenced -38.702139 15.224143 -2.542 0.011
L3.circulating_fil_log_differenced -199.087594 77.485470 -2.569 0.010
L3.locked_fil_log_differenced -481.544876 1193.898633 -0.403 0.687
L3.vested_fil_log_differenced 126.540583 225.440545 0.561 0.575
L4.cum_sum_baseline_log_differenced 3676.801516 3761.230472 0.978 0.328
L4.cum_sum_realized_log_differenced 46.974126 458.531071 0.102 0.918
L4.effective_baseline_power_log_differenced -1736.530758 1874.496412 -0.926 0.354
L4.effective_network_time_log_differenced -3733.993469 3969.321160 -0.941 0.347
L4.new_baseline_power_log_differenced -309.097455 1664.624500 -0.186 0.853
L4.total_mined_reward_log_differenced 269.738506 41.688817 6.470 0.000
L4.miner_count_log_differenced 1.347941 0.359767 3.747 0.000
L4.participating_miner_count_log_differenced 0.260469 0.088089 2.957 0.003
L4.qa_smoothed_position_estimate_log_differenced -1.046785 0.207892 -5.035 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000815 0.001219 0.669 0.504
L4.total_pledge_collateral_log_differenced -3617.031743 1207.904852 -2.994 0.003
L4.total_qa_bytes_committed_log_differenced 454.001442 583.237067 0.778 0.436
L4.total_qa_bytes_power_log_differenced -882.606991 578.531772 -1.526 0.127
L4.total_raw_bytes_committed_log_differenced -302.875677 584.071324 -0.519 0.604
L4.total_raw_bytes_power_log_differenced 730.891028 579.276792 1.262 0.207
L4.burnt_fil_log_differenced -93.550090 15.242086 -6.138 0.000
L4.circulating_fil_log_differenced -483.125038 77.570892 -6.228 0.000
L4.locked_fil_log_differenced 3332.854602 1192.773575 2.794 0.005
L4.vested_fil_log_differenced 567.168862 190.558733 2.976 0.003
===================================================================================================================
Results for equation total_raw_bytes_power_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000013 0.008 0.993
L1.cum_sum_baseline_log_differenced 9713.102375 3771.579491 2.575 0.010
L1.cum_sum_realized_log_differenced -143.768587 458.614792 -0.313 0.754
L1.effective_baseline_power_log_differenced -5653.848074 1875.954728 -3.014 0.003
L1.effective_network_time_log_differenced -9472.923428 3980.658900 -2.380 0.017
L1.new_baseline_power_log_differenced 290.084763 1665.334378 0.174 0.862
L1.total_mined_reward_log_differenced 88.564915 41.740715 2.122 0.034
L1.miner_count_log_differenced 0.748902 0.359330 2.084 0.037
L1.participating_miner_count_log_differenced 0.723677 0.088147 8.210 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.612544 0.208516 2.938 0.003
L1.qa_smoothed_velocity_estimate_log_differenced -0.003718 0.001222 -3.043 0.002
L1.total_pledge_collateral_log_differenced -6732.653049 1205.879673 -5.583 0.000
L1.total_qa_bytes_committed_log_differenced -3218.212934 584.087205 -5.510 0.000
L1.total_qa_bytes_power_log_differenced 2675.470528 579.465340 4.617 0.000
L1.total_raw_bytes_committed_log_differenced 3487.385672 585.137834 5.960 0.000
L1.total_raw_bytes_power_log_differenced -2944.648008 580.421392 -5.073 0.000
L1.burnt_fil_log_differenced -24.638782 15.247240 -1.616 0.106
L1.circulating_fil_log_differenced -121.184607 77.606425 -1.562 0.118
L1.locked_fil_log_differenced 6661.408971 1190.763649 5.594 0.000
L1.vested_fil_log_differenced 148.768252 191.455533 0.777 0.437
L2.cum_sum_baseline_log_differenced 25767.218886 3980.443353 6.473 0.000
L2.cum_sum_realized_log_differenced 22.898621 492.287595 0.047 0.963
L2.effective_baseline_power_log_differenced -14438.343458 1968.891997 -7.333 0.000
L2.effective_network_time_log_differenced -25482.397335 4210.577385 -6.052 0.000
L2.new_baseline_power_log_differenced -149.512133 1795.221828 -0.083 0.934
L2.total_mined_reward_log_differenced -25.542005 41.694994 -0.613 0.540
L2.miner_count_log_differenced 0.194464 0.359636 0.541 0.589
L2.participating_miner_count_log_differenced 0.306242 0.088141 3.474 0.001
L2.qa_smoothed_position_estimate_log_differenced 0.972261 0.208147 4.671 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.001013 0.001246 0.813 0.416
L2.total_pledge_collateral_log_differenced -5513.783581 1209.163324 -4.560 0.000
L2.total_qa_bytes_committed_log_differenced -2643.554424 585.062797 -4.518 0.000
L2.total_qa_bytes_power_log_differenced 2161.881646 580.187521 3.726 0.000
L2.total_raw_bytes_committed_log_differenced 2543.036608 585.873857 4.341 0.000
L2.total_raw_bytes_power_log_differenced -2062.204157 580.911297 -3.550 0.000
L2.burnt_fil_log_differenced 20.796694 15.234390 1.365 0.172
L2.circulating_fil_log_differenced 89.227543 77.537895 1.151 0.250
L2.locked_fil_log_differenced 5573.174641 1194.084226 4.667 0.000
L2.vested_fil_log_differenced -118.231830 225.625303 -0.524 0.600
L3.cum_sum_baseline_log_differenced 1611.194859 3976.866494 0.405 0.685
L3.cum_sum_realized_log_differenced 15.548895 492.147107 0.032 0.975
L3.effective_baseline_power_log_differenced -846.351644 1970.145369 -0.430 0.667
L3.effective_network_time_log_differenced -1588.641633 4206.074212 -0.378 0.706
L3.new_baseline_power_log_differenced 41.195190 1794.503459 0.023 0.982
L3.total_mined_reward_log_differenced 85.446138 41.664402 2.051 0.040
L3.miner_count_log_differenced 0.520763 0.359824 1.447 0.148
L3.participating_miner_count_log_differenced -0.074980 0.088150 -0.851 0.395
L3.qa_smoothed_position_estimate_log_differenced -0.262889 0.208150 -1.263 0.207
L3.qa_smoothed_velocity_estimate_log_differenced 0.002701 0.001246 2.168 0.030
L3.total_pledge_collateral_log_differenced 364.197200 1209.090268 0.301 0.763
L3.total_qa_bytes_committed_log_differenced -15.237028 584.725479 -0.026 0.979
L3.total_qa_bytes_power_log_differenced -96.221974 579.872582 -0.166 0.868
L3.total_raw_bytes_committed_log_differenced -280.838376 585.494454 -0.480 0.631
L3.total_raw_bytes_power_log_differenced 392.690380 580.553883 0.676 0.499
L3.burnt_fil_log_differenced -38.699380 15.225482 -2.542 0.011
L3.circulating_fil_log_differenced -199.072826 77.492285 -2.569 0.010
L3.locked_fil_log_differenced -481.770522 1194.003640 -0.403 0.687
L3.vested_fil_log_differenced 126.527890 225.460373 0.561 0.575
L4.cum_sum_baseline_log_differenced 3677.031133 3761.561285 0.978 0.328
L4.cum_sum_realized_log_differenced 46.960714 458.571401 0.102 0.918
L4.effective_baseline_power_log_differenced -1736.681531 1874.661280 -0.926 0.354
L4.effective_network_time_log_differenced -3734.209275 3969.670275 -0.941 0.347
L4.new_baseline_power_log_differenced -309.074774 1664.770910 -0.186 0.853
L4.total_mined_reward_log_differenced 269.745510 41.692483 6.470 0.000
L4.miner_count_log_differenced 1.348102 0.359799 3.747 0.000
L4.participating_miner_count_log_differenced 0.260501 0.088096 2.957 0.003
L4.qa_smoothed_position_estimate_log_differenced -1.046858 0.207910 -5.035 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000815 0.001219 0.669 0.504
L4.total_pledge_collateral_log_differenced -3617.676211 1208.011092 -2.995 0.003
L4.total_qa_bytes_committed_log_differenced 454.064345 583.288365 0.778 0.436
L4.total_qa_bytes_power_log_differenced -882.715515 578.582656 -1.526 0.127
L4.total_raw_bytes_committed_log_differenced -302.907517 584.122695 -0.519 0.604
L4.total_raw_bytes_power_log_differenced 730.968442 579.327741 1.262 0.207
L4.burnt_fil_log_differenced -93.552372 15.243427 -6.137 0.000
L4.circulating_fil_log_differenced -483.137071 77.577714 -6.228 0.000
L4.locked_fil_log_differenced 3333.491328 1192.878484 2.794 0.005
L4.vested_fil_log_differenced 567.196741 190.575493 2.976 0.003
===================================================================================================================
Results for equation burnt_fil_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000003 0.004 0.997
L1.cum_sum_baseline_log_differenced 1749.490625 746.789188 2.343 0.019
L1.cum_sum_realized_log_differenced -39.353279 90.807729 -0.433 0.665
L1.effective_baseline_power_log_differenced -1053.990858 371.447218 -2.838 0.005
L1.effective_network_time_log_differenced -1691.854699 788.187823 -2.147 0.032
L1.new_baseline_power_log_differenced 108.809550 329.743470 0.330 0.741
L1.total_mined_reward_log_differenced 23.429507 8.264844 2.835 0.005
L1.miner_count_log_differenced 0.108121 0.071149 1.520 0.129
L1.participating_miner_count_log_differenced 0.127758 0.017453 7.320 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.171643 0.041287 4.157 0.000
L1.qa_smoothed_velocity_estimate_log_differenced -0.000810 0.000242 -3.347 0.001
L1.total_pledge_collateral_log_differenced -1331.072180 238.769435 -5.575 0.000
L1.total_qa_bytes_committed_log_differenced -520.241860 115.651814 -4.498 0.000
L1.total_qa_bytes_power_log_differenced 413.377199 114.736664 3.603 0.000
L1.total_raw_bytes_committed_log_differenced 578.876118 115.859843 4.996 0.000
L1.total_raw_bytes_power_log_differenced -472.070843 114.925967 -4.108 0.000
L1.burnt_fil_log_differenced -6.870286 3.019020 -2.276 0.023
L1.circulating_fil_log_differenced -34.338738 15.366411 -2.235 0.025
L1.locked_fil_log_differenced 1310.554722 235.776396 5.558 0.000
L1.vested_fil_log_differenced 33.035694 37.909031 0.871 0.384
L2.cum_sum_baseline_log_differenced 5235.259537 788.145144 6.643 0.000
L2.cum_sum_realized_log_differenced -5.910183 97.475091 -0.061 0.952
L2.effective_baseline_power_log_differenced -2963.199126 389.849202 -7.601 0.000
L2.effective_network_time_log_differenced -5166.870074 833.712686 -6.197 0.000
L2.new_baseline_power_log_differenced 5.604732 355.461751 0.016 0.987
L2.total_mined_reward_log_differenced -3.224957 8.255791 -0.391 0.696
L2.miner_count_log_differenced 0.028103 0.071209 0.395 0.693
L2.participating_miner_count_log_differenced 0.061632 0.017452 3.531 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.184223 0.041214 4.470 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.000293 0.000247 1.188 0.235
L2.total_pledge_collateral_log_differenced -1279.515890 239.419612 -5.344 0.000
L2.total_qa_bytes_committed_log_differenced -571.256594 115.844985 -4.931 0.000
L2.total_qa_bytes_power_log_differenced 471.337839 114.879660 4.103 0.000
L2.total_raw_bytes_committed_log_differenced 557.999689 116.005579 4.810 0.000
L2.total_raw_bytes_power_log_differenced -458.238767 115.022970 -3.984 0.000
L2.burnt_fil_log_differenced 3.143356 3.016476 1.042 0.297
L2.circulating_fil_log_differenced 13.118427 15.352841 0.854 0.393
L2.locked_fil_log_differenced 1288.505573 236.433885 5.450 0.000
L2.vested_fil_log_differenced -12.123051 44.674794 -0.271 0.786
L3.cum_sum_baseline_log_differenced 403.087860 787.436910 0.512 0.609
L3.cum_sum_realized_log_differenced 9.457461 97.447274 0.097 0.923
L3.effective_baseline_power_log_differenced -191.846871 390.097376 -0.492 0.623
L3.effective_network_time_log_differenced -406.163563 832.821038 -0.488 0.626
L3.new_baseline_power_log_differenced -22.571378 355.319511 -0.064 0.949
L3.total_mined_reward_log_differenced 25.171756 8.249733 3.051 0.002
L3.miner_count_log_differenced 0.082016 0.071247 1.151 0.250
L3.participating_miner_count_log_differenced -0.008129 0.017454 -0.466 0.641
L3.qa_smoothed_position_estimate_log_differenced -0.016108 0.041215 -0.391 0.696
L3.qa_smoothed_velocity_estimate_log_differenced 0.000672 0.000247 2.722 0.006
L3.total_pledge_collateral_log_differenced -108.015556 239.405146 -0.451 0.652
L3.total_qa_bytes_committed_log_differenced 135.941376 115.778195 1.174 0.240
L3.total_qa_bytes_power_log_differenced -160.567034 114.817300 -1.398 0.162
L3.total_raw_bytes_committed_log_differenced -194.868538 115.930455 -1.681 0.093
L3.total_raw_bytes_power_log_differenced 219.533262 114.952201 1.910 0.056
L3.burnt_fil_log_differenced -10.720266 3.014712 -3.556 0.000
L3.circulating_fil_log_differenced -54.854125 15.343810 -3.575 0.000
L3.locked_fil_log_differenced 75.374679 236.417928 0.319 0.750
L3.vested_fil_log_differenced 47.712668 44.642137 1.069 0.285
L4.cum_sum_baseline_log_differenced 540.677628 744.805540 0.726 0.468
L4.cum_sum_realized_log_differenced 4.359393 90.799137 0.048 0.962
L4.effective_baseline_power_log_differenced -251.735405 371.191109 -0.678 0.498
L4.effective_network_time_log_differenced -549.517965 786.012027 -0.699 0.484
L4.new_baseline_power_log_differenced -35.621386 329.631901 -0.108 0.914
L4.total_mined_reward_log_differenced 63.436447 8.255294 7.684 0.000
L4.miner_count_log_differenced 0.239736 0.071242 3.365 0.001
L4.participating_miner_count_log_differenced 0.049827 0.017443 2.857 0.004
L4.qa_smoothed_position_estimate_log_differenced -0.204135 0.041167 -4.959 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000209 0.000241 0.867 0.386
L4.total_pledge_collateral_log_differenced -839.203150 239.191465 -3.508 0.000
L4.total_qa_bytes_committed_log_differenced 139.803338 115.493640 1.210 0.226
L4.total_qa_bytes_power_log_differenced -227.783446 114.561889 -1.988 0.047
L4.total_raw_bytes_committed_log_differenced -99.117007 115.658841 -0.857 0.391
L4.total_raw_bytes_power_log_differenced 186.945551 114.709419 1.630 0.103
L4.burnt_fil_log_differenced -22.155180 3.018265 -7.340 0.000
L4.circulating_fil_log_differenced -113.878688 15.360726 -7.414 0.000
L4.locked_fil_log_differenced 771.880797 236.195142 3.268 0.001
L4.vested_fil_log_differenced 128.327281 37.734779 3.401 0.001
===================================================================================================================
Results for equation circulating_fil_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000008 0.010 0.992
L1.cum_sum_baseline_log_differenced 6930.765972 2179.989968 3.179 0.001
L1.cum_sum_realized_log_differenced -41.495464 265.081420 -0.157 0.876
L1.effective_baseline_power_log_differenced -3891.452717 1084.310300 -3.589 0.000
L1.effective_network_time_log_differenced -6822.332598 2300.838810 -2.965 0.003
L1.new_baseline_power_log_differenced -6.345853 962.570787 -0.007 0.995
L1.total_mined_reward_log_differenced 51.670519 24.126322 2.142 0.032
L1.miner_count_log_differenced 0.392184 0.207694 1.888 0.059
L1.participating_miner_count_log_differenced 0.429153 0.050949 8.423 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.257678 0.120523 2.138 0.033
L1.qa_smoothed_velocity_estimate_log_differenced -0.001983 0.000706 -2.807 0.005
L1.total_pledge_collateral_log_differenced -4209.322372 697.003894 -6.039 0.000
L1.total_qa_bytes_committed_log_differenced -2017.772160 337.605041 -5.977 0.000
L1.total_qa_bytes_power_log_differenced 1706.824247 334.933582 5.096 0.000
L1.total_raw_bytes_committed_log_differenced 2170.517080 338.212309 6.418 0.000
L1.total_raw_bytes_power_log_differenced -1859.464561 335.486184 -5.543 0.000
L1.burnt_fil_log_differenced -14.374731 8.812973 -1.631 0.103
L1.circulating_fil_log_differenced -70.936795 44.856864 -1.581 0.114
L1.locked_fil_log_differenced 4167.596419 688.266764 6.055 0.000
L1.vested_fil_log_differenced 104.388810 110.662162 0.943 0.346
L2.cum_sum_baseline_log_differenced 15754.343615 2300.714223 6.848 0.000
L2.cum_sum_realized_log_differenced 40.815939 284.544452 0.143 0.886
L2.effective_baseline_power_log_differenced -8755.555673 1138.028460 -7.694 0.000
L2.effective_network_time_log_differenced -15608.997858 2433.732732 -6.414 0.000
L2.new_baseline_power_log_differenced -194.361548 1037.646319 -0.187 0.851
L2.total_mined_reward_log_differenced -16.703414 24.099895 -0.693 0.488
L2.miner_count_log_differenced 0.084875 0.207871 0.408 0.683
L2.participating_miner_count_log_differenced 0.181126 0.050946 3.555 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.549002 0.120310 4.563 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.000609 0.000720 0.845 0.398
L2.total_pledge_collateral_log_differenced -3200.799530 698.901859 -4.580 0.000
L2.total_qa_bytes_committed_log_differenced -1562.153626 338.168937 -4.619 0.000
L2.total_qa_bytes_power_log_differenced 1288.957203 335.351006 3.844 0.000
L2.total_raw_bytes_committed_log_differenced 1502.271977 338.637734 4.436 0.000
L2.total_raw_bytes_power_log_differenced -1229.548068 335.769352 -3.662 0.000
L2.burnt_fil_log_differenced 12.982430 8.805546 1.474 0.140
L2.circulating_fil_log_differenced 55.802428 44.817253 1.245 0.213
L2.locked_fil_log_differenced 3237.699616 690.186072 4.691 0.000
L2.vested_fil_log_differenced -67.305994 130.412444 -0.516 0.606
L3.cum_sum_baseline_log_differenced 1510.101404 2298.646782 0.657 0.511
L3.cum_sum_realized_log_differenced -3.122553 284.463249 -0.011 0.991
L3.effective_baseline_power_log_differenced -852.383472 1138.752915 -0.749 0.454
L3.effective_network_time_log_differenced -1477.429294 2431.129878 -0.608 0.543
L3.new_baseline_power_log_differenced 62.699610 1037.231099 0.060 0.952
L3.total_mined_reward_log_differenced 45.452076 24.082212 1.887 0.059
L3.miner_count_log_differenced 0.283901 0.207980 1.365 0.172
L3.participating_miner_count_log_differenced -0.050437 0.050951 -0.990 0.322
L3.qa_smoothed_position_estimate_log_differenced -0.214236 0.120312 -1.781 0.075
L3.qa_smoothed_velocity_estimate_log_differenced 0.001537 0.000720 2.134 0.033
L3.total_pledge_collateral_log_differenced 200.895454 698.859632 0.287 0.774
L3.total_qa_bytes_committed_log_differenced -177.089988 337.973966 -0.524 0.600
L3.total_qa_bytes_power_log_differenced 115.165246 335.168969 0.344 0.731
L3.total_raw_bytes_committed_log_differenced 2.832643 338.418437 0.008 0.993
L3.total_raw_bytes_power_log_differenced 59.394495 335.562764 0.177 0.860
L3.burnt_fil_log_differenced -21.338892 8.800398 -2.425 0.015
L3.circulating_fil_log_differenced -110.193708 44.790890 -2.460 0.014
L3.locked_fil_log_differenced -265.785291 690.139493 -0.385 0.700
L3.vested_fil_log_differenced 78.379701 130.317113 0.601 0.548
L4.cum_sum_baseline_log_differenced 2714.854755 2174.199400 1.249 0.212
L4.cum_sum_realized_log_differenced 35.048375 265.056339 0.132 0.895
L4.effective_baseline_power_log_differenced -1312.134024 1083.562681 -1.211 0.226
L4.effective_network_time_log_differenced -2750.822117 2294.487335 -1.199 0.231
L4.new_baseline_power_log_differenced -223.165676 962.245099 -0.232 0.817
L4.total_mined_reward_log_differenced 152.916202 24.098444 6.345 0.000
L4.miner_count_log_differenced 0.799158 0.207965 3.843 0.000
L4.participating_miner_count_log_differenced 0.159176 0.050920 3.126 0.002
L4.qa_smoothed_position_estimate_log_differenced -0.582491 0.120173 -4.847 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000450 0.000705 0.638 0.523
L4.total_pledge_collateral_log_differenced -2073.100163 698.235863 -2.969 0.003
L4.total_qa_bytes_committed_log_differenced 230.636815 337.143308 0.684 0.494
L4.total_qa_bytes_power_log_differenced -474.143440 334.423386 -1.418 0.156
L4.total_raw_bytes_committed_log_differenced -145.432222 337.625554 -0.431 0.667
L4.total_raw_bytes_power_log_differenced 388.628885 334.854049 1.161 0.246
L4.burnt_fil_log_differenced -53.083696 8.810770 -6.025 0.000
L4.circulating_fil_log_differenced -274.637574 44.840269 -6.125 0.000
L4.locked_fil_log_differenced 1911.739999 689.489147 2.773 0.006
L4.vested_fil_log_differenced 337.184716 110.153495 3.061 0.002
===================================================================================================================
Results for equation locked_fil_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000008 0.009 0.993
L1.cum_sum_baseline_log_differenced 6782.672324 2365.658363 2.867 0.004
L1.cum_sum_realized_log_differenced -73.225294 287.658240 -0.255 0.799
L1.effective_baseline_power_log_differenced -3885.180202 1176.660336 -3.302 0.001
L1.effective_network_time_log_differenced -6643.218389 2496.799826 -2.661 0.008
L1.new_baseline_power_log_differenced 110.535503 1044.552345 0.106 0.916
L1.total_mined_reward_log_differenced 61.092508 26.181146 2.333 0.020
L1.miner_count_log_differenced 0.436980 0.225384 1.939 0.053
L1.participating_miner_count_log_differenced 0.446283 0.055288 8.072 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.334998 0.130788 2.561 0.010
L1.qa_smoothed_velocity_estimate_log_differenced -0.002329 0.000766 -3.039 0.002
L1.total_pledge_collateral_log_differenced -4566.528142 756.367284 -6.037 0.000
L1.total_qa_bytes_committed_log_differenced -2047.847647 366.358653 -5.590 0.000
L1.total_qa_bytes_power_log_differenced 1693.197610 363.459667 4.659 0.000
L1.total_raw_bytes_committed_log_differenced 2212.874279 367.017642 6.029 0.000
L1.total_raw_bytes_power_log_differenced -1858.167844 364.059335 -5.104 0.000
L1.burnt_fil_log_differenced -17.161480 9.563569 -1.794 0.073
L1.circulating_fil_log_differenced -85.018234 48.677295 -1.747 0.081
L1.locked_fil_log_differenced 4516.108220 746.886017 6.047 0.000
L1.vested_fil_log_differenced 110.059580 120.087190 0.916 0.359
L2.cum_sum_baseline_log_differenced 16340.252863 2496.664628 6.545 0.000
L2.cum_sum_realized_log_differenced 28.850970 308.778927 0.093 0.926
L2.effective_baseline_power_log_differenced -9115.295310 1234.953639 -7.381 0.000
L2.effective_network_time_log_differenced -16176.165650 2641.012241 -6.125 0.000
L2.new_baseline_power_log_differenced -157.750294 1126.022013 -0.140 0.889
L2.total_mined_reward_log_differenced -18.157616 26.152468 -0.694 0.487
L2.miner_count_log_differenced 0.136647 0.225575 0.606 0.545
L2.participating_miner_count_log_differenced 0.192540 0.055285 3.483 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.577008 0.130557 4.420 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.000654 0.000782 0.836 0.403
L2.total_pledge_collateral_log_differenced -3566.460668 758.426897 -4.702 0.000
L2.total_qa_bytes_committed_log_differenced -1678.854190 366.970576 -4.575 0.000
L2.total_qa_bytes_power_log_differenced 1367.499292 363.912643 3.758 0.000
L2.total_raw_bytes_committed_log_differenced 1616.336590 367.479300 4.398 0.000
L2.total_raw_bytes_power_log_differenced -1305.466965 364.366619 -3.583 0.000
L2.burnt_fil_log_differenced 13.945662 9.555509 1.459 0.144
L2.circulating_fil_log_differenced 60.656168 48.634311 1.247 0.212
L2.locked_fil_log_differenced 3606.378010 748.968792 4.815 0.000
L2.vested_fil_log_differenced -70.087774 141.519591 -0.495 0.620
L3.cum_sum_baseline_log_differenced 1429.420115 2494.421105 0.573 0.567
L3.cum_sum_realized_log_differenced 14.485362 308.690808 0.047 0.963
L3.effective_baseline_power_log_differenced -752.160060 1235.739796 -0.609 0.543
L3.effective_network_time_log_differenced -1416.593591 2638.187703 -0.537 0.591
L3.new_baseline_power_log_differenced -3.859464 1125.571429 -0.003 0.997
L3.total_mined_reward_log_differenced 51.712762 26.133279 1.979 0.048
L3.miner_count_log_differenced 0.303958 0.225694 1.347 0.178
L3.participating_miner_count_log_differenced -0.040957 0.055290 -0.741 0.459
L3.qa_smoothed_position_estimate_log_differenced -0.188917 0.130559 -1.447 0.148
L3.qa_smoothed_velocity_estimate_log_differenced 0.001724 0.000782 2.206 0.027
L3.total_pledge_collateral_log_differenced 88.945131 758.381074 0.117 0.907
L3.total_qa_bytes_committed_log_differenced -37.374161 366.758999 -0.102 0.919
L3.total_qa_bytes_power_log_differenced -37.512633 363.715103 -0.103 0.918
L3.total_raw_bytes_committed_log_differenced -148.576936 367.241326 -0.405 0.686
L3.total_raw_bytes_power_log_differenced 223.742975 364.142437 0.614 0.539
L3.burnt_fil_log_differenced -23.650988 9.549922 -2.477 0.013
L3.circulating_fil_log_differenced -121.821356 48.605703 -2.506 0.012
L3.locked_fil_log_differenced -160.909213 748.918246 -0.215 0.830
L3.vested_fil_log_differenced 87.605539 141.416141 0.619 0.536
L4.cum_sum_baseline_log_differenced 2509.828594 2359.374616 1.064 0.287
L4.cum_sum_realized_log_differenced 51.600504 287.631023 0.179 0.858
L4.effective_baseline_power_log_differenced -1142.603169 1175.849043 -0.972 0.331
L4.effective_network_time_log_differenced -2567.901273 2489.907400 -1.031 0.302
L4.new_baseline_power_log_differenced -280.466460 1044.198918 -0.269 0.788
L4.total_mined_reward_log_differenced 170.574877 26.150893 6.523 0.000
L4.miner_count_log_differenced 0.858229 0.225677 3.803 0.000
L4.participating_miner_count_log_differenced 0.169116 0.055257 3.061 0.002
L4.qa_smoothed_position_estimate_log_differenced -0.626333 0.130408 -4.803 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000497 0.000765 0.650 0.516
L4.total_pledge_collateral_log_differenced -2379.454772 757.704179 -3.140 0.002
L4.total_qa_bytes_committed_log_differenced 293.145214 365.857594 0.801 0.423
L4.total_qa_bytes_power_log_differenced -567.188017 362.906019 -1.563 0.118
L4.total_raw_bytes_committed_log_differenced -193.906223 366.380913 -0.529 0.597
L4.total_raw_bytes_power_log_differenced 467.582536 363.373361 1.287 0.198
L4.burnt_fil_log_differenced -59.007432 9.561177 -6.172 0.000
L4.circulating_fil_log_differenced -304.716490 48.659287 -6.262 0.000
L4.locked_fil_log_differenced 2200.074708 748.212511 2.940 0.003
L4.vested_fil_log_differenced 362.965916 119.535200 3.036 0.002
===================================================================================================================
Results for equation vested_fil_log_differenced
===================================================================================================================
coefficient std. error t-stat prob
-------------------------------------------------------------------------------------------------------------------
const 0.000000 0.000006 0.009 0.993
L1.cum_sum_baseline_log_differenced 5196.016967 1707.577810 3.043 0.002
L1.cum_sum_realized_log_differenced -41.506640 207.637263 -0.200 0.842
L1.effective_baseline_power_log_differenced -2942.323935 849.336113 -3.464 0.001
L1.effective_network_time_log_differenced -5103.988287 1802.238246 -2.832 0.005
L1.new_baseline_power_log_differenced 33.351071 753.978018 0.044 0.965
L1.total_mined_reward_log_differenced 42.162301 18.898056 2.231 0.026
L1.miner_count_log_differenced 0.307905 0.162686 1.893 0.058
L1.participating_miner_count_log_differenced 0.330312 0.039908 8.277 0.000
L1.qa_smoothed_position_estimate_log_differenced 0.223448 0.094405 2.367 0.018
L1.qa_smoothed_velocity_estimate_log_differenced -0.001608 0.000553 -2.907 0.004
L1.total_pledge_collateral_log_differenced -3285.424561 545.960486 -6.018 0.000
L1.total_qa_bytes_committed_log_differenced -1532.060527 264.444738 -5.793 0.000
L1.total_qa_bytes_power_log_differenced 1284.422528 262.352194 4.896 0.000
L1.total_raw_bytes_committed_log_differenced 1652.387898 264.920409 6.237 0.000
L1.total_raw_bytes_power_log_differenced -1404.690971 262.785046 -5.345 0.000
L1.burnt_fil_log_differenced -11.793079 6.903168 -1.708 0.088
L1.circulating_fil_log_differenced -58.309835 35.136210 -1.660 0.097
L1.locked_fil_log_differenced 3251.002220 539.116725 6.030 0.000
L1.vested_fil_log_differenced 80.375504 86.681249 0.927 0.354
L2.cum_sum_baseline_log_differenced 12163.386514 1802.140657 6.749 0.000
L2.cum_sum_realized_log_differenced 26.526261 222.882582 0.119 0.905
L2.effective_baseline_power_log_differenced -6772.995008 891.413343 -7.598 0.000
L2.effective_network_time_log_differenced -12046.121201 1906.333547 -6.319 0.000
L2.new_baseline_power_log_differenced -132.917958 812.784395 -0.164 0.870
L2.total_mined_reward_log_differenced -12.872734 18.877355 -0.682 0.495
L2.miner_count_log_differenced 0.077208 0.162825 0.474 0.635
L2.participating_miner_count_log_differenced 0.141061 0.039906 3.535 0.000
L2.qa_smoothed_position_estimate_log_differenced 0.425730 0.094238 4.518 0.000
L2.qa_smoothed_velocity_estimate_log_differenced 0.000483 0.000564 0.856 0.392
L2.total_pledge_collateral_log_differenced -2547.486060 547.447155 -4.653 0.000
L2.total_qa_bytes_committed_log_differenced -1224.633778 264.886436 -4.623 0.000
L2.total_qa_bytes_power_log_differenced 1006.440610 262.679161 3.831 0.000
L2.total_raw_bytes_committed_log_differenced 1178.901891 265.253642 4.444 0.000
L2.total_raw_bytes_power_log_differenced -961.072469 263.006850 -3.654 0.000
L2.burnt_fil_log_differenced 10.028774 6.897351 1.454 0.146
L2.circulating_fil_log_differenced 43.234741 35.105183 1.232 0.218
L2.locked_fil_log_differenced 2576.059474 540.620112 4.765 0.000
L2.vested_fil_log_differenced -51.312223 102.151569 -0.502 0.615
L3.cum_sum_baseline_log_differenced 1124.290892 1800.521239 0.624 0.532
L3.cum_sum_realized_log_differenced 2.797091 222.818976 0.013 0.990
L3.effective_baseline_power_log_differenced -618.338168 891.980806 -0.693 0.488
L3.effective_network_time_log_differenced -1105.355133 1904.294741 -0.580 0.562
L3.new_baseline_power_log_differenced 28.101496 812.459155 0.035 0.972
L3.total_mined_reward_log_differenced 37.039960 18.863505 1.964 0.050
L3.miner_count_log_differenced 0.220166 0.162910 1.351 0.177
L3.participating_miner_count_log_differenced -0.035453 0.039910 -0.888 0.374
L3.qa_smoothed_position_estimate_log_differenced -0.152356 0.094240 -1.617 0.106
L3.qa_smoothed_velocity_estimate_log_differenced 0.001233 0.000564 2.186 0.029
L3.total_pledge_collateral_log_differenced 112.421562 547.414079 0.205 0.837
L3.total_qa_bytes_committed_log_differenced -84.577853 264.733716 -0.319 0.749
L3.total_qa_bytes_power_log_differenced 33.988664 262.536573 0.129 0.897
L3.total_raw_bytes_committed_log_differenced -51.277893 265.081868 -0.193 0.847
L3.total_raw_bytes_power_log_differenced 102.086545 262.845031 0.388 0.698
L3.burnt_fil_log_differenced -17.143664 6.893318 -2.487 0.013
L3.circulating_fil_log_differenced -88.411097 35.084533 -2.520 0.012
L3.locked_fil_log_differenced -164.568071 540.583627 -0.304 0.761
L3.vested_fil_log_differenced 63.719333 102.076897 0.624 0.532
L4.cum_sum_baseline_log_differenced 1990.093314 1703.042080 1.169 0.243
L4.cum_sum_realized_log_differenced 29.697324 207.617617 0.143 0.886
L4.effective_baseline_power_log_differenced -945.103260 848.750506 -1.114 0.265
L4.effective_network_time_log_differenced -2022.172696 1797.263160 -1.125 0.261
L4.new_baseline_power_log_differenced -179.222375 753.722909 -0.238 0.812
L4.total_mined_reward_log_differenced 122.063635 18.876219 6.467 0.000
L4.miner_count_log_differenced 0.621217 0.162898 3.814 0.000
L4.participating_miner_count_log_differenced 0.123567 0.039886 3.098 0.002
L4.qa_smoothed_position_estimate_log_differenced -0.455566 0.094131 -4.840 0.000
L4.qa_smoothed_velocity_estimate_log_differenced 0.000360 0.000552 0.652 0.515
L4.total_pledge_collateral_log_differenced -1667.909896 546.925483 -3.050 0.002
L4.total_qa_bytes_committed_log_differenced 196.817879 264.083064 0.745 0.456
L4.total_qa_bytes_power_log_differenced -390.453083 261.952560 -1.491 0.136
L4.total_raw_bytes_committed_log_differenced -127.352049 264.460806 -0.482 0.630
L4.total_raw_bytes_power_log_differenced 320.732548 262.289897 1.223 0.221
L4.burnt_fil_log_differenced -42.335732 6.901442 -6.134 0.000
L4.circulating_fil_log_differenced -218.828513 35.123211 -6.230 0.000
L4.locked_fil_log_differenced 1539.217652 540.074214 2.850 0.004
L4.vested_fil_log_differenced 264.950650 86.282812 3.071 0.002
===================================================================================================================
Correlation matrix of residuals
cum_sum_baseline_log_differenced cum_sum_realized_log_differenced effective_baseline_power_log_differenced effective_network_time_log_differenced new_baseline_power_log_differenced total_mined_reward_log_differenced miner_count_log_differenced participating_miner_count_log_differenced qa_smoothed_position_estimate_log_differenced qa_smoothed_velocity_estimate_log_differenced total_pledge_collateral_log_differenced total_qa_bytes_committed_log_differenced total_qa_bytes_power_log_differenced total_raw_bytes_committed_log_differenced total_raw_bytes_power_log_differenced burnt_fil_log_differenced circulating_fil_log_differenced locked_fil_log_differenced vested_fil_log_differenced
cum_sum_baseline_log_differenced 1.000000 1.000000 0.999887 0.999994 0.999869 0.999999 0.883384 0.993365 0.999132 -0.701787 0.999641 0.999022 0.999022 0.999021 0.999021 0.984772 0.999404 0.999641 0.999965
cum_sum_realized_log_differenced 1.000000 1.000000 0.999887 0.999994 0.999869 0.999999 0.883384 0.993365 0.999132 -0.701787 0.999641 0.999022 0.999022 0.999021 0.999021 0.984772 0.999404 0.999641 0.999965
effective_baseline_power_log_differenced 0.999887 0.999887 1.000000 0.999829 0.999999 0.999864 0.888478 0.992439 0.998705 -0.703956 0.999138 0.998602 0.998602 0.998599 0.998599 0.983129 0.999780 0.999138 0.999977
effective_network_time_log_differenced 0.999994 0.999994 0.999829 1.000000 0.999807 0.999998 0.882186 0.993546 0.999198 -0.701266 0.999724 0.999087 0.999087 0.999086 0.999086 0.985118 0.999285 0.999724 0.999930
new_baseline_power_log_differenced 0.999869 0.999869 0.999999 0.999807 1.000000 0.999846 0.888849 0.992362 0.998665 -0.704113 0.999092 0.998562 0.998562 0.998559 0.998559 0.982996 0.999799 0.999092 0.999969
total_mined_reward_log_differenced 0.999999 0.999999 0.999864 0.999998 0.999846 1.000000 0.882805 0.993430 0.999163 -0.701640 0.999678 0.999058 0.999058 0.999056 0.999056 0.984918 0.999356 0.999678 0.999952
miner_count_log_differenced 0.883384 0.883384 0.888478 0.882186 0.888849 0.882805 1.000000 0.854856 0.874587 -0.687846 0.872436 0.871857 0.871852 0.871825 0.871822 0.813834 0.896486 0.872433 0.886212
participating_miner_count_log_differenced 0.993365 0.993365 0.992439 0.993546 0.992362 0.993430 0.854856 1.000000 0.993992 -0.693222 0.994398 0.994024 0.994027 0.994027 0.994029 0.986321 0.990845 0.994398 0.992881
qa_smoothed_position_estimate_log_differenced 0.999132 0.999132 0.998705 0.999198 0.998665 0.999163 0.874587 0.993992 1.000000 -0.690486 0.999327 0.999799 0.999799 0.999799 0.999799 0.986356 0.997831 0.999327 0.998924
qa_smoothed_velocity_estimate_log_differenced -0.701787 -0.701787 -0.703956 -0.701266 -0.704113 -0.701640 -0.687846 -0.693222 -0.690486 1.000000 -0.697453 -0.689625 -0.689631 -0.689605 -0.689612 -0.658209 -0.707573 -0.697451 -0.702994
total_pledge_collateral_log_differenced 0.999641 0.999641 0.999138 0.999724 0.999092 0.999678 0.872436 0.994398 0.999327 -0.697453 1.000000 0.999270 0.999270 0.999271 0.999271 0.987408 0.998150 1.000000 0.999390
total_qa_bytes_committed_log_differenced 0.999022 0.999022 0.998602 0.999087 0.998562 0.999058 0.871857 0.994024 0.999799 -0.689625 0.999270 1.000000 1.000000 1.000000 1.000000 0.986870 0.997654 0.999270 0.998818
total_qa_bytes_power_log_differenced 0.999022 0.999022 0.998602 0.999087 0.998562 0.999058 0.871852 0.994027 0.999799 -0.689631 0.999270 1.000000 1.000000 1.000000 1.000000 0.986869 0.997653 0.999270 0.998818
total_raw_bytes_committed_log_differenced 0.999021 0.999021 0.998599 0.999086 0.998559 0.999056 0.871825 0.994027 0.999799 -0.689605 0.999271 1.000000 1.000000 1.000000 1.000000 0.986875 0.997649 0.999271 0.998816
total_raw_bytes_power_log_differenced 0.999021 0.999021 0.998599 0.999086 0.998559 0.999056 0.871822 0.994029 0.999799 -0.689612 0.999271 1.000000 1.000000 1.000000 1.000000 0.986873 0.997649 0.999271 0.998816
burnt_fil_log_differenced 0.984772 0.984772 0.983129 0.985118 0.982996 0.984918 0.813834 0.986321 0.986356 -0.658209 0.987408 0.986870 0.986869 0.986875 0.986873 1.000000 0.979336 0.987410 0.983904
circulating_fil_log_differenced 0.999404 0.999404 0.999780 0.999285 0.999799 0.999356 0.896486 0.990845 0.997831 -0.707573 0.998150 0.997654 0.997653 0.997649 0.997649 0.979336 1.000000 0.998150 0.999639
locked_fil_log_differenced 0.999641 0.999641 0.999138 0.999724 0.999092 0.999678 0.872433 0.994398 0.999327 -0.697451 1.000000 0.999270 0.999270 0.999271 0.999271 0.987410 0.998150 1.000000 0.999390
vested_fil_log_differenced 0.999965 0.999965 0.999977 0.999930 0.999969 0.999952 0.886212 0.992881 0.998924 -0.702994 0.999390 0.998818 0.998818 0.998816 0.998816 0.983904 0.999639 0.999390 1.000000
alpha = 0.05
result_dfs = []
variables = list(log_differenced_subset.columns)
for i in variables:
for j in variables:
if i==j:
pass
else:
results_summary = results.test_causality(i,j,
kind='f',signif=alpha).summary()
df = pd.read_html(results_summary.as_html(),header=0, index_col=0)[0]
df['alpha'] = alpha
df['caused'] = i
df['causing'] = j
result_dfs.append(df)
Grangers_df = pd.concat(result_dfs)
Grangers_df.reset_index(inplace=True)
Grangers_df['result'] = Grangers_df['p-value'].apply(lambda x: 'reject H0' if x < alpha else 'fail to reject H0' )
Grangers_df
| Test statistic | Critical value | p-value | df | alpha | caused | causing | result | |
|---|---|---|---|---|---|---|---|---|
| 0 | 0.03640 | 2.372 | 0.997 | (4, 1618382) | 0.05 | cum_sum_baseline_log_differenced | cum_sum_realized_log_differenced | fail to reject H0 |
| 1 | 15.70000 | 2.372 | 0.000 | (4, 1618382) | 0.05 | cum_sum_baseline_log_differenced | effective_baseline_power_log_differenced | reject H0 |
| 2 | 10.82000 | 2.372 | 0.000 | (4, 1618382) | 0.05 | cum_sum_baseline_log_differenced | effective_network_time_log_differenced | reject H0 |
| 3 | 0.03617 | 2.372 | 0.998 | (4, 1618382) | 0.05 | cum_sum_baseline_log_differenced | new_baseline_power_log_differenced | fail to reject H0 |
| 4 | 12.99000 | 2.372 | 0.000 | (4, 1618382) | 0.05 | cum_sum_baseline_log_differenced | total_mined_reward_log_differenced | reject H0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 337 | 13.88000 | 2.372 | 0.000 | (4, 1618382) | 0.05 | vested_fil_log_differenced | total_raw_bytes_committed_log_differenced | reject H0 |
| 338 | 10.37000 | 2.372 | 0.000 | (4, 1618382) | 0.05 | vested_fil_log_differenced | total_raw_bytes_power_log_differenced | reject H0 |
| 339 | 12.33000 | 2.372 | 0.000 | (4, 1618382) | 0.05 | vested_fil_log_differenced | burnt_fil_log_differenced | reject H0 |
| 340 | 12.45000 | 2.372 | 0.000 | (4, 1618382) | 0.05 | vested_fil_log_differenced | circulating_fil_log_differenced | reject H0 |
| 341 | 16.49000 | 2.372 | 0.000 | (4, 1618382) | 0.05 | vested_fil_log_differenced | locked_fil_log_differenced | reject H0 |
342 rows × 8 columns
heatdf = Grangers_df.pivot(index='caused', columns=['causing'],values=['p-value'])
f, ax = plt.subplots(figsize=(15, 12))
sns.heatmap(heatdf, annot=True, linewidths=.5, ax=ax,cmap=['green','red'],center=0.05)
plt.suptitle('Heatmap of Granger Casuality \n Green shows causal relationship whereas red shows no causal relationship')
Text(0.5, 0.98, 'Heatmap of Granger Casuality \n Green shows causal relationship whereas red shows no causal relationship')
Grangers_df.query("result == 'reject H0'").sort_values('p-value',ascending=True)
| Test statistic | Critical value | p-value | df | alpha | caused | causing | result | |
|---|---|---|---|---|---|---|---|---|
| 1 | 15.700 | 2.372 | 0.000 | (4, 1618382) | 0.05 | cum_sum_baseline_log_differenced | effective_baseline_power_log_differenced | reject H0 |
| 205 | 21.850 | 2.372 | 0.000 | (4, 1618382) | 0.05 | total_qa_bytes_committed_log_differenced | participating_miner_count_log_differenced | reject H0 |
| 206 | 15.130 | 2.372 | 0.000 | (4, 1618382) | 0.05 | total_qa_bytes_committed_log_differenced | qa_smoothed_position_estimate_log_differenced | reject H0 |
| 208 | 14.970 | 2.372 | 0.000 | (4, 1618382) | 0.05 | total_qa_bytes_committed_log_differenced | total_pledge_collateral_log_differenced | reject H0 |
| 209 | 8.921 | 2.372 | 0.000 | (4, 1618382) | 0.05 | total_qa_bytes_committed_log_differenced | total_qa_bytes_power_log_differenced | reject H0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 297 | 3.205 | 2.372 | 0.012 | (4, 1618382) | 0.05 | circulating_fil_log_differenced | qa_smoothed_velocity_estimate_log_differenced | reject H0 |
| 269 | 3.224 | 2.372 | 0.012 | (4, 1618382) | 0.05 | total_raw_bytes_power_log_differenced | vested_fil_log_differenced | reject H0 |
| 251 | 3.224 | 2.372 | 0.012 | (4, 1618382) | 0.05 | total_raw_bytes_committed_log_differenced | vested_fil_log_differenced | reject H0 |
| 215 | 3.225 | 2.372 | 0.012 | (4, 1618382) | 0.05 | total_qa_bytes_committed_log_differenced | vested_fil_log_differenced | reject H0 |
| 233 | 3.225 | 2.372 | 0.012 | (4, 1618382) | 0.05 | total_qa_bytes_power_log_differenced | vested_fil_log_differenced | reject H0 |
305 rows × 8 columns