PREVIEW / etf_30min / 2024-01-09
file: by_date/etf_30min/2024/2024-01-09.parquet size: 788 KB rows: 30,838
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-01-09 04:00:00 | SPY | ETF | 473.88 | 473.91 | 472.89 | 473.1 | 15416.0 |
| 2024-01-09 04:30:00 | SPY | ETF | 473.22 | 473.5 | 473.22 | 473.35 | 2130.0 |
| 2024-01-09 05:00:00 | SPY | ETF | 473.26 | 473.39 | 473.21 | 473.36 | 4200.0 |
| 2024-01-09 05:30:00 | SPY | ETF | 473.27 | 473.35 | 473.04 | 473.14 | 14938.0 |
| 2024-01-09 06:00:00 | SPY | ETF | 473.22 | 473.26 | 472.79 | 472.81 | 8960.0 |
| 2024-01-09 06:30:00 | SPY | ETF | 472.79 | 472.91 | 472.31 | 472.42 | 38867.0 |
| 2024-01-09 07:00:00 | SPY | ETF | 472.44 | 472.9 | 472.24 | 472.79 | 174589.0 |
| 2024-01-09 07:30:00 | SPY | ETF | 472.73 | 473.06 | 472.68 | 472.98 | 108355.0 |
| 2024-01-09 08:00:00 | SPY | ETF | 472.54 | 474.21 | 472.3196 | 472.54 | 198513.0 |
| 2024-01-09 08:30:00 | SPY | ETF | 472.52 | 472.56 | 471.93 | 471.99 | 329987.0 |
| 2024-01-09 09:00:00 | SPY | ETF | 471.98 | 472.13 | 471.669 | 471.9 | 236863.0 |
| 2024-01-09 09:30:00 | SPY | ETF | 471.87 | 472.2 | 471.35 | 472.1625 | 5254016.0 |
| 2024-01-09 10:00:00 | SPY | ETF | 472.16 | 472.9501 | 471.57 | 472.5 | 4476375.0 |
| 2024-01-09 10:30:00 | SPY | ETF | 472.49 | 472.81 | 472.16 | 472.23 | 2597320.0 |
| 2024-01-09 11:00:00 | SPY | ETF | 472.22 | 473.34 | 472.21 | 473.285 | 2621659.0 |
| 2024-01-09 11:30:00 | SPY | ETF | 473.29 | 474.23 | 473.08 | 474.22 | 2686221.0 |
| 2024-01-09 12:00:00 | SPY | ETF | 474.225 | 474.375 | 473.83 | 474.23 | 2251122.0 |
| 2024-01-09 12:30:00 | SPY | ETF | 474.24 | 474.47 | 474.06 | 474.34 | 1449354.0 |
| 2024-01-09 13:00:00 | SPY | ETF | 474.35 | 474.93 | 473.755 | 473.8 | 2511756.0 |
| 2024-01-09 13:30:00 | SPY | ETF | 473.81 | 474.6699 | 473.15 | 474.28 | 3292225.0 |
| 2024-01-09 14:00:00 | SPY | ETF | 474.295 | 474.545 | 473.4599 | 473.595 | 2737289.0 |
| 2024-01-09 14:30:00 | SPY | ETF | 473.6 | 473.95 | 473.35 | 473.79 | 2204547.0 |
| 2024-01-09 15:00:00 | SPY | ETF | 473.79 | 474.25 | 473.19 | 473.78 | 2761102.0 |
| 2024-01-09 15:30:00 | SPY | ETF | 473.765 | 474.2 | 472.93 | 473.84 | 9831462.0 |
| 2024-01-09 16:00:00 | SPY | ETF | 473.84 | 474.0384 | 471.5521 | 473.67 | 2492379.0 |
| 2024-01-09 16:30:00 | SPY | ETF | 473.679 | 473.73 | 473.54 | 473.67 | 88647.0 |
| 2024-01-09 17:00:00 | SPY | ETF | 473.66 | 473.7 | 473.6 | 473.62 | 26686.0 |
| 2024-01-09 17:30:00 | SPY | ETF | 473.6 | 473.67 | 473.53 | 473.67 | 8798.0 |
| 2024-01-09 18:00:00 | SPY | ETF | 473.6 | 473.6 | 473.36 | 473.4801 | 28335.0 |
| 2024-01-09 18:30:00 | SPY | ETF | 473.49 | 473.77 | 473.49 | 473.76 | 16470.0 |
| 2024-01-09 19:00:00 | SPY | ETF | 473.79 | 474.0 | 473.79 | 474.0 | 10579.0 |
| 2024-01-09 19:30:00 | SPY | ETF | 473.95 | 474.01 | 473.77 | 473.79 | 32227.0 |
| 2024-01-09 04:00:00 | QQQ | ETF | 403.97 | 403.97 | 403.1 | 403.4 | 65792.0 |
| 2024-01-09 04:30:00 | QQQ | ETF | 403.42 | 403.72 | 403.38 | 403.6 | 17429.0 |
| 2024-01-09 05:00:00 | QQQ | ETF | 403.52 | 403.63 | 403.27 | 403.63 | 12415.0 |
| 2024-01-09 05:30:00 | QQQ | ETF | 403.4 | 403.53 | 403.2 | 403.34 | 21763.0 |
| 2024-01-09 06:00:00 | QQQ | ETF | 403.38 | 403.41 | 402.87 | 402.87 | 33088.0 |
| 2024-01-09 06:30:00 | QQQ | ETF | 402.9 | 403.0 | 402.31 | 402.46 | 79112.0 |
| 2024-01-09 07:00:00 | QQQ | ETF | 402.49 | 403.02 | 402.35 | 402.8 | 194131.0 |
| 2024-01-09 07:30:00 | QQQ | ETF | 402.8 | 403.22 | 402.66 | 403.2 | 76092.0 |
| 2024-01-09 08:00:00 | QQQ | ETF | 402.87 | 405.253 | 402.39 | 402.67 | 185771.0 |
| 2024-01-09 08:30:00 | QQQ | ETF | 402.64 | 402.73 | 401.63 | 401.8 | 395025.0 |
| 2024-01-09 09:00:00 | QQQ | ETF | 401.82 | 402.17 | 401.8 | 401.94 | 342412.0 |
| 2024-01-09 09:30:00 | QQQ | ETF | 401.91 | 403.0 | 401.71 | 402.78 | 6433733.0 |
| 2024-01-09 10:00:00 | QQQ | ETF | 402.78 | 403.77 | 402.24 | 403.31 | 3272752.0 |
| 2024-01-09 10:30:00 | QQQ | ETF | 403.31 | 403.88 | 402.93 | 403.46 | 2018668.0 |
| 2024-01-09 11:00:00 | QQQ | ETF | 403.455 | 404.74 | 403.43 | 404.5675 | 1956782.0 |
| 2024-01-09 11:30:00 | QQQ | ETF | 404.58 | 405.83 | 404.43 | 405.829 | 1980624.0 |
| 2024-01-09 12:00:00 | QQQ | ETF | 405.82 | 405.9897 | 405.41 | 405.6812 | 1416023.0 |
| 2024-01-09 12:30:00 | QQQ | ETF | 405.69 | 406.18 | 405.39 | 406.1313 | 1105089.0 |
> showing 50 of 30,838 rows — these rows as CSV