PREVIEW / etf_1hour / 2024-07-02
file: by_date/etf_1hour/2024/2024-07-02.parquet size: 545 KB rows: 20,368
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-07-02 04:00:00 | SPY | ETF | 543.98 | 544.28 | 542.97 | 543.49 | 18355.0 |
| 2024-07-02 05:00:00 | SPY | ETF | 543.48 | 543.67 | 543.05 | 543.34 | 6385.0 |
| 2024-07-02 06:00:00 | SPY | ETF | 543.35 | 543.63 | 543.25 | 543.42 | 17843.0 |
| 2024-07-02 07:00:00 | SPY | ETF | 543.46 | 543.48 | 542.44 | 542.97 | 209399.0 |
| 2024-07-02 08:00:00 | SPY | ETF | 542.93 | 544.8 | 542.5097 | 543.24 | 136266.0 |
| 2024-07-02 09:00:00 | SPY | ETF | 543.24 | 545.68 | 543.24 | 545.125 | 3088224.0 |
| 2024-07-02 10:00:00 | SPY | ETF | 545.14 | 545.97 | 544.47 | 545.76 | 2907216.0 |
| 2024-07-02 11:00:00 | SPY | ETF | 545.76 | 546.51 | 545.44 | 545.65 | 2271723.0 |
| 2024-07-02 12:00:00 | SPY | ETF | 545.64 | 546.0 | 545.12 | 546.0 | 1843172.0 |
| 2024-07-02 13:00:00 | SPY | ETF | 546.0 | 547.48 | 545.9 | 547.275 | 2405312.0 |
| 2024-07-02 14:00:00 | SPY | ETF | 547.28 | 547.98 | 547.2404 | 547.64 | 2420224.0 |
| 2024-07-02 15:00:00 | SPY | ETF | 547.63 | 548.98 | 547.48 | 548.97 | 7709196.0 |
| 2024-07-02 16:00:00 | SPY | ETF | 548.97 | 549.01 | 548.12 | 548.29 | 2694492.0 |
| 2024-07-02 17:00:00 | SPY | ETF | 548.33 | 548.8246 | 548.17 | 548.37 | 225273.0 |
| 2024-07-02 18:00:00 | SPY | ETF | 548.26 | 548.6 | 548.19 | 548.56 | 41955.0 |
| 2024-07-02 19:00:00 | SPY | ETF | 548.511 | 548.82 | 548.17 | 548.2599 | 33847.0 |
| 2024-07-02 04:00:00 | QQQ | ETF | 480.0 | 480.22 | 479.46 | 479.91 | 28928.0 |
| 2024-07-02 05:00:00 | QQQ | ETF | 479.99 | 480.07 | 479.48 | 479.9 | 22178.0 |
| 2024-07-02 06:00:00 | QQQ | ETF | 479.8 | 479.99 | 479.54 | 479.95 | 30131.0 |
| 2024-07-02 07:00:00 | QQQ | ETF | 479.97 | 479.97 | 478.74 | 479.22 | 157869.0 |
| 2024-07-02 08:00:00 | QQQ | ETF | 479.32 | 482.281 | 478.83 | 479.56 | 124395.0 |
| 2024-07-02 09:00:00 | QQQ | ETF | 479.53 | 483.18 | 479.53 | 482.33 | 2672888.0 |
| 2024-07-02 10:00:00 | QQQ | ETF | 482.36 | 483.78 | 481.28 | 483.4597 | 2538260.0 |
| 2024-07-02 11:00:00 | QQQ | ETF | 483.47 | 484.53 | 482.85 | 483.08 | 2141250.0 |
| 2024-07-02 12:00:00 | QQQ | ETF | 483.02 | 483.88 | 482.38 | 483.87 | 1300791.0 |
| 2024-07-02 13:00:00 | QQQ | ETF | 483.8757 | 485.96 | 483.71 | 485.81 | 2294558.0 |
| 2024-07-02 14:00:00 | QQQ | ETF | 485.79 | 486.55 | 485.69 | 486.126 | 2081249.0 |
| 2024-07-02 15:00:00 | QQQ | ETF | 486.11 | 487.04 | 485.82 | 487.01 | 3393490.0 |
| 2024-07-02 16:00:00 | QQQ | ETF | 486.99 | 487.1 | 486.36 | 486.6 | 1811873.0 |
| 2024-07-02 17:00:00 | QQQ | ETF | 486.58 | 486.98 | 486.5 | 486.58 | 142428.0 |
| 2024-07-02 18:00:00 | QQQ | ETF | 486.58 | 486.84 | 486.4 | 486.74 | 49143.0 |
| 2024-07-02 19:00:00 | QQQ | ETF | 486.7515 | 486.84 | 486.4431 | 486.5 | 19418.0 |
| 2024-07-02 04:00:00 | IWM | ETF | 200.93 | 200.93 | 200.0 | 200.28 | 16005.0 |
| 2024-07-02 05:00:00 | IWM | ETF | 200.3 | 200.36 | 200.08 | 200.2 | 7527.0 |
| 2024-07-02 06:00:00 | IWM | ETF | 200.29 | 200.45 | 200.14 | 200.38 | 10061.0 |
| 2024-07-02 07:00:00 | IWM | ETF | 200.47 | 200.47 | 200.01 | 200.38 | 50505.0 |
| 2024-07-02 08:00:00 | IWM | ETF | 200.3899 | 201.23 | 200.03 | 201.19 | 98142.0 |
| 2024-07-02 09:00:00 | IWM | ETF | 201.22 | 202.2 | 201.05 | 202.04 | 2298497.0 |
| 2024-07-02 10:00:00 | IWM | ETF | 202.05 | 202.27 | 201.21 | 201.59 | 2319108.0 |
| 2024-07-02 11:00:00 | IWM | ETF | 201.57 | 201.77 | 201.34 | 201.56 | 1168008.0 |
| 2024-07-02 12:00:00 | IWM | ETF | 201.57 | 201.6 | 200.9034 | 200.95 | 1301321.0 |
| 2024-07-02 13:00:00 | IWM | ETF | 200.9467 | 201.36 | 200.915 | 201.3 | 1155707.0 |
| 2024-07-02 14:00:00 | IWM | ETF | 201.3 | 201.71 | 201.3 | 201.54 | 968706.0 |
| 2024-07-02 15:00:00 | IWM | ETF | 201.53 | 201.98 | 201.47 | 201.81 | 3044751.0 |
| 2024-07-02 16:00:00 | IWM | ETF | 201.88 | 201.88 | 201.43 | 201.54 | 1186629.0 |
| 2024-07-02 17:00:00 | IWM | ETF | 201.5 | 201.71 | 201.41 | 201.63 | 41328.0 |
| 2024-07-02 18:00:00 | IWM | ETF | 201.66 | 201.88 | 201.63 | 201.88 | 28724.0 |
| 2024-07-02 19:00:00 | IWM | ETF | 201.85 | 201.88 | 201.66 | 201.72 | 10024.0 |
| 2024-07-02 04:00:00 | DIA | ETF | 390.58 | 390.58 | 390.25 | 390.37 | 1620.0 |
| 2024-07-02 05:00:00 | DIA | ETF | 390.31 | 390.31 | 390.31 | 390.31 | 400.0 |
> showing 50 of 20,368 rows — these rows as CSV