PREVIEW / etf_1hour / 2026-03-16
file: by_date/etf_1hour/2026/2026-03-16.parquet size: 646 KB rows: 25,236
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 |
|---|---|---|---|---|---|---|---|
| 2026-03-16 04:00:00 | SPY | ETF | 664.0 | 666.58 | 664.0 | 665.3 | 147231.0 |
| 2026-03-16 05:00:00 | SPY | ETF | 665.34 | 665.34 | 663.9 | 664.32 | 118745.0 |
| 2026-03-16 06:00:00 | SPY | ETF | 664.25 | 667.3 | 664.25 | 667.18 | 280404.0 |
| 2026-03-16 07:00:00 | SPY | ETF | 667.14 | 667.67 | 666.28 | 667.44 | 517615.0 |
| 2026-03-16 08:00:00 | SPY | ETF | 664.7 | 669.05 | 664.04 | 668.1 | 1166378.0 |
| 2026-03-16 09:00:00 | SPY | ETF | 668.13 | 670.9 | 662.3043 | 670.8 | 8456389.0 |
| 2026-03-16 10:00:00 | SPY | ETF | 670.8 | 671.4 | 667.575 | 669.83 | 10436587.0 |
| 2026-03-16 11:00:00 | SPY | ETF | 669.84 | 670.64 | 668.44 | 668.47 | 6080474.0 |
| 2026-03-16 12:00:00 | SPY | ETF | 668.47 | 669.19 | 667.12 | 668.425 | 6478837.0 |
| 2026-03-16 13:00:00 | SPY | ETF | 668.43 | 669.75 | 667.98 | 668.755 | 4970622.0 |
| 2026-03-16 14:00:00 | SPY | ETF | 668.76 | 670.31 | 668.66 | 669.605 | 6613289.0 |
| 2026-03-16 15:00:00 | SPY | ETF | 669.605 | 672.07 | 668.42 | 668.96 | 15975281.0 |
| 2026-03-16 16:00:00 | SPY | ETF | 668.96 | 669.38 | 668.28 | 668.6 | 2672225.0 |
| 2026-03-16 17:00:00 | SPY | ETF | 668.63 | 669.03 | 668.26 | 668.6 | 220329.0 |
| 2026-03-16 18:00:00 | SPY | ETF | 668.7091 | 668.7091 | 667.94 | 667.95 | 82106.0 |
| 2026-03-16 19:00:00 | SPY | ETF | 667.99 | 668.8 | 667.99 | 668.8 | 35946.0 |
| 2026-03-16 04:00:00 | QQQ | ETF | 596.49 | 597.91 | 595.8 | 596.93 | 139098.0 |
| 2026-03-16 05:00:00 | QQQ | ETF | 597.03 | 597.12 | 595.79 | 596.07 | 137712.0 |
| 2026-03-16 06:00:00 | QQQ | ETF | 596.09 | 599.0 | 595.99 | 598.77 | 172750.0 |
| 2026-03-16 07:00:00 | QQQ | ETF | 598.74 | 599.51 | 598.08 | 599.29 | 228317.0 |
| 2026-03-16 08:00:00 | QQQ | ETF | 598.74 | 600.8 | 595.91 | 600.08 | 768744.0 |
| 2026-03-16 09:00:00 | QQQ | ETF | 600.09 | 602.03 | 599.23 | 601.91 | 5613757.0 |
| 2026-03-16 10:00:00 | QQQ | ETF | 601.9 | 602.6 | 599.13 | 600.94 | 7238132.0 |
| 2026-03-16 11:00:00 | QQQ | ETF | 600.94 | 601.99 | 599.802 | 600.46 | 4374946.0 |
| 2026-03-16 12:00:00 | QQQ | ETF | 600.46 | 601.15 | 599.11 | 600.48 | 3901016.0 |
| 2026-03-16 13:00:00 | QQQ | ETF | 600.48 | 601.64 | 599.93 | 600.65 | 3419405.0 |
| 2026-03-16 14:00:00 | QQQ | ETF | 600.645 | 601.89 | 600.48 | 601.15 | 4183896.0 |
| 2026-03-16 15:00:00 | QQQ | ETF | 601.15 | 603.86 | 599.53 | 600.31 | 9759537.0 |
| 2026-03-16 16:00:00 | QQQ | ETF | 600.33 | 600.71 | 599.78 | 600.01 | 1252526.0 |
| 2026-03-16 17:00:00 | QQQ | ETF | 600.06 | 600.09 | 599.8819 | 599.95 | 52660.0 |
| 2026-03-16 18:00:00 | QQQ | ETF | 600.0 | 600.13 | 599.17 | 599.3 | 114599.0 |
| 2026-03-16 19:00:00 | QQQ | ETF | 599.31 | 600.242 | 599.22 | 600.21 | 51462.0 |
| 2026-03-16 04:00:00 | IWM | ETF | 247.99 | 248.5 | 247.38 | 247.55 | 77957.0 |
| 2026-03-16 05:00:00 | IWM | ETF | 247.54 | 247.68 | 246.76 | 247.07 | 53679.0 |
| 2026-03-16 06:00:00 | IWM | ETF | 246.91 | 249.07 | 246.88 | 249.05 | 71419.0 |
| 2026-03-16 07:00:00 | IWM | ETF | 248.96 | 249.23 | 248.12 | 249.23 | 240785.0 |
| 2026-03-16 08:00:00 | IWM | ETF | 248.96 | 249.91 | 247.05 | 249.46 | 495014.0 |
| 2026-03-16 09:00:00 | IWM | ETF | 249.47 | 251.265 | 249.43 | 251.24 | 5747447.0 |
| 2026-03-16 10:00:00 | IWM | ETF | 251.24 | 251.465 | 249.18 | 250.4 | 4624744.0 |
| 2026-03-16 11:00:00 | IWM | ETF | 250.41 | 250.455 | 249.135 | 249.135 | 3265808.0 |
| 2026-03-16 12:00:00 | IWM | ETF | 249.14 | 249.3 | 248.31 | 248.86 | 2587535.0 |
| 2026-03-16 13:00:00 | IWM | ETF | 248.87 | 249.735 | 248.69 | 249.04 | 2700520.0 |
| 2026-03-16 14:00:00 | IWM | ETF | 249.07 | 250.315 | 248.99 | 249.93 | 2674416.0 |
| 2026-03-16 15:00:00 | IWM | ETF | 249.93 | 250.72 | 248.83 | 248.92 | 5450090.0 |
| 2026-03-16 16:00:00 | IWM | ETF | 248.92 | 249.04 | 248.5 | 248.61 | 1695171.0 |
| 2026-03-16 17:00:00 | IWM | ETF | 248.74 | 248.74 | 248.3989 | 248.53 | 40860.0 |
| 2026-03-16 18:00:00 | IWM | ETF | 248.62 | 248.6206 | 248.0617 | 248.14 | 41227.0 |
| 2026-03-16 19:00:00 | IWM | ETF | 248.1112 | 248.56 | 248.11 | 248.4914 | 16434.0 |
| 2026-03-16 04:00:00 | DIA | ETF | 468.36 | 468.36 | 467.3 | 467.65 | 2666.0 |
| 2026-03-16 05:00:00 | DIA | ETF | 467.62 | 467.62 | 466.86 | 467.16 | 3821.0 |
> showing 50 of 25,236 rows — these rows as CSV