PREVIEW / etf_30min / 2025-10-03
file: by_date/etf_30min/2025/2025-10-03.parquet size: 1.0 MB rows: 43,652
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-03 04:00:00 | SPY | ETF | 671.08 | 671.24 | 670.6 | 671.14 | 22431.0 |
| 2025-10-03 04:30:00 | SPY | ETF | 671.18 | 671.18 | 671.04 | 671.15 | 5935.0 |
| 2025-10-03 05:00:00 | SPY | ETF | 671.24 | 671.26 | 671.06 | 671.12 | 6215.0 |
| 2025-10-03 05:30:00 | SPY | ETF | 671.13 | 671.45 | 671.12 | 671.45 | 6318.0 |
| 2025-10-03 06:00:00 | SPY | ETF | 671.48 | 671.48 | 671.15 | 671.15 | 4618.0 |
| 2025-10-03 06:30:00 | SPY | ETF | 671.14 | 671.14 | 670.82 | 670.85 | 8616.0 |
| 2025-10-03 07:00:00 | SPY | ETF | 670.73 | 670.97 | 670.3 | 670.3 | 26804.0 |
| 2025-10-03 07:30:00 | SPY | ETF | 670.3 | 670.72 | 669.98 | 670.13 | 38425.0 |
| 2025-10-03 08:00:00 | SPY | ETF | 671.14 | 671.44 | 670.02 | 670.2 | 135511.0 |
| 2025-10-03 08:30:00 | SPY | ETF | 670.21 | 670.38 | 669.47 | 669.86 | 106998.0 |
| 2025-10-03 09:00:00 | SPY | ETF | 669.7878 | 670.04 | 669.61 | 669.98 | 135036.0 |
| 2025-10-03 09:30:00 | SPY | ETF | 669.99 | 671.57 | 669.93 | 670.8899 | 5215390.0 |
| 2025-10-03 10:00:00 | SPY | ETF | 670.81 | 671.55 | 669.97 | 671.395 | 4049179.0 |
| 2025-10-03 10:30:00 | SPY | ETF | 671.39 | 672.28 | 671.32 | 672.11 | 2999562.0 |
| 2025-10-03 11:00:00 | SPY | ETF | 672.115 | 672.14 | 671.55 | 671.7713 | 2321109.0 |
| 2025-10-03 11:30:00 | SPY | ETF | 671.77 | 672.615 | 671.35 | 672.5 | 2688484.0 |
| 2025-10-03 12:00:00 | SPY | ETF | 672.5 | 672.675 | 672.22 | 672.46 | 1625440.0 |
| 2025-10-03 12:30:00 | SPY | ETF | 672.45 | 672.545 | 672.0001 | 672.24 | 1456780.0 |
| 2025-10-03 13:00:00 | SPY | ETF | 672.2003 | 672.2003 | 670.32 | 670.33 | 4752268.0 |
| 2025-10-03 13:30:00 | SPY | ETF | 670.33 | 670.95 | 668.16 | 669.19 | 5631083.0 |
| 2025-10-03 14:00:00 | SPY | ETF | 669.19 | 670.705 | 668.27 | 670.52 | 5041850.0 |
| 2025-10-03 14:30:00 | SPY | ETF | 670.537 | 670.685 | 669.28 | 669.87 | 2713151.0 |
| 2025-10-03 15:00:00 | SPY | ETF | 669.865 | 670.26 | 669.4 | 669.62 | 3202694.0 |
| 2025-10-03 15:30:00 | SPY | ETF | 669.61 | 670.24 | 668.77 | 669.18 | 6948167.0 |
| 2025-10-03 16:00:00 | SPY | ETF | 669.2 | 669.35 | 668.6 | 668.85 | 2014736.0 |
| 2025-10-03 16:30:00 | SPY | ETF | 668.87 | 669.07 | 668.87 | 669.02 | 113206.0 |
| 2025-10-03 17:00:00 | SPY | ETF | 669.05 | 669.1 | 668.97 | 668.98 | 9933.0 |
| 2025-10-03 17:30:00 | SPY | ETF | 668.9801 | 669.5 | 668.9801 | 669.2501 | 42453.0 |
| 2025-10-03 18:00:00 | SPY | ETF | 669.36 | 669.61 | 669.26 | 669.61 | 15378.0 |
| 2025-10-03 18:30:00 | SPY | ETF | 669.65 | 669.95 | 669.51 | 669.57 | 32237.0 |
| 2025-10-03 19:00:00 | SPY | ETF | 669.68 | 669.73 | 669.58 | 669.73 | 3309.0 |
| 2025-10-03 19:30:00 | SPY | ETF | 669.61 | 669.61 | 669.42 | 669.56 | 7200.0 |
| 2025-10-03 04:00:00 | QQQ | ETF | 605.86 | 607.8 | 605.86 | 607.7 | 40671.0 |
| 2025-10-03 04:30:00 | QQQ | ETF | 607.63 | 607.7 | 607.51 | 607.7 | 18279.0 |
| 2025-10-03 05:00:00 | QQQ | ETF | 607.75 | 607.79 | 607.47 | 607.56 | 21821.0 |
| 2025-10-03 05:30:00 | QQQ | ETF | 607.59 | 607.84 | 607.54 | 607.78 | 10127.0 |
| 2025-10-03 06:00:00 | QQQ | ETF | 607.96 | 608.04 | 607.59 | 607.62 | 24145.0 |
| 2025-10-03 06:30:00 | QQQ | ETF | 607.64 | 607.64 | 607.11 | 607.23 | 26746.0 |
| 2025-10-03 07:00:00 | QQQ | ETF | 607.22 | 607.42 | 606.72 | 606.79 | 28843.0 |
| 2025-10-03 07:30:00 | QQQ | ETF | 606.84 | 607.29 | 606.5 | 606.55 | 64458.0 |
| 2025-10-03 08:00:00 | QQQ | ETF | 606.63 | 607.9896 | 606.184 | 606.6 | 152571.0 |
| 2025-10-03 08:30:00 | QQQ | ETF | 606.6805 | 606.77 | 605.83 | 606.22 | 115049.0 |
| 2025-10-03 09:00:00 | QQQ | ETF | 606.19 | 606.6 | 606.12 | 606.51 | 102249.0 |
| 2025-10-03 09:30:00 | QQQ | ETF | 606.51 | 607.3255 | 605.71 | 605.8856 | 3589696.0 |
| 2025-10-03 10:00:00 | QQQ | ETF | 605.89 | 605.92 | 604.52 | 605.465 | 2707968.0 |
| 2025-10-03 10:30:00 | QQQ | ETF | 605.46 | 606.34 | 605.19 | 606.1 | 1593340.0 |
| 2025-10-03 11:00:00 | QQQ | ETF | 606.11 | 606.7053 | 605.68 | 606.5 | 1557474.0 |
| 2025-10-03 11:30:00 | QQQ | ETF | 606.49 | 606.9294 | 605.79 | 606.775 | 1603265.0 |
| 2025-10-03 12:00:00 | QQQ | ETF | 606.76 | 607.015 | 606.36 | 606.72 | 1152193.0 |
| 2025-10-03 12:30:00 | QQQ | ETF | 606.71 | 606.76 | 605.88 | 606.1 | 1098209.0 |
> showing 50 of 43,652 rows — these rows as CSV