PREVIEW / stock_30min / 2024-06-11
file: by_date/stock_30min/2024/2024-06-11.parquet size: 2.0 MB rows: 97,223 symbols: 948
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-06-11 04:00:00 | AAPL | Stock | 192.48 | 192.61 | 191.82 | 191.98 | 34421.0 |
| 2024-06-11 04:30:00 | AAPL | Stock | 191.99 | 192.05 | 191.68 | 192.0 | 9158.0 |
| 2024-06-11 05:00:00 | AAPL | Stock | 191.93 | 192.0 | 191.51 | 191.51 | 9720.0 |
| 2024-06-11 05:30:00 | AAPL | Stock | 191.51 | 191.87 | 191.48 | 191.85 | 6227.0 |
| 2024-06-11 06:00:00 | AAPL | Stock | 191.74 | 192.56 | 191.74 | 192.41 | 42031.0 |
| 2024-06-11 06:30:00 | AAPL | Stock | 192.41 | 193.0 | 192.4 | 192.74 | 24016.0 |
| 2024-06-11 07:00:00 | AAPL | Stock | 192.75 | 192.8 | 192.1 | 192.35 | 32279.0 |
| 2024-06-11 07:30:00 | AAPL | Stock | 192.2 | 193.24 | 192.14 | 192.85 | 61918.0 |
| 2024-06-11 08:00:00 | AAPL | Stock | 192.5 | 193.2365 | 191.28 | 192.8 | 220589.0 |
| 2024-06-11 08:30:00 | AAPL | Stock | 192.8 | 193.1 | 192.65 | 193.05 | 57690.0 |
| 2024-06-11 09:00:00 | AAPL | Stock | 193.0 | 193.78 | 193.0 | 193.6881 | 284260.0 |
| 2024-06-11 09:30:00 | AAPL | Stock | 193.69 | 199.149 | 193.63 | 199.13 | 17582053.0 |
| 2024-06-11 10:00:00 | AAPL | Stock | 199.1316 | 201.05 | 198.87 | 200.92 | 17890968.0 |
| 2024-06-11 10:30:00 | AAPL | Stock | 200.93 | 203.8 | 200.88 | 203.24 | 16060648.0 |
| 2024-06-11 11:00:00 | AAPL | Stock | 203.235 | 204.51 | 202.25 | 204.4099 | 13662044.0 |
| 2024-06-11 11:30:00 | AAPL | Stock | 204.395 | 205.45 | 204.02 | 204.3299 | 12420139.0 |
| 2024-06-11 12:00:00 | AAPL | Stock | 204.33 | 204.83 | 203.45 | 204.225 | 7391779.0 |
| 2024-06-11 12:30:00 | AAPL | Stock | 204.2476 | 205.07 | 203.8 | 205.04 | 5925898.0 |
| 2024-06-11 13:00:00 | AAPL | Stock | 205.0499 | 206.03 | 204.7114 | 205.04 | 7216072.0 |
| 2024-06-11 13:30:00 | AAPL | Stock | 205.03 | 205.41 | 204.44 | 204.99 | 5109785.0 |
| 2024-06-11 14:00:00 | AAPL | Stock | 204.985 | 205.24 | 204.44 | 205.08 | 4782955.0 |
| 2024-06-11 14:30:00 | AAPL | Stock | 205.09 | 205.93 | 204.94 | 205.6 | 5231177.0 |
| 2024-06-11 15:00:00 | AAPL | Stock | 205.595 | 205.78 | 204.7 | 205.73 | 5895858.0 |
| 2024-06-11 15:30:00 | AAPL | Stock | 205.73 | 207.16 | 205.49 | 207.14 | 13663745.0 |
| 2024-06-11 16:00:00 | AAPL | Stock | 207.15 | 207.77 | 202.865 | 207.7 | 11663410.0 |
| 2024-06-11 16:30:00 | AAPL | Stock | 207.72 | 207.89 | 207.15 | 207.69 | 507778.0 |
| 2024-06-11 17:00:00 | AAPL | Stock | 207.68 | 207.77 | 207.15 | 207.5784 | 105391.0 |
| 2024-06-11 17:30:00 | AAPL | Stock | 207.58 | 207.58 | 207.01 | 207.15 | 103157.0 |
| 2024-06-11 18:00:00 | AAPL | Stock | 207.15 | 207.1999 | 206.61 | 206.8822 | 205153.0 |
| 2024-06-11 18:30:00 | AAPL | Stock | 206.86 | 207.0 | 206.8102 | 206.95 | 44688.0 |
| 2024-06-11 19:00:00 | AAPL | Stock | 206.91 | 207.44 | 206.91 | 207.18 | 107707.0 |
| 2024-06-11 19:30:00 | AAPL | Stock | 207.17 | 207.29 | 206.51 | 206.54 | 150449.0 |
| 2024-06-11 04:00:00 | MSFT | Stock | 427.17 | 427.52 | 427.17 | 427.42 | 726.0 |
| 2024-06-11 04:30:00 | MSFT | Stock | 427.7 | 427.7 | 427.27 | 427.27 | 318.0 |
| 2024-06-11 05:00:00 | MSFT | Stock | 427.0 | 427.0 | 427.0 | 427.0 | 100.0 |
| 2024-06-11 05:30:00 | MSFT | Stock | 427.01 | 427.22 | 427.0 | 427.22 | 518.0 |
| 2024-06-11 06:00:00 | MSFT | Stock | 427.1 | 427.1 | 426.9 | 426.9 | 243.0 |
| 2024-06-11 07:00:00 | MSFT | Stock | 426.79 | 426.79 | 425.61 | 426.39 | 3173.0 |
| 2024-06-11 07:30:00 | MSFT | Stock | 426.1 | 426.1 | 426.09 | 426.09 | 224.0 |
| 2024-06-11 08:00:00 | MSFT | Stock | 426.73 | 427.64 | 426.0 | 426.5 | 11276.0 |
| 2024-06-11 08:30:00 | MSFT | Stock | 426.68 | 426.8 | 426.2 | 426.39 | 3159.0 |
| 2024-06-11 09:00:00 | MSFT | Stock | 426.13 | 426.64 | 425.07 | 425.42 | 11022.0 |
| 2024-06-11 09:30:00 | MSFT | Stock | 425.44 | 427.36 | 425.25 | 426.47 | 741882.0 |
| 2024-06-11 10:00:00 | MSFT | Stock | 426.475 | 427.42 | 425.48 | 427.34 | 557598.0 |
| 2024-06-11 10:30:00 | MSFT | Stock | 427.33 | 428.24 | 427.18 | 428.13 | 408665.0 |
| 2024-06-11 11:00:00 | MSFT | Stock | 428.14 | 428.39 | 427.45 | 428.05 | 260314.0 |
| 2024-06-11 11:30:00 | MSFT | Stock | 428.05 | 428.79 | 428.04 | 428.35 | 372303.0 |
| 2024-06-11 12:00:00 | MSFT | Stock | 428.36 | 428.38 | 427.35 | 427.59 | 234924.0 |
| 2024-06-11 12:30:00 | MSFT | Stock | 427.59 | 427.86 | 427.2 | 427.82 | 210832.0 |
| 2024-06-11 13:00:00 | MSFT | Stock | 427.85 | 429.0107 | 427.72 | 428.23 | 510701.0 |
> showing 50 of 97,223 rows — these rows as CSV