PREVIEW / etf_30min / 2003-02-03
file: by_date/etf_30min/2003/2003-02-03.parquet size: 20 KB rows: 604
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2003-02-03 08:00:00 | SPY | ETF | 86.65 | 86.65 | 86.3 | 86.38 | 11100.0 |
| 2003-02-03 08:30:00 | SPY | ETF | 86.35 | 86.4 | 86.29 | 86.33 | 22300.0 |
| 2003-02-03 09:00:00 | SPY | ETF | 86.31 | 86.33 | 86.11 | 86.13 | 28500.0 |
| 2003-02-03 09:30:00 | SPY | ETF | 86.16 | 86.45 | 85.92 | 86.2 | 5988000.0 |
| 2003-02-03 10:00:00 | SPY | ETF | 86.13 | 86.75 | 86.06 | 86.73 | 6335900.0 |
| 2003-02-03 10:30:00 | SPY | ETF | 86.73 | 86.81 | 86.45 | 86.6 | 2492200.0 |
| 2003-02-03 11:00:00 | SPY | ETF | 86.58 | 86.67 | 86.01 | 86.05 | 2945000.0 |
| 2003-02-03 11:30:00 | SPY | ETF | 86.02 | 86.34 | 86.0 | 86.28 | 1879100.0 |
| 2003-02-03 12:00:00 | SPY | ETF | 86.28 | 86.46 | 86.02 | 86.23 | 2119400.0 |
| 2003-02-03 12:30:00 | SPY | ETF | 86.24 | 86.55 | 86.18 | 86.35 | 1493100.0 |
| 2003-02-03 13:00:00 | SPY | ETF | 86.35 | 86.55 | 86.3 | 86.49 | 713900.0 |
| 2003-02-03 13:30:00 | SPY | ETF | 86.47 | 86.74 | 86.46 | 86.53 | 1803800.0 |
| 2003-02-03 14:00:00 | SPY | ETF | 86.49 | 86.78 | 86.4 | 86.65 | 1554700.0 |
| 2003-02-03 14:30:00 | SPY | ETF | 86.75 | 86.78 | 86.28 | 86.28 | 1266600.0 |
| 2003-02-03 15:00:00 | SPY | ETF | 86.31 | 86.43 | 86.04 | 86.2 | 2355200.0 |
| 2003-02-03 15:30:00 | SPY | ETF | 86.25 | 86.43 | 86.1 | 86.27 | 2082700.0 |
| 2003-02-03 16:00:00 | SPY | ETF | 86.27 | 86.38 | 86.2 | 86.36 | 1105000.0 |
| 2003-02-03 16:30:00 | SPY | ETF | 86.36 | 86.36 | 86.25 | 86.28 | 345800.0 |
| 2003-02-03 17:00:00 | SPY | ETF | 86.27 | 86.36 | 86.24 | 86.34 | 124400.0 |
| 2003-02-03 17:30:00 | SPY | ETF | 86.31 | 86.52 | 86.31 | 86.46 | 12400.0 |
| 2003-02-03 18:00:00 | SPY | ETF | 86.41 | 86.41 | 86.3 | 86.3 | 6300.0 |
| 2003-02-03 19:30:00 | SPY | ETF | 86.32 | 86.32 | 86.3 | 86.3 | 700.0 |
| 2003-02-03 08:00:00 | QQQ | ETF | 24.66 | 24.73 | 24.6 | 24.62 | 76600.0 |
| 2003-02-03 08:30:00 | QQQ | ETF | 24.6 | 24.64 | 24.57 | 24.57 | 34100.0 |
| 2003-02-03 09:00:00 | QQQ | ETF | 24.57 | 24.63 | 24.55 | 24.55 | 35600.0 |
| 2003-02-03 09:30:00 | QQQ | ETF | 24.52 | 24.59 | 24.38 | 24.54 | 7631200.0 |
| 2003-02-03 10:00:00 | QQQ | ETF | 24.52 | 24.76 | 24.49 | 24.72 | 6375400.0 |
| 2003-02-03 10:30:00 | QQQ | ETF | 24.73 | 24.79 | 24.65 | 24.69 | 3402200.0 |
| 2003-02-03 11:00:00 | QQQ | ETF | 24.68 | 24.73 | 24.49 | 24.5 | 3591600.0 |
| 2003-02-03 11:30:00 | QQQ | ETF | 24.51 | 24.63 | 24.46 | 24.59 | 2320400.0 |
| 2003-02-03 12:00:00 | QQQ | ETF | 24.59 | 24.66 | 24.51 | 24.61 | 2259600.0 |
| 2003-02-03 12:30:00 | QQQ | ETF | 24.61 | 24.7 | 24.57 | 24.64 | 1577400.0 |
| 2003-02-03 13:00:00 | QQQ | ETF | 24.65 | 24.72 | 24.57 | 24.67 | 1321200.0 |
| 2003-02-03 13:30:00 | QQQ | ETF | 24.67 | 24.76 | 24.62 | 24.67 | 1870900.0 |
| 2003-02-03 14:00:00 | QQQ | ETF | 24.64 | 24.76 | 24.59 | 24.7 | 2545800.0 |
| 2003-02-03 14:30:00 | QQQ | ETF | 24.71 | 24.74 | 24.56 | 24.58 | 3345500.0 |
| 2003-02-03 15:00:00 | QQQ | ETF | 24.58 | 24.64 | 24.48 | 24.54 | 3532700.0 |
| 2003-02-03 15:30:00 | QQQ | ETF | 24.55 | 24.58 | 24.46 | 24.51 | 3770900.0 |
| 2003-02-03 16:00:00 | QQQ | ETF | 24.5 | 24.54 | 24.47 | 24.52 | 1136900.0 |
| 2003-02-03 16:30:00 | QQQ | ETF | 24.54 | 24.56 | 24.51 | 24.56 | 154400.0 |
| 2003-02-03 17:00:00 | QQQ | ETF | 24.55 | 24.57 | 24.53 | 24.57 | 90900.0 |
| 2003-02-03 17:30:00 | QQQ | ETF | 24.57 | 24.59 | 24.57 | 24.57 | 12300.0 |
| 2003-02-03 18:00:00 | QQQ | ETF | 24.54 | 24.56 | 24.53 | 24.54 | 13800.0 |
| 2003-02-03 18:30:00 | QQQ | ETF | 24.56 | 24.58 | 24.55 | 24.56 | 1300.0 |
| 2003-02-03 19:00:00 | QQQ | ETF | 24.54 | 24.54 | 24.54 | 24.54 | 200.0 |
| 2003-02-03 19:30:00 | QQQ | ETF | 24.56 | 24.56 | 24.55 | 24.56 | 800.0 |
| 2003-02-03 09:30:00 | IWM | ETF | 37.2 | 37.2 | 36.895 | 36.955 | 236600.0 |
| 2003-02-03 10:00:00 | IWM | ETF | 37.025 | 37.18 | 36.955 | 37.18 | 448000.0 |
| 2003-02-03 10:30:00 | IWM | ETF | 37.19 | 37.24 | 37.14 | 37.18 | 774600.0 |
| 2003-02-03 11:00:00 | IWM | ETF | 37.175 | 37.175 | 36.95 | 36.955 | 215800.0 |
> showing 50 of 604 rows — these rows as CSV