PREVIEW / etf_5min / 2000-11-24
file: by_date/etf_5min/2000/2000-11-24.parquet size: 14 KB rows: 463
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-11-24 09:30:00 | SPY | ETF | 133.625 | 134.125 | 133.625 | 133.9688 | 263400.0 |
| 2000-11-24 09:35:00 | SPY | ETF | 134.125 | 134.25 | 133.8438 | 133.875 | 311500.0 |
| 2000-11-24 09:40:00 | SPY | ETF | 133.8125 | 134.0 | 133.7188 | 133.7812 | 247100.0 |
| 2000-11-24 09:45:00 | SPY | ETF | 133.7812 | 133.9688 | 133.625 | 133.9688 | 154400.0 |
| 2000-11-24 09:50:00 | SPY | ETF | 133.9688 | 134.0 | 133.8438 | 133.875 | 20000.0 |
| 2000-11-24 09:55:00 | SPY | ETF | 133.9688 | 134.0625 | 133.875 | 134.0 | 66600.0 |
| 2000-11-24 10:00:00 | SPY | ETF | 133.9688 | 134.3438 | 133.9688 | 134.3438 | 76400.0 |
| 2000-11-24 10:05:00 | SPY | ETF | 134.3438 | 134.5 | 134.25 | 134.375 | 144000.0 |
| 2000-11-24 10:10:00 | SPY | ETF | 134.4688 | 134.5938 | 134.2812 | 134.5625 | 118400.0 |
| 2000-11-24 10:15:00 | SPY | ETF | 134.5938 | 134.625 | 134.375 | 134.4688 | 57800.0 |
| 2000-11-24 10:20:00 | SPY | ETF | 134.25 | 134.4062 | 134.25 | 134.3438 | 25100.0 |
| 2000-11-24 10:25:00 | SPY | ETF | 134.25 | 134.3438 | 134.1562 | 134.25 | 60500.0 |
| 2000-11-24 10:30:00 | SPY | ETF | 134.3438 | 134.5 | 134.25 | 134.4375 | 46300.0 |
| 2000-11-24 10:35:00 | SPY | ETF | 134.4375 | 134.4375 | 134.0938 | 134.375 | 18800.0 |
| 2000-11-24 10:40:00 | SPY | ETF | 134.1562 | 134.2812 | 134.125 | 134.2188 | 27300.0 |
| 2000-11-24 10:45:00 | SPY | ETF | 134.3438 | 134.375 | 134.1562 | 134.2188 | 24000.0 |
| 2000-11-24 10:50:00 | SPY | ETF | 134.2812 | 134.3125 | 134.125 | 134.125 | 3500.0 |
| 2000-11-24 10:55:00 | SPY | ETF | 134.2188 | 134.375 | 134.125 | 134.25 | 25200.0 |
| 2000-11-24 11:00:00 | SPY | ETF | 134.3125 | 134.375 | 134.25 | 134.3438 | 7500.0 |
| 2000-11-24 11:05:00 | SPY | ETF | 134.3438 | 134.5625 | 134.25 | 134.4062 | 99200.0 |
| 2000-11-24 11:10:00 | SPY | ETF | 134.5312 | 134.5312 | 134.3125 | 134.4375 | 17600.0 |
| 2000-11-24 11:15:00 | SPY | ETF | 134.4375 | 134.5312 | 134.3125 | 134.4375 | 38300.0 |
| 2000-11-24 11:20:00 | SPY | ETF | 134.4062 | 134.4375 | 134.25 | 134.25 | 25600.0 |
| 2000-11-24 11:25:00 | SPY | ETF | 134.25 | 134.4375 | 134.25 | 134.3438 | 21100.0 |
| 2000-11-24 11:30:00 | SPY | ETF | 134.3438 | 134.375 | 134.25 | 134.3125 | 12300.0 |
| 2000-11-24 11:35:00 | SPY | ETF | 134.375 | 134.4688 | 134.3125 | 134.375 | 14000.0 |
| 2000-11-24 11:40:00 | SPY | ETF | 134.5 | 134.5938 | 134.4375 | 134.5938 | 69300.0 |
| 2000-11-24 11:45:00 | SPY | ETF | 134.5625 | 134.5938 | 134.4375 | 134.5938 | 15500.0 |
| 2000-11-24 11:50:00 | SPY | ETF | 134.5 | 134.5625 | 134.4375 | 134.5312 | 10300.0 |
| 2000-11-24 11:55:00 | SPY | ETF | 134.5625 | 134.5625 | 134.25 | 134.25 | 62900.0 |
| 2000-11-24 12:00:00 | SPY | ETF | 134.2812 | 134.4688 | 134.2812 | 134.3438 | 79900.0 |
| 2000-11-24 12:05:00 | SPY | ETF | 134.3125 | 134.5 | 134.3125 | 134.4062 | 74200.0 |
| 2000-11-24 12:10:00 | SPY | ETF | 134.5 | 134.7812 | 134.4375 | 134.7812 | 104900.0 |
| 2000-11-24 12:15:00 | SPY | ETF | 134.7812 | 134.8438 | 134.6875 | 134.75 | 51600.0 |
| 2000-11-24 12:20:00 | SPY | ETF | 134.75 | 134.9688 | 134.5938 | 134.875 | 31400.0 |
| 2000-11-24 12:25:00 | SPY | ETF | 134.75 | 134.9375 | 134.5625 | 134.5625 | 81900.0 |
| 2000-11-24 12:30:00 | SPY | ETF | 134.6562 | 134.8125 | 134.5312 | 134.7812 | 87300.0 |
| 2000-11-24 12:35:00 | SPY | ETF | 134.7812 | 134.8125 | 134.6875 | 134.6875 | 67800.0 |
| 2000-11-24 12:40:00 | SPY | ETF | 134.8125 | 134.8125 | 134.5 | 134.6562 | 137200.0 |
| 2000-11-24 12:45:00 | SPY | ETF | 134.5 | 134.5938 | 134.4062 | 134.5625 | 61700.0 |
| 2000-11-24 12:50:00 | SPY | ETF | 134.5 | 134.5938 | 134.2188 | 134.2188 | 184600.0 |
| 2000-11-24 12:55:00 | SPY | ETF | 134.3125 | 134.5625 | 134.25 | 134.4375 | 144700.0 |
| 2000-11-24 13:00:00 | SPY | ETF | 134.5312 | 134.5938 | 134.4062 | 134.5938 | 34000.0 |
| 2000-11-24 13:05:00 | SPY | ETF | 134.5 | 134.5938 | 134.5 | 134.5625 | 2900.0 |
| 2000-11-24 13:10:00 | SPY | ETF | 134.5938 | 134.875 | 134.5938 | 134.8125 | 18400.0 |
| 2000-11-24 13:15:00 | SPY | ETF | 134.75 | 134.8438 | 134.75 | 134.8438 | 44200.0 |
| 2000-11-24 09:30:00 | QQQ | ETF | 68.375 | 69.125 | 68.375 | 69.0 | 1841300.0 |
| 2000-11-24 09:35:00 | QQQ | ETF | 69.1562 | 69.1562 | 68.375 | 68.5 | 681500.0 |
| 2000-11-24 09:40:00 | QQQ | ETF | 68.375 | 68.75 | 68.1562 | 68.4375 | 482500.0 |
| 2000-11-24 09:45:00 | QQQ | ETF | 68.3125 | 68.75 | 68.25 | 68.5 | 509100.0 |
> showing 50 of 463 rows — these rows as CSV