PREVIEW / etf_30min / 2025-11-10
file: by_date/etf_30min/2025/2025-11-10.parquet size: 1.1 MB rows: 45,103
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-11-10 04:00:00 | SPY | ETF | 675.62 | 677.94 | 675.62 | 677.34 | 69903.0 |
| 2025-11-10 04:30:00 | SPY | ETF | 677.34 | 677.72 | 677.19 | 677.62 | 39256.0 |
| 2025-11-10 05:00:00 | SPY | ETF | 677.62 | 677.68 | 677.37 | 677.44 | 11694.0 |
| 2025-11-10 05:30:00 | SPY | ETF | 677.48 | 677.8 | 677.3 | 677.38 | 13871.0 |
| 2025-11-10 06:00:00 | SPY | ETF | 677.39 | 677.61 | 676.76 | 676.89 | 27907.0 |
| 2025-11-10 06:30:00 | SPY | ETF | 676.86 | 677.65 | 676.81 | 677.65 | 69580.0 |
| 2025-11-10 07:00:00 | SPY | ETF | 677.65 | 677.74 | 676.9 | 676.95 | 332243.0 |
| 2025-11-10 07:30:00 | SPY | ETF | 676.95 | 677.29 | 676.79 | 677.11 | 81468.0 |
| 2025-11-10 08:00:00 | SPY | ETF | 677.59 | 677.7316 | 675.39 | 677.44 | 162290.0 |
| 2025-11-10 08:30:00 | SPY | ETF | 677.37 | 677.7 | 676.08 | 677.58 | 205217.0 |
| 2025-11-10 09:00:00 | SPY | ETF | 677.6 | 677.68 | 676.93 | 677.21 | 416577.0 |
| 2025-11-10 09:30:00 | SPY | ETF | 677.24 | 679.2 | 677.03 | 678.545 | 10054498.0 |
| 2025-11-10 10:00:00 | SPY | ETF | 678.54 | 679.22 | 678.16 | 678.86 | 4154667.0 |
| 2025-11-10 10:30:00 | SPY | ETF | 678.87 | 678.99 | 676.15 | 676.24 | 4610995.0 |
| 2025-11-10 11:00:00 | SPY | ETF | 676.25 | 676.82 | 675.24 | 675.555 | 4407879.0 |
| 2025-11-10 11:30:00 | SPY | ETF | 675.55 | 676.67 | 675.03 | 676.63 | 2671638.0 |
| 2025-11-10 12:00:00 | SPY | ETF | 676.62 | 677.85 | 676.45 | 677.465 | 2936453.0 |
| 2025-11-10 12:30:00 | SPY | ETF | 677.465 | 679.75 | 677.465 | 679.42 | 3104487.0 |
| 2025-11-10 13:00:00 | SPY | ETF | 679.42 | 680.05 | 679.34 | 679.475 | 2496414.0 |
| 2025-11-10 13:30:00 | SPY | ETF | 679.5 | 680.54 | 679.495 | 679.875 | 2235370.0 |
| 2025-11-10 14:00:00 | SPY | ETF | 679.88 | 680.9555 | 679.84 | 680.7815 | 2200329.0 |
| 2025-11-10 14:30:00 | SPY | ETF | 680.78 | 681.67 | 680.54 | 681.3 | 3388751.0 |
| 2025-11-10 15:00:00 | SPY | ETF | 681.29 | 682.08 | 681.15 | 681.31 | 3597989.0 |
| 2025-11-10 15:30:00 | SPY | ETF | 681.3 | 682.18 | 681.03 | 681.33 | 10145156.0 |
| 2025-11-10 16:00:00 | SPY | ETF | 681.32 | 682.0 | 681.18 | 681.7827 | 2492660.0 |
| 2025-11-10 16:30:00 | SPY | ETF | 681.8 | 681.9 | 681.39 | 681.42 | 173868.0 |
| 2025-11-10 17:00:00 | SPY | ETF | 681.51 | 681.6 | 681.25 | 681.59 | 100538.0 |
| 2025-11-10 17:30:00 | SPY | ETF | 681.521 | 681.59 | 681.49 | 681.49 | 26893.0 |
| 2025-11-10 18:00:00 | SPY | ETF | 681.49 | 681.61 | 681.11 | 681.4 | 67897.0 |
| 2025-11-10 18:30:00 | SPY | ETF | 681.44 | 681.9 | 681.15 | 681.85 | 23172.0 |
| 2025-11-10 19:00:00 | SPY | ETF | 681.8 | 682.33 | 681.6145 | 681.85 | 24058.0 |
| 2025-11-10 19:30:00 | SPY | ETF | 681.87 | 682.07 | 681.58 | 681.66 | 47018.0 |
| 2025-11-10 04:00:00 | QQQ | ETF | 617.12 | 619.67 | 617.12 | 619.0 | 122080.0 |
| 2025-11-10 04:30:00 | QQQ | ETF | 619.01 | 619.49 | 618.77 | 619.27 | 68328.0 |
| 2025-11-10 05:00:00 | QQQ | ETF | 619.35 | 619.39 | 618.91 | 618.96 | 85716.0 |
| 2025-11-10 05:30:00 | QQQ | ETF | 618.94 | 619.42 | 618.69 | 618.78 | 65610.0 |
| 2025-11-10 06:00:00 | QQQ | ETF | 618.78 | 619.12 | 618.22 | 618.31 | 82625.0 |
| 2025-11-10 06:30:00 | QQQ | ETF | 618.28 | 619.13 | 618.18 | 619.13 | 51877.0 |
| 2025-11-10 07:00:00 | QQQ | ETF | 619.12 | 619.25 | 618.36 | 618.46 | 169118.0 |
| 2025-11-10 07:30:00 | QQQ | ETF | 618.46 | 619.14 | 618.45 | 618.97 | 134213.0 |
| 2025-11-10 08:00:00 | QQQ | ETF | 617.82 | 619.47 | 610.197 | 619.18 | 378014.0 |
| 2025-11-10 08:30:00 | QQQ | ETF | 619.16 | 619.4 | 618.7 | 619.33 | 236463.0 |
| 2025-11-10 09:00:00 | QQQ | ETF | 619.32 | 619.34 | 618.5 | 618.86 | 342660.0 |
| 2025-11-10 09:30:00 | QQQ | ETF | 618.92 | 621.77 | 618.56 | 621.29 | 7293898.0 |
| 2025-11-10 10:00:00 | QQQ | ETF | 621.28 | 622.04 | 620.69 | 621.46 | 3811007.0 |
| 2025-11-10 10:30:00 | QQQ | ETF | 621.48 | 621.98 | 618.43 | 618.57 | 3781506.0 |
| 2025-11-10 11:00:00 | QQQ | ETF | 618.59 | 618.94 | 617.37 | 617.6101 | 3124313.0 |
| 2025-11-10 11:30:00 | QQQ | ETF | 617.61 | 618.63 | 616.89 | 618.57 | 2266160.0 |
| 2025-11-10 12:00:00 | QQQ | ETF | 618.57 | 619.87 | 618.24 | 619.2401 | 1999415.0 |
| 2025-11-10 12:30:00 | QQQ | ETF | 619.28 | 621.55 | 619.28 | 621.262 | 2063296.0 |
> showing 50 of 45,103 rows — these rows as CSV