Getting Started with TradeXil Datasets

# Check if Python is already installed:

# WINDOWS (Command Prompt or PowerShell):
python --version
# Expected output: Python 3.8.x or higher

# LINUX/MAC (Terminal):
python3 --version
# Expected output: Python 3.8.x or higher

# ─────────────────────────────────────────
# If NOT installed:
# ─────────────────────────────────────────

# WINDOWS:
# 1. Go to: https://www.python.org/downloads/
# 2. Download Python 3.11 or later
# 3. Run installer
# 4. CHECK "Add Python to PATH" during installation
# 5. Restart Command Prompt

# LINUX (Ubuntu/Debian):
sudo apt update
sudo apt install python3 python3-pip python3-venv

# LINUX (Fedora/RHEL):
sudo dnf install python3 python3-pip

# MAC (with Homebrew):
brew install python3

# WINDOWS (Command Prompt):
cd C:\Users\YourName\Documents
mkdir tradexil-analysis
cd tradexil-analysis
dir

# WINDOWS (PowerShell):
cd ~\Documents
mkdir tradexil-analysis
cd tradexil-analysis
ls

# LINUX/MAC (Terminal):
cd ~/Documents
mkdir tradexil-analysis
cd tradexil-analysis
ls

# WINDOWS (Command Prompt):
python -m venv venv
venv\Scripts\activate
# You'll see (venv) in your prompt

# WINDOWS (PowerShell - if you get execution policy error):
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser
python -m venv venv
venv\Scripts\Activate.ps1

# LINUX/MAC (Terminal):
python3 -m venv venv
source venv/bin/activate
# You'll see (venv) in your prompt

# To deactivate later:
# deactivate

# Make sure virtual environment is activated (you see (venv) in prompt)

# WINDOWS:
pip install pandas pyarrow jupyter

# LINUX/MAC:
pip install pandas pyarrow jupyter

# Verify installation:
pip list | findstr pandas     # Windows
pip list | grep pandas        # Linux/Mac

# Expected output:
# pandas         2.x.x
# pyarrow        14.x.x
# jupyter        1.x.x

# 1. Go to: https://tradexil.com/data
# 2. Click "Get Access" for 1-Day timeframe (FREE)
# 3. Enter your email
# 4. Check your email for the activation key
# 5. Download the .parquet file
# 6. Move it to your project folder:

# WINDOWS:
# Move from Downloads to project folder:
move C:\Users\YourName\Downloads\btcusdt_1d_*.parquet .
dir *.parquet

# LINUX/MAC:
# Move from Downloads to project folder:
mv ~/Downloads/btcusdt_1d_*.parquet .
ls *.parquet

# You should see: btcusdt_1d_2020-2024.parquet

# Create a new file: analyze.py
# Copy this code:

import pandas as pd
import warnings
warnings.filterwarnings('ignore')

# Load the dataset
print("Loading TradeXil dataset...")
df = pd.read_parquet('btcusdt_1d_2020-2024.parquet')

# Display basic information
print("\n" + "="*60)
print("Dataset loaded successfully!")
print("="*60)
print(f"\nDate Range: {df['datetime'].min()} to {df['datetime'].max()}")
print(f"Total Candles: {len(df):,}")
print(f"Columns: {len(df.columns)}")
print(f"Memory: {df.memory_usage(deep=True).sum() / (1024**2):.2f} MB")

# Show latest prices
print("\n" + "="*60)
print("Latest Prices (Last 5 days)")
print("="*60)
latest = df[['datetime', 'open', 'high', 'low', 'close', 'volume']].tail(5)
print(latest.to_string(index=False))

# Show some technical indicators
print("\n" + "="*60)
print("Technical Indicators (Latest)")
print("="*60)
indicators = df[['datetime', 'RSI_14', 'MACD_12_26_9_line', 'BB_20_2_upper', 'BB_20_2_lower']].tail(1)
print(indicators.to_string(index=False))

print("\nAnalysis complete!\n")

# WINDOWS (Command Prompt or PowerShell):
python analyze.py

# LINUX/MAC (Terminal):
python3 analyze.py

# You should see output showing:
# - Dataset information
# - Latest prices
# - Technical indicators

# Start Jupyter Notebook:

# WINDOWS:
jupyter notebook

# LINUX/MAC:
jupyter notebook

# This will open your browser automatically
# Create a new notebook: New → Python 3
# Then you can run code interactively!

# Example notebook cell:
import pandas as pd
df = pd.read_parquet('btcusdt_1d_2020-2024.parquet')
df.head()