PREVIEW / etf_30min / 2003-01-27
file: by_date/etf_30min/2003/2003-01-27.parquet size: 23 KB rows: 697
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-01-27 08:00:00 | SPY | ETF | 85.34 | 85.35 | 85.2 | 85.3 | 45000.0 |
| 2003-01-27 08:30:00 | SPY | ETF | 85.25 | 85.29 | 85.12 | 85.18 | 80700.0 |
| 2003-01-27 09:00:00 | SPY | ETF | 85.18 | 85.68 | 85.11 | 85.57 | 89300.0 |
| 2003-01-27 09:30:00 | SPY | ETF | 85.73 | 86.5 | 85.42 | 86.43 | 8891600.0 |
| 2003-01-27 10:00:00 | SPY | ETF | 86.46 | 86.8 | 85.62 | 85.87 | 7988300.0 |
| 2003-01-27 10:30:00 | SPY | ETF | 85.87 | 86.15 | 85.48 | 85.86 | 3402700.0 |
| 2003-01-27 11:00:00 | SPY | ETF | 85.85 | 85.93 | 85.38 | 85.39 | 3133200.0 |
| 2003-01-27 11:30:00 | SPY | ETF | 85.38 | 85.5 | 84.73 | 84.81 | 4265800.0 |
| 2003-01-27 12:00:00 | SPY | ETF | 84.81 | 85.14 | 84.65 | 85.11 | 3266300.0 |
| 2003-01-27 12:30:00 | SPY | ETF | 85.1 | 85.49 | 84.98 | 85.25 | 2733000.0 |
| 2003-01-27 13:00:00 | SPY | ETF | 85.25 | 85.5 | 85.06 | 85.3 | 1736500.0 |
| 2003-01-27 13:30:00 | SPY | ETF | 85.27 | 85.46 | 85.04 | 85.16 | 2636600.0 |
| 2003-01-27 14:00:00 | SPY | ETF | 85.16 | 85.26 | 84.91 | 84.97 | 2327500.0 |
| 2003-01-27 14:30:00 | SPY | ETF | 84.98 | 85.15 | 84.66 | 84.85 | 3056200.0 |
| 2003-01-27 15:00:00 | SPY | ETF | 84.85 | 85.32 | 84.7 | 85.28 | 3211300.0 |
| 2003-01-27 15:30:00 | SPY | ETF | 85.28 | 85.5 | 84.94 | 85.03 | 4392900.0 |
| 2003-01-27 16:00:00 | SPY | ETF | 85.04 | 85.21 | 84.94 | 85.11 | 1334800.0 |
| 2003-01-27 16:30:00 | SPY | ETF | 85.07 | 85.3 | 85.07 | 85.17 | 103400.0 |
| 2003-01-27 17:00:00 | SPY | ETF | 85.2 | 85.23 | 84.84 | 85.21 | 284200.0 |
| 2003-01-27 17:30:00 | SPY | ETF | 85.21 | 85.21 | 85.11 | 85.11 | 410000.0 |
| 2003-01-27 18:00:00 | SPY | ETF | 85.11 | 85.21 | 85.11 | 85.12 | 5700.0 |
| 2003-01-27 18:30:00 | SPY | ETF | 85.12 | 85.24 | 85.12 | 85.24 | 1400.0 |
| 2003-01-27 19:00:00 | SPY | ETF | 85.23 | 85.23 | 85.18 | 85.19 | 8200.0 |
| 2003-01-27 19:30:00 | SPY | ETF | 85.25 | 85.25 | 85.25 | 85.25 | 300.0 |
| 2003-01-27 08:00:00 | QQQ | ETF | 24.51 | 24.51 | 24.39 | 24.39 | 90600.0 |
| 2003-01-27 08:30:00 | QQQ | ETF | 24.38 | 24.45 | 24.33 | 24.43 | 42500.0 |
| 2003-01-27 09:00:00 | QQQ | ETF | 24.42 | 24.58 | 24.4 | 24.47 | 70200.0 |
| 2003-01-27 09:30:00 | QQQ | ETF | 24.45 | 24.98 | 24.43 | 24.9 | 10883400.0 |
| 2003-01-27 10:00:00 | QQQ | ETF | 24.95 | 25.03 | 24.6 | 24.7 | 8572000.0 |
| 2003-01-27 10:30:00 | QQQ | ETF | 24.7 | 24.84 | 24.61 | 24.73 | 4256200.0 |
| 2003-01-27 11:00:00 | QQQ | ETF | 24.74 | 24.81 | 24.58 | 24.6 | 3885000.0 |
| 2003-01-27 11:30:00 | QQQ | ETF | 24.6 | 24.65 | 24.4 | 24.46 | 6754600.0 |
| 2003-01-27 12:00:00 | QQQ | ETF | 24.43 | 24.58 | 24.41 | 24.54 | 4990600.0 |
| 2003-01-27 12:30:00 | QQQ | ETF | 24.54 | 24.65 | 24.5 | 24.58 | 3623200.0 |
| 2003-01-27 13:00:00 | QQQ | ETF | 24.58 | 24.68 | 24.51 | 24.59 | 2666200.0 |
| 2003-01-27 13:30:00 | QQQ | ETF | 24.59 | 24.66 | 24.49 | 24.56 | 3545100.0 |
| 2003-01-27 14:00:00 | QQQ | ETF | 24.53 | 24.54 | 24.43 | 24.49 | 2464200.0 |
| 2003-01-27 14:30:00 | QQQ | ETF | 24.49 | 24.56 | 24.39 | 24.45 | 4323400.0 |
| 2003-01-27 15:00:00 | QQQ | ETF | 24.47 | 24.58 | 24.37 | 24.56 | 3381100.0 |
| 2003-01-27 15:30:00 | QQQ | ETF | 24.55 | 24.67 | 24.45 | 24.54 | 7750000.0 |
| 2003-01-27 16:00:00 | QQQ | ETF | 24.54 | 24.63 | 24.46 | 24.57 | 2691300.0 |
| 2003-01-27 16:30:00 | QQQ | ETF | 24.59 | 24.62 | 24.55 | 24.61 | 73300.0 |
| 2003-01-27 17:00:00 | QQQ | ETF | 24.6 | 24.63 | 24.59 | 24.59 | 200000.0 |
| 2003-01-27 17:30:00 | QQQ | ETF | 24.61 | 24.63 | 24.56 | 24.56 | 19200.0 |
| 2003-01-27 18:00:00 | QQQ | ETF | 24.55 | 24.6 | 24.54 | 24.58 | 10200.0 |
| 2003-01-27 18:30:00 | QQQ | ETF | 24.57 | 24.6 | 24.57 | 24.58 | 6800.0 |
| 2003-01-27 19:00:00 | QQQ | ETF | 24.63 | 24.63 | 24.61 | 24.61 | 1200.0 |
| 2003-01-27 19:30:00 | QQQ | ETF | 24.61 | 24.62 | 24.56 | 24.6 | 11800.0 |
| 2003-01-27 09:00:00 | IWM | ETF | 36.8 | 36.8 | 36.8 | 36.8 | 200.0 |
| 2003-01-27 09:30:00 | IWM | ETF | 37.0 | 37.18 | 36.96 | 37.175 | 319600.0 |
> showing 50 of 697 rows — these rows as CSV