PREVIEW / etf_1hour / 2001-02-12
file: by_date/etf_1hour/2001/2001-02-12.parquet size: 11 KB rows: 200
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-12 09:00:00 | SPY | ETF | 131.7 | 132.2 | 131.7 | 131.72 | 1096300.0 |
| 2001-02-12 10:00:00 | SPY | ETF | 131.84 | 133.17 | 131.71 | 133.1 | 1255900.0 |
| 2001-02-12 11:00:00 | SPY | ETF | 133.11 | 133.26 | 132.62 | 132.9 | 631400.0 |
| 2001-02-12 12:00:00 | SPY | ETF | 132.89 | 133.08 | 132.54 | 132.78 | 543300.0 |
| 2001-02-12 13:00:00 | SPY | ETF | 132.62 | 133.02 | 132.46 | 132.75 | 716600.0 |
| 2001-02-12 14:00:00 | SPY | ETF | 132.73 | 133.36 | 132.62 | 133.23 | 538600.0 |
| 2001-02-12 15:00:00 | SPY | ETF | 133.2 | 133.5 | 133.1 | 133.14 | 657600.0 |
| 2001-02-12 16:00:00 | SPY | ETF | 133.14 | 133.49 | 133.14 | 133.35 | 314000.0 |
| 2001-02-12 17:00:00 | SPY | ETF | 133.47 | 133.47 | 133.47 | 133.47 | 500.0 |
| 2001-02-12 09:00:00 | QQQ | ETF | 56.25 | 56.55 | 55.7 | 55.73 | 8379700.0 |
| 2001-02-12 10:00:00 | QQQ | ETF | 55.76 | 57.75 | 55.62 | 57.66 | 12555000.0 |
| 2001-02-12 11:00:00 | QQQ | ETF | 57.6 | 57.94 | 56.6 | 56.9 | 5778400.0 |
| 2001-02-12 12:00:00 | QQQ | ETF | 56.81 | 57.18 | 56.34 | 56.44 | 4544900.0 |
| 2001-02-12 13:00:00 | QQQ | ETF | 56.42 | 56.68 | 56.01 | 56.26 | 5272400.0 |
| 2001-02-12 14:00:00 | QQQ | ETF | 56.25 | 57.22 | 56.05 | 57.1 | 5588700.0 |
| 2001-02-12 15:00:00 | QQQ | ETF | 57.11 | 57.45 | 56.81 | 56.99 | 6689200.0 |
| 2001-02-12 16:00:00 | QQQ | ETF | 57.02 | 57.3 | 56.49 | 57.24 | 665800.0 |
| 2001-02-12 17:00:00 | QQQ | ETF | 57.18 | 57.25 | 57.05 | 57.2 | 23800.0 |
| 2001-02-12 18:00:00 | QQQ | ETF | 57.15 | 57.24 | 57.15 | 57.2 | 5400.0 |
| 2001-02-12 09:00:00 | IWM | ETF | 49.325 | 49.525 | 49.325 | 49.35 | 18800.0 |
| 2001-02-12 10:00:00 | IWM | ETF | 49.255 | 49.95 | 49.255 | 49.95 | 45600.0 |
| 2001-02-12 11:00:00 | IWM | ETF | 49.95 | 49.975 | 49.875 | 49.9 | 19200.0 |
| 2001-02-12 12:00:00 | IWM | ETF | 49.85 | 50.045 | 49.85 | 49.895 | 70600.0 |
| 2001-02-12 13:00:00 | IWM | ETF | 49.985 | 50.275 | 49.985 | 50.25 | 167400.0 |
| 2001-02-12 14:00:00 | IWM | ETF | 50.27 | 50.365 | 50.27 | 50.35 | 62800.0 |
| 2001-02-12 15:00:00 | IWM | ETF | 50.35 | 50.45 | 50.32 | 50.4 | 58800.0 |
| 2001-02-12 09:00:00 | DIA | ETF | 108.08 | 108.49 | 108.03 | 108.3 | 210200.0 |
| 2001-02-12 10:00:00 | DIA | ETF | 108.31 | 109.11 | 108.31 | 109.1 | 350600.0 |
| 2001-02-12 11:00:00 | DIA | ETF | 109.09 | 109.19 | 108.7 | 108.93 | 126000.0 |
| 2001-02-12 12:00:00 | DIA | ETF | 109.0 | 109.1 | 108.79 | 108.98 | 52900.0 |
| 2001-02-12 13:00:00 | DIA | ETF | 108.95 | 109.49 | 108.79 | 109.42 | 167600.0 |
| 2001-02-12 14:00:00 | DIA | ETF | 109.45 | 109.69 | 109.25 | 109.66 | 211200.0 |
| 2001-02-12 15:00:00 | DIA | ETF | 109.65 | 109.68 | 109.38 | 109.55 | 128800.0 |
| 2001-02-12 16:00:00 | DIA | ETF | 109.57 | 109.68 | 109.57 | 109.63 | 8300.0 |
> showing 34 of 200 rows — these rows as CSV