PREVIEW / etf_1hour / 2000-07-10
file: by_date/etf_1hour/2000/2000-07-10.parquet size: 9 KB rows: 166
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-10 09:00:00 | SPY | ETF | 147.875 | 148.2812 | 147.6875 | 147.9688 | 223100.0 |
| 2000-07-10 10:00:00 | SPY | ETF | 148.0 | 148.4688 | 147.7188 | 148.0312 | 393200.0 |
| 2000-07-10 11:00:00 | SPY | ETF | 148.0312 | 148.4062 | 147.625 | 148.1875 | 385100.0 |
| 2000-07-10 12:00:00 | SPY | ETF | 148.25 | 148.5312 | 148.0938 | 148.4688 | 167800.0 |
| 2000-07-10 13:00:00 | SPY | ETF | 148.5 | 148.9062 | 148.4688 | 148.6875 | 329700.0 |
| 2000-07-10 14:00:00 | SPY | ETF | 148.7188 | 148.875 | 148.2188 | 148.5 | 296900.0 |
| 2000-07-10 15:00:00 | SPY | ETF | 148.5 | 148.625 | 147.7188 | 147.9688 | 574600.0 |
| 2000-07-10 16:00:00 | SPY | ETF | 147.875 | 147.875 | 147.4688 | 147.8438 | 347500.0 |
| 2000-07-10 09:00:00 | QQQ | ETF | 94.6875 | 95.6875 | 94.625 | 94.8125 | 2138400.0 |
| 2000-07-10 10:00:00 | QQQ | ETF | 94.7812 | 95.5 | 94.6875 | 95.25 | 1845800.0 |
| 2000-07-10 11:00:00 | QQQ | ETF | 95.125 | 95.4375 | 94.5 | 95.25 | 1798400.0 |
| 2000-07-10 12:00:00 | QQQ | ETF | 95.25 | 95.4688 | 95.0312 | 95.375 | 700100.0 |
| 2000-07-10 13:00:00 | QQQ | ETF | 95.375 | 95.875 | 95.25 | 95.625 | 1244200.0 |
| 2000-07-10 14:00:00 | QQQ | ETF | 95.6875 | 95.75 | 94.7188 | 94.9375 | 1398600.0 |
| 2000-07-10 15:00:00 | QQQ | ETF | 95.0 | 95.3438 | 94.0 | 94.1875 | 2678700.0 |
| 2000-07-10 16:00:00 | QQQ | ETF | 94.0938 | 94.5 | 94.0938 | 94.1562 | 421200.0 |
| 2000-07-10 17:00:00 | QQQ | ETF | 94.5 | 94.5 | 94.25 | 94.25 | 1800.0 |
| 2000-07-10 18:00:00 | QQQ | ETF | 94.4688 | 94.4688 | 94.4688 | 94.4688 | 500.0 |
| 2000-07-10 09:00:00 | IWM | ETF | 52.7188 | 52.8594 | 52.7188 | 52.8594 | 3000.0 |
| 2000-07-10 10:00:00 | IWM | ETF | 52.9531 | 52.9531 | 52.9531 | 52.9531 | 400.0 |
| 2000-07-10 11:00:00 | IWM | ETF | 52.9531 | 52.9844 | 52.8438 | 52.9844 | 15800.0 |
| 2000-07-10 12:00:00 | IWM | ETF | 53.0469 | 53.125 | 53.0469 | 53.1094 | 2600.0 |
| 2000-07-10 13:00:00 | IWM | ETF | 53.1562 | 53.2812 | 53.1562 | 53.1562 | 2800.0 |
| 2000-07-10 14:00:00 | IWM | ETF | 53.2188 | 53.2188 | 53.0312 | 53.0312 | 1400.0 |
| 2000-07-10 15:00:00 | IWM | ETF | 53.1562 | 53.1562 | 52.9062 | 53.0781 | 8400.0 |
| 2000-07-10 16:00:00 | IWM | ETF | 53.0938 | 53.0938 | 53.0938 | 53.0938 | 10400.0 |
| 2000-07-10 09:00:00 | DIA | ETF | 106.0625 | 106.75 | 106.0625 | 106.5 | 48100.0 |
| 2000-07-10 10:00:00 | DIA | ETF | 106.6875 | 106.8438 | 106.375 | 106.5625 | 29400.0 |
| 2000-07-10 11:00:00 | DIA | ETF | 106.5 | 106.8438 | 106.25 | 106.7188 | 159800.0 |
| 2000-07-10 12:00:00 | DIA | ETF | 106.625 | 106.9062 | 106.625 | 106.9062 | 21100.0 |
| 2000-07-10 13:00:00 | DIA | ETF | 106.9375 | 107.2188 | 106.75 | 107.0625 | 33800.0 |
| 2000-07-10 14:00:00 | DIA | ETF | 107.0938 | 107.125 | 106.75 | 107.0 | 16200.0 |
| 2000-07-10 15:00:00 | DIA | ETF | 107.0 | 107.125 | 106.5 | 106.5312 | 74900.0 |
| 2000-07-10 16:00:00 | DIA | ETF | 106.5312 | 106.5625 | 106.5 | 106.5 | 4200.0 |
> showing 34 of 166 rows — these rows as CSV