PREVIEW / etf_1hour / 2025-01-27
file: by_date/etf_1hour/2025/2025-01-27.parquet size: 651 KB rows: 25,301
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-01-27 04:00:00 | SPY | ETF | 598.78 | 598.83 | 595.68 | 595.9 | 188644.0 |
| 2025-01-27 05:00:00 | SPY | ETF | 595.95 | 595.98 | 589.75 | 592.25 | 400243.0 |
| 2025-01-27 06:00:00 | SPY | ETF | 592.25 | 594.2 | 592.1 | 593.23 | 983751.0 |
| 2025-01-27 07:00:00 | SPY | ETF | 593.24 | 595.67 | 593.16 | 595.05 | 1112051.0 |
| 2025-01-27 08:00:00 | SPY | ETF | 593.69 | 602.3 | 590.5251 | 595.67 | 958490.0 |
| 2025-01-27 09:00:00 | SPY | ETF | 595.77 | 598.665 | 594.63 | 598.62 | 8072871.0 |
| 2025-01-27 10:00:00 | SPY | ETF | 598.59 | 599.69 | 596.67 | 598.08 | 6213470.0 |
| 2025-01-27 11:00:00 | SPY | ETF | 598.09 | 598.25 | 596.24 | 596.81 | 4133912.0 |
| 2025-01-27 12:00:00 | SPY | ETF | 596.85 | 598.21 | 596.15 | 596.2 | 3524925.0 |
| 2025-01-27 13:00:00 | SPY | ETF | 596.19 | 597.43 | 596.03 | 596.58 | 2300658.0 |
| 2025-01-27 14:00:00 | SPY | ETF | 596.61 | 599.12 | 596.27 | 596.94 | 4197644.0 |
| 2025-01-27 15:00:00 | SPY | ETF | 596.94 | 599.57 | 596.33 | 599.41 | 9467132.0 |
| 2025-01-27 16:00:00 | SPY | ETF | 599.44 | 600.36 | 599.2 | 599.76 | 2913096.0 |
| 2025-01-27 17:00:00 | SPY | ETF | 599.74 | 600.68 | 599.74 | 600.68 | 89273.0 |
| 2025-01-27 18:00:00 | SPY | ETF | 600.47 | 600.66 | 598.54 | 599.911 | 291167.0 |
| 2025-01-27 19:00:00 | SPY | ETF | 599.94 | 600.11 | 598.78 | 599.17 | 57547.0 |
| 2025-01-27 04:00:00 | QQQ | ETF | 516.78 | 517.78 | 511.69 | 511.82 | 473850.0 |
| 2025-01-27 05:00:00 | QQQ | ETF | 511.85 | 512.0 | 502.32 | 505.31 | 556181.0 |
| 2025-01-27 06:00:00 | QQQ | ETF | 505.29 | 508.93 | 505.03 | 508.03 | 1012547.0 |
| 2025-01-27 07:00:00 | QQQ | ETF | 508.15 | 510.68 | 508.06 | 510.15 | 1209555.0 |
| 2025-01-27 08:00:00 | QQQ | ETF | 508.94 | 529.233 | 502.7296 | 511.72 | 1593917.0 |
| 2025-01-27 09:00:00 | QQQ | ETF | 511.8101 | 516.14 | 510.4 | 515.93 | 7879537.0 |
| 2025-01-27 10:00:00 | QQQ | ETF | 515.87 | 517.99 | 513.4 | 515.446 | 5905664.0 |
| 2025-01-27 11:00:00 | QQQ | ETF | 515.48 | 515.8 | 512.37 | 512.9199 | 4074854.0 |
| 2025-01-27 12:00:00 | QQQ | ETF | 512.96 | 514.32 | 511.24 | 511.2801 | 2963365.0 |
| 2025-01-27 13:00:00 | QQQ | ETF | 511.31 | 513.03 | 511.22 | 511.47 | 3131032.0 |
| 2025-01-27 14:00:00 | QQQ | ETF | 511.46 | 514.0804 | 510.15 | 511.04 | 3460000.0 |
| 2025-01-27 15:00:00 | QQQ | ETF | 511.04 | 514.2 | 510.9 | 514.05 | 6692137.0 |
| 2025-01-27 16:00:00 | QQQ | ETF | 514.06 | 515.72 | 513.87 | 515.15 | 2589973.0 |
| 2025-01-27 17:00:00 | QQQ | ETF | 515.12 | 516.12 | 515.05 | 516.12 | 121865.0 |
| 2025-01-27 18:00:00 | QQQ | ETF | 516.08 | 516.32 | 513.86 | 515.69 | 274145.0 |
| 2025-01-27 19:00:00 | QQQ | ETF | 515.6 | 516.02 | 514.4 | 514.6916 | 88445.0 |
| 2025-01-27 04:00:00 | IWM | ETF | 225.69 | 226.99 | 225.58 | 226.82 | 68731.0 |
| 2025-01-27 05:00:00 | IWM | ETF | 226.75 | 226.75 | 225.84 | 225.85 | 86901.0 |
| 2025-01-27 06:00:00 | IWM | ETF | 225.7 | 226.57 | 225.66 | 225.86 | 139220.0 |
| 2025-01-27 07:00:00 | IWM | ETF | 225.86 | 226.61 | 225.57 | 226.4 | 288105.0 |
| 2025-01-27 08:00:00 | IWM | ETF | 225.95 | 227.21 | 225.1 | 226.81 | 366521.0 |
| 2025-01-27 09:00:00 | IWM | ETF | 226.85 | 229.5 | 226.45 | 229.41 | 3787910.0 |
| 2025-01-27 10:00:00 | IWM | ETF | 229.41 | 229.62 | 227.76 | 227.77 | 3490606.0 |
| 2025-01-27 11:00:00 | IWM | ETF | 227.78 | 228.03 | 226.44 | 226.84 | 2383592.0 |
| 2025-01-27 12:00:00 | IWM | ETF | 226.84 | 227.49 | 225.86 | 225.87 | 2007721.0 |
| 2025-01-27 13:00:00 | IWM | ETF | 225.89 | 226.53 | 225.21 | 225.26 | 1653361.0 |
| 2025-01-27 14:00:00 | IWM | ETF | 225.26 | 226.36 | 225.26 | 225.42 | 1793885.0 |
| 2025-01-27 15:00:00 | IWM | ETF | 225.42 | 226.67 | 225.2902 | 226.54 | 4046884.0 |
| 2025-01-27 16:00:00 | IWM | ETF | 226.5 | 226.84 | 226.46 | 226.48 | 1215061.0 |
| 2025-01-27 17:00:00 | IWM | ETF | 226.43 | 226.59 | 226.27 | 226.56 | 27429.0 |
| 2025-01-27 18:00:00 | IWM | ETF | 226.56 | 226.79 | 225.87 | 226.44 | 32158.0 |
| 2025-01-27 19:00:00 | IWM | ETF | 226.33 | 226.49 | 225.77 | 225.9701 | 11794.0 |
| 2025-01-27 04:00:00 | DIA | ETF | 438.81 | 440.57 | 438.81 | 440.57 | 14754.0 |
| 2025-01-27 05:00:00 | DIA | ETF | 440.1 | 440.82 | 439.74 | 440.04 | 19064.0 |
> showing 50 of 25,301 rows — these rows as CSV