PREVIEW / etf_1hour / 2001-10-22
file: by_date/etf_1hour/2001/2001-10-22.parquet size: 12 KB rows: 244
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-10-22 09:00:00 | SPY | ETF | 107.3 | 108.18 | 107.21 | 108.1 | 3061500.0 |
| 2001-10-22 10:00:00 | SPY | ETF | 108.09 | 108.25 | 107.72 | 108.01 | 2035100.0 |
| 2001-10-22 11:00:00 | SPY | ETF | 108.0 | 108.35 | 107.9 | 108.05 | 1210100.0 |
| 2001-10-22 12:00:00 | SPY | ETF | 108.05 | 108.62 | 107.95 | 108.48 | 1655700.0 |
| 2001-10-22 13:00:00 | SPY | ETF | 108.46 | 108.63 | 107.91 | 108.15 | 1697600.0 |
| 2001-10-22 14:00:00 | SPY | ETF | 108.11 | 109.23 | 107.95 | 109.1 | 2412400.0 |
| 2001-10-22 15:00:00 | SPY | ETF | 109.09 | 109.49 | 108.98 | 109.26 | 3679700.0 |
| 2001-10-22 16:00:00 | SPY | ETF | 109.3 | 109.57 | 108.05 | 109.5 | 889800.0 |
| 2001-10-22 17:00:00 | SPY | ETF | 109.69 | 109.69 | 109.69 | 109.69 | 100.0 |
| 2001-10-22 18:00:00 | SPY | ETF | 109.49 | 109.49 | 109.49 | 109.49 | 300.0 |
| 2001-10-22 09:00:00 | QQQ | ETF | 33.44 | 34.24 | 33.22 | 34.12 | 11272700.0 |
| 2001-10-22 10:00:00 | QQQ | ETF | 34.18 | 34.38 | 33.9 | 34.1 | 12495100.0 |
| 2001-10-22 11:00:00 | QQQ | ETF | 34.15 | 34.27 | 33.83 | 33.9 | 8552200.0 |
| 2001-10-22 12:00:00 | QQQ | ETF | 33.92 | 34.16 | 33.89 | 33.95 | 4290200.0 |
| 2001-10-22 13:00:00 | QQQ | ETF | 33.95 | 34.04 | 33.51 | 33.73 | 9293900.0 |
| 2001-10-22 14:00:00 | QQQ | ETF | 33.71 | 34.31 | 33.6 | 34.21 | 8116600.0 |
| 2001-10-22 15:00:00 | QQQ | ETF | 34.2 | 34.43 | 34.06 | 34.43 | 12946700.0 |
| 2001-10-22 16:00:00 | QQQ | ETF | 34.43 | 34.58 | 34.37 | 34.56 | 3948300.0 |
| 2001-10-22 17:00:00 | QQQ | ETF | 34.55 | 34.63 | 34.5 | 34.55 | 80000.0 |
| 2001-10-22 18:00:00 | QQQ | ETF | 34.53 | 34.6 | 34.53 | 34.53 | 4500.0 |
| 2001-10-22 09:00:00 | IWM | ETF | 42.375 | 42.5 | 42.34 | 42.49 | 21800.0 |
| 2001-10-22 10:00:00 | IWM | ETF | 42.55 | 42.575 | 42.375 | 42.535 | 91000.0 |
| 2001-10-22 11:00:00 | IWM | ETF | 42.525 | 42.575 | 42.44 | 42.455 | 85200.0 |
| 2001-10-22 12:00:00 | IWM | ETF | 42.53 | 42.65 | 42.53 | 42.575 | 39400.0 |
| 2001-10-22 13:00:00 | IWM | ETF | 42.66 | 42.7 | 42.505 | 42.6 | 33200.0 |
| 2001-10-22 14:00:00 | IWM | ETF | 42.605 | 42.85 | 42.585 | 42.82 | 39000.0 |
| 2001-10-22 15:00:00 | IWM | ETF | 42.735 | 42.875 | 42.68 | 42.68 | 44800.0 |
| 2001-10-22 09:00:00 | DIA | ETF | 91.9 | 92.69 | 91.7 | 92.57 | 728800.0 |
| 2001-10-22 10:00:00 | DIA | ETF | 92.58 | 92.79 | 92.39 | 92.68 | 429000.0 |
| 2001-10-22 11:00:00 | DIA | ETF | 92.67 | 92.84 | 92.41 | 92.59 | 189500.0 |
| 2001-10-22 12:00:00 | DIA | ETF | 92.6 | 93.15 | 92.53 | 93.0 | 478500.0 |
| 2001-10-22 13:00:00 | DIA | ETF | 92.99 | 93.1 | 92.58 | 92.8 | 389300.0 |
| 2001-10-22 14:00:00 | DIA | ETF | 92.84 | 93.73 | 92.7 | 93.64 | 574800.0 |
| 2001-10-22 15:00:00 | DIA | ETF | 93.64 | 94.15 | 93.6 | 93.83 | 819800.0 |
| 2001-10-22 16:00:00 | DIA | ETF | 93.92 | 94.08 | 93.85 | 94.05 | 42900.0 |
> showing 35 of 244 rows — these rows as CSV