Go to the and click "API" to generate your API key. Every account on the Free plan comes with 500 free query seconds per month.
2. 🛠 Pick Your SDK and Install It
pip install flipside
yarn add @flipsidecrypto/sdk
or
npm install @flipsidecrypto/sdk
install.packages("shroomDK") # from CRAN
3. 🏃♀️Execute your First Query
from flipside import Flipside
# Initialize `Flipside` with your API Key and API Url
flipside = Flipside("<YOUR_API_KEY>", "https://api-v2.flipsidecrypto.xyz")
sql = """
SELECT
date_trunc('hour', block_timestamp) as hour,
count(distinct tx_hash) as tx_count
FROM ethereum.core.fact_transactions
WHERE block_timestamp >= GETDATE() - interval'7 days'
GROUP BY 1
"""
# Run the query against Flipside's query engine and await the results
query_result_set = flipside.query(sql)
const { Flipside } = require("@flipsidecrypto/sdk");
// Initialize `Flipside` with your API key
const flipside = new Flipside(
"<YOUR_API_KEY>",
"https://api-v2.flipsidecrypto.xyz"
);
const sql = `
SELECT
date_trunc('hour', block_timestamp) as hour,
count(distinct tx_hash) as tx_count
FROM ethereum.core.fact_transactions
WHERE block_timestamp >= GETDATE() - interval'7 days'
GROUP BY 1
`
// Send the `Query` to Flipside's query engine and await the results
const queryResultSet = await flipside.query.run({sql: sql});
library(shroomDK)
api_key = readLines("api_key.txt") # always gitignore your API keys!
query <- {
"
SELECT
date_trunc('hour', block_timestamp) as hour,
count(distinct tx_hash) as tx_count
FROM ethereum.core.fact_transactions
WHERE block_timestamp >= GETDATE() - interval'7 days'
GROUP BY 1
"
}
pull_data <- auto_paginate_query(
query = query,
api_key = api_key
)
