PREVIEW / stock_30min / 2024-10-24
file: by_date/stock_30min/2024/2024-10-24.parquet size: 2.1 MB rows: 99,650 symbols: 723
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-10-24 04:00:00 | AAPL | Stock | 230.66 | 231.48 | 230.66 | 231.38 | 11362.0 |
| 2024-10-24 04:30:00 | AAPL | Stock | 231.38 | 231.4 | 231.2 | 231.2 | 6631.0 |
| 2024-10-24 05:00:00 | AAPL | Stock | 231.28 | 231.38 | 231.21 | 231.38 | 6053.0 |
| 2024-10-24 05:30:00 | AAPL | Stock | 231.32 | 231.34 | 231.28 | 231.34 | 679.0 |
| 2024-10-24 06:00:00 | AAPL | Stock | 231.36 | 231.38 | 231.36 | 231.38 | 1340.0 |
| 2024-10-24 06:30:00 | AAPL | Stock | 231.44 | 231.45 | 231.39 | 231.4 | 2777.0 |
| 2024-10-24 07:00:00 | AAPL | Stock | 231.4 | 231.46 | 231.07 | 231.18 | 15430.0 |
| 2024-10-24 07:30:00 | AAPL | Stock | 231.19 | 231.33 | 231.05 | 231.33 | 4690.0 |
| 2024-10-24 08:00:00 | AAPL | Stock | 231.27 | 231.61 | 230.52 | 231.2 | 60357.0 |
| 2024-10-24 08:30:00 | AAPL | Stock | 231.2 | 231.33 | 230.45 | 230.5 | 59032.0 |
| 2024-10-24 09:00:00 | AAPL | Stock | 230.442 | 230.74 | 229.56 | 229.9699 | 108326.0 |
| 2024-10-24 09:30:00 | AAPL | Stock | 229.98 | 230.4 | 228.41 | 229.82 | 3967310.0 |
| 2024-10-24 10:00:00 | AAPL | Stock | 229.83 | 230.24 | 229.55 | 229.815 | 1602217.0 |
| 2024-10-24 10:30:00 | AAPL | Stock | 229.83 | 230.38 | 229.24 | 229.25 | 1304551.0 |
| 2024-10-24 11:00:00 | AAPL | Stock | 229.25 | 230.2 | 229.23 | 229.84 | 1061443.0 |
| 2024-10-24 11:30:00 | AAPL | Stock | 229.82 | 230.04 | 228.8806 | 229.58 | 1321810.0 |
| 2024-10-24 12:00:00 | AAPL | Stock | 229.59 | 229.72 | 228.67 | 229.5194 | 1072559.0 |
| 2024-10-24 12:30:00 | AAPL | Stock | 229.52 | 230.345 | 229.52 | 230.308 | 778319.0 |
| 2024-10-24 13:00:00 | AAPL | Stock | 230.31 | 230.82 | 230.11 | 230.27 | 981786.0 |
| 2024-10-24 13:30:00 | AAPL | Stock | 230.27 | 230.54 | 230.185 | 230.255 | 651510.0 |
| 2024-10-24 14:00:00 | AAPL | Stock | 230.26 | 230.54 | 230.04 | 230.42 | 675419.0 |
| 2024-10-24 14:30:00 | AAPL | Stock | 230.43 | 230.5676 | 230.26 | 230.46 | 512185.0 |
| 2024-10-24 15:00:00 | AAPL | Stock | 230.45 | 230.81 | 230.12 | 230.53 | 879868.0 |
| 2024-10-24 15:30:00 | AAPL | Stock | 230.535 | 230.81 | 230.22 | 230.57 | 1823615.0 |
| 2024-10-24 16:00:00 | AAPL | Stock | 230.57 | 230.77 | 230.5222 | 230.66 | 5563402.0 |
| 2024-10-24 16:30:00 | AAPL | Stock | 230.66 | 230.66 | 230.43 | 230.48 | 85424.0 |
| 2024-10-24 17:00:00 | AAPL | Stock | 230.43 | 230.46 | 230.32 | 230.32 | 10971.0 |
| 2024-10-24 17:30:00 | AAPL | Stock | 230.32 | 230.4294 | 230.01 | 230.39 | 7648.0 |
| 2024-10-24 18:00:00 | AAPL | Stock | 230.42 | 230.48 | 230.15 | 230.25 | 4072.0 |
| 2024-10-24 18:30:00 | AAPL | Stock | 230.18 | 230.39 | 230.18 | 230.2603 | 3540.0 |
| 2024-10-24 19:00:00 | AAPL | Stock | 230.27 | 230.33 | 230.1884 | 230.1884 | 3781.0 |
| 2024-10-24 19:30:00 | AAPL | Stock | 230.18 | 230.3229 | 229.47 | 229.51 | 15639.0 |
| 2024-10-24 04:00:00 | MSFT | Stock | 426.65 | 426.65 | 426.12 | 426.12 | 2788.0 |
| 2024-10-24 04:30:00 | MSFT | Stock | 426.5 | 426.81 | 426.0 | 426.0 | 2014.0 |
| 2024-10-24 05:00:00 | MSFT | Stock | 426.5 | 426.5 | 426.4 | 426.4 | 950.0 |
| 2024-10-24 05:30:00 | MSFT | Stock | 426.57 | 426.71 | 426.57 | 426.71 | 1019.0 |
| 2024-10-24 06:00:00 | MSFT | Stock | 426.71 | 426.71 | 426.71 | 426.71 | 177.0 |
| 2024-10-24 06:30:00 | MSFT | Stock | 426.85 | 426.85 | 426.85 | 426.85 | 300.0 |
| 2024-10-24 07:00:00 | MSFT | Stock | 426.43 | 426.62 | 426.3 | 426.5 | 3505.0 |
| 2024-10-24 07:30:00 | MSFT | Stock | 426.3 | 426.5 | 426.25 | 426.25 | 2338.0 |
| 2024-10-24 08:00:00 | MSFT | Stock | 426.55 | 426.62 | 425.12 | 426.31 | 20977.0 |
| 2024-10-24 08:30:00 | MSFT | Stock | 426.25 | 426.69 | 426.05 | 426.05 | 11894.0 |
| 2024-10-24 09:00:00 | MSFT | Stock | 426.0353 | 427.21 | 424.82 | 425.21 | 53088.0 |
| 2024-10-24 09:30:00 | MSFT | Stock | 425.325 | 425.9782 | 423.2 | 424.685 | 1144880.0 |
| 2024-10-24 10:00:00 | MSFT | Stock | 424.72 | 425.38 | 423.7101 | 424.17 | 604208.0 |
| 2024-10-24 10:30:00 | MSFT | Stock | 424.12 | 425.18 | 423.91 | 424.08 | 396835.0 |
| 2024-10-24 11:00:00 | MSFT | Stock | 424.095 | 425.045 | 423.7106 | 424.45 | 295933.0 |
| 2024-10-24 11:30:00 | MSFT | Stock | 424.43 | 424.83 | 422.54 | 423.76 | 320328.0 |
| 2024-10-24 12:00:00 | MSFT | Stock | 423.77 | 423.91 | 422.4 | 423.64 | 272934.0 |
| 2024-10-24 12:30:00 | MSFT | Stock | 423.63 | 424.41 | 423.63 | 424.395 | 220782.0 |
> showing 50 of 99,650 rows — these rows as CSV