PREVIEW / etf_5min / 2000-07-12
file: by_date/etf_5min/2000/2000-07-12.parquet size: 19 KB rows: 856
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-07-12 09:30:00 | SPY | ETF | 149.2812 | 149.4688 | 149.25 | 149.2812 | 277500.0 |
| 2000-07-12 09:35:00 | SPY | ETF | 149.2812 | 149.4062 | 149.1562 | 149.4062 | 155900.0 |
| 2000-07-12 09:40:00 | SPY | ETF | 149.375 | 149.4375 | 149.0 | 149.0 | 88800.0 |
| 2000-07-12 09:45:00 | SPY | ETF | 149.0938 | 149.1875 | 148.9688 | 149.0 | 42800.0 |
| 2000-07-12 09:50:00 | SPY | ETF | 149.0 | 149.125 | 148.9062 | 148.9375 | 355600.0 |
| 2000-07-12 09:55:00 | SPY | ETF | 149.1562 | 149.1875 | 148.7812 | 148.875 | 138300.0 |
| 2000-07-12 10:00:00 | SPY | ETF | 148.75 | 149.0312 | 148.75 | 148.9688 | 64500.0 |
| 2000-07-12 10:05:00 | SPY | ETF | 148.8438 | 149.2188 | 148.8438 | 149.2188 | 113500.0 |
| 2000-07-12 10:10:00 | SPY | ETF | 149.1562 | 149.3125 | 149.0938 | 149.3125 | 105000.0 |
| 2000-07-12 10:15:00 | SPY | ETF | 149.375 | 149.5625 | 149.3125 | 149.4375 | 386000.0 |
| 2000-07-12 10:20:00 | SPY | ETF | 149.375 | 149.5 | 149.2812 | 149.4062 | 75800.0 |
| 2000-07-12 10:25:00 | SPY | ETF | 149.4062 | 149.4375 | 149.25 | 149.4062 | 18200.0 |
| 2000-07-12 10:30:00 | SPY | ETF | 149.25 | 149.5 | 149.25 | 149.375 | 17200.0 |
| 2000-07-12 10:35:00 | SPY | ETF | 149.4062 | 149.4062 | 149.0625 | 149.0625 | 76300.0 |
| 2000-07-12 10:40:00 | SPY | ETF | 149.0625 | 149.1562 | 148.6875 | 148.875 | 33300.0 |
| 2000-07-12 10:45:00 | SPY | ETF | 148.8125 | 148.9688 | 148.7812 | 148.875 | 28600.0 |
| 2000-07-12 10:50:00 | SPY | ETF | 148.9688 | 148.9688 | 148.75 | 148.8125 | 59000.0 |
| 2000-07-12 10:55:00 | SPY | ETF | 148.7188 | 149.0 | 148.7188 | 148.9688 | 17000.0 |
| 2000-07-12 11:00:00 | SPY | ETF | 149.0 | 149.0938 | 148.875 | 148.9375 | 216000.0 |
| 2000-07-12 11:05:00 | SPY | ETF | 149.0312 | 149.1562 | 148.9688 | 148.9688 | 22100.0 |
| 2000-07-12 11:10:00 | SPY | ETF | 149.0 | 149.0 | 148.875 | 148.875 | 8300.0 |
| 2000-07-12 11:15:00 | SPY | ETF | 148.9062 | 149.125 | 148.75 | 149.0625 | 6300.0 |
| 2000-07-12 11:20:00 | SPY | ETF | 149.125 | 149.2188 | 149.0312 | 149.2188 | 48100.0 |
| 2000-07-12 11:25:00 | SPY | ETF | 149.25 | 149.3438 | 149.0938 | 149.125 | 188900.0 |
| 2000-07-12 11:30:00 | SPY | ETF | 149.2812 | 149.375 | 149.1875 | 149.3125 | 20400.0 |
| 2000-07-12 11:35:00 | SPY | ETF | 149.25 | 149.2812 | 149.125 | 149.125 | 20100.0 |
| 2000-07-12 11:40:00 | SPY | ETF | 149.0312 | 149.125 | 148.9062 | 149.0938 | 87800.0 |
| 2000-07-12 11:45:00 | SPY | ETF | 149.0 | 149.1875 | 149.0 | 149.125 | 12500.0 |
| 2000-07-12 11:50:00 | SPY | ETF | 149.0 | 149.0938 | 149.0 | 149.0312 | 27300.0 |
| 2000-07-12 11:55:00 | SPY | ETF | 149.0625 | 149.0625 | 149.0 | 149.0312 | 30600.0 |
| 2000-07-12 12:00:00 | SPY | ETF | 149.0625 | 149.0625 | 148.9375 | 149.0 | 17600.0 |
| 2000-07-12 12:05:00 | SPY | ETF | 148.9375 | 149.125 | 148.9375 | 149.125 | 10100.0 |
| 2000-07-12 12:10:00 | SPY | ETF | 149.1875 | 149.2188 | 149.0625 | 149.2188 | 31700.0 |
| 2000-07-12 12:15:00 | SPY | ETF | 149.0625 | 149.1875 | 148.9062 | 148.9062 | 32400.0 |
| 2000-07-12 12:20:00 | SPY | ETF | 148.9375 | 149.0 | 148.75 | 149.0 | 12800.0 |
| 2000-07-12 12:25:00 | SPY | ETF | 148.9375 | 149.0 | 148.9375 | 148.9688 | 2400.0 |
| 2000-07-12 12:30:00 | SPY | ETF | 148.9062 | 149.0 | 148.9062 | 149.0 | 3100.0 |
| 2000-07-12 12:35:00 | SPY | ETF | 148.9375 | 149.0 | 148.8438 | 148.875 | 133300.0 |
| 2000-07-12 12:40:00 | SPY | ETF | 148.875 | 148.875 | 148.875 | 148.875 | 2800.0 |
| 2000-07-12 12:45:00 | SPY | ETF | 148.9375 | 149.0938 | 148.9375 | 149.0938 | 75300.0 |
| 2000-07-12 12:50:00 | SPY | ETF | 149.0312 | 149.125 | 149.0 | 149.0625 | 170700.0 |
| 2000-07-12 12:55:00 | SPY | ETF | 149.0625 | 149.2188 | 149.0625 | 149.125 | 56500.0 |
| 2000-07-12 13:00:00 | SPY | ETF | 149.1875 | 149.1875 | 149.0938 | 149.1875 | 35000.0 |
| 2000-07-12 13:05:00 | SPY | ETF | 149.125 | 149.2188 | 149.125 | 149.1562 | 30500.0 |
| 2000-07-12 13:10:00 | SPY | ETF | 149.125 | 149.3125 | 149.125 | 149.3125 | 146100.0 |
| 2000-07-12 13:15:00 | SPY | ETF | 149.3125 | 149.375 | 149.25 | 149.25 | 10200.0 |
| 2000-07-12 13:20:00 | SPY | ETF | 149.3438 | 149.375 | 149.25 | 149.3438 | 27000.0 |
| 2000-07-12 13:25:00 | SPY | ETF | 149.375 | 149.375 | 149.1875 | 149.25 | 4000.0 |
| 2000-07-12 13:30:00 | SPY | ETF | 149.1875 | 149.2188 | 149.0312 | 149.2188 | 20500.0 |
| 2000-07-12 13:35:00 | SPY | ETF | 149.25 | 149.25 | 149.1875 | 149.1875 | 600.0 |
> showing 50 of 856 rows — these rows as CSV