PREVIEW / etf_30min / 2025-12-01
file: by_date/etf_30min/2025/2025-12-01.parquet size: 1.1 MB rows: 45,895
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-12-01 04:00:00 | SPY | ETF | 679.9 | 680.41 | 679.62 | 679.92 | 110090.0 |
| 2025-12-01 04:30:00 | SPY | ETF | 679.95 | 679.98 | 678.94 | 679.08 | 24288.0 |
| 2025-12-01 05:00:00 | SPY | ETF | 679.19 | 679.88 | 679.15 | 679.69 | 6416.0 |
| 2025-12-01 05:30:00 | SPY | ETF | 679.71 | 679.99 | 679.46 | 679.54 | 6455.0 |
| 2025-12-01 06:00:00 | SPY | ETF | 679.36 | 679.6 | 679.05 | 679.25 | 11269.0 |
| 2025-12-01 06:30:00 | SPY | ETF | 679.31 | 679.52 | 679.07 | 679.4 | 32574.0 |
| 2025-12-01 07:00:00 | SPY | ETF | 679.41 | 679.57 | 678.5 | 678.66 | 119275.0 |
| 2025-12-01 07:30:00 | SPY | ETF | 678.55 | 678.68 | 677.96 | 678.33 | 90444.0 |
| 2025-12-01 08:00:00 | SPY | ETF | 678.35 | 680.37 | 677.71 | 678.85 | 210633.0 |
| 2025-12-01 08:30:00 | SPY | ETF | 678.85 | 679.26 | 678.62 | 679.16 | 173265.0 |
| 2025-12-01 09:00:00 | SPY | ETF | 679.1496 | 679.75 | 678.65 | 678.79 | 211085.0 |
| 2025-12-01 09:30:00 | SPY | ETF | 678.8 | 681.86 | 678.74 | 681.45 | 6398261.0 |
| 2025-12-01 10:00:00 | SPY | ETF | 681.455 | 681.79 | 679.59 | 679.83 | 3957336.0 |
| 2025-12-01 10:30:00 | SPY | ETF | 679.84 | 681.83 | 678.84 | 681.64 | 3179769.0 |
| 2025-12-01 11:00:00 | SPY | ETF | 681.65 | 681.8 | 680.12 | 681.0799 | 1807858.0 |
| 2025-12-01 11:30:00 | SPY | ETF | 681.08 | 682.44 | 681.07 | 681.925 | 1945162.0 |
| 2025-12-01 12:00:00 | SPY | ETF | 681.96 | 682.51 | 681.295 | 682.01 | 1524252.0 |
| 2025-12-01 12:30:00 | SPY | ETF | 682.0 | 682.79 | 681.73 | 682.03 | 1356691.0 |
| 2025-12-01 13:00:00 | SPY | ETF | 682.04 | 682.79 | 681.975 | 682.48 | 1363143.0 |
| 2025-12-01 13:30:00 | SPY | ETF | 682.5 | 682.99 | 682.49 | 682.8205 | 1576700.0 |
| 2025-12-01 14:00:00 | SPY | ETF | 682.82 | 682.8493 | 680.48 | 680.6 | 3146776.0 |
| 2025-12-01 14:30:00 | SPY | ETF | 680.605 | 681.095 | 679.82 | 680.22 | 3034647.0 |
| 2025-12-01 15:00:00 | SPY | ETF | 680.2 | 681.015 | 680.03 | 680.73 | 2553140.0 |
| 2025-12-01 15:30:00 | SPY | ETF | 680.72 | 681.07 | 679.375 | 680.27 | 11688101.0 |
| 2025-12-01 16:00:00 | SPY | ETF | 680.28 | 680.4 | 679.8986 | 680.22 | 2532675.0 |
| 2025-12-01 16:30:00 | SPY | ETF | 680.22 | 680.26 | 680.0 | 680.09 | 99733.0 |
| 2025-12-01 17:00:00 | SPY | ETF | 680.17 | 680.24 | 680.03 | 680.0914 | 37838.0 |
| 2025-12-01 17:30:00 | SPY | ETF | 680.19 | 680.42 | 680.04 | 680.34 | 33554.0 |
| 2025-12-01 18:00:00 | SPY | ETF | 680.34 | 680.5 | 679.655 | 680.37 | 59906.0 |
| 2025-12-01 18:30:00 | SPY | ETF | 680.35 | 680.54 | 679.91 | 679.98 | 27577.0 |
| 2025-12-01 19:00:00 | SPY | ETF | 679.88 | 680.07 | 679.66 | 679.87 | 16624.0 |
| 2025-12-01 19:30:00 | SPY | ETF | 679.991 | 680.3 | 679.991 | 680.07 | 17447.0 |
| 2025-12-01 04:00:00 | QQQ | ETF | 615.85 | 615.85 | 614.55 | 615.16 | 71406.0 |
| 2025-12-01 04:30:00 | QQQ | ETF | 615.13 | 615.14 | 614.06 | 614.29 | 76186.0 |
| 2025-12-01 05:00:00 | QQQ | ETF | 614.28 | 615.28 | 614.28 | 615.0 | 45974.0 |
| 2025-12-01 05:30:00 | QQQ | ETF | 615.0 | 615.5 | 614.84 | 615.04 | 36309.0 |
| 2025-12-01 06:00:00 | QQQ | ETF | 615.0 | 615.17 | 614.43 | 614.78 | 45219.0 |
| 2025-12-01 06:30:00 | QQQ | ETF | 614.74 | 614.87 | 614.26 | 614.63 | 48647.0 |
| 2025-12-01 07:00:00 | QQQ | ETF | 614.64 | 614.83 | 613.4 | 613.57 | 173862.0 |
| 2025-12-01 07:30:00 | QQQ | ETF | 613.6 | 613.6 | 612.6 | 612.91 | 206797.0 |
| 2025-12-01 08:00:00 | QQQ | ETF | 614.81 | 618.786 | 612.13 | 613.45 | 557208.0 |
| 2025-12-01 08:30:00 | QQQ | ETF | 613.4 | 614.0 | 613.17 | 613.9 | 215551.0 |
| 2025-12-01 09:00:00 | QQQ | ETF | 613.87 | 614.68 | 613.42 | 613.63 | 277313.0 |
| 2025-12-01 09:30:00 | QQQ | ETF | 613.61 | 616.63 | 612.52 | 616.28 | 6365919.0 |
| 2025-12-01 10:00:00 | QQQ | ETF | 616.28 | 616.8513 | 614.93 | 615.29 | 3228266.0 |
| 2025-12-01 10:30:00 | QQQ | ETF | 615.31 | 617.6087 | 613.9488 | 617.4382 | 2747163.0 |
| 2025-12-01 11:00:00 | QQQ | ETF | 617.43 | 617.57 | 615.28 | 616.68 | 1957798.0 |
| 2025-12-01 11:30:00 | QQQ | ETF | 616.68 | 618.36 | 616.66 | 617.96 | 1613292.0 |
| 2025-12-01 12:00:00 | QQQ | ETF | 617.99 | 618.75 | 617.48 | 618.4233 | 1502033.0 |
| 2025-12-01 12:30:00 | QQQ | ETF | 618.42 | 619.4401 | 618.13 | 618.35 | 1396703.0 |
> showing 50 of 45,895 rows — these rows as CSV