PREVIEW / stock_30min / 2024-01-03
file: by_date/stock_30min/2024/2024-01-03.parquet size: 2.1 MB rows: 101,370 symbols: 1,183
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-01-03 04:00:00 | AAPL | Stock | 185.0 | 185.0 | 184.73 | 184.92 | 10592.0 |
| 2024-01-03 04:30:00 | AAPL | Stock | 184.86 | 184.9 | 184.72 | 184.72 | 2108.0 |
| 2024-01-03 05:00:00 | AAPL | Stock | 184.67 | 184.81 | 184.67 | 184.7 | 6872.0 |
| 2024-01-03 05:30:00 | AAPL | Stock | 184.69 | 184.83 | 184.69 | 184.73 | 3806.0 |
| 2024-01-03 06:00:00 | AAPL | Stock | 184.8 | 184.83 | 184.7 | 184.7 | 601.0 |
| 2024-01-03 06:30:00 | AAPL | Stock | 184.66 | 185.0 | 184.66 | 185.0 | 10364.0 |
| 2024-01-03 07:00:00 | AAPL | Stock | 184.95 | 184.99 | 184.58 | 184.67 | 16203.0 |
| 2024-01-03 07:30:00 | AAPL | Stock | 184.61 | 184.88 | 184.31 | 184.31 | 32112.0 |
| 2024-01-03 08:00:00 | AAPL | Stock | 184.975 | 185.64 | 184.19 | 184.63 | 102368.0 |
| 2024-01-03 08:30:00 | AAPL | Stock | 184.61 | 184.8789 | 184.48 | 184.65 | 52602.0 |
| 2024-01-03 09:00:00 | AAPL | Stock | 184.68 | 184.8 | 183.5 | 184.3 | 234242.0 |
| 2024-01-03 09:30:00 | AAPL | Stock | 184.29 | 185.88 | 183.86 | 184.7701 | 7741227.0 |
| 2024-01-03 10:00:00 | AAPL | Stock | 184.77 | 185.29 | 183.63 | 183.9587 | 4548939.0 |
| 2024-01-03 10:30:00 | AAPL | Stock | 183.955 | 184.12 | 183.45 | 183.86 | 3284909.0 |
| 2024-01-03 11:00:00 | AAPL | Stock | 183.855 | 184.27 | 183.855 | 184.2 | 2466722.0 |
| 2024-01-03 11:30:00 | AAPL | Stock | 184.19 | 184.38 | 183.49 | 183.51 | 2435171.0 |
| 2024-01-03 12:00:00 | AAPL | Stock | 183.505 | 183.94 | 183.43 | 183.93 | 2027240.0 |
| 2024-01-03 12:30:00 | AAPL | Stock | 183.9271 | 184.37 | 183.8517 | 184.335 | 1689434.0 |
| 2024-01-03 13:00:00 | AAPL | Stock | 184.33 | 184.55 | 184.2381 | 184.4731 | 1667838.0 |
| 2024-01-03 13:30:00 | AAPL | Stock | 184.475 | 184.56 | 184.18 | 184.37 | 1352890.0 |
| 2024-01-03 14:00:00 | AAPL | Stock | 184.36 | 184.82 | 183.805 | 184.74 | 2305332.0 |
| 2024-01-03 14:30:00 | AAPL | Stock | 184.7495 | 184.94 | 184.495 | 184.6499 | 1757884.0 |
| 2024-01-03 15:00:00 | AAPL | Stock | 184.65 | 184.71 | 184.2101 | 184.39 | 1806493.0 |
| 2024-01-03 15:30:00 | AAPL | Stock | 184.39 | 184.52 | 183.75 | 184.24 | 4247474.0 |
| 2024-01-03 16:00:00 | AAPL | Stock | 184.25 | 184.33 | 184.1997 | 184.21 | 8163973.0 |
| 2024-01-03 16:30:00 | AAPL | Stock | 184.23 | 184.26 | 184.03 | 184.2 | 27857.0 |
| 2024-01-03 17:00:00 | AAPL | Stock | 184.18 | 184.25 | 184.0201 | 184.14 | 37807.0 |
| 2024-01-03 17:30:00 | AAPL | Stock | 184.15 | 184.25 | 184.13 | 184.13 | 33142.0 |
| 2024-01-03 18:00:00 | AAPL | Stock | 184.18 | 184.3 | 184.17 | 184.25 | 12134.0 |
| 2024-01-03 18:30:00 | AAPL | Stock | 184.2001 | 184.29 | 184.2 | 184.29 | 9020.0 |
| 2024-01-03 19:00:00 | AAPL | Stock | 184.2 | 184.2 | 184.0 | 184.17 | 8397.0 |
| 2024-01-03 19:30:00 | AAPL | Stock | 184.17 | 184.3 | 184.1699 | 184.3 | 9402.0 |
| 2024-01-03 04:00:00 | MSFT | Stock | 369.49 | 369.61 | 367.14 | 367.8 | 8756.0 |
| 2024-01-03 04:30:00 | MSFT | Stock | 367.7 | 367.7 | 367.47 | 367.63 | 1387.0 |
| 2024-01-03 05:00:00 | MSFT | Stock | 367.6 | 368.49 | 367.6 | 368.07 | 2516.0 |
| 2024-01-03 05:30:00 | MSFT | Stock | 368.42 | 368.42 | 368.42 | 368.42 | 100.0 |
| 2024-01-03 06:00:00 | MSFT | Stock | 368.3 | 368.31 | 367.7 | 367.7 | 642.0 |
| 2024-01-03 06:30:00 | MSFT | Stock | 367.44 | 367.6 | 367.44 | 367.6 | 989.0 |
| 2024-01-03 07:00:00 | MSFT | Stock | 367.71 | 368.03 | 367.4 | 367.53 | 6543.0 |
| 2024-01-03 07:30:00 | MSFT | Stock | 367.59 | 367.68 | 367.25 | 367.59 | 1933.0 |
| 2024-01-03 08:00:00 | MSFT | Stock | 370.87 | 370.87 | 367.25 | 368.24 | 32500.0 |
| 2024-01-03 08:30:00 | MSFT | Stock | 368.23 | 368.41 | 367.9403 | 367.9403 | 10273.0 |
| 2024-01-03 09:00:00 | MSFT | Stock | 367.99 | 369.0 | 367.18 | 368.99 | 30373.0 |
| 2024-01-03 09:30:00 | MSFT | Stock | 368.99 | 373.25 | 368.51 | 372.07 | 2363488.0 |
| 2024-01-03 10:00:00 | MSFT | Stock | 372.06 | 373.2562 | 371.07 | 372.1 | 1137856.0 |
| 2024-01-03 10:30:00 | MSFT | Stock | 372.105 | 372.47 | 371.42 | 372.29 | 761212.0 |
| 2024-01-03 11:00:00 | MSFT | Stock | 372.31 | 372.8299 | 370.82 | 371.87 | 751782.0 |
| 2024-01-03 11:30:00 | MSFT | Stock | 371.83 | 372.04 | 370.56 | 370.7993 | 567187.0 |
| 2024-01-03 12:00:00 | MSFT | Stock | 370.8 | 371.72 | 370.7247 | 371.71 | 479785.0 |
| 2024-01-03 12:30:00 | MSFT | Stock | 371.69 | 372.44 | 371.6 | 372.42 | 405072.0 |
> showing 50 of 101,370 rows — these rows as CSV