eshaben

# This script is designed to extract meta tags and page titles from
# URLs listed in a sitemap and save the results to a CSV file.
# 
# The script accepts two arguments:
#
# Sitemap URL: The URL of the sitemap to process.
# CSV File Name: The name of the CSV file to which the results will be saved.
# 
# Run the script using the following command:
# python <file_name_of_script> <sitemap_url> <output_csv_file>

eshaben

Documentation for the Airlyft Campaign Indexer

The generic indexer provides address and transaction information across all participating appchains.

The endpoint for the generic indexer is: https://tanssi-campaign.squids.live/airlyft/graphql

TOC:

• Schema
• Recommendations

eshaben

// You can generate the Hyperlane digaram using the mermaid.live editor with the following code:

%%{ init: { "theme": "dark", "themeVariables": { "mainBkg": "#025AA1", "textColor": "white", "edgeLabelBackground": "transparent", "clusterBkg": "transparent", "clusterBorder": "white",

eshaben

import { ethers } from 'ethers';

const providerRPC = {
  moonriver: {
    name: 'moonriver',
    // Switch to see opposite results: https://moonriver.unitedbloc.com
    rpc: 'https://moonriver.api.onfinality.io/public', // Insert your RPC URL here
    chainId: 1285, // 0x505 in hex,
  },
};

eshaben

from eth_utils import to_checksum_address
import requests

# Insert addresses to check
addresses = []

def get_transfers(query):
    res = requests.post("https://app.gc.subsquid.io/beta/moonriver-transfers/1/graphql", json={'query': query}).json()
    transfers = res['data']['transfers']
    return transfers

eshaben

import pandas as pd

data = pd.read_csv('~/Downloads/0x50afc32c3e5d25aee36d035806d80ee0c09c2a16.csv')

out_flow = data.loc[data['From'] == '0x50afc32c3e5d25aee36d035806d80ee0c09c2a16', 'Value'].sum()
in_flow = data.loc[data['To'] == '0x50afc32c3e5d25aee36d035806d80ee0c09c2a16', 'Value'].sum()

print("Subscan", in_flow, out_flow)

eshaben

import requests

def get_transfers(query):
    res = requests.post("https://api.subquery.network/sq/eshaben/moonriver-asset-transfers", json={'query': query}).json()
    transfers =res['data']['transfers']['nodes']
    return transfers

outflow_balance = 0
inflow_balance = 0
counter = 0

eshaben

import pandas as pd

data = pd.read_csv('~/Downloads/export-address-token-0xd3dfd3ede74e0dcebc1aa685e151332857efce2d.csv')

receive = data.loc[data['From'] == '0xd3dfd3ede74e0dcebc1aa685e151332857efce2d', 'Value']
send = data.loc[data['To'] == '0xd3dfd3ede74e0dcebc1aa685e151332857efce2d', 'Value']

send_sum = 0
receive_sum = 0

eshaben

import pandas as pd

data = pd.read_csv('~/Downloads/export-token-0x30d2a9f5fdf90ace8c17952cbb4ee48a55d916a7 (1).csv')

swapin = data.loc[data['From'] == '0x0000000000000000000000000000000000000000', 'Quantity'].sum()
swapout = data.loc[data['To'] == '0x0000000000000000000000000000000000000000', 'Quantity'].sum()

print(receive_sum, send_sum)

eshaben

import pandas as pd

data = pd.read_csv('~/Downloads/export-TxGrowth (1).csv')
print(data['Value'].sum())