PREVIEW / etf_1hour / 2001-12-11
file: by_date/etf_1hour/2001/2001-12-11.parquet size: 13 KB rows: 289
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-11 09:00:00 | SPY | ETF | 114.9 | 115.0 | 114.61 | 114.9 | 1408700.0 |
| 2001-12-11 10:00:00 | SPY | ETF | 114.91 | 115.12 | 114.67 | 114.98 | 1793400.0 |
| 2001-12-11 11:00:00 | SPY | ETF | 114.99 | 115.05 | 114.81 | 114.91 | 985200.0 |
| 2001-12-11 12:00:00 | SPY | ETF | 114.93 | 115.03 | 114.82 | 114.98 | 740700.0 |
| 2001-12-11 13:00:00 | SPY | ETF | 114.98 | 115.02 | 114.78 | 114.99 | 434400.0 |
| 2001-12-11 14:00:00 | SPY | ETF | 115.0 | 115.72 | 114.66 | 115.56 | 7130700.0 |
| 2001-12-11 15:00:00 | SPY | ETF | 115.53 | 115.58 | 113.9 | 114.19 | 6646600.0 |
| 2001-12-11 16:00:00 | SPY | ETF | 114.22 | 114.88 | 114.05 | 114.27 | 1415200.0 |
| 2001-12-11 17:00:00 | SPY | ETF | 114.27 | 114.32 | 114.27 | 114.32 | 1700.0 |
| 2001-12-11 18:00:00 | SPY | ETF | 114.3 | 114.3 | 114.3 | 114.3 | 200.0 |
| 2001-12-11 09:00:00 | QQQ | ETF | 41.46 | 41.65 | 41.35 | 41.61 | 7310500.0 |
| 2001-12-11 10:00:00 | QQQ | ETF | 41.6 | 41.85 | 41.45 | 41.78 | 8196100.0 |
| 2001-12-11 11:00:00 | QQQ | ETF | 41.77 | 41.93 | 41.65 | 41.77 | 5083700.0 |
| 2001-12-11 12:00:00 | QQQ | ETF | 41.75 | 41.8 | 41.63 | 41.77 | 3468200.0 |
| 2001-12-11 13:00:00 | QQQ | ETF | 41.74 | 41.85 | 41.66 | 41.84 | 1975400.0 |
| 2001-12-11 14:00:00 | QQQ | ETF | 41.83 | 42.26 | 41.6 | 42.15 | 16521100.0 |
| 2001-12-11 15:00:00 | QQQ | ETF | 42.14 | 42.16 | 41.15 | 41.36 | 20261200.0 |
| 2001-12-11 16:00:00 | QQQ | ETF | 41.37 | 41.93 | 41.13 | 41.37 | 2965600.0 |
| 2001-12-11 17:00:00 | QQQ | ETF | 41.35 | 41.41 | 41.32 | 41.35 | 25900.0 |
| 2001-12-11 18:00:00 | QQQ | ETF | 41.37 | 41.44 | 41.36 | 41.42 | 15100.0 |
| 2001-12-11 09:00:00 | IWM | ETF | 47.425 | 47.425 | 47.34 | 47.36 | 21200.0 |
| 2001-12-11 10:00:00 | IWM | ETF | 47.34 | 47.425 | 47.25 | 47.415 | 51200.0 |
| 2001-12-11 11:00:00 | IWM | ETF | 47.37 | 47.435 | 47.33 | 47.395 | 18400.0 |
| 2001-12-11 12:00:00 | IWM | ETF | 47.4 | 47.41 | 47.3 | 47.385 | 29400.0 |
| 2001-12-11 13:00:00 | IWM | ETF | 47.31 | 47.42 | 47.31 | 47.4 | 23600.0 |
| 2001-12-11 14:00:00 | IWM | ETF | 47.395 | 47.7 | 47.3 | 47.6 | 173400.0 |
| 2001-12-11 15:00:00 | IWM | ETF | 47.6 | 47.645 | 47.03 | 47.32 | 107000.0 |
| 2001-12-11 16:00:00 | IWM | ETF | 47.28 | 47.325 | 47.28 | 47.325 | 2600.0 |
| 2001-12-11 09:00:00 | DIA | ETF | 99.79 | 99.8 | 99.4 | 99.68 | 280900.0 |
| 2001-12-11 10:00:00 | DIA | ETF | 99.76 | 99.97 | 99.48 | 99.77 | 297600.0 |
| 2001-12-11 11:00:00 | DIA | ETF | 99.81 | 99.94 | 99.64 | 99.76 | 107700.0 |
| 2001-12-11 12:00:00 | DIA | ETF | 99.66 | 99.83 | 99.62 | 99.83 | 28200.0 |
| 2001-12-11 13:00:00 | DIA | ETF | 99.8 | 99.84 | 99.62 | 99.84 | 61900.0 |
| 2001-12-11 14:00:00 | DIA | ETF | 99.76 | 100.49 | 99.43 | 100.24 | 760200.0 |
| 2001-12-11 15:00:00 | DIA | ETF | 100.24 | 100.33 | 98.8 | 99.17 | 1743400.0 |
| 2001-12-11 16:00:00 | DIA | ETF | 99.15 | 99.95 | 98.2 | 99.0 | 71400.0 |
| 2001-12-11 17:00:00 | DIA | ETF | 99.2 | 99.2 | 99.2 | 99.2 | 300.0 |
> showing 37 of 289 rows — these rows as CSV