PREVIEW / etf_30min / 2024-12-31
file: by_date/etf_30min/2024/2024-12-31.parquet size: 922 KB rows: 37,588
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-31 04:00:00 | SPY | ETF | 587.5 | 590.02 | 587.5 | 590.02 | 19234.0 |
| 2024-12-31 04:30:00 | SPY | ETF | 589.96 | 590.39 | 589.88 | 590.08 | 6009.0 |
| 2024-12-31 05:00:00 | SPY | ETF | 590.07 | 590.28 | 589.98 | 590.28 | 5242.0 |
| 2024-12-31 05:30:00 | SPY | ETF | 590.03 | 590.5 | 590.03 | 590.5 | 8195.0 |
| 2024-12-31 06:00:00 | SPY | ETF | 590.53 | 590.74 | 590.14 | 590.24 | 10903.0 |
| 2024-12-31 06:30:00 | SPY | ETF | 590.3 | 590.57 | 590.26 | 590.52 | 26753.0 |
| 2024-12-31 07:00:00 | SPY | ETF | 590.53 | 590.99 | 590.33 | 590.82 | 87283.0 |
| 2024-12-31 07:30:00 | SPY | ETF | 590.77 | 590.77 | 589.91 | 589.91 | 47435.0 |
| 2024-12-31 08:00:00 | SPY | ETF | 590.4916 | 590.94 | 587.6 | 590.19 | 143820.0 |
| 2024-12-31 08:30:00 | SPY | ETF | 590.12 | 590.56 | 589.8 | 590.0 | 96093.0 |
| 2024-12-31 09:00:00 | SPY | ETF | 589.92 | 590.45 | 589.6986 | 589.91 | 187664.0 |
| 2024-12-31 09:30:00 | SPY | ETF | 589.905 | 590.58 | 588.5559 | 590.015 | 2781234.0 |
| 2024-12-31 10:00:00 | SPY | ETF | 590.01 | 590.6399 | 588.1701 | 589.61 | 2036986.0 |
| 2024-12-31 10:30:00 | SPY | ETF | 589.61 | 590.06 | 588.57 | 588.66 | 1100848.0 |
| 2024-12-31 11:00:00 | SPY | ETF | 588.69 | 588.8 | 586.82 | 586.95 | 1593218.0 |
| 2024-12-31 11:30:00 | SPY | ETF | 586.9499 | 587.84 | 586.54 | 587.045 | 1189204.0 |
| 2024-12-31 12:00:00 | SPY | ETF | 587.06 | 587.4 | 585.74 | 585.8886 | 1313333.0 |
| 2024-12-31 12:30:00 | SPY | ETF | 585.86 | 587.31 | 584.9 | 587.22 | 2377719.0 |
| 2024-12-31 13:00:00 | SPY | ETF | 587.225 | 587.68 | 584.79 | 585.01 | 1877250.0 |
| 2024-12-31 13:30:00 | SPY | ETF | 585.015 | 586.51 | 584.92 | 585.34 | 1431878.0 |
| 2024-12-31 14:00:00 | SPY | ETF | 585.36 | 586.5599 | 584.58 | 584.94 | 2664697.0 |
| 2024-12-31 14:30:00 | SPY | ETF | 584.92 | 586.34 | 584.42 | 586.33 | 2427016.0 |
| 2024-12-31 15:00:00 | SPY | ETF | 586.31 | 587.3 | 585.17 | 587.2301 | 2953080.0 |
| 2024-12-31 15:30:00 | SPY | ETF | 587.23 | 587.4999 | 584.97 | 586.01 | 9745604.0 |
| 2024-12-31 16:00:00 | SPY | ETF | 586.02 | 586.7 | 585.65 | 586.27 | 5569050.0 |
| 2024-12-31 16:30:00 | SPY | ETF | 586.33 | 586.65 | 586.21 | 586.34 | 183097.0 |
| 2024-12-31 17:00:00 | SPY | ETF | 586.31 | 586.4 | 586.18 | 586.3506 | 27651.0 |
| 2024-12-31 17:30:00 | SPY | ETF | 586.35 | 586.4 | 586.25 | 586.25 | 3939.0 |
| 2024-12-31 18:00:00 | SPY | ETF | 586.4 | 586.41 | 586.34 | 586.41 | 12424.0 |
| 2024-12-31 18:30:00 | SPY | ETF | 586.41 | 586.5708 | 586.4 | 586.5 | 2846.0 |
| 2024-12-31 19:00:00 | SPY | ETF | 586.57 | 586.65 | 586.45 | 586.65 | 2150.0 |
| 2024-12-31 19:30:00 | SPY | ETF | 586.6887 | 586.74 | 586.51 | 586.51 | 9727.0 |
| 2024-12-31 04:00:00 | QQQ | ETF | 515.01 | 517.8 | 515.01 | 517.76 | 54239.0 |
| 2024-12-31 04:30:00 | QQQ | ETF | 517.7 | 518.14 | 517.25 | 517.54 | 26749.0 |
| 2024-12-31 05:00:00 | QQQ | ETF | 517.57 | 517.74 | 517.36 | 517.49 | 25292.0 |
| 2024-12-31 05:30:00 | QQQ | ETF | 517.49 | 518.1 | 517.39 | 517.85 | 9495.0 |
| 2024-12-31 06:00:00 | QQQ | ETF | 517.95 | 518.32 | 517.4 | 517.68 | 17081.0 |
| 2024-12-31 06:30:00 | QQQ | ETF | 517.65 | 518.06 | 517.58 | 517.89 | 8562.0 |
| 2024-12-31 07:00:00 | QQQ | ETF | 517.93 | 518.46 | 517.87 | 518.19 | 79324.0 |
| 2024-12-31 07:30:00 | QQQ | ETF | 518.15 | 518.2 | 516.94 | 517.13 | 49845.0 |
| 2024-12-31 08:00:00 | QQQ | ETF | 518.2 | 518.4592 | 514.81 | 517.28 | 136399.0 |
| 2024-12-31 08:30:00 | QQQ | ETF | 517.22 | 517.8 | 516.89 | 517.1 | 58358.0 |
| 2024-12-31 09:00:00 | QQQ | ETF | 516.9096 | 517.55 | 516.6 | 516.9 | 155197.0 |
| 2024-12-31 09:30:00 | QQQ | ETF | 516.9 | 517.66 | 514.8 | 516.34 | 2072719.0 |
| 2024-12-31 10:00:00 | QQQ | ETF | 516.21 | 517.1996 | 513.99 | 515.9201 | 1513177.0 |
| 2024-12-31 10:30:00 | QQQ | ETF | 515.95 | 516.59 | 514.74 | 515.108 | 913027.0 |
| 2024-12-31 11:00:00 | QQQ | ETF | 515.08 | 515.16 | 512.94 | 513.16 | 1170682.0 |
| 2024-12-31 11:30:00 | QQQ | ETF | 513.14 | 514.65 | 512.86 | 513.8784 | 772146.0 |
| 2024-12-31 12:00:00 | QQQ | ETF | 513.85 | 514.22 | 512.09 | 512.25 | 714860.0 |
| 2024-12-31 12:30:00 | QQQ | ETF | 512.2699 | 513.56 | 510.95 | 513.47 | 1465351.0 |
> showing 50 of 37,588 rows — these rows as CSV