PREVIEW / etf_1hour / 2001-12-07
file: by_date/etf_1hour/2001/2001-12-07.parquet size: 13 KB rows: 275
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-07 09:00:00 | SPY | ETF | 116.9 | 116.9 | 116.48 | 116.66 | 2344600.0 |
| 2001-12-07 10:00:00 | SPY | ETF | 116.61 | 117.09 | 116.51 | 116.97 | 2807400.0 |
| 2001-12-07 11:00:00 | SPY | ETF | 116.97 | 117.06 | 116.14 | 116.33 | 3073800.0 |
| 2001-12-07 12:00:00 | SPY | ETF | 116.3 | 116.46 | 116.12 | 116.27 | 3223100.0 |
| 2001-12-07 13:00:00 | SPY | ETF | 116.28 | 116.55 | 116.02 | 116.02 | 1256100.0 |
| 2001-12-07 14:00:00 | SPY | ETF | 116.1 | 116.2 | 115.7 | 116.1 | 2931300.0 |
| 2001-12-07 15:00:00 | SPY | ETF | 116.07 | 116.49 | 115.97 | 116.45 | 2001500.0 |
| 2001-12-07 16:00:00 | SPY | ETF | 116.42 | 116.62 | 116.19 | 116.5 | 1186800.0 |
| 2001-12-07 17:00:00 | SPY | ETF | 116.45 | 116.45 | 116.4 | 116.4 | 200.0 |
| 2001-12-07 09:00:00 | QQQ | ETF | 42.48 | 42.6 | 42.15 | 42.34 | 11906700.0 |
| 2001-12-07 10:00:00 | QQQ | ETF | 42.34 | 42.51 | 42.16 | 42.42 | 14085400.0 |
| 2001-12-07 11:00:00 | QQQ | ETF | 42.43 | 42.53 | 41.8 | 41.91 | 11170500.0 |
| 2001-12-07 12:00:00 | QQQ | ETF | 41.9 | 41.98 | 41.7 | 41.85 | 5988500.0 |
| 2001-12-07 13:00:00 | QQQ | ETF | 41.84 | 42.04 | 41.65 | 41.65 | 7648700.0 |
| 2001-12-07 14:00:00 | QQQ | ETF | 41.65 | 41.75 | 41.14 | 41.42 | 14877900.0 |
| 2001-12-07 15:00:00 | QQQ | ETF | 41.41 | 41.93 | 41.3 | 41.72 | 12652300.0 |
| 2001-12-07 16:00:00 | QQQ | ETF | 41.73 | 41.84 | 41.7 | 41.77 | 2052600.0 |
| 2001-12-07 17:00:00 | QQQ | ETF | 41.76 | 41.85 | 41.7 | 41.8 | 19200.0 |
| 2001-12-07 18:00:00 | QQQ | ETF | 41.8 | 41.85 | 41.8 | 41.85 | 3400.0 |
| 2001-12-07 09:00:00 | IWM | ETF | 48.075 | 48.075 | 47.85 | 47.915 | 62200.0 |
| 2001-12-07 10:00:00 | IWM | ETF | 47.89 | 48.19 | 47.78 | 48.19 | 26000.0 |
| 2001-12-07 11:00:00 | IWM | ETF | 48.185 | 48.24 | 47.925 | 47.94 | 56200.0 |
| 2001-12-07 12:00:00 | IWM | ETF | 47.945 | 48.05 | 47.85 | 48.05 | 34600.0 |
| 2001-12-07 13:00:00 | IWM | ETF | 48.03 | 48.175 | 47.945 | 48.12 | 41000.0 |
| 2001-12-07 14:00:00 | IWM | ETF | 47.95 | 48.09 | 47.825 | 48.0 | 77800.0 |
| 2001-12-07 15:00:00 | IWM | ETF | 47.905 | 48.15 | 47.83 | 48.06 | 226000.0 |
| 2001-12-07 16:00:00 | IWM | ETF | 48.055 | 48.055 | 47.885 | 47.885 | 1800.0 |
| 2001-12-07 09:00:00 | DIA | ETF | 100.82 | 101.0 | 100.6 | 100.87 | 444700.0 |
| 2001-12-07 10:00:00 | DIA | ETF | 100.85 | 101.24 | 100.67 | 101.15 | 266700.0 |
| 2001-12-07 11:00:00 | DIA | ETF | 101.2 | 101.23 | 100.52 | 100.66 | 440500.0 |
| 2001-12-07 12:00:00 | DIA | ETF | 100.65 | 100.74 | 100.35 | 100.51 | 673000.0 |
| 2001-12-07 13:00:00 | DIA | ETF | 100.59 | 100.85 | 100.41 | 100.47 | 634200.0 |
| 2001-12-07 14:00:00 | DIA | ETF | 100.44 | 100.62 | 100.17 | 100.49 | 463100.0 |
| 2001-12-07 15:00:00 | DIA | ETF | 100.6 | 100.84 | 100.44 | 100.65 | 689800.0 |
| 2001-12-07 16:00:00 | DIA | ETF | 100.7 | 100.95 | 100.68 | 100.8 | 338400.0 |
> showing 35 of 275 rows — these rows as CSV