PREVIEW / etf_30min / 2003-01-21
file: by_date/etf_30min/2003/2003-01-21.parquet size: 22 KB rows: 661
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-21 08:00:00 | SPY | ETF | 90.48 | 90.52 | 90.45 | 90.52 | 25800.0 |
| 2003-01-21 08:30:00 | SPY | ETF | 90.55 | 90.8 | 90.45 | 90.8 | 31900.0 |
| 2003-01-21 09:00:00 | SPY | ETF | 90.79 | 90.85 | 90.72 | 90.85 | 11300.0 |
| 2003-01-21 09:30:00 | SPY | ETF | 90.87 | 90.92 | 90.4 | 90.48 | 4983600.0 |
| 2003-01-21 10:00:00 | SPY | ETF | 90.48 | 90.52 | 90.13 | 90.21 | 4452900.0 |
| 2003-01-21 10:30:00 | SPY | ETF | 90.21 | 90.3 | 89.75 | 89.85 | 3564700.0 |
| 2003-01-21 11:00:00 | SPY | ETF | 89.85 | 89.99 | 89.72 | 89.8 | 2409200.0 |
| 2003-01-21 11:30:00 | SPY | ETF | 89.82 | 89.94 | 89.65 | 89.94 | 1581000.0 |
| 2003-01-21 12:00:00 | SPY | ETF | 89.92 | 90.08 | 89.81 | 89.85 | 2485800.0 |
| 2003-01-21 12:30:00 | SPY | ETF | 89.84 | 90.05 | 89.63 | 90.05 | 1266400.0 |
| 2003-01-21 13:00:00 | SPY | ETF | 90.05 | 90.18 | 89.92 | 90.05 | 1634200.0 |
| 2003-01-21 13:30:00 | SPY | ETF | 90.07 | 90.1 | 89.8 | 89.89 | 754800.0 |
| 2003-01-21 14:00:00 | SPY | ETF | 89.91 | 89.91 | 89.57 | 89.71 | 2091700.0 |
| 2003-01-21 14:30:00 | SPY | ETF | 89.69 | 89.75 | 89.42 | 89.47 | 1541900.0 |
| 2003-01-21 15:00:00 | SPY | ETF | 89.43 | 89.46 | 89.14 | 89.2 | 3156000.0 |
| 2003-01-21 15:30:00 | SPY | ETF | 89.17 | 89.27 | 89.03 | 89.07 | 3520900.0 |
| 2003-01-21 16:00:00 | SPY | ETF | 89.02 | 89.25 | 88.73 | 89.15 | 1146900.0 |
| 2003-01-21 16:30:00 | SPY | ETF | 89.12 | 89.25 | 89.12 | 89.13 | 55600.0 |
| 2003-01-21 17:00:00 | SPY | ETF | 89.13 | 89.18 | 89.1 | 89.1 | 8900.0 |
| 2003-01-21 17:30:00 | SPY | ETF | 89.1 | 90.46 | 89.08 | 89.12 | 5537700.0 |
| 2003-01-21 18:00:00 | SPY | ETF | 89.11 | 89.11 | 89.06 | 89.06 | 4600.0 |
| 2003-01-21 18:30:00 | SPY | ETF | 89.14 | 89.18 | 89.1 | 89.18 | 4200.0 |
| 2003-01-21 19:30:00 | SPY | ETF | 89.21 | 89.21 | 89.12 | 89.18 | 1900.0 |
| 2003-01-21 08:00:00 | QQQ | ETF | 25.3 | 25.32 | 25.25 | 25.27 | 82000.0 |
| 2003-01-21 08:30:00 | QQQ | ETF | 25.32 | 25.45 | 25.3 | 25.43 | 40100.0 |
| 2003-01-21 09:00:00 | QQQ | ETF | 25.44 | 25.44 | 25.34 | 25.4 | 16400.0 |
| 2003-01-21 09:30:00 | QQQ | ETF | 25.41 | 25.55 | 25.34 | 25.41 | 8999100.0 |
| 2003-01-21 10:00:00 | QQQ | ETF | 25.42 | 25.46 | 25.25 | 25.35 | 6980400.0 |
| 2003-01-21 10:30:00 | QQQ | ETF | 25.34 | 25.42 | 25.17 | 25.25 | 8222700.0 |
| 2003-01-21 11:00:00 | QQQ | ETF | 25.27 | 25.29 | 25.13 | 25.2 | 2751600.0 |
| 2003-01-21 11:30:00 | QQQ | ETF | 25.2 | 25.34 | 25.15 | 25.34 | 3599400.0 |
| 2003-01-21 12:00:00 | QQQ | ETF | 25.34 | 25.42 | 25.3 | 25.33 | 3449500.0 |
| 2003-01-21 12:30:00 | QQQ | ETF | 25.34 | 25.48 | 25.27 | 25.48 | 2542600.0 |
| 2003-01-21 13:00:00 | QQQ | ETF | 25.47 | 25.55 | 25.43 | 25.49 | 2303400.0 |
| 2003-01-21 13:30:00 | QQQ | ETF | 25.49 | 25.51 | 25.37 | 25.41 | 1768300.0 |
| 2003-01-21 14:00:00 | QQQ | ETF | 25.41 | 25.42 | 25.31 | 25.37 | 2430700.0 |
| 2003-01-21 14:30:00 | QQQ | ETF | 25.38 | 25.42 | 25.22 | 25.25 | 4171500.0 |
| 2003-01-21 15:00:00 | QQQ | ETF | 25.25 | 25.27 | 25.12 | 25.18 | 6636700.0 |
| 2003-01-21 15:30:00 | QQQ | ETF | 25.17 | 25.25 | 25.1 | 25.13 | 6516300.0 |
| 2003-01-21 16:00:00 | QQQ | ETF | 25.11 | 25.15 | 24.98 | 25.01 | 2445100.0 |
| 2003-01-21 16:30:00 | QQQ | ETF | 25.01 | 25.05 | 24.97 | 25.02 | 403900.0 |
| 2003-01-21 17:00:00 | QQQ | ETF | 25.02 | 25.1 | 25.0 | 25.05 | 205800.0 |
| 2003-01-21 17:30:00 | QQQ | ETF | 25.06 | 25.1 | 25.05 | 25.09 | 970700.0 |
| 2003-01-21 18:00:00 | QQQ | ETF | 25.09 | 25.11 | 25.08 | 25.08 | 36100.0 |
| 2003-01-21 18:30:00 | QQQ | ETF | 25.08 | 25.12 | 25.06 | 25.11 | 18700.0 |
| 2003-01-21 19:00:00 | QQQ | ETF | 25.14 | 25.14 | 25.09 | 25.09 | 200.0 |
| 2003-01-21 19:30:00 | QQQ | ETF | 25.1 | 25.1 | 25.08 | 25.1 | 10900.0 |
| 2003-01-21 09:30:00 | IWM | ETF | 38.7 | 38.77 | 38.445 | 38.49 | 233400.0 |
| 2003-01-21 10:00:00 | IWM | ETF | 38.48 | 38.48 | 38.305 | 38.35 | 141000.0 |
| 2003-01-21 10:30:00 | IWM | ETF | 38.315 | 38.375 | 38.225 | 38.305 | 80200.0 |
> showing 50 of 661 rows — these rows as CSV