PREVIEW / etf_1hour / 2025-05-19
file: by_date/etf_1hour/2025/2025-05-19.parquet size: 644 KB rows: 25,389
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-19 04:00:00 | SPY | ETF | 588.2 | 588.88 | 586.2 | 586.7 | 122399.0 |
| 2025-05-19 05:00:00 | SPY | ETF | 586.41 | 587.67 | 586.33 | 587.38 | 175150.0 |
| 2025-05-19 06:00:00 | SPY | ETF | 587.36 | 588.21 | 586.51 | 587.84 | 80052.0 |
| 2025-05-19 07:00:00 | SPY | ETF | 587.87 | 588.69 | 587.5 | 588.58 | 314164.0 |
| 2025-05-19 08:00:00 | SPY | ETF | 588.08 | 589.1 | 586.6004 | 588.67 | 468852.0 |
| 2025-05-19 09:00:00 | SPY | ETF | 588.64 | 591.41 | 587.1 | 591.24 | 7478547.0 |
| 2025-05-19 10:00:00 | SPY | ETF | 591.24 | 593.3 | 591.05 | 592.015 | 7344415.0 |
| 2025-05-19 11:00:00 | SPY | ETF | 592.02 | 593.77 | 588.51 | 593.1 | 3682459.0 |
| 2025-05-19 12:00:00 | SPY | ETF | 593.1057 | 594.76 | 588.9495 | 594.54 | 3930154.0 |
| 2025-05-19 13:00:00 | SPY | ETF | 594.54 | 595.54 | 589.57 | 594.36 | 5312800.0 |
| 2025-05-19 14:00:00 | SPY | ETF | 594.36 | 594.55 | 593.335 | 594.39 | 4638352.0 |
| 2025-05-19 15:00:00 | SPY | ETF | 594.4 | 595.25 | 593.16 | 594.94 | 10303336.0 |
| 2025-05-19 16:00:00 | SPY | ETF | 594.94 | 595.05 | 593.87 | 594.85 | 3504964.0 |
| 2025-05-19 17:00:00 | SPY | ETF | 594.8 | 594.96 | 594.5218 | 594.77 | 114211.0 |
| 2025-05-19 18:00:00 | SPY | ETF | 594.74 | 594.959 | 594.46 | 594.72 | 62626.0 |
| 2025-05-19 19:00:00 | SPY | ETF | 594.8099 | 596.05 | 594.7 | 595.54 | 105471.0 |
| 2025-05-19 04:00:00 | QQQ | ETF | 514.14 | 514.14 | 512.09 | 512.64 | 220695.0 |
| 2025-05-19 05:00:00 | QQQ | ETF | 512.58 | 513.7 | 512.26 | 513.4 | 99836.0 |
| 2025-05-19 06:00:00 | QQQ | ETF | 513.4 | 514.34 | 512.56 | 513.88 | 132379.0 |
| 2025-05-19 07:00:00 | QQQ | ETF | 513.9 | 514.56 | 513.34 | 514.36 | 273493.0 |
| 2025-05-19 08:00:00 | QQQ | ETF | 513.88 | 516.3 | 512.5604 | 514.54 | 513113.0 |
| 2025-05-19 09:00:00 | QQQ | ETF | 514.54 | 518.44 | 513.12 | 518.01 | 6225390.0 |
| 2025-05-19 10:00:00 | QQQ | ETF | 517.99 | 520.95 | 517.8 | 518.8999 | 5782280.0 |
| 2025-05-19 11:00:00 | QQQ | ETF | 518.91 | 520.88 | 518.57 | 519.87 | 3354965.0 |
| 2025-05-19 12:00:00 | QQQ | ETF | 519.88 | 521.54 | 516.3 | 521.435 | 2439328.0 |
| 2025-05-19 13:00:00 | QQQ | ETF | 521.43 | 522.53 | 521.32 | 521.45 | 3804932.0 |
| 2025-05-19 14:00:00 | QQQ | ETF | 521.44 | 521.62 | 520.265 | 521.37 | 3084460.0 |
| 2025-05-19 15:00:00 | QQQ | ETF | 521.38 | 522.275 | 520.11 | 522.03 | 4893474.0 |
| 2025-05-19 16:00:00 | QQQ | ETF | 522.04 | 522.1 | 520.97 | 521.85 | 941095.0 |
| 2025-05-19 17:00:00 | QQQ | ETF | 521.83 | 522.0 | 521.67 | 521.7 | 39437.0 |
| 2025-05-19 18:00:00 | QQQ | ETF | 521.72 | 521.8 | 521.41 | 521.4601 | 28514.0 |
| 2025-05-19 19:00:00 | QQQ | ETF | 521.45 | 522.88 | 521.45 | 522.42 | 107375.0 |
| 2025-05-19 04:00:00 | IWM | ETF | 207.17 | 207.21 | 206.27 | 206.45 | 56061.0 |
| 2025-05-19 05:00:00 | IWM | ETF | 206.4 | 206.79 | 206.37 | 206.45 | 17315.0 |
| 2025-05-19 06:00:00 | IWM | ETF | 206.49 | 207.08 | 206.21 | 206.91 | 73516.0 |
| 2025-05-19 07:00:00 | IWM | ETF | 206.94 | 207.2 | 206.71 | 207.11 | 78491.0 |
| 2025-05-19 08:00:00 | IWM | ETF | 207.0 | 207.89 | 206.61 | 206.99 | 169371.0 |
| 2025-05-19 09:00:00 | IWM | ETF | 207.02 | 207.67 | 206.26 | 207.1891 | 4659495.0 |
| 2025-05-19 10:00:00 | IWM | ETF | 207.18 | 208.13 | 207.125 | 207.55 | 2474918.0 |
| 2025-05-19 11:00:00 | IWM | ETF | 207.56 | 208.15 | 207.55 | 207.99 | 1207049.0 |
| 2025-05-19 12:00:00 | IWM | ETF | 207.98 | 208.86 | 207.11 | 208.57 | 1380201.0 |
| 2025-05-19 13:00:00 | IWM | ETF | 208.55 | 208.9 | 208.415 | 208.42 | 2010660.0 |
| 2025-05-19 14:00:00 | IWM | ETF | 208.43 | 208.665 | 208.19 | 208.45 | 1536090.0 |
| 2025-05-19 15:00:00 | IWM | ETF | 208.46 | 209.09 | 208.23 | 208.97 | 4252519.0 |
| 2025-05-19 16:00:00 | IWM | ETF | 208.97 | 209.02 | 208.62 | 208.87 | 1783037.0 |
| 2025-05-19 17:00:00 | IWM | ETF | 208.89 | 208.92 | 208.69 | 208.79 | 7252.0 |
| 2025-05-19 18:00:00 | IWM | ETF | 208.78 | 208.94 | 208.78 | 208.85 | 14963.0 |
| 2025-05-19 19:00:00 | IWM | ETF | 208.8 | 209.1988 | 208.79 | 209.03 | 8864.0 |
| 2025-05-19 04:00:00 | DIA | ETF | 422.81 | 423.24 | 422.81 | 422.92 | 3668.0 |
| 2025-05-19 05:00:00 | DIA | ETF | 422.81 | 423.35 | 422.81 | 423.1 | 810.0 |
> showing 50 of 25,389 rows — these rows as CSV