PREVIEW / etf_30min / 2025-10-13
file: by_date/etf_30min/2025/2025-10-13.parquet size: 1.0 MB rows: 44,353
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-10-13 04:00:00 | SPY | ETF | 661.5 | 663.23 | 658.17 | 661.91 | 152316.0 |
| 2025-10-13 04:30:00 | SPY | ETF | 662.04 | 662.5 | 661.57 | 662.22 | 25390.0 |
| 2025-10-13 05:00:00 | SPY | ETF | 662.21 | 662.4 | 661.81 | 661.93 | 13450.0 |
| 2025-10-13 05:30:00 | SPY | ETF | 661.95 | 662.0 | 661.58 | 661.7 | 20818.0 |
| 2025-10-13 06:00:00 | SPY | ETF | 661.68 | 661.87 | 661.2 | 661.8 | 32864.0 |
| 2025-10-13 06:30:00 | SPY | ETF | 661.8 | 662.21 | 661.05 | 661.74 | 70169.0 |
| 2025-10-13 07:00:00 | SPY | ETF | 661.64 | 662.18 | 658.91 | 659.9 | 409020.0 |
| 2025-10-13 07:30:00 | SPY | ETF | 659.95 | 660.77 | 659.24 | 660.28 | 278158.0 |
| 2025-10-13 08:00:00 | SPY | ETF | 661.51 | 663.97 | 659.0 | 660.4693 | 409650.0 |
| 2025-10-13 08:30:00 | SPY | ETF | 660.39 | 661.25 | 660.37 | 660.61 | 246225.0 |
| 2025-10-13 09:00:00 | SPY | ETF | 660.59 | 661.73 | 660.56 | 660.65 | 656723.0 |
| 2025-10-13 09:30:00 | SPY | ETF | 660.65 | 663.0 | 659.8 | 662.8788 | 10952679.0 |
| 2025-10-13 10:00:00 | SPY | ETF | 662.87 | 663.23 | 660.111 | 660.85 | 6269789.0 |
| 2025-10-13 10:30:00 | SPY | ETF | 660.88 | 662.48 | 659.95 | 660.215 | 3794866.0 |
| 2025-10-13 11:00:00 | SPY | ETF | 660.21 | 662.85 | 659.7679 | 662.72 | 3557683.0 |
| 2025-10-13 11:30:00 | SPY | ETF | 662.72 | 663.175 | 662.23 | 662.97 | 2599963.0 |
| 2025-10-13 12:00:00 | SPY | ETF | 662.98 | 665.13 | 662.64 | 663.49 | 3658094.0 |
| 2025-10-13 12:30:00 | SPY | ETF | 663.485 | 664.37 | 663.02 | 664.24 | 2048052.0 |
| 2025-10-13 13:00:00 | SPY | ETF | 664.25 | 664.61 | 662.915 | 663.12 | 2064550.0 |
| 2025-10-13 13:30:00 | SPY | ETF | 663.13 | 663.31 | 662.37 | 663.26 | 1707382.0 |
| 2025-10-13 14:00:00 | SPY | ETF | 663.25 | 664.05 | 663.17 | 663.94 | 2067659.0 |
| 2025-10-13 14:30:00 | SPY | ETF | 663.935 | 664.27 | 661.82 | 662.08 | 3292496.0 |
| 2025-10-13 15:00:00 | SPY | ETF | 662.09 | 663.35 | 661.68 | 662.8192 | 3546994.0 |
| 2025-10-13 15:30:00 | SPY | ETF | 662.8 | 663.65 | 662.63 | 663.05 | 7712681.0 |
| 2025-10-13 16:00:00 | SPY | ETF | 663.06 | 663.22 | 662.6 | 662.74 | 2445966.0 |
| 2025-10-13 16:30:00 | SPY | ETF | 662.75 | 662.75 | 662.48 | 662.63 | 112426.0 |
| 2025-10-13 17:00:00 | SPY | ETF | 662.7799 | 662.7799 | 662.56 | 662.75 | 23604.0 |
| 2025-10-13 17:30:00 | SPY | ETF | 662.7494 | 662.83 | 662.69 | 662.8 | 16624.0 |
| 2025-10-13 18:00:00 | SPY | ETF | 662.71 | 663.26 | 662.61 | 662.61 | 42500.0 |
| 2025-10-13 18:30:00 | SPY | ETF | 662.87 | 663.22 | 662.81 | 663.14 | 18055.0 |
| 2025-10-13 19:00:00 | SPY | ETF | 663.1 | 663.1 | 662.61 | 662.86 | 12871.0 |
| 2025-10-13 19:30:00 | SPY | ETF | 662.81 | 662.81 | 662.46 | 662.68 | 11293.0 |
| 2025-10-13 04:00:00 | QQQ | ETF | 598.17 | 601.58 | 598.0 | 600.32 | 197404.0 |
| 2025-10-13 04:30:00 | QQQ | ETF | 600.41 | 600.93 | 600.02 | 600.8 | 115931.0 |
| 2025-10-13 05:00:00 | QQQ | ETF | 600.8 | 600.94 | 600.3 | 600.45 | 123880.0 |
| 2025-10-13 05:30:00 | QQQ | ETF | 600.45 | 600.5 | 599.9 | 600.18 | 107662.0 |
| 2025-10-13 06:00:00 | QQQ | ETF | 600.14 | 600.55 | 599.7 | 600.43 | 192371.0 |
| 2025-10-13 06:30:00 | QQQ | ETF | 600.42 | 600.86 | 599.71 | 600.26 | 184719.0 |
| 2025-10-13 07:00:00 | QQQ | ETF | 600.23 | 600.63 | 597.46 | 598.18 | 537419.0 |
| 2025-10-13 07:30:00 | QQQ | ETF | 598.12 | 599.39 | 597.49 | 598.96 | 371104.0 |
| 2025-10-13 08:00:00 | QQQ | ETF | 594.82 | 602.38 | 594.82 | 599.44 | 950768.0 |
| 2025-10-13 08:30:00 | QQQ | ETF | 599.39 | 600.19 | 598.62 | 598.76 | 681875.0 |
| 2025-10-13 09:00:00 | QQQ | ETF | 598.74 | 601.22 | 598.73 | 599.7 | 1433432.0 |
| 2025-10-13 09:30:00 | QQQ | ETF | 599.7 | 601.25 | 597.23 | 601.16 | 7256628.0 |
| 2025-10-13 10:00:00 | QQQ | ETF | 601.14 | 601.74 | 598.74 | 599.63 | 3824429.0 |
| 2025-10-13 10:30:00 | QQQ | ETF | 599.65 | 601.16 | 597.6842 | 598.0396 | 2936241.0 |
| 2025-10-13 11:00:00 | QQQ | ETF | 598.06 | 601.09 | 597.74 | 600.8956 | 2383385.0 |
| 2025-10-13 11:30:00 | QQQ | ETF | 600.9 | 601.47 | 600.3 | 601.255 | 1604332.0 |
| 2025-10-13 12:00:00 | QQQ | ETF | 601.29 | 602.24 | 600.71 | 601.66 | 2057225.0 |
| 2025-10-13 12:30:00 | QQQ | ETF | 601.67 | 602.77 | 601.15 | 602.58 | 2008457.0 |
> showing 50 of 44,353 rows — these rows as CSV