PREVIEW / etf_1hour / 2001-02-16
file: by_date/etf_1hour/2001/2001-02-16.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-16 09:00:00 | SPY | ETF | 131.0 | 131.13 | 130.5 | 131.0 | 1186200.0 |
| 2001-02-16 10:00:00 | SPY | ETF | 131.05 | 131.29 | 130.5 | 130.84 | 571000.0 |
| 2001-02-16 11:00:00 | SPY | ETF | 130.84 | 131.21 | 130.66 | 130.92 | 494300.0 |
| 2001-02-16 12:00:00 | SPY | ETF | 130.83 | 131.08 | 130.61 | 130.76 | 304600.0 |
| 2001-02-16 13:00:00 | SPY | ETF | 130.6 | 130.71 | 130.02 | 130.18 | 1056000.0 |
| 2001-02-16 14:00:00 | SPY | ETF | 130.15 | 130.68 | 129.51 | 130.52 | 1050100.0 |
| 2001-02-16 15:00:00 | SPY | ETF | 130.39 | 130.99 | 130.0 | 130.46 | 1291000.0 |
| 2001-02-16 16:00:00 | SPY | ETF | 130.46 | 130.6 | 130.31 | 130.4 | 249100.0 |
| 2001-02-16 09:00:00 | QQQ | ETF | 55.96 | 56.58 | 55.0 | 56.45 | 13637900.0 |
| 2001-02-16 10:00:00 | QQQ | ETF | 56.47 | 56.54 | 55.52 | 55.83 | 10143300.0 |
| 2001-02-16 11:00:00 | QQQ | ETF | 55.9 | 56.37 | 55.75 | 55.8 | 5024400.0 |
| 2001-02-16 12:00:00 | QQQ | ETF | 55.9 | 56.06 | 55.49 | 55.64 | 3518900.0 |
| 2001-02-16 13:00:00 | QQQ | ETF | 55.6 | 55.64 | 54.77 | 54.98 | 8238000.0 |
| 2001-02-16 14:00:00 | QQQ | ETF | 54.95 | 55.75 | 54.53 | 55.57 | 10497400.0 |
| 2001-02-16 15:00:00 | QQQ | ETF | 55.53 | 55.97 | 55.18 | 55.26 | 9263400.0 |
| 2001-02-16 16:00:00 | QQQ | ETF | 55.26 | 55.8 | 54.9 | 55.0 | 1764400.0 |
| 2001-02-16 17:00:00 | QQQ | ETF | 55.0 | 55.4 | 55.0 | 55.29 | 19900.0 |
| 2001-02-16 18:00:00 | QQQ | ETF | 55.27 | 55.45 | 55.2 | 55.25 | 23600.0 |
| 2001-02-16 09:00:00 | IWM | ETF | 49.55 | 50.015 | 49.525 | 50.015 | 240200.0 |
| 2001-02-16 10:00:00 | IWM | ETF | 50.2 | 50.2 | 49.75 | 49.895 | 151800.0 |
| 2001-02-16 11:00:00 | IWM | ETF | 49.8 | 49.925 | 49.775 | 49.875 | 17600.0 |
| 2001-02-16 12:00:00 | IWM | ETF | 49.75 | 49.875 | 49.75 | 49.875 | 1000.0 |
| 2001-02-16 13:00:00 | IWM | ETF | 49.875 | 49.875 | 49.525 | 49.575 | 15800.0 |
| 2001-02-16 14:00:00 | IWM | ETF | 49.6 | 49.9 | 49.45 | 49.9 | 206000.0 |
| 2001-02-16 15:00:00 | IWM | ETF | 49.65 | 50.0 | 49.63 | 49.755 | 39000.0 |
| 2001-02-16 16:00:00 | IWM | ETF | 49.75 | 49.75 | 49.605 | 49.605 | 2800.0 |
| 2001-02-16 09:00:00 | DIA | ETF | 107.78 | 108.38 | 107.51 | 108.29 | 293600.0 |
| 2001-02-16 10:00:00 | DIA | ETF | 108.2 | 108.54 | 108.01 | 108.4 | 253800.0 |
| 2001-02-16 11:00:00 | DIA | ETF | 108.24 | 108.4 | 108.11 | 108.27 | 144400.0 |
| 2001-02-16 12:00:00 | DIA | ETF | 108.15 | 108.26 | 107.96 | 107.96 | 143100.0 |
| 2001-02-16 13:00:00 | DIA | ETF | 107.96 | 108.0 | 107.52 | 107.53 | 247400.0 |
| 2001-02-16 14:00:00 | DIA | ETF | 107.7 | 107.95 | 107.21 | 107.95 | 217300.0 |
| 2001-02-16 15:00:00 | DIA | ETF | 107.82 | 108.4 | 107.6 | 108.0 | 202100.0 |
| 2001-02-16 16:00:00 | DIA | ETF | 107.9 | 108.15 | 107.88 | 108.15 | 11500.0 |
> showing 34 of 204 rows — these rows as CSV