Goerli TTD Estimations

goerli_avg_diff.py

import csv

with open('goerli_td_1m.csv') as csv_file:
    csv_reader = csv.reader(csv_file, delimiter=',')
    line_count = 0
    avg = 0.0 # Average difficulty added per block
    deltas = [] # List of added difficulty per block 

    # Calculate average over the entire set, and convert deltas column to a list 
    for row in csv_reader:
        if line_count == 0:
            print(f'Column names are {", ".join(row)}')
            line_count += 1
        else:
            deltas.append(float(row[2]))
            prev_avg = avg
            avg += (float(row[2]) - prev_avg) / line_count
            line_count +=1

    # Calculate rolling averages over 50k block windows 
    win_size = 50000
    i = 0 
    avgs = []
    while i < len(deltas) - win_size +1: 
        win = deltas[i : i + win_size]
        win_avg = round(sum(win) / win_size, 2)
        avgs.append(win_avg)
        i += 1
        if i % 10000 == 0:
            print(i)

    # Print data
    print(avgs)
    print(avg) # Average difficulty added per block
    print(max(avgs)) # Maximum average difficulty added over a 50k window
    print(min(avgs)) # Minimum average difficulty added over a 50k window
    print(f'Processed {line_count} lines.')

Output from lines 34-37 using these blocks:

1.4346965929656057
1.71
1.28
Processed 1001840 lines.