PREVIEW / stock_30min / 2024-06-28
file: by_date/stock_30min/2024/2024-06-28.parquet size: 2.0 MB rows: 98,371 symbols: 908
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-06-28 04:00:00 | AAPL | Stock | 214.12 | 214.93 | 214.12 | 214.61 | 6169.0 |
| 2024-06-28 04:30:00 | AAPL | Stock | 214.71 | 214.71 | 214.69 | 214.69 | 543.0 |
| 2024-06-28 05:00:00 | AAPL | Stock | 214.68 | 215.63 | 214.68 | 215.5 | 6400.0 |
| 2024-06-28 05:30:00 | AAPL | Stock | 215.4 | 216.37 | 215.25 | 216.32 | 41638.0 |
| 2024-06-28 06:00:00 | AAPL | Stock | 216.3 | 216.3 | 215.96 | 216.07 | 10427.0 |
| 2024-06-28 06:30:00 | AAPL | Stock | 216.07 | 216.3 | 215.97 | 216.15 | 9168.0 |
| 2024-06-28 07:00:00 | AAPL | Stock | 216.11 | 216.11 | 215.5 | 215.82 | 38723.0 |
| 2024-06-28 07:30:00 | AAPL | Stock | 215.79 | 216.259 | 215.79 | 215.92 | 29706.0 |
| 2024-06-28 08:00:00 | AAPL | Stock | 215.8 | 216.26 | 214.69 | 215.92 | 193371.0 |
| 2024-06-28 08:30:00 | AAPL | Stock | 215.72 | 215.98 | 215.5203 | 215.839 | 103533.0 |
| 2024-06-28 09:00:00 | AAPL | Stock | 215.8 | 216.0873 | 214.92 | 215.79 | 233369.0 |
| 2024-06-28 09:30:00 | AAPL | Stock | 215.79 | 216.07 | 213.5703 | 214.325 | 6404437.0 |
| 2024-06-28 10:00:00 | AAPL | Stock | 214.34 | 215.51 | 214.24 | 214.64 | 4495232.0 |
| 2024-06-28 10:30:00 | AAPL | Stock | 214.63 | 215.3 | 213.93 | 214.37 | 2496977.0 |
| 2024-06-28 11:00:00 | AAPL | Stock | 214.36 | 214.73 | 213.77 | 214.34 | 2633656.0 |
| 2024-06-28 11:30:00 | AAPL | Stock | 214.33 | 214.71 | 213.95 | 214.19 | 2303535.0 |
| 2024-06-28 12:00:00 | AAPL | Stock | 214.185 | 214.37 | 213.52 | 213.84 | 2304125.0 |
| 2024-06-28 12:30:00 | AAPL | Stock | 213.835 | 213.96 | 213.27 | 213.955 | 2143595.0 |
| 2024-06-28 13:00:00 | AAPL | Stock | 213.95 | 214.53 | 213.79 | 213.8301 | 2026669.0 |
| 2024-06-28 13:30:00 | AAPL | Stock | 213.85 | 214.04 | 213.62 | 213.92 | 1172963.0 |
| 2024-06-28 14:00:00 | AAPL | Stock | 213.92 | 214.08 | 213.13 | 213.21 | 1827884.0 |
| 2024-06-28 14:30:00 | AAPL | Stock | 213.21 | 213.485 | 213.08 | 213.145 | 1733801.0 |
| 2024-06-28 15:00:00 | AAPL | Stock | 213.15 | 213.35 | 212.7 | 213.055 | 2089254.0 |
| 2024-06-28 15:30:00 | AAPL | Stock | 213.06 | 213.61 | 210.3 | 210.61 | 11182968.0 |
| 2024-06-28 16:00:00 | AAPL | Stock | 210.63 | 211.38 | 210.55 | 211.38 | 23750401.0 |
| 2024-06-28 16:30:00 | AAPL | Stock | 211.37 | 211.45 | 210.62 | 211.23 | 1539475.0 |
| 2024-06-28 17:00:00 | AAPL | Stock | 211.2107 | 211.3524 | 210.62 | 211.2836 | 109850.0 |
| 2024-06-28 17:30:00 | AAPL | Stock | 211.1231 | 211.2899 | 211.1 | 211.18 | 9321.0 |
| 2024-06-28 18:00:00 | AAPL | Stock | 211.2 | 211.2 | 211.1319 | 211.1349 | 4467.0 |
| 2024-06-28 18:30:00 | AAPL | Stock | 211.23 | 211.23 | 211.1301 | 211.19 | 4777.0 |
| 2024-06-28 19:00:00 | AAPL | Stock | 211.19 | 211.21 | 211.0996 | 211.21 | 14993.0 |
| 2024-06-28 19:30:00 | AAPL | Stock | 211.21 | 211.7 | 211.15 | 211.66 | 25946.0 |
| 2024-06-28 04:00:00 | MSFT | Stock | 453.7 | 453.7 | 453.7 | 453.7 | 884.0 |
| 2024-06-28 05:00:00 | MSFT | Stock | 454.34 | 454.34 | 454.33 | 454.33 | 225.0 |
| 2024-06-28 05:30:00 | MSFT | Stock | 454.78 | 455.0 | 454.77 | 454.95 | 1020.0 |
| 2024-06-28 06:00:00 | MSFT | Stock | 454.47 | 454.47 | 454.47 | 454.47 | 200.0 |
| 2024-06-28 06:30:00 | MSFT | Stock | 454.36 | 454.36 | 454.25 | 454.3 | 422.0 |
| 2024-06-28 07:00:00 | MSFT | Stock | 454.26 | 454.33 | 453.97 | 453.97 | 2213.0 |
| 2024-06-28 07:30:00 | MSFT | Stock | 454.0 | 454.17 | 454.0 | 454.17 | 600.0 |
| 2024-06-28 08:00:00 | MSFT | Stock | 454.38 | 454.9 | 453.37 | 453.78 | 17583.0 |
| 2024-06-28 08:30:00 | MSFT | Stock | 453.5 | 454.1 | 452.0 | 452.28 | 26045.0 |
| 2024-06-28 09:00:00 | MSFT | Stock | 452.17 | 453.53 | 452.04 | 453.19 | 34221.0 |
| 2024-06-28 09:30:00 | MSFT | Stock | 453.1 | 453.9 | 451.605 | 453.88 | 1139928.0 |
| 2024-06-28 10:00:00 | MSFT | Stock | 453.9 | 455.38 | 453.75 | 454.1901 | 680264.0 |
| 2024-06-28 10:30:00 | MSFT | Stock | 454.2042 | 455.16 | 453.35 | 454.055 | 721910.0 |
| 2024-06-28 11:00:00 | MSFT | Stock | 454.01 | 454.11 | 452.5 | 452.97 | 602504.0 |
| 2024-06-28 11:30:00 | MSFT | Stock | 452.95 | 454.06 | 452.88 | 453.49 | 389045.0 |
| 2024-06-28 12:00:00 | MSFT | Stock | 453.48 | 453.6999 | 452.17 | 452.84 | 521702.0 |
| 2024-06-28 12:30:00 | MSFT | Stock | 452.82 | 453.65 | 452.14 | 453.56 | 416926.0 |
| 2024-06-28 13:00:00 | MSFT | Stock | 453.54 | 454.19 | 453.185 | 453.5 | 290104.0 |
> showing 50 of 98,371 rows — these rows as CSV