PREVIEW / etf_1hour / 2024-02-28
file: by_date/etf_1hour/2024/2024-02-28.parquet size: 533 KB rows: 19,595
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-28 04:00:00 | SPY | ETF | 505.78 | 506.0 | 504.5 | 504.6 | 72412.0 |
| 2024-02-28 05:00:00 | SPY | ETF | 504.69 | 505.58 | 504.6 | 505.39 | 29601.0 |
| 2024-02-28 06:00:00 | SPY | ETF | 505.35 | 505.72 | 505.21 | 505.33 | 23221.0 |
| 2024-02-28 07:00:00 | SPY | ETF | 505.52 | 505.58 | 504.96 | 504.96 | 136505.0 |
| 2024-02-28 08:00:00 | SPY | ETF | 505.41 | 506.98 | 504.7396 | 505.73 | 415347.0 |
| 2024-02-28 09:00:00 | SPY | ETF | 505.72 | 505.82 | 504.96 | 505.33 | 3788294.0 |
| 2024-02-28 10:00:00 | SPY | ETF | 505.33 | 506.52 | 505.24 | 506.475 | 5430340.0 |
| 2024-02-28 11:00:00 | SPY | ETF | 506.48 | 506.855 | 506.165 | 506.57 | 4140509.0 |
| 2024-02-28 12:00:00 | SPY | ETF | 506.57 | 506.6799 | 505.445 | 505.8799 | 4214562.0 |
| 2024-02-28 13:00:00 | SPY | ETF | 505.87 | 506.78 | 505.49 | 506.63 | 3818846.0 |
| 2024-02-28 14:00:00 | SPY | ETF | 506.63 | 506.6987 | 505.1776 | 505.845 | 5181902.0 |
| 2024-02-28 15:00:00 | SPY | ETF | 505.85 | 506.27 | 505.34 | 506.19 | 9686437.0 |
| 2024-02-28 16:00:00 | SPY | ETF | 506.19 | 506.26 | 504.74 | 505.0007 | 4268369.0 |
| 2024-02-28 17:00:00 | SPY | ETF | 505.03 | 505.17 | 504.8 | 505.1 | 134136.0 |
| 2024-02-28 18:00:00 | SPY | ETF | 505.1 | 505.4 | 505.07 | 505.15 | 92989.0 |
| 2024-02-28 19:00:00 | SPY | ETF | 505.23 | 505.82 | 505.23 | 505.77 | 53863.0 |
| 2024-02-28 04:00:00 | QQQ | ETF | 436.18 | 436.39 | 434.71 | 434.79 | 103117.0 |
| 2024-02-28 05:00:00 | QQQ | ETF | 434.87 | 435.99 | 434.81 | 435.87 | 39622.0 |
| 2024-02-28 06:00:00 | QQQ | ETF | 435.87 | 436.23 | 435.66 | 435.99 | 33766.0 |
| 2024-02-28 07:00:00 | QQQ | ETF | 435.99 | 436.29 | 435.41 | 435.48 | 176220.0 |
| 2024-02-28 08:00:00 | QQQ | ETF | 435.889 | 437.928 | 434.9 | 435.981 | 406977.0 |
| 2024-02-28 09:00:00 | QQQ | ETF | 435.99 | 435.99 | 434.3 | 434.77 | 3853420.0 |
| 2024-02-28 10:00:00 | QQQ | ETF | 434.76 | 435.6 | 434.37 | 435.544 | 3691823.0 |
| 2024-02-28 11:00:00 | QQQ | ETF | 435.55 | 436.67 | 435.55 | 436.39 | 2696577.0 |
| 2024-02-28 12:00:00 | QQQ | ETF | 436.4 | 436.47 | 434.78 | 435.29 | 2796092.0 |
| 2024-02-28 13:00:00 | QQQ | ETF | 435.27 | 436.2 | 434.72 | 436.0587 | 2807327.0 |
| 2024-02-28 14:00:00 | QQQ | ETF | 436.05 | 436.17 | 434.475 | 435.2 | 3809395.0 |
| 2024-02-28 15:00:00 | QQQ | ETF | 435.21 | 435.595 | 434.655 | 435.28 | 4528008.0 |
| 2024-02-28 16:00:00 | QQQ | ETF | 435.28 | 435.3 | 433.56 | 433.9 | 1620525.0 |
| 2024-02-28 17:00:00 | QQQ | ETF | 433.9 | 434.0 | 433.6 | 433.91 | 104978.0 |
| 2024-02-28 18:00:00 | QQQ | ETF | 433.91 | 434.32 | 433.91 | 434.15 | 137791.0 |
| 2024-02-28 19:00:00 | QQQ | ETF | 434.09 | 434.96 | 434.09 | 434.85 | 126162.0 |
| 2024-02-28 04:00:00 | IWM | ETF | 203.0 | 203.23 | 202.28 | 202.42 | 32917.0 |
| 2024-02-28 05:00:00 | IWM | ETF | 202.44 | 202.75 | 202.28 | 202.58 | 10300.0 |
| 2024-02-28 06:00:00 | IWM | ETF | 202.57 | 202.84 | 202.32 | 202.32 | 13348.0 |
| 2024-02-28 07:00:00 | IWM | ETF | 202.38 | 202.61 | 202.25 | 202.41 | 86128.0 |
| 2024-02-28 08:00:00 | IWM | ETF | 202.43 | 203.66 | 202.27 | 202.85 | 271132.0 |
| 2024-02-28 09:00:00 | IWM | ETF | 202.79 | 203.25 | 201.87 | 203.095 | 4175709.0 |
| 2024-02-28 10:00:00 | IWM | ETF | 203.1 | 203.8559 | 202.74 | 203.53 | 4240897.0 |
| 2024-02-28 11:00:00 | IWM | ETF | 203.53 | 203.75 | 203.02 | 203.575 | 2694479.0 |
| 2024-02-28 12:00:00 | IWM | ETF | 203.58 | 203.735 | 202.84 | 203.155 | 1814606.0 |
| 2024-02-28 13:00:00 | IWM | ETF | 203.15 | 203.42 | 202.8 | 203.3 | 2036317.0 |
| 2024-02-28 14:00:00 | IWM | ETF | 203.305 | 203.32 | 202.41 | 202.905 | 2713492.0 |
| 2024-02-28 15:00:00 | IWM | ETF | 202.905 | 203.03 | 202.08 | 202.395 | 5702540.0 |
| 2024-02-28 16:00:00 | IWM | ETF | 202.32 | 202.42 | 201.95 | 202.15 | 1061744.0 |
| 2024-02-28 17:00:00 | IWM | ETF | 202.14 | 202.14 | 201.9 | 202.0 | 16873.0 |
| 2024-02-28 18:00:00 | IWM | ETF | 202.05 | 202.29 | 201.99 | 201.99 | 24276.0 |
| 2024-02-28 19:00:00 | IWM | ETF | 202.01 | 202.37 | 201.99 | 202.32 | 45168.0 |
| 2024-02-28 04:00:00 | DIA | ETF | 388.98 | 388.98 | 388.62 | 388.62 | 763.0 |
| 2024-02-28 05:00:00 | DIA | ETF | 388.39 | 388.56 | 388.39 | 388.56 | 458.0 |
> showing 50 of 19,595 rows — these rows as CSV