PREVIEW / etf_30min / 2000-05-26
file: by_date/etf_30min/2000/2000-05-26.parquet size: 10 KB rows: 214
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 |
|---|---|---|---|---|---|---|---|
| 2000-05-26 09:30:00 | SPY | ETF | 138.8125 | 139.6875 | 138.25 | 138.375 | 1175200.0 |
| 2000-05-26 10:00:00 | SPY | ETF | 138.375 | 138.7188 | 137.5312 | 138.2812 | 778900.0 |
| 2000-05-26 10:30:00 | SPY | ETF | 138.2812 | 139.25 | 138.0625 | 138.7188 | 322300.0 |
| 2000-05-26 11:00:00 | SPY | ETF | 138.75 | 139.0625 | 138.1875 | 138.7812 | 275900.0 |
| 2000-05-26 11:30:00 | SPY | ETF | 138.75 | 139.4375 | 138.5938 | 139.25 | 205200.0 |
| 2000-05-26 12:00:00 | SPY | ETF | 139.1875 | 139.3125 | 138.75 | 139.125 | 292800.0 |
| 2000-05-26 12:30:00 | SPY | ETF | 139.0 | 139.0938 | 138.4062 | 138.5 | 399000.0 |
| 2000-05-26 13:00:00 | SPY | ETF | 138.5 | 138.5938 | 138.0938 | 138.2188 | 81800.0 |
| 2000-05-26 13:30:00 | SPY | ETF | 138.125 | 138.625 | 138.0 | 138.25 | 104900.0 |
| 2000-05-26 14:00:00 | SPY | ETF | 138.3125 | 138.3125 | 137.6562 | 138.0 | 201000.0 |
| 2000-05-26 14:30:00 | SPY | ETF | 137.9688 | 138.3438 | 137.5 | 138.1562 | 128900.0 |
| 2000-05-26 15:00:00 | SPY | ETF | 138.0 | 138.4375 | 137.4375 | 137.6562 | 218000.0 |
| 2000-05-26 15:30:00 | SPY | ETF | 137.625 | 138.375 | 137.3125 | 138.3125 | 367300.0 |
| 2000-05-26 16:00:00 | SPY | ETF | 138.3438 | 138.6875 | 138.0 | 138.0 | 255500.0 |
| 2000-05-26 09:30:00 | QQQ | ETF | 77.75 | 79.25 | 76.75 | 77.0 | 3057900.0 |
| 2000-05-26 10:00:00 | QQQ | ETF | 77.25 | 77.4375 | 75.75 | 76.5625 | 3537800.0 |
| 2000-05-26 10:30:00 | QQQ | ETF | 76.625 | 78.0 | 76.4375 | 77.0 | 1864900.0 |
| 2000-05-26 11:00:00 | QQQ | ETF | 77.0625 | 78.0312 | 76.875 | 77.75 | 1276100.0 |
| 2000-05-26 11:30:00 | QQQ | ETF | 77.75 | 78.4688 | 77.25 | 78.0625 | 1019300.0 |
| 2000-05-26 12:00:00 | QQQ | ETF | 78.0 | 78.0625 | 77.25 | 77.625 | 969400.0 |
| 2000-05-26 12:30:00 | QQQ | ETF | 77.625 | 77.8125 | 76.5625 | 76.875 | 717000.0 |
| 2000-05-26 13:00:00 | QQQ | ETF | 76.75 | 77.125 | 76.4062 | 76.5 | 547800.0 |
| 2000-05-26 13:30:00 | QQQ | ETF | 76.5 | 77.1875 | 76.25 | 76.75 | 675400.0 |
| 2000-05-26 14:00:00 | QQQ | ETF | 76.75 | 76.75 | 76.0 | 76.3125 | 1065600.0 |
| 2000-05-26 14:30:00 | QQQ | ETF | 76.5625 | 77.3125 | 76.0 | 77.25 | 778500.0 |
| 2000-05-26 15:00:00 | QQQ | ETF | 77.25 | 77.3125 | 76.125 | 76.5 | 618400.0 |
| 2000-05-26 15:30:00 | QQQ | ETF | 76.5625 | 77.75 | 76.0 | 77.5 | 1569300.0 |
| 2000-05-26 16:00:00 | QQQ | ETF | 77.5 | 78.125 | 77.3125 | 77.75 | 413400.0 |
| 2000-05-26 16:30:00 | QQQ | ETF | 77.3125 | 77.6875 | 77.3125 | 77.6875 | 1400.0 |
| 2000-05-26 17:00:00 | QQQ | ETF | 77.6875 | 77.6875 | 77.6875 | 77.6875 | 1000.0 |
| 2000-05-26 17:30:00 | QQQ | ETF | 77.6875 | 77.6875 | 77.6875 | 77.6875 | 100.0 |
| 2000-05-26 18:00:00 | QQQ | ETF | 77.6875 | 77.75 | 77.6875 | 77.75 | 2600.0 |
| 2000-05-26 09:30:00 | IWM | ETF | 45.5312 | 45.5312 | 45.5312 | 45.5312 | 2000.0 |
| 2000-05-26 10:00:00 | IWM | ETF | 45.2812 | 45.2812 | 45.2812 | 45.2812 | 2000.0 |
| 2000-05-26 10:30:00 | IWM | ETF | 45.3125 | 45.5 | 45.3125 | 45.5 | 12000.0 |
| 2000-05-26 12:00:00 | IWM | ETF | 45.6719 | 45.6719 | 45.6719 | 45.6719 | 200.0 |
| 2000-05-26 13:30:00 | IWM | ETF | 45.5625 | 45.5625 | 45.5625 | 45.5625 | 10000.0 |
| 2000-05-26 14:00:00 | IWM | ETF | 45.3594 | 45.3594 | 45.3594 | 45.3594 | 44400.0 |
| 2000-05-26 14:30:00 | IWM | ETF | 45.375 | 45.375 | 45.375 | 45.375 | 200.0 |
| 2000-05-26 15:30:00 | IWM | ETF | 45.7188 | 45.7188 | 45.7188 | 45.7188 | 6000.0 |
| 2000-05-26 09:30:00 | DIA | ETF | 103.4688 | 103.9688 | 102.9375 | 103.0625 | 272500.0 |
| 2000-05-26 10:00:00 | DIA | ETF | 103.125 | 103.375 | 102.5312 | 103.1875 | 128400.0 |
| 2000-05-26 10:30:00 | DIA | ETF | 103.2188 | 103.8125 | 102.9688 | 103.25 | 66300.0 |
| 2000-05-26 11:00:00 | DIA | ETF | 103.125 | 103.5625 | 103.0312 | 103.4375 | 26300.0 |
| 2000-05-26 11:30:00 | DIA | ETF | 103.25 | 103.875 | 103.25 | 103.6875 | 67200.0 |
| 2000-05-26 12:00:00 | DIA | ETF | 103.5 | 103.7812 | 103.375 | 103.6562 | 8600.0 |
| 2000-05-26 12:30:00 | DIA | ETF | 103.6562 | 103.6875 | 103.1875 | 103.375 | 14700.0 |
| 2000-05-26 13:00:00 | DIA | ETF | 103.4375 | 103.5312 | 103.0938 | 103.0938 | 114200.0 |
| 2000-05-26 13:30:00 | DIA | ETF | 103.25 | 103.5312 | 103.2188 | 103.2188 | 8400.0 |
| 2000-05-26 14:00:00 | DIA | ETF | 103.2188 | 103.2188 | 102.75 | 103.0 | 22500.0 |
> showing 50 of 214 rows — these rows as CSV