PREVIEW / stock_30min / 2024-10-23
file: by_date/stock_30min/2024/2024-10-23.parquet size: 2.1 MB rows: 100,464 symbols: 742
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-23 04:00:00 | AAPL | Stock | 235.39 | 235.7 | 235.12 | 235.31 | 1630.0 |
| 2024-10-23 04:30:00 | AAPL | Stock | 235.27 | 235.27 | 235.0 | 235.0 | 1135.0 |
| 2024-10-23 05:00:00 | AAPL | Stock | 234.94 | 234.94 | 234.81 | 234.92 | 2020.0 |
| 2024-10-23 05:30:00 | AAPL | Stock | 234.95 | 234.95 | 234.75 | 234.77 | 3006.0 |
| 2024-10-23 06:00:00 | AAPL | Stock | 234.72 | 234.87 | 234.66 | 234.66 | 1804.0 |
| 2024-10-23 06:30:00 | AAPL | Stock | 234.65 | 234.65 | 234.31 | 234.4 | 7944.0 |
| 2024-10-23 07:00:00 | AAPL | Stock | 234.53 | 234.85 | 234.52 | 234.62 | 20477.0 |
| 2024-10-23 07:30:00 | AAPL | Stock | 234.65 | 234.65 | 234.39 | 234.45 | 16920.0 |
| 2024-10-23 08:00:00 | AAPL | Stock | 234.74 | 235.48 | 234.25 | 234.57 | 48394.0 |
| 2024-10-23 08:30:00 | AAPL | Stock | 234.6974 | 234.6974 | 233.8 | 233.9979 | 45818.0 |
| 2024-10-23 09:00:00 | AAPL | Stock | 233.93 | 234.3 | 233.61 | 234.25 | 199584.0 |
| 2024-10-23 09:30:00 | AAPL | Stock | 234.13 | 235.144 | 233.81 | 234.915 | 3094503.0 |
| 2024-10-23 10:00:00 | AAPL | Stock | 234.915 | 234.96 | 234.11 | 234.72 | 1523447.0 |
| 2024-10-23 10:30:00 | AAPL | Stock | 234.72 | 235.1199 | 234.27 | 234.2925 | 1134921.0 |
| 2024-10-23 11:00:00 | AAPL | Stock | 234.29 | 234.5621 | 233.32 | 233.5 | 1457609.0 |
| 2024-10-23 11:30:00 | AAPL | Stock | 233.49 | 233.7362 | 230.58 | 231.56 | 4669362.0 |
| 2024-10-23 12:00:00 | AAPL | Stock | 231.58 | 231.9199 | 229.64 | 229.69 | 5447530.0 |
| 2024-10-23 12:30:00 | AAPL | Stock | 229.67 | 230.25 | 228.93 | 229.64 | 2828722.0 |
| 2024-10-23 13:00:00 | AAPL | Stock | 229.63 | 230.2 | 229.2 | 230.055 | 2010642.0 |
| 2024-10-23 13:30:00 | AAPL | Stock | 230.05 | 230.07 | 228.28 | 228.37 | 1742777.0 |
| 2024-10-23 14:00:00 | AAPL | Stock | 228.36 | 228.865 | 227.76 | 228.62 | 1928444.0 |
| 2024-10-23 14:30:00 | AAPL | Stock | 228.6 | 229.66 | 228.51 | 229.26 | 1525803.0 |
| 2024-10-23 15:00:00 | AAPL | Stock | 229.24 | 229.81 | 229.1802 | 229.68 | 1266340.0 |
| 2024-10-23 15:30:00 | AAPL | Stock | 229.69 | 230.86 | 229.61 | 230.75 | 3143160.0 |
| 2024-10-23 16:00:00 | AAPL | Stock | 230.76 | 230.77 | 230.02 | 230.3 | 7592290.0 |
| 2024-10-23 16:30:00 | AAPL | Stock | 230.3 | 230.7601 | 230.22 | 230.35 | 135274.0 |
| 2024-10-23 17:00:00 | AAPL | Stock | 230.51 | 230.76 | 230.29 | 230.43 | 191712.0 |
| 2024-10-23 17:30:00 | AAPL | Stock | 230.4108 | 230.53 | 230.31 | 230.49 | 16769.0 |
| 2024-10-23 18:00:00 | AAPL | Stock | 230.49 | 230.49 | 230.15 | 230.28 | 19107.0 |
| 2024-10-23 18:30:00 | AAPL | Stock | 230.33 | 230.33 | 230.12 | 230.25 | 5822.0 |
| 2024-10-23 19:00:00 | AAPL | Stock | 230.3 | 230.35 | 230.1121 | 230.25 | 16303.0 |
| 2024-10-23 19:30:00 | AAPL | Stock | 230.232 | 230.64 | 230.132 | 230.4178 | 12373.0 |
| 2024-10-23 04:00:00 | MSFT | Stock | 426.44 | 428.35 | 426.44 | 427.61 | 3416.0 |
| 2024-10-23 04:30:00 | MSFT | Stock | 427.08 | 427.6 | 427.08 | 427.34 | 1286.0 |
| 2024-10-23 05:00:00 | MSFT | Stock | 428.26 | 428.26 | 427.32 | 427.69 | 2999.0 |
| 2024-10-23 05:30:00 | MSFT | Stock | 427.69 | 427.85 | 427.69 | 427.75 | 981.0 |
| 2024-10-23 06:00:00 | MSFT | Stock | 427.5 | 427.5 | 426.45 | 426.5 | 2991.0 |
| 2024-10-23 06:30:00 | MSFT | Stock | 426.69 | 428.5 | 426.69 | 428.08 | 7627.0 |
| 2024-10-23 07:00:00 | MSFT | Stock | 428.22 | 428.98 | 428.0 | 428.68 | 7961.0 |
| 2024-10-23 07:30:00 | MSFT | Stock | 428.68 | 429.78 | 428.54 | 429.5 | 10514.0 |
| 2024-10-23 08:00:00 | MSFT | Stock | 428.37 | 431.41 | 426.38 | 430.99 | 67498.0 |
| 2024-10-23 08:30:00 | MSFT | Stock | 430.94 | 431.3796 | 429.76 | 430.918 | 41449.0 |
| 2024-10-23 09:00:00 | MSFT | Stock | 430.7 | 431.07 | 429.9 | 431.0 | 30951.0 |
| 2024-10-23 09:30:00 | MSFT | Stock | 431.07 | 431.08 | 426.7 | 429.26 | 1897579.0 |
| 2024-10-23 10:00:00 | MSFT | Stock | 429.255 | 430.18 | 427.8 | 429.06 | 1281229.0 |
| 2024-10-23 10:30:00 | MSFT | Stock | 429.06 | 430.59 | 428.675 | 428.77 | 674424.0 |
| 2024-10-23 11:00:00 | MSFT | Stock | 428.775 | 429.64 | 427.94 | 428.0 | 603653.0 |
| 2024-10-23 11:30:00 | MSFT | Stock | 428.0 | 429.48 | 427.5789 | 429.405 | 454771.0 |
| 2024-10-23 12:00:00 | MSFT | Stock | 429.3249 | 429.3249 | 427.12 | 427.3853 | 431516.0 |
| 2024-10-23 12:30:00 | MSFT | Stock | 427.38 | 427.59 | 426.54 | 426.91 | 403853.0 |
> showing 50 of 100,464 rows — these rows as CSV