PREVIEW / stock_30min / 2024-09-27
file: by_date/stock_30min/2024/2024-09-27.parquet size: 2.1 MB rows: 99,800 symbols: 770
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-09-27 04:00:00 | AAPL | Stock | 226.4 | 227.57 | 226.11 | 227.57 | 11420.0 |
| 2024-09-27 04:30:00 | AAPL | Stock | 227.56 | 227.62 | 227.24 | 227.24 | 4796.0 |
| 2024-09-27 05:00:00 | AAPL | Stock | 227.24 | 227.53 | 227.0 | 227.43 | 6037.0 |
| 2024-09-27 05:30:00 | AAPL | Stock | 227.26 | 228.11 | 227.14 | 228.11 | 13558.0 |
| 2024-09-27 06:00:00 | AAPL | Stock | 227.92 | 228.09 | 227.85 | 228.0 | 1997.0 |
| 2024-09-27 06:30:00 | AAPL | Stock | 227.94 | 228.0 | 227.52 | 227.72 | 6871.0 |
| 2024-09-27 07:00:00 | AAPL | Stock | 227.68 | 227.99 | 227.62 | 227.99 | 3758.0 |
| 2024-09-27 07:30:00 | AAPL | Stock | 227.85 | 228.11 | 227.75 | 228.01 | 3625.0 |
| 2024-09-27 08:00:00 | AAPL | Stock | 227.69 | 228.15 | 226.89 | 228.1467 | 37593.0 |
| 2024-09-27 08:30:00 | AAPL | Stock | 228.15 | 228.5 | 227.9 | 228.0195 | 48412.0 |
| 2024-09-27 09:00:00 | AAPL | Stock | 228.04 | 228.7 | 227.9 | 228.49 | 63364.0 |
| 2024-09-27 09:30:00 | AAPL | Stock | 228.48 | 229.51 | 227.99 | 228.8 | 3240500.0 |
| 2024-09-27 10:00:00 | AAPL | Stock | 228.81 | 229.52 | 228.78 | 228.965 | 1966275.0 |
| 2024-09-27 10:30:00 | AAPL | Stock | 228.965 | 229.07 | 228.5 | 228.64 | 1330026.0 |
| 2024-09-27 11:00:00 | AAPL | Stock | 228.64 | 228.7106 | 227.84 | 228.14 | 1335703.0 |
| 2024-09-27 11:30:00 | AAPL | Stock | 228.12 | 228.25 | 227.3 | 227.51 | 1151811.0 |
| 2024-09-27 12:00:00 | AAPL | Stock | 227.51 | 228.25 | 227.44 | 228.15 | 859098.0 |
| 2024-09-27 12:30:00 | AAPL | Stock | 228.14 | 228.34 | 228.02 | 228.33 | 582899.0 |
| 2024-09-27 13:00:00 | AAPL | Stock | 228.34 | 228.62 | 227.92 | 227.995 | 786130.0 |
| 2024-09-27 13:30:00 | AAPL | Stock | 227.99 | 228.385 | 227.81 | 228.365 | 593707.0 |
| 2024-09-27 14:00:00 | AAPL | Stock | 228.36 | 228.52 | 227.83 | 227.895 | 773204.0 |
| 2024-09-27 14:30:00 | AAPL | Stock | 227.9 | 228.19 | 227.53 | 228.1066 | 755773.0 |
| 2024-09-27 15:00:00 | AAPL | Stock | 228.12 | 228.13 | 227.6641 | 227.81 | 765003.0 |
| 2024-09-27 15:30:00 | AAPL | Stock | 227.82 | 228.0 | 227.55 | 227.82 | 2463131.0 |
| 2024-09-27 16:00:00 | AAPL | Stock | 227.79 | 227.79 | 227.42 | 227.53 | 6845663.0 |
| 2024-09-27 16:30:00 | AAPL | Stock | 227.54 | 227.79 | 227.54 | 227.5985 | 74107.0 |
| 2024-09-27 17:00:00 | AAPL | Stock | 227.57 | 227.65 | 227.57 | 227.65 | 4755.0 |
| 2024-09-27 17:30:00 | AAPL | Stock | 227.6 | 227.6 | 227.486 | 227.57 | 9860.0 |
| 2024-09-27 18:00:00 | AAPL | Stock | 227.505 | 227.59 | 227.505 | 227.54 | 375.0 |
| 2024-09-27 18:30:00 | AAPL | Stock | 227.53 | 227.57 | 227.49 | 227.57 | 1424.0 |
| 2024-09-27 19:00:00 | AAPL | Stock | 227.5 | 227.55 | 227.45 | 227.45 | 4884.0 |
| 2024-09-27 19:30:00 | AAPL | Stock | 227.46 | 227.5 | 227.14 | 227.4982 | 17311.0 |
| 2024-09-27 04:00:00 | MSFT | Stock | 430.0 | 430.48 | 429.15 | 430.48 | 4837.0 |
| 2024-09-27 04:30:00 | MSFT | Stock | 430.78 | 431.0 | 430.5 | 430.5 | 983.0 |
| 2024-09-27 05:30:00 | MSFT | Stock | 430.4 | 430.4 | 430.09 | 430.09 | 340.0 |
| 2024-09-27 06:00:00 | MSFT | Stock | 430.39 | 430.59 | 430.39 | 430.59 | 200.0 |
| 2024-09-27 06:30:00 | MSFT | Stock | 430.67 | 431.04 | 430.67 | 430.87 | 1009.0 |
| 2024-09-27 07:00:00 | MSFT | Stock | 430.81 | 430.95 | 430.65 | 430.95 | 766.0 |
| 2024-09-27 07:30:00 | MSFT | Stock | 431.2 | 431.4 | 431.2 | 431.31 | 1536.0 |
| 2024-09-27 08:00:00 | MSFT | Stock | 430.8 | 432.0 | 430.6 | 431.988 | 9023.0 |
| 2024-09-27 08:30:00 | MSFT | Stock | 432.0 | 432.74 | 431.89 | 432.62 | 11337.0 |
| 2024-09-27 09:00:00 | MSFT | Stock | 432.52 | 432.95 | 431.4 | 431.8 | 24616.0 |
| 2024-09-27 09:30:00 | MSFT | Stock | 431.8 | 431.8 | 429.9 | 430.76 | 832814.0 |
| 2024-09-27 10:00:00 | MSFT | Stock | 430.78 | 431.85 | 430.71 | 431.215 | 479908.0 |
| 2024-09-27 10:30:00 | MSFT | Stock | 431.24 | 431.34 | 430.455 | 430.83 | 334751.0 |
| 2024-09-27 11:00:00 | MSFT | Stock | 430.8288 | 431.07 | 429.97 | 430.21 | 294633.0 |
| 2024-09-27 11:30:00 | MSFT | Stock | 430.27 | 430.27 | 428.25 | 428.295 | 407960.0 |
| 2024-09-27 12:00:00 | MSFT | Stock | 428.28 | 428.91 | 427.47 | 428.5882 | 456283.0 |
| 2024-09-27 12:30:00 | MSFT | Stock | 428.57 | 429.13 | 428.32 | 429.07 | 236842.0 |
| 2024-09-27 13:00:00 | MSFT | Stock | 429.04 | 429.57 | 428.74 | 428.77 | 182299.0 |
> showing 50 of 99,800 rows — these rows as CSV