ana0

CREATE OR REPLACE VIEW accounts.address_token_balances AS (
  SELECT
      address_hash,
      token_contract_address_hash,
      block_number,
      SUM(amount) OVER (
          PARTITION BY address_hash, token_contract_address_hash
          ORDER BY block_number ASC
          ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
      ) AS amount

ana0

Keybase proof

I hereby claim:

• I am ana0 on github.
• I am isthisa (https://keybase.io/isthisa) on keybase.
• I have a public key whose fingerprint is EEF7 E570 982B 119B 3386 0F2C 387B 49FC 57FE 5D83

To claim this, I am signing this object:

ana0

import random

class Board(object):
    def __init__(self):
        self.board = [[" "," "," "], [" "," "," "], [" "," "," "]]

    def print_board(self):
        topstr = "      a     b     c"
        linestr = "   +-----+-----+-----+"
        rowstr = "%s  |  %s  |  %s  |  %s  |"

ana0

import random

class Board(object):

    def __init__(self):
        self.board = [[" "," "," "], [" "," "," "], [" "," "," "]]

    def print_board(self):
        topstr = "      a     b     c"
        linestr = "   +-----+-----+-----+"

ana0

import random

class Board(object):

    def __init__(self):
        self.board = [[" "," "," "], [" "," "," "], [" "," "," "]]

    def print_board(self):
        topstr = "      a     b     c"
        linestr = "   +-----+-----+-----+"

ana0

def probabilities_matrix(text):
	bigrams = {}
	for i in range(len(text)):
		try:
			if (text[i], text[i+1]) in bigrams:
				bigrams[(text[i], text[i+1])].append(text[i+2])
			else:
				bigrams[(text[i], text[i+1])] = [text[i+2]]
		except IndexError:
			return bigrams

ana0

def clockwise_rotation(grid):
	#returns a representation of the grid rotated clockwise
	rotated = [["" for i in grid] for i in grid]
	l = len(grid)
	for r in range(l):
		x = l - r
		for c in range(l):
			rotated[r][c] = grid[x-1][r]
	return rotated

ana0

def create_grid(x):
	#creates nested set of lists that represent a grid matrix
	gridarray = [[i for i in range(x)] for i in range(x)]
	return gridarray

def rotate_grid_counterclockwise(grid):
	#returns a representation of what you'd get if you rotated the matrix 90 degress counterclockwise
	rotated = [["" for i in grid] for i in grid]
	x = len(grid)
	r = 0

ana0

class Sequence(object):
    
    def __init__(self, query, answers):
        self.query = query
        self.answers = answers

    def text_wrapping(self, text):
        #simple textwrapper, check how much space is left on the x-axis of the screen 
        #if a word's length is longer than the remaining space, adds a newline
        maxx = stdscr.getmaxyx()[1] - stdscr.getyx()[1]