PREVIEW / stock_5min / 2007-07-24
file: by_date/stock_5min/2007/2007-07-24.parquet size: 4.2 MB rows: 305,613 symbols: 3,086
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-07-24 09:30:00 | AAPL | Stock | 4.96 | 4.9625 | 4.8768 | 4.8875 | 84029568.0 |
| 2007-07-24 09:35:00 | AAPL | Stock | 4.8879 | 4.9264 | 4.8804 | 4.9218 | 61953724.0 |
| 2007-07-24 09:40:00 | AAPL | Stock | 4.9214 | 4.9714 | 4.9214 | 4.9564 | 57660400.0 |
| 2007-07-24 09:45:00 | AAPL | Stock | 4.9561 | 4.9811 | 4.9464 | 4.9596 | 51925804.0 |
| 2007-07-24 09:50:00 | AAPL | Stock | 4.9597 | 4.9679 | 4.9504 | 4.9582 | 26239976.0 |
| 2007-07-24 09:55:00 | AAPL | Stock | 4.9586 | 4.9586 | 4.9286 | 4.9379 | 39198852.0 |
| 2007-07-24 10:00:00 | AAPL | Stock | 4.9368 | 4.9582 | 4.9321 | 4.9547 | 24038392.0 |
| 2007-07-24 10:05:00 | AAPL | Stock | 4.9548 | 4.9557 | 4.9311 | 4.955 | 19782280.0 |
| 2007-07-24 10:10:00 | AAPL | Stock | 4.9554 | 4.9896 | 4.9518 | 4.9814 | 38897460.0 |
| 2007-07-24 10:15:00 | AAPL | Stock | 4.9814 | 5.0 | 4.9775 | 4.9936 | 34618444.0 |
| 2007-07-24 10:20:00 | AAPL | Stock | 4.9929 | 4.9993 | 4.9818 | 4.9821 | 20636028.0 |
| 2007-07-24 10:25:00 | AAPL | Stock | 4.9821 | 4.9925 | 4.9761 | 4.9804 | 14589008.0 |
| 2007-07-24 10:30:00 | AAPL | Stock | 4.9804 | 4.9854 | 4.9661 | 4.9786 | 15962660.0 |
| 2007-07-24 10:35:00 | AAPL | Stock | 4.9793 | 4.9871 | 4.9714 | 4.9864 | 13720812.0 |
| 2007-07-24 10:40:00 | AAPL | Stock | 4.9861 | 4.9982 | 4.9768 | 4.9929 | 15418816.0 |
| 2007-07-24 10:45:00 | AAPL | Stock | 4.9929 | 4.9932 | 4.9732 | 4.9775 | 13281100.0 |
| 2007-07-24 10:50:00 | AAPL | Stock | 4.9782 | 4.9911 | 4.9782 | 4.9832 | 12533584.0 |
| 2007-07-24 10:55:00 | AAPL | Stock | 4.9829 | 5.0179 | 4.9714 | 5.0129 | 22485372.0 |
| 2007-07-24 11:00:00 | AAPL | Stock | 5.0136 | 5.0189 | 5.0011 | 5.0039 | 20616288.0 |
| 2007-07-24 11:05:00 | AAPL | Stock | 5.0036 | 5.0118 | 5.0 | 5.0011 | 15090600.0 |
| 2007-07-24 11:10:00 | AAPL | Stock | 5.0029 | 5.0161 | 5.0029 | 5.0139 | 15959636.0 |
| 2007-07-24 11:15:00 | AAPL | Stock | 5.0139 | 5.0246 | 5.0104 | 5.0186 | 21507556.0 |
| 2007-07-24 11:20:00 | AAPL | Stock | 5.0192 | 5.0204 | 5.0036 | 5.0115 | 18461296.0 |
| 2007-07-24 11:25:00 | AAPL | Stock | 5.0121 | 5.0143 | 4.9968 | 5.0054 | 16920484.0 |
| 2007-07-24 11:30:00 | AAPL | Stock | 5.005 | 5.0057 | 4.9846 | 4.9932 | 16319240.0 |
| 2007-07-24 11:35:00 | AAPL | Stock | 4.9929 | 5.0029 | 4.9925 | 5.0007 | 9847460.0 |
| 2007-07-24 11:40:00 | AAPL | Stock | 5.0007 | 5.0068 | 4.9918 | 4.9957 | 10350676.0 |
| 2007-07-24 11:45:00 | AAPL | Stock | 4.9957 | 4.9982 | 4.9857 | 4.9936 | 9539068.0 |
| 2007-07-24 11:50:00 | AAPL | Stock | 4.9936 | 4.9964 | 4.9821 | 4.9832 | 8486016.0 |
| 2007-07-24 11:55:00 | AAPL | Stock | 4.9832 | 4.9964 | 4.9814 | 4.9957 | 7584584.0 |
| 2007-07-24 12:00:00 | AAPL | Stock | 4.995 | 5.0011 | 4.9921 | 4.995 | 7646212.0 |
| 2007-07-24 12:05:00 | AAPL | Stock | 4.9949 | 4.9986 | 4.9882 | 4.9929 | 6177416.0 |
| 2007-07-24 12:10:00 | AAPL | Stock | 4.9939 | 4.9943 | 4.9789 | 4.9839 | 11479188.0 |
| 2007-07-24 12:15:00 | AAPL | Stock | 4.9839 | 4.9936 | 4.9839 | 4.9896 | 5841584.0 |
| 2007-07-24 12:20:00 | AAPL | Stock | 4.9896 | 5.0054 | 4.9886 | 5.0036 | 11760980.0 |
| 2007-07-24 12:25:00 | AAPL | Stock | 5.0036 | 5.0061 | 5.0 | 5.0032 | 10114328.0 |
| 2007-07-24 12:30:00 | AAPL | Stock | 5.0029 | 5.0036 | 4.9939 | 4.9972 | 14218288.0 |
| 2007-07-24 12:35:00 | AAPL | Stock | 4.9975 | 4.9993 | 4.9929 | 4.995 | 8392216.0 |
| 2007-07-24 12:40:00 | AAPL | Stock | 4.995 | 4.9964 | 4.9911 | 4.9936 | 8171184.0 |
| 2007-07-24 12:45:00 | AAPL | Stock | 4.9939 | 4.9946 | 4.9911 | 4.9925 | 5620524.0 |
| 2007-07-24 12:50:00 | AAPL | Stock | 4.9925 | 4.9996 | 4.9918 | 4.9995 | 9279564.0 |
| 2007-07-24 12:55:00 | AAPL | Stock | 4.9993 | 4.9996 | 4.9936 | 4.9979 | 3678052.0 |
| 2007-07-24 13:00:00 | AAPL | Stock | 4.9979 | 5.0011 | 4.9968 | 5.0 | 6451396.0 |
| 2007-07-24 13:05:00 | AAPL | Stock | 5.0004 | 5.0011 | 4.9929 | 4.9932 | 6033832.0 |
| 2007-07-24 13:10:00 | AAPL | Stock | 4.9932 | 5.0191 | 4.9911 | 4.9929 | 6116040.0 |
| 2007-07-24 13:15:00 | AAPL | Stock | 4.9925 | 5.0 | 4.9911 | 4.9993 | 7521276.0 |
| 2007-07-24 13:20:00 | AAPL | Stock | 4.9996 | 5.0143 | 4.9986 | 5.0129 | 14765576.0 |
| 2007-07-24 13:25:00 | AAPL | Stock | 5.0125 | 5.0146 | 5.0043 | 5.0111 | 11632908.0 |
| 2007-07-24 13:30:00 | AAPL | Stock | 5.01 | 5.0357 | 5.0079 | 5.0336 | 17762108.0 |
| 2007-07-24 13:35:00 | AAPL | Stock | 5.0329 | 5.0357 | 5.015 | 5.0175 | 16402260.0 |
> showing 50 of 305,613 rows — these rows as CSV