PREVIEW / etf_1hour / 2000-11-16
file: by_date/etf_1hour/2000/2000-11-16.parquet size: 9 KB rows: 172
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-11-16 09:00:00 | SPY | ETF | 138.5625 | 139.375 | 138.4375 | 138.75 | 1146300.0 |
| 2000-11-16 10:00:00 | SPY | ETF | 138.875 | 139.875 | 138.875 | 139.375 | 1129400.0 |
| 2000-11-16 11:00:00 | SPY | ETF | 139.625 | 139.625 | 138.5625 | 139.125 | 888400.0 |
| 2000-11-16 12:00:00 | SPY | ETF | 139.125 | 139.1562 | 138.5625 | 138.9062 | 232600.0 |
| 2000-11-16 13:00:00 | SPY | ETF | 138.9062 | 138.9375 | 138.0 | 138.3125 | 718200.0 |
| 2000-11-16 14:00:00 | SPY | ETF | 138.4375 | 138.8125 | 137.8438 | 137.9375 | 879200.0 |
| 2000-11-16 15:00:00 | SPY | ETF | 138.0938 | 138.375 | 137.3125 | 137.75 | 1044900.0 |
| 2000-11-16 16:00:00 | SPY | ETF | 137.75 | 137.75 | 137.375 | 137.375 | 466500.0 |
| 2000-11-16 09:00:00 | QQQ | ETF | 75.375 | 76.25 | 74.875 | 75.4375 | 6357500.0 |
| 2000-11-16 10:00:00 | QQQ | ETF | 75.375 | 77.0 | 75.2812 | 76.25 | 4916200.0 |
| 2000-11-16 11:00:00 | QQQ | ETF | 76.3125 | 76.5 | 75.375 | 76.0625 | 3892900.0 |
| 2000-11-16 12:00:00 | QQQ | ETF | 76.0625 | 76.2188 | 75.0625 | 75.375 | 2536700.0 |
| 2000-11-16 13:00:00 | QQQ | ETF | 75.3125 | 75.4688 | 74.0625 | 74.75 | 3049600.0 |
| 2000-11-16 14:00:00 | QQQ | ETF | 74.75 | 75.25 | 73.75 | 73.875 | 3498800.0 |
| 2000-11-16 15:00:00 | QQQ | ETF | 73.8438 | 74.375 | 73.0 | 73.0 | 7227500.0 |
| 2000-11-16 16:00:00 | QQQ | ETF | 73.0 | 73.25 | 72.4062 | 73.0 | 922200.0 |
| 2000-11-16 17:00:00 | QQQ | ETF | 73.0 | 73.625 | 72.875 | 73.0625 | 73500.0 |
| 2000-11-16 18:00:00 | QQQ | ETF | 73.0 | 73.0625 | 72.875 | 73.0 | 17900.0 |
| 2000-11-16 09:00:00 | IWM | ETF | 48.8438 | 49.1562 | 48.7812 | 49.0 | 42000.0 |
| 2000-11-16 10:00:00 | IWM | ETF | 48.875 | 49.2344 | 48.875 | 49.2344 | 23600.0 |
| 2000-11-16 11:00:00 | IWM | ETF | 48.9688 | 49.0 | 48.9688 | 49.0 | 800.0 |
| 2000-11-16 12:00:00 | IWM | ETF | 48.9688 | 48.9688 | 48.7188 | 48.9688 | 5000.0 |
| 2000-11-16 13:00:00 | IWM | ETF | 48.8438 | 48.8438 | 48.5312 | 48.5312 | 18600.0 |
| 2000-11-16 14:00:00 | IWM | ETF | 48.7812 | 48.7969 | 48.5625 | 48.5625 | 6400.0 |
| 2000-11-16 15:00:00 | IWM | ETF | 48.6875 | 48.6875 | 48.1562 | 48.1875 | 48400.0 |
| 2000-11-16 16:00:00 | IWM | ETF | 47.9531 | 48.0 | 47.8438 | 47.8438 | 7400.0 |
| 2000-11-16 09:00:00 | DIA | ETF | 106.7812 | 107.4688 | 106.7812 | 107.125 | 107700.0 |
| 2000-11-16 10:00:00 | DIA | ETF | 107.0625 | 107.8438 | 107.0625 | 107.3125 | 74700.0 |
| 2000-11-16 11:00:00 | DIA | ETF | 107.3125 | 107.4688 | 106.7812 | 107.1875 | 81900.0 |
| 2000-11-16 12:00:00 | DIA | ETF | 107.125 | 107.125 | 106.9375 | 107.0 | 58000.0 |
| 2000-11-16 13:00:00 | DIA | ETF | 107.1562 | 107.1562 | 106.5625 | 106.8438 | 65200.0 |
| 2000-11-16 14:00:00 | DIA | ETF | 106.8438 | 107.4375 | 106.5938 | 106.5938 | 201600.0 |
| 2000-11-16 15:00:00 | DIA | ETF | 106.5938 | 106.9688 | 106.4375 | 106.625 | 244600.0 |
| 2000-11-16 16:00:00 | DIA | ETF | 106.875 | 106.875 | 106.4375 | 106.625 | 42800.0 |
> showing 34 of 172 rows — these rows as CSV