PREVIEW / etf_30min / 2024-11-01
file: by_date/etf_30min/2024/2024-11-01.parquet size: 875 KB rows: 34,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-11-01 04:00:00 | SPY | ETF | 570.19 | 570.79 | 570.19 | 570.59 | 29367.0 |
| 2024-11-01 04:30:00 | SPY | ETF | 570.6 | 570.94 | 570.39 | 570.52 | 13725.0 |
| 2024-11-01 05:00:00 | SPY | ETF | 570.59 | 571.0 | 570.55 | 570.96 | 5216.0 |
| 2024-11-01 05:30:00 | SPY | ETF | 570.9 | 570.9 | 570.63 | 570.78 | 10987.0 |
| 2024-11-01 06:00:00 | SPY | ETF | 570.88 | 571.28 | 570.88 | 571.28 | 112605.0 |
| 2024-11-01 06:30:00 | SPY | ETF | 571.11 | 571.59 | 571.0 | 571.43 | 156520.0 |
| 2024-11-01 07:00:00 | SPY | ETF | 571.42 | 571.43 | 570.8 | 571.26 | 273194.0 |
| 2024-11-01 07:30:00 | SPY | ETF | 571.28 | 571.65 | 571.19 | 571.37 | 63918.0 |
| 2024-11-01 08:00:00 | SPY | ETF | 571.4 | 571.5901 | 569.37 | 571.43 | 239845.0 |
| 2024-11-01 08:30:00 | SPY | ETF | 571.5 | 572.17 | 569.8 | 571.8 | 695147.0 |
| 2024-11-01 09:00:00 | SPY | ETF | 571.83 | 571.84 | 571.16 | 571.34 | 249246.0 |
| 2024-11-01 09:30:00 | SPY | ETF | 571.32 | 573.3599 | 570.68 | 573.12 | 3821892.0 |
| 2024-11-01 10:00:00 | SPY | ETF | 573.13 | 575.5003 | 572.64 | 575.46 | 2935375.0 |
| 2024-11-01 10:30:00 | SPY | ETF | 575.5 | 575.55 | 572.86 | 574.435 | 2698214.0 |
| 2024-11-01 11:00:00 | SPY | ETF | 574.42 | 575.3 | 574.0 | 575.2 | 1831898.0 |
| 2024-11-01 11:30:00 | SPY | ETF | 575.2 | 575.27 | 573.36 | 573.65 | 1303375.0 |
| 2024-11-01 12:00:00 | SPY | ETF | 573.63 | 574.3099 | 573.3 | 573.39 | 868429.0 |
| 2024-11-01 12:30:00 | SPY | ETF | 573.39 | 574.24 | 572.66 | 573.0 | 986175.0 |
| 2024-11-01 13:00:00 | SPY | ETF | 573.03 | 573.8669 | 572.15 | 573.7 | 1129242.0 |
| 2024-11-01 13:30:00 | SPY | ETF | 573.68 | 573.75 | 571.6 | 571.6499 | 1699088.0 |
| 2024-11-01 14:00:00 | SPY | ETF | 571.64 | 572.24 | 571.14 | 571.9201 | 1293542.0 |
| 2024-11-01 14:30:00 | SPY | ETF | 571.92 | 572.46 | 571.6201 | 572.17 | 974177.0 |
| 2024-11-01 15:00:00 | SPY | ETF | 572.15 | 572.94 | 571.7 | 571.7495 | 1227383.0 |
| 2024-11-01 15:30:00 | SPY | ETF | 571.74 | 572.24 | 570.62 | 571.02 | 6553868.0 |
| 2024-11-01 16:00:00 | SPY | ETF | 571.0 | 571.85 | 570.96 | 571.45 | 1505984.0 |
| 2024-11-01 16:30:00 | SPY | ETF | 571.44 | 571.51 | 571.2 | 571.26 | 118763.0 |
| 2024-11-01 17:00:00 | SPY | ETF | 571.25 | 571.77 | 571.04 | 571.77 | 170990.0 |
| 2024-11-01 17:30:00 | SPY | ETF | 571.75 | 571.75 | 571.4 | 571.41 | 21904.0 |
| 2024-11-01 18:00:00 | SPY | ETF | 571.5 | 571.76 | 571.45 | 571.6 | 5837.0 |
| 2024-11-01 18:30:00 | SPY | ETF | 571.65 | 571.82 | 571.02 | 571.09 | 45347.0 |
| 2024-11-01 19:00:00 | SPY | ETF | 571.2 | 571.3 | 571.12 | 571.2987 | 9170.0 |
| 2024-11-01 19:30:00 | SPY | ETF | 571.2545 | 571.5 | 570.75 | 571.3 | 43096.0 |
| 2024-11-01 04:00:00 | QQQ | ETF | 486.05 | 486.5 | 486.0 | 486.39 | 23010.0 |
| 2024-11-01 04:30:00 | QQQ | ETF | 486.23 | 486.39 | 485.81 | 486.11 | 14943.0 |
| 2024-11-01 05:00:00 | QQQ | ETF | 486.13 | 486.53 | 486.02 | 486.53 | 28068.0 |
| 2024-11-01 05:30:00 | QQQ | ETF | 486.44 | 486.44 | 485.96 | 486.13 | 9400.0 |
| 2024-11-01 06:00:00 | QQQ | ETF | 486.0 | 486.48 | 486.0 | 486.35 | 18825.0 |
| 2024-11-01 06:30:00 | QQQ | ETF | 486.47 | 486.7 | 486.25 | 486.56 | 46541.0 |
| 2024-11-01 07:00:00 | QQQ | ETF | 486.52 | 486.649 | 486.11 | 486.55 | 70950.0 |
| 2024-11-01 07:30:00 | QQQ | ETF | 486.57 | 486.97 | 486.34 | 486.46 | 81286.0 |
| 2024-11-01 08:00:00 | QQQ | ETF | 486.48 | 486.95 | 485.31 | 486.38 | 203135.0 |
| 2024-11-01 08:30:00 | QQQ | ETF | 486.42 | 487.35 | 485.25 | 486.56 | 372011.0 |
| 2024-11-01 09:00:00 | QQQ | ETF | 486.58 | 486.58 | 485.41 | 485.5 | 293447.0 |
| 2024-11-01 09:30:00 | QQQ | ETF | 485.52 | 488.09 | 485.2 | 487.87 | 2860158.0 |
| 2024-11-01 10:00:00 | QQQ | ETF | 487.89 | 490.35 | 487.06 | 490.3497 | 2412158.0 |
| 2024-11-01 10:30:00 | QQQ | ETF | 490.36 | 490.48 | 487.63 | 489.53 | 2404396.0 |
| 2024-11-01 11:00:00 | QQQ | ETF | 489.4991 | 490.7507 | 489.03 | 490.65 | 1450691.0 |
| 2024-11-01 11:30:00 | QQQ | ETF | 490.67 | 490.75 | 488.88 | 489.22 | 977616.0 |
| 2024-11-01 12:00:00 | QQQ | ETF | 489.18 | 489.95 | 489.0709 | 489.14 | 518388.0 |
| 2024-11-01 12:30:00 | QQQ | ETF | 489.141 | 489.93 | 488.465 | 488.9209 | 742760.0 |
> showing 50 of 34,500 rows — these rows as CSV