PREVIEW / stock_30min / 2024-08-13
file: by_date/stock_30min/2024/2024-08-13.parquet size: 2.0 MB rows: 97,088 symbols: 861
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-13 04:00:00 | AAPL | Stock | 218.31 | 218.81 | 218.03 | 218.81 | 11033.0 |
| 2024-08-13 04:30:00 | AAPL | Stock | 218.83 | 218.83 | 218.54 | 218.54 | 1765.0 |
| 2024-08-13 05:00:00 | AAPL | Stock | 218.54 | 218.6 | 218.54 | 218.6 | 2100.0 |
| 2024-08-13 05:30:00 | AAPL | Stock | 218.6 | 218.7 | 218.56 | 218.66 | 3104.0 |
| 2024-08-13 06:00:00 | AAPL | Stock | 218.65 | 218.65 | 218.23 | 218.28 | 7693.0 |
| 2024-08-13 06:30:00 | AAPL | Stock | 218.21 | 218.28 | 217.56 | 217.89 | 8688.0 |
| 2024-08-13 07:00:00 | AAPL | Stock | 217.92 | 218.3 | 217.85 | 218.3 | 9700.0 |
| 2024-08-13 07:30:00 | AAPL | Stock | 218.28 | 218.32 | 218.2 | 218.24 | 8640.0 |
| 2024-08-13 08:00:00 | AAPL | Stock | 217.97 | 219.0 | 217.79 | 218.4 | 58269.0 |
| 2024-08-13 08:30:00 | AAPL | Stock | 218.52 | 219.01 | 218.1247 | 218.5009 | 76813.0 |
| 2024-08-13 09:00:00 | AAPL | Stock | 218.58 | 219.2 | 218.15 | 219.04 | 84682.0 |
| 2024-08-13 09:30:00 | AAPL | Stock | 219.06 | 221.47 | 219.01 | 221.13 | 5539301.0 |
| 2024-08-13 10:00:00 | AAPL | Stock | 221.13 | 221.71 | 220.29 | 221.0 | 2302639.0 |
| 2024-08-13 10:30:00 | AAPL | Stock | 220.99 | 221.0701 | 220.2606 | 220.97 | 1823372.0 |
| 2024-08-13 11:00:00 | AAPL | Stock | 220.98 | 221.5 | 220.9124 | 221.055 | 1370036.0 |
| 2024-08-13 11:30:00 | AAPL | Stock | 221.05 | 221.5987 | 220.89 | 221.1203 | 1238948.0 |
| 2024-08-13 12:00:00 | AAPL | Stock | 221.1 | 221.4399 | 220.92 | 221.11 | 1035023.0 |
| 2024-08-13 12:30:00 | AAPL | Stock | 221.09 | 221.59 | 220.96 | 221.585 | 1095544.0 |
| 2024-08-13 13:00:00 | AAPL | Stock | 221.57 | 221.8 | 221.4 | 221.69 | 1021440.0 |
| 2024-08-13 13:30:00 | AAPL | Stock | 221.69 | 221.89 | 220.56 | 220.93 | 1356618.0 |
| 2024-08-13 14:00:00 | AAPL | Stock | 220.93 | 221.39 | 220.71 | 221.218 | 1031830.0 |
| 2024-08-13 14:30:00 | AAPL | Stock | 221.2461 | 221.4849 | 221.19 | 221.23 | 777880.0 |
| 2024-08-13 15:00:00 | AAPL | Stock | 221.23 | 221.31 | 220.54 | 220.67 | 1132920.0 |
| 2024-08-13 15:30:00 | AAPL | Stock | 220.67 | 221.28 | 220.42 | 221.27 | 3029556.0 |
| 2024-08-13 16:00:00 | AAPL | Stock | 221.275 | 221.35 | 220.01 | 220.64 | 7094300.0 |
| 2024-08-13 16:30:00 | AAPL | Stock | 220.62 | 221.27 | 220.03 | 220.44 | 1128656.0 |
| 2024-08-13 17:00:00 | AAPL | Stock | 220.45 | 220.7 | 220.41 | 220.55 | 15185.0 |
| 2024-08-13 17:30:00 | AAPL | Stock | 220.5 | 220.7385 | 220.5 | 220.68 | 6543.0 |
| 2024-08-13 18:00:00 | AAPL | Stock | 220.69 | 220.88 | 220.5 | 220.5869 | 14836.0 |
| 2024-08-13 18:30:00 | AAPL | Stock | 220.65 | 220.72 | 220.5304 | 220.65 | 2856.0 |
| 2024-08-13 19:00:00 | AAPL | Stock | 220.6 | 220.75 | 220.49 | 220.57 | 13413.0 |
| 2024-08-13 19:30:00 | AAPL | Stock | 220.62 | 220.7 | 220.55 | 220.7 | 20343.0 |
| 2024-08-13 04:00:00 | MSFT | Stock | 408.5 | 409.4 | 407.49 | 409.02 | 5277.0 |
| 2024-08-13 04:30:00 | MSFT | Stock | 409.13 | 409.25 | 408.98 | 409.25 | 1945.0 |
| 2024-08-13 05:00:00 | MSFT | Stock | 409.17 | 409.24 | 409.01 | 409.15 | 897.0 |
| 2024-08-13 05:30:00 | MSFT | Stock | 409.31 | 409.5 | 409.31 | 409.5 | 1171.0 |
| 2024-08-13 06:00:00 | MSFT | Stock | 409.0 | 409.13 | 407.5 | 407.5 | 1785.0 |
| 2024-08-13 06:30:00 | MSFT | Stock | 407.12 | 407.65 | 406.81 | 407.5 | 7567.0 |
| 2024-08-13 07:00:00 | MSFT | Stock | 407.31 | 408.2 | 407.3 | 407.99 | 3661.0 |
| 2024-08-13 07:30:00 | MSFT | Stock | 407.96 | 408.2 | 407.76 | 408.03 | 2661.0 |
| 2024-08-13 08:00:00 | MSFT | Stock | 407.6 | 409.25 | 406.51 | 408.65 | 21686.0 |
| 2024-08-13 08:30:00 | MSFT | Stock | 408.76 | 410.241 | 408.76 | 410.11 | 25222.0 |
| 2024-08-13 09:00:00 | MSFT | Stock | 410.08 | 410.2 | 409.02 | 409.58 | 23507.0 |
| 2024-08-13 09:30:00 | MSFT | Stock | 409.59 | 412.88 | 409.57 | 411.52 | 1241426.0 |
| 2024-08-13 10:00:00 | MSFT | Stock | 411.56 | 411.83 | 410.17 | 410.6 | 593230.0 |
| 2024-08-13 10:30:00 | MSFT | Stock | 410.59 | 412.295 | 409.93 | 412.12 | 483113.0 |
| 2024-08-13 11:00:00 | MSFT | Stock | 412.11 | 413.77 | 412.06 | 413.24 | 626920.0 |
| 2024-08-13 11:30:00 | MSFT | Stock | 413.16 | 413.48 | 412.58 | 413.22 | 340624.0 |
| 2024-08-13 12:00:00 | MSFT | Stock | 413.22 | 413.9 | 412.88 | 413.42 | 339054.0 |
| 2024-08-13 12:30:00 | MSFT | Stock | 413.36 | 414.95 | 413.13 | 414.8 | 408556.0 |
> showing 50 of 97,088 rows — these rows as CSV