PREVIEW / etf_1hour / 2001-03-15
file: by_date/etf_1hour/2001/2001-03-15.parquet size: 11 KB rows: 217
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-03-15 09:00:00 | SPY | ETF | 118.45 | 118.86 | 118.2 | 118.48 | 1592300.0 |
| 2001-03-15 10:00:00 | SPY | ETF | 118.42 | 118.69 | 117.85 | 117.85 | 1581700.0 |
| 2001-03-15 11:00:00 | SPY | ETF | 117.86 | 118.27 | 117.51 | 117.94 | 926800.0 |
| 2001-03-15 12:00:00 | SPY | ETF | 117.97 | 118.49 | 117.9 | 117.96 | 727000.0 |
| 2001-03-15 13:00:00 | SPY | ETF | 117.97 | 118.38 | 117.75 | 118.28 | 352600.0 |
| 2001-03-15 14:00:00 | SPY | ETF | 118.11 | 118.47 | 117.52 | 117.75 | 927500.0 |
| 2001-03-15 15:00:00 | SPY | ETF | 117.8 | 118.2 | 117.6 | 117.71 | 1569600.0 |
| 2001-03-15 16:00:00 | SPY | ETF | 117.7 | 117.92 | 117.36 | 117.8 | 610000.0 |
| 2001-03-15 17:00:00 | SPY | ETF | 117.86 | 118.42 | 117.86 | 117.99 | 1660600.0 |
| 2001-03-15 09:00:00 | QQQ | ETF | 45.2 | 45.31 | 44.72 | 44.95 | 11883300.0 |
| 2001-03-15 10:00:00 | QQQ | ETF | 44.95 | 45.17 | 44.2 | 44.2 | 13204900.0 |
| 2001-03-15 11:00:00 | QQQ | ETF | 44.26 | 44.5 | 43.99 | 44.28 | 7916800.0 |
| 2001-03-15 12:00:00 | QQQ | ETF | 44.26 | 44.65 | 44.22 | 44.25 | 5805300.0 |
| 2001-03-15 13:00:00 | QQQ | ETF | 44.25 | 44.3 | 43.65 | 43.84 | 6582100.0 |
| 2001-03-15 14:00:00 | QQQ | ETF | 43.83 | 44.07 | 43.0 | 43.05 | 7388500.0 |
| 2001-03-15 15:00:00 | QQQ | ETF | 43.0 | 43.12 | 42.25 | 42.32 | 11641400.0 |
| 2001-03-15 16:00:00 | QQQ | ETF | 42.3 | 42.75 | 42.01 | 42.65 | 1941600.0 |
| 2001-03-15 17:00:00 | QQQ | ETF | 42.65 | 43.0 | 42.57 | 42.77 | 957200.0 |
| 2001-03-15 18:00:00 | QQQ | ETF | 42.75 | 42.9 | 42.6 | 42.85 | 54600.0 |
| 2001-03-15 09:00:00 | IWM | ETF | 45.525 | 45.675 | 45.475 | 45.615 | 13600.0 |
| 2001-03-15 10:00:00 | IWM | ETF | 45.7 | 45.7 | 45.3 | 45.55 | 19000.0 |
| 2001-03-15 11:00:00 | IWM | ETF | 45.2 | 45.265 | 45.05 | 45.18 | 25400.0 |
| 2001-03-15 12:00:00 | IWM | ETF | 45.2 | 45.425 | 45.2 | 45.325 | 92600.0 |
| 2001-03-15 13:00:00 | IWM | ETF | 45.255 | 45.255 | 45.05 | 45.1 | 16400.0 |
| 2001-03-15 14:00:00 | IWM | ETF | 45.325 | 45.35 | 45.1 | 45.24 | 259400.0 |
| 2001-03-15 15:00:00 | IWM | ETF | 45.0 | 45.2 | 44.75 | 44.825 | 132200.0 |
| 2001-03-15 16:00:00 | IWM | ETF | 44.85 | 44.85 | 44.85 | 44.85 | 15200.0 |
| 2001-03-15 09:00:00 | DIA | ETF | 101.24 | 101.32 | 100.5 | 100.82 | 593900.0 |
| 2001-03-15 10:00:00 | DIA | ETF | 100.86 | 100.9 | 100.02 | 100.19 | 582900.0 |
| 2001-03-15 11:00:00 | DIA | ETF | 100.19 | 100.62 | 99.9 | 100.3 | 478200.0 |
| 2001-03-15 12:00:00 | DIA | ETF | 100.3 | 100.71 | 100.21 | 100.25 | 369400.0 |
| 2001-03-15 13:00:00 | DIA | ETF | 100.3 | 100.5 | 100.0 | 100.5 | 325700.0 |
| 2001-03-15 14:00:00 | DIA | ETF | 100.4 | 100.72 | 100.1 | 100.11 | 409300.0 |
| 2001-03-15 15:00:00 | DIA | ETF | 100.25 | 100.59 | 100.1 | 100.42 | 495300.0 |
| 2001-03-15 16:00:00 | DIA | ETF | 100.6 | 100.65 | 100.18 | 100.4 | 22300.0 |
> showing 35 of 217 rows — these rows as CSV