PREVIEW / etf_30min / 2001-06-28
file: by_date/etf_30min/2001/2001-06-28.parquet size: 15 KB rows: 384
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-06-28 09:30:00 | SPY | ETF | 122.0 | 122.85 | 121.93 | 122.75 | 1824000.0 |
| 2001-06-28 10:00:00 | SPY | ETF | 122.69 | 123.27 | 122.6 | 122.95 | 1120500.0 |
| 2001-06-28 10:30:00 | SPY | ETF | 122.91 | 123.1 | 122.71 | 122.87 | 495100.0 |
| 2001-06-28 11:00:00 | SPY | ETF | 122.87 | 123.18 | 122.73 | 123.02 | 500000.0 |
| 2001-06-28 11:30:00 | SPY | ETF | 123.1 | 123.8 | 123.1 | 123.62 | 920300.0 |
| 2001-06-28 12:00:00 | SPY | ETF | 123.72 | 123.88 | 123.35 | 123.62 | 412900.0 |
| 2001-06-28 12:30:00 | SPY | ETF | 123.64 | 123.78 | 123.51 | 123.65 | 171200.0 |
| 2001-06-28 13:00:00 | SPY | ETF | 123.68 | 123.94 | 123.45 | 123.74 | 361100.0 |
| 2001-06-28 13:30:00 | SPY | ETF | 123.7 | 123.92 | 123.55 | 123.85 | 538900.0 |
| 2001-06-28 14:00:00 | SPY | ETF | 123.9 | 123.9 | 123.36 | 123.7 | 311000.0 |
| 2001-06-28 14:30:00 | SPY | ETF | 123.65 | 123.94 | 123.15 | 123.36 | 1105400.0 |
| 2001-06-28 15:00:00 | SPY | ETF | 123.35 | 123.5 | 122.9 | 122.98 | 479000.0 |
| 2001-06-28 15:30:00 | SPY | ETF | 122.9 | 123.05 | 122.6 | 122.89 | 1095600.0 |
| 2001-06-28 16:00:00 | SPY | ETF | 122.83 | 122.9 | 122.06 | 122.15 | 559500.0 |
| 2001-06-28 09:30:00 | QQQ | ETF | 44.4 | 45.16 | 44.4 | 45.05 | 10908100.0 |
| 2001-06-28 10:00:00 | QQQ | ETF | 45.04 | 45.4 | 44.97 | 45.1 | 7814800.0 |
| 2001-06-28 10:30:00 | QQQ | ETF | 45.15 | 45.31 | 44.95 | 45.16 | 7322700.0 |
| 2001-06-28 11:00:00 | QQQ | ETF | 45.16 | 45.5 | 45.08 | 45.39 | 5055300.0 |
| 2001-06-28 11:30:00 | QQQ | ETF | 45.4 | 46.0 | 45.35 | 45.96 | 10671800.0 |
| 2001-06-28 12:00:00 | QQQ | ETF | 45.95 | 46.08 | 45.58 | 45.8 | 5636100.0 |
| 2001-06-28 12:30:00 | QQQ | ETF | 45.83 | 46.05 | 45.72 | 45.79 | 3077600.0 |
| 2001-06-28 13:00:00 | QQQ | ETF | 45.79 | 46.21 | 45.65 | 46.15 | 3389300.0 |
| 2001-06-28 13:30:00 | QQQ | ETF | 46.13 | 46.29 | 46.0 | 46.25 | 3905900.0 |
| 2001-06-28 14:00:00 | QQQ | ETF | 46.25 | 46.36 | 45.9 | 46.18 | 4022400.0 |
| 2001-06-28 14:30:00 | QQQ | ETF | 46.2 | 46.27 | 45.6 | 45.8 | 8037400.0 |
| 2001-06-28 15:00:00 | QQQ | ETF | 45.76 | 45.86 | 45.23 | 45.29 | 5710300.0 |
| 2001-06-28 15:30:00 | QQQ | ETF | 45.25 | 45.33 | 44.78 | 45.07 | 7721000.0 |
| 2001-06-28 16:00:00 | QQQ | ETF | 45.09 | 45.1 | 44.35 | 44.53 | 2658200.0 |
| 2001-06-28 16:30:00 | QQQ | ETF | 44.51 | 45.6 | 44.5 | 44.76 | 710100.0 |
| 2001-06-28 17:00:00 | QQQ | ETF | 44.73 | 44.92 | 44.72 | 44.92 | 91600.0 |
| 2001-06-28 17:30:00 | QQQ | ETF | 44.9 | 45.7 | 44.82 | 44.88 | 50700.0 |
| 2001-06-28 18:00:00 | QQQ | ETF | 44.9 | 45.2 | 44.72 | 45.0 | 44500.0 |
| 2001-06-28 09:30:00 | IWM | ETF | 49.75 | 50.025 | 49.75 | 50.0 | 63400.0 |
| 2001-06-28 10:00:00 | IWM | ETF | 50.175 | 50.325 | 50.14 | 50.14 | 48200.0 |
| 2001-06-28 10:30:00 | IWM | ETF | 50.08 | 50.125 | 49.95 | 50.0 | 71000.0 |
| 2001-06-28 11:00:00 | IWM | ETF | 50.0 | 50.1 | 50.0 | 50.095 | 41200.0 |
| 2001-06-28 11:30:00 | IWM | ETF | 50.06 | 50.35 | 50.06 | 50.175 | 46400.0 |
| 2001-06-28 12:00:00 | IWM | ETF | 50.175 | 50.375 | 50.135 | 50.3 | 380800.0 |
| 2001-06-28 12:30:00 | IWM | ETF | 50.295 | 50.295 | 50.175 | 50.175 | 10600.0 |
| 2001-06-28 13:00:00 | IWM | ETF | 50.15 | 50.375 | 50.15 | 50.3 | 27600.0 |
| 2001-06-28 13:30:00 | IWM | ETF | 50.3 | 50.365 | 50.3 | 50.345 | 34000.0 |
| 2001-06-28 14:00:00 | IWM | ETF | 50.345 | 50.355 | 50.15 | 50.15 | 27400.0 |
| 2001-06-28 14:30:00 | IWM | ETF | 50.325 | 50.355 | 50.15 | 50.25 | 63200.0 |
| 2001-06-28 15:00:00 | IWM | ETF | 50.2 | 50.275 | 50.06 | 50.06 | 41000.0 |
| 2001-06-28 15:30:00 | IWM | ETF | 50.1 | 50.245 | 49.935 | 50.245 | 44200.0 |
| 2001-06-28 16:00:00 | IWM | ETF | 50.35 | 50.35 | 50.075 | 50.1 | 12400.0 |
| 2001-06-28 09:30:00 | DIA | ETF | 105.07 | 105.85 | 105.0 | 105.74 | 207300.0 |
| 2001-06-28 10:00:00 | DIA | ETF | 105.74 | 106.2 | 105.54 | 105.95 | 160300.0 |
| 2001-06-28 10:30:00 | DIA | ETF | 105.96 | 106.02 | 105.67 | 105.71 | 183800.0 |
| 2001-06-28 11:00:00 | DIA | ETF | 105.77 | 106.09 | 105.7 | 105.98 | 147000.0 |
> showing 50 of 384 rows — these rows as CSV