Skip to content

Instantly share code, notes, and snippets.

View buddies2705's full-sized avatar
🏠
Working from home

Gaurav buddies2705

🏠
Working from home
  • Bangalore
View GitHub Profile
@buddies2705
buddies2705 / data.py
Created October 30, 2020 11:21
week start from Thursday
# 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:
@buddies2705
buddies2705 / 1Paykw4s2WX4SaVjDrQkwSiJr16AiANhiM.csv
Created October 27, 2020 22:14
1Paykw4s2WX4SaVjDrQkwSiJr16AiANhiM
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 October 27, 2020 20:45
0x6fdc428d10baec5e4a114363d261c3f56b4aadb9
{
"symbol": "ETH",
"token_id": 0,
"token_type": "",
"token": "0x0000000000000000000000000000000000000000",
"direction": "inbound",
"path": [
{
"depth": 1,
"block": 11128247,
@buddies2705
buddies2705 / monthly_trade_volume_dex.ql
Created October 16, 2020 16:03
Monthly DEX trading volume for a specific Token
{
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 April 3, 2022 10:40
OHLC data for currency pair on DEX
{
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 October 16, 2020 16:01
Latest trades of a specific currency pair on a DEX protocol
{
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 October 16, 2020 15:59
Latest trades on a DEX Protocol
{
ethereum(network: ethereum) {
dexTrades(options: {limit: 10, desc: "trades"}, protocol:
{is: "Uniswap v2"}) {
protocol
buyCurrency {
symbol
address
}
buyAmount
@buddies2705
buddies2705 / top_DEX_Protocols.ql
Created October 16, 2020 15:58
Top DEX Protocols
{
ethereum(network: ethereum) {
dexTrades(options: {limit: 100, desc: "trades"}) {
protocol
started: minimum(of: date)
trades: count
}
}
}
@buddies2705
buddies2705 / graphql_example.rb
Last active April 14, 2021 08:58
GraphQL with Ruby
require 'net/http'
require 'uri'
require 'json'
uri = URI.parse("https://graphql.bitquery.io/")
header = {'Content-Type': 'application/json'; 'X-API-KEY': 'YOUR API KEY'}
query = "{ bitcoin { blocks { count } } }"
# Create the HTTP objects
http = Net::HTTP.new(uri.host, uri.port)
@buddies2705
buddies2705 / graphql_example.rb
Created October 15, 2020 17:28
Using GraphQL with Ruby
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)