PREVIEW / etf_1hour / 2024-06-28
file: by_date/etf_1hour/2024/2024-06-28.parquet size: 541 KB rows: 20,241
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-28 04:00:00 | SPY | ETF | 547.78 | 548.19 | 547.6 | 548.19 | 11372.0 |
| 2024-06-28 05:00:00 | SPY | ETF | 548.12 | 548.57 | 548.11 | 548.49 | 25215.0 |
| 2024-06-28 06:00:00 | SPY | ETF | 548.39 | 548.48 | 548.24 | 548.45 | 48848.0 |
| 2024-06-28 07:00:00 | SPY | ETF | 548.45 | 548.48 | 548.02 | 548.31 | 208185.0 |
| 2024-06-28 08:00:00 | SPY | ETF | 548.35 | 549.01 | 547.44 | 547.56 | 444311.0 |
| 2024-06-28 09:00:00 | SPY | ETF | 547.64 | 548.26 | 546.67 | 548.055 | 3458055.0 |
| 2024-06-28 10:00:00 | SPY | ETF | 548.05 | 550.28 | 548.04 | 548.63 | 6513166.0 |
| 2024-06-28 11:00:00 | SPY | ETF | 548.62 | 548.63 | 547.25 | 547.72 | 3935590.0 |
| 2024-06-28 12:00:00 | SPY | ETF | 547.71 | 547.83 | 545.49 | 546.33 | 4024279.0 |
| 2024-06-28 13:00:00 | SPY | ETF | 546.32 | 546.99 | 545.85 | 546.03 | 2542263.0 |
| 2024-06-28 14:00:00 | SPY | ETF | 546.0234 | 546.58 | 544.95 | 545.1 | 4639352.0 |
| 2024-06-28 15:00:00 | SPY | ETF | 545.105 | 545.47 | 542.95 | 544.09 | 17511621.0 |
| 2024-06-28 16:00:00 | SPY | ETF | 544.12 | 545.24 | 543.9565 | 545.06 | 6308463.0 |
| 2024-06-28 17:00:00 | SPY | ETF | 545.05 | 545.05 | 544.8 | 544.9 | 138880.0 |
| 2024-06-28 18:00:00 | SPY | ETF | 544.94 | 545.06 | 544.87 | 544.98 | 15999.0 |
| 2024-06-28 19:00:00 | SPY | ETF | 544.9804 | 545.18 | 544.93 | 545.1216 | 29833.0 |
| 2024-06-28 04:00:00 | QQQ | ETF | 483.38 | 483.47 | 482.94 | 483.35 | 32486.0 |
| 2024-06-28 05:00:00 | QQQ | ETF | 483.5 | 483.86 | 483.43 | 483.81 | 36108.0 |
| 2024-06-28 06:00:00 | QQQ | ETF | 483.74 | 483.83 | 483.51 | 483.75 | 28358.0 |
| 2024-06-28 07:00:00 | QQQ | ETF | 483.72 | 483.79 | 483.54 | 483.725 | 83456.0 |
| 2024-06-28 08:00:00 | QQQ | ETF | 483.7 | 485.31 | 481.249 | 482.66 | 526592.0 |
| 2024-06-28 09:00:00 | QQQ | ETF | 482.659 | 484.27 | 481.67 | 484.24 | 2603153.0 |
| 2024-06-28 10:00:00 | QQQ | ETF | 484.24 | 487.2 | 483.56 | 484.07 | 4694627.0 |
| 2024-06-28 11:00:00 | QQQ | ETF | 484.07 | 484.07 | 482.56 | 483.335 | 2697373.0 |
| 2024-06-28 12:00:00 | QQQ | ETF | 483.32 | 483.48 | 480.39 | 481.59 | 2908281.0 |
| 2024-06-28 13:00:00 | QQQ | ETF | 481.58 | 482.45 | 481.13 | 481.6512 | 1487349.0 |
| 2024-06-28 14:00:00 | QQQ | ETF | 481.595 | 482.43 | 480.82 | 481.0001 | 1533553.0 |
| 2024-06-28 15:00:00 | QQQ | ETF | 481.02 | 481.11 | 478.46 | 478.98 | 6976462.0 |
| 2024-06-28 16:00:00 | QQQ | ETF | 478.98 | 480.07 | 478.87 | 479.82 | 1610281.0 |
| 2024-06-28 17:00:00 | QQQ | ETF | 479.8009 | 479.8475 | 479.11 | 479.52 | 127539.0 |
| 2024-06-28 18:00:00 | QQQ | ETF | 479.6999 | 479.6999 | 479.42 | 479.55 | 3457.0 |
| 2024-06-28 19:00:00 | QQQ | ETF | 479.58 | 479.7 | 479.44 | 479.54 | 9441.0 |
| 2024-06-28 04:00:00 | IWM | ETF | 203.02 | 203.53 | 202.75 | 203.4 | 81487.0 |
| 2024-06-28 05:00:00 | IWM | ETF | 203.37 | 203.49 | 203.26 | 203.44 | 21254.0 |
| 2024-06-28 06:00:00 | IWM | ETF | 203.45 | 203.99 | 203.3 | 203.94 | 47365.0 |
| 2024-06-28 07:00:00 | IWM | ETF | 203.93 | 203.97 | 203.6 | 203.85 | 272102.0 |
| 2024-06-28 08:00:00 | IWM | ETF | 203.8 | 204.3 | 202.76 | 203.9 | 466025.0 |
| 2024-06-28 09:00:00 | IWM | ETF | 203.901 | 204.635 | 202.8 | 202.85 | 5069506.0 |
| 2024-06-28 10:00:00 | IWM | ETF | 202.87 | 204.16 | 202.86 | 203.495 | 3037570.0 |
| 2024-06-28 11:00:00 | IWM | ETF | 203.49 | 203.49 | 202.59 | 203.2699 | 2845381.0 |
| 2024-06-28 12:00:00 | IWM | ETF | 203.26 | 203.305 | 202.24 | 202.44 | 2205380.0 |
| 2024-06-28 13:00:00 | IWM | ETF | 202.39 | 202.86 | 201.88 | 202.07 | 1481647.0 |
| 2024-06-28 14:00:00 | IWM | ETF | 202.06 | 202.46 | 201.965 | 202.24 | 1870653.0 |
| 2024-06-28 15:00:00 | IWM | ETF | 202.235 | 202.95 | 201.315 | 202.91 | 7617394.0 |
| 2024-06-28 16:00:00 | IWM | ETF | 202.92 | 203.41 | 202.83 | 203.15 | 3475828.0 |
| 2024-06-28 17:00:00 | IWM | ETF | 203.12 | 203.14 | 202.88 | 202.91 | 48224.0 |
| 2024-06-28 18:00:00 | IWM | ETF | 202.92 | 203.0 | 202.87 | 202.88 | 21492.0 |
| 2024-06-28 19:00:00 | IWM | ETF | 202.9 | 203.0 | 202.87 | 203.0 | 18905.0 |
| 2024-06-28 04:00:00 | DIA | ETF | 391.69 | 391.94 | 391.65 | 391.94 | 1613.0 |
| 2024-06-28 05:00:00 | DIA | ETF | 392.05 | 392.06 | 392.05 | 392.06 | 1200.0 |
> showing 50 of 20,241 rows — these rows as CSV