PREVIEW / stock_30min / 2023-12-11
file: by_date/stock_30min/2023/2023-12-11.parquet size: 2.1 MB rows: 101,428 symbols: 1,295
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-11 04:00:00 | AAPL | Stock | 195.01 | 195.05 | 194.92 | 194.99 | 15178.0 |
| 2023-12-11 04:30:00 | AAPL | Stock | 194.98 | 195.0 | 194.8 | 194.8 | 13512.0 |
| 2023-12-11 05:00:00 | AAPL | Stock | 194.83 | 194.85 | 194.76 | 194.82 | 15869.0 |
| 2023-12-11 05:30:00 | AAPL | Stock | 194.81 | 194.81 | 194.61 | 194.64 | 8804.0 |
| 2023-12-11 06:00:00 | AAPL | Stock | 194.66 | 194.68 | 194.46 | 194.49 | 6325.0 |
| 2023-12-11 06:30:00 | AAPL | Stock | 194.5 | 194.7 | 194.5 | 194.7 | 5395.0 |
| 2023-12-11 07:00:00 | AAPL | Stock | 194.75 | 195.5 | 194.74 | 195.25 | 44469.0 |
| 2023-12-11 07:30:00 | AAPL | Stock | 195.25 | 195.25 | 194.95 | 194.95 | 29204.0 |
| 2023-12-11 08:00:00 | AAPL | Stock | 194.98 | 195.4763 | 194.48 | 194.85 | 135582.0 |
| 2023-12-11 08:30:00 | AAPL | Stock | 194.83 | 194.97 | 194.75 | 194.91 | 56029.0 |
| 2023-12-11 09:00:00 | AAPL | Stock | 194.91 | 195.19 | 191.54 | 193.05 | 815180.0 |
| 2023-12-11 09:30:00 | AAPL | Stock | 193.22 | 193.49 | 192.29 | 192.89 | 10381752.0 |
| 2023-12-11 10:00:00 | AAPL | Stock | 192.9 | 192.99 | 192.02 | 192.11 | 4021213.0 |
| 2023-12-11 10:30:00 | AAPL | Stock | 192.12 | 192.43 | 191.705 | 191.96 | 3359381.0 |
| 2023-12-11 11:00:00 | AAPL | Stock | 191.965 | 192.225 | 191.42 | 191.81 | 2869463.0 |
| 2023-12-11 11:30:00 | AAPL | Stock | 191.81 | 192.04 | 191.49 | 191.98 | 1928720.0 |
| 2023-12-11 12:00:00 | AAPL | Stock | 191.97 | 192.39 | 191.81 | 192.1 | 1758230.0 |
| 2023-12-11 12:30:00 | AAPL | Stock | 192.1099 | 192.35 | 192.06 | 192.2142 | 1184346.0 |
| 2023-12-11 13:00:00 | AAPL | Stock | 192.22 | 192.59 | 192.15 | 192.455 | 1696992.0 |
| 2023-12-11 13:30:00 | AAPL | Stock | 192.47 | 192.81 | 192.47 | 192.785 | 1617713.0 |
| 2023-12-11 14:00:00 | AAPL | Stock | 192.788 | 192.97 | 192.68 | 192.7918 | 1421860.0 |
| 2023-12-11 14:30:00 | AAPL | Stock | 192.795 | 193.005 | 192.75 | 192.895 | 1793218.0 |
| 2023-12-11 15:00:00 | AAPL | Stock | 192.9 | 193.125 | 192.75 | 192.87 | 1976458.0 |
| 2023-12-11 15:30:00 | AAPL | Stock | 192.87 | 193.31 | 192.83 | 193.19 | 4458529.0 |
| 2023-12-11 16:00:00 | AAPL | Stock | 193.2 | 193.26 | 193.18 | 193.18 | 8499947.0 |
| 2023-12-11 16:30:00 | AAPL | Stock | 193.23 | 193.23 | 193.18 | 193.2259 | 59005.0 |
| 2023-12-11 17:00:00 | AAPL | Stock | 193.22 | 193.23 | 193.13 | 193.18 | 11790.0 |
| 2023-12-11 17:30:00 | AAPL | Stock | 193.18 | 193.18 | 193.0997 | 193.1 | 15794.0 |
| 2023-12-11 18:00:00 | AAPL | Stock | 193.09 | 193.18 | 193.01 | 193.06 | 6854.0 |
| 2023-12-11 18:30:00 | AAPL | Stock | 193.1636 | 193.18 | 193.13 | 193.18 | 3291.0 |
| 2023-12-11 19:00:00 | AAPL | Stock | 193.18 | 193.52 | 193.18 | 193.45 | 20239.0 |
| 2023-12-11 19:30:00 | AAPL | Stock | 193.4 | 193.45 | 193.28 | 193.42 | 5221.0 |
| 2023-12-11 04:00:00 | MSFT | Stock | 373.51 | 373.89 | 373.51 | 373.8 | 2085.0 |
| 2023-12-11 04:30:00 | MSFT | Stock | 373.6 | 373.6 | 373.09 | 373.09 | 4143.0 |
| 2023-12-11 05:00:00 | MSFT | Stock | 373.2 | 373.2 | 372.6 | 373.01 | 5101.0 |
| 2023-12-11 05:30:00 | MSFT | Stock | 372.83 | 373.0 | 372.65 | 372.71 | 2653.0 |
| 2023-12-11 06:00:00 | MSFT | Stock | 372.63 | 372.69 | 372.53 | 372.69 | 350.0 |
| 2023-12-11 06:30:00 | MSFT | Stock | 372.5 | 372.68 | 372.5 | 372.68 | 550.0 |
| 2023-12-11 07:00:00 | MSFT | Stock | 372.68 | 373.11 | 372.68 | 373.0 | 8159.0 |
| 2023-12-11 07:30:00 | MSFT | Stock | 372.9 | 372.9 | 371.97 | 371.97 | 13687.0 |
| 2023-12-11 08:00:00 | MSFT | Stock | 372.99 | 373.22 | 371.01 | 371.3 | 55810.0 |
| 2023-12-11 08:30:00 | MSFT | Stock | 371.299 | 371.3 | 370.61 | 370.7 | 29120.0 |
| 2023-12-11 09:00:00 | MSFT | Stock | 370.7 | 370.7 | 367.85 | 368.35 | 135124.0 |
| 2023-12-11 09:30:00 | MSFT | Stock | 368.45 | 369.56 | 366.1 | 368.7138 | 4867684.0 |
| 2023-12-11 10:00:00 | MSFT | Stock | 368.72 | 369.2 | 368.06 | 368.74 | 1471087.0 |
| 2023-12-11 10:30:00 | MSFT | Stock | 368.7375 | 370.56 | 368.455 | 369.8 | 1364708.0 |
| 2023-12-11 11:00:00 | MSFT | Stock | 369.8 | 370.28 | 368.09 | 368.44 | 905687.0 |
| 2023-12-11 11:30:00 | MSFT | Stock | 368.4899 | 368.58 | 367.82 | 368.54 | 707193.0 |
| 2023-12-11 12:00:00 | MSFT | Stock | 368.52 | 369.05 | 368.03 | 368.52 | 674961.0 |
| 2023-12-11 12:30:00 | MSFT | Stock | 368.53 | 369.08 | 368.16 | 369.05 | 467847.0 |
> showing 50 of 101,428 rows — these rows as CSV