PREVIEW / etf_1hour / 2001-02-08
file: by_date/etf_1hour/2001/2001-02-08.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-08 09:00:00 | SPY | ETF | 134.8 | 135.15 | 134.7 | 134.9 | 1064100.0 |
| 2001-02-08 10:00:00 | SPY | ETF | 134.87 | 135.4 | 134.76 | 134.95 | 900000.0 |
| 2001-02-08 11:00:00 | SPY | ETF | 134.92 | 135.0 | 134.32 | 134.59 | 558800.0 |
| 2001-02-08 12:00:00 | SPY | ETF | 134.52 | 134.74 | 134.2 | 134.3 | 341100.0 |
| 2001-02-08 13:00:00 | SPY | ETF | 134.26 | 134.54 | 133.91 | 134.18 | 348100.0 |
| 2001-02-08 14:00:00 | SPY | ETF | 134.16 | 134.47 | 133.81 | 134.25 | 538000.0 |
| 2001-02-08 15:00:00 | SPY | ETF | 134.2 | 134.5 | 133.48 | 133.48 | 1610000.0 |
| 2001-02-08 16:00:00 | SPY | ETF | 133.5 | 134.44 | 133.1 | 133.12 | 388400.0 |
| 2001-02-08 09:00:00 | QQQ | ETF | 60.9 | 61.11 | 60.38 | 60.54 | 6646000.0 |
| 2001-02-08 10:00:00 | QQQ | ETF | 60.5 | 61.5 | 60.4 | 60.82 | 8077300.0 |
| 2001-02-08 11:00:00 | QQQ | ETF | 60.84 | 60.88 | 59.92 | 60.05 | 5490400.0 |
| 2001-02-08 12:00:00 | QQQ | ETF | 60.05 | 60.25 | 59.4 | 59.58 | 4493000.0 |
| 2001-02-08 13:00:00 | QQQ | ETF | 59.58 | 59.79 | 59.0 | 59.6 | 5604100.0 |
| 2001-02-08 14:00:00 | QQQ | ETF | 59.52 | 60.1 | 59.15 | 59.65 | 7457900.0 |
| 2001-02-08 15:00:00 | QQQ | ETF | 59.7 | 59.95 | 58.65 | 58.7 | 7090500.0 |
| 2001-02-08 16:00:00 | QQQ | ETF | 58.7 | 59.25 | 58.58 | 58.95 | 948600.0 |
| 2001-02-08 17:00:00 | QQQ | ETF | 58.96 | 59.09 | 58.75 | 58.8 | 33400.0 |
| 2001-02-08 18:00:00 | QQQ | ETF | 58.8 | 58.8 | 58.56 | 58.75 | 122900.0 |
| 2001-02-08 09:00:00 | IWM | ETF | 50.825 | 50.825 | 50.55 | 50.55 | 166800.0 |
| 2001-02-08 10:00:00 | IWM | ETF | 50.55 | 50.9 | 50.55 | 50.7 | 309400.0 |
| 2001-02-08 11:00:00 | IWM | ETF | 50.705 | 50.705 | 50.425 | 50.43 | 254200.0 |
| 2001-02-08 12:00:00 | IWM | ETF | 50.425 | 50.6 | 50.3 | 50.35 | 429200.0 |
| 2001-02-08 13:00:00 | IWM | ETF | 50.37 | 50.37 | 50.16 | 50.2 | 348400.0 |
| 2001-02-08 14:00:00 | IWM | ETF | 50.32 | 50.4 | 50.17 | 50.275 | 216600.0 |
| 2001-02-08 15:00:00 | IWM | ETF | 50.275 | 50.36 | 49.925 | 49.94 | 525800.0 |
| 2001-02-08 16:00:00 | IWM | ETF | 49.94 | 49.94 | 49.875 | 49.94 | 71800.0 |
| 2001-02-08 09:00:00 | DIA | ETF | 109.85 | 109.85 | 109.31 | 109.59 | 65600.0 |
| 2001-02-08 10:00:00 | DIA | ETF | 109.6 | 109.88 | 109.45 | 109.6 | 262200.0 |
| 2001-02-08 11:00:00 | DIA | ETF | 109.52 | 109.71 | 109.36 | 109.52 | 45600.0 |
| 2001-02-08 12:00:00 | DIA | ETF | 109.52 | 109.55 | 109.05 | 109.15 | 270800.0 |
| 2001-02-08 13:00:00 | DIA | ETF | 109.23 | 109.35 | 108.88 | 109.3 | 130600.0 |
| 2001-02-08 14:00:00 | DIA | ETF | 109.2 | 109.29 | 108.76 | 109.05 | 206700.0 |
| 2001-02-08 15:00:00 | DIA | ETF | 109.15 | 109.4 | 108.81 | 108.83 | 176400.0 |
| 2001-02-08 16:00:00 | DIA | ETF | 108.82 | 108.82 | 108.5 | 108.55 | 53500.0 |
> showing 34 of 204 rows — these rows as CSV