PREVIEW / etf_1hour / 2024-02-22
file: by_date/etf_1hour/2024/2024-02-22.parquet size: 546 KB rows: 20,235
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-22 04:00:00 | SPY | ETF | 503.12 | 503.25 | 501.2 | 503.0 | 63061.0 |
| 2024-02-22 05:00:00 | SPY | ETF | 502.95 | 503.43 | 502.82 | 503.35 | 74141.0 |
| 2024-02-22 06:00:00 | SPY | ETF | 503.34 | 504.49 | 503.27 | 503.91 | 79553.0 |
| 2024-02-22 07:00:00 | SPY | ETF | 503.88 | 503.92 | 503.52 | 503.6 | 376235.0 |
| 2024-02-22 08:00:00 | SPY | ETF | 503.6 | 504.33 | 501.1 | 504.2 | 671262.0 |
| 2024-02-22 09:00:00 | SPY | ETF | 504.16 | 505.425 | 503.02 | 504.99 | 9675278.0 |
| 2024-02-22 10:00:00 | SPY | ETF | 505.02 | 505.6999 | 504.51 | 504.75 | 8335277.0 |
| 2024-02-22 11:00:00 | SPY | ETF | 504.77 | 505.89 | 504.54 | 505.245 | 5691591.0 |
| 2024-02-22 12:00:00 | SPY | ETF | 505.25 | 506.51 | 504.91 | 506.45 | 5277574.0 |
| 2024-02-22 13:00:00 | SPY | ETF | 506.45 | 507.2699 | 506.07 | 507.25 | 5759611.0 |
| 2024-02-22 14:00:00 | SPY | ETF | 507.24 | 508.49 | 506.89 | 507.195 | 8711752.0 |
| 2024-02-22 15:00:00 | SPY | ETF | 507.185 | 508.315 | 507.07 | 507.53 | 14039306.0 |
| 2024-02-22 16:00:00 | SPY | ETF | 507.52 | 507.6 | 505.7552 | 507.12 | 2595984.0 |
| 2024-02-22 17:00:00 | SPY | ETF | 507.1201 | 507.3 | 507.1 | 507.22 | 59893.0 |
| 2024-02-22 18:00:00 | SPY | ETF | 507.24 | 507.79 | 507.22 | 507.67 | 373537.0 |
| 2024-02-22 19:00:00 | SPY | ETF | 507.65 | 507.65 | 507.0 | 507.34 | 54801.0 |
| 2024-02-22 04:00:00 | QQQ | ETF | 433.62 | 434.45 | 431.99 | 434.24 | 193720.0 |
| 2024-02-22 05:00:00 | QQQ | ETF | 434.25 | 434.45 | 433.89 | 434.35 | 48657.0 |
| 2024-02-22 06:00:00 | QQQ | ETF | 434.35 | 435.18 | 434.09 | 434.84 | 92824.0 |
| 2024-02-22 07:00:00 | QQQ | ETF | 434.84 | 434.85 | 434.16 | 434.31 | 329030.0 |
| 2024-02-22 08:00:00 | QQQ | ETF | 434.3 | 435.0904 | 431.9 | 434.53 | 468962.0 |
| 2024-02-22 09:00:00 | QQQ | ETF | 434.53 | 436.285 | 433.71 | 435.11 | 7509587.0 |
| 2024-02-22 10:00:00 | QQQ | ETF | 435.12 | 436.39 | 434.51 | 434.91 | 6504443.0 |
| 2024-02-22 11:00:00 | QQQ | ETF | 434.93 | 436.53 | 434.73 | 435.84 | 3904682.0 |
| 2024-02-22 12:00:00 | QQQ | ETF | 435.85 | 437.48 | 435.45 | 437.4601 | 3383536.0 |
| 2024-02-22 13:00:00 | QQQ | ETF | 437.46 | 438.36 | 437.08 | 438.295 | 3123794.0 |
| 2024-02-22 14:00:00 | QQQ | ETF | 438.29 | 439.12 | 437.85 | 438.235 | 4440722.0 |
| 2024-02-22 15:00:00 | QQQ | ETF | 438.21 | 439.0799 | 438.0 | 438.14 | 9257643.0 |
| 2024-02-22 16:00:00 | QQQ | ETF | 438.12 | 438.14 | 437.24 | 437.59 | 2589769.0 |
| 2024-02-22 17:00:00 | QQQ | ETF | 437.6 | 437.6 | 436.33 | 437.489 | 278317.0 |
| 2024-02-22 18:00:00 | QQQ | ETF | 437.51 | 438.2 | 437.5 | 438.01 | 70654.0 |
| 2024-02-22 19:00:00 | QQQ | ETF | 438.01 | 438.02 | 437.42 | 437.7 | 87996.0 |
| 2024-02-22 04:00:00 | IWM | ETF | 199.54 | 199.54 | 198.7 | 198.83 | 40599.0 |
| 2024-02-22 05:00:00 | IWM | ETF | 198.85 | 199.24 | 198.85 | 199.1 | 24382.0 |
| 2024-02-22 06:00:00 | IWM | ETF | 199.06 | 199.6 | 198.9 | 199.25 | 70189.0 |
| 2024-02-22 07:00:00 | IWM | ETF | 199.25 | 199.34 | 198.84 | 198.84 | 97623.0 |
| 2024-02-22 08:00:00 | IWM | ETF | 198.82 | 199.93 | 198.3 | 198.47 | 242020.0 |
| 2024-02-22 09:00:00 | IWM | ETF | 198.45 | 199.71 | 198.08 | 199.03 | 4230309.0 |
| 2024-02-22 10:00:00 | IWM | ETF | 199.05 | 199.3103 | 197.89 | 198.55 | 6331776.0 |
| 2024-02-22 11:00:00 | IWM | ETF | 198.56 | 199.34 | 198.4 | 199.165 | 3782585.0 |
| 2024-02-22 12:00:00 | IWM | ETF | 199.165 | 199.98 | 199.02 | 199.88 | 1881176.0 |
| 2024-02-22 13:00:00 | IWM | ETF | 199.895 | 199.9 | 198.885 | 199.75 | 2929935.0 |
| 2024-02-22 14:00:00 | IWM | ETF | 199.74 | 200.085 | 199.0188 | 199.175 | 3092701.0 |
| 2024-02-22 15:00:00 | IWM | ETF | 199.16 | 199.985 | 199.03 | 199.51 | 5094473.0 |
| 2024-02-22 16:00:00 | IWM | ETF | 199.44 | 199.56 | 199.18 | 199.25 | 1561033.0 |
| 2024-02-22 17:00:00 | IWM | ETF | 199.3 | 199.45 | 199.28 | 199.41 | 22864.0 |
| 2024-02-22 18:00:00 | IWM | ETF | 199.4 | 199.75 | 199.4 | 199.7 | 59633.0 |
| 2024-02-22 19:00:00 | IWM | ETF | 199.65 | 199.7 | 199.21 | 199.44 | 68375.0 |
| 2024-02-22 06:00:00 | DIA | ETF | 387.63 | 387.63 | 387.63 | 387.63 | 200.0 |
| 2024-02-22 07:00:00 | DIA | ETF | 387.61 | 387.86 | 387.61 | 387.72 | 9509.0 |
> showing 50 of 20,235 rows — these rows as CSV