PREVIEW / stock_5min / 2006-12-29
file: by_date/stock_5min/2006/2006-12-29.parquet size: 3.3 MB rows: 240,936 symbols: 2,504
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-29 06:10:00 | AAPL | Stock | 2.8925 | 2.9 | 2.8925 | 2.8996 | 53200.0 |
| 2006-12-29 06:20:00 | AAPL | Stock | 2.9093 | 2.9189 | 2.8968 | 2.9189 | 30800.0 |
| 2006-12-29 06:25:00 | AAPL | Stock | 2.9179 | 2.9307 | 2.9179 | 2.9307 | 86800.0 |
| 2006-12-29 06:30:00 | AAPL | Stock | 2.9425 | 2.9643 | 2.9114 | 2.9114 | 44436.0 |
| 2006-12-29 06:40:00 | AAPL | Stock | 2.95 | 2.95 | 2.95 | 2.95 | 2800.0 |
| 2006-12-29 06:45:00 | AAPL | Stock | 2.9514 | 2.9514 | 2.9514 | 2.9514 | 8764.0 |
| 2006-12-29 06:50:00 | AAPL | Stock | 2.9704 | 2.9714 | 2.9679 | 2.9679 | 25200.0 |
| 2006-12-29 06:55:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9714 | 2.9714 | 10808.0 |
| 2006-12-29 07:00:00 | AAPL | Stock | 2.9714 | 2.9921 | 2.9714 | 2.9821 | 120428.0 |
| 2006-12-29 07:05:00 | AAPL | Stock | 2.9857 | 2.9936 | 2.9857 | 2.9875 | 265244.0 |
| 2006-12-29 07:10:00 | AAPL | Stock | 2.9821 | 2.9821 | 2.9661 | 2.975 | 324800.0 |
| 2006-12-29 07:15:00 | AAPL | Stock | 2.9782 | 2.9857 | 2.9782 | 2.9825 | 378700.0 |
| 2006-12-29 07:20:00 | AAPL | Stock | 2.9825 | 2.9857 | 2.9821 | 2.9825 | 418880.0 |
| 2006-12-29 07:25:00 | AAPL | Stock | 2.9832 | 2.9857 | 2.9829 | 2.9857 | 166264.0 |
| 2006-12-29 07:30:00 | AAPL | Stock | 2.9875 | 3.0321 | 2.9875 | 3.025 | 2471588.0 |
| 2006-12-29 07:35:00 | AAPL | Stock | 3.025 | 3.025 | 3.0054 | 3.0054 | 816844.0 |
| 2006-12-29 07:40:00 | AAPL | Stock | 3.0086 | 3.0104 | 3.0043 | 3.0068 | 534828.0 |
| 2006-12-29 07:45:00 | AAPL | Stock | 3.0071 | 3.0143 | 3.0071 | 3.0104 | 800800.0 |
| 2006-12-29 07:50:00 | AAPL | Stock | 3.0107 | 3.0179 | 3.0093 | 3.0093 | 817740.0 |
| 2006-12-29 07:55:00 | AAPL | Stock | 3.0089 | 3.0089 | 2.9929 | 3.0046 | 647640.0 |
| 2006-12-29 08:00:00 | AAPL | Stock | 3.0061 | 3.0129 | 3.0 | 3.0125 | 5163928.0 |
| 2006-12-29 08:05:00 | AAPL | Stock | 3.0125 | 3.0186 | 3.0071 | 3.0121 | 3188584.0 |
| 2006-12-29 08:10:00 | AAPL | Stock | 3.0125 | 3.0175 | 3.0071 | 3.0121 | 2233924.0 |
| 2006-12-29 08:15:00 | AAPL | Stock | 3.0121 | 3.025 | 3.01 | 3.0189 | 4353692.0 |
| 2006-12-29 08:20:00 | AAPL | Stock | 3.0189 | 3.0282 | 3.0179 | 3.0254 | 3505320.0 |
| 2006-12-29 08:25:00 | AAPL | Stock | 3.025 | 3.025 | 3.0107 | 3.0121 | 3775548.0 |
| 2006-12-29 08:30:00 | AAPL | Stock | 3.0118 | 3.015 | 3.0039 | 3.0039 | 6145888.0 |
| 2006-12-29 08:35:00 | AAPL | Stock | 3.0036 | 3.0068 | 2.9968 | 2.9982 | 3371004.0 |
| 2006-12-29 08:40:00 | AAPL | Stock | 2.9982 | 3.0079 | 2.9975 | 3.0046 | 2239104.0 |
| 2006-12-29 08:45:00 | AAPL | Stock | 3.005 | 3.0114 | 3.0036 | 3.0107 | 1829800.0 |
| 2006-12-29 08:50:00 | AAPL | Stock | 3.0107 | 3.0129 | 3.0039 | 3.0054 | 2239860.0 |
| 2006-12-29 08:55:00 | AAPL | Stock | 3.0054 | 3.0071 | 2.9982 | 3.0004 | 2155636.0 |
| 2006-12-29 09:00:00 | AAPL | Stock | 3.0014 | 3.005 | 2.9957 | 3.0 | 4071620.0 |
| 2006-12-29 09:05:00 | AAPL | Stock | 2.9996 | 3.0018 | 2.9964 | 2.9982 | 1910048.0 |
| 2006-12-29 09:10:00 | AAPL | Stock | 2.9982 | 3.005 | 2.9982 | 3.0018 | 2600164.0 |
| 2006-12-29 09:15:00 | AAPL | Stock | 3.0018 | 3.0018 | 2.9943 | 2.9971 | 2249464.0 |
| 2006-12-29 09:20:00 | AAPL | Stock | 2.9979 | 3.0096 | 2.995 | 2.9957 | 1560972.0 |
| 2006-12-29 09:25:00 | AAPL | Stock | 2.9954 | 3.0029 | 2.9911 | 2.9989 | 2277352.0 |
| 2006-12-29 09:30:00 | AAPL | Stock | 2.9982 | 3.0054 | 2.9771 | 3.0 | 57007384.0 |
| 2006-12-29 09:35:00 | AAPL | Stock | 3.0007 | 3.0075 | 2.9921 | 3.0025 | 36181012.0 |
| 2006-12-29 09:40:00 | AAPL | Stock | 3.0029 | 3.0064 | 2.9971 | 3.0054 | 26459216.0 |
| 2006-12-29 09:45:00 | AAPL | Stock | 3.0054 | 3.0179 | 3.0009 | 3.0121 | 36690752.0 |
| 2006-12-29 09:50:00 | AAPL | Stock | 3.0118 | 3.0282 | 3.01 | 3.025 | 39367972.0 |
| 2006-12-29 09:55:00 | AAPL | Stock | 3.0247 | 3.0293 | 3.0179 | 3.0186 | 28621180.0 |
| 2006-12-29 10:00:00 | AAPL | Stock | 3.0189 | 3.035 | 3.0182 | 3.0282 | 31930724.0 |
| 2006-12-29 10:05:00 | AAPL | Stock | 3.0279 | 3.035 | 3.0261 | 3.0318 | 26906796.0 |
| 2006-12-29 10:10:00 | AAPL | Stock | 3.0318 | 3.0411 | 3.0304 | 3.0332 | 33479152.0 |
| 2006-12-29 10:15:00 | AAPL | Stock | 3.0332 | 3.0382 | 3.0304 | 3.0321 | 20821696.0 |
| 2006-12-29 10:20:00 | AAPL | Stock | 3.0321 | 3.0411 | 3.0314 | 3.0361 | 21050288.0 |
| 2006-12-29 10:25:00 | AAPL | Stock | 3.0361 | 3.0361 | 3.0286 | 3.0325 | 16613940.0 |
> showing 50 of 240,936 rows — these rows as CSV