PREVIEW / etf_1hour / 2025-05-13
file: by_date/etf_1hour/2025/2025-05-13.parquet size: 664 KB rows: 25,499
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-13 04:00:00 | SPY | ETF | 580.7 | 581.21 | 580.36 | 580.46 | 21747.0 |
| 2025-05-13 05:00:00 | SPY | ETF | 580.45 | 581.5 | 580.32 | 581.41 | 15985.0 |
| 2025-05-13 06:00:00 | SPY | ETF | 581.55 | 581.84 | 581.07 | 581.47 | 37609.0 |
| 2025-05-13 07:00:00 | SPY | ETF | 581.25 | 582.2 | 581.23 | 582.19 | 180977.0 |
| 2025-05-13 08:00:00 | SPY | ETF | 581.55 | 587.4 | 580.22 | 583.33 | 875951.0 |
| 2025-05-13 09:00:00 | SPY | ETF | 583.29 | 585.47 | 564.61 | 585.28 | 5084264.0 |
| 2025-05-13 10:00:00 | SPY | ETF | 585.29 | 587.9 | 585.22 | 587.0801 | 8255893.0 |
| 2025-05-13 11:00:00 | SPY | ETF | 587.11 | 588.44 | 586.74 | 587.65 | 5131027.0 |
| 2025-05-13 12:00:00 | SPY | ETF | 587.67 | 588.355 | 586.96 | 587.955 | 3535860.0 |
| 2025-05-13 13:00:00 | SPY | ETF | 587.96 | 589.0699 | 587.66 | 587.9192 | 4224297.0 |
| 2025-05-13 14:00:00 | SPY | ETF | 587.92 | 588.7 | 587.46 | 588.6 | 4143596.0 |
| 2025-05-13 15:00:00 | SPY | ETF | 588.59 | 589.08 | 586.73 | 586.81 | 9869389.0 |
| 2025-05-13 16:00:00 | SPY | ETF | 586.8 | 587.1 | 586.39 | 586.6 | 2603393.0 |
| 2025-05-13 17:00:00 | SPY | ETF | 586.62 | 586.9998 | 586.42 | 586.75 | 88773.0 |
| 2025-05-13 18:00:00 | SPY | ETF | 586.65 | 586.8996 | 586.42 | 586.78 | 60937.0 |
| 2025-05-13 19:00:00 | SPY | ETF | 586.75 | 587.35 | 586.6 | 587.26 | 38661.0 |
| 2025-05-13 04:00:00 | QQQ | ETF | 505.37 | 506.07 | 504.82 | 505.04 | 60299.0 |
| 2025-05-13 05:00:00 | QQQ | ETF | 505.06 | 506.12 | 504.9 | 506.12 | 44702.0 |
| 2025-05-13 06:00:00 | QQQ | ETF | 506.21 | 506.88 | 505.69 | 506.49 | 62836.0 |
| 2025-05-13 07:00:00 | QQQ | ETF | 506.45 | 507.75 | 506.39 | 507.74 | 89178.0 |
| 2025-05-13 08:00:00 | QQQ | ETF | 506.78 | 510.5 | 504.78 | 509.25 | 700097.0 |
| 2025-05-13 09:00:00 | QQQ | ETF | 509.25 | 512.26 | 508.42 | 512.1175 | 5106398.0 |
| 2025-05-13 10:00:00 | QQQ | ETF | 512.12 | 515.29 | 511.88 | 515.09 | 7822167.0 |
| 2025-05-13 11:00:00 | QQQ | ETF | 515.1 | 516.35 | 514.62 | 515.89 | 5113057.0 |
| 2025-05-13 12:00:00 | QQQ | ETF | 515.9 | 517.18 | 515.13 | 516.78 | 4092626.0 |
| 2025-05-13 13:00:00 | QQQ | ETF | 516.8 | 517.39 | 516.12 | 516.18 | 3887234.0 |
| 2025-05-13 14:00:00 | QQQ | ETF | 516.19 | 517.03 | 515.64 | 516.9298 | 3134497.0 |
| 2025-05-13 15:00:00 | QQQ | ETF | 516.91 | 517.28 | 515.26 | 515.58 | 5690227.0 |
| 2025-05-13 16:00:00 | QQQ | ETF | 515.58 | 515.7939 | 515.04 | 515.1912 | 1928525.0 |
| 2025-05-13 17:00:00 | QQQ | ETF | 515.28 | 515.53 | 515.1 | 515.46 | 75901.0 |
| 2025-05-13 18:00:00 | QQQ | ETF | 515.26 | 515.6 | 515.14 | 515.32 | 62477.0 |
| 2025-05-13 19:00:00 | QQQ | ETF | 515.4 | 516.24 | 515.19 | 516.18 | 57884.0 |
| 2025-05-13 04:00:00 | IWM | ETF | 206.94 | 207.47 | 206.86 | 207.0 | 13110.0 |
| 2025-05-13 05:00:00 | IWM | ETF | 207.0 | 207.9 | 206.95 | 207.9 | 10423.0 |
| 2025-05-13 06:00:00 | IWM | ETF | 207.8 | 208.03 | 207.65 | 207.94 | 58867.0 |
| 2025-05-13 07:00:00 | IWM | ETF | 207.81 | 208.4 | 207.751 | 208.4 | 65011.0 |
| 2025-05-13 08:00:00 | IWM | ETF | 207.82 | 209.73 | 206.76 | 209.05 | 491889.0 |
| 2025-05-13 09:00:00 | IWM | ETF | 209.06 | 209.43 | 208.38 | 208.42 | 3457441.0 |
| 2025-05-13 10:00:00 | IWM | ETF | 208.42 | 209.02 | 207.96 | 208.6 | 3101326.0 |
| 2025-05-13 11:00:00 | IWM | ETF | 208.61 | 209.33 | 208.39 | 209.04 | 2406003.0 |
| 2025-05-13 12:00:00 | IWM | ETF | 209.05 | 209.37 | 208.59 | 208.89 | 1667486.0 |
| 2025-05-13 13:00:00 | IWM | ETF | 208.9 | 209.4 | 208.69 | 208.89 | 1668252.0 |
| 2025-05-13 14:00:00 | IWM | ETF | 208.905 | 209.39 | 208.74 | 209.31 | 2282108.0 |
| 2025-05-13 15:00:00 | IWM | ETF | 209.315 | 209.61 | 208.615 | 208.67 | 4637372.0 |
| 2025-05-13 16:00:00 | IWM | ETF | 208.63 | 208.7 | 208.21 | 208.21 | 930068.0 |
| 2025-05-13 17:00:00 | IWM | ETF | 208.41 | 208.41 | 208.1 | 208.38 | 6022.0 |
| 2025-05-13 18:00:00 | IWM | ETF | 208.38 | 208.63 | 208.31 | 208.51 | 23509.0 |
| 2025-05-13 19:00:00 | IWM | ETF | 208.6 | 208.74 | 208.45 | 208.64 | 9520.0 |
| 2025-05-13 04:00:00 | DIA | ETF | 423.33 | 423.49 | 423.26 | 423.26 | 1400.0 |
| 2025-05-13 05:00:00 | DIA | ETF | 423.86 | 423.86 | 423.86 | 423.86 | 100.0 |
> showing 50 of 25,499 rows — these rows as CSV