PREVIEW / etf_5min / 2000-12-20
file: by_date/etf_5min/2000/2000-12-20.parquet size: 26 KB rows: 1,143
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-12-20 09:30:00 | SPY | ETF | 128.625 | 128.625 | 127.9375 | 128.0 | 759400.0 |
| 2000-12-20 09:35:00 | SPY | ETF | 127.875 | 128.625 | 127.125 | 127.25 | 236100.0 |
| 2000-12-20 09:40:00 | SPY | ETF | 127.3125 | 128.4062 | 127.2188 | 128.25 | 372300.0 |
| 2000-12-20 09:45:00 | SPY | ETF | 128.125 | 128.375 | 127.5312 | 127.75 | 420200.0 |
| 2000-12-20 09:50:00 | SPY | ETF | 127.7812 | 128.7188 | 127.7188 | 128.4062 | 229100.0 |
| 2000-12-20 09:55:00 | SPY | ETF | 128.2188 | 128.4688 | 128.0 | 128.0 | 117300.0 |
| 2000-12-20 10:00:00 | SPY | ETF | 128.0312 | 128.0938 | 127.6875 | 128.0 | 345700.0 |
| 2000-12-20 10:05:00 | SPY | ETF | 128.2188 | 128.25 | 127.8438 | 128.0 | 171700.0 |
| 2000-12-20 10:10:00 | SPY | ETF | 128.0938 | 128.5938 | 128.0 | 128.5312 | 283500.0 |
| 2000-12-20 10:15:00 | SPY | ETF | 128.5938 | 128.75 | 128.2812 | 128.75 | 75900.0 |
| 2000-12-20 10:20:00 | SPY | ETF | 128.75 | 128.75 | 128.0938 | 128.4375 | 84400.0 |
| 2000-12-20 10:25:00 | SPY | ETF | 128.5312 | 128.6875 | 128.0312 | 128.0312 | 73600.0 |
| 2000-12-20 10:30:00 | SPY | ETF | 128.0312 | 128.2812 | 127.75 | 127.9062 | 167600.0 |
| 2000-12-20 10:35:00 | SPY | ETF | 127.75 | 128.1875 | 127.5625 | 128.0 | 165400.0 |
| 2000-12-20 10:40:00 | SPY | ETF | 128.0 | 128.1562 | 127.75 | 128.0312 | 117100.0 |
| 2000-12-20 10:45:00 | SPY | ETF | 128.0938 | 128.1562 | 127.75 | 127.875 | 133500.0 |
| 2000-12-20 10:50:00 | SPY | ETF | 127.875 | 128.0625 | 127.7188 | 128.0312 | 75300.0 |
| 2000-12-20 10:55:00 | SPY | ETF | 128.125 | 128.5625 | 128.0938 | 128.5625 | 77600.0 |
| 2000-12-20 11:00:00 | SPY | ETF | 128.625 | 128.6562 | 128.3438 | 128.625 | 54000.0 |
| 2000-12-20 11:05:00 | SPY | ETF | 128.5938 | 128.9375 | 128.5 | 128.6562 | 83700.0 |
| 2000-12-20 11:10:00 | SPY | ETF | 128.5938 | 128.6875 | 128.0625 | 128.1875 | 150000.0 |
| 2000-12-20 11:15:00 | SPY | ETF | 128.3438 | 128.3438 | 128.0312 | 128.1562 | 120300.0 |
| 2000-12-20 11:20:00 | SPY | ETF | 128.0 | 128.25 | 127.8438 | 128.0938 | 42800.0 |
| 2000-12-20 11:25:00 | SPY | ETF | 128.2188 | 128.3125 | 128.0625 | 128.2188 | 60100.0 |
| 2000-12-20 11:30:00 | SPY | ETF | 128.3125 | 128.375 | 127.875 | 128.0312 | 55400.0 |
| 2000-12-20 11:35:00 | SPY | ETF | 127.9375 | 128.2812 | 127.9375 | 128.0625 | 45700.0 |
| 2000-12-20 11:40:00 | SPY | ETF | 128.0312 | 128.4375 | 127.9688 | 128.1562 | 35000.0 |
| 2000-12-20 11:45:00 | SPY | ETF | 128.4375 | 128.7188 | 128.3438 | 128.6562 | 71700.0 |
| 2000-12-20 11:50:00 | SPY | ETF | 128.6562 | 128.6562 | 128.4062 | 128.5 | 146500.0 |
| 2000-12-20 11:55:00 | SPY | ETF | 128.4375 | 128.625 | 128.3125 | 128.625 | 39200.0 |
| 2000-12-20 12:00:00 | SPY | ETF | 128.6562 | 128.75 | 128.4688 | 128.5 | 28000.0 |
| 2000-12-20 12:05:00 | SPY | ETF | 128.6562 | 128.6562 | 128.1875 | 128.1875 | 32300.0 |
| 2000-12-20 12:10:00 | SPY | ETF | 128.1875 | 128.4062 | 128.0625 | 128.2188 | 5000.0 |
| 2000-12-20 12:15:00 | SPY | ETF | 128.25 | 128.4688 | 128.0625 | 128.4688 | 46300.0 |
| 2000-12-20 12:20:00 | SPY | ETF | 128.2188 | 128.3438 | 127.9375 | 128.125 | 150700.0 |
| 2000-12-20 12:25:00 | SPY | ETF | 128.1562 | 128.2188 | 127.875 | 128.125 | 43000.0 |
| 2000-12-20 12:30:00 | SPY | ETF | 128.0625 | 128.3125 | 128.0625 | 128.0625 | 51800.0 |
| 2000-12-20 12:35:00 | SPY | ETF | 127.9375 | 128.0312 | 127.8125 | 127.9375 | 144000.0 |
| 2000-12-20 12:40:00 | SPY | ETF | 128.0 | 128.0625 | 127.75 | 127.9375 | 84000.0 |
| 2000-12-20 12:45:00 | SPY | ETF | 127.8125 | 127.9688 | 127.75 | 127.9375 | 44400.0 |
| 2000-12-20 12:50:00 | SPY | ETF | 127.875 | 128.0 | 127.5 | 127.5 | 112700.0 |
| 2000-12-20 12:55:00 | SPY | ETF | 127.5 | 127.9062 | 127.4375 | 127.75 | 131200.0 |
| 2000-12-20 13:00:00 | SPY | ETF | 127.625 | 127.7812 | 127.375 | 127.5 | 22400.0 |
| 2000-12-20 13:05:00 | SPY | ETF | 127.5 | 127.7188 | 127.1875 | 127.4688 | 65400.0 |
| 2000-12-20 13:10:00 | SPY | ETF | 127.4688 | 127.75 | 127.3125 | 127.75 | 79900.0 |
| 2000-12-20 13:15:00 | SPY | ETF | 127.8438 | 127.8438 | 127.375 | 127.4375 | 24700.0 |
| 2000-12-20 13:20:00 | SPY | ETF | 127.5 | 127.625 | 127.375 | 127.625 | 16800.0 |
| 2000-12-20 13:25:00 | SPY | ETF | 127.5312 | 127.75 | 127.5 | 127.5 | 22400.0 |
| 2000-12-20 13:30:00 | SPY | ETF | 127.4688 | 127.7188 | 127.3125 | 127.3125 | 69200.0 |
| 2000-12-20 13:35:00 | SPY | ETF | 127.1875 | 127.4062 | 127.0938 | 127.2812 | 121600.0 |
> showing 50 of 1,143 rows — these rows as CSV