PREVIEW / etf_1hour / 2025-08-12
file: by_date/etf_1hour/2025/2025-08-12.parquet size: 681 KB rows: 25,805
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-12 04:00:00 | SPY | ETF | 636.68 | 636.83 | 636.09 | 636.09 | 21491.0 |
| 2025-08-12 05:00:00 | SPY | ETF | 636.16 | 636.37 | 635.97 | 635.97 | 32834.0 |
| 2025-08-12 06:00:00 | SPY | ETF | 635.91 | 636.03 | 635.74 | 635.74 | 53192.0 |
| 2025-08-12 07:00:00 | SPY | ETF | 635.83 | 635.83 | 635.14 | 635.75 | 99133.0 |
| 2025-08-12 08:00:00 | SPY | ETF | 635.71 | 640.1 | 635.23 | 639.03 | 1936417.0 |
| 2025-08-12 09:00:00 | SPY | ETF | 639.19 | 639.875 | 636.97 | 637.34 | 8873244.0 |
| 2025-08-12 10:00:00 | SPY | ETF | 637.36 | 640.23 | 636.79 | 639.875 | 7427381.0 |
| 2025-08-12 11:00:00 | SPY | ETF | 639.87 | 641.27 | 639.825 | 641.23 | 6305613.0 |
| 2025-08-12 12:00:00 | SPY | ETF | 641.23 | 641.99 | 640.86 | 641.7 | 3724595.0 |
| 2025-08-12 13:00:00 | SPY | ETF | 641.7 | 642.145 | 641.425 | 642.06 | 3166948.0 |
| 2025-08-12 14:00:00 | SPY | ETF | 642.07 | 642.615 | 641.975 | 642.035 | 4131804.0 |
| 2025-08-12 15:00:00 | SPY | ETF | 642.04 | 642.85 | 641.98 | 642.64 | 10465511.0 |
| 2025-08-12 16:00:00 | SPY | ETF | 642.64 | 642.86 | 642.44 | 642.7995 | 3130495.0 |
| 2025-08-12 17:00:00 | SPY | ETF | 642.72 | 642.72 | 642.35 | 642.42 | 50356.0 |
| 2025-08-12 18:00:00 | SPY | ETF | 642.43 | 642.6 | 642.3002 | 642.38 | 58037.0 |
| 2025-08-12 19:00:00 | SPY | ETF | 642.4199 | 643.1 | 642.4199 | 643.06 | 65401.0 |
| 2025-08-12 04:00:00 | QQQ | ETF | 573.31 | 573.67 | 572.84 | 572.94 | 22338.0 |
| 2025-08-12 05:00:00 | QQQ | ETF | 572.93 | 573.22 | 572.85 | 572.86 | 17787.0 |
| 2025-08-12 06:00:00 | QQQ | ETF | 572.73 | 573.03 | 572.71 | 572.77 | 9575.0 |
| 2025-08-12 07:00:00 | QQQ | ETF | 572.78 | 572.96 | 572.18 | 572.95 | 62110.0 |
| 2025-08-12 08:00:00 | QQQ | ETF | 572.42 | 577.24 | 572.0 | 576.12 | 961627.0 |
| 2025-08-12 09:00:00 | QQQ | ETF | 576.16 | 576.94 | 573.14 | 573.26 | 6167406.0 |
| 2025-08-12 10:00:00 | QQQ | ETF | 573.28 | 576.32 | 572.485 | 576.21 | 4680474.0 |
| 2025-08-12 11:00:00 | QQQ | ETF | 576.21 | 578.47 | 576.135 | 578.4 | 4222335.0 |
| 2025-08-12 12:00:00 | QQQ | ETF | 578.398 | 579.41 | 577.8855 | 579.165 | 2234245.0 |
| 2025-08-12 13:00:00 | QQQ | ETF | 579.17 | 579.55 | 578.83 | 579.51 | 2150211.0 |
| 2025-08-12 14:00:00 | QQQ | ETF | 579.51 | 579.95 | 579.31 | 579.34 | 1964249.0 |
| 2025-08-12 15:00:00 | QQQ | ETF | 579.34 | 580.35 | 579.24 | 580.02 | 5902675.0 |
| 2025-08-12 16:00:00 | QQQ | ETF | 580.02 | 580.45 | 579.78 | 580.3993 | 973087.0 |
| 2025-08-12 17:00:00 | QQQ | ETF | 580.38 | 580.4 | 579.9 | 580.0 | 455799.0 |
| 2025-08-12 18:00:00 | QQQ | ETF | 580.0 | 580.15 | 579.8 | 579.94 | 83985.0 |
| 2025-08-12 19:00:00 | QQQ | ETF | 579.9 | 580.8 | 579.88 | 580.65 | 93573.0 |
| 2025-08-12 04:00:00 | IWM | ETF | 221.03 | 221.03 | 220.25 | 220.68 | 10794.0 |
| 2025-08-12 05:00:00 | IWM | ETF | 220.73 | 220.94 | 220.73 | 220.78 | 9480.0 |
| 2025-08-12 06:00:00 | IWM | ETF | 220.79 | 220.8 | 220.44 | 220.46 | 20826.0 |
| 2025-08-12 07:00:00 | IWM | ETF | 220.48 | 220.7 | 220.28 | 220.68 | 67813.0 |
| 2025-08-12 08:00:00 | IWM | ETF | 220.7 | 223.69 | 220.32 | 222.61 | 1379381.0 |
| 2025-08-12 09:00:00 | IWM | ETF | 222.6 | 222.85 | 221.15 | 222.16 | 6999251.0 |
| 2025-08-12 10:00:00 | IWM | ETF | 222.17 | 224.62 | 221.99 | 224.32 | 7234607.0 |
| 2025-08-12 11:00:00 | IWM | ETF | 224.32 | 225.095 | 224.13 | 224.98 | 3529424.0 |
| 2025-08-12 12:00:00 | IWM | ETF | 224.98 | 225.22 | 224.74 | 225.18 | 2169159.0 |
| 2025-08-12 13:00:00 | IWM | ETF | 225.175 | 225.765 | 225.065 | 225.655 | 2585745.0 |
| 2025-08-12 14:00:00 | IWM | ETF | 225.66 | 226.305 | 225.66 | 225.935 | 2679474.0 |
| 2025-08-12 15:00:00 | IWM | ETF | 225.93 | 226.975 | 225.9299 | 226.78 | 6578863.0 |
| 2025-08-12 16:00:00 | IWM | ETF | 226.81 | 227.06 | 226.7 | 227.02 | 1402909.0 |
| 2025-08-12 17:00:00 | IWM | ETF | 226.99 | 227.119 | 226.7701 | 226.84 | 122434.0 |
| 2025-08-12 18:00:00 | IWM | ETF | 226.8 | 226.89 | 226.75 | 226.81 | 88801.0 |
| 2025-08-12 19:00:00 | IWM | ETF | 226.81 | 227.46 | 226.77 | 227.44 | 94197.0 |
| 2025-08-12 04:00:00 | DIA | ETF | 440.72 | 440.82 | 440.49 | 440.49 | 2200.0 |
| 2025-08-12 05:00:00 | DIA | ETF | 440.56 | 440.65 | 440.49 | 440.54 | 1100.0 |
> showing 50 of 25,805 rows — these rows as CSV