PY
py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
import streamlit as st
import sqlite3
import pandas as pd
import plotly.graph_objects as go
import datetime
# ───────────────────────────────────────────
# 1. SET PAGE CONFIG (MUST BE FIRST)
# ───────────────────────────────────────────
st.set_page_config(layout="wide", page_title="Order Flow Dashboard")
# ───────────────────────────────────────────
# 2. DATA LOADING & OPTIMIZATION
# ───────────────────────────────────────────
@st.cache_data(show_spinner=True)
def load_data(limit):
"""Load the most recent 'limit' trades from the database."""
conn = sqlite3.connect("trades.db")
query = f"""
SELECT tradeTime, buyOrderId, sellOrderId, quantity
FROM trades
ORDER BY tradeTime DESC
LIMIT {limit}
"""
df = pd.read_sql_query(query, conn)
conn.close()
# Convert tradeTime (assumed stored as epoch milliseconds) to datetime
Enter to Rename, Shift+Enter to Preview
OUTPUT
Run