PREVIEW / stock_30min / 2024-11-26
file: by_date/stock_30min/2024/2024-11-26.parquet size: 2.2 MB rows: 103,976 symbols: 684
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-26 04:00:00 | AAPL | Stock | 231.93 | 233.0 | 231.93 | 232.65 | 37524.0 |
| 2024-11-26 04:30:00 | AAPL | Stock | 232.51 | 232.7 | 232.45 | 232.7 | 3550.0 |
| 2024-11-26 05:00:00 | AAPL | Stock | 232.67 | 232.82 | 232.64 | 232.64 | 2303.0 |
| 2024-11-26 05:30:00 | AAPL | Stock | 232.62 | 232.64 | 232.49 | 232.6 | 8351.0 |
| 2024-11-26 06:00:00 | AAPL | Stock | 232.6 | 232.6 | 232.25 | 232.25 | 15646.0 |
| 2024-11-26 06:30:00 | AAPL | Stock | 232.28 | 233.08 | 232.26 | 232.95 | 15580.0 |
| 2024-11-26 07:00:00 | AAPL | Stock | 232.93 | 233.48 | 232.72 | 233.39 | 41286.0 |
| 2024-11-26 07:30:00 | AAPL | Stock | 233.4 | 233.48 | 233.08 | 233.18 | 9839.0 |
| 2024-11-26 08:00:00 | AAPL | Stock | 233.33 | 233.48 | 231.93 | 233.01 | 65765.0 |
| 2024-11-26 08:30:00 | AAPL | Stock | 233.0001 | 233.5 | 233.0 | 233.37 | 42661.0 |
| 2024-11-26 09:00:00 | AAPL | Stock | 233.3899 | 233.6899 | 232.86 | 233.47 | 151401.0 |
| 2024-11-26 09:30:00 | AAPL | Stock | 233.35 | 235.435 | 233.33 | 234.81 | 5787049.0 |
| 2024-11-26 10:00:00 | AAPL | Stock | 234.78 | 235.0 | 233.65 | 234.37 | 2124753.0 |
| 2024-11-26 10:30:00 | AAPL | Stock | 234.36 | 235.57 | 234.21 | 235.1699 | 2361724.0 |
| 2024-11-26 11:00:00 | AAPL | Stock | 235.17 | 235.46 | 234.94 | 235.04 | 1215294.0 |
| 2024-11-26 11:30:00 | AAPL | Stock | 235.04 | 235.1047 | 234.61 | 235.03 | 1208953.0 |
| 2024-11-26 12:00:00 | AAPL | Stock | 235.02 | 235.06 | 234.27 | 234.48 | 1008682.0 |
| 2024-11-26 12:30:00 | AAPL | Stock | 234.485 | 235.18 | 234.43 | 235.0 | 1104170.0 |
| 2024-11-26 13:00:00 | AAPL | Stock | 235.005 | 235.0298 | 234.35 | 234.51 | 1074675.0 |
| 2024-11-26 13:30:00 | AAPL | Stock | 234.51 | 235.08 | 234.445 | 235.08 | 860346.0 |
| 2024-11-26 14:00:00 | AAPL | Stock | 235.07 | 235.1 | 234.56 | 234.94 | 946995.0 |
| 2024-11-26 14:30:00 | AAPL | Stock | 234.925 | 235.03 | 234.73 | 234.92 | 854695.0 |
| 2024-11-26 15:00:00 | AAPL | Stock | 234.91 | 235.25 | 234.725 | 234.81 | 1324394.0 |
| 2024-11-26 15:30:00 | AAPL | Stock | 234.81 | 235.28 | 234.58 | 235.08 | 3734924.0 |
| 2024-11-26 16:00:00 | AAPL | Stock | 235.06 | 235.49 | 234.9811 | 235.3076 | 7357295.0 |
| 2024-11-26 16:30:00 | AAPL | Stock | 235.35 | 235.55 | 235.06 | 235.55 | 38251.0 |
| 2024-11-26 17:00:00 | AAPL | Stock | 235.55 | 235.62 | 235.45 | 235.4799 | 16678.0 |
| 2024-11-26 17:30:00 | AAPL | Stock | 235.41 | 235.51 | 235.35 | 235.41 | 5244.0 |
| 2024-11-26 18:00:00 | AAPL | Stock | 235.41 | 235.64 | 235.06 | 235.48 | 11506.0 |
| 2024-11-26 18:30:00 | AAPL | Stock | 235.45 | 235.64 | 235.41 | 235.4617 | 4472.0 |
| 2024-11-26 19:00:00 | AAPL | Stock | 235.5935 | 235.65 | 235.5 | 235.5768 | 6912.0 |
| 2024-11-26 19:30:00 | AAPL | Stock | 235.5799 | 235.65 | 235.3109 | 235.53 | 10369.0 |
| 2024-11-26 04:00:00 | MSFT | Stock | 417.66 | 418.84 | 415.15 | 418.79 | 9826.0 |
| 2024-11-26 04:30:00 | MSFT | Stock | 418.79 | 418.79 | 417.9 | 418.0 | 5160.0 |
| 2024-11-26 05:00:00 | MSFT | Stock | 418.0 | 418.46 | 416.99 | 417.0 | 40818.0 |
| 2024-11-26 05:30:00 | MSFT | Stock | 417.0 | 417.55 | 416.98 | 417.4 | 3273.0 |
| 2024-11-26 06:00:00 | MSFT | Stock | 417.4 | 418.07 | 417.39 | 417.92 | 2305.0 |
| 2024-11-26 06:30:00 | MSFT | Stock | 417.35 | 418.5 | 417.35 | 418.5 | 699.0 |
| 2024-11-26 07:00:00 | MSFT | Stock | 418.76 | 419.19 | 418.76 | 418.9 | 1136.0 |
| 2024-11-26 07:30:00 | MSFT | Stock | 418.89 | 419.22 | 418.89 | 419.0 | 1637.0 |
| 2024-11-26 08:00:00 | MSFT | Stock | 418.68 | 419.24 | 417.67 | 418.7 | 14520.0 |
| 2024-11-26 08:30:00 | MSFT | Stock | 418.55 | 419.72 | 418.4 | 419.58 | 20192.0 |
| 2024-11-26 09:00:00 | MSFT | Stock | 419.58 | 420.5 | 418.79 | 419.31 | 22289.0 |
| 2024-11-26 09:30:00 | MSFT | Stock | 419.69 | 424.57 | 418.85 | 424.29 | 2521894.0 |
| 2024-11-26 10:00:00 | MSFT | Stock | 424.32 | 425.29 | 423.52 | 424.7075 | 1133590.0 |
| 2024-11-26 10:30:00 | MSFT | Stock | 424.75 | 427.25 | 424.71 | 425.64 | 969295.0 |
| 2024-11-26 11:00:00 | MSFT | Stock | 425.67 | 426.8 | 425.36 | 425.41 | 568238.0 |
| 2024-11-26 11:30:00 | MSFT | Stock | 425.41 | 426.46 | 425.2101 | 425.8999 | 379374.0 |
| 2024-11-26 12:00:00 | MSFT | Stock | 425.87 | 426.15 | 425.135 | 425.48 | 312699.0 |
| 2024-11-26 12:30:00 | MSFT | Stock | 425.475 | 426.97 | 425.43 | 426.9 | 364074.0 |
> showing 50 of 103,976 rows — these rows as CSV