PREVIEW / etf_1hour / 2025-08-20
file: by_date/etf_1hour/2025/2025-08-20.parquet size: 667 KB rows: 25,492
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-08-20 04:00:00 | SPY | ETF | 637.22 | 638.78 | 637.22 | 638.46 | 52329.0 |
| 2025-08-20 05:00:00 | SPY | ETF | 638.56 | 639.14 | 638.41 | 639.02 | 22247.0 |
| 2025-08-20 06:00:00 | SPY | ETF | 638.95 | 639.39 | 638.87 | 639.13 | 6117.0 |
| 2025-08-20 07:00:00 | SPY | ETF | 639.12 | 639.53 | 638.5 | 639.01 | 111441.0 |
| 2025-08-20 08:00:00 | SPY | ETF | 639.42 | 639.58 | 637.49 | 639.23 | 272704.0 |
| 2025-08-20 09:00:00 | SPY | ETF | 639.25 | 639.66 | 634.96 | 635.39 | 10890163.0 |
| 2025-08-20 10:00:00 | SPY | ETF | 635.38 | 636.29 | 632.95 | 633.38 | 11835326.0 |
| 2025-08-20 11:00:00 | SPY | ETF | 633.38 | 636.9 | 633.18 | 635.15 | 7908949.0 |
| 2025-08-20 12:00:00 | SPY | ETF | 635.14 | 637.4758 | 635.075 | 636.315 | 5525201.0 |
| 2025-08-20 13:00:00 | SPY | ETF | 636.31 | 637.96 | 636.13 | 637.198 | 3467699.0 |
| 2025-08-20 14:00:00 | SPY | ETF | 637.18 | 637.38 | 635.21 | 636.69 | 6528713.0 |
| 2025-08-20 15:00:00 | SPY | ETF | 636.69 | 639.06 | 636.69 | 638.07 | 11615054.0 |
| 2025-08-20 16:00:00 | SPY | ETF | 638.05 | 638.18 | 636.4788 | 638.08 | 2758265.0 |
| 2025-08-20 17:00:00 | SPY | ETF | 638.0 | 638.13 | 637.9 | 637.96 | 73963.0 |
| 2025-08-20 18:00:00 | SPY | ETF | 638.07 | 638.35 | 637.6 | 637.8196 | 109548.0 |
| 2025-08-20 19:00:00 | SPY | ETF | 637.75 | 637.9 | 637.49 | 637.8 | 34993.0 |
| 2025-08-20 04:00:00 | QQQ | ETF | 567.72 | 568.19 | 567.05 | 568.0 | 84865.0 |
| 2025-08-20 05:00:00 | QQQ | ETF | 568.06 | 568.63 | 567.87 | 568.45 | 47246.0 |
| 2025-08-20 06:00:00 | QQQ | ETF | 568.39 | 568.69 | 567.82 | 568.35 | 40606.0 |
| 2025-08-20 07:00:00 | QQQ | ETF | 568.3 | 568.91 | 567.37 | 567.99 | 135947.0 |
| 2025-08-20 08:00:00 | QQQ | ETF | 568.56 | 568.869 | 566.1 | 568.32 | 314195.0 |
| 2025-08-20 09:00:00 | QQQ | ETF | 568.31 | 568.45 | 561.52 | 562.18 | 9425481.0 |
| 2025-08-20 10:00:00 | QQQ | ETF | 562.18 | 563.17 | 558.84 | 559.368 | 11659122.0 |
| 2025-08-20 11:00:00 | QQQ | ETF | 559.37 | 564.42 | 559.1 | 562.13 | 8915130.0 |
| 2025-08-20 12:00:00 | QQQ | ETF | 562.13 | 565.33 | 562.06 | 563.64 | 5285144.0 |
| 2025-08-20 13:00:00 | QQQ | ETF | 563.64 | 565.62 | 563.46 | 564.39 | 4392158.0 |
| 2025-08-20 14:00:00 | QQQ | ETF | 564.37 | 564.77 | 562.6 | 563.89 | 4716203.0 |
| 2025-08-20 15:00:00 | QQQ | ETF | 563.88 | 566.89 | 563.88 | 565.85 | 6904287.0 |
| 2025-08-20 16:00:00 | QQQ | ETF | 565.86 | 565.99 | 564.467 | 565.7 | 1442124.0 |
| 2025-08-20 17:00:00 | QQQ | ETF | 565.6208 | 565.74 | 565.51 | 565.59 | 102514.0 |
| 2025-08-20 18:00:00 | QQQ | ETF | 565.6 | 566.2 | 565.59 | 565.78 | 105000.0 |
| 2025-08-20 19:00:00 | QQQ | ETF | 565.7801 | 565.92 | 565.39 | 565.7 | 78775.0 |
| 2025-08-20 04:00:00 | IWM | ETF | 225.8 | 226.02 | 225.36 | 225.92 | 52764.0 |
| 2025-08-20 05:00:00 | IWM | ETF | 225.96 | 226.36 | 225.91 | 226.29 | 28802.0 |
| 2025-08-20 06:00:00 | IWM | ETF | 226.21 | 226.48 | 226.19 | 226.28 | 16534.0 |
| 2025-08-20 07:00:00 | IWM | ETF | 226.35 | 226.41 | 225.98 | 226.06 | 60364.0 |
| 2025-08-20 08:00:00 | IWM | ETF | 225.96 | 226.4 | 225.31 | 226.0 | 98485.0 |
| 2025-08-20 09:00:00 | IWM | ETF | 225.99 | 226.375 | 224.195 | 224.56 | 3307585.0 |
| 2025-08-20 10:00:00 | IWM | ETF | 224.555 | 225.33 | 223.69 | 223.985 | 4640874.0 |
| 2025-08-20 11:00:00 | IWM | ETF | 223.99 | 225.28 | 223.81 | 224.41 | 3547924.0 |
| 2025-08-20 12:00:00 | IWM | ETF | 224.4 | 225.2 | 224.39 | 224.78 | 2115683.0 |
| 2025-08-20 13:00:00 | IWM | ETF | 224.78 | 225.39 | 224.73 | 225.28 | 1842702.0 |
| 2025-08-20 14:00:00 | IWM | ETF | 225.27 | 225.2951 | 224.235 | 224.87 | 3181970.0 |
| 2025-08-20 15:00:00 | IWM | ETF | 224.88 | 225.875 | 224.88 | 225.43 | 4433823.0 |
| 2025-08-20 16:00:00 | IWM | ETF | 225.41 | 225.64 | 225.35 | 225.58 | 745326.0 |
| 2025-08-20 17:00:00 | IWM | ETF | 225.63 | 225.63 | 225.45 | 225.5 | 8400.0 |
| 2025-08-20 18:00:00 | IWM | ETF | 225.51 | 225.67 | 225.31 | 225.4 | 24064.0 |
| 2025-08-20 19:00:00 | IWM | ETF | 225.43 | 225.51 | 225.26 | 225.45 | 30539.0 |
| 2025-08-20 04:00:00 | DIA | ETF | 448.06 | 448.38 | 448.06 | 448.32 | 1400.0 |
| 2025-08-20 05:00:00 | DIA | ETF | 448.21 | 448.71 | 448.2 | 448.71 | 3687.0 |
> showing 50 of 25,492 rows — these rows as CSV