PREVIEW / etf_1hour / 2001-12-04
file: by_date/etf_1hour/2001/2001-12-04.parquet size: 13 KB rows: 277
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-12-04 09:00:00 | SPY | ETF | 113.91 | 114.0 | 113.65 | 113.96 | 1488100.0 |
| 2001-12-04 10:00:00 | SPY | ETF | 113.94 | 114.17 | 113.36 | 113.56 | 3616800.0 |
| 2001-12-04 11:00:00 | SPY | ETF | 113.55 | 113.8 | 113.35 | 113.72 | 1796100.0 |
| 2001-12-04 12:00:00 | SPY | ETF | 113.73 | 113.98 | 113.6 | 113.73 | 1322100.0 |
| 2001-12-04 13:00:00 | SPY | ETF | 113.74 | 113.96 | 113.57 | 113.89 | 1133600.0 |
| 2001-12-04 14:00:00 | SPY | ETF | 113.91 | 114.74 | 113.82 | 114.65 | 2623200.0 |
| 2001-12-04 15:00:00 | SPY | ETF | 114.65 | 115.0 | 114.46 | 115.0 | 2739900.0 |
| 2001-12-04 16:00:00 | SPY | ETF | 114.99 | 115.3 | 114.94 | 115.29 | 2380200.0 |
| 2001-12-04 17:00:00 | SPY | ETF | 115.2 | 115.2 | 115.05 | 115.15 | 3400.0 |
| 2001-12-04 09:00:00 | QQQ | ETF | 39.34 | 39.6 | 39.24 | 39.52 | 10341400.0 |
| 2001-12-04 10:00:00 | QQQ | ETF | 39.52 | 39.76 | 39.32 | 39.5 | 12416300.0 |
| 2001-12-04 11:00:00 | QQQ | ETF | 39.53 | 39.7 | 39.4 | 39.5 | 6887900.0 |
| 2001-12-04 12:00:00 | QQQ | ETF | 39.51 | 39.72 | 39.43 | 39.5 | 4619300.0 |
| 2001-12-04 13:00:00 | QQQ | ETF | 39.5 | 39.74 | 39.44 | 39.72 | 5695400.0 |
| 2001-12-04 14:00:00 | QQQ | ETF | 39.69 | 40.35 | 39.66 | 40.3 | 17062300.0 |
| 2001-12-04 15:00:00 | QQQ | ETF | 40.32 | 40.68 | 40.23 | 40.65 | 17129400.0 |
| 2001-12-04 16:00:00 | QQQ | ETF | 40.65 | 40.85 | 39.59 | 40.8 | 4644500.0 |
| 2001-12-04 17:00:00 | QQQ | ETF | 40.8 | 40.82 | 40.7 | 40.77 | 108600.0 |
| 2001-12-04 18:00:00 | QQQ | ETF | 40.75 | 40.8 | 40.75 | 40.8 | 22900.0 |
| 2001-12-04 09:00:00 | IWM | ETF | 45.5 | 45.825 | 45.48 | 45.825 | 22800.0 |
| 2001-12-04 10:00:00 | IWM | ETF | 45.84 | 45.865 | 45.6 | 45.765 | 70400.0 |
| 2001-12-04 11:00:00 | IWM | ETF | 45.705 | 45.87 | 45.7 | 45.78 | 28200.0 |
| 2001-12-04 12:00:00 | IWM | ETF | 45.87 | 46.15 | 45.87 | 46.145 | 34200.0 |
| 2001-12-04 13:00:00 | IWM | ETF | 46.12 | 46.2 | 45.975 | 46.145 | 43000.0 |
| 2001-12-04 14:00:00 | IWM | ETF | 46.1 | 46.375 | 46.1 | 46.375 | 52600.0 |
| 2001-12-04 15:00:00 | IWM | ETF | 46.33 | 46.675 | 46.24 | 46.675 | 360200.0 |
| 2001-12-04 16:00:00 | IWM | ETF | 46.675 | 46.675 | 46.55 | 46.55 | 65200.0 |
| 2001-12-04 09:00:00 | DIA | ETF | 98.3 | 98.44 | 97.95 | 98.13 | 216600.0 |
| 2001-12-04 10:00:00 | DIA | ETF | 98.15 | 98.4 | 97.67 | 97.8 | 240200.0 |
| 2001-12-04 11:00:00 | DIA | ETF | 97.75 | 98.09 | 97.58 | 97.98 | 560900.0 |
| 2001-12-04 12:00:00 | DIA | ETF | 97.99 | 98.26 | 97.96 | 97.97 | 153700.0 |
| 2001-12-04 13:00:00 | DIA | ETF | 98.02 | 98.19 | 97.88 | 98.1 | 259000.0 |
| 2001-12-04 14:00:00 | DIA | ETF | 98.15 | 98.84 | 98.05 | 98.8 | 377600.0 |
| 2001-12-04 15:00:00 | DIA | ETF | 98.8 | 99.17 | 98.68 | 99.13 | 707700.0 |
| 2001-12-04 16:00:00 | DIA | ETF | 99.11 | 99.45 | 99.1 | 99.35 | 85300.0 |
| 2001-12-04 17:00:00 | DIA | ETF | 99.32 | 99.57 | 99.32 | 99.57 | 800.0 |
> showing 36 of 277 rows — these rows as CSV