PREVIEW / etf_1hour / 2024-10-08
file: by_date/etf_1hour/2024/2024-10-08.parquet size: 575 KB rows: 21,369
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-10-08 04:00:00 | SPY | ETF | 568.09 | 568.54 | 567.85 | 568.48 | 18949.0 |
| 2024-10-08 05:00:00 | SPY | ETF | 568.55 | 569.91 | 568.55 | 569.71 | 32111.0 |
| 2024-10-08 06:00:00 | SPY | ETF | 569.8 | 570.07 | 569.31 | 570.05 | 50369.0 |
| 2024-10-08 07:00:00 | SPY | ETF | 570.05 | 570.24 | 569.6 | 569.98 | 362308.0 |
| 2024-10-08 08:00:00 | SPY | ETF | 569.62 | 570.15 | 567.07 | 569.73 | 189486.0 |
| 2024-10-08 09:00:00 | SPY | ETF | 569.79 | 570.86 | 569.5299 | 570.7403 | 3757047.0 |
| 2024-10-08 10:00:00 | SPY | ETF | 570.75 | 572.55 | 570.39 | 571.81 | 5081346.0 |
| 2024-10-08 11:00:00 | SPY | ETF | 571.8 | 572.33 | 571.25 | 572.275 | 2524875.0 |
| 2024-10-08 12:00:00 | SPY | ETF | 572.27 | 572.3299 | 571.4 | 571.87 | 1641372.0 |
| 2024-10-08 13:00:00 | SPY | ETF | 571.87 | 571.97 | 570.55 | 571.7458 | 1973037.0 |
| 2024-10-08 14:00:00 | SPY | ETF | 571.75 | 572.9 | 571.7 | 572.72 | 1978189.0 |
| 2024-10-08 15:00:00 | SPY | ETF | 572.71 | 573.78 | 572.31 | 573.13 | 7557126.0 |
| 2024-10-08 16:00:00 | SPY | ETF | 573.14 | 573.22 | 572.71 | 572.9 | 1873579.0 |
| 2024-10-08 17:00:00 | SPY | ETF | 572.9 | 573.17 | 572.76 | 572.92 | 174079.0 |
| 2024-10-08 18:00:00 | SPY | ETF | 572.94 | 572.9992 | 572.65 | 572.9 | 63890.0 |
| 2024-10-08 19:00:00 | SPY | ETF | 573.0 | 573.08 | 572.63 | 572.6801 | 28604.0 |
| 2024-10-08 04:00:00 | QQQ | ETF | 482.29 | 482.78 | 481.88 | 482.6 | 60081.0 |
| 2024-10-08 05:00:00 | QQQ | ETF | 482.7 | 484.3 | 482.7 | 483.93 | 59828.0 |
| 2024-10-08 06:00:00 | QQQ | ETF | 483.91 | 484.4 | 483.5 | 484.31 | 89714.0 |
| 2024-10-08 07:00:00 | QQQ | ETF | 484.26 | 484.52 | 483.82 | 484.3 | 94605.0 |
| 2024-10-08 08:00:00 | QQQ | ETF | 484.31 | 484.6 | 480.97 | 483.65 | 145812.0 |
| 2024-10-08 09:00:00 | QQQ | ETF | 483.71 | 485.88 | 483.57 | 485.86 | 2751676.0 |
| 2024-10-08 10:00:00 | QQQ | ETF | 485.88 | 488.65 | 485.8 | 487.83 | 4408385.0 |
| 2024-10-08 11:00:00 | QQQ | ETF | 487.87 | 488.34 | 487.16 | 488.25 | 1850527.0 |
| 2024-10-08 12:00:00 | QQQ | ETF | 488.24 | 488.245 | 486.9 | 487.66 | 1215071.0 |
| 2024-10-08 13:00:00 | QQQ | ETF | 487.6599 | 487.77 | 486.08 | 487.67 | 1884428.0 |
| 2024-10-08 14:00:00 | QQQ | ETF | 487.65 | 488.85 | 487.46 | 488.66 | 1494824.0 |
| 2024-10-08 15:00:00 | QQQ | ETF | 488.63 | 489.99 | 488.23 | 489.33 | 4540271.0 |
| 2024-10-08 16:00:00 | QQQ | ETF | 489.325 | 489.34 | 488.76 | 489.0 | 1888676.0 |
| 2024-10-08 17:00:00 | QQQ | ETF | 488.901 | 489.06 | 488.88 | 489.01 | 37533.0 |
| 2024-10-08 18:00:00 | QQQ | ETF | 489.06 | 489.12 | 488.7 | 489.06 | 39848.0 |
| 2024-10-08 19:00:00 | QQQ | ETF | 489.14 | 489.2 | 488.68 | 488.74 | 26252.0 |
| 2024-10-08 04:00:00 | IWM | ETF | 217.15 | 217.23 | 216.8 | 216.88 | 35302.0 |
| 2024-10-08 05:00:00 | IWM | ETF | 216.9 | 217.73 | 216.9 | 217.47 | 15266.0 |
| 2024-10-08 06:00:00 | IWM | ETF | 217.49 | 217.81 | 217.47 | 217.78 | 18198.0 |
| 2024-10-08 07:00:00 | IWM | ETF | 217.78 | 217.83 | 217.57 | 217.65 | 68594.0 |
| 2024-10-08 08:00:00 | IWM | ETF | 217.73 | 217.84 | 216.64 | 217.66 | 79096.0 |
| 2024-10-08 09:00:00 | IWM | ETF | 217.73 | 217.88 | 216.7 | 217.44 | 1803030.0 |
| 2024-10-08 10:00:00 | IWM | ETF | 217.46 | 218.16 | 216.89 | 217.82 | 2836269.0 |
| 2024-10-08 11:00:00 | IWM | ETF | 217.84 | 218.17 | 217.3811 | 218.15 | 1358744.0 |
| 2024-10-08 12:00:00 | IWM | ETF | 218.15 | 218.37 | 217.86 | 217.96 | 1266165.0 |
| 2024-10-08 13:00:00 | IWM | ETF | 217.98 | 218.035 | 217.36 | 217.85 | 1003836.0 |
| 2024-10-08 14:00:00 | IWM | ETF | 217.85 | 218.11 | 217.51 | 218.03 | 943799.0 |
| 2024-10-08 15:00:00 | IWM | ETF | 218.01 | 218.0499 | 217.54 | 217.61 | 2477799.0 |
| 2024-10-08 16:00:00 | IWM | ETF | 217.59 | 217.61 | 217.3995 | 217.43 | 1134588.0 |
| 2024-10-08 17:00:00 | IWM | ETF | 217.42 | 217.57 | 217.42 | 217.57 | 12857.0 |
| 2024-10-08 18:00:00 | IWM | ETF | 217.55 | 217.57 | 217.333 | 217.57 | 16149.0 |
| 2024-10-08 19:00:00 | IWM | ETF | 217.57 | 217.58 | 217.38 | 217.44 | 10017.0 |
| 2024-10-08 04:00:00 | DIA | ETF | 419.25 | 419.25 | 419.17 | 419.17 | 500.0 |
| 2024-10-08 06:00:00 | DIA | ETF | 420.1 | 420.25 | 419.91 | 420.21 | 1959.0 |
> showing 50 of 21,369 rows — these rows as CSV