PREVIEW / stock_30min / 2023-10-25
file: by_date/stock_30min/2023/2023-10-25.parquet size: 2.0 MB rows: 96,433 symbols: 1,351
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-10-25 04:00:00 | AAPL | Stock | 172.56 | 172.73 | 172.34 | 172.64 | 14924.0 |
| 2023-10-25 04:30:00 | AAPL | Stock | 172.63 | 172.65 | 172.35 | 172.59 | 7250.0 |
| 2023-10-25 05:00:00 | AAPL | Stock | 172.56 | 172.56 | 172.28 | 172.51 | 10223.0 |
| 2023-10-25 05:30:00 | AAPL | Stock | 172.52 | 172.62 | 172.5 | 172.54 | 5984.0 |
| 2023-10-25 06:00:00 | AAPL | Stock | 172.51 | 172.56 | 172.41 | 172.56 | 1221.0 |
| 2023-10-25 06:30:00 | AAPL | Stock | 172.68 | 172.79 | 172.66 | 172.79 | 1289.0 |
| 2023-10-25 07:00:00 | AAPL | Stock | 172.8 | 172.97 | 172.66 | 172.81 | 5699.0 |
| 2023-10-25 07:30:00 | AAPL | Stock | 172.85 | 172.85 | 172.51 | 172.51 | 4080.0 |
| 2023-10-25 08:00:00 | AAPL | Stock | 172.83 | 173.19 | 172.415 | 172.5 | 37724.0 |
| 2023-10-25 08:30:00 | AAPL | Stock | 172.55 | 172.605 | 172.02 | 172.05 | 40465.0 |
| 2023-10-25 09:00:00 | AAPL | Stock | 172.05 | 172.11 | 171.42 | 171.9 | 144946.0 |
| 2023-10-25 09:30:00 | AAPL | Stock | 171.88 | 172.01 | 170.95 | 171.27 | 4477079.0 |
| 2023-10-25 10:00:00 | AAPL | Stock | 171.28 | 172.24 | 170.83 | 172.13 | 4455541.0 |
| 2023-10-25 10:30:00 | AAPL | Stock | 172.13 | 172.96 | 171.88 | 172.145 | 3482690.0 |
| 2023-10-25 11:00:00 | AAPL | Stock | 172.145 | 173.06 | 172.13 | 172.445 | 3123021.0 |
| 2023-10-25 11:30:00 | AAPL | Stock | 172.445 | 172.6 | 171.715 | 171.74 | 1972648.0 |
| 2023-10-25 12:00:00 | AAPL | Stock | 171.74 | 171.975 | 171.54 | 171.765 | 1779637.0 |
| 2023-10-25 12:30:00 | AAPL | Stock | 171.76 | 172.0 | 171.33 | 171.92 | 2006942.0 |
| 2023-10-25 13:00:00 | AAPL | Stock | 171.92 | 172.05 | 171.06 | 171.145 | 2279601.0 |
| 2023-10-25 13:30:00 | AAPL | Stock | 171.14 | 171.21 | 170.77 | 171.125 | 2043300.0 |
| 2023-10-25 14:00:00 | AAPL | Stock | 171.12 | 171.6198 | 171.05 | 171.42 | 2116064.0 |
| 2023-10-25 14:30:00 | AAPL | Stock | 171.43 | 171.54 | 170.94 | 171.09 | 1530977.0 |
| 2023-10-25 15:00:00 | AAPL | Stock | 171.095 | 171.24 | 170.65 | 171.175 | 2352559.0 |
| 2023-10-25 15:30:00 | AAPL | Stock | 171.1778 | 171.43 | 170.86 | 171.09 | 5781390.0 |
| 2023-10-25 16:00:00 | AAPL | Stock | 171.09 | 171.61 | 170.87 | 171.2 | 7850011.0 |
| 2023-10-25 16:30:00 | AAPL | Stock | 171.27 | 171.27 | 170.5 | 170.5 | 179926.0 |
| 2023-10-25 17:00:00 | AAPL | Stock | 170.49 | 170.7787 | 170.31 | 170.5 | 29757.0 |
| 2023-10-25 17:30:00 | AAPL | Stock | 170.55 | 170.6 | 170.21 | 170.4 | 28078.0 |
| 2023-10-25 18:00:00 | AAPL | Stock | 170.48 | 170.57 | 169.3204 | 169.48 | 100620.0 |
| 2023-10-25 18:30:00 | AAPL | Stock | 169.48 | 169.88 | 169.42 | 169.76 | 39939.0 |
| 2023-10-25 19:00:00 | AAPL | Stock | 169.75 | 169.79 | 169.3 | 169.34 | 38369.0 |
| 2023-10-25 19:30:00 | AAPL | Stock | 169.34 | 169.8 | 169.3 | 169.3 | 30276.0 |
| 2023-10-25 04:00:00 | MSFT | Stock | 341.72 | 343.04 | 340.79 | 342.6 | 38449.0 |
| 2023-10-25 04:30:00 | MSFT | Stock | 342.6 | 342.95 | 342.35 | 342.42 | 10863.0 |
| 2023-10-25 05:00:00 | MSFT | Stock | 342.54 | 342.8 | 342.22 | 342.8 | 3697.0 |
| 2023-10-25 05:30:00 | MSFT | Stock | 342.89 | 342.92 | 342.15 | 342.65 | 7732.0 |
| 2023-10-25 06:00:00 | MSFT | Stock | 342.57 | 342.6 | 341.09 | 342.44 | 16656.0 |
| 2023-10-25 06:30:00 | MSFT | Stock | 342.42 | 343.6 | 342.42 | 343.33 | 22731.0 |
| 2023-10-25 07:00:00 | MSFT | Stock | 343.33 | 343.85 | 342.75 | 343.15 | 46511.0 |
| 2023-10-25 07:30:00 | MSFT | Stock | 343.3 | 343.5 | 342.48 | 343.4 | 46249.0 |
| 2023-10-25 08:00:00 | MSFT | Stock | 342.7 | 345.84 | 341.51 | 345.5 | 191075.0 |
| 2023-10-25 08:30:00 | MSFT | Stock | 345.49 | 347.3199 | 345.49 | 346.29 | 332486.0 |
| 2023-10-25 09:00:00 | MSFT | Stock | 346.11 | 347.0 | 343.71 | 345.02 | 384167.0 |
| 2023-10-25 09:30:00 | MSFT | Stock | 345.09 | 346.2 | 341.6 | 344.65 | 8042112.0 |
| 2023-10-25 10:00:00 | MSFT | Stock | 344.63 | 344.68 | 338.94 | 340.365 | 3498688.0 |
| 2023-10-25 10:30:00 | MSFT | Stock | 340.585 | 341.73 | 338.62 | 339.54 | 2909114.0 |
| 2023-10-25 11:00:00 | MSFT | Stock | 339.53 | 341.57 | 337.8273 | 338.6401 | 2564841.0 |
| 2023-10-25 11:30:00 | MSFT | Stock | 338.65 | 339.2425 | 337.62 | 338.07 | 2004739.0 |
| 2023-10-25 12:00:00 | MSFT | Stock | 338.095 | 340.16 | 338.02 | 339.62 | 1713281.0 |
| 2023-10-25 12:30:00 | MSFT | Stock | 339.6315 | 340.21 | 338.9 | 339.59 | 1280835.0 |
> showing 50 of 96,433 rows — these rows as CSV