PREVIEW / etf_1hour / 2000-11-13
file: by_date/etf_1hour/2000/2000-11-13.parquet size: 10 KB rows: 195
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-13 09:00:00 | SPY | ETF | 135.625 | 135.8125 | 134.625 | 135.4375 | 2908000.0 |
| 2000-11-13 10:00:00 | SPY | ETF | 135.375 | 136.1875 | 134.25 | 134.7812 | 3080000.0 |
| 2000-11-13 11:00:00 | SPY | ETF | 134.8125 | 134.9688 | 133.2812 | 133.5312 | 1264200.0 |
| 2000-11-13 12:00:00 | SPY | ETF | 133.4375 | 133.875 | 133.0312 | 133.4375 | 2893000.0 |
| 2000-11-13 13:00:00 | SPY | ETF | 133.375 | 135.3125 | 133.25 | 134.9688 | 2203500.0 |
| 2000-11-13 14:00:00 | SPY | ETF | 135.0625 | 136.4062 | 134.75 | 135.875 | 2119700.0 |
| 2000-11-13 15:00:00 | SPY | ETF | 135.8438 | 136.9688 | 135.25 | 135.375 | 1438900.0 |
| 2000-11-13 16:00:00 | SPY | ETF | 135.4688 | 136.1875 | 135.0312 | 135.5625 | 605000.0 |
| 2000-11-13 09:00:00 | QQQ | ETF | 70.9375 | 71.0 | 69.0625 | 69.9688 | 13011400.0 |
| 2000-11-13 10:00:00 | QQQ | ETF | 69.875 | 71.25 | 69.25 | 69.8125 | 10206500.0 |
| 2000-11-13 11:00:00 | QQQ | ETF | 69.9375 | 70.1875 | 68.875 | 69.2188 | 7965600.0 |
| 2000-11-13 12:00:00 | QQQ | ETF | 69.25 | 69.375 | 68.25 | 68.875 | 8321500.0 |
| 2000-11-13 13:00:00 | QQQ | ETF | 68.75 | 70.75 | 68.625 | 70.625 | 9460800.0 |
| 2000-11-13 14:00:00 | QQQ | ETF | 70.625 | 73.125 | 70.5 | 72.5 | 11810000.0 |
| 2000-11-13 15:00:00 | QQQ | ETF | 72.5 | 74.1875 | 70.6875 | 71.0 | 9877500.0 |
| 2000-11-13 16:00:00 | QQQ | ETF | 70.875 | 71.125 | 69.875 | 70.3438 | 1564500.0 |
| 2000-11-13 17:00:00 | QQQ | ETF | 70.2188 | 70.7188 | 70.0 | 70.0 | 16300.0 |
| 2000-11-13 18:00:00 | QQQ | ETF | 70.3125 | 71.0 | 70.3125 | 71.0 | 8300.0 |
| 2000-11-13 09:00:00 | IWM | ETF | 47.5 | 47.5 | 46.9219 | 47.125 | 14200.0 |
| 2000-11-13 10:00:00 | IWM | ETF | 47.3125 | 47.3125 | 46.7812 | 46.8125 | 44200.0 |
| 2000-11-13 11:00:00 | IWM | ETF | 46.8438 | 46.875 | 46.5781 | 46.5781 | 11600.0 |
| 2000-11-13 12:00:00 | IWM | ETF | 46.5625 | 46.5625 | 46.3125 | 46.4531 | 7800.0 |
| 2000-11-13 13:00:00 | IWM | ETF | 46.4688 | 46.7812 | 46.3438 | 46.75 | 2600.0 |
| 2000-11-13 14:00:00 | IWM | ETF | 46.8438 | 47.6875 | 46.8438 | 47.6875 | 9800.0 |
| 2000-11-13 15:00:00 | IWM | ETF | 47.6875 | 47.8906 | 47.625 | 47.6562 | 26800.0 |
| 2000-11-13 16:00:00 | IWM | ETF | 47.625 | 47.75 | 47.4688 | 47.5156 | 43800.0 |
| 2000-11-13 09:00:00 | DIA | ETF | 105.0 | 105.25 | 104.3438 | 105.0625 | 605200.0 |
| 2000-11-13 10:00:00 | DIA | ETF | 105.0625 | 105.7812 | 104.4062 | 104.625 | 492200.0 |
| 2000-11-13 11:00:00 | DIA | ETF | 104.7812 | 104.9375 | 103.75 | 103.8438 | 248300.0 |
| 2000-11-13 12:00:00 | DIA | ETF | 103.875 | 104.3125 | 103.75 | 103.875 | 116100.0 |
| 2000-11-13 13:00:00 | DIA | ETF | 103.875 | 105.0938 | 103.75 | 104.625 | 144700.0 |
| 2000-11-13 14:00:00 | DIA | ETF | 104.75 | 105.6562 | 104.625 | 105.3438 | 324700.0 |
| 2000-11-13 15:00:00 | DIA | ETF | 105.1562 | 106.2188 | 105.1562 | 105.25 | 755100.0 |
| 2000-11-13 16:00:00 | DIA | ETF | 105.3125 | 105.4375 | 105.0625 | 105.4375 | 24100.0 |
> showing 34 of 195 rows — these rows as CSV