PREVIEW / etf_30min / 2024-12-19
file: by_date/etf_30min/2024/2024-12-19.parquet size: 962 KB rows: 39,500
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-19 04:00:00 | SPY | ETF | 588.61 | 589.19 | 588.28 | 588.36 | 41690.0 |
| 2024-12-19 04:30:00 | SPY | ETF | 588.49 | 589.08 | 588.49 | 588.91 | 28738.0 |
| 2024-12-19 05:00:00 | SPY | ETF | 588.97 | 589.65 | 588.92 | 589.65 | 17154.0 |
| 2024-12-19 05:30:00 | SPY | ETF | 589.54 | 589.54 | 588.65 | 588.65 | 14742.0 |
| 2024-12-19 06:00:00 | SPY | ETF | 588.69 | 589.11 | 588.6 | 588.8 | 6095.0 |
| 2024-12-19 06:30:00 | SPY | ETF | 588.85 | 589.38 | 588.51 | 589.14 | 80733.0 |
| 2024-12-19 07:00:00 | SPY | ETF | 589.14 | 590.79 | 589.02 | 590.57 | 372451.0 |
| 2024-12-19 07:30:00 | SPY | ETF | 590.6 | 591.37 | 590.25 | 591.29 | 277516.0 |
| 2024-12-19 08:00:00 | SPY | ETF | 589.09 | 591.6 | 586.31 | 591.04 | 472254.0 |
| 2024-12-19 08:30:00 | SPY | ETF | 591.39 | 591.4 | 590.27 | 590.35 | 268248.0 |
| 2024-12-19 09:00:00 | SPY | ETF | 590.33 | 591.66 | 589.91 | 591.36 | 271014.0 |
| 2024-12-19 09:30:00 | SPY | ETF | 591.36 | 593.0 | 589.81 | 590.53 | 5649878.0 |
| 2024-12-19 10:00:00 | SPY | ETF | 590.515 | 590.92 | 588.65 | 588.7 | 4443713.0 |
| 2024-12-19 10:30:00 | SPY | ETF | 588.67 | 590.3598 | 587.79 | 589.72 | 3587804.0 |
| 2024-12-19 11:00:00 | SPY | ETF | 589.72 | 590.96 | 587.823 | 590.79 | 2933508.0 |
| 2024-12-19 11:30:00 | SPY | ETF | 590.77 | 591.4 | 589.55 | 589.8797 | 2418099.0 |
| 2024-12-19 12:00:00 | SPY | ETF | 589.86 | 590.1487 | 587.85 | 588.01 | 1480119.0 |
| 2024-12-19 12:30:00 | SPY | ETF | 588.01 | 589.14 | 587.4605 | 589.06 | 2124515.0 |
| 2024-12-19 13:00:00 | SPY | ETF | 589.02 | 589.73 | 587.28 | 589.63 | 1944776.0 |
| 2024-12-19 13:30:00 | SPY | ETF | 589.5839 | 591.26 | 589.23 | 591.25 | 1594764.0 |
| 2024-12-19 14:00:00 | SPY | ETF | 591.22 | 591.26 | 588.81 | 589.23 | 2419392.0 |
| 2024-12-19 14:30:00 | SPY | ETF | 589.25 | 589.32 | 588.05 | 588.06 | 2019481.0 |
| 2024-12-19 15:00:00 | SPY | ETF | 588.09 | 589.43 | 587.41 | 588.61 | 2740300.0 |
| 2024-12-19 15:30:00 | SPY | ETF | 588.63 | 589.22 | 585.85 | 586.12 | 10955259.0 |
| 2024-12-19 16:00:00 | SPY | ETF | 586.14 | 586.64 | 585.79 | 586.43 | 6209517.0 |
| 2024-12-19 16:30:00 | SPY | ETF | 586.4 | 586.99 | 586.24 | 586.8 | 191850.0 |
| 2024-12-19 17:00:00 | SPY | ETF | 586.76 | 586.93 | 586.55 | 586.85 | 19766.0 |
| 2024-12-19 17:30:00 | SPY | ETF | 586.75 | 586.87 | 586.1006 | 586.87 | 201833.0 |
| 2024-12-19 18:00:00 | SPY | ETF | 586.87 | 586.91 | 586.44 | 586.72 | 66977.0 |
| 2024-12-19 18:30:00 | SPY | ETF | 586.7 | 586.7 | 586.04 | 586.19 | 352378.0 |
| 2024-12-19 19:00:00 | SPY | ETF | 586.3 | 586.5 | 584.69 | 585.05 | 313221.0 |
| 2024-12-19 19:30:00 | SPY | ETF | 585.1 | 585.39 | 584.14 | 584.31 | 130121.0 |
| 2024-12-19 04:00:00 | QQQ | ETF | 518.97 | 519.24 | 517.78 | 517.78 | 146232.0 |
| 2024-12-19 04:30:00 | QQQ | ETF | 517.93 | 518.87 | 517.93 | 518.49 | 56725.0 |
| 2024-12-19 05:00:00 | QQQ | ETF | 518.55 | 519.63 | 518.5 | 519.63 | 27002.0 |
| 2024-12-19 05:30:00 | QQQ | ETF | 519.5 | 519.5 | 518.5 | 518.57 | 183330.0 |
| 2024-12-19 06:00:00 | QQQ | ETF | 518.66 | 519.06 | 518.44 | 518.58 | 99290.0 |
| 2024-12-19 06:30:00 | QQQ | ETF | 518.54 | 518.97 | 518.17 | 518.63 | 85534.0 |
| 2024-12-19 07:00:00 | QQQ | ETF | 518.71 | 520.94 | 518.5 | 520.78 | 275130.0 |
| 2024-12-19 07:30:00 | QQQ | ETF | 520.73 | 521.18 | 520.38 | 521.18 | 189550.0 |
| 2024-12-19 08:00:00 | QQQ | ETF | 518.79 | 521.34 | 515.5 | 520.7477 | 334432.0 |
| 2024-12-19 08:30:00 | QQQ | ETF | 520.93 | 521.15 | 519.83 | 520.01 | 235761.0 |
| 2024-12-19 09:00:00 | QQQ | ETF | 519.96 | 521.33 | 519.51 | 521.2396 | 275975.0 |
| 2024-12-19 09:30:00 | QQQ | ETF | 521.19 | 521.7599 | 518.28 | 518.91 | 5108607.0 |
| 2024-12-19 10:00:00 | QQQ | ETF | 518.87 | 520.21 | 516.84 | 516.905 | 3334249.0 |
| 2024-12-19 10:30:00 | QQQ | ETF | 516.88 | 518.98 | 516.12 | 518.217 | 2780740.0 |
| 2024-12-19 11:00:00 | QQQ | ETF | 518.2 | 519.77 | 516.08 | 519.43 | 1974208.0 |
| 2024-12-19 11:30:00 | QQQ | ETF | 519.41 | 520.12 | 518.0814 | 518.56 | 1628055.0 |
| 2024-12-19 12:00:00 | QQQ | ETF | 518.5001 | 518.72 | 515.64 | 515.98 | 1274759.0 |
| 2024-12-19 12:30:00 | QQQ | ETF | 515.98 | 517.6 | 515.38 | 517.5201 | 1999226.0 |
> showing 50 of 39,500 rows — these rows as CSV