PREVIEW / etf_5min / 2000-09-27
file: by_date/etf_5min/2000/2000-09-27.parquet size: 20 KB rows: 882
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-09-27 09:30:00 | SPY | ETF | 143.5625 | 143.7188 | 143.4062 | 143.7188 | 142500.0 |
| 2000-09-27 09:35:00 | SPY | ETF | 143.7188 | 143.7188 | 143.4062 | 143.5 | 80300.0 |
| 2000-09-27 09:40:00 | SPY | ETF | 143.5312 | 143.5312 | 143.25 | 143.375 | 45500.0 |
| 2000-09-27 09:45:00 | SPY | ETF | 143.2812 | 143.5312 | 143.0938 | 143.5312 | 141600.0 |
| 2000-09-27 09:50:00 | SPY | ETF | 143.4688 | 143.5938 | 143.2812 | 143.5 | 21700.0 |
| 2000-09-27 09:55:00 | SPY | ETF | 143.4375 | 143.625 | 143.3125 | 143.4375 | 54300.0 |
| 2000-09-27 10:00:00 | SPY | ETF | 143.3125 | 143.3125 | 142.8438 | 143.0312 | 57800.0 |
| 2000-09-27 10:05:00 | SPY | ETF | 143.0625 | 143.1875 | 142.9062 | 143.0312 | 62500.0 |
| 2000-09-27 10:10:00 | SPY | ETF | 143.0 | 143.4375 | 142.8438 | 143.2188 | 56400.0 |
| 2000-09-27 10:15:00 | SPY | ETF | 143.4062 | 143.5 | 143.0938 | 143.375 | 121000.0 |
| 2000-09-27 10:20:00 | SPY | ETF | 143.3125 | 143.5625 | 143.3125 | 143.5312 | 48500.0 |
| 2000-09-27 10:25:00 | SPY | ETF | 143.5 | 143.5 | 143.1562 | 143.1562 | 102300.0 |
| 2000-09-27 10:30:00 | SPY | ETF | 143.2812 | 143.3438 | 142.8438 | 142.875 | 82100.0 |
| 2000-09-27 10:35:00 | SPY | ETF | 143.0 | 143.125 | 142.9375 | 142.9375 | 19700.0 |
| 2000-09-27 10:40:00 | SPY | ETF | 143.0625 | 143.2188 | 143.0 | 143.0938 | 83600.0 |
| 2000-09-27 10:45:00 | SPY | ETF | 143.125 | 143.125 | 142.9375 | 143.0 | 21300.0 |
| 2000-09-27 10:50:00 | SPY | ETF | 143.0312 | 143.0625 | 142.8438 | 143.0625 | 5900.0 |
| 2000-09-27 10:55:00 | SPY | ETF | 143.0625 | 143.0625 | 142.75 | 142.875 | 34700.0 |
| 2000-09-27 11:00:00 | SPY | ETF | 142.75 | 142.75 | 142.5625 | 142.6875 | 174300.0 |
| 2000-09-27 11:05:00 | SPY | ETF | 142.625 | 142.6875 | 142.5 | 142.6562 | 326900.0 |
| 2000-09-27 11:10:00 | SPY | ETF | 142.5312 | 142.875 | 142.5312 | 142.875 | 77200.0 |
| 2000-09-27 11:15:00 | SPY | ETF | 142.9375 | 142.9375 | 142.5 | 142.5 | 35700.0 |
| 2000-09-27 11:20:00 | SPY | ETF | 142.6562 | 143.2812 | 142.5625 | 143.25 | 230900.0 |
| 2000-09-27 11:25:00 | SPY | ETF | 143.25 | 143.25 | 142.875 | 142.875 | 92900.0 |
| 2000-09-27 11:30:00 | SPY | ETF | 142.9688 | 143.0312 | 142.7188 | 142.7188 | 133600.0 |
| 2000-09-27 11:35:00 | SPY | ETF | 142.7188 | 143.0 | 142.6875 | 143.0 | 45800.0 |
| 2000-09-27 11:40:00 | SPY | ETF | 142.9688 | 143.1562 | 142.9062 | 142.9062 | 64700.0 |
| 2000-09-27 11:45:00 | SPY | ETF | 143.0 | 143.5 | 143.0 | 143.5 | 52900.0 |
| 2000-09-27 11:50:00 | SPY | ETF | 143.4688 | 143.4688 | 143.0312 | 143.0938 | 14600.0 |
| 2000-09-27 11:55:00 | SPY | ETF | 143.1562 | 143.25 | 143.125 | 143.125 | 17500.0 |
| 2000-09-27 12:00:00 | SPY | ETF | 143.125 | 143.25 | 143.0312 | 143.25 | 19500.0 |
| 2000-09-27 12:05:00 | SPY | ETF | 143.2188 | 143.3125 | 143.125 | 143.3125 | 8300.0 |
| 2000-09-27 12:10:00 | SPY | ETF | 143.3125 | 143.4062 | 143.2188 | 143.2188 | 57200.0 |
| 2000-09-27 12:15:00 | SPY | ETF | 143.2188 | 143.25 | 143.2188 | 143.2188 | 11400.0 |
| 2000-09-27 12:20:00 | SPY | ETF | 143.125 | 143.25 | 143.125 | 143.25 | 1500.0 |
| 2000-09-27 12:25:00 | SPY | ETF | 143.1562 | 143.2812 | 143.1562 | 143.1875 | 112000.0 |
| 2000-09-27 12:30:00 | SPY | ETF | 143.3125 | 143.6562 | 143.2812 | 143.5312 | 93500.0 |
| 2000-09-27 12:35:00 | SPY | ETF | 143.5312 | 143.9688 | 143.5312 | 143.75 | 249500.0 |
| 2000-09-27 12:40:00 | SPY | ETF | 143.6875 | 143.8125 | 143.625 | 143.7188 | 46100.0 |
| 2000-09-27 12:45:00 | SPY | ETF | 143.6562 | 143.75 | 143.625 | 143.7188 | 68900.0 |
| 2000-09-27 12:50:00 | SPY | ETF | 143.7188 | 143.7188 | 143.5 | 143.5 | 10500.0 |
| 2000-09-27 12:55:00 | SPY | ETF | 143.5 | 143.5625 | 143.4375 | 143.4375 | 2400.0 |
| 2000-09-27 13:00:00 | SPY | ETF | 143.4375 | 143.625 | 143.4375 | 143.5625 | 56700.0 |
| 2000-09-27 13:05:00 | SPY | ETF | 143.5625 | 143.5938 | 143.2812 | 143.2812 | 9000.0 |
| 2000-09-27 13:10:00 | SPY | ETF | 143.4062 | 143.4062 | 143.25 | 143.25 | 5700.0 |
| 2000-09-27 13:15:00 | SPY | ETF | 143.4688 | 143.4688 | 143.4688 | 143.4688 | 5000.0 |
| 2000-09-27 13:20:00 | SPY | ETF | 143.3125 | 143.5 | 143.3125 | 143.5 | 33500.0 |
| 2000-09-27 13:25:00 | SPY | ETF | 143.5 | 143.5312 | 143.4375 | 143.4375 | 10200.0 |
| 2000-09-27 13:30:00 | SPY | ETF | 143.5312 | 143.5312 | 143.2188 | 143.2188 | 3500.0 |
| 2000-09-27 13:35:00 | SPY | ETF | 143.3438 | 143.3438 | 143.1562 | 143.25 | 57600.0 |
> showing 50 of 882 rows — these rows as CSV