PREVIEW / etf_5min / 2001-01-09
file: by_date/etf_5min/2001/2001-01-09.parquet size: 22 KB rows: 1,002
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-09 09:30:00 | SPY | ETF | 131.0312 | 131.25 | 130.5625 | 130.9375 | 262500.0 |
| 2001-01-09 09:35:00 | SPY | ETF | 130.875 | 131.0 | 130.625 | 130.75 | 301500.0 |
| 2001-01-09 09:40:00 | SPY | ETF | 130.7188 | 130.75 | 130.25 | 130.4375 | 192200.0 |
| 2001-01-09 09:45:00 | SPY | ETF | 130.3125 | 130.6875 | 130.2812 | 130.6875 | 100900.0 |
| 2001-01-09 09:50:00 | SPY | ETF | 130.5938 | 130.9375 | 130.4688 | 130.8438 | 168900.0 |
| 2001-01-09 09:55:00 | SPY | ETF | 130.7812 | 130.9688 | 130.3438 | 130.3438 | 48400.0 |
| 2001-01-09 10:00:00 | SPY | ETF | 130.375 | 130.625 | 130.25 | 130.5625 | 31000.0 |
| 2001-01-09 10:05:00 | SPY | ETF | 130.625 | 131.0 | 130.5 | 130.875 | 29900.0 |
| 2001-01-09 10:10:00 | SPY | ETF | 130.9375 | 131.3125 | 130.9375 | 131.1875 | 67300.0 |
| 2001-01-09 10:15:00 | SPY | ETF | 131.3438 | 131.375 | 131.0938 | 131.125 | 60900.0 |
| 2001-01-09 10:20:00 | SPY | ETF | 131.125 | 131.1875 | 131.0 | 131.125 | 28900.0 |
| 2001-01-09 10:25:00 | SPY | ETF | 131.0625 | 131.4688 | 131.0625 | 131.4688 | 56600.0 |
| 2001-01-09 10:30:00 | SPY | ETF | 131.5 | 131.5 | 131.25 | 131.375 | 50200.0 |
| 2001-01-09 10:35:00 | SPY | ETF | 131.4375 | 131.5 | 131.0625 | 131.125 | 241800.0 |
| 2001-01-09 10:40:00 | SPY | ETF | 131.0938 | 131.2812 | 130.9688 | 131.0938 | 14100.0 |
| 2001-01-09 10:45:00 | SPY | ETF | 131.0 | 131.25 | 131.0 | 131.1562 | 31000.0 |
| 2001-01-09 10:50:00 | SPY | ETF | 131.125 | 131.1875 | 130.9375 | 131.0 | 44300.0 |
| 2001-01-09 10:55:00 | SPY | ETF | 131.0 | 131.0 | 130.6875 | 130.875 | 196000.0 |
| 2001-01-09 11:00:00 | SPY | ETF | 130.875 | 130.9688 | 130.6562 | 130.7812 | 21700.0 |
| 2001-01-09 11:05:00 | SPY | ETF | 130.6875 | 130.875 | 130.6875 | 130.8438 | 48300.0 |
| 2001-01-09 11:10:00 | SPY | ETF | 130.875 | 130.875 | 130.625 | 130.625 | 19400.0 |
| 2001-01-09 11:15:00 | SPY | ETF | 130.5312 | 130.6562 | 130.2188 | 130.2188 | 63500.0 |
| 2001-01-09 11:20:00 | SPY | ETF | 130.25 | 130.5312 | 130.1875 | 130.375 | 31500.0 |
| 2001-01-09 11:25:00 | SPY | ETF | 130.375 | 130.375 | 130.125 | 130.2188 | 31700.0 |
| 2001-01-09 11:30:00 | SPY | ETF | 130.3438 | 130.5312 | 130.2188 | 130.4375 | 44400.0 |
| 2001-01-09 11:35:00 | SPY | ETF | 130.5938 | 130.625 | 130.4375 | 130.5312 | 13000.0 |
| 2001-01-09 11:40:00 | SPY | ETF | 130.5 | 130.625 | 130.375 | 130.5938 | 13000.0 |
| 2001-01-09 11:45:00 | SPY | ETF | 130.5938 | 130.6562 | 130.4375 | 130.4375 | 69900.0 |
| 2001-01-09 11:50:00 | SPY | ETF | 130.5938 | 130.5938 | 130.5 | 130.5 | 27200.0 |
| 2001-01-09 11:55:00 | SPY | ETF | 130.5312 | 130.625 | 130.4062 | 130.5 | 45000.0 |
| 2001-01-09 12:00:00 | SPY | ETF | 130.5 | 130.5 | 130.3125 | 130.5 | 21400.0 |
| 2001-01-09 12:05:00 | SPY | ETF | 130.4688 | 130.4688 | 130.2188 | 130.25 | 14000.0 |
| 2001-01-09 12:10:00 | SPY | ETF | 130.2188 | 130.3438 | 130.1875 | 130.25 | 19100.0 |
| 2001-01-09 12:15:00 | SPY | ETF | 130.1875 | 130.4688 | 130.1875 | 130.3125 | 11500.0 |
| 2001-01-09 12:20:00 | SPY | ETF | 130.4062 | 130.4062 | 130.0938 | 130.0938 | 19300.0 |
| 2001-01-09 12:25:00 | SPY | ETF | 130.2188 | 130.4375 | 130.0938 | 130.4375 | 39400.0 |
| 2001-01-09 12:30:00 | SPY | ETF | 130.2812 | 130.4375 | 130.125 | 130.125 | 29100.0 |
| 2001-01-09 12:35:00 | SPY | ETF | 130.1562 | 130.2188 | 129.8125 | 129.8125 | 111700.0 |
| 2001-01-09 12:40:00 | SPY | ETF | 129.7812 | 130.0312 | 129.6875 | 130.0312 | 158800.0 |
| 2001-01-09 12:45:00 | SPY | ETF | 129.9375 | 130.1875 | 129.9375 | 130.1875 | 57600.0 |
| 2001-01-09 12:50:00 | SPY | ETF | 130.1875 | 130.2188 | 130.0938 | 130.2188 | 58100.0 |
| 2001-01-09 12:55:00 | SPY | ETF | 130.2188 | 130.2188 | 130.0625 | 130.1875 | 22300.0 |
| 2001-01-09 13:00:00 | SPY | ETF | 130.0312 | 130.2188 | 129.8125 | 129.9375 | 39400.0 |
| 2001-01-09 13:05:00 | SPY | ETF | 130.0 | 130.2188 | 129.7812 | 130.2188 | 28500.0 |
| 2001-01-09 13:10:00 | SPY | ETF | 130.1875 | 130.375 | 130.0938 | 130.125 | 57000.0 |
| 2001-01-09 13:15:00 | SPY | ETF | 130.1875 | 130.4062 | 130.1562 | 130.375 | 65000.0 |
| 2001-01-09 13:20:00 | SPY | ETF | 130.375 | 130.4062 | 130.2188 | 130.2812 | 21800.0 |
| 2001-01-09 13:25:00 | SPY | ETF | 130.3438 | 130.4062 | 130.2188 | 130.25 | 49300.0 |
| 2001-01-09 13:30:00 | SPY | ETF | 130.375 | 130.5938 | 130.25 | 130.5625 | 23800.0 |
| 2001-01-09 13:35:00 | SPY | ETF | 130.4688 | 130.5312 | 130.3125 | 130.4062 | 138700.0 |
> showing 50 of 1,002 rows — these rows as CSV