PREVIEW / stock_30min / 2024-12-23
file: by_date/stock_30min/2024/2024-12-23.parquet size: 2.2 MB rows: 108,368 symbols: 617
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-12-23 04:00:00 | AAPL | Stock | 255.55 | 255.97 | 255.01 | 255.59 | 22129.0 |
| 2024-12-23 04:30:00 | AAPL | Stock | 255.54 | 255.74 | 255.38 | 255.38 | 4939.0 |
| 2024-12-23 05:00:00 | AAPL | Stock | 255.55 | 255.61 | 255.3 | 255.4 | 5126.0 |
| 2024-12-23 05:30:00 | AAPL | Stock | 255.34 | 255.54 | 255.01 | 255.1 | 12927.0 |
| 2024-12-23 06:00:00 | AAPL | Stock | 255.09 | 255.09 | 254.81 | 254.81 | 15806.0 |
| 2024-12-23 06:30:00 | AAPL | Stock | 254.94 | 254.95 | 254.6 | 254.78 | 1893.0 |
| 2024-12-23 07:00:00 | AAPL | Stock | 254.79 | 255.43 | 254.71 | 255.43 | 20492.0 |
| 2024-12-23 07:30:00 | AAPL | Stock | 255.43 | 255.49 | 255.25 | 255.41 | 7333.0 |
| 2024-12-23 08:00:00 | AAPL | Stock | 254.93 | 256.76 | 253.854 | 255.35 | 69663.0 |
| 2024-12-23 08:30:00 | AAPL | Stock | 255.35 | 255.35 | 254.3701 | 254.88 | 78000.0 |
| 2024-12-23 09:00:00 | AAPL | Stock | 254.88 | 254.9776 | 254.49 | 254.77 | 100289.0 |
| 2024-12-23 09:30:00 | AAPL | Stock | 254.77 | 255.65 | 253.9 | 254.9686 | 4072887.0 |
| 2024-12-23 10:00:00 | AAPL | Stock | 254.98 | 255.04 | 253.45 | 254.06 | 2366733.0 |
| 2024-12-23 10:30:00 | AAPL | Stock | 254.05 | 254.3 | 253.46 | 253.62 | 1203967.0 |
| 2024-12-23 11:00:00 | AAPL | Stock | 253.6 | 255.07 | 253.56 | 254.83 | 1212707.0 |
| 2024-12-23 11:30:00 | AAPL | Stock | 254.8391 | 255.23 | 254.547 | 254.905 | 787513.0 |
| 2024-12-23 12:00:00 | AAPL | Stock | 254.9 | 255.15 | 254.37 | 254.43 | 1040088.0 |
| 2024-12-23 12:30:00 | AAPL | Stock | 254.43 | 254.755 | 254.185 | 254.21 | 1064740.0 |
| 2024-12-23 13:00:00 | AAPL | Stock | 254.2131 | 254.31 | 253.72 | 253.92 | 1104865.0 |
| 2024-12-23 13:30:00 | AAPL | Stock | 253.92 | 254.3 | 253.87 | 254.2238 | 1083476.0 |
| 2024-12-23 14:00:00 | AAPL | Stock | 254.22 | 254.46 | 254.035 | 254.295 | 840180.0 |
| 2024-12-23 14:30:00 | AAPL | Stock | 254.3 | 254.4 | 253.8989 | 253.93 | 949589.0 |
| 2024-12-23 15:00:00 | AAPL | Stock | 253.915 | 254.39 | 253.68 | 254.335 | 1031747.0 |
| 2024-12-23 15:30:00 | AAPL | Stock | 254.34 | 255.65 | 254.34 | 255.31 | 3493586.0 |
| 2024-12-23 16:00:00 | AAPL | Stock | 255.3 | 255.8 | 255.04 | 255.2666 | 8268051.0 |
| 2024-12-23 16:30:00 | AAPL | Stock | 255.2 | 255.27 | 255.03 | 255.12 | 1368095.0 |
| 2024-12-23 17:00:00 | AAPL | Stock | 255.0704 | 255.1 | 255.02 | 255.02 | 4351.0 |
| 2024-12-23 17:30:00 | AAPL | Stock | 255.05 | 255.2 | 255.01 | 255.12 | 10396.0 |
| 2024-12-23 18:00:00 | AAPL | Stock | 255.04 | 255.15 | 254.9798 | 255.15 | 6533.0 |
| 2024-12-23 18:30:00 | AAPL | Stock | 255.08 | 255.09 | 254.75 | 254.7685 | 3191.0 |
| 2024-12-23 19:00:00 | AAPL | Stock | 254.77 | 254.8 | 254.58 | 254.72 | 6769.0 |
| 2024-12-23 19:30:00 | AAPL | Stock | 254.7 | 254.95 | 254.64 | 254.95 | 6480.0 |
| 2024-12-23 04:00:00 | MSFT | Stock | 437.64 | 437.8 | 437.64 | 437.75 | 756.0 |
| 2024-12-23 04:30:00 | MSFT | Stock | 438.2 | 438.29 | 437.84 | 437.84 | 1227.0 |
| 2024-12-23 05:00:00 | MSFT | Stock | 437.77 | 437.77 | 437.27 | 437.3 | 700.0 |
| 2024-12-23 05:30:00 | MSFT | Stock | 437.05 | 437.05 | 436.88 | 437.0 | 1288.0 |
| 2024-12-23 06:00:00 | MSFT | Stock | 436.0 | 436.0 | 436.0 | 436.0 | 100.0 |
| 2024-12-23 06:30:00 | MSFT | Stock | 436.07 | 436.07 | 435.99 | 436.0 | 966.0 |
| 2024-12-23 07:00:00 | MSFT | Stock | 436.35 | 437.7 | 436.35 | 437.39 | 5647.0 |
| 2024-12-23 07:30:00 | MSFT | Stock | 436.75 | 437.17 | 436.75 | 437.0 | 3566.0 |
| 2024-12-23 08:00:00 | MSFT | Stock | 436.64 | 439.92 | 435.509 | 437.33 | 14648.0 |
| 2024-12-23 08:30:00 | MSFT | Stock | 437.05 | 437.05 | 436.0 | 436.14 | 14301.0 |
| 2024-12-23 09:00:00 | MSFT | Stock | 436.1 | 436.6 | 436.01 | 436.6 | 9642.0 |
| 2024-12-23 09:30:00 | MSFT | Stock | 436.74 | 437.65 | 434.6599 | 436.09 | 976309.0 |
| 2024-12-23 10:00:00 | MSFT | Stock | 436.09 | 436.42 | 433.5401 | 433.7 | 630083.0 |
| 2024-12-23 10:30:00 | MSFT | Stock | 433.78 | 434.6696 | 432.91 | 433.3 | 389567.0 |
| 2024-12-23 11:00:00 | MSFT | Stock | 433.245 | 434.5 | 433.12 | 433.7 | 426017.0 |
| 2024-12-23 11:30:00 | MSFT | Stock | 433.68 | 434.65 | 432.83 | 434.1299 | 459480.0 |
| 2024-12-23 12:00:00 | MSFT | Stock | 434.09 | 434.93 | 433.6 | 433.98 | 428307.0 |
| 2024-12-23 12:30:00 | MSFT | Stock | 434.04 | 434.87 | 433.88 | 434.26 | 292624.0 |
> showing 50 of 108,368 rows — these rows as CSV