0xEvan Evan-Kim2028
Evan-Kim2028
/ gist:50fb8e220a7293c406423b789fd0e8f9
Last active
January 9, 2024 21:50
polars_query.py
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| txs_calldata: pl.LazyFrame = ( | |
| pl.scan_parquet("data/raw/transactions/*.parquet") | |
| .select( | |
| "block_number", | |
| "transaction_hash", | |
| "input", | |
| ) | |
| .with_columns([pl.col("input").str.len_bytes().alias("calldata_size")]) | |
| .with_columns(pl.col("calldata_size") - 1) | |
| .select("transaction_hash", "block_number", "calldata_size") |
Evan-Kim2028
/ univ3_orderby_token_symbol.ipynb
Created
May 17, 2023 18:44
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Evan-Kim2028
/ query_size_bug.ipynb
Created
May 13, 2023 19:00
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Evan-Kim2028
/ query_size_bug
Created
May 13, 2023 18:59
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "execution_count": 1, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/plain": [ |
Evan-Kim2028
/ univ2_pair_filter.ipynb
Created
May 8, 2023 20:17
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Evan-Kim2028
/ gist:6e616e54603f80c9d70deb0b6839116e
Created
May 8, 2023 20:17
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "execution_count": 1, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/plain": [ |
Evan-Kim2028
/ univ2_filter_swaps_pair.ipynb
Created
May 8, 2023 20:16
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Evan-Kim2028
/ llpls.py
Created
May 3, 2023 22:19
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import numpy as np | |
| import matplotlib.pyplot as plt | |
| import yfinance as yf | |
| import pandas as pd | |
| from scipy.optimize import curve_fit | |
| from fastdtw import fastdtw | |
| from scipy.spatial.distance import euclidean | |
| from scipy.signal import find_peaks, peak_widths | |
| from scipy.interpolate import interp1d |
Evan-Kim2028
/ nested_struct.py
Created
April 28, 2023 13:53
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from queryportal.subgraphinterface import SubgraphInterface as sgi | |
| import polars as pl | |
| pl.Config.set_fmt_str_lengths(200) | |
| endpoints = [ | |
| 'https://api.thegraph.com/subgraphs/name/messari/uniswap-v3-ethereum', | |
| 'https://api.thegraph.com/subgraphs/name/messari/uniswap-v3-arbitrum', | |
| 'https://api.thegraph.com/subgraphs/name/messari/uniswap-v3-polygon', | |
| 'https://api.thegraph.com/subgraphs/name/messari/uniswap-v3-optimism', |
Evan-Kim2028
/ camelCase_break.py
Created
April 28, 2023 13:49
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from queryportal.subgraphinterface import SubgraphInterface as sgi | |
| import polars as pl | |
| pl.Config.set_fmt_str_lengths(200) | |
| endpoints = ['https://api.thegraph.com/subgraphs/name/denverbaumgartner/rubiconv2-optimism-mainnet', | |
| 'https://api.thegraph.com/subgraphs/name/denverbaumgartner/rubiconv2-optimism-goerli', | |
| 'https://api.thegraph.com/subgraphs/name/denverbaumgartner/rubiconv2-arbitrum-goerli', | |
| 'https://api.thegraph.com/subgraphs/name/denverbaumgartner/rubiconv2-polygon-mumbai' | |
| ] |
NewerOlder