PREVIEW / etf_5min / 2000-01-03
file: by_date/etf_5min/2000/2000-01-03.parquet size: 19 KB rows: 836
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-03 09:30:00 | SPY | ETF | 148.25 | 148.25 | 147.6875 | 147.6875 | 385000.0 |
| 2000-01-03 09:35:00 | SPY | ETF | 147.8438 | 148.25 | 147.5 | 147.5 | 99700.0 |
| 2000-01-03 09:40:00 | SPY | ETF | 147.5938 | 147.8125 | 146.9688 | 147.0625 | 69900.0 |
| 2000-01-03 09:45:00 | SPY | ETF | 147.0 | 147.4062 | 147.0 | 147.2188 | 163500.0 |
| 2000-01-03 09:50:00 | SPY | ETF | 147.0625 | 147.1875 | 146.75 | 146.75 | 52100.0 |
| 2000-01-03 09:55:00 | SPY | ETF | 146.7812 | 147.0625 | 146.4688 | 146.625 | 192800.0 |
| 2000-01-03 10:00:00 | SPY | ETF | 146.8125 | 147.2188 | 146.625 | 146.8125 | 342900.0 |
| 2000-01-03 10:05:00 | SPY | ETF | 146.8125 | 147.0938 | 146.6562 | 147.0 | 160000.0 |
| 2000-01-03 10:10:00 | SPY | ETF | 147.1562 | 147.1875 | 146.875 | 147.0625 | 29200.0 |
| 2000-01-03 10:15:00 | SPY | ETF | 147.0 | 147.0312 | 146.75 | 146.75 | 64300.0 |
| 2000-01-03 10:20:00 | SPY | ETF | 146.8125 | 147.25 | 146.625 | 146.625 | 58100.0 |
| 2000-01-03 10:25:00 | SPY | ETF | 146.5625 | 147.0 | 146.5625 | 146.9688 | 18500.0 |
| 2000-01-03 10:30:00 | SPY | ETF | 146.9688 | 146.9688 | 146.2188 | 146.3125 | 30500.0 |
| 2000-01-03 10:35:00 | SPY | ETF | 146.2812 | 146.2812 | 145.8125 | 145.9688 | 71000.0 |
| 2000-01-03 10:40:00 | SPY | ETF | 145.8438 | 145.9688 | 145.3125 | 145.3125 | 201800.0 |
| 2000-01-03 10:45:00 | SPY | ETF | 145.375 | 145.5 | 145.0 | 145.0 | 195000.0 |
| 2000-01-03 10:50:00 | SPY | ETF | 145.0 | 145.0312 | 144.4062 | 144.5938 | 251200.0 |
| 2000-01-03 10:55:00 | SPY | ETF | 144.7188 | 144.9062 | 144.5 | 144.625 | 34600.0 |
| 2000-01-03 11:00:00 | SPY | ETF | 144.6875 | 144.6875 | 144.1875 | 144.375 | 239800.0 |
| 2000-01-03 11:05:00 | SPY | ETF | 144.375 | 144.4688 | 144.1562 | 144.1875 | 168100.0 |
| 2000-01-03 11:10:00 | SPY | ETF | 144.1562 | 144.375 | 144.0 | 144.0 | 222100.0 |
| 2000-01-03 11:15:00 | SPY | ETF | 144.0625 | 144.25 | 143.875 | 144.1562 | 38400.0 |
| 2000-01-03 11:20:00 | SPY | ETF | 144.1875 | 144.3438 | 144.0 | 144.2188 | 83500.0 |
| 2000-01-03 11:25:00 | SPY | ETF | 144.25 | 144.625 | 144.1562 | 144.25 | 120700.0 |
| 2000-01-03 11:30:00 | SPY | ETF | 144.4375 | 144.625 | 144.3438 | 144.5312 | 25300.0 |
| 2000-01-03 11:35:00 | SPY | ETF | 144.4688 | 144.6875 | 144.3438 | 144.5 | 26000.0 |
| 2000-01-03 11:40:00 | SPY | ETF | 144.6562 | 144.7188 | 144.4688 | 144.5625 | 50000.0 |
| 2000-01-03 11:45:00 | SPY | ETF | 144.375 | 144.7188 | 144.375 | 144.7188 | 25000.0 |
| 2000-01-03 11:50:00 | SPY | ETF | 144.5312 | 144.9062 | 144.5312 | 144.8125 | 22300.0 |
| 2000-01-03 11:55:00 | SPY | ETF | 144.6875 | 144.75 | 144.5625 | 144.75 | 7700.0 |
| 2000-01-03 12:00:00 | SPY | ETF | 144.6875 | 144.9375 | 144.5625 | 144.9375 | 21300.0 |
| 2000-01-03 12:05:00 | SPY | ETF | 144.7812 | 144.7812 | 144.25 | 144.375 | 271500.0 |
| 2000-01-03 12:10:00 | SPY | ETF | 144.25 | 144.5312 | 144.1562 | 144.4062 | 82900.0 |
| 2000-01-03 12:15:00 | SPY | ETF | 144.4375 | 144.5312 | 144.1875 | 144.5312 | 55300.0 |
| 2000-01-03 12:20:00 | SPY | ETF | 144.5938 | 144.625 | 144.5 | 144.5 | 5600.0 |
| 2000-01-03 12:25:00 | SPY | ETF | 144.5625 | 144.5625 | 144.4062 | 144.4375 | 18400.0 |
| 2000-01-03 12:30:00 | SPY | ETF | 144.4688 | 144.6875 | 144.4688 | 144.4688 | 17600.0 |
| 2000-01-03 12:35:00 | SPY | ETF | 144.5625 | 144.5625 | 144.2812 | 144.2812 | 25600.0 |
| 2000-01-03 12:40:00 | SPY | ETF | 144.2812 | 144.4062 | 144.25 | 144.3125 | 12300.0 |
| 2000-01-03 12:45:00 | SPY | ETF | 144.4062 | 144.4375 | 144.25 | 144.25 | 18100.0 |
| 2000-01-03 12:50:00 | SPY | ETF | 144.25 | 144.2812 | 144.0625 | 144.1875 | 60700.0 |
| 2000-01-03 12:55:00 | SPY | ETF | 144.25 | 144.5312 | 144.25 | 144.5312 | 50700.0 |
| 2000-01-03 13:00:00 | SPY | ETF | 144.5625 | 144.5625 | 144.2812 | 144.3125 | 19000.0 |
| 2000-01-03 13:05:00 | SPY | ETF | 144.375 | 144.375 | 144.1875 | 144.25 | 45800.0 |
| 2000-01-03 13:10:00 | SPY | ETF | 144.375 | 144.5312 | 144.25 | 144.25 | 8300.0 |
| 2000-01-03 13:15:00 | SPY | ETF | 144.4062 | 144.625 | 144.3125 | 144.5938 | 531000.0 |
| 2000-01-03 13:20:00 | SPY | ETF | 144.625 | 144.8438 | 144.625 | 144.6875 | 27900.0 |
| 2000-01-03 13:25:00 | SPY | ETF | 144.75 | 144.8438 | 144.5 | 144.625 | 290100.0 |
| 2000-01-03 13:30:00 | SPY | ETF | 144.6875 | 144.75 | 144.5312 | 144.75 | 12900.0 |
| 2000-01-03 13:35:00 | SPY | ETF | 144.75 | 144.875 | 144.75 | 144.8125 | 33500.0 |
> showing 50 of 836 rows — these rows as CSV