PREVIEW / etf_1hour / 2000-07-05
file: by_date/etf_1hour/2000/2000-07-05.parquet size: 9 KB rows: 165
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-05 09:00:00 | SPY | ETF | 146.375 | 146.625 | 145.9375 | 146.3125 | 418400.0 |
| 2000-07-05 10:00:00 | SPY | ETF | 146.25 | 146.6562 | 145.8125 | 146.125 | 445900.0 |
| 2000-07-05 11:00:00 | SPY | ETF | 146.125 | 146.5 | 145.7188 | 146.5 | 298800.0 |
| 2000-07-05 12:00:00 | SPY | ETF | 146.375 | 146.5 | 146.0312 | 146.0938 | 199800.0 |
| 2000-07-05 13:00:00 | SPY | ETF | 146.2188 | 146.2812 | 145.75 | 146.2812 | 189900.0 |
| 2000-07-05 14:00:00 | SPY | ETF | 146.25 | 146.25 | 145.2812 | 145.5938 | 250700.0 |
| 2000-07-05 15:00:00 | SPY | ETF | 145.375 | 145.375 | 144.375 | 145.0938 | 638200.0 |
| 2000-07-05 16:00:00 | SPY | ETF | 145.0 | 145.0312 | 144.375 | 144.625 | 303600.0 |
| 2000-07-05 17:00:00 | SPY | ETF | 144.625 | 144.625 | 144.625 | 144.625 | 400.0 |
| 2000-07-05 09:00:00 | QQQ | ETF | 93.625 | 93.75 | 92.875 | 93.4375 | 3172400.0 |
| 2000-07-05 10:00:00 | QQQ | ETF | 93.5 | 93.9688 | 92.5625 | 93.0 | 3520600.0 |
| 2000-07-05 11:00:00 | QQQ | ETF | 93.0 | 93.3438 | 92.5 | 93.3438 | 1350400.0 |
| 2000-07-05 12:00:00 | QQQ | ETF | 93.3125 | 93.3438 | 92.75 | 92.875 | 767600.0 |
| 2000-07-05 13:00:00 | QQQ | ETF | 92.9688 | 93.0 | 92.4375 | 92.9375 | 1089700.0 |
| 2000-07-05 14:00:00 | QQQ | ETF | 92.9062 | 92.9375 | 91.75 | 91.9375 | 1833900.0 |
| 2000-07-05 15:00:00 | QQQ | ETF | 92.0 | 92.0 | 90.875 | 91.25 | 3850500.0 |
| 2000-07-05 16:00:00 | QQQ | ETF | 91.25 | 91.5625 | 91.125 | 91.375 | 747800.0 |
| 2000-07-05 17:00:00 | QQQ | ETF | 91.375 | 91.375 | 91.25 | 91.375 | 400.0 |
| 2000-07-05 18:00:00 | QQQ | ETF | 91.75 | 91.75 | 91.5625 | 91.5625 | 200.0 |
| 2000-07-05 09:00:00 | IWM | ETF | 52.1094 | 52.1094 | 51.875 | 52.0 | 31400.0 |
| 2000-07-05 10:00:00 | IWM | ETF | 52.125 | 52.125 | 51.8906 | 52.0156 | 7400.0 |
| 2000-07-05 11:00:00 | IWM | ETF | 51.7344 | 51.9219 | 51.7344 | 51.9219 | 22400.0 |
| 2000-07-05 12:00:00 | IWM | ETF | 52.0312 | 52.1094 | 52.0 | 52.0 | 3000.0 |
| 2000-07-05 13:00:00 | IWM | ETF | 52.0 | 52.0 | 52.0 | 52.0 | 59600.0 |
| 2000-07-05 14:00:00 | IWM | ETF | 51.9062 | 51.9062 | 51.75 | 51.7656 | 12800.0 |
| 2000-07-05 15:00:00 | IWM | ETF | 51.8125 | 51.8125 | 51.625 | 51.625 | 1600.0 |
| 2000-07-05 16:00:00 | IWM | ETF | 51.8125 | 51.8125 | 51.8125 | 51.8125 | 600.0 |
| 2000-07-05 09:00:00 | DIA | ETF | 105.3438 | 105.625 | 105.0312 | 105.5 | 150700.0 |
| 2000-07-05 10:00:00 | DIA | ETF | 105.625 | 105.7188 | 105.25 | 105.4688 | 61500.0 |
| 2000-07-05 11:00:00 | DIA | ETF | 105.375 | 105.8438 | 105.25 | 105.8438 | 63500.0 |
| 2000-07-05 12:00:00 | DIA | ETF | 105.625 | 105.875 | 105.4062 | 105.7188 | 23800.0 |
| 2000-07-05 13:00:00 | DIA | ETF | 105.6875 | 105.7812 | 105.375 | 105.5312 | 21100.0 |
| 2000-07-05 14:00:00 | DIA | ETF | 105.5 | 105.5312 | 105.1562 | 105.25 | 28900.0 |
| 2000-07-05 15:00:00 | DIA | ETF | 105.25 | 105.2812 | 104.625 | 105.0625 | 252100.0 |
| 2000-07-05 16:00:00 | DIA | ETF | 105.0 | 105.0312 | 104.8125 | 105.0 | 158300.0 |
> showing 35 of 165 rows — these rows as CSV