PREVIEW / etf_1hour / 2024-12-17
file: by_date/etf_1hour/2024/2024-12-17.parquet size: 610 KB rows: 23,170
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-17 04:00:00 | SPY | ETF | 605.35 | 605.36 | 604.8 | 605.33 | 37219.0 |
| 2024-12-17 05:00:00 | SPY | ETF | 605.37 | 605.42 | 605.0 | 605.39 | 3765.0 |
| 2024-12-17 06:00:00 | SPY | ETF | 605.14 | 605.62 | 604.85 | 605.02 | 30237.0 |
| 2024-12-17 07:00:00 | SPY | ETF | 605.09 | 605.25 | 604.66 | 604.68 | 137807.0 |
| 2024-12-17 08:00:00 | SPY | ETF | 604.86 | 606.46 | 604.02 | 604.6 | 281322.0 |
| 2024-12-17 09:00:00 | SPY | ETF | 604.6 | 604.9 | 603.6004 | 604.4 | 3286531.0 |
| 2024-12-17 10:00:00 | SPY | ETF | 604.38 | 604.41 | 603.16 | 603.935 | 3676276.0 |
| 2024-12-17 11:00:00 | SPY | ETF | 603.935 | 605.17 | 603.85 | 604.94 | 2745824.0 |
| 2024-12-17 12:00:00 | SPY | ETF | 604.94 | 604.97 | 604.26 | 604.82 | 1926279.0 |
| 2024-12-17 13:00:00 | SPY | ETF | 604.79 | 604.79 | 604.02 | 604.25 | 1652565.0 |
| 2024-12-17 14:00:00 | SPY | ETF | 604.24 | 604.3 | 603.25 | 603.41 | 3608588.0 |
| 2024-12-17 15:00:00 | SPY | ETF | 603.4 | 604.74 | 602.885 | 604.24 | 8437883.0 |
| 2024-12-17 16:00:00 | SPY | ETF | 604.22 | 604.47 | 603.66 | 604.03 | 7137195.0 |
| 2024-12-17 17:00:00 | SPY | ETF | 604.0 | 604.15 | 603.92 | 604.15 | 18775.0 |
| 2024-12-17 18:00:00 | SPY | ETF | 604.14 | 604.15 | 602.87 | 603.9 | 39247.0 |
| 2024-12-17 19:00:00 | SPY | ETF | 603.82 | 604.17 | 603.82 | 604.09 | 22054.0 |
| 2024-12-17 04:00:00 | QQQ | ETF | 537.48 | 537.8 | 536.54 | 537.68 | 68151.0 |
| 2024-12-17 05:00:00 | QQQ | ETF | 537.77 | 538.2 | 537.42 | 538.18 | 37797.0 |
| 2024-12-17 06:00:00 | QQQ | ETF | 538.1 | 538.51 | 537.37 | 537.7 | 54724.0 |
| 2024-12-17 07:00:00 | QQQ | ETF | 537.68 | 537.9 | 536.8 | 536.8 | 121106.0 |
| 2024-12-17 08:00:00 | QQQ | ETF | 537.07 | 538.573 | 536.2 | 536.74 | 304293.0 |
| 2024-12-17 09:00:00 | QQQ | ETF | 536.76 | 537.15 | 535.04 | 535.6899 | 3207017.0 |
| 2024-12-17 10:00:00 | QQQ | ETF | 535.63 | 535.89 | 534.13 | 535.65 | 3169163.0 |
| 2024-12-17 11:00:00 | QQQ | ETF | 535.61 | 537.48 | 535.04 | 536.42 | 2643485.0 |
| 2024-12-17 12:00:00 | QQQ | ETF | 536.43 | 536.8177 | 535.38 | 536.42 | 1886154.0 |
| 2024-12-17 13:00:00 | QQQ | ETF | 536.35 | 536.56 | 535.51 | 535.6 | 1664149.0 |
| 2024-12-17 14:00:00 | QQQ | ETF | 535.61 | 535.64 | 534.68 | 535.02 | 1859078.0 |
| 2024-12-17 15:00:00 | QQQ | ETF | 535.0 | 536.21 | 534.35 | 535.85 | 3270522.0 |
| 2024-12-17 16:00:00 | QQQ | ETF | 535.86 | 535.9 | 535.18 | 535.58 | 889077.0 |
| 2024-12-17 17:00:00 | QQQ | ETF | 535.56 | 535.83 | 535.43 | 535.71 | 21734.0 |
| 2024-12-17 18:00:00 | QQQ | ETF | 535.67 | 535.67 | 533.14 | 534.8101 | 243974.0 |
| 2024-12-17 19:00:00 | QQQ | ETF | 534.8 | 535.3 | 534.8 | 535.13 | 32122.0 |
| 2024-12-17 04:00:00 | IWM | ETF | 233.05 | 233.57 | 233.0 | 233.57 | 20063.0 |
| 2024-12-17 05:00:00 | IWM | ETF | 233.66 | 233.66 | 233.3 | 233.4 | 7426.0 |
| 2024-12-17 06:00:00 | IWM | ETF | 233.35 | 233.6 | 233.07 | 233.24 | 40660.0 |
| 2024-12-17 07:00:00 | IWM | ETF | 233.22 | 233.35 | 232.42 | 232.47 | 121188.0 |
| 2024-12-17 08:00:00 | IWM | ETF | 232.73 | 233.58 | 231.99 | 232.84 | 285834.0 |
| 2024-12-17 09:00:00 | IWM | ETF | 232.84 | 233.44 | 232.02 | 232.48 | 3262994.0 |
| 2024-12-17 10:00:00 | IWM | ETF | 232.47 | 232.56 | 230.605 | 231.1701 | 4223176.0 |
| 2024-12-17 11:00:00 | IWM | ETF | 231.17 | 232.06 | 231.0 | 231.79 | 2157878.0 |
| 2024-12-17 12:00:00 | IWM | ETF | 231.79 | 232.16 | 231.16 | 232.09 | 1230775.0 |
| 2024-12-17 13:00:00 | IWM | ETF | 232.08 | 232.19 | 231.34 | 231.8803 | 1115923.0 |
| 2024-12-17 14:00:00 | IWM | ETF | 231.885 | 232.0 | 231.1301 | 231.295 | 2226729.0 |
| 2024-12-17 15:00:00 | IWM | ETF | 231.29 | 231.51 | 230.55 | 231.06 | 5070657.0 |
| 2024-12-17 16:00:00 | IWM | ETF | 231.07 | 231.2 | 230.81 | 230.9 | 1339268.0 |
| 2024-12-17 17:00:00 | IWM | ETF | 230.92 | 231.89 | 230.9 | 231.0 | 22595.0 |
| 2024-12-17 18:00:00 | IWM | ETF | 231.0 | 231.16 | 230.64 | 230.97 | 34550.0 |
| 2024-12-17 19:00:00 | IWM | ETF | 230.98 | 231.17 | 230.95 | 230.95 | 52535.0 |
| 2024-12-17 04:00:00 | DIA | ETF | 436.73 | 437.11 | 436.73 | 437.0 | 2149.0 |
| 2024-12-17 05:00:00 | DIA | ETF | 436.96 | 436.96 | 436.81 | 436.81 | 882.0 |
> showing 50 of 23,170 rows — these rows as CSV