Skip to content

Instantly share code, notes, and snippets.

View gaburipeach's full-sized avatar

boybad gaburipeach

View GitHub Profile
@gaburipeach
gaburipeach / power_perps_pricing.ipynb
Created April 18, 2022 06:25
Power Perp Pricing
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@gaburipeach
gaburipeach / entropy_funding_exploration.ipynb
Created April 21, 2022 22:17
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@gaburipeach
gaburipeach / friktion_user_query
Last active April 22, 2022 17:01
Friktion User Portfolio
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "95c16ebb",
"metadata": {},
"outputs": [],
"source": [
"\"\"\"\n",
@gaburipeach
gaburipeach / friktion.ipynb
Created April 22, 2022 17:02
Friktion Bitquery Workflow
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@gaburipeach
gaburipeach / gist:a89d29229704957b85e8216556fe855b
Created April 23, 2022 02:38
turn Solana private key into bytearray and vice versa
import pandas
import numpy as np
import base58
def to_byte_aray(MY_PRIVATE_KEY_IN_BASE58):
byte_array = base58.b58decode(MY_PRIVATE_KEY_IN_BASE58)
json_string = "[" + ",".join(map(lambda b: str(b), byte_array)) + "]"
print(json_string)
def to_base58_string(MY_PRIVATE_KEY_IN_JSON_STRING):
@gaburipeach
gaburipeach / gist:09c19f549a0925980c9349a6ffd715df
Created April 25, 2022 07:38
example for 2Lm8Ps6rxkXoxYLMDFrieYeNUnqy5hFhsZMKUzx2VMYc
,txSignature,amount,instructionAction,instructionOrder,userAddress,timestamp,currencyName,currencyAddress,senderAddress,senderTokenMint,receiverAddress,userAction,globalId,vaultAuthority,shareTokenMint,depositTokenSymbol,depositTokenCoingeckoId
370,HSAVYL3TaGA33vM8dGLJeBy5n2M1PNk7cJkuoT5BQupaaRcgwnA9H2WQPjaJVLVM7W7KwWmWHi7ZrbuLvaew3WA,11.5,transfer,3-1,2Lm8Ps6rxkXoxYLMDFrieYeNUnqy5hFhsZMKUzx2VMYc,2021-12-20 20:28:03+00:00,Wrapped SOL,So11111111111111111111111111111111111111112,2Lm8Ps6rxkXoxYLMDFrieYeNUnqy5hFhsZMKUzx2VMYc,2ywXxGcVbFJ2a9CR4BZM3XFs1udjF8QGAz5UQ1LuEhVA,Hxtb6APfNtf9m8jJjh7uYp8fCTGr9aeHxBSfiPqCrV6G,Deposit,mainnet_income_call_sol,Hxtb6APfNtf9m8jJjh7uYp8fCTGr9aeHxBSfiPqCrV6G,4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2,SOL,solana
1152,55bXrKyMCVo9QpmH4mrBJZHk76TFpUyLhBa7KhucDZ4PtGQMkdE7zzydQtHy2qPwQWmpDVLWUowfWGmnn4dB3iMA,11.399926191,transfer,1-1,2Lm8Ps6rxkXoxYLMDFrieYeNUnqy5hFhsZMKUzx2VMYc,2021-12-22 06:55:07+00:00,Marinade staked SOL (mSOL),mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So,2Lm8Ps6rxkXo
@gaburipeach
gaburipeach / funding_exploration.ipynb
Created April 26, 2022 00:22
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@gaburipeach
gaburipeach / funding_exploration_btc^2.ipynb
Created April 26, 2022 02:03
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@gaburipeach
gaburipeach / GUTUqgNdhwn5ePp4vxnyJn77JPJViC6r1akUx531PXqb
Created April 26, 2022 19:02
GUTUqgNdhwn5ePp4vxnyJn77JPJViC6r1akUx531PXqb
txSignature amount instructionAction instructionOrder userAddress timestamp currencyName currencyAddress senderAddress senderTokenMint receiverAddress userAction globalId vaultAuthority shareTokenMint depositTokenSymbol depositTokenCoingeckoId
31605 53u56yVTM5uB3Wr7WH6hW3KoME3GFrF7iQXn3FunNhagyC... 2.000000 transfer 1-1 GUTUqgNdhwn5ePp4vxnyJn77JPJViC6r1akUx531PXqb 2022-04-23T15:06:39Z NaN KgV1GvrHQmRBY8sHQQeUKwTm2r2h8t4C8qt12Cw1HVE GUTUqgNdhwn5ePp4vxnyJn77JPJViC6r1akUx531PXqb EKUkr2yxyHo36keru2AU2U9maZ4PMvuYXFv9SD4qptjC 5LrULR5w9N1dfnJ9vHnzRkQi9uBL3CkSRWkDGTG6dP1e Deposit mainnet_income_call_avax 5LrULR5w9N1dfnJ9vHnzRkQi9uBL3CkSRWkDGTG6dP1e HLfkEc6E2HEcABaWm3QZSfDvswzXjh1onF9xEzUAtWNS AVAX avalanche-2
31746 2cRfv5DMtFK96nXMh8dRaUfRL1awHnijcqcrso57Ck1A5d... 0.249580 transfer 1-1 GUTUqgNdhwn5ePp4vxnyJn77JPJViC6r1akUx531PXqb 2022-04-24T22:06:08Z Wrapped Ether (Wormhole) 7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs GUTUqgNdhwn5ePp4vxnyJn77JPJViC6r1akUx531PXqb 6kSFNrhMTLaFU3C89ww92stW6gmvmLtNa3RiKamARtjm FThcy5XX
@gaburipeach
gaburipeach / trouble_file
Created April 28, 2022 20:10
import dotenv from "dotenv"
dotenv.config()
import express from "express"
import cors from "cors"
import { QueryTypes } from "sequelize"
import { sequelize } from "../models"
import { maxBy, minBy } from "lodash"
import { Connection } from '@solana/web3.js'
import sumBy from 'lodash/sumBy'
import {getCrabDelta} from '@friktion-labs/entropy-client/lib/src/crabHelpers'