PREVIEW / etf_1hour / 2000-12-14
file: by_date/etf_1hour/2000/2000-12-14.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-12-14 09:00:00 | SPY | ETF | 135.875 | 136.5 | 135.75 | 136.125 | 742800.0 |
| 2000-12-14 10:00:00 | SPY | ETF | 136.125 | 136.1562 | 134.5625 | 135.25 | 1347300.0 |
| 2000-12-14 11:00:00 | SPY | ETF | 135.5 | 135.875 | 135.0312 | 135.875 | 1201200.0 |
| 2000-12-14 12:00:00 | SPY | ETF | 135.875 | 136.1875 | 135.1562 | 135.5 | 742200.0 |
| 2000-12-14 13:00:00 | SPY | ETF | 135.5 | 135.7188 | 135.125 | 135.2812 | 362100.0 |
| 2000-12-14 14:00:00 | SPY | ETF | 135.125 | 135.375 | 134.75 | 135.3125 | 694800.0 |
| 2000-12-14 15:00:00 | SPY | ETF | 135.4062 | 135.7812 | 134.1875 | 134.1875 | 1994500.0 |
| 2000-12-14 16:00:00 | SPY | ETF | 134.375 | 134.5 | 133.625 | 134.0 | 427500.0 |
| 2000-12-14 17:00:00 | SPY | ETF | 134.0 | 134.0 | 133.625 | 133.625 | 500.0 |
| 2000-12-14 09:00:00 | QQQ | ETF | 68.5 | 69.6875 | 68.0625 | 68.9062 | 4448900.0 |
| 2000-12-14 10:00:00 | QQQ | ETF | 68.875 | 69.0312 | 67.125 | 68.0 | 9053000.0 |
| 2000-12-14 11:00:00 | QQQ | ETF | 67.9375 | 68.625 | 67.7188 | 68.5 | 4292100.0 |
| 2000-12-14 12:00:00 | QQQ | ETF | 68.4375 | 68.9375 | 68.0 | 68.0625 | 2915700.0 |
| 2000-12-14 13:00:00 | QQQ | ETF | 68.0312 | 68.2188 | 67.5 | 67.5625 | 2583000.0 |
| 2000-12-14 14:00:00 | QQQ | ETF | 67.5 | 67.625 | 66.8125 | 67.5 | 4700200.0 |
| 2000-12-14 15:00:00 | QQQ | ETF | 67.5 | 67.875 | 65.625 | 65.875 | 8172900.0 |
| 2000-12-14 16:00:00 | QQQ | ETF | 65.75 | 66.375 | 63.0 | 64.8125 | 2975300.0 |
| 2000-12-14 17:00:00 | QQQ | ETF | 64.6875 | 65.5 | 64.0 | 64.125 | 405400.0 |
| 2000-12-14 18:00:00 | QQQ | ETF | 64.125 | 64.25 | 64.0625 | 64.125 | 89800.0 |
| 2000-12-14 09:00:00 | IWM | ETF | 46.5 | 46.8438 | 46.5 | 46.6562 | 14000.0 |
| 2000-12-14 10:00:00 | IWM | ETF | 46.5625 | 46.5625 | 45.9062 | 46.25 | 63200.0 |
| 2000-12-14 11:00:00 | IWM | ETF | 46.125 | 46.375 | 46.125 | 46.25 | 75800.0 |
| 2000-12-14 12:00:00 | IWM | ETF | 46.25 | 46.25 | 46.125 | 46.125 | 62600.0 |
| 2000-12-14 13:00:00 | IWM | ETF | 46.1406 | 46.1406 | 46.0 | 46.0625 | 16600.0 |
| 2000-12-14 14:00:00 | IWM | ETF | 45.9375 | 45.9688 | 45.875 | 45.9219 | 89600.0 |
| 2000-12-14 15:00:00 | IWM | ETF | 45.875 | 46.1562 | 45.875 | 46.0 | 188800.0 |
| 2000-12-14 16:00:00 | IWM | ETF | 45.875 | 45.875 | 45.875 | 45.875 | 50000.0 |
| 2000-12-14 09:00:00 | DIA | ETF | 107.3125 | 107.6562 | 107.0938 | 107.4375 | 225900.0 |
| 2000-12-14 10:00:00 | DIA | ETF | 107.4375 | 107.4375 | 106.2812 | 106.875 | 167300.0 |
| 2000-12-14 11:00:00 | DIA | ETF | 106.6875 | 107.1562 | 106.6562 | 106.9375 | 116800.0 |
| 2000-12-14 12:00:00 | DIA | ETF | 107.0625 | 107.25 | 106.75 | 107.0 | 142800.0 |
| 2000-12-14 13:00:00 | DIA | ETF | 107.0938 | 107.1875 | 106.75 | 106.75 | 89100.0 |
| 2000-12-14 14:00:00 | DIA | ETF | 106.75 | 107.125 | 106.5938 | 107.125 | 92100.0 |
| 2000-12-14 15:00:00 | DIA | ETF | 107.0312 | 107.4688 | 106.6875 | 106.75 | 291800.0 |
| 2000-12-14 16:00:00 | DIA | ETF | 106.6875 | 106.8438 | 106.5 | 106.5 | 49800.0 |
| 2000-12-14 17:00:00 | DIA | ETF | 106.375 | 106.375 | 106.25 | 106.25 | 1000.0 |
> showing 36 of 195 rows — these rows as CSV