PREVIEW / etf_1hour / 2001-02-14
file: by_date/etf_1hour/2001/2001-02-14.parquet size: 11 KB rows: 204
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-02-14 09:00:00 | SPY | ETF | 132.6 | 132.65 | 131.76 | 131.85 | 1944000.0 |
| 2001-02-14 10:00:00 | SPY | ETF | 131.89 | 131.89 | 130.66 | 131.17 | 1599100.0 |
| 2001-02-14 11:00:00 | SPY | ETF | 131.1 | 131.74 | 131.0 | 131.47 | 742300.0 |
| 2001-02-14 12:00:00 | SPY | ETF | 131.4 | 131.69 | 131.12 | 131.28 | 283200.0 |
| 2001-02-14 13:00:00 | SPY | ETF | 131.26 | 131.64 | 130.96 | 131.58 | 322300.0 |
| 2001-02-14 14:00:00 | SPY | ETF | 131.6 | 132.42 | 131.52 | 131.76 | 1250200.0 |
| 2001-02-14 15:00:00 | SPY | ETF | 131.9 | 132.3 | 131.62 | 132.15 | 1460500.0 |
| 2001-02-14 16:00:00 | SPY | ETF | 132.24 | 132.3 | 131.72 | 132.06 | 638800.0 |
| 2001-02-14 09:00:00 | QQQ | ETF | 55.4 | 55.75 | 54.89 | 55.4 | 9640600.0 |
| 2001-02-14 10:00:00 | QQQ | ETF | 55.4 | 55.69 | 54.12 | 54.75 | 9875800.0 |
| 2001-02-14 11:00:00 | QQQ | ETF | 54.78 | 56.2 | 54.7 | 55.88 | 10247500.0 |
| 2001-02-14 12:00:00 | QQQ | ETF | 55.85 | 56.04 | 55.3 | 55.3 | 5245000.0 |
| 2001-02-14 13:00:00 | QQQ | ETF | 55.3 | 56.15 | 55.0 | 56.1 | 5150400.0 |
| 2001-02-14 14:00:00 | QQQ | ETF | 56.11 | 57.09 | 56.0 | 56.74 | 9206300.0 |
| 2001-02-14 15:00:00 | QQQ | ETF | 56.75 | 57.61 | 56.63 | 57.44 | 9437000.0 |
| 2001-02-14 16:00:00 | QQQ | ETF | 57.5 | 58.45 | 55.57 | 57.87 | 1754300.0 |
| 2001-02-14 17:00:00 | QQQ | ETF | 57.89 | 58.15 | 57.85 | 58.05 | 37500.0 |
| 2001-02-14 18:00:00 | QQQ | ETF | 58.0 | 58.05 | 57.92 | 58.0 | 8000.0 |
| 2001-02-14 09:00:00 | IWM | ETF | 50.2 | 50.2 | 49.8 | 50.0 | 9800.0 |
| 2001-02-14 10:00:00 | IWM | ETF | 49.95 | 49.97 | 49.685 | 49.725 | 17800.0 |
| 2001-02-14 11:00:00 | IWM | ETF | 49.725 | 50.025 | 49.725 | 50.025 | 23400.0 |
| 2001-02-14 12:00:00 | IWM | ETF | 49.875 | 49.995 | 49.65 | 49.75 | 37600.0 |
| 2001-02-14 13:00:00 | IWM | ETF | 49.7 | 49.95 | 49.7 | 49.875 | 163000.0 |
| 2001-02-14 14:00:00 | IWM | ETF | 50.135 | 50.2 | 49.95 | 49.95 | 41600.0 |
| 2001-02-14 15:00:00 | IWM | ETF | 50.1 | 50.45 | 50.015 | 50.45 | 41200.0 |
| 2001-02-14 09:00:00 | DIA | ETF | 109.36 | 109.36 | 108.76 | 108.9 | 395200.0 |
| 2001-02-14 10:00:00 | DIA | ETF | 108.93 | 109.0 | 108.33 | 108.46 | 453300.0 |
| 2001-02-14 11:00:00 | DIA | ETF | 108.47 | 108.66 | 108.11 | 108.46 | 313800.0 |
| 2001-02-14 12:00:00 | DIA | ETF | 108.34 | 108.53 | 108.02 | 108.11 | 74000.0 |
| 2001-02-14 13:00:00 | DIA | ETF | 108.1 | 108.44 | 108.01 | 108.44 | 67100.0 |
| 2001-02-14 14:00:00 | DIA | ETF | 108.36 | 108.87 | 108.28 | 108.5 | 203100.0 |
| 2001-02-14 15:00:00 | DIA | ETF | 108.49 | 108.64 | 108.11 | 108.25 | 182600.0 |
| 2001-02-14 16:00:00 | DIA | ETF | 108.3 | 108.35 | 108.09 | 108.28 | 53000.0 |
> showing 33 of 204 rows — these rows as CSV