PREVIEW / stock_30min / 2024-11-08
file: by_date/stock_30min/2024/2024-11-08.parquet size: 2.2 MB rows: 104,115 symbols: 708
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-08 04:00:00 | AAPL | Stock | 227.75 | 227.79 | 227.5 | 227.75 | 5580.0 |
| 2024-11-08 04:30:00 | AAPL | Stock | 227.8 | 227.81 | 227.72 | 227.79 | 2495.0 |
| 2024-11-08 05:00:00 | AAPL | Stock | 227.82 | 228.0 | 227.5 | 227.51 | 5516.0 |
| 2024-11-08 05:30:00 | AAPL | Stock | 227.51 | 227.53 | 227.0 | 227.06 | 7671.0 |
| 2024-11-08 06:00:00 | AAPL | Stock | 227.06 | 227.7 | 227.05 | 227.66 | 8029.0 |
| 2024-11-08 06:30:00 | AAPL | Stock | 227.57 | 227.7 | 227.5 | 227.56 | 3789.0 |
| 2024-11-08 07:00:00 | AAPL | Stock | 227.57 | 227.66 | 227.41 | 227.51 | 8541.0 |
| 2024-11-08 07:30:00 | AAPL | Stock | 227.55 | 227.71 | 227.51 | 227.55 | 4089.0 |
| 2024-11-08 08:00:00 | AAPL | Stock | 227.57 | 227.9 | 227.25 | 227.58 | 51493.0 |
| 2024-11-08 08:30:00 | AAPL | Stock | 227.58 | 227.609 | 227.3 | 227.37 | 16062.0 |
| 2024-11-08 09:00:00 | AAPL | Stock | 227.38 | 227.71 | 226.78 | 227.19 | 51555.0 |
| 2024-11-08 09:30:00 | AAPL | Stock | 227.17 | 228.66 | 227.14 | 227.7699 | 3142170.0 |
| 2024-11-08 10:00:00 | AAPL | Stock | 227.78 | 228.1499 | 227.44 | 227.4947 | 1596129.0 |
| 2024-11-08 10:30:00 | AAPL | Stock | 227.48 | 227.57 | 226.505 | 226.51 | 1327272.0 |
| 2024-11-08 11:00:00 | AAPL | Stock | 226.515 | 227.01 | 226.405 | 226.6881 | 1414190.0 |
| 2024-11-08 11:30:00 | AAPL | Stock | 226.685 | 227.58 | 226.685 | 227.27 | 1127100.0 |
| 2024-11-08 12:00:00 | AAPL | Stock | 227.265 | 227.28 | 226.75 | 226.88 | 827231.0 |
| 2024-11-08 12:30:00 | AAPL | Stock | 226.87 | 227.4565 | 226.863 | 227.02 | 752282.0 |
| 2024-11-08 13:00:00 | AAPL | Stock | 227.03 | 227.18 | 226.79 | 226.995 | 624100.0 |
| 2024-11-08 13:30:00 | AAPL | Stock | 227.0 | 227.61 | 226.97 | 227.5 | 865202.0 |
| 2024-11-08 14:00:00 | AAPL | Stock | 227.495 | 227.61 | 227.23 | 227.5399 | 646977.0 |
| 2024-11-08 14:30:00 | AAPL | Stock | 227.53 | 227.68 | 227.38 | 227.44 | 613432.0 |
| 2024-11-08 15:00:00 | AAPL | Stock | 227.435 | 227.72 | 227.26 | 227.47 | 1022384.0 |
| 2024-11-08 15:30:00 | AAPL | Stock | 227.45 | 227.485 | 226.72 | 227.16 | 3176604.0 |
| 2024-11-08 16:00:00 | AAPL | Stock | 226.96 | 227.39 | 226.96 | 227.23 | 6786112.0 |
| 2024-11-08 16:30:00 | AAPL | Stock | 227.22 | 227.39 | 226.96 | 227.18 | 11867.0 |
| 2024-11-08 17:00:00 | AAPL | Stock | 227.15 | 227.15 | 226.86 | 226.88 | 390246.0 |
| 2024-11-08 17:30:00 | AAPL | Stock | 226.94 | 227.2584 | 226.85 | 226.85 | 9350.0 |
| 2024-11-08 18:00:00 | AAPL | Stock | 226.88 | 226.94 | 226.85 | 226.89 | 4123.0 |
| 2024-11-08 18:30:00 | AAPL | Stock | 226.88 | 226.9912 | 226.86 | 226.96 | 3629.0 |
| 2024-11-08 19:00:00 | AAPL | Stock | 226.96 | 226.98 | 226.8808 | 226.96 | 3081.0 |
| 2024-11-08 19:30:00 | AAPL | Stock | 226.97 | 226.98 | 226.95 | 226.96 | 1999.0 |
| 2024-11-08 04:00:00 | MSFT | Stock | 425.97 | 427.0 | 425.97 | 426.12 | 1193.0 |
| 2024-11-08 04:30:00 | MSFT | Stock | 426.23 | 426.24 | 426.02 | 426.02 | 1388.0 |
| 2024-11-08 05:00:00 | MSFT | Stock | 425.73 | 425.73 | 425.0 | 425.0 | 1314.0 |
| 2024-11-08 05:30:00 | MSFT | Stock | 424.8 | 424.8 | 423.47 | 423.8 | 3247.0 |
| 2024-11-08 06:00:00 | MSFT | Stock | 423.45 | 423.6 | 423.05 | 423.05 | 4725.0 |
| 2024-11-08 06:30:00 | MSFT | Stock | 423.5 | 423.79 | 423.5 | 423.79 | 1415.0 |
| 2024-11-08 07:00:00 | MSFT | Stock | 423.78 | 424.63 | 423.78 | 424.25 | 6140.0 |
| 2024-11-08 07:30:00 | MSFT | Stock | 424.5 | 425.0 | 424.5 | 424.84 | 1332.0 |
| 2024-11-08 08:00:00 | MSFT | Stock | 424.6 | 426.493 | 423.81 | 424.48 | 17067.0 |
| 2024-11-08 08:30:00 | MSFT | Stock | 424.4 | 424.5 | 423.81 | 424.33 | 8847.0 |
| 2024-11-08 09:00:00 | MSFT | Stock | 424.15 | 425.36 | 423.9759 | 425.3 | 14446.0 |
| 2024-11-08 09:30:00 | MSFT | Stock | 425.41 | 426.5 | 424.38 | 426.15 | 1318893.0 |
| 2024-11-08 10:00:00 | MSFT | Stock | 426.24 | 426.5 | 423.875 | 424.15 | 854486.0 |
| 2024-11-08 10:30:00 | MSFT | Stock | 424.18 | 424.87 | 423.11 | 423.87 | 542019.0 |
| 2024-11-08 11:00:00 | MSFT | Stock | 423.88 | 424.07 | 423.0582 | 423.68 | 555756.0 |
| 2024-11-08 11:30:00 | MSFT | Stock | 423.695 | 424.37 | 423.59 | 423.8209 | 457260.0 |
| 2024-11-08 12:00:00 | MSFT | Stock | 423.8 | 423.85 | 422.15 | 422.435 | 435734.0 |
| 2024-11-08 12:30:00 | MSFT | Stock | 422.42 | 423.18 | 422.17 | 422.3 | 315730.0 |
> showing 50 of 104,115 rows — these rows as CSV