PREVIEW / etf_1hour / 2001-08-28
file: by_date/etf_1hour/2001/2001-08-28.parquet size: 12 KB rows: 234
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-08-28 09:00:00 | SPY | ETF | 118.28 | 118.49 | 118.14 | 118.2 | 1176300.0 |
| 2001-08-28 10:00:00 | SPY | ETF | 118.21 | 118.22 | 117.05 | 117.21 | 2714500.0 |
| 2001-08-28 11:00:00 | SPY | ETF | 117.19 | 117.36 | 116.96 | 117.1 | 1635000.0 |
| 2001-08-28 12:00:00 | SPY | ETF | 117.12 | 117.3 | 117.01 | 117.14 | 277600.0 |
| 2001-08-28 13:00:00 | SPY | ETF | 117.17 | 117.59 | 117.02 | 117.52 | 1040700.0 |
| 2001-08-28 14:00:00 | SPY | ETF | 117.56 | 117.58 | 116.66 | 116.9 | 1290200.0 |
| 2001-08-28 15:00:00 | SPY | ETF | 116.91 | 117.08 | 116.59 | 116.64 | 2477200.0 |
| 2001-08-28 16:00:00 | SPY | ETF | 116.65 | 116.67 | 116.58 | 116.65 | 1172100.0 |
| 2001-08-28 17:00:00 | SPY | ETF | 116.59 | 116.59 | 116.59 | 116.59 | 200.0 |
| 2001-08-28 09:00:00 | QQQ | ETF | 39.32 | 39.44 | 39.08 | 39.16 | 7387700.0 |
| 2001-08-28 10:00:00 | QQQ | ETF | 39.16 | 39.17 | 38.31 | 38.48 | 17355600.0 |
| 2001-08-28 11:00:00 | QQQ | ETF | 38.48 | 38.65 | 38.36 | 38.49 | 6215500.0 |
| 2001-08-28 12:00:00 | QQQ | ETF | 38.47 | 38.56 | 38.33 | 38.5 | 4097300.0 |
| 2001-08-28 13:00:00 | QQQ | ETF | 38.5 | 38.89 | 38.35 | 38.83 | 7276700.0 |
| 2001-08-28 14:00:00 | QQQ | ETF | 38.83 | 38.85 | 38.02 | 38.14 | 9175700.0 |
| 2001-08-28 15:00:00 | QQQ | ETF | 38.13 | 38.32 | 38.01 | 38.07 | 8575000.0 |
| 2001-08-28 16:00:00 | QQQ | ETF | 38.1 | 38.51 | 38.0 | 38.15 | 1338500.0 |
| 2001-08-28 17:00:00 | QQQ | ETF | 38.11 | 38.16 | 38.08 | 38.15 | 35000.0 |
| 2001-08-28 18:00:00 | QQQ | ETF | 38.16 | 38.17 | 38.12 | 38.15 | 7800.0 |
| 2001-08-28 09:00:00 | IWM | ETF | 47.825 | 47.85 | 47.75 | 47.85 | 39200.0 |
| 2001-08-28 10:00:00 | IWM | ETF | 47.705 | 47.725 | 47.44 | 47.44 | 58600.0 |
| 2001-08-28 11:00:00 | IWM | ETF | 47.47 | 47.495 | 47.3 | 47.475 | 54000.0 |
| 2001-08-28 12:00:00 | IWM | ETF | 47.35 | 47.45 | 47.255 | 47.375 | 434200.0 |
| 2001-08-28 13:00:00 | IWM | ETF | 47.4 | 47.55 | 47.4 | 47.55 | 26800.0 |
| 2001-08-28 14:00:00 | IWM | ETF | 47.565 | 47.565 | 47.325 | 47.405 | 85600.0 |
| 2001-08-28 15:00:00 | IWM | ETF | 47.415 | 47.455 | 47.25 | 47.25 | 234200.0 |
| 2001-08-28 16:00:00 | IWM | ETF | 47.255 | 47.35 | 47.255 | 47.35 | 7600.0 |
| 2001-08-28 09:00:00 | DIA | ETF | 103.99 | 103.99 | 103.71 | 103.73 | 205600.0 |
| 2001-08-28 10:00:00 | DIA | ETF | 103.73 | 103.73 | 102.65 | 102.78 | 608100.0 |
| 2001-08-28 11:00:00 | DIA | ETF | 102.8 | 102.96 | 102.44 | 102.79 | 330300.0 |
| 2001-08-28 12:00:00 | DIA | ETF | 102.79 | 102.9 | 102.66 | 102.78 | 58900.0 |
| 2001-08-28 13:00:00 | DIA | ETF | 102.73 | 103.06 | 102.63 | 102.96 | 432700.0 |
| 2001-08-28 14:00:00 | DIA | ETF | 102.99 | 103.05 | 102.35 | 102.56 | 334300.0 |
| 2001-08-28 15:00:00 | DIA | ETF | 102.56 | 102.72 | 102.25 | 102.38 | 603300.0 |
| 2001-08-28 16:00:00 | DIA | ETF | 102.35 | 102.39 | 102.32 | 102.32 | 129300.0 |
> showing 35 of 234 rows — these rows as CSV