PREVIEW / stock_30min / 2024-08-02
file: by_date/stock_30min/2024/2024-08-02.parquet size: 2.1 MB rows: 102,703 symbols: 880
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-02 04:00:00 | AAPL | Stock | 217.9 | 218.82 | 216.55 | 217.75 | 33596.0 |
| 2024-08-02 04:30:00 | AAPL | Stock | 217.63 | 218.26 | 217.48 | 218.15 | 6496.0 |
| 2024-08-02 05:00:00 | AAPL | Stock | 218.0 | 218.01 | 217.6 | 217.69 | 12670.0 |
| 2024-08-02 05:30:00 | AAPL | Stock | 217.75 | 218.12 | 217.68 | 218.01 | 10252.0 |
| 2024-08-02 06:00:00 | AAPL | Stock | 218.05 | 220.57 | 217.51 | 220.0 | 20161.0 |
| 2024-08-02 06:30:00 | AAPL | Stock | 219.79 | 220.47 | 218.75 | 220.47 | 29306.0 |
| 2024-08-02 07:00:00 | AAPL | Stock | 220.1 | 220.48 | 219.26 | 219.3 | 101536.0 |
| 2024-08-02 07:30:00 | AAPL | Stock | 219.45 | 219.5 | 217.28 | 217.5 | 80000.0 |
| 2024-08-02 08:00:00 | AAPL | Stock | 220.02 | 220.5 | 215.85 | 217.21 | 240838.0 |
| 2024-08-02 08:30:00 | AAPL | Stock | 217.39 | 218.5 | 214.0 | 215.3 | 629947.0 |
| 2024-08-02 09:00:00 | AAPL | Stock | 215.36 | 219.39 | 213.7 | 219.05 | 746573.0 |
| 2024-08-02 09:30:00 | AAPL | Stock | 219.15 | 224.43 | 217.71 | 223.24 | 13466246.0 |
| 2024-08-02 10:00:00 | AAPL | Stock | 223.205 | 224.19 | 220.67 | 222.655 | 6503999.0 |
| 2024-08-02 10:30:00 | AAPL | Stock | 222.64 | 224.3799 | 222.3557 | 222.4 | 5686747.0 |
| 2024-08-02 11:00:00 | AAPL | Stock | 222.41 | 223.67 | 221.76 | 222.82 | 4202431.0 |
| 2024-08-02 11:30:00 | AAPL | Stock | 222.81 | 223.45 | 221.4101 | 223.205 | 3311747.0 |
| 2024-08-02 12:00:00 | AAPL | Stock | 223.205 | 224.72 | 222.73 | 224.62 | 3380134.0 |
| 2024-08-02 12:30:00 | AAPL | Stock | 224.6 | 225.6 | 223.45 | 224.235 | 3539988.0 |
| 2024-08-02 13:00:00 | AAPL | Stock | 224.215 | 225.28 | 224.14 | 224.64 | 2538143.0 |
| 2024-08-02 13:30:00 | AAPL | Stock | 224.63 | 225.005 | 223.3 | 224.19 | 2692079.0 |
| 2024-08-02 14:00:00 | AAPL | Stock | 224.2 | 224.23 | 221.91 | 223.435 | 2929226.0 |
| 2024-08-02 14:30:00 | AAPL | Stock | 223.42 | 224.1 | 222.63 | 222.7 | 2207056.0 |
| 2024-08-02 15:00:00 | AAPL | Stock | 222.7 | 223.37 | 222.11 | 222.62 | 2848305.0 |
| 2024-08-02 15:30:00 | AAPL | Stock | 222.63 | 222.9883 | 219.05 | 219.8 | 9167862.0 |
| 2024-08-02 16:00:00 | AAPL | Stock | 219.86 | 220.25 | 219.41 | 219.94 | 8602362.0 |
| 2024-08-02 16:30:00 | AAPL | Stock | 219.94 | 220.0 | 219.77 | 219.82 | 92598.0 |
| 2024-08-02 17:00:00 | AAPL | Stock | 219.82 | 220.11 | 219.7714 | 219.8942 | 340331.0 |
| 2024-08-02 17:30:00 | AAPL | Stock | 219.8988 | 219.9 | 219.2513 | 219.34 | 29203.0 |
| 2024-08-02 18:00:00 | AAPL | Stock | 219.5493 | 219.86 | 219.35 | 219.41 | 6983921.0 |
| 2024-08-02 18:30:00 | AAPL | Stock | 219.42 | 219.54 | 219.36 | 219.5 | 14004.0 |
| 2024-08-02 19:00:00 | AAPL | Stock | 219.53 | 219.53 | 219.15 | 219.292 | 15292.0 |
| 2024-08-02 19:30:00 | AAPL | Stock | 219.22 | 219.3 | 219.19 | 219.25 | 18890.0 |
| 2024-08-02 04:00:00 | MSFT | Stock | 411.7 | 413.0 | 410.95 | 411.8 | 5178.0 |
| 2024-08-02 04:30:00 | MSFT | Stock | 411.55 | 412.0 | 411.23 | 412.0 | 1986.0 |
| 2024-08-02 05:00:00 | MSFT | Stock | 411.61 | 411.98 | 409.9 | 409.9 | 2541.0 |
| 2024-08-02 05:30:00 | MSFT | Stock | 410.0 | 410.0 | 409.0 | 409.45 | 12099.0 |
| 2024-08-02 06:00:00 | MSFT | Stock | 409.0 | 410.16 | 408.61 | 410.16 | 6354.0 |
| 2024-08-02 06:30:00 | MSFT | Stock | 410.03 | 410.5 | 409.13 | 409.13 | 4977.0 |
| 2024-08-02 07:00:00 | MSFT | Stock | 409.72 | 410.0 | 408.15 | 408.27 | 11362.0 |
| 2024-08-02 07:30:00 | MSFT | Stock | 408.45 | 409.42 | 408.27 | 408.5 | 13096.0 |
| 2024-08-02 08:00:00 | MSFT | Stock | 409.99 | 418.152 | 408.1001 | 409.0 | 36175.0 |
| 2024-08-02 08:30:00 | MSFT | Stock | 409.4 | 409.96 | 406.05 | 409.22 | 86457.0 |
| 2024-08-02 09:00:00 | MSFT | Stock | 408.6599 | 412.99 | 408.06 | 412.02 | 78611.0 |
| 2024-08-02 09:30:00 | MSFT | Stock | 412.49 | 415.0 | 406.15 | 407.465 | 2384253.0 |
| 2024-08-02 10:00:00 | MSFT | Stock | 407.57 | 408.03 | 404.34 | 407.08 | 1389751.0 |
| 2024-08-02 10:30:00 | MSFT | Stock | 407.0 | 408.4 | 404.44 | 406.12 | 1074721.0 |
| 2024-08-02 11:00:00 | MSFT | Stock | 406.09 | 408.0132 | 404.68 | 405.355 | 1026740.0 |
| 2024-08-02 11:30:00 | MSFT | Stock | 405.4 | 407.66 | 404.88 | 406.83 | 871050.0 |
| 2024-08-02 12:00:00 | MSFT | Stock | 406.88 | 408.65 | 405.45 | 406.3908 | 692848.0 |
| 2024-08-02 12:30:00 | MSFT | Stock | 406.31 | 408.03 | 405.0 | 405.5 | 645599.0 |
> showing 50 of 102,703 rows — these rows as CSV