PREVIEW / stock_5min / 2007-05-21
file: by_date/stock_5min/2007/2007-05-21.parquet size: 3.9 MB rows: 289,272 symbols: 3,019
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-21 09:30:00 | AAPL | Stock | 3.9396 | 3.9479 | 3.9304 | 3.9404 | 16899372.0 |
| 2007-05-21 09:35:00 | AAPL | Stock | 3.9404 | 3.9482 | 3.9357 | 3.9457 | 11082372.0 |
| 2007-05-21 09:40:00 | AAPL | Stock | 3.9457 | 3.9543 | 3.9443 | 3.9471 | 11182108.0 |
| 2007-05-21 09:45:00 | AAPL | Stock | 3.9471 | 3.9521 | 3.9436 | 3.95 | 9205952.0 |
| 2007-05-21 09:50:00 | AAPL | Stock | 3.95 | 3.9511 | 3.9432 | 3.945 | 8497916.0 |
| 2007-05-21 09:55:00 | AAPL | Stock | 3.9454 | 3.9614 | 3.9446 | 3.9584 | 12337500.0 |
| 2007-05-21 10:00:00 | AAPL | Stock | 3.9571 | 3.9661 | 3.9561 | 3.9625 | 21259952.0 |
| 2007-05-21 10:05:00 | AAPL | Stock | 3.9629 | 3.9671 | 3.9575 | 3.9661 | 9951620.0 |
| 2007-05-21 10:10:00 | AAPL | Stock | 3.9661 | 3.9679 | 3.9593 | 3.9614 | 10226524.0 |
| 2007-05-21 10:15:00 | AAPL | Stock | 3.9611 | 3.9625 | 3.9536 | 3.9571 | 9883636.0 |
| 2007-05-21 10:20:00 | AAPL | Stock | 3.9564 | 3.9618 | 3.9536 | 3.9618 | 7920304.0 |
| 2007-05-21 10:25:00 | AAPL | Stock | 3.9621 | 3.9661 | 3.9571 | 3.9629 | 6019972.0 |
| 2007-05-21 10:30:00 | AAPL | Stock | 3.9632 | 3.9657 | 3.96 | 3.9614 | 5039804.0 |
| 2007-05-21 10:35:00 | AAPL | Stock | 3.9614 | 3.9711 | 3.9604 | 3.9686 | 8443680.0 |
| 2007-05-21 10:40:00 | AAPL | Stock | 3.9686 | 3.9804 | 3.9654 | 3.9789 | 11814012.0 |
| 2007-05-21 10:45:00 | AAPL | Stock | 3.9786 | 3.9854 | 3.9782 | 3.9846 | 9409456.0 |
| 2007-05-21 10:50:00 | AAPL | Stock | 3.985 | 4.0036 | 3.9821 | 3.9989 | 23823604.0 |
| 2007-05-21 10:55:00 | AAPL | Stock | 3.9986 | 4.0061 | 3.9954 | 4.005 | 12553044.0 |
| 2007-05-21 11:00:00 | AAPL | Stock | 4.005 | 4.0079 | 3.9968 | 3.9986 | 10486784.0 |
| 2007-05-21 11:05:00 | AAPL | Stock | 3.9982 | 4.0079 | 3.9982 | 4.0007 | 10045756.0 |
| 2007-05-21 11:10:00 | AAPL | Stock | 4.0004 | 4.0071 | 3.9957 | 3.9968 | 10681720.0 |
| 2007-05-21 11:15:00 | AAPL | Stock | 3.9964 | 3.9968 | 3.9929 | 3.9954 | 6729828.0 |
| 2007-05-21 11:20:00 | AAPL | Stock | 3.9954 | 4.0 | 3.9954 | 3.9986 | 4467344.0 |
| 2007-05-21 11:25:00 | AAPL | Stock | 3.9986 | 4.0 | 3.995 | 3.9961 | 4784836.0 |
| 2007-05-21 11:30:00 | AAPL | Stock | 3.9964 | 3.9968 | 3.9929 | 3.9968 | 4351116.0 |
| 2007-05-21 11:35:00 | AAPL | Stock | 3.9964 | 3.9971 | 3.9929 | 3.9936 | 3303384.0 |
| 2007-05-21 11:40:00 | AAPL | Stock | 3.9936 | 3.9982 | 3.9932 | 3.9968 | 3298512.0 |
| 2007-05-21 11:45:00 | AAPL | Stock | 3.9975 | 4.0018 | 3.9968 | 3.9975 | 4202828.0 |
| 2007-05-21 11:50:00 | AAPL | Stock | 3.9975 | 4.0 | 3.9964 | 3.9989 | 4294388.0 |
| 2007-05-21 11:55:00 | AAPL | Stock | 3.9986 | 4.0018 | 3.9968 | 4.0011 | 4334176.0 |
| 2007-05-21 12:00:00 | AAPL | Stock | 4.0011 | 4.0036 | 4.0 | 4.0032 | 5013512.0 |
| 2007-05-21 12:05:00 | AAPL | Stock | 4.0033 | 4.0143 | 4.0032 | 4.0136 | 10922380.0 |
| 2007-05-21 12:10:00 | AAPL | Stock | 4.0136 | 4.0161 | 4.0121 | 4.015 | 7298704.0 |
| 2007-05-21 12:15:00 | AAPL | Stock | 4.015 | 4.0161 | 4.0089 | 4.0104 | 7248836.0 |
| 2007-05-21 12:20:00 | AAPL | Stock | 4.01 | 4.0125 | 4.0 | 4.0011 | 7887180.0 |
| 2007-05-21 12:25:00 | AAPL | Stock | 4.0014 | 4.0064 | 3.9996 | 4.0054 | 7871276.0 |
| 2007-05-21 12:30:00 | AAPL | Stock | 4.005 | 4.0075 | 4.0018 | 4.004 | 4782484.0 |
| 2007-05-21 12:35:00 | AAPL | Stock | 4.0043 | 4.0079 | 4.0011 | 4.0021 | 5264000.0 |
| 2007-05-21 12:40:00 | AAPL | Stock | 4.0021 | 4.0043 | 3.9939 | 3.9955 | 7217112.0 |
| 2007-05-21 12:45:00 | AAPL | Stock | 3.995 | 3.9954 | 3.8768 | 3.9871 | 16144632.0 |
| 2007-05-21 12:50:00 | AAPL | Stock | 3.9868 | 3.9875 | 3.9793 | 3.9854 | 5672268.0 |
| 2007-05-21 12:55:00 | AAPL | Stock | 3.985 | 3.9943 | 3.985 | 3.9929 | 6560792.0 |
| 2007-05-21 13:00:00 | AAPL | Stock | 3.9929 | 3.9979 | 3.9907 | 3.9939 | 4570972.0 |
| 2007-05-21 13:05:00 | AAPL | Stock | 3.9936 | 3.9954 | 3.99 | 3.9925 | 2984268.0 |
| 2007-05-21 13:10:00 | AAPL | Stock | 3.9921 | 3.9946 | 3.9907 | 3.9932 | 2890748.0 |
| 2007-05-21 13:15:00 | AAPL | Stock | 3.9933 | 4.0007 | 3.9933 | 3.9975 | 4884096.0 |
| 2007-05-21 13:20:00 | AAPL | Stock | 3.9975 | 3.9996 | 3.9932 | 3.9964 | 3084116.0 |
| 2007-05-21 13:25:00 | AAPL | Stock | 3.9968 | 3.9993 | 3.9957 | 3.9968 | 2027928.0 |
| 2007-05-21 13:30:00 | AAPL | Stock | 3.9964 | 3.9975 | 3.9918 | 3.9925 | 2976456.0 |
| 2007-05-21 13:35:00 | AAPL | Stock | 3.9921 | 3.9929 | 3.9861 | 3.9889 | 4283188.0 |
> showing 50 of 289,272 rows — these rows as CSV