PREVIEW / etf_1hour / 2024-02-15
file: by_date/etf_1hour/2024/2024-02-15.parquet size: 539 KB rows: 19,716
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-02-15 04:00:00 | SPY | ETF | 499.7 | 500.26 | 499.7 | 499.96 | 47006.0 |
| 2024-02-15 05:00:00 | SPY | ETF | 499.95 | 500.04 | 499.66 | 499.76 | 4274.0 |
| 2024-02-15 06:00:00 | SPY | ETF | 499.78 | 499.99 | 499.73 | 499.79 | 18709.0 |
| 2024-02-15 07:00:00 | SPY | ETF | 499.79 | 500.09 | 499.66 | 499.91 | 145872.0 |
| 2024-02-15 08:00:00 | SPY | ETF | 499.8 | 500.55 | 499.3 | 499.7 | 446773.0 |
| 2024-02-15 09:00:00 | SPY | ETF | 499.68 | 500.38 | 499.03 | 499.6499 | 4174623.0 |
| 2024-02-15 10:00:00 | SPY | ETF | 499.65 | 500.57 | 499.3 | 499.82 | 6016522.0 |
| 2024-02-15 11:00:00 | SPY | ETF | 499.82 | 500.15 | 498.795 | 499.805 | 5498099.0 |
| 2024-02-15 12:00:00 | SPY | ETF | 499.805 | 500.59 | 499.665 | 500.05 | 4479734.0 |
| 2024-02-15 13:00:00 | SPY | ETF | 500.045 | 501.6806 | 499.95 | 501.38 | 6108268.0 |
| 2024-02-15 14:00:00 | SPY | ETF | 501.39 | 502.2 | 500.99 | 501.84 | 5950067.0 |
| 2024-02-15 15:00:00 | SPY | ETF | 501.84 | 502.05 | 501.15 | 501.95 | 12509260.0 |
| 2024-02-15 16:00:00 | SPY | ETF | 501.96 | 502.5 | 501.752 | 502.36 | 2414918.0 |
| 2024-02-15 17:00:00 | SPY | ETF | 502.41 | 502.42 | 502.01 | 502.2 | 488631.0 |
| 2024-02-15 18:00:00 | SPY | ETF | 502.2 | 502.3 | 502.1 | 502.13 | 56355.0 |
| 2024-02-15 19:00:00 | SPY | ETF | 502.13 | 502.16 | 501.49 | 501.61 | 79167.0 |
| 2024-02-15 04:00:00 | QQQ | ETF | 434.7 | 434.72 | 433.82 | 434.0 | 80851.0 |
| 2024-02-15 05:00:00 | QQQ | ETF | 434.12 | 434.21 | 433.88 | 434.15 | 12351.0 |
| 2024-02-15 06:00:00 | QQQ | ETF | 434.18 | 434.4 | 434.15 | 434.25 | 22442.0 |
| 2024-02-15 07:00:00 | QQQ | ETF | 434.18 | 434.64 | 434.18 | 434.34 | 77310.0 |
| 2024-02-15 08:00:00 | QQQ | ETF | 434.24 | 435.05 | 432.896 | 434.2 | 454914.0 |
| 2024-02-15 09:00:00 | QQQ | ETF | 434.05 | 434.28 | 432.03 | 432.18 | 3587635.0 |
| 2024-02-15 10:00:00 | QQQ | ETF | 432.18 | 433.32 | 431.725 | 432.92 | 5190045.0 |
| 2024-02-15 11:00:00 | QQQ | ETF | 432.95 | 433.07 | 431.33 | 432.64 | 4208473.0 |
| 2024-02-15 12:00:00 | QQQ | ETF | 432.66 | 433.79 | 432.2601 | 433.08 | 3013952.0 |
| 2024-02-15 13:00:00 | QQQ | ETF | 433.07 | 434.98 | 433.0 | 434.47 | 4742145.0 |
| 2024-02-15 14:00:00 | QQQ | ETF | 434.47 | 434.86 | 433.7387 | 434.35 | 3720468.0 |
| 2024-02-15 15:00:00 | QQQ | ETF | 434.36 | 434.61 | 433.535 | 434.53 | 5169591.0 |
| 2024-02-15 16:00:00 | QQQ | ETF | 434.53 | 435.84 | 434.5 | 435.55 | 1082809.0 |
| 2024-02-15 17:00:00 | QQQ | ETF | 435.55 | 435.57 | 435.2 | 435.3 | 61023.0 |
| 2024-02-15 18:00:00 | QQQ | ETF | 435.39 | 435.58 | 435.29 | 435.45 | 75300.0 |
| 2024-02-15 19:00:00 | QQQ | ETF | 435.43 | 435.43 | 434.88 | 435.01 | 73772.0 |
| 2024-02-15 04:00:00 | IWM | ETF | 200.85 | 201.52 | 200.12 | 201.28 | 34978.0 |
| 2024-02-15 05:00:00 | IWM | ETF | 201.2 | 201.32 | 200.77 | 200.83 | 16010.0 |
| 2024-02-15 06:00:00 | IWM | ETF | 200.84 | 200.9 | 200.67 | 200.9 | 77846.0 |
| 2024-02-15 07:00:00 | IWM | ETF | 200.9 | 201.05 | 200.75 | 200.94 | 74150.0 |
| 2024-02-15 08:00:00 | IWM | ETF | 200.94 | 202.16 | 199.95 | 201.1999 | 380382.0 |
| 2024-02-15 09:00:00 | IWM | ETF | 201.07 | 202.735 | 200.72 | 201.78 | 4342062.0 |
| 2024-02-15 10:00:00 | IWM | ETF | 201.79 | 202.99 | 201.58 | 201.615 | 5767321.0 |
| 2024-02-15 11:00:00 | IWM | ETF | 201.62 | 202.2899 | 200.98 | 202.06 | 4018337.0 |
| 2024-02-15 12:00:00 | IWM | ETF | 202.1 | 202.65 | 202.04 | 202.19 | 2534707.0 |
| 2024-02-15 13:00:00 | IWM | ETF | 202.19 | 204.08 | 202.09 | 204.0 | 5308610.0 |
| 2024-02-15 14:00:00 | IWM | ETF | 204.0 | 204.765 | 203.89 | 204.425 | 4514914.0 |
| 2024-02-15 15:00:00 | IWM | ETF | 204.42 | 204.465 | 203.82 | 204.38 | 7074818.0 |
| 2024-02-15 16:00:00 | IWM | ETF | 204.38 | 204.52 | 204.0 | 204.0 | 1528678.0 |
| 2024-02-15 17:00:00 | IWM | ETF | 204.01 | 204.2 | 204.0 | 204.13 | 60575.0 |
| 2024-02-15 18:00:00 | IWM | ETF | 204.13 | 204.22 | 204.02 | 204.11 | 174174.0 |
| 2024-02-15 19:00:00 | IWM | ETF | 204.1 | 204.1 | 203.57 | 203.6 | 92076.0 |
| 2024-02-15 04:00:00 | DIA | ETF | 385.0 | 385.4 | 385.0 | 385.33 | 325.0 |
| 2024-02-15 05:00:00 | DIA | ETF | 385.28 | 385.28 | 385.28 | 385.28 | 290.0 |
> showing 50 of 19,716 rows — these rows as CSV