PREVIEW / etf_30min / 2001-12-12
file: by_date/etf_30min/2001/2001-12-12.parquet size: 18 KB rows: 458
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-12 09:30:00 | SPY | ETF | 114.55 | 114.6 | 114.1 | 114.48 | 1577300.0 |
| 2001-12-12 10:00:00 | SPY | ETF | 114.5 | 114.78 | 114.19 | 114.3 | 2024500.0 |
| 2001-12-12 10:30:00 | SPY | ETF | 114.35 | 114.38 | 113.7 | 113.82 | 1822800.0 |
| 2001-12-12 11:00:00 | SPY | ETF | 113.83 | 113.91 | 113.51 | 113.66 | 932400.0 |
| 2001-12-12 11:30:00 | SPY | ETF | 113.69 | 113.76 | 113.17 | 113.33 | 850400.0 |
| 2001-12-12 12:00:00 | SPY | ETF | 113.3 | 113.4 | 113.11 | 113.32 | 649500.0 |
| 2001-12-12 12:30:00 | SPY | ETF | 113.31 | 113.55 | 113.3 | 113.45 | 1097900.0 |
| 2001-12-12 13:00:00 | SPY | ETF | 113.49 | 113.66 | 113.36 | 113.44 | 621100.0 |
| 2001-12-12 13:30:00 | SPY | ETF | 113.49 | 113.86 | 113.38 | 113.68 | 737100.0 |
| 2001-12-12 14:00:00 | SPY | ETF | 113.7 | 113.74 | 113.21 | 113.42 | 1002600.0 |
| 2001-12-12 14:30:00 | SPY | ETF | 113.4 | 113.66 | 113.21 | 113.3 | 869400.0 |
| 2001-12-12 15:00:00 | SPY | ETF | 113.29 | 114.09 | 113.22 | 113.91 | 1153700.0 |
| 2001-12-12 15:30:00 | SPY | ETF | 113.93 | 114.33 | 113.91 | 114.29 | 2000500.0 |
| 2001-12-12 16:00:00 | SPY | ETF | 114.22 | 114.74 | 114.15 | 114.25 | 825100.0 |
| 2001-12-12 16:30:00 | SPY | ETF | 114.32 | 114.32 | 114.31 | 114.31 | 2100.0 |
| 2001-12-12 17:00:00 | SPY | ETF | 114.28 | 114.28 | 114.27 | 114.28 | 900.0 |
| 2001-12-12 09:30:00 | QQQ | ETF | 41.5 | 41.74 | 41.31 | 41.71 | 6812100.0 |
| 2001-12-12 10:00:00 | QQQ | ETF | 41.71 | 41.94 | 41.58 | 41.7 | 7204800.0 |
| 2001-12-12 10:30:00 | QQQ | ETF | 41.74 | 41.76 | 41.02 | 41.16 | 8255800.0 |
| 2001-12-12 11:00:00 | QQQ | ETF | 41.16 | 41.28 | 40.91 | 41.05 | 5282100.0 |
| 2001-12-12 11:30:00 | QQQ | ETF | 41.13 | 41.15 | 40.6 | 40.82 | 5162500.0 |
| 2001-12-12 12:00:00 | QQQ | ETF | 40.8 | 40.89 | 40.6 | 40.8 | 3212300.0 |
| 2001-12-12 12:30:00 | QQQ | ETF | 40.8 | 40.95 | 40.73 | 40.84 | 2885100.0 |
| 2001-12-12 13:00:00 | QQQ | ETF | 40.85 | 41.07 | 40.8 | 40.96 | 3511400.0 |
| 2001-12-12 13:30:00 | QQQ | ETF | 40.91 | 41.31 | 40.87 | 41.14 | 4660800.0 |
| 2001-12-12 14:00:00 | QQQ | ETF | 41.18 | 41.24 | 40.79 | 40.84 | 5440300.0 |
| 2001-12-12 14:30:00 | QQQ | ETF | 40.82 | 41.07 | 40.74 | 40.79 | 5473300.0 |
| 2001-12-12 15:00:00 | QQQ | ETF | 40.8 | 41.38 | 40.75 | 41.24 | 7205600.0 |
| 2001-12-12 15:30:00 | QQQ | ETF | 41.24 | 41.63 | 41.2 | 41.57 | 9047500.0 |
| 2001-12-12 16:00:00 | QQQ | ETF | 41.57 | 41.63 | 41.4 | 41.56 | 1497700.0 |
| 2001-12-12 16:30:00 | QQQ | ETF | 41.56 | 41.58 | 41.51 | 41.55 | 221400.0 |
| 2001-12-12 17:00:00 | QQQ | ETF | 41.15 | 41.56 | 40.9 | 41.55 | 15500.0 |
| 2001-12-12 17:30:00 | QQQ | ETF | 41.55 | 41.57 | 41.5 | 41.52 | 9300.0 |
| 2001-12-12 18:00:00 | QQQ | ETF | 41.52 | 41.55 | 41.5 | 41.55 | 10200.0 |
| 2001-12-12 09:30:00 | IWM | ETF | 47.45 | 47.47 | 47.25 | 47.34 | 18400.0 |
| 2001-12-12 10:00:00 | IWM | ETF | 47.405 | 47.565 | 47.285 | 47.285 | 4000.0 |
| 2001-12-12 10:30:00 | IWM | ETF | 47.285 | 47.36 | 47.065 | 47.065 | 3600.0 |
| 2001-12-12 11:00:00 | IWM | ETF | 47.16 | 47.175 | 47.01 | 47.175 | 26200.0 |
| 2001-12-12 11:30:00 | IWM | ETF | 47.11 | 47.135 | 47.0 | 47.0 | 5800.0 |
| 2001-12-12 12:00:00 | IWM | ETF | 46.865 | 47.01 | 46.865 | 46.96 | 24000.0 |
| 2001-12-12 12:30:00 | IWM | ETF | 46.98 | 46.99 | 46.97 | 46.98 | 4800.0 |
| 2001-12-12 13:00:00 | IWM | ETF | 46.915 | 47.04 | 46.915 | 47.04 | 2600.0 |
| 2001-12-12 13:30:00 | IWM | ETF | 47.04 | 47.275 | 47.02 | 47.185 | 33800.0 |
| 2001-12-12 14:00:00 | IWM | ETF | 47.185 | 47.21 | 47.06 | 47.185 | 2200.0 |
| 2001-12-12 14:30:00 | IWM | ETF | 47.16 | 47.26 | 47.06 | 47.235 | 31000.0 |
| 2001-12-12 15:00:00 | IWM | ETF | 47.225 | 47.39 | 47.085 | 47.39 | 22200.0 |
| 2001-12-12 15:30:00 | IWM | ETF | 47.365 | 47.465 | 47.25 | 47.4 | 66200.0 |
| 2001-12-12 16:00:00 | IWM | ETF | 47.4 | 47.4 | 47.4 | 47.4 | 2800.0 |
| 2001-12-12 09:30:00 | DIA | ETF | 99.4 | 99.4 | 98.88 | 99.2 | 190800.0 |
| 2001-12-12 10:00:00 | DIA | ETF | 99.14 | 99.45 | 99.0 | 99.1 | 216400.0 |
> showing 50 of 458 rows — these rows as CSV