PREVIEW / etf_1hour / 2024-06-24
file: by_date/etf_1hour/2024/2024-06-24.parquet size: 545 KB rows: 20,399
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-24 04:00:00 | SPY | ETF | 545.12 | 545.73 | 544.4 | 545.38 | 21328.0 |
| 2024-06-24 05:00:00 | SPY | ETF | 545.49 | 545.49 | 544.63 | 544.87 | 11086.0 |
| 2024-06-24 06:00:00 | SPY | ETF | 544.95 | 545.32 | 544.83 | 545.26 | 13137.0 |
| 2024-06-24 07:00:00 | SPY | ETF | 545.25 | 545.4 | 544.85 | 544.91 | 68238.0 |
| 2024-06-24 08:00:00 | SPY | ETF | 545.27 | 545.4 | 543.8 | 544.39 | 115266.0 |
| 2024-06-24 09:00:00 | SPY | ETF | 544.39 | 545.802 | 543.76 | 545.655 | 3314900.0 |
| 2024-06-24 10:00:00 | SPY | ETF | 545.65 | 546.95 | 544.66 | 545.98 | 5100234.0 |
| 2024-06-24 11:00:00 | SPY | ETF | 545.97 | 546.34 | 545.54 | 546.17 | 2404554.0 |
| 2024-06-24 12:00:00 | SPY | ETF | 546.15 | 546.226 | 544.85 | 545.0999 | 1652822.0 |
| 2024-06-24 13:00:00 | SPY | ETF | 545.1 | 545.3 | 543.61 | 543.975 | 2829476.0 |
| 2024-06-24 14:00:00 | SPY | ETF | 543.98 | 544.6172 | 543.425 | 544.225 | 3287916.0 |
| 2024-06-24 15:00:00 | SPY | ETF | 544.22 | 544.66 | 542.63 | 542.65 | 8542948.0 |
| 2024-06-24 16:00:00 | SPY | ETF | 542.63 | 542.91 | 542.21 | 542.79 | 3809686.0 |
| 2024-06-24 17:00:00 | SPY | ETF | 542.7989 | 542.95 | 542.75 | 542.88 | 69169.0 |
| 2024-06-24 18:00:00 | SPY | ETF | 542.84 | 543.02 | 542.64 | 542.96 | 420689.0 |
| 2024-06-24 19:00:00 | SPY | ETF | 542.9 | 543.11 | 542.89 | 543.08 | 11172.0 |
| 2024-06-24 04:00:00 | QQQ | ETF | 480.0 | 480.71 | 479.82 | 480.2 | 38087.0 |
| 2024-06-24 05:00:00 | QQQ | ETF | 480.04 | 480.22 | 478.57 | 478.83 | 65302.0 |
| 2024-06-24 06:00:00 | QQQ | ETF | 479.0 | 479.42 | 478.8 | 479.29 | 42238.0 |
| 2024-06-24 07:00:00 | QQQ | ETF | 479.25 | 479.64 | 478.89 | 478.91 | 154374.0 |
| 2024-06-24 08:00:00 | QQQ | ETF | 479.41 | 480.57 | 478.21 | 478.45 | 246124.0 |
| 2024-06-24 09:00:00 | QQQ | ETF | 478.45 | 479.21 | 476.82 | 478.7 | 3101373.0 |
| 2024-06-24 10:00:00 | QQQ | ETF | 478.73 | 479.93 | 475.77 | 477.79 | 4262537.0 |
| 2024-06-24 11:00:00 | QQQ | ETF | 477.8 | 478.42 | 477.0 | 478.07 | 2169333.0 |
| 2024-06-24 12:00:00 | QQQ | ETF | 478.06 | 478.1599 | 476.26 | 476.49 | 1474642.0 |
| 2024-06-24 13:00:00 | QQQ | ETF | 476.485 | 476.8492 | 474.99 | 475.4839 | 2791139.0 |
| 2024-06-24 14:00:00 | QQQ | ETF | 475.51 | 476.095 | 474.51 | 475.76 | 3135899.0 |
| 2024-06-24 15:00:00 | QQQ | ETF | 475.765 | 476.56 | 473.82 | 473.91 | 6549386.0 |
| 2024-06-24 16:00:00 | QQQ | ETF | 473.93 | 474.42 | 473.55 | 474.1 | 2515433.0 |
| 2024-06-24 17:00:00 | QQQ | ETF | 474.02 | 474.22 | 474.01 | 474.11 | 68971.0 |
| 2024-06-24 18:00:00 | QQQ | ETF | 474.2 | 474.46 | 473.96 | 474.26 | 106331.0 |
| 2024-06-24 19:00:00 | QQQ | ETF | 474.21 | 474.56 | 474.17 | 474.56 | 59495.0 |
| 2024-06-24 04:00:00 | IWM | ETF | 200.6 | 201.04 | 200.6 | 200.93 | 18682.0 |
| 2024-06-24 05:00:00 | IWM | ETF | 200.98 | 201.09 | 200.8 | 200.91 | 20453.0 |
| 2024-06-24 06:00:00 | IWM | ETF | 200.91 | 201.2 | 200.72 | 201.15 | 9935.0 |
| 2024-06-24 07:00:00 | IWM | ETF | 201.04 | 201.13 | 200.81 | 200.94 | 53933.0 |
| 2024-06-24 08:00:00 | IWM | ETF | 200.98 | 201.12 | 199.86 | 200.69 | 45341.0 |
| 2024-06-24 09:00:00 | IWM | ETF | 200.69 | 202.47 | 200.38 | 202.28 | 2640462.0 |
| 2024-06-24 10:00:00 | IWM | ETF | 202.27 | 202.58 | 201.515 | 202.57 | 2971205.0 |
| 2024-06-24 11:00:00 | IWM | ETF | 202.565 | 202.69 | 201.88 | 202.1095 | 2778069.0 |
| 2024-06-24 12:00:00 | IWM | ETF | 202.1 | 202.14 | 201.39 | 201.52 | 1358465.0 |
| 2024-06-24 13:00:00 | IWM | ETF | 201.52 | 201.645 | 201.06 | 201.3901 | 1564610.0 |
| 2024-06-24 14:00:00 | IWM | ETF | 201.38 | 202.3 | 201.3 | 202.14 | 1837109.0 |
| 2024-06-24 15:00:00 | IWM | ETF | 202.135 | 202.3 | 201.17 | 201.18 | 3137897.0 |
| 2024-06-24 16:00:00 | IWM | ETF | 201.18 | 201.43 | 201.0 | 201.4103 | 968952.0 |
| 2024-06-24 17:00:00 | IWM | ETF | 201.36 | 201.48 | 201.27 | 201.27 | 12409.0 |
| 2024-06-24 18:00:00 | IWM | ETF | 201.42 | 201.51 | 201.22 | 201.35 | 24353.0 |
| 2024-06-24 19:00:00 | IWM | ETF | 201.31 | 201.36 | 201.26 | 201.31 | 9654.0 |
| 2024-06-24 04:00:00 | DIA | ETF | 391.95 | 392.2 | 391.95 | 392.2 | 1300.0 |
| 2024-06-24 05:00:00 | DIA | ETF | 392.38 | 392.65 | 392.34 | 392.65 | 3900.0 |
> showing 50 of 20,399 rows — these rows as CSV