PREVIEW / etf_1hour / 2024-01-31
file: by_date/etf_1hour/2024/2024-01-31.parquet size: 538 KB rows: 19,978
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-01-31 04:00:00 | SPY | ETF | 489.15 | 489.5 | 488.37 | 488.55 | 40130.0 |
| 2024-01-31 05:00:00 | SPY | ETF | 488.58 | 488.6 | 488.4 | 488.51 | 23030.0 |
| 2024-01-31 06:00:00 | SPY | ETF | 488.35 | 488.89 | 488.35 | 488.75 | 33886.0 |
| 2024-01-31 07:00:00 | SPY | ETF | 488.84 | 489.11 | 488.48 | 489.11 | 146867.0 |
| 2024-01-31 08:00:00 | SPY | ETF | 488.85 | 489.81 | 488.38 | 488.54 | 452392.0 |
| 2024-01-31 09:00:00 | SPY | ETF | 488.52 | 489.0813 | 487.52 | 487.7602 | 6592871.0 |
| 2024-01-31 10:00:00 | SPY | ETF | 487.73 | 487.83 | 486.39 | 486.745 | 8146821.0 |
| 2024-01-31 11:00:00 | SPY | ETF | 486.74 | 487.48 | 486.34 | 486.8399 | 5342040.0 |
| 2024-01-31 12:00:00 | SPY | ETF | 486.85 | 487.41 | 486.56 | 487.34 | 3982847.0 |
| 2024-01-31 13:00:00 | SPY | ETF | 487.345 | 487.71 | 487.03 | 487.43 | 4219452.0 |
| 2024-01-31 14:00:00 | SPY | ETF | 487.43 | 489.0 | 485.63 | 486.484 | 18586119.0 |
| 2024-01-31 15:00:00 | SPY | ETF | 486.5 | 486.62 | 482.89 | 482.92 | 36688618.0 |
| 2024-01-31 16:00:00 | SPY | ETF | 482.915 | 487.3909 | 482.69 | 483.26 | 7548392.0 |
| 2024-01-31 17:00:00 | SPY | ETF | 483.25 | 483.4 | 482.88 | 483.4 | 100969.0 |
| 2024-01-31 18:00:00 | SPY | ETF | 483.45 | 483.77 | 483.31 | 483.72 | 73301.0 |
| 2024-01-31 19:00:00 | SPY | ETF | 483.71 | 484.3 | 483.71 | 484.02 | 123768.0 |
| 2024-01-31 04:00:00 | QQQ | ETF | 422.01 | 422.02 | 419.5 | 420.38 | 170319.0 |
| 2024-01-31 05:00:00 | QQQ | ETF | 420.37 | 420.42 | 419.8 | 419.8 | 64738.0 |
| 2024-01-31 06:00:00 | QQQ | ETF | 419.81 | 420.73 | 419.25 | 420.73 | 128441.0 |
| 2024-01-31 07:00:00 | QQQ | ETF | 420.69 | 421.59 | 420.52 | 421.55 | 406375.0 |
| 2024-01-31 08:00:00 | QQQ | ETF | 420.63 | 424.982 | 419.6296 | 421.02 | 697223.0 |
| 2024-01-31 09:00:00 | QQQ | ETF | 421.03 | 421.53 | 419.62 | 420.15 | 6290146.0 |
| 2024-01-31 10:00:00 | QQQ | ETF | 420.15 | 420.47 | 418.06 | 418.52 | 6186153.0 |
| 2024-01-31 11:00:00 | QQQ | ETF | 418.51 | 419.7 | 418.49 | 419.44 | 3960115.0 |
| 2024-01-31 12:00:00 | QQQ | ETF | 419.44 | 420.18 | 419.26 | 420.1601 | 3025112.0 |
| 2024-01-31 13:00:00 | QQQ | ETF | 420.1699 | 420.9499 | 420.05 | 420.53 | 2978508.0 |
| 2024-01-31 14:00:00 | QQQ | ETF | 420.55 | 422.8699 | 418.6999 | 420.35 | 11335300.0 |
| 2024-01-31 15:00:00 | QQQ | ETF | 420.38 | 420.51 | 416.79 | 416.89 | 15010271.0 |
| 2024-01-31 16:00:00 | QQQ | ETF | 416.89 | 417.72 | 416.55 | 417.5903 | 2241665.0 |
| 2024-01-31 17:00:00 | QQQ | ETF | 417.57 | 417.67 | 417.32 | 417.65 | 37328.0 |
| 2024-01-31 18:00:00 | QQQ | ETF | 417.65 | 418.16 | 417.64 | 418.0 | 87071.0 |
| 2024-01-31 19:00:00 | QQQ | ETF | 418.12 | 418.8 | 417.97 | 418.56 | 59058.0 |
| 2024-01-31 04:00:00 | IWM | ETF | 198.17 | 198.89 | 198.17 | 198.4 | 105401.0 |
| 2024-01-31 05:00:00 | IWM | ETF | 198.4 | 198.59 | 198.24 | 198.41 | 73071.0 |
| 2024-01-31 06:00:00 | IWM | ETF | 198.32 | 198.57 | 198.31 | 198.43 | 86769.0 |
| 2024-01-31 07:00:00 | IWM | ETF | 198.46 | 198.63 | 198.28 | 198.46 | 166207.0 |
| 2024-01-31 08:00:00 | IWM | ETF | 198.5591 | 198.99 | 197.37 | 197.4 | 780242.0 |
| 2024-01-31 09:00:00 | IWM | ETF | 197.4 | 197.75 | 195.97 | 196.92 | 5632427.0 |
| 2024-01-31 10:00:00 | IWM | ETF | 196.93 | 197.25 | 196.21 | 196.82 | 5070440.0 |
| 2024-01-31 11:00:00 | IWM | ETF | 196.79 | 197.22 | 195.71 | 196.27 | 4132023.0 |
| 2024-01-31 12:00:00 | IWM | ETF | 196.2601 | 197.11 | 196.22 | 197.1 | 3281151.0 |
| 2024-01-31 13:00:00 | IWM | ETF | 197.09 | 197.16 | 196.64 | 196.94 | 2843428.0 |
| 2024-01-31 14:00:00 | IWM | ETF | 196.97 | 198.94 | 195.51 | 196.66 | 12756833.0 |
| 2024-01-31 15:00:00 | IWM | ETF | 196.68 | 196.89 | 192.71 | 192.81 | 19744083.0 |
| 2024-01-31 16:00:00 | IWM | ETF | 192.8 | 193.41 | 192.66 | 193.2 | 2274261.0 |
| 2024-01-31 17:00:00 | IWM | ETF | 193.2 | 193.32 | 193.02 | 193.15 | 97333.0 |
| 2024-01-31 18:00:00 | IWM | ETF | 193.15 | 193.5 | 193.05 | 193.36 | 141407.0 |
| 2024-01-31 19:00:00 | IWM | ETF | 193.45 | 194.02 | 193.45 | 193.7 | 113147.0 |
| 2024-01-31 04:00:00 | DIA | ETF | 385.1 | 385.11 | 384.99 | 385.07 | 1500.0 |
| 2024-01-31 05:00:00 | DIA | ETF | 384.96 | 384.99 | 384.96 | 384.99 | 2200.0 |
> showing 50 of 19,978 rows — these rows as CSV