PREVIEW / etf_1hour / 2001-02-13
file: by_date/etf_1hour/2001/2001-02-13.parquet size: 11 KB rows: 212
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-13 09:00:00 | SPY | ETF | 133.7 | 133.84 | 133.22 | 133.8 | 1336800.0 |
| 2001-02-13 10:00:00 | SPY | ETF | 133.73 | 134.17 | 133.26 | 133.59 | 1198100.0 |
| 2001-02-13 11:00:00 | SPY | ETF | 133.51 | 133.94 | 133.41 | 133.77 | 488100.0 |
| 2001-02-13 12:00:00 | SPY | ETF | 133.81 | 133.96 | 133.5 | 133.8 | 483500.0 |
| 2001-02-13 13:00:00 | SPY | ETF | 133.78 | 133.84 | 133.02 | 133.02 | 542700.0 |
| 2001-02-13 14:00:00 | SPY | ETF | 133.01 | 133.49 | 132.73 | 132.74 | 634800.0 |
| 2001-02-13 15:00:00 | SPY | ETF | 132.77 | 132.92 | 132.0 | 132.12 | 1194600.0 |
| 2001-02-13 16:00:00 | SPY | ETF | 132.12 | 132.5 | 132.0 | 132.26 | 580300.0 |
| 2001-02-13 09:00:00 | QQQ | ETF | 57.65 | 58.85 | 57.6 | 58.6 | 8283400.0 |
| 2001-02-13 10:00:00 | QQQ | ETF | 58.6 | 59.15 | 58.0 | 58.47 | 12534800.0 |
| 2001-02-13 11:00:00 | QQQ | ETF | 58.47 | 58.79 | 58.25 | 58.37 | 3445500.0 |
| 2001-02-13 12:00:00 | QQQ | ETF | 58.33 | 58.58 | 58.14 | 58.38 | 3635800.0 |
| 2001-02-13 13:00:00 | QQQ | ETF | 58.4 | 58.45 | 56.86 | 56.95 | 8008800.0 |
| 2001-02-13 14:00:00 | QQQ | ETF | 56.95 | 57.34 | 56.35 | 56.47 | 7420000.0 |
| 2001-02-13 15:00:00 | QQQ | ETF | 56.46 | 56.48 | 55.0 | 55.1 | 9915500.0 |
| 2001-02-13 16:00:00 | QQQ | ETF | 55.1 | 58.45 | 54.5 | 55.32 | 2607000.0 |
| 2001-02-13 17:00:00 | QQQ | ETF | 55.34 | 55.5 | 55.0 | 55.03 | 86600.0 |
| 2001-02-13 18:00:00 | QQQ | ETF | 55.05 | 55.25 | 55.03 | 55.15 | 14200.0 |
| 2001-02-13 09:00:00 | IWM | ETF | 50.825 | 51.025 | 50.675 | 50.975 | 404200.0 |
| 2001-02-13 10:00:00 | IWM | ETF | 51.175 | 51.25 | 50.875 | 51.0 | 152400.0 |
| 2001-02-13 11:00:00 | IWM | ETF | 51.175 | 51.225 | 50.95 | 50.955 | 80400.0 |
| 2001-02-13 12:00:00 | IWM | ETF | 51.1 | 51.1 | 50.85 | 50.95 | 65600.0 |
| 2001-02-13 13:00:00 | IWM | ETF | 50.875 | 50.98 | 50.675 | 50.835 | 68400.0 |
| 2001-02-13 14:00:00 | IWM | ETF | 50.8 | 50.825 | 50.5 | 50.5 | 9800.0 |
| 2001-02-13 15:00:00 | IWM | ETF | 50.575 | 50.585 | 49.95 | 50.05 | 122600.0 |
| 2001-02-13 16:00:00 | IWM | ETF | 49.925 | 49.925 | 49.925 | 49.925 | 7400.0 |
| 2001-02-13 09:00:00 | DIA | ETF | 109.7 | 109.8 | 109.36 | 109.65 | 248100.0 |
| 2001-02-13 10:00:00 | DIA | ETF | 109.68 | 110.0 | 109.65 | 109.95 | 420400.0 |
| 2001-02-13 11:00:00 | DIA | ETF | 109.77 | 110.22 | 109.71 | 110.12 | 330700.0 |
| 2001-02-13 12:00:00 | DIA | ETF | 110.15 | 110.4 | 109.86 | 110.07 | 178300.0 |
| 2001-02-13 13:00:00 | DIA | ETF | 110.19 | 110.19 | 109.4 | 109.45 | 750600.0 |
| 2001-02-13 14:00:00 | DIA | ETF | 109.41 | 109.9 | 109.31 | 109.63 | 140900.0 |
| 2001-02-13 15:00:00 | DIA | ETF | 109.58 | 109.58 | 109.04 | 109.1 | 212400.0 |
| 2001-02-13 16:00:00 | DIA | ETF | 109.1 | 109.3 | 109.07 | 109.25 | 54600.0 |
> showing 34 of 212 rows — these rows as CSV