PREVIEW / etf_1hour / 2024-05-16
file: by_date/etf_1hour/2024/2024-05-16.parquet size: 534 KB rows: 19,586
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-05-16 04:00:00 | SPY | ETF | 530.8 | 530.8 | 530.18 | 530.35 | 15555.0 |
| 2024-05-16 05:00:00 | SPY | ETF | 530.31 | 530.46 | 530.23 | 530.23 | 6925.0 |
| 2024-05-16 06:00:00 | SPY | ETF | 530.33 | 530.33 | 530.09 | 530.2 | 16434.0 |
| 2024-05-16 07:00:00 | SPY | ETF | 530.25 | 530.62 | 530.25 | 530.36 | 47400.0 |
| 2024-05-16 08:00:00 | SPY | ETF | 530.33 | 530.89 | 529.85 | 529.99 | 209461.0 |
| 2024-05-16 09:00:00 | SPY | ETF | 529.99 | 530.33 | 529.68 | 530.22 | 3127035.0 |
| 2024-05-16 10:00:00 | SPY | ETF | 530.21 | 531.47 | 529.55 | 531.375 | 4941948.0 |
| 2024-05-16 11:00:00 | SPY | ETF | 531.38 | 531.5218 | 530.52 | 530.91 | 4035165.0 |
| 2024-05-16 12:00:00 | SPY | ETF | 530.92 | 530.92 | 530.19 | 530.7191 | 2741636.0 |
| 2024-05-16 13:00:00 | SPY | ETF | 530.725 | 530.85 | 529.3303 | 530.05 | 4364493.0 |
| 2024-05-16 14:00:00 | SPY | ETF | 530.055 | 530.13 | 529.0201 | 530.09 | 3738549.0 |
| 2024-05-16 15:00:00 | SPY | ETF | 530.1 | 530.2 | 528.54 | 528.66 | 11608225.0 |
| 2024-05-16 16:00:00 | SPY | ETF | 528.66 | 528.82 | 528.24 | 528.29 | 2504294.0 |
| 2024-05-16 17:00:00 | SPY | ETF | 528.29 | 528.82 | 528.25 | 528.75 | 284371.0 |
| 2024-05-16 18:00:00 | SPY | ETF | 528.74 | 528.74 | 528.37 | 528.61 | 206696.0 |
| 2024-05-16 19:00:00 | SPY | ETF | 528.61 | 528.8 | 528.57 | 528.71 | 20049.0 |
| 2024-05-16 04:00:00 | QQQ | ETF | 453.9 | 453.9 | 453.5 | 453.74 | 61868.0 |
| 2024-05-16 05:00:00 | QQQ | ETF | 453.76 | 453.9 | 453.66 | 453.75 | 18190.0 |
| 2024-05-16 06:00:00 | QQQ | ETF | 453.82 | 453.84 | 453.58 | 453.75 | 38925.0 |
| 2024-05-16 07:00:00 | QQQ | ETF | 453.67 | 453.89 | 453.53 | 453.64 | 86487.0 |
| 2024-05-16 08:00:00 | QQQ | ETF | 453.71 | 454.0 | 452.91 | 453.08 | 176477.0 |
| 2024-05-16 09:00:00 | QQQ | ETF | 453.09 | 453.619 | 452.53 | 453.44 | 3249075.0 |
| 2024-05-16 10:00:00 | QQQ | ETF | 453.44 | 454.43 | 452.58 | 454.39 | 3864353.0 |
| 2024-05-16 11:00:00 | QQQ | ETF | 454.4095 | 454.69 | 453.81 | 454.23 | 2654495.0 |
| 2024-05-16 12:00:00 | QQQ | ETF | 454.22 | 454.22 | 453.42 | 454.0401 | 2078329.0 |
| 2024-05-16 13:00:00 | QQQ | ETF | 454.05 | 454.22 | 452.55 | 453.47 | 2680497.0 |
| 2024-05-16 14:00:00 | QQQ | ETF | 453.48 | 453.48 | 452.27 | 453.08 | 3437344.0 |
| 2024-05-16 15:00:00 | QQQ | ETF | 453.07 | 453.27 | 451.81 | 451.96 | 6466062.0 |
| 2024-05-16 16:00:00 | QQQ | ETF | 451.97 | 452.08 | 451.58 | 451.65 | 952845.0 |
| 2024-05-16 17:00:00 | QQQ | ETF | 451.64 | 451.89 | 451.63 | 451.85 | 69240.0 |
| 2024-05-16 18:00:00 | QQQ | ETF | 451.85 | 452.06 | 451.78 | 451.99 | 69581.0 |
| 2024-05-16 19:00:00 | QQQ | ETF | 451.97 | 452.1 | 451.87 | 451.98 | 20236.0 |
| 2024-05-16 04:00:00 | IWM | ETF | 209.42 | 209.45 | 208.96 | 208.96 | 13608.0 |
| 2024-05-16 05:00:00 | IWM | ETF | 209.04 | 209.12 | 208.94 | 209.09 | 10472.0 |
| 2024-05-16 06:00:00 | IWM | ETF | 208.97 | 209.18 | 208.94 | 209.17 | 10796.0 |
| 2024-05-16 07:00:00 | IWM | ETF | 209.23 | 209.48 | 209.16 | 209.27 | 21014.0 |
| 2024-05-16 08:00:00 | IWM | ETF | 209.38 | 209.91 | 209.0004 | 209.16 | 227340.0 |
| 2024-05-16 09:00:00 | IWM | ETF | 209.16 | 209.35 | 208.26 | 208.54 | 2718451.0 |
| 2024-05-16 10:00:00 | IWM | ETF | 208.54 | 208.95 | 208.17 | 208.825 | 3070371.0 |
| 2024-05-16 11:00:00 | IWM | ETF | 208.83 | 208.99 | 208.485 | 208.715 | 2399019.0 |
| 2024-05-16 12:00:00 | IWM | ETF | 208.71 | 208.71 | 208.355 | 208.535 | 1806171.0 |
| 2024-05-16 13:00:00 | IWM | ETF | 208.5351 | 208.665 | 207.97 | 208.38 | 2390865.0 |
| 2024-05-16 14:00:00 | IWM | ETF | 208.38 | 208.495 | 207.945 | 208.47 | 2024540.0 |
| 2024-05-16 15:00:00 | IWM | ETF | 208.47 | 208.66 | 207.98 | 208.0 | 4448876.0 |
| 2024-05-16 16:00:00 | IWM | ETF | 207.93 | 208.08 | 207.82 | 207.88 | 2002559.0 |
| 2024-05-16 17:00:00 | IWM | ETF | 207.92 | 208.17 | 207.9 | 208.04 | 25034.0 |
| 2024-05-16 18:00:00 | IWM | ETF | 208.03 | 208.05 | 207.81 | 207.9 | 49862.0 |
| 2024-05-16 19:00:00 | IWM | ETF | 207.89 | 207.98 | 207.87 | 207.92 | 6737.0 |
| 2024-05-16 04:00:00 | DIA | ETF | 399.75 | 399.78 | 399.75 | 399.78 | 700.0 |
| 2024-05-16 05:00:00 | DIA | ETF | 399.74 | 399.78 | 399.74 | 399.78 | 477.0 |
> showing 50 of 19,586 rows — these rows as CSV