PREVIEW / etf_5min / 2000-03-07
file: by_date/etf_5min/2000/2000-03-07.parquet size: 21 KB rows: 894
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-03-07 09:30:00 | SPY | ETF | 140.0 | 140.1562 | 139.875 | 139.875 | 826800.0 |
| 2000-03-07 09:35:00 | SPY | ETF | 139.75 | 140.0 | 139.6875 | 139.6875 | 50300.0 |
| 2000-03-07 09:40:00 | SPY | ETF | 139.6875 | 139.9688 | 139.5 | 139.5938 | 95500.0 |
| 2000-03-07 09:45:00 | SPY | ETF | 139.5938 | 139.75 | 139.0 | 139.2188 | 108200.0 |
| 2000-03-07 09:50:00 | SPY | ETF | 139.125 | 139.75 | 139.0 | 139.3125 | 99100.0 |
| 2000-03-07 09:55:00 | SPY | ETF | 140.0 | 140.0 | 138.6562 | 138.75 | 555200.0 |
| 2000-03-07 10:00:00 | SPY | ETF | 138.625 | 138.875 | 138.375 | 138.875 | 180600.0 |
| 2000-03-07 10:05:00 | SPY | ETF | 138.8125 | 138.8438 | 138.4688 | 138.75 | 83100.0 |
| 2000-03-07 10:10:00 | SPY | ETF | 138.7812 | 138.7812 | 138.0 | 138.4375 | 111200.0 |
| 2000-03-07 10:15:00 | SPY | ETF | 138.0 | 138.0 | 136.875 | 137.25 | 740200.0 |
| 2000-03-07 10:20:00 | SPY | ETF | 137.3125 | 137.6875 | 137.0 | 137.6875 | 391600.0 |
| 2000-03-07 10:25:00 | SPY | ETF | 137.6562 | 138.0625 | 137.5312 | 137.8438 | 491100.0 |
| 2000-03-07 10:30:00 | SPY | ETF | 137.9688 | 138.25 | 137.9062 | 138.1562 | 158000.0 |
| 2000-03-07 10:35:00 | SPY | ETF | 138.3125 | 138.375 | 138.0312 | 138.2812 | 427800.0 |
| 2000-03-07 10:40:00 | SPY | ETF | 138.25 | 138.5625 | 138.0 | 138.4688 | 109600.0 |
| 2000-03-07 10:45:00 | SPY | ETF | 138.25 | 138.5 | 138.125 | 138.4062 | 38600.0 |
| 2000-03-07 10:50:00 | SPY | ETF | 138.1875 | 138.375 | 137.9375 | 137.9375 | 17300.0 |
| 2000-03-07 10:55:00 | SPY | ETF | 138.0 | 138.2188 | 137.8125 | 137.875 | 41500.0 |
| 2000-03-07 11:00:00 | SPY | ETF | 137.7812 | 138.3438 | 137.7812 | 138.1875 | 708000.0 |
| 2000-03-07 11:05:00 | SPY | ETF | 138.3438 | 138.625 | 138.2812 | 138.625 | 720100.0 |
| 2000-03-07 11:10:00 | SPY | ETF | 138.5 | 138.8125 | 138.5 | 138.8125 | 438000.0 |
| 2000-03-07 11:15:00 | SPY | ETF | 138.6875 | 138.7812 | 138.4062 | 138.4062 | 25500.0 |
| 2000-03-07 11:20:00 | SPY | ETF | 138.4062 | 138.5625 | 138.3438 | 138.4688 | 23300.0 |
| 2000-03-07 11:25:00 | SPY | ETF | 138.3438 | 138.5625 | 138.3438 | 138.5 | 9600.0 |
| 2000-03-07 11:30:00 | SPY | ETF | 138.625 | 138.9375 | 138.5625 | 138.9375 | 758100.0 |
| 2000-03-07 11:35:00 | SPY | ETF | 138.9375 | 139.0938 | 138.9062 | 139.0 | 24600.0 |
| 2000-03-07 11:40:00 | SPY | ETF | 138.875 | 139.1562 | 138.8125 | 139.0312 | 235800.0 |
| 2000-03-07 11:45:00 | SPY | ETF | 138.875 | 138.875 | 138.625 | 138.7812 | 40300.0 |
| 2000-03-07 11:50:00 | SPY | ETF | 138.7812 | 138.7812 | 138.5 | 138.5 | 134600.0 |
| 2000-03-07 11:55:00 | SPY | ETF | 138.7188 | 138.8438 | 138.625 | 138.75 | 43400.0 |
| 2000-03-07 12:00:00 | SPY | ETF | 138.75 | 139.0 | 138.625 | 138.8438 | 13700.0 |
| 2000-03-07 12:05:00 | SPY | ETF | 138.5938 | 138.8438 | 138.5312 | 138.5312 | 308800.0 |
| 2000-03-07 12:10:00 | SPY | ETF | 138.75 | 138.75 | 138.375 | 138.375 | 38000.0 |
| 2000-03-07 12:15:00 | SPY | ETF | 138.3125 | 138.4375 | 138.0312 | 138.0625 | 159200.0 |
| 2000-03-07 12:20:00 | SPY | ETF | 138.0 | 138.2188 | 137.9375 | 138.0 | 235800.0 |
| 2000-03-07 12:25:00 | SPY | ETF | 137.9688 | 138.1875 | 137.875 | 138.0625 | 2145200.0 |
| 2000-03-07 12:30:00 | SPY | ETF | 138.1875 | 138.25 | 137.7812 | 137.8438 | 101200.0 |
| 2000-03-07 12:35:00 | SPY | ETF | 137.8438 | 138.1875 | 137.8438 | 138.1875 | 44900.0 |
| 2000-03-07 12:40:00 | SPY | ETF | 137.9688 | 138.3125 | 137.9688 | 138.125 | 4400.0 |
| 2000-03-07 12:45:00 | SPY | ETF | 138.1562 | 138.4062 | 138.0312 | 138.4062 | 18800.0 |
| 2000-03-07 12:50:00 | SPY | ETF | 138.4062 | 138.4062 | 138.0312 | 138.0312 | 8200.0 |
| 2000-03-07 12:55:00 | SPY | ETF | 138.0625 | 138.1875 | 138.0 | 138.0 | 5100.0 |
| 2000-03-07 13:00:00 | SPY | ETF | 137.9062 | 137.9062 | 137.625 | 137.75 | 522500.0 |
| 2000-03-07 13:05:00 | SPY | ETF | 137.75 | 137.9375 | 137.625 | 137.875 | 120200.0 |
| 2000-03-07 13:10:00 | SPY | ETF | 137.9375 | 138.0 | 137.75 | 138.0 | 15900.0 |
| 2000-03-07 13:15:00 | SPY | ETF | 137.8125 | 138.125 | 137.8125 | 138.125 | 16600.0 |
| 2000-03-07 13:20:00 | SPY | ETF | 137.7812 | 137.9375 | 137.5 | 137.5 | 9000.0 |
| 2000-03-07 13:25:00 | SPY | ETF | 137.5 | 137.6875 | 137.4375 | 137.4375 | 245200.0 |
| 2000-03-07 13:30:00 | SPY | ETF | 137.375 | 137.375 | 137.125 | 137.125 | 22900.0 |
| 2000-03-07 13:35:00 | SPY | ETF | 137.0625 | 137.5625 | 137.0625 | 137.5625 | 182600.0 |
> showing 50 of 894 rows — these rows as CSV