PREVIEW / etf_1hour / 2001-01-09
file: by_date/etf_1hour/2001/2001-01-09.parquet size: 10 KB rows: 189
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-09 09:00:00 | SPY | ETF | 131.0312 | 131.25 | 130.25 | 130.3438 | 1074400.0 |
| 2001-01-09 10:00:00 | SPY | ETF | 130.375 | 131.5 | 130.25 | 130.875 | 852000.0 |
| 2001-01-09 11:00:00 | SPY | ETF | 130.875 | 130.9688 | 130.125 | 130.5 | 428600.0 |
| 2001-01-09 12:00:00 | SPY | ETF | 130.5 | 130.5 | 129.6875 | 130.1875 | 562300.0 |
| 2001-01-09 13:00:00 | SPY | ETF | 130.0312 | 130.625 | 129.7812 | 130.0 | 741000.0 |
| 2001-01-09 14:00:00 | SPY | ETF | 130.0 | 130.7812 | 129.625 | 130.75 | 436200.0 |
| 2001-01-09 15:00:00 | SPY | ETF | 130.8125 | 130.8438 | 130.125 | 130.125 | 878200.0 |
| 2001-01-09 16:00:00 | SPY | ETF | 130.0312 | 130.5625 | 129.4062 | 129.875 | 541800.0 |
| 2001-01-09 09:00:00 | QQQ | ETF | 57.75 | 58.375 | 57.0312 | 57.6875 | 10106500.0 |
| 2001-01-09 10:00:00 | QQQ | ETF | 57.625 | 59.125 | 57.5625 | 58.125 | 10448300.0 |
| 2001-01-09 11:00:00 | QQQ | ETF | 58.1875 | 58.1875 | 57.375 | 57.9375 | 7049000.0 |
| 2001-01-09 12:00:00 | QQQ | ETF | 57.875 | 58.0312 | 56.625 | 57.0625 | 4502500.0 |
| 2001-01-09 13:00:00 | QQQ | ETF | 57.0625 | 58.1875 | 56.75 | 57.5 | 4822400.0 |
| 2001-01-09 14:00:00 | QQQ | ETF | 57.5312 | 58.375 | 57.0312 | 58.25 | 4099600.0 |
| 2001-01-09 15:00:00 | QQQ | ETF | 58.25 | 58.4375 | 57.3125 | 57.4375 | 8002100.0 |
| 2001-01-09 16:00:00 | QQQ | ETF | 57.4375 | 57.6875 | 57.0 | 57.1875 | 1182900.0 |
| 2001-01-09 17:00:00 | QQQ | ETF | 57.1875 | 57.375 | 57.125 | 57.3125 | 19000.0 |
| 2001-01-09 18:00:00 | QQQ | ETF | 57.25 | 57.375 | 57.25 | 57.3438 | 15700.0 |
| 2001-01-09 09:00:00 | IWM | ETF | 46.1875 | 46.5312 | 46.1875 | 46.2812 | 33600.0 |
| 2001-01-09 10:00:00 | IWM | ETF | 46.2188 | 46.5625 | 46.2188 | 46.4844 | 56000.0 |
| 2001-01-09 11:00:00 | IWM | ETF | 46.4375 | 46.4375 | 45.9688 | 46.125 | 60200.0 |
| 2001-01-09 12:00:00 | IWM | ETF | 46.0 | 46.0312 | 45.9219 | 46.0312 | 7400.0 |
| 2001-01-09 13:00:00 | IWM | ETF | 45.9062 | 46.1875 | 45.8438 | 46.1875 | 40600.0 |
| 2001-01-09 14:00:00 | IWM | ETF | 46.0 | 46.3125 | 45.9844 | 46.3125 | 83000.0 |
| 2001-01-09 15:00:00 | IWM | ETF | 46.4062 | 46.4062 | 46.1562 | 46.4062 | 20600.0 |
| 2001-01-09 16:00:00 | IWM | ETF | 46.1875 | 46.1875 | 46.1094 | 46.1094 | 5200.0 |
| 2001-01-09 09:00:00 | DIA | ETF | 106.9375 | 106.9688 | 106.25 | 106.5 | 187400.0 |
| 2001-01-09 10:00:00 | DIA | ETF | 106.5 | 106.9688 | 106.1875 | 106.4375 | 367700.0 |
| 2001-01-09 11:00:00 | DIA | ETF | 106.5 | 106.5 | 105.5938 | 106.0 | 142500.0 |
| 2001-01-09 12:00:00 | DIA | ETF | 105.9062 | 106.0312 | 105.625 | 105.75 | 60700.0 |
| 2001-01-09 13:00:00 | DIA | ETF | 105.9062 | 105.9062 | 105.375 | 105.5 | 164200.0 |
| 2001-01-09 14:00:00 | DIA | ETF | 105.4688 | 106.0312 | 105.1562 | 106.0 | 146600.0 |
| 2001-01-09 15:00:00 | DIA | ETF | 106.0 | 106.0 | 105.5 | 105.5312 | 116300.0 |
| 2001-01-09 16:00:00 | DIA | ETF | 105.5938 | 105.5938 | 105.3125 | 105.4375 | 83000.0 |
> showing 34 of 189 rows — these rows as CSV