PREVIEW / stock_30min / 2024-05-29
file: by_date/stock_30min/2024/2024-05-29.parquet size: 2.0 MB rows: 99,028 symbols: 964
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-05-29 04:00:00 | AAPL | Stock | 189.88 | 189.95 | 189.71 | 189.78 | 7087.0 |
| 2024-05-29 04:30:00 | AAPL | Stock | 189.75 | 189.75 | 189.0 | 189.39 | 13413.0 |
| 2024-05-29 05:00:00 | AAPL | Stock | 189.4 | 189.52 | 189.3 | 189.3 | 4279.0 |
| 2024-05-29 05:30:00 | AAPL | Stock | 189.34 | 189.45 | 189.34 | 189.45 | 1155.0 |
| 2024-05-29 06:00:00 | AAPL | Stock | 189.54 | 189.88 | 189.54 | 189.86 | 3946.0 |
| 2024-05-29 06:30:00 | AAPL | Stock | 189.88 | 189.88 | 189.69 | 189.71 | 5403.0 |
| 2024-05-29 07:00:00 | AAPL | Stock | 189.82 | 189.89 | 189.5 | 189.67 | 21782.0 |
| 2024-05-29 07:30:00 | AAPL | Stock | 189.72 | 189.99 | 189.61 | 189.99 | 13631.0 |
| 2024-05-29 08:00:00 | AAPL | Stock | 189.8 | 190.7 | 189.5 | 190.31 | 149660.0 |
| 2024-05-29 08:30:00 | AAPL | Stock | 190.33 | 190.36 | 189.8395 | 190.3 | 80817.0 |
| 2024-05-29 09:00:00 | AAPL | Stock | 190.27 | 190.3 | 189.3 | 189.59 | 112765.0 |
| 2024-05-29 09:30:00 | AAPL | Stock | 189.67 | 192.247 | 189.51 | 191.785 | 7170988.0 |
| 2024-05-29 10:00:00 | AAPL | Stock | 191.8 | 192.13 | 191.35 | 191.85 | 3119613.0 |
| 2024-05-29 10:30:00 | AAPL | Stock | 191.8489 | 192.24 | 191.7 | 192.1796 | 2853301.0 |
| 2024-05-29 11:00:00 | AAPL | Stock | 192.17 | 192.175 | 191.125 | 191.48 | 2200415.0 |
| 2024-05-29 11:30:00 | AAPL | Stock | 191.48 | 191.56 | 191.08 | 191.4465 | 1683226.0 |
| 2024-05-29 12:00:00 | AAPL | Stock | 191.45 | 191.78 | 191.26 | 191.76 | 1585537.0 |
| 2024-05-29 12:30:00 | AAPL | Stock | 191.7625 | 192.03 | 191.503 | 191.8938 | 1415373.0 |
| 2024-05-29 13:00:00 | AAPL | Stock | 191.895 | 192.015 | 191.5505 | 191.7977 | 1252693.0 |
| 2024-05-29 13:30:00 | AAPL | Stock | 191.79 | 191.97 | 191.47 | 191.78 | 1639267.0 |
| 2024-05-29 14:00:00 | AAPL | Stock | 191.775 | 191.775 | 191.31 | 191.5601 | 1384883.0 |
| 2024-05-29 14:30:00 | AAPL | Stock | 191.56 | 191.63 | 191.12 | 191.22 | 1456840.0 |
| 2024-05-29 15:00:00 | AAPL | Stock | 191.2114 | 191.265 | 190.715 | 191.14 | 1833632.0 |
| 2024-05-29 15:30:00 | AAPL | Stock | 191.14 | 191.21 | 189.95 | 190.37 | 5885027.0 |
| 2024-05-29 16:00:00 | AAPL | Stock | 190.42 | 190.42 | 189.5 | 189.8 | 7927032.0 |
| 2024-05-29 16:30:00 | AAPL | Stock | 189.81 | 190.09 | 189.62 | 189.8 | 46735.0 |
| 2024-05-29 17:00:00 | AAPL | Stock | 190.29 | 190.4 | 189.8 | 190.38 | 174237.0 |
| 2024-05-29 17:30:00 | AAPL | Stock | 190.4 | 190.55 | 190.35 | 190.5 | 35541.0 |
| 2024-05-29 18:00:00 | AAPL | Stock | 190.36 | 190.6 | 190.25 | 190.25 | 13038.0 |
| 2024-05-29 18:30:00 | AAPL | Stock | 190.25 | 190.29 | 189.93 | 190.01 | 20164.0 |
| 2024-05-29 19:00:00 | AAPL | Stock | 189.99 | 190.2 | 189.99 | 190.0 | 4700.0 |
| 2024-05-29 19:30:00 | AAPL | Stock | 190.01 | 190.25 | 190.01 | 190.25 | 12572.0 |
| 2024-05-29 04:00:00 | MSFT | Stock | 427.64 | 427.64 | 427.6 | 427.6 | 302.0 |
| 2024-05-29 04:30:00 | MSFT | Stock | 427.6 | 427.6 | 427.5 | 427.5 | 1058.0 |
| 2024-05-29 05:30:00 | MSFT | Stock | 427.5 | 427.5 | 427.5 | 427.5 | 200.0 |
| 2024-05-29 06:00:00 | MSFT | Stock | 427.53 | 427.74 | 427.53 | 427.58 | 1156.0 |
| 2024-05-29 06:30:00 | MSFT | Stock | 427.68 | 427.68 | 427.5 | 427.5 | 682.0 |
| 2024-05-29 07:00:00 | MSFT | Stock | 427.59 | 428.05 | 426.72 | 426.72 | 6425.0 |
| 2024-05-29 07:30:00 | MSFT | Stock | 427.04 | 427.15 | 427.04 | 427.07 | 614.0 |
| 2024-05-29 08:00:00 | MSFT | Stock | 427.71 | 428.51 | 426.67 | 427.2 | 15093.0 |
| 2024-05-29 08:30:00 | MSFT | Stock | 427.45 | 427.5 | 426.9 | 427.1 | 7724.0 |
| 2024-05-29 09:00:00 | MSFT | Stock | 427.2 | 427.25 | 425.43 | 425.64 | 23984.0 |
| 2024-05-29 09:30:00 | MSFT | Stock | 425.89 | 430.41 | 425.69 | 429.445 | 1453206.0 |
| 2024-05-29 10:00:00 | MSFT | Stock | 429.455 | 430.38 | 428.63 | 430.14 | 726333.0 |
| 2024-05-29 10:30:00 | MSFT | Stock | 430.17 | 430.7 | 429.5201 | 429.8825 | 575909.0 |
| 2024-05-29 11:00:00 | MSFT | Stock | 429.89 | 430.02 | 428.68 | 429.21 | 425657.0 |
| 2024-05-29 11:30:00 | MSFT | Stock | 429.26 | 430.23 | 429.04 | 430.15 | 361380.0 |
| 2024-05-29 12:00:00 | MSFT | Stock | 430.155 | 430.405 | 429.9 | 430.26 | 277671.0 |
| 2024-05-29 12:30:00 | MSFT | Stock | 430.28 | 430.94 | 430.19 | 430.76 | 321619.0 |
| 2024-05-29 13:00:00 | MSFT | Stock | 430.74 | 430.82 | 429.69 | 430.1935 | 395221.0 |
> showing 50 of 99,028 rows — these rows as CSV