PREVIEW / stock_30min / 2024-08-21
file: by_date/stock_30min/2024/2024-08-21.parquet size: 2.0 MB rows: 97,428 symbols: 845
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-08-21 04:00:00 | AAPL | Stock | 225.89 | 226.89 | 225.89 | 226.74 | 3008.0 |
| 2024-08-21 04:30:00 | AAPL | Stock | 226.67 | 226.74 | 226.67 | 226.73 | 709.0 |
| 2024-08-21 05:00:00 | AAPL | Stock | 226.63 | 226.64 | 226.5 | 226.64 | 2211.0 |
| 2024-08-21 05:30:00 | AAPL | Stock | 226.58 | 226.69 | 226.54 | 226.58 | 1104.0 |
| 2024-08-21 06:00:00 | AAPL | Stock | 226.6 | 226.71 | 226.55 | 226.55 | 1013.0 |
| 2024-08-21 06:30:00 | AAPL | Stock | 226.7 | 227.01 | 226.65 | 227.01 | 5373.0 |
| 2024-08-21 07:00:00 | AAPL | Stock | 226.99 | 227.0 | 226.75 | 226.76 | 7465.0 |
| 2024-08-21 07:30:00 | AAPL | Stock | 226.75 | 226.92 | 226.72 | 226.92 | 3735.0 |
| 2024-08-21 08:00:00 | AAPL | Stock | 227.0 | 227.08 | 225.944 | 227.0 | 37068.0 |
| 2024-08-21 08:30:00 | AAPL | Stock | 227.0 | 227.0 | 226.71 | 226.84 | 14849.0 |
| 2024-08-21 09:00:00 | AAPL | Stock | 226.84 | 226.84 | 226.13 | 226.5 | 48253.0 |
| 2024-08-21 09:30:00 | AAPL | Stock | 226.51 | 227.07 | 225.91 | 227.06 | 2885484.0 |
| 2024-08-21 10:00:00 | AAPL | Stock | 227.07 | 227.67 | 226.66 | 227.225 | 2091272.0 |
| 2024-08-21 10:30:00 | AAPL | Stock | 227.23 | 227.98 | 225.87 | 226.28 | 2310593.0 |
| 2024-08-21 11:00:00 | AAPL | Stock | 226.26 | 226.98 | 225.95 | 226.491 | 1254456.0 |
| 2024-08-21 11:30:00 | AAPL | Stock | 226.4999 | 226.59 | 225.758 | 226.21 | 1132734.0 |
| 2024-08-21 12:00:00 | AAPL | Stock | 226.205 | 226.28 | 225.635 | 226.24 | 943940.0 |
| 2024-08-21 12:30:00 | AAPL | Stock | 226.25 | 226.504 | 226.07 | 226.42 | 781405.0 |
| 2024-08-21 13:00:00 | AAPL | Stock | 226.42 | 226.46 | 225.9201 | 226.0001 | 811240.0 |
| 2024-08-21 13:30:00 | AAPL | Stock | 226.01 | 226.24 | 225.83 | 226.15 | 847245.0 |
| 2024-08-21 14:00:00 | AAPL | Stock | 226.17 | 226.4574 | 225.86 | 226.45 | 966054.0 |
| 2024-08-21 14:30:00 | AAPL | Stock | 226.45 | 226.58 | 225.98 | 226.416 | 961963.0 |
| 2024-08-21 15:00:00 | AAPL | Stock | 226.41 | 226.48 | 225.3302 | 225.77 | 1149120.0 |
| 2024-08-21 15:30:00 | AAPL | Stock | 225.78 | 226.56 | 225.05 | 226.36 | 2926041.0 |
| 2024-08-21 16:00:00 | AAPL | Stock | 226.4 | 226.66 | 226.38 | 226.6093 | 5394976.0 |
| 2024-08-21 16:30:00 | AAPL | Stock | 226.58 | 226.73 | 226.4 | 226.64 | 15433.0 |
| 2024-08-21 17:00:00 | AAPL | Stock | 226.65 | 226.65 | 226.52 | 226.57 | 4958.0 |
| 2024-08-21 17:30:00 | AAPL | Stock | 226.6494 | 226.67 | 226.0933 | 226.6663 | 4263.0 |
| 2024-08-21 18:00:00 | AAPL | Stock | 226.69 | 226.75 | 226.57 | 226.7 | 4991.0 |
| 2024-08-21 18:30:00 | AAPL | Stock | 226.79 | 226.8492 | 226.6113 | 226.65 | 2911.0 |
| 2024-08-21 19:00:00 | AAPL | Stock | 226.74 | 226.79 | 226.65 | 226.65 | 7855.0 |
| 2024-08-21 19:30:00 | AAPL | Stock | 226.65 | 226.6892 | 226.59 | 226.59 | 12587.0 |
| 2024-08-21 04:00:00 | MSFT | Stock | 421.53 | 425.24 | 421.53 | 424.21 | 4371.0 |
| 2024-08-21 04:30:00 | MSFT | Stock | 424.4 | 424.68 | 424.4 | 424.68 | 690.0 |
| 2024-08-21 05:00:00 | MSFT | Stock | 424.4 | 425.03 | 424.4 | 425.03 | 655.0 |
| 2024-08-21 05:30:00 | MSFT | Stock | 424.82 | 426.21 | 424.82 | 426.0 | 4394.0 |
| 2024-08-21 06:00:00 | MSFT | Stock | 425.53 | 425.53 | 425.53 | 425.53 | 191.0 |
| 2024-08-21 06:30:00 | MSFT | Stock | 425.59 | 426.0 | 425.59 | 425.81 | 1000.0 |
| 2024-08-21 07:00:00 | MSFT | Stock | 425.72 | 425.91 | 425.68 | 425.81 | 1175.0 |
| 2024-08-21 07:30:00 | MSFT | Stock | 425.78 | 426.21 | 424.8 | 424.91 | 13817.0 |
| 2024-08-21 08:00:00 | MSFT | Stock | 425.8 | 425.9999 | 424.65 | 425.4 | 12646.0 |
| 2024-08-21 08:30:00 | MSFT | Stock | 425.55 | 425.75 | 425.35 | 425.6 | 5649.0 |
| 2024-08-21 09:00:00 | MSFT | Stock | 425.7 | 425.9 | 423.5063 | 424.0 | 25648.0 |
| 2024-08-21 09:30:00 | MSFT | Stock | 424.01 | 424.15 | 422.62 | 423.595 | 1007902.0 |
| 2024-08-21 10:00:00 | MSFT | Stock | 423.65 | 425.05 | 423.43 | 424.165 | 530544.0 |
| 2024-08-21 10:30:00 | MSFT | Stock | 424.1401 | 426.4 | 423.07 | 423.69 | 768042.0 |
| 2024-08-21 11:00:00 | MSFT | Stock | 423.64 | 424.71 | 422.9603 | 423.82 | 371058.0 |
| 2024-08-21 11:30:00 | MSFT | Stock | 423.805 | 423.805 | 421.96 | 422.33 | 418108.0 |
| 2024-08-21 12:00:00 | MSFT | Stock | 422.3 | 423.0865 | 421.72 | 423.06 | 296412.0 |
| 2024-08-21 12:30:00 | MSFT | Stock | 423.05 | 423.67 | 423.0 | 423.47 | 212554.0 |
> showing 50 of 97,428 rows — these rows as CSV