PREVIEW / etf_5min / 2000-01-28
file: by_date/etf_5min/2000/2000-01-28.parquet size: 19 KB rows: 784
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-01-28 09:30:00 | SPY | ETF | 139.4375 | 139.4375 | 139.0625 | 139.0625 | 107400.0 |
| 2000-01-28 09:35:00 | SPY | ETF | 139.0938 | 139.0938 | 138.5 | 138.5 | 83100.0 |
| 2000-01-28 09:40:00 | SPY | ETF | 138.5 | 139.0625 | 138.4375 | 139.0 | 375200.0 |
| 2000-01-28 09:45:00 | SPY | ETF | 138.9688 | 139.4375 | 138.9375 | 139.375 | 150600.0 |
| 2000-01-28 09:50:00 | SPY | ETF | 139.375 | 139.6562 | 139.3125 | 139.3125 | 349600.0 |
| 2000-01-28 09:55:00 | SPY | ETF | 139.4375 | 139.875 | 139.4375 | 139.625 | 169400.0 |
| 2000-01-28 10:00:00 | SPY | ETF | 139.5312 | 139.5625 | 139.1875 | 139.5625 | 361500.0 |
| 2000-01-28 10:05:00 | SPY | ETF | 139.375 | 139.9375 | 139.1875 | 139.875 | 106200.0 |
| 2000-01-28 10:10:00 | SPY | ETF | 139.9062 | 140.0625 | 139.625 | 139.625 | 81300.0 |
| 2000-01-28 10:15:00 | SPY | ETF | 139.625 | 139.875 | 139.5625 | 139.7188 | 37000.0 |
| 2000-01-28 10:20:00 | SPY | ETF | 139.5625 | 139.875 | 139.375 | 139.8125 | 37700.0 |
| 2000-01-28 10:25:00 | SPY | ETF | 139.875 | 139.9688 | 139.5625 | 139.5625 | 15300.0 |
| 2000-01-28 10:30:00 | SPY | ETF | 139.625 | 139.6875 | 139.375 | 139.4375 | 52200.0 |
| 2000-01-28 10:35:00 | SPY | ETF | 139.4062 | 139.5938 | 139.4062 | 139.5312 | 30900.0 |
| 2000-01-28 10:40:00 | SPY | ETF | 139.5 | 139.5625 | 138.9688 | 139.0 | 96300.0 |
| 2000-01-28 10:45:00 | SPY | ETF | 139.0625 | 139.25 | 138.6875 | 138.75 | 194700.0 |
| 2000-01-28 10:50:00 | SPY | ETF | 138.6562 | 138.9062 | 138.625 | 138.75 | 76600.0 |
| 2000-01-28 10:55:00 | SPY | ETF | 138.75 | 138.9062 | 138.5 | 138.8438 | 92000.0 |
| 2000-01-28 11:00:00 | SPY | ETF | 138.6562 | 138.7812 | 138.0 | 138.0312 | 138500.0 |
| 2000-01-28 11:05:00 | SPY | ETF | 138.0312 | 138.4688 | 138.0 | 138.375 | 182200.0 |
| 2000-01-28 11:10:00 | SPY | ETF | 138.3125 | 138.6562 | 138.2188 | 138.5312 | 28800.0 |
| 2000-01-28 11:15:00 | SPY | ETF | 138.4688 | 138.9062 | 138.4688 | 138.5625 | 56500.0 |
| 2000-01-28 11:20:00 | SPY | ETF | 138.6875 | 138.875 | 138.5 | 138.8438 | 7700.0 |
| 2000-01-28 11:25:00 | SPY | ETF | 138.6562 | 138.75 | 138.5 | 138.5625 | 8200.0 |
| 2000-01-28 11:30:00 | SPY | ETF | 138.7188 | 138.7188 | 138.25 | 138.625 | 114700.0 |
| 2000-01-28 11:35:00 | SPY | ETF | 138.7188 | 138.9688 | 138.375 | 138.9688 | 468300.0 |
| 2000-01-28 11:40:00 | SPY | ETF | 138.9688 | 139.0938 | 138.75 | 138.7812 | 48200.0 |
| 2000-01-28 11:45:00 | SPY | ETF | 138.875 | 138.9688 | 138.75 | 138.75 | 58500.0 |
| 2000-01-28 11:50:00 | SPY | ETF | 138.5938 | 138.6875 | 138.5625 | 138.5625 | 8900.0 |
| 2000-01-28 11:55:00 | SPY | ETF | 138.625 | 138.625 | 138.0 | 138.0 | 43400.0 |
| 2000-01-28 12:00:00 | SPY | ETF | 138.0625 | 138.1875 | 137.75 | 137.75 | 132800.0 |
| 2000-01-28 12:05:00 | SPY | ETF | 137.75 | 137.8125 | 137.1875 | 137.1875 | 265800.0 |
| 2000-01-28 12:10:00 | SPY | ETF | 137.25 | 137.5312 | 137.0312 | 137.3438 | 187800.0 |
| 2000-01-28 12:15:00 | SPY | ETF | 137.3438 | 137.9375 | 137.3125 | 137.9375 | 95300.0 |
| 2000-01-28 12:20:00 | SPY | ETF | 137.6875 | 137.9688 | 137.5 | 137.5 | 251100.0 |
| 2000-01-28 12:25:00 | SPY | ETF | 137.5 | 137.6875 | 137.3438 | 137.5 | 13700.0 |
| 2000-01-28 12:30:00 | SPY | ETF | 137.5625 | 138.0 | 137.4062 | 138.0 | 89600.0 |
| 2000-01-28 12:35:00 | SPY | ETF | 137.875 | 137.875 | 137.6875 | 137.75 | 23900.0 |
| 2000-01-28 12:40:00 | SPY | ETF | 137.6875 | 137.8125 | 137.3125 | 137.375 | 254100.0 |
| 2000-01-28 12:45:00 | SPY | ETF | 137.4688 | 137.7812 | 137.4688 | 137.625 | 63500.0 |
| 2000-01-28 12:50:00 | SPY | ETF | 137.75 | 137.75 | 137.3125 | 137.5 | 30300.0 |
| 2000-01-28 12:55:00 | SPY | ETF | 137.5 | 137.5938 | 137.0 | 137.2188 | 139900.0 |
| 2000-01-28 13:00:00 | SPY | ETF | 137.125 | 137.3125 | 136.75 | 136.8125 | 477000.0 |
| 2000-01-28 13:05:00 | SPY | ETF | 136.8125 | 136.9375 | 136.625 | 136.875 | 245900.0 |
| 2000-01-28 13:10:00 | SPY | ETF | 137.0 | 137.5 | 136.8438 | 137.5 | 306900.0 |
| 2000-01-28 13:15:00 | SPY | ETF | 137.5 | 137.875 | 137.2188 | 137.6875 | 80700.0 |
| 2000-01-28 13:20:00 | SPY | ETF | 137.8438 | 137.9688 | 137.5625 | 137.625 | 266700.0 |
| 2000-01-28 13:25:00 | SPY | ETF | 137.5 | 137.6875 | 137.3125 | 137.5 | 149700.0 |
| 2000-01-28 13:30:00 | SPY | ETF | 137.4375 | 137.75 | 137.4375 | 137.7188 | 31500.0 |
| 2000-01-28 13:35:00 | SPY | ETF | 137.7188 | 137.7188 | 137.375 | 137.5 | 18600.0 |
> showing 50 of 784 rows — these rows as CSV