PREVIEW / etf_1hour / 2024-05-03
file: by_date/etf_1hour/2024/2024-05-03.parquet size: 523 KB rows: 19,620
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-03 04:00:00 | SPY | ETF | 506.25 | 506.82 | 506.25 | 506.69 | 15838.0 |
| 2024-05-03 05:00:00 | SPY | ETF | 506.71 | 506.81 | 506.45 | 506.8 | 7909.0 |
| 2024-05-03 06:00:00 | SPY | ETF | 506.97 | 507.21 | 506.8 | 506.8 | 26151.0 |
| 2024-05-03 07:00:00 | SPY | ETF | 506.71 | 507.08 | 506.12 | 506.64 | 180928.0 |
| 2024-05-03 08:00:00 | SPY | ETF | 506.75 | 511.51 | 505.86 | 510.55 | 1694967.0 |
| 2024-05-03 09:00:00 | SPY | ETF | 510.63 | 511.98 | 509.61 | 511.57 | 8016165.0 |
| 2024-05-03 10:00:00 | SPY | ETF | 511.59 | 512.55 | 508.64 | 509.17 | 11997881.0 |
| 2024-05-03 11:00:00 | SPY | ETF | 509.17 | 510.92 | 508.56 | 510.485 | 6420986.0 |
| 2024-05-03 12:00:00 | SPY | ETF | 510.48 | 511.3986 | 510.42 | 510.7 | 4700924.0 |
| 2024-05-03 13:00:00 | SPY | ETF | 510.71 | 511.62 | 510.6 | 511.3 | 3830527.0 |
| 2024-05-03 14:00:00 | SPY | ETF | 511.29 | 511.99 | 511.24 | 511.54 | 4011880.0 |
| 2024-05-03 15:00:00 | SPY | ETF | 511.54 | 511.8499 | 511.14 | 511.29 | 11539251.0 |
| 2024-05-03 16:00:00 | SPY | ETF | 511.28 | 512.07 | 511.25 | 511.9 | 4482804.0 |
| 2024-05-03 17:00:00 | SPY | ETF | 511.9 | 512.17 | 511.6 | 512.17 | 95145.0 |
| 2024-05-03 18:00:00 | SPY | ETF | 512.13 | 512.56 | 512.09 | 512.29 | 60507.0 |
| 2024-05-03 19:00:00 | SPY | ETF | 512.33 | 512.55 | 512.2 | 512.32 | 46442.0 |
| 2024-05-03 04:00:00 | QQQ | ETF | 429.32 | 429.89 | 429.24 | 429.71 | 39789.0 |
| 2024-05-03 05:00:00 | QQQ | ETF | 429.71 | 429.71 | 429.31 | 429.58 | 12379.0 |
| 2024-05-03 06:00:00 | QQQ | ETF | 429.73 | 430.12 | 429.52 | 429.52 | 56065.0 |
| 2024-05-03 07:00:00 | QQQ | ETF | 429.5 | 429.98 | 429.25 | 429.37 | 66837.0 |
| 2024-05-03 08:00:00 | QQQ | ETF | 429.5617 | 434.54 | 428.78 | 433.6 | 815800.0 |
| 2024-05-03 09:00:00 | QQQ | ETF | 433.62 | 435.88 | 433.43 | 435.4207 | 5735482.0 |
| 2024-05-03 10:00:00 | QQQ | ETF | 435.44 | 436.48 | 432.62 | 433.62 | 8029587.0 |
| 2024-05-03 11:00:00 | QQQ | ETF | 433.64 | 435.54 | 432.89 | 435.0985 | 4189177.0 |
| 2024-05-03 12:00:00 | QQQ | ETF | 435.09 | 435.59 | 434.51 | 434.74 | 2679015.0 |
| 2024-05-03 13:00:00 | QQQ | ETF | 434.75 | 435.51 | 434.64 | 435.09 | 2107961.0 |
| 2024-05-03 14:00:00 | QQQ | ETF | 435.0899 | 436.07 | 435.0896 | 435.625 | 2168984.0 |
| 2024-05-03 15:00:00 | QQQ | ETF | 435.64 | 436.0 | 435.15 | 435.48 | 5691178.0 |
| 2024-05-03 16:00:00 | QQQ | ETF | 435.475 | 436.09 | 435.43 | 436.03 | 1632018.0 |
| 2024-05-03 17:00:00 | QQQ | ETF | 436.02 | 436.1 | 435.88 | 436.1 | 47736.0 |
| 2024-05-03 18:00:00 | QQQ | ETF | 436.1 | 436.28 | 436.0497 | 436.13 | 13548.0 |
| 2024-05-03 19:00:00 | QQQ | ETF | 436.06 | 436.2 | 436.04 | 436.15 | 16481.0 |
| 2024-05-03 04:00:00 | IWM | ETF | 199.71 | 199.8 | 199.5 | 199.71 | 11598.0 |
| 2024-05-03 05:00:00 | IWM | ETF | 199.66 | 199.82 | 199.49 | 199.79 | 4241.0 |
| 2024-05-03 06:00:00 | IWM | ETF | 199.85 | 199.89 | 199.62 | 199.62 | 3677.0 |
| 2024-05-03 07:00:00 | IWM | ETF | 199.66 | 199.74 | 199.48 | 199.59 | 38162.0 |
| 2024-05-03 08:00:00 | IWM | ETF | 199.6 | 204.22 | 199.2 | 203.44 | 1794459.0 |
| 2024-05-03 09:00:00 | IWM | ETF | 203.49 | 204.0 | 202.67 | 203.595 | 3908891.0 |
| 2024-05-03 10:00:00 | IWM | ETF | 203.64 | 204.16 | 201.31 | 201.55 | 6944565.0 |
| 2024-05-03 11:00:00 | IWM | ETF | 201.55 | 201.995 | 201.12 | 201.8 | 2533456.0 |
| 2024-05-03 12:00:00 | IWM | ETF | 201.84 | 202.07 | 201.7 | 201.83 | 1584108.0 |
| 2024-05-03 13:00:00 | IWM | ETF | 201.84 | 202.04 | 201.27 | 201.89 | 1359533.0 |
| 2024-05-03 14:00:00 | IWM | ETF | 201.89 | 202.24 | 201.585 | 201.795 | 1493355.0 |
| 2024-05-03 15:00:00 | IWM | ETF | 201.79 | 202.01 | 201.47 | 201.89 | 4081073.0 |
| 2024-05-03 16:00:00 | IWM | ETF | 201.9 | 202.26 | 201.86 | 202.1 | 670726.0 |
| 2024-05-03 17:00:00 | IWM | ETF | 202.12 | 202.45 | 201.9 | 202.45 | 91238.0 |
| 2024-05-03 18:00:00 | IWM | ETF | 202.34 | 202.45 | 202.25 | 202.25 | 3588.0 |
| 2024-05-03 19:00:00 | IWM | ETF | 202.26 | 202.33 | 202.24 | 202.33 | 3571.0 |
| 2024-05-03 04:00:00 | DIA | ETF | 384.7 | 384.87 | 384.7 | 384.87 | 1300.0 |
| 2024-05-03 05:00:00 | DIA | ETF | 385.18 | 385.2 | 385.18 | 385.2 | 804.0 |
> showing 50 of 19,620 rows — these rows as CSV