PREVIEW / stock_30min / 2001-01-04
file: by_date/stock_30min/2001/2001-01-04.parquet size: 484 KB rows: 27,592 symbols: 1,265
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-04 08:00:00 | AAPL | Stock | 0.2857 | 0.2924 | 0.2857 | 0.2902 | 621600.0 |
| 2001-01-04 08:30:00 | AAPL | Stock | 0.2902 | 0.2913 | 0.2879 | 0.2913 | 498400.0 |
| 2001-01-04 09:00:00 | AAPL | Stock | 0.2913 | 0.3259 | 0.2879 | 0.3248 | 30654400.0 |
| 2001-01-04 09:30:00 | AAPL | Stock | 0.3237 | 0.3304 | 0.3002 | 0.3114 | 189173600.0 |
| 2001-01-04 10:00:00 | AAPL | Stock | 0.3119 | 0.3147 | 0.3013 | 0.3047 | 63543200.0 |
| 2001-01-04 10:30:00 | AAPL | Stock | 0.3047 | 0.3125 | 0.3002 | 0.3103 | 78876000.0 |
| 2001-01-04 11:00:00 | AAPL | Stock | 0.3114 | 0.3158 | 0.3092 | 0.3114 | 45836000.0 |
| 2001-01-04 11:30:00 | AAPL | Stock | 0.3114 | 0.317 | 0.3103 | 0.3158 | 25446400.0 |
| 2001-01-04 12:00:00 | AAPL | Stock | 0.3158 | 0.3192 | 0.3147 | 0.317 | 47118400.0 |
| 2001-01-04 12:30:00 | AAPL | Stock | 0.317 | 0.317 | 0.3114 | 0.3125 | 19555200.0 |
| 2001-01-04 13:00:00 | AAPL | Stock | 0.3114 | 0.3125 | 0.308 | 0.308 | 20272000.0 |
| 2001-01-04 13:30:00 | AAPL | Stock | 0.308 | 0.3103 | 0.3047 | 0.308 | 23968000.0 |
| 2001-01-04 14:00:00 | AAPL | Stock | 0.308 | 0.3092 | 0.3025 | 0.3058 | 28184800.0 |
| 2001-01-04 14:30:00 | AAPL | Stock | 0.3058 | 0.3058 | 0.3036 | 0.3058 | 13400800.0 |
| 2001-01-04 15:00:00 | AAPL | Stock | 0.3047 | 0.3092 | 0.3047 | 0.3069 | 25905600.0 |
| 2001-01-04 15:30:00 | AAPL | Stock | 0.3069 | 0.308 | 0.3047 | 0.3047 | 24908800.0 |
| 2001-01-04 16:00:00 | AAPL | Stock | 0.3047 | 0.3259 | 0.3036 | 0.3259 | 4457600.0 |
| 2001-01-04 16:30:00 | AAPL | Stock | 0.3041 | 0.3248 | 0.3036 | 0.3248 | 543200.0 |
| 2001-01-04 17:00:00 | AAPL | Stock | 0.3058 | 0.3058 | 0.3047 | 0.3058 | 280000.0 |
| 2001-01-04 17:30:00 | AAPL | Stock | 0.3058 | 0.3058 | 0.3058 | 0.3058 | 44800.0 |
| 2001-01-04 18:00:00 | AAPL | Stock | 0.3058 | 0.308 | 0.3058 | 0.3058 | 106400.0 |
| 2001-01-04 08:00:00 | MSFT | Stock | 24.25 | 24.375 | 23.625 | 23.75 | 944800.0 |
| 2001-01-04 08:30:00 | MSFT | Stock | 23.875 | 23.9375 | 23.5312 | 23.625 | 78000.0 |
| 2001-01-04 09:00:00 | MSFT | Stock | 23.6094 | 23.9688 | 23.375 | 23.9062 | 279200.0 |
| 2001-01-04 09:30:00 | MSFT | Stock | 23.9062 | 24.1406 | 23.4375 | 23.6562 | 14516000.0 |
| 2001-01-04 10:00:00 | MSFT | Stock | 23.9062 | 24.9375 | 23.8438 | 24.3125 | 13473000.0 |
| 2001-01-04 10:30:00 | MSFT | Stock | 24.3438 | 24.5312 | 24.0938 | 24.4375 | 8013400.0 |
| 2001-01-04 11:00:00 | MSFT | Stock | 24.4375 | 24.6875 | 24.2812 | 24.5 | 4952800.0 |
| 2001-01-04 11:30:00 | MSFT | Stock | 24.5 | 24.5 | 24.1562 | 24.4375 | 6856200.0 |
| 2001-01-04 12:00:00 | MSFT | Stock | 24.4062 | 24.7812 | 24.3438 | 24.7812 | 6861800.0 |
| 2001-01-04 12:30:00 | MSFT | Stock | 24.75 | 24.7812 | 24.375 | 24.4062 | 6595200.0 |
| 2001-01-04 13:00:00 | MSFT | Stock | 24.4062 | 24.5625 | 24.4062 | 24.4688 | 3467600.0 |
| 2001-01-04 13:30:00 | MSFT | Stock | 24.4688 | 24.625 | 24.1875 | 24.5 | 5224400.0 |
| 2001-01-04 14:00:00 | MSFT | Stock | 24.5 | 24.5625 | 24.0625 | 24.1719 | 6486600.0 |
| 2001-01-04 14:30:00 | MSFT | Stock | 24.1875 | 24.25 | 23.875 | 24.25 | 8788200.0 |
| 2001-01-04 15:00:00 | MSFT | Stock | 24.2188 | 24.4219 | 24.1875 | 24.4062 | 6279000.0 |
| 2001-01-04 15:30:00 | MSFT | Stock | 24.4062 | 24.4375 | 24.0625 | 24.25 | 9093800.0 |
| 2001-01-04 16:00:00 | MSFT | Stock | 24.2188 | 24.375 | 24.1094 | 24.1562 | 2518400.0 |
| 2001-01-04 16:30:00 | MSFT | Stock | 24.1562 | 24.2812 | 24.1562 | 24.25 | 312400.0 |
| 2001-01-04 17:00:00 | MSFT | Stock | 24.0625 | 24.6875 | 24.0625 | 24.5 | 211800.0 |
| 2001-01-04 17:30:00 | MSFT | Stock | 24.5 | 24.5938 | 24.4062 | 24.5938 | 24400.0 |
| 2001-01-04 18:00:00 | MSFT | Stock | 24.5938 | 24.875 | 24.4375 | 24.5 | 6000.0 |
| 2001-01-04 08:00:00 | NVDA | Stock | 0.1667 | 0.1667 | 0.1629 | 0.1629 | 888000.0 |
| 2001-01-04 08:30:00 | NVDA | Stock | 0.1583 | 0.1604 | 0.1583 | 0.1604 | 48000.0 |
| 2001-01-04 09:00:00 | NVDA | Stock | 0.1604 | 0.1625 | 0.1604 | 0.1625 | 96000.0 |
| 2001-01-04 09:30:00 | NVDA | Stock | 0.1602 | 0.1745 | 0.1557 | 0.168 | 88392000.0 |
| 2001-01-04 10:00:00 | NVDA | Stock | 0.168 | 0.1719 | 0.1638 | 0.1693 | 48696000.0 |
| 2001-01-04 10:30:00 | NVDA | Stock | 0.1693 | 0.1721 | 0.168 | 0.1693 | 25128000.0 |
| 2001-01-04 11:00:00 | NVDA | Stock | 0.1693 | 0.1719 | 0.1688 | 0.171 | 15720000.0 |
| 2001-01-04 11:30:00 | NVDA | Stock | 0.1708 | 0.1771 | 0.1706 | 0.1768 | 29232000.0 |
> showing 50 of 27,592 rows — these rows as CSV