PREVIEW / stock_30min / 2024-04-11
file: by_date/stock_30min/2024/2024-04-11.parquet size: 2.0 MB rows: 98,467 symbols: 1,021
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-04-11 04:00:00 | AAPL | Stock | 167.96 | 168.26 | 167.78 | 168.24 | 5129.0 |
| 2024-04-11 04:30:00 | AAPL | Stock | 168.22 | 168.25 | 167.84 | 168.09 | 16898.0 |
| 2024-04-11 05:00:00 | AAPL | Stock | 168.01 | 168.15 | 167.92 | 168.05 | 4565.0 |
| 2024-04-11 05:30:00 | AAPL | Stock | 168.05 | 168.36 | 168.05 | 168.08 | 12391.0 |
| 2024-04-11 06:00:00 | AAPL | Stock | 168.12 | 168.24 | 168.0 | 168.24 | 2145.0 |
| 2024-04-11 06:30:00 | AAPL | Stock | 168.19 | 168.3 | 168.07 | 168.16 | 3003.0 |
| 2024-04-11 07:00:00 | AAPL | Stock | 168.09 | 168.25 | 168.03 | 168.07 | 9335.0 |
| 2024-04-11 07:30:00 | AAPL | Stock | 168.065 | 168.11 | 167.78 | 167.83 | 23167.0 |
| 2024-04-11 08:00:00 | AAPL | Stock | 168.1008 | 168.25 | 167.7 | 167.92 | 89222.0 |
| 2024-04-11 08:30:00 | AAPL | Stock | 167.91 | 168.88 | 167.8 | 168.52 | 218576.0 |
| 2024-04-11 09:00:00 | AAPL | Stock | 168.59 | 169.0 | 168.27 | 168.28 | 149296.0 |
| 2024-04-11 09:30:00 | AAPL | Stock | 168.3 | 169.17 | 168.16 | 168.97 | 4677618.0 |
| 2024-04-11 10:00:00 | AAPL | Stock | 168.97 | 169.0 | 168.31 | 168.72 | 2544873.0 |
| 2024-04-11 10:30:00 | AAPL | Stock | 168.73 | 169.33 | 168.57 | 169.15 | 2912593.0 |
| 2024-04-11 11:00:00 | AAPL | Stock | 169.155 | 169.43 | 168.945 | 169.0 | 1912390.0 |
| 2024-04-11 11:30:00 | AAPL | Stock | 169.0011 | 169.9403 | 169.0 | 169.9088 | 2000876.0 |
| 2024-04-11 12:00:00 | AAPL | Stock | 169.92 | 170.29 | 169.83 | 169.91 | 2397651.0 |
| 2024-04-11 12:30:00 | AAPL | Stock | 169.92 | 170.44 | 169.84 | 170.395 | 2755004.0 |
| 2024-04-11 13:00:00 | AAPL | Stock | 170.3916 | 172.19 | 170.3 | 172.11 | 5719377.0 |
| 2024-04-11 13:30:00 | AAPL | Stock | 172.11 | 173.25 | 171.9601 | 173.02 | 6690606.0 |
| 2024-04-11 14:00:00 | AAPL | Stock | 173.02 | 174.48 | 172.94 | 174.18 | 6694772.0 |
| 2024-04-11 14:30:00 | AAPL | Stock | 174.18 | 174.5 | 173.55 | 173.57 | 6169491.0 |
| 2024-04-11 15:00:00 | AAPL | Stock | 173.565 | 174.86 | 173.55 | 174.7399 | 6451538.0 |
| 2024-04-11 15:30:00 | AAPL | Stock | 174.74 | 175.46 | 174.62 | 175.04 | 12033148.0 |
| 2024-04-11 16:00:00 | AAPL | Stock | 175.04 | 175.47 | 174.68 | 175.23 | 10832590.0 |
| 2024-04-11 16:30:00 | AAPL | Stock | 175.21 | 175.23 | 174.82 | 174.85 | 362789.0 |
| 2024-04-11 17:00:00 | AAPL | Stock | 174.8799 | 175.0 | 174.81 | 174.95 | 58193.0 |
| 2024-04-11 17:30:00 | AAPL | Stock | 174.92 | 175.04 | 174.86 | 174.87 | 23660.0 |
| 2024-04-11 18:00:00 | AAPL | Stock | 174.86 | 175.0 | 174.86 | 174.94 | 42564.0 |
| 2024-04-11 18:30:00 | AAPL | Stock | 174.9331 | 174.97 | 174.9 | 174.9 | 19357.0 |
| 2024-04-11 19:00:00 | AAPL | Stock | 174.96 | 175.25 | 174.89 | 175.2 | 42015.0 |
| 2024-04-11 19:30:00 | AAPL | Stock | 175.2 | 175.6 | 175.06 | 175.5999 | 66865.0 |
| 2024-04-11 04:00:00 | MSFT | Stock | 423.35 | 425.07 | 423.35 | 424.8 | 8447.0 |
| 2024-04-11 04:30:00 | MSFT | Stock | 425.0 | 426.36 | 425.0 | 425.55 | 6058.0 |
| 2024-04-11 05:00:00 | MSFT | Stock | 425.35 | 426.65 | 425.27 | 425.75 | 6003.0 |
| 2024-04-11 05:30:00 | MSFT | Stock | 426.21 | 426.47 | 425.84 | 426.03 | 2463.0 |
| 2024-04-11 06:00:00 | MSFT | Stock | 425.75 | 425.95 | 425.47 | 425.95 | 1937.0 |
| 2024-04-11 06:30:00 | MSFT | Stock | 426.07 | 426.79 | 426.02 | 426.79 | 2330.0 |
| 2024-04-11 07:00:00 | MSFT | Stock | 426.05 | 426.23 | 425.3 | 425.4 | 16132.0 |
| 2024-04-11 07:30:00 | MSFT | Stock | 425.36 | 425.6 | 424.0 | 424.58 | 15579.0 |
| 2024-04-11 08:00:00 | MSFT | Stock | 425.99 | 426.04 | 423.0 | 425.0 | 53195.0 |
| 2024-04-11 08:30:00 | MSFT | Stock | 425.0 | 427.74 | 425.0 | 427.03 | 123033.0 |
| 2024-04-11 09:00:00 | MSFT | Stock | 427.05 | 427.5 | 425.5 | 425.99 | 42215.0 |
| 2024-04-11 09:30:00 | MSFT | Stock | 425.83 | 426.8 | 424.03 | 424.415 | 1526259.0 |
| 2024-04-11 10:00:00 | MSFT | Stock | 424.425 | 424.64 | 422.36 | 423.79 | 883904.0 |
| 2024-04-11 10:30:00 | MSFT | Stock | 423.71 | 424.39 | 423.57 | 423.88 | 522298.0 |
| 2024-04-11 11:00:00 | MSFT | Stock | 423.9 | 424.91 | 423.71 | 424.2492 | 459072.0 |
| 2024-04-11 11:30:00 | MSFT | Stock | 424.23 | 426.05 | 424.2 | 425.965 | 502315.0 |
| 2024-04-11 12:00:00 | MSFT | Stock | 425.99 | 426.43 | 425.6 | 425.68 | 514189.0 |
| 2024-04-11 12:30:00 | MSFT | Stock | 425.685 | 425.89 | 424.92 | 424.96 | 319926.0 |
> showing 50 of 98,467 rows — these rows as CSV