Skip to content

Example SQL Queries & Tutorials

SQL Queries

Known Ethereum Exploiter Addresses

SELECT DISTINCT address as banned_address,
                tag as wallet_tag,
                label as etherscan_label
FROM ethereum.tags WHERE label in ('heist', 'exploit', 'phish-hack')

Malicious Smart Contract Detection Dataset

Query the dataset used to train the malicious smart contract ML bot. 

SELECT * FROM forta.malicious_contract_detection_dataset

Query and convert dataset into a pandas dataframe for data analysis or ML training. 

import requests
from os import environ

LUABASE_API_KEY = environ['LUABASE_API_KEY']
LUABASE_QUERY_URL = "https://q.luabase.com/run"
MALICIOUS_CONTRACT_SQL = '''
SELECT contract_address,
       decompiled_opcodes,
       malicious
FROM forta.malicious_contract_detection_dataset
'''

def get_luabase_data(sql: str, limit: int = 1_000_000) -> pd.DataFrame:
    payload = {
        "block": {
            "details": {
                "sql": sql,
                "limit": limit,
                "parameters": {}
            }
        },
        "api_key": LUABASE_API_KEY,
    }
    headers = {"content-type": "application/json"}
    response = requests.request("POST", LUABASE_QUERY_URL, json=payload, headers=headers)
    data = response.json()
    return pd.DataFrame(data['data'])


get_luabase_data(MALICIOUS_CONTRACT_QUERY)

For more details on how the dataset was created, please check out this data collection notebook.

Tutorials