PREVIEW / stock_30min / 2024-09-05
file: by_date/stock_30min/2024/2024-09-05.parquet size: 2.0 MB rows: 95,863 symbols: 841
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-05 04:00:00 | AAPL | Stock | 220.2 | 220.5 | 220.12 | 220.34 | 7605.0 |
| 2024-09-05 04:30:00 | AAPL | Stock | 220.33 | 220.49 | 220.13 | 220.49 | 2311.0 |
| 2024-09-05 05:00:00 | AAPL | Stock | 220.44 | 220.44 | 219.9 | 219.91 | 4205.0 |
| 2024-09-05 05:30:00 | AAPL | Stock | 219.89 | 220.18 | 219.89 | 220.1 | 1460.0 |
| 2024-09-05 06:00:00 | AAPL | Stock | 220.17 | 220.2 | 219.95 | 220.03 | 5144.0 |
| 2024-09-05 06:30:00 | AAPL | Stock | 220.0 | 221.37 | 220.0 | 221.2 | 23600.0 |
| 2024-09-05 07:00:00 | AAPL | Stock | 221.1 | 221.39 | 220.63 | 220.63 | 14440.0 |
| 2024-09-05 07:30:00 | AAPL | Stock | 220.8 | 221.14 | 220.39 | 220.44 | 9505.0 |
| 2024-09-05 08:00:00 | AAPL | Stock | 221.2 | 221.39 | 219.15 | 219.75 | 84727.0 |
| 2024-09-05 08:30:00 | AAPL | Stock | 219.86 | 220.8 | 219.6144 | 220.36 | 81405.0 |
| 2024-09-05 09:00:00 | AAPL | Stock | 220.29 | 221.76 | 220.2595 | 221.68 | 229180.0 |
| 2024-09-05 09:30:00 | AAPL | Stock | 221.73 | 224.92 | 221.52 | 224.71 | 5113613.0 |
| 2024-09-05 10:00:00 | AAPL | Stock | 224.71 | 225.48 | 223.88 | 225.08 | 2676056.0 |
| 2024-09-05 10:30:00 | AAPL | Stock | 225.09 | 225.39 | 223.63 | 223.7 | 1598265.0 |
| 2024-09-05 11:00:00 | AAPL | Stock | 223.7 | 223.87 | 222.38 | 222.48 | 1801506.0 |
| 2024-09-05 11:30:00 | AAPL | Stock | 222.46 | 222.66 | 221.88 | 221.97 | 1249743.0 |
| 2024-09-05 12:00:00 | AAPL | Stock | 221.98 | 222.8196 | 221.9562 | 222.7952 | 934618.0 |
| 2024-09-05 12:30:00 | AAPL | Stock | 222.79 | 223.15 | 222.625 | 222.825 | 959451.0 |
| 2024-09-05 13:00:00 | AAPL | Stock | 222.835 | 222.985 | 222.34 | 222.39 | 781037.0 |
| 2024-09-05 13:30:00 | AAPL | Stock | 222.3977 | 223.74 | 222.3742 | 223.61 | 1095333.0 |
| 2024-09-05 14:00:00 | AAPL | Stock | 223.63 | 223.75 | 223.17 | 223.3305 | 969545.0 |
| 2024-09-05 14:30:00 | AAPL | Stock | 223.34 | 223.9 | 223.2805 | 223.32 | 836755.0 |
| 2024-09-05 15:00:00 | AAPL | Stock | 223.33 | 223.3932 | 222.11 | 222.83 | 994668.0 |
| 2024-09-05 15:30:00 | AAPL | Stock | 222.82 | 223.4 | 221.8101 | 222.38 | 2559622.0 |
| 2024-09-05 16:00:00 | AAPL | Stock | 222.38 | 222.79 | 221.62 | 222.25 | 3844669.0 |
| 2024-09-05 16:30:00 | AAPL | Stock | 222.48 | 222.66 | 222.0405 | 222.37 | 35128.0 |
| 2024-09-05 17:00:00 | AAPL | Stock | 222.3106 | 222.5 | 222.27 | 222.38 | 23604.0 |
| 2024-09-05 17:30:00 | AAPL | Stock | 222.2777 | 222.35 | 222.1931 | 222.35 | 5631.0 |
| 2024-09-05 18:00:00 | AAPL | Stock | 222.35 | 222.49 | 222.1627 | 222.1627 | 7300.0 |
| 2024-09-05 18:30:00 | AAPL | Stock | 222.24 | 222.49 | 222.032 | 222.3219 | 13380.0 |
| 2024-09-05 19:00:00 | AAPL | Stock | 222.41 | 222.41 | 222.1504 | 222.3196 | 4709.0 |
| 2024-09-05 19:30:00 | AAPL | Stock | 222.3 | 222.4 | 222.15 | 222.21 | 18340.0 |
| 2024-09-05 04:00:00 | MSFT | Stock | 409.19 | 409.5 | 409.0 | 409.0 | 1051.0 |
| 2024-09-05 04:30:00 | MSFT | Stock | 408.54 | 408.6 | 408.18 | 408.18 | 1231.0 |
| 2024-09-05 05:00:00 | MSFT | Stock | 408.0 | 408.0 | 407.29 | 407.29 | 762.0 |
| 2024-09-05 05:30:00 | MSFT | Stock | 407.28 | 407.5 | 406.49 | 407.3 | 1546.0 |
| 2024-09-05 06:00:00 | MSFT | Stock | 407.8 | 407.8 | 407.35 | 407.4 | 722.0 |
| 2024-09-05 06:30:00 | MSFT | Stock | 407.27 | 407.9 | 407.26 | 407.9 | 2025.0 |
| 2024-09-05 07:00:00 | MSFT | Stock | 408.0 | 408.1 | 407.2 | 407.2 | 2229.0 |
| 2024-09-05 07:30:00 | MSFT | Stock | 407.5 | 407.65 | 406.6 | 406.67 | 2663.0 |
| 2024-09-05 08:00:00 | MSFT | Stock | 408.0 | 408.276 | 405.72 | 406.1 | 23632.0 |
| 2024-09-05 08:30:00 | MSFT | Stock | 406.1 | 408.3 | 406.1 | 406.9 | 5754.0 |
| 2024-09-05 09:00:00 | MSFT | Stock | 406.9 | 407.9 | 405.25 | 407.58 | 19629.0 |
| 2024-09-05 09:30:00 | MSFT | Stock | 407.62 | 413.0883 | 407.62 | 411.45 | 1155998.0 |
| 2024-09-05 10:00:00 | MSFT | Stock | 411.43 | 413.09 | 410.08 | 411.99 | 720601.0 |
| 2024-09-05 10:30:00 | MSFT | Stock | 412.04 | 413.1 | 409.31 | 409.43 | 553512.0 |
| 2024-09-05 11:00:00 | MSFT | Stock | 409.4412 | 410.06 | 407.44 | 407.63 | 533187.0 |
| 2024-09-05 11:30:00 | MSFT | Stock | 407.6277 | 407.95 | 406.84 | 407.05 | 376494.0 |
| 2024-09-05 12:00:00 | MSFT | Stock | 406.98 | 407.75 | 406.13 | 407.45 | 396258.0 |
| 2024-09-05 12:30:00 | MSFT | Stock | 407.465 | 407.69 | 406.8401 | 407.05 | 272416.0 |
> showing 50 of 95,863 rows — these rows as CSV