PREVIEW / etf_30min / 2024-10-24
file: by_date/etf_30min/2024/2024-10-24.parquet size: 853 KB rows: 33,654
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-10-24 04:00:00 | SPY | ETF | 579.72 | 580.92 | 579.72 | 580.78 | 18473.0 |
| 2024-10-24 04:30:00 | SPY | ETF | 580.9 | 580.92 | 580.17 | 580.24 | 8913.0 |
| 2024-10-24 05:00:00 | SPY | ETF | 580.52 | 580.68 | 580.38 | 580.47 | 18771.0 |
| 2024-10-24 05:30:00 | SPY | ETF | 580.52 | 580.6 | 580.43 | 580.48 | 2157.0 |
| 2024-10-24 06:00:00 | SPY | ETF | 580.42 | 580.89 | 580.4 | 580.82 | 44899.0 |
| 2024-10-24 06:30:00 | SPY | ETF | 580.77 | 580.88 | 580.51 | 580.54 | 30434.0 |
| 2024-10-24 07:00:00 | SPY | ETF | 580.57 | 581.08 | 579.4 | 580.75 | 401765.0 |
| 2024-10-24 07:30:00 | SPY | ETF | 580.65 | 581.08 | 580.61 | 581.01 | 47899.0 |
| 2024-10-24 08:00:00 | SPY | ETF | 580.5108 | 581.067 | 579.11 | 580.79 | 86614.0 |
| 2024-10-24 08:30:00 | SPY | ETF | 580.73 | 581.21 | 580.45 | 580.51 | 121577.0 |
| 2024-10-24 09:00:00 | SPY | ETF | 580.54 | 580.91 | 580.0 | 580.0 | 98162.0 |
| 2024-10-24 09:30:00 | SPY | ETF | 579.98 | 580.06 | 578.62 | 579.39 | 3412546.0 |
| 2024-10-24 10:00:00 | SPY | ETF | 579.39 | 579.93 | 578.835 | 578.93 | 1526223.0 |
| 2024-10-24 10:30:00 | SPY | ETF | 578.925 | 579.83 | 578.54 | 578.8004 | 1262102.0 |
| 2024-10-24 11:00:00 | SPY | ETF | 578.82 | 579.36 | 578.25 | 578.65 | 1190676.0 |
| 2024-10-24 11:30:00 | SPY | ETF | 578.61 | 578.71 | 577.04 | 578.06 | 1550230.0 |
| 2024-10-24 12:00:00 | SPY | ETF | 578.06 | 578.17 | 576.57 | 578.01 | 1689737.0 |
| 2024-10-24 12:30:00 | SPY | ETF | 578.02 | 578.99 | 578.015 | 578.88 | 1094579.0 |
| 2024-10-24 13:00:00 | SPY | ETF | 578.86 | 579.509 | 578.73 | 579.05 | 1005091.0 |
| 2024-10-24 13:30:00 | SPY | ETF | 579.05 | 579.5601 | 578.42 | 578.49 | 848863.0 |
| 2024-10-24 14:00:00 | SPY | ETF | 578.5322 | 579.36 | 578.0702 | 578.88 | 1149626.0 |
| 2024-10-24 14:30:00 | SPY | ETF | 578.89 | 578.9201 | 578.3 | 578.82 | 872921.0 |
| 2024-10-24 15:00:00 | SPY | ETF | 578.81 | 579.5372 | 578.25 | 579.44 | 1942428.0 |
| 2024-10-24 15:30:00 | SPY | ETF | 579.44 | 579.885 | 579.0001 | 579.18 | 3856517.0 |
| 2024-10-24 16:00:00 | SPY | ETF | 579.17 | 579.94 | 578.88 | 579.7 | 2517484.0 |
| 2024-10-24 16:30:00 | SPY | ETF | 579.72 | 579.72 | 579.24 | 579.49 | 964189.0 |
| 2024-10-24 17:00:00 | SPY | ETF | 579.55 | 579.56 | 579.35 | 579.36 | 34725.0 |
| 2024-10-24 17:30:00 | SPY | ETF | 579.4 | 579.53 | 579.35 | 579.53 | 18807.0 |
| 2024-10-24 18:00:00 | SPY | ETF | 579.56 | 579.63 | 579.28 | 579.42 | 36998.0 |
| 2024-10-24 18:30:00 | SPY | ETF | 579.46 | 579.46 | 579.21 | 579.3 | 32816.0 |
| 2024-10-24 19:00:00 | SPY | ETF | 579.28 | 579.28 | 579.1 | 579.24 | 7787.0 |
| 2024-10-24 19:30:00 | SPY | ETF | 579.11 | 579.36 | 579.0 | 579.36 | 13640.0 |
| 2024-10-24 04:00:00 | QQQ | ETF | 491.72 | 492.83 | 491.72 | 492.51 | 51234.0 |
| 2024-10-24 04:30:00 | QQQ | ETF | 492.55 | 492.62 | 491.66 | 492.08 | 23629.0 |
| 2024-10-24 05:00:00 | QQQ | ETF | 492.17 | 492.39 | 491.9 | 492.03 | 18810.0 |
| 2024-10-24 05:30:00 | QQQ | ETF | 492.09 | 492.26 | 492.0 | 492.2 | 7192.0 |
| 2024-10-24 06:00:00 | QQQ | ETF | 492.22 | 492.67 | 492.11 | 492.5 | 12133.0 |
| 2024-10-24 06:30:00 | QQQ | ETF | 492.5 | 492.65 | 492.3 | 492.3 | 8976.0 |
| 2024-10-24 07:00:00 | QQQ | ETF | 492.3 | 492.939 | 492.15 | 492.72 | 82056.0 |
| 2024-10-24 07:30:00 | QQQ | ETF | 492.8 | 493.24 | 492.62 | 493.17 | 51584.0 |
| 2024-10-24 08:00:00 | QQQ | ETF | 492.52 | 493.2 | 490.8 | 492.88 | 144913.0 |
| 2024-10-24 08:30:00 | QQQ | ETF | 492.83 | 493.41 | 492.2999 | 492.38 | 117908.0 |
| 2024-10-24 09:00:00 | QQQ | ETF | 492.38 | 492.9094 | 491.87 | 492.09 | 161392.0 |
| 2024-10-24 09:30:00 | QQQ | ETF | 492.11 | 492.19 | 490.29 | 491.2663 | 2413069.0 |
| 2024-10-24 10:00:00 | QQQ | ETF | 491.27 | 492.228 | 490.59 | 490.73 | 1664723.0 |
| 2024-10-24 10:30:00 | QQQ | ETF | 490.76 | 492.12 | 490.52 | 490.744 | 1179145.0 |
| 2024-10-24 11:00:00 | QQQ | ETF | 490.7494 | 491.97 | 490.49 | 491.37 | 856791.0 |
| 2024-10-24 11:30:00 | QQQ | ETF | 491.31 | 491.63 | 489.53 | 491.0475 | 1043620.0 |
| 2024-10-24 12:00:00 | QQQ | ETF | 491.04 | 491.3 | 489.44 | 491.0099 | 843709.0 |
| 2024-10-24 12:30:00 | QQQ | ETF | 491.0 | 491.93 | 491.0 | 491.73 | 729987.0 |
> showing 50 of 33,654 rows — these rows as CSV