notwedtm

import { IAgentRuntime, Memory } from "@ai16z/eliza";
import { SolanaAgentKit } from "solana-agent-kit";
export function getSakAgent(runtime: IAgentRuntime) {
  return new SolanaAgentKit(
    runtime.getSetting("SOLANA_PRIVATE_KEY"),
    runtime.getSetting("SOLANA_RPC_URL"),
    runtime.getSetting("OPENAI_API_KEY")
  );
}

notwedtm

-- use database
use birdeye;

WITH filtered_tokens AS (
    SELECT
        name,
        symbol,
        liquidity,
        lowerUTF8(name) AS normalized_name,
        lengthUTF8(name) AS name_length,

notwedtm

use birdeye;

WITH filtered_tokens AS (
    SELECT *
    FROM token_listings
    WHERE liquidity > 0
        AND liquidity_added_at >= now() - INTERVAL 24 HOUR
)
SELECT
    t1.address AS original_address,

notwedtm

#!/bin/bash

SAVE_DIR="/mnt/data/cars"
BASE_URL="https://files.old-faithful.net"
MAX_PARALLEL=20
START_EPOCH=651
END_EPOCH=0

# Create save directory if it doesn't exist
mkdir -p "$SAVE_DIR"

notwedtm

CREATE TABLE default.transactions
(
    `epoch` UInt64,
    `slot` UInt64,
    `fee` UInt64,
    `fee_payer` String,
    `required_signatures` UInt8,
    `readonly_signed_accounts` UInt8,
    `readonly_unsigned_accounts` UInt8,
    `block_hash` String,