Skip to content

Instantly share code, notes, and snippets.

Avatar
🏠
Working from home

Gaurav buddies2705

🏠
Working from home
View GitHub Profile
@buddies2705
buddies2705 / data.py
Created Oct 30, 2020
week start from Thursday
View data.py
# Hello World program in Python
import requests
import datetime
def run_query(query): # A simple function to use requests.post to make the API call.
request = requests.post('https://graphql.bitquery.io/',
json={'query': query})
if request.status_code == 200:
View 1Paykw4s2WX4SaVjDrQkwSiJr16AiANhiM.csv
We can make this file beautiful and searchable if this error is corrected: Illegal quoting in line 3.
[
{
"symbol": "BTC",
"direction": "outbound",
"path": [
{
"depth": 1,
"block": 654328,
"tx_time": "2020-10-26 05:55:30",
"amount": 2,
@buddies2705
buddies2705 / 0x6fdc428d10baec5e4a114363d261c3f56b4aadb9.json
Created Oct 27, 2020
0x6fdc428d10baec5e4a114363d261c3f56b4aadb9
View 0x6fdc428d10baec5e4a114363d261c3f56b4aadb9.json
{
"symbol": "ETH",
"token_id": 0,
"token_type": "",
"token": "0x0000000000000000000000000000000000000000",
"direction": "inbound",
"path": [
{
"depth": 1,
"block": 11128247,
@buddies2705
buddies2705 / monthly_trade_volume_dex.ql
Created Oct 16, 2020
Monthly DEX trading volume for a specific Token
View monthly_trade_volume_dex.ql
{
ethereum(network: ethereum) {
dexTrades(options: {asc: "date.date"},
buyOrSellCurrency: {is: "0xdac17f958d2ee523a2206206994597c13d831ec7"}) {
date {
date(format: "%Y-%m")
}
amount
currency {
symbol
@buddies2705
buddies2705 / DEX_OHLC.ql
Last active Oct 16, 2020
OHLC data for currency pair on DEX
View DEX_OHLC.ql
{
ethereum(network: ethereum) {
dexTrades(options: {limit: 10, asc: "timeInterval.minute"},
protocol: {is: "Uniswap v2"},
date: {is: "2020-10-10"}
buyCurrency: {is: "0xdac17f958d2ee523a2206206994597c13d831ec7"},
sellCurrency: {is: "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"}) {
timeInterval {
minute(count: 5)
}
@buddies2705
buddies2705 / latest_trades_for_currency.ql
Created Oct 16, 2020
Latest trades of a specific currency pair on a DEX protocol
View latest_trades_for_currency.ql
{
ethereum(network: ethereum) {
dexTrades(options: {limit: 10, desc: ["block.height", "tradeIndex"]},
protocol: {is: "Uniswap v2"},
buyCurrency: {is: "0xdac17f958d2ee523a2206206994597c13d831ec7"},
sellCurrency: {is: "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"}) {
block {
height
timestamp {
iso8601
@buddies2705
buddies2705 / latest_trades.ql
Created Oct 16, 2020
Latest trades on a DEX Protocol
View latest_trades.ql
{
ethereum(network: ethereum) {
dexTrades(options: {limit: 10, desc: "trades"}, protocol:
{is: "Uniswap v2"}) {
protocol
buyCurrency {
symbol
address
}
buyAmount
View top_DEX_Protocols.ql
{
ethereum(network: ethereum) {
dexTrades(options: {limit: 100, desc: "trades"}) {
protocol
started: minimum(of: date)
trades: count
}
}
}
View graphql_example.rb
require 'net/http'
require 'uri'
require 'json'
uri = URI.parse("https://graphql.bitquery.io/")
header = {'Content-Type': 'application/json'}
query = "{ bitcoin { blocks { count } } }"
# Create the HTTP objects
http = Net::HTTP.new(uri.host, uri.port)
@buddies2705
buddies2705 / graphql_example.rb
Created Oct 15, 2020
Using GraphQL with Ruby
View graphql_example.rb
require 'net/http'
require 'uri'
require 'json'
uri = URI.parse('https://graphql.bitquery.io/')
header = {'Content-Type': 'application/json'}
query = ' { bitcoin { blocks { count } } }'
puts query
# Create the HTTP objects
http = Net::HTTP.new(uri.host, uri.port)
You can’t perform that action at this time.