PREVIEW / etf_1hour / 2024-12-02
file: by_date/etf_1hour/2024/2024-12-02.parquet size: 606 KB rows: 22,975
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-02 04:00:00 | SPY | ETF | 601.9 | 601.9 | 601.35 | 601.4 | 34798.0 |
| 2024-12-02 05:00:00 | SPY | ETF | 601.3 | 601.65 | 601.24 | 601.5 | 9319.0 |
| 2024-12-02 06:00:00 | SPY | ETF | 601.59 | 602.0 | 601.43 | 601.93 | 111881.0 |
| 2024-12-02 07:00:00 | SPY | ETF | 601.91 | 602.6 | 601.86 | 602.37 | 172623.0 |
| 2024-12-02 08:00:00 | SPY | ETF | 602.05 | 602.77 | 601.1 | 602.62 | 232840.0 |
| 2024-12-02 09:00:00 | SPY | ETF | 602.62 | 603.6798 | 602.47 | 602.8698 | 3614605.0 |
| 2024-12-02 10:00:00 | SPY | ETF | 602.88 | 603.57 | 602.47 | 602.7 | 2601553.0 |
| 2024-12-02 11:00:00 | SPY | ETF | 602.71 | 603.86 | 602.51 | 603.655 | 1781409.0 |
| 2024-12-02 12:00:00 | SPY | ETF | 603.6598 | 603.96 | 603.4 | 603.57 | 1565233.0 |
| 2024-12-02 13:00:00 | SPY | ETF | 603.53 | 603.8799 | 603.39 | 603.79 | 1432121.0 |
| 2024-12-02 14:00:00 | SPY | ETF | 603.79 | 603.985 | 603.05 | 603.935 | 2284369.0 |
| 2024-12-02 15:00:00 | SPY | ETF | 603.93 | 604.32 | 603.45 | 603.65 | 5512975.0 |
| 2024-12-02 16:00:00 | SPY | ETF | 603.65 | 604.2 | 603.58 | 603.66 | 2402585.0 |
| 2024-12-02 17:00:00 | SPY | ETF | 603.7 | 603.824 | 603.5 | 603.78 | 235807.0 |
| 2024-12-02 18:00:00 | SPY | ETF | 603.75 | 604.01 | 603.51 | 603.85 | 36357.0 |
| 2024-12-02 19:00:00 | SPY | ETF | 603.87 | 603.94 | 603.61 | 603.62 | 26791.0 |
| 2024-12-02 04:00:00 | QQQ | ETF | 509.51 | 509.51 | 508.78 | 508.78 | 54235.0 |
| 2024-12-02 05:00:00 | QQQ | ETF | 508.75 | 509.11 | 508.66 | 508.8 | 20889.0 |
| 2024-12-02 06:00:00 | QQQ | ETF | 508.96 | 509.25 | 508.79 | 509.25 | 13588.0 |
| 2024-12-02 07:00:00 | QQQ | ETF | 509.24 | 510.25 | 509.2 | 510.16 | 93631.0 |
| 2024-12-02 08:00:00 | QQQ | ETF | 510.16 | 510.85 | 508.63 | 510.68 | 210901.0 |
| 2024-12-02 09:00:00 | QQQ | ETF | 510.65 | 514.1 | 510.58 | 513.67 | 3727083.0 |
| 2024-12-02 10:00:00 | QQQ | ETF | 513.68 | 514.89 | 513.43 | 513.7635 | 2570234.0 |
| 2024-12-02 11:00:00 | QQQ | ETF | 513.79 | 515.72 | 513.7 | 515.53 | 1869473.0 |
| 2024-12-02 12:00:00 | QQQ | ETF | 515.515 | 516.26 | 515.44 | 515.51 | 1960290.0 |
| 2024-12-02 13:00:00 | QQQ | ETF | 515.51 | 515.64 | 514.73 | 515.16 | 1565925.0 |
| 2024-12-02 14:00:00 | QQQ | ETF | 515.14 | 515.37 | 514.27 | 515.31 | 1629648.0 |
| 2024-12-02 15:00:00 | QQQ | ETF | 515.28 | 515.8382 | 514.91 | 515.3 | 3502106.0 |
| 2024-12-02 16:00:00 | QQQ | ETF | 515.29 | 515.8 | 515.06 | 515.14 | 1341166.0 |
| 2024-12-02 17:00:00 | QQQ | ETF | 515.14 | 515.33 | 515.05 | 515.29 | 54468.0 |
| 2024-12-02 18:00:00 | QQQ | ETF | 515.29 | 515.45 | 514.98 | 515.25 | 29803.0 |
| 2024-12-02 19:00:00 | QQQ | ETF | 515.25 | 515.35 | 515.0 | 515.15 | 25309.0 |
| 2024-12-02 04:00:00 | IWM | ETF | 241.95 | 242.2 | 241.71 | 241.97 | 19371.0 |
| 2024-12-02 05:00:00 | IWM | ETF | 241.8 | 242.15 | 241.78 | 242.13 | 7316.0 |
| 2024-12-02 06:00:00 | IWM | ETF | 242.18 | 242.69 | 242.18 | 242.67 | 63162.0 |
| 2024-12-02 07:00:00 | IWM | ETF | 242.68 | 242.93 | 242.42 | 242.42 | 55088.0 |
| 2024-12-02 08:00:00 | IWM | ETF | 242.8812 | 242.8812 | 241.61 | 242.45 | 159779.0 |
| 2024-12-02 09:00:00 | IWM | ETF | 242.47 | 242.69 | 240.18 | 240.36 | 2623152.0 |
| 2024-12-02 10:00:00 | IWM | ETF | 240.42 | 242.0199 | 240.01 | 240.7 | 2920657.0 |
| 2024-12-02 11:00:00 | IWM | ETF | 240.68 | 241.54 | 240.22 | 241.25 | 1506160.0 |
| 2024-12-02 12:00:00 | IWM | ETF | 241.25 | 241.7899 | 241.19 | 241.57 | 988929.0 |
| 2024-12-02 13:00:00 | IWM | ETF | 241.54 | 242.35 | 241.37 | 242.26 | 1114918.0 |
| 2024-12-02 14:00:00 | IWM | ETF | 242.25 | 242.42 | 241.56 | 242.07 | 1379006.0 |
| 2024-12-02 15:00:00 | IWM | ETF | 242.03 | 242.66 | 241.64 | 241.815 | 3777589.0 |
| 2024-12-02 16:00:00 | IWM | ETF | 241.75 | 242.11 | 241.7333 | 241.98 | 2108248.0 |
| 2024-12-02 17:00:00 | IWM | ETF | 241.97 | 242.03 | 241.75 | 241.96 | 36449.0 |
| 2024-12-02 18:00:00 | IWM | ETF | 241.96 | 242.09 | 241.7 | 241.76 | 31923.0 |
| 2024-12-02 19:00:00 | IWM | ETF | 241.86 | 241.94 | 241.67 | 241.73 | 8036.0 |
| 2024-12-02 04:00:00 | DIA | ETF | 449.6 | 449.65 | 449.51 | 449.51 | 611.0 |
| 2024-12-02 05:00:00 | DIA | ETF | 449.63 | 449.86 | 449.6 | 449.6 | 555.0 |
> showing 50 of 22,975 rows — these rows as CSV