PREVIEW / etf_1hour / 2024-06-27
file: by_date/etf_1hour/2024/2024-06-27.parquet size: 534 KB rows: 19,873
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-06-27 04:00:00 | SPY | ETF | 544.7 | 544.84 | 544.41 | 544.72 | 17231.0 |
| 2024-06-27 05:00:00 | SPY | ETF | 544.68 | 545.05 | 544.6 | 545.03 | 8998.0 |
| 2024-06-27 06:00:00 | SPY | ETF | 545.0 | 545.35 | 544.96 | 545.16 | 8118.0 |
| 2024-06-27 07:00:00 | SPY | ETF | 545.18 | 545.18 | 544.77 | 544.95 | 61141.0 |
| 2024-06-27 08:00:00 | SPY | ETF | 545.05 | 545.75 | 543.92 | 545.72 | 182703.0 |
| 2024-06-27 09:00:00 | SPY | ETF | 545.67 | 546.84 | 545.14 | 546.11 | 2649672.0 |
| 2024-06-27 10:00:00 | SPY | ETF | 546.1 | 546.96 | 545.62 | 545.99 | 3006921.0 |
| 2024-06-27 11:00:00 | SPY | ETF | 545.97 | 546.04 | 544.67 | 545.225 | 2869035.0 |
| 2024-06-27 12:00:00 | SPY | ETF | 545.25 | 546.1 | 545.1 | 545.66 | 2324126.0 |
| 2024-06-27 13:00:00 | SPY | ETF | 545.64 | 546.43 | 545.64 | 545.78 | 1400787.0 |
| 2024-06-27 14:00:00 | SPY | ETF | 545.79 | 545.8 | 544.61 | 545.39 | 2808227.0 |
| 2024-06-27 15:00:00 | SPY | ETF | 545.4 | 546.4 | 545.18 | 546.35 | 5745991.0 |
| 2024-06-27 16:00:00 | SPY | ETF | 546.34 | 546.69 | 545.6308 | 546.44 | 2796132.0 |
| 2024-06-27 17:00:00 | SPY | ETF | 546.44 | 547.19 | 546.13 | 546.47 | 206927.0 |
| 2024-06-27 18:00:00 | SPY | ETF | 546.43 | 546.78 | 546.37 | 546.7 | 54385.0 |
| 2024-06-27 19:00:00 | SPY | ETF | 546.74 | 547.08 | 546.74 | 547.08 | 31644.0 |
| 2024-06-27 04:00:00 | QQQ | ETF | 479.13 | 479.46 | 478.76 | 479.46 | 39551.0 |
| 2024-06-27 05:00:00 | QQQ | ETF | 479.3 | 479.81 | 479.19 | 479.78 | 14501.0 |
| 2024-06-27 06:00:00 | QQQ | ETF | 479.71 | 480.15 | 479.67 | 479.94 | 33461.0 |
| 2024-06-27 07:00:00 | QQQ | ETF | 479.93 | 479.97 | 479.4 | 479.71 | 129253.0 |
| 2024-06-27 08:00:00 | QQQ | ETF | 479.42 | 480.45 | 479.0904 | 480.41 | 230418.0 |
| 2024-06-27 09:00:00 | QQQ | ETF | 480.43 | 482.76 | 480.1 | 481.77 | 2810617.0 |
| 2024-06-27 10:00:00 | QQQ | ETF | 481.75 | 483.1 | 480.41 | 481.0561 | 2660406.0 |
| 2024-06-27 11:00:00 | QQQ | ETF | 481.06 | 481.27 | 479.3 | 480.13 | 2160778.0 |
| 2024-06-27 12:00:00 | QQQ | ETF | 480.1 | 481.78 | 479.92 | 481.12 | 1363067.0 |
| 2024-06-27 13:00:00 | QQQ | ETF | 481.18 | 482.0 | 480.9799 | 481.23 | 989387.0 |
| 2024-06-27 14:00:00 | QQQ | ETF | 481.24 | 481.53 | 480.29 | 481.46 | 1602949.0 |
| 2024-06-27 15:00:00 | QQQ | ETF | 481.48 | 481.86 | 480.41 | 481.57 | 2333458.0 |
| 2024-06-27 16:00:00 | QQQ | ETF | 481.53 | 482.29 | 480.7231 | 482.04 | 747400.0 |
| 2024-06-27 17:00:00 | QQQ | ETF | 482.01 | 482.22 | 481.48 | 482.05 | 151620.0 |
| 2024-06-27 18:00:00 | QQQ | ETF | 482.07 | 482.53 | 481.61 | 482.37 | 114119.0 |
| 2024-06-27 19:00:00 | QQQ | ETF | 482.46 | 482.73 | 482.46 | 482.697 | 26535.0 |
| 2024-06-27 04:00:00 | IWM | ETF | 199.96 | 200.08 | 199.66 | 199.78 | 12302.0 |
| 2024-06-27 05:00:00 | IWM | ETF | 199.72 | 199.92 | 199.72 | 199.88 | 6373.0 |
| 2024-06-27 06:00:00 | IWM | ETF | 199.85 | 199.94 | 199.81 | 199.88 | 7044.0 |
| 2024-06-27 07:00:00 | IWM | ETF | 199.9 | 199.93 | 199.73 | 199.89 | 15669.0 |
| 2024-06-27 08:00:00 | IWM | ETF | 199.8 | 200.87 | 199.49 | 200.87 | 164553.0 |
| 2024-06-27 09:00:00 | IWM | ETF | 200.79 | 201.39 | 199.96 | 201.08 | 2594034.0 |
| 2024-06-27 10:00:00 | IWM | ETF | 201.08 | 201.45 | 200.65 | 200.85 | 1797000.0 |
| 2024-06-27 11:00:00 | IWM | ETF | 200.84 | 200.86 | 200.16 | 200.63 | 1465244.0 |
| 2024-06-27 12:00:00 | IWM | ETF | 200.63 | 201.09 | 200.49 | 200.88 | 822138.0 |
| 2024-06-27 13:00:00 | IWM | ETF | 200.9 | 201.44 | 200.9 | 201.26 | 1263296.0 |
| 2024-06-27 14:00:00 | IWM | ETF | 201.25 | 201.41 | 200.825 | 201.37 | 1191685.0 |
| 2024-06-27 15:00:00 | IWM | ETF | 201.37 | 202.15 | 201.23 | 202.1 | 3505711.0 |
| 2024-06-27 16:00:00 | IWM | ETF | 202.06 | 202.39 | 200.06 | 202.24 | 835771.0 |
| 2024-06-27 17:00:00 | IWM | ETF | 202.259 | 202.32 | 202.0 | 202.08 | 39721.0 |
| 2024-06-27 18:00:00 | IWM | ETF | 202.18 | 202.42 | 202.18 | 202.4 | 19021.0 |
| 2024-06-27 19:00:00 | IWM | ETF | 202.43 | 202.55 | 202.42 | 202.55 | 19735.0 |
| 2024-06-27 04:00:00 | DIA | ETF | 390.42 | 390.42 | 390.42 | 390.42 | 300.0 |
| 2024-06-27 06:00:00 | DIA | ETF | 390.63 | 390.71 | 390.63 | 390.71 | 389.0 |
> showing 50 of 19,873 rows — these rows as CSV