PREVIEW / etf_1hour / 2000-07-24
file: by_date/etf_1hour/2000/2000-07-24.parquet size: 9 KB rows: 159
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-07-24 09:00:00 | SPY | ETF | 148.125 | 148.375 | 147.7812 | 148.3125 | 815400.0 |
| 2000-07-24 10:00:00 | SPY | ETF | 148.4375 | 148.8438 | 148.1875 | 148.5 | 921800.0 |
| 2000-07-24 11:00:00 | SPY | ETF | 148.5625 | 148.6875 | 148.1875 | 148.5 | 477500.0 |
| 2000-07-24 12:00:00 | SPY | ETF | 148.375 | 148.4375 | 147.3125 | 147.6875 | 961300.0 |
| 2000-07-24 13:00:00 | SPY | ETF | 147.6875 | 147.7188 | 146.9375 | 147.0312 | 583600.0 |
| 2000-07-24 14:00:00 | SPY | ETF | 147.1562 | 147.5 | 146.875 | 147.0 | 821900.0 |
| 2000-07-24 15:00:00 | SPY | ETF | 147.0625 | 147.125 | 146.5625 | 146.6562 | 857400.0 |
| 2000-07-24 16:00:00 | SPY | ETF | 146.8438 | 146.9688 | 146.625 | 146.625 | 150800.0 |
| 2000-07-24 09:00:00 | QQQ | ETF | 97.9375 | 98.0 | 97.1875 | 98.0 | 1816200.0 |
| 2000-07-24 10:00:00 | QQQ | ETF | 98.0 | 99.0 | 97.875 | 98.5 | 2167000.0 |
| 2000-07-24 11:00:00 | QQQ | ETF | 98.4375 | 98.5938 | 97.875 | 97.875 | 1591500.0 |
| 2000-07-24 12:00:00 | QQQ | ETF | 97.875 | 97.9688 | 96.3125 | 96.5 | 2370300.0 |
| 2000-07-24 13:00:00 | QQQ | ETF | 96.5 | 96.6875 | 95.125 | 95.375 | 3731100.0 |
| 2000-07-24 14:00:00 | QQQ | ETF | 95.3125 | 96.0625 | 95.125 | 95.1875 | 2458700.0 |
| 2000-07-24 15:00:00 | QQQ | ETF | 95.2812 | 95.4375 | 94.5 | 94.625 | 3938400.0 |
| 2000-07-24 16:00:00 | QQQ | ETF | 94.625 | 95.0 | 94.25 | 94.5 | 459600.0 |
| 2000-07-24 17:00:00 | QQQ | ETF | 94.75 | 95.0 | 94.75 | 95.0 | 2900.0 |
| 2000-07-24 09:00:00 | IWM | ETF | 52.3125 | 52.3125 | 52.1562 | 52.2031 | 1400.0 |
| 2000-07-24 10:00:00 | IWM | ETF | 52.2812 | 52.3125 | 52.2812 | 52.3125 | 400.0 |
| 2000-07-24 11:00:00 | IWM | ETF | 52.1875 | 52.1875 | 52.125 | 52.125 | 800.0 |
| 2000-07-24 12:00:00 | IWM | ETF | 51.875 | 51.875 | 51.8594 | 51.8594 | 2000.0 |
| 2000-07-24 13:00:00 | IWM | ETF | 51.5469 | 51.6562 | 51.4531 | 51.4531 | 4000.0 |
| 2000-07-24 14:00:00 | IWM | ETF | 51.5469 | 51.5781 | 51.5469 | 51.5781 | 1200.0 |
| 2000-07-24 15:00:00 | IWM | ETF | 51.3125 | 51.375 | 51.1562 | 51.1875 | 27000.0 |
| 2000-07-24 16:00:00 | IWM | ETF | 51.2656 | 51.2656 | 51.2656 | 51.2656 | 200.0 |
| 2000-07-24 09:00:00 | DIA | ETF | 107.375 | 107.4375 | 106.875 | 107.3125 | 62900.0 |
| 2000-07-24 10:00:00 | DIA | ETF | 107.3125 | 107.4688 | 107.1875 | 107.375 | 13700.0 |
| 2000-07-24 11:00:00 | DIA | ETF | 107.4062 | 107.75 | 107.1875 | 107.625 | 31700.0 |
| 2000-07-24 12:00:00 | DIA | ETF | 107.5 | 107.6562 | 107.1875 | 107.375 | 27500.0 |
| 2000-07-24 13:00:00 | DIA | ETF | 107.25 | 107.2812 | 106.8438 | 106.8438 | 129100.0 |
| 2000-07-24 14:00:00 | DIA | ETF | 106.8438 | 107.2812 | 106.8438 | 107.0 | 19700.0 |
| 2000-07-24 15:00:00 | DIA | ETF | 106.875 | 107.125 | 106.6875 | 106.75 | 95500.0 |
| 2000-07-24 16:00:00 | DIA | ETF | 106.6875 | 106.9688 | 106.6875 | 106.8125 | 34200.0 |
> showing 33 of 159 rows — these rows as CSV