PREVIEW / etf_5min / 2001-01-05
file: by_date/etf_5min/2001/2001-01-05.parquet size: 25 KB rows: 1,057
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-05 09:30:00 | SPY | ETF | 133.4688 | 133.625 | 132.8438 | 132.8438 | 542600.0 |
| 2001-01-05 09:35:00 | SPY | ETF | 132.8125 | 132.9688 | 132.1562 | 132.1562 | 173200.0 |
| 2001-01-05 09:40:00 | SPY | ETF | 132.3125 | 132.625 | 132.1562 | 132.4062 | 216900.0 |
| 2001-01-05 09:45:00 | SPY | ETF | 132.4688 | 132.5312 | 131.875 | 132.0 | 222100.0 |
| 2001-01-05 09:50:00 | SPY | ETF | 132.0 | 132.0 | 130.8438 | 131.0 | 341200.0 |
| 2001-01-05 09:55:00 | SPY | ETF | 130.8125 | 131.3438 | 130.4375 | 131.25 | 326200.0 |
| 2001-01-05 10:00:00 | SPY | ETF | 131.4375 | 132.375 | 131.2812 | 131.9375 | 698100.0 |
| 2001-01-05 10:05:00 | SPY | ETF | 131.7812 | 132.625 | 131.7812 | 132.4688 | 521000.0 |
| 2001-01-05 10:10:00 | SPY | ETF | 132.5938 | 132.75 | 132.125 | 132.1562 | 288700.0 |
| 2001-01-05 10:15:00 | SPY | ETF | 132.375 | 132.4688 | 131.9375 | 132.0 | 607300.0 |
| 2001-01-05 10:20:00 | SPY | ETF | 132.1875 | 132.7188 | 132.0625 | 132.3125 | 347700.0 |
| 2001-01-05 10:25:00 | SPY | ETF | 132.375 | 132.75 | 132.1875 | 132.5938 | 668900.0 |
| 2001-01-05 10:30:00 | SPY | ETF | 132.5938 | 132.6875 | 132.1875 | 132.5938 | 153600.0 |
| 2001-01-05 10:35:00 | SPY | ETF | 132.5 | 132.6562 | 132.0625 | 132.0938 | 162300.0 |
| 2001-01-05 10:40:00 | SPY | ETF | 131.875 | 132.1562 | 131.75 | 132.0 | 104800.0 |
| 2001-01-05 10:45:00 | SPY | ETF | 131.9688 | 132.375 | 131.7812 | 131.7812 | 182300.0 |
| 2001-01-05 10:50:00 | SPY | ETF | 131.75 | 132.0312 | 131.5 | 131.8438 | 118700.0 |
| 2001-01-05 10:55:00 | SPY | ETF | 131.875 | 132.0312 | 131.625 | 131.625 | 481400.0 |
| 2001-01-05 11:00:00 | SPY | ETF | 131.6562 | 131.6875 | 131.4062 | 131.5625 | 49700.0 |
| 2001-01-05 11:05:00 | SPY | ETF | 131.5 | 131.5938 | 131.0938 | 131.25 | 117300.0 |
| 2001-01-05 11:10:00 | SPY | ETF | 131.125 | 131.4688 | 131.125 | 131.3438 | 86500.0 |
| 2001-01-05 11:15:00 | SPY | ETF | 131.3438 | 131.375 | 131.0 | 131.0 | 80700.0 |
| 2001-01-05 11:20:00 | SPY | ETF | 131.0312 | 131.375 | 130.7812 | 131.1875 | 128900.0 |
| 2001-01-05 11:25:00 | SPY | ETF | 131.125 | 131.4375 | 131.0 | 131.125 | 71500.0 |
| 2001-01-05 11:30:00 | SPY | ETF | 131.125 | 131.1562 | 130.75 | 130.75 | 27600.0 |
| 2001-01-05 11:35:00 | SPY | ETF | 130.75 | 130.8438 | 130.5 | 130.625 | 92600.0 |
| 2001-01-05 11:40:00 | SPY | ETF | 130.625 | 130.9062 | 130.5 | 130.8438 | 178100.0 |
| 2001-01-05 11:45:00 | SPY | ETF | 130.9688 | 131.0312 | 130.375 | 130.375 | 336000.0 |
| 2001-01-05 11:50:00 | SPY | ETF | 130.3125 | 130.7812 | 130.2812 | 130.7812 | 78200.0 |
| 2001-01-05 11:55:00 | SPY | ETF | 130.875 | 131.3125 | 130.875 | 131.125 | 186700.0 |
| 2001-01-05 12:00:00 | SPY | ETF | 131.2812 | 131.3438 | 130.6875 | 130.75 | 264800.0 |
| 2001-01-05 12:05:00 | SPY | ETF | 130.6875 | 130.9688 | 130.6875 | 130.9062 | 18500.0 |
| 2001-01-05 12:10:00 | SPY | ETF | 130.875 | 131.2812 | 130.875 | 131.1875 | 19500.0 |
| 2001-01-05 12:15:00 | SPY | ETF | 131.2812 | 131.5 | 131.1562 | 131.5 | 42800.0 |
| 2001-01-05 12:20:00 | SPY | ETF | 131.375 | 131.4688 | 131.25 | 131.4375 | 163800.0 |
| 2001-01-05 12:25:00 | SPY | ETF | 131.3438 | 131.3438 | 131.0625 | 131.3438 | 70800.0 |
| 2001-01-05 12:30:00 | SPY | ETF | 131.2812 | 131.6562 | 131.2812 | 131.3125 | 28100.0 |
| 2001-01-05 12:35:00 | SPY | ETF | 131.375 | 131.5625 | 131.2812 | 131.4688 | 18600.0 |
| 2001-01-05 12:40:00 | SPY | ETF | 131.4062 | 131.75 | 131.2812 | 131.5938 | 171700.0 |
| 2001-01-05 12:45:00 | SPY | ETF | 131.7188 | 131.7188 | 131.4375 | 131.4688 | 167300.0 |
| 2001-01-05 12:50:00 | SPY | ETF | 131.5 | 131.6875 | 131.3438 | 131.5625 | 19500.0 |
| 2001-01-05 12:55:00 | SPY | ETF | 131.625 | 131.625 | 131.4062 | 131.4375 | 2400.0 |
| 2001-01-05 13:00:00 | SPY | ETF | 131.5312 | 131.5625 | 131.3438 | 131.375 | 33500.0 |
| 2001-01-05 13:05:00 | SPY | ETF | 131.375 | 131.4688 | 131.25 | 131.4062 | 70700.0 |
| 2001-01-05 13:10:00 | SPY | ETF | 131.3438 | 131.4375 | 131.1875 | 131.4375 | 157200.0 |
| 2001-01-05 13:15:00 | SPY | ETF | 131.25 | 131.375 | 131.0938 | 131.25 | 68100.0 |
| 2001-01-05 13:20:00 | SPY | ETF | 131.125 | 131.3125 | 131.0625 | 131.1875 | 16800.0 |
| 2001-01-05 13:25:00 | SPY | ETF | 131.2812 | 131.3125 | 131.1875 | 131.3125 | 25200.0 |
| 2001-01-05 13:30:00 | SPY | ETF | 131.125 | 131.1562 | 131.0 | 131.125 | 48200.0 |
| 2001-01-05 13:35:00 | SPY | ETF | 131.0 | 131.0625 | 130.8438 | 131.0312 | 20500.0 |
> showing 50 of 1,057 rows — these rows as CSV