PREVIEW / stock_5min / 2006-07-10
file: by_date/stock_5min/2006/2006-07-10.parquet size: 3.0 MB rows: 223,923 symbols: 2,317
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-07-10 08:00:00 | AAPL | Stock | 1.9911 | 1.9911 | 1.9911 | 1.9911 | 36400.0 |
| 2006-07-10 08:05:00 | AAPL | Stock | 1.9911 | 1.9946 | 1.9911 | 1.9946 | 71400.0 |
| 2006-07-10 08:10:00 | AAPL | Stock | 1.9946 | 1.9946 | 1.9946 | 1.9946 | 28000.0 |
| 2006-07-10 08:15:00 | AAPL | Stock | 1.9946 | 1.9946 | 1.9946 | 1.9946 | 7000.0 |
| 2006-07-10 08:20:00 | AAPL | Stock | 1.9946 | 1.9946 | 1.9946 | 1.9946 | 36400.0 |
| 2006-07-10 08:25:00 | AAPL | Stock | 1.9929 | 1.9946 | 1.9929 | 1.9946 | 68040.0 |
| 2006-07-10 08:30:00 | AAPL | Stock | 1.9946 | 1.9946 | 1.9929 | 1.9929 | 35560.0 |
| 2006-07-10 08:40:00 | AAPL | Stock | 1.9936 | 1.9936 | 1.9936 | 1.9936 | 2800.0 |
| 2006-07-10 08:45:00 | AAPL | Stock | 1.9936 | 1.9939 | 1.9936 | 1.9939 | 28000.0 |
| 2006-07-10 08:50:00 | AAPL | Stock | 1.9939 | 1.9957 | 1.9936 | 1.9957 | 30800.0 |
| 2006-07-10 08:55:00 | AAPL | Stock | 1.9957 | 1.9957 | 1.9936 | 1.9936 | 58800.0 |
| 2006-07-10 09:00:00 | AAPL | Stock | 1.9943 | 1.9943 | 1.9943 | 1.9943 | 19600.0 |
| 2006-07-10 09:05:00 | AAPL | Stock | 1.9936 | 1.9936 | 1.9936 | 1.9936 | 5600.0 |
| 2006-07-10 09:10:00 | AAPL | Stock | 1.9932 | 1.9932 | 1.9929 | 1.9929 | 22400.0 |
| 2006-07-10 09:15:00 | AAPL | Stock | 1.9911 | 1.9918 | 1.9896 | 1.9896 | 44800.0 |
| 2006-07-10 09:20:00 | AAPL | Stock | 1.9896 | 1.9904 | 1.9893 | 1.9893 | 56000.0 |
| 2006-07-10 09:25:00 | AAPL | Stock | 1.9893 | 1.9896 | 1.9889 | 1.9893 | 102480.0 |
| 2006-07-10 09:30:00 | AAPL | Stock | 1.9893 | 2.0036 | 1.9868 | 2.0036 | 12778976.0 |
| 2006-07-10 09:35:00 | AAPL | Stock | 2.0036 | 2.0064 | 1.9979 | 2.0036 | 9544500.0 |
| 2006-07-10 09:40:00 | AAPL | Stock | 2.0036 | 2.0118 | 2.0018 | 2.0071 | 13913928.0 |
| 2006-07-10 09:45:00 | AAPL | Stock | 2.0071 | 2.0072 | 1.9968 | 1.9982 | 9993872.0 |
| 2006-07-10 09:50:00 | AAPL | Stock | 1.9986 | 2.0046 | 1.9982 | 1.9986 | 6245708.0 |
| 2006-07-10 09:55:00 | AAPL | Stock | 1.9982 | 2.0082 | 1.9968 | 2.0075 | 9279956.0 |
| 2006-07-10 10:00:00 | AAPL | Stock | 2.0071 | 2.01 | 2.0018 | 2.0061 | 7829808.0 |
| 2006-07-10 10:05:00 | AAPL | Stock | 2.0061 | 2.0171 | 2.0061 | 2.015 | 14266448.0 |
| 2006-07-10 10:10:00 | AAPL | Stock | 2.015 | 2.0175 | 2.0089 | 2.0089 | 7553980.0 |
| 2006-07-10 10:15:00 | AAPL | Stock | 2.0093 | 2.0139 | 2.0054 | 2.0054 | 7618128.0 |
| 2006-07-10 10:20:00 | AAPL | Stock | 2.0057 | 2.0089 | 2.0011 | 2.0029 | 6421856.0 |
| 2006-07-10 10:25:00 | AAPL | Stock | 2.0032 | 2.0082 | 2.0029 | 2.0068 | 5972904.0 |
| 2006-07-10 10:30:00 | AAPL | Stock | 2.0071 | 2.0129 | 1.9979 | 2.0 | 9848440.0 |
| 2006-07-10 10:35:00 | AAPL | Stock | 1.9993 | 2.0032 | 1.9975 | 2.0 | 6173804.0 |
| 2006-07-10 10:40:00 | AAPL | Stock | 2.0 | 2.0064 | 1.9996 | 2.0064 | 6684944.0 |
| 2006-07-10 10:45:00 | AAPL | Stock | 2.0061 | 2.0082 | 2.0025 | 2.0075 | 4611684.0 |
| 2006-07-10 10:50:00 | AAPL | Stock | 2.0075 | 2.0089 | 2.005 | 2.0057 | 6144908.0 |
| 2006-07-10 10:55:00 | AAPL | Stock | 2.0057 | 2.0079 | 2.0025 | 2.0043 | 4616528.0 |
| 2006-07-10 11:00:00 | AAPL | Stock | 2.0043 | 2.0043 | 2.0007 | 2.0011 | 3900904.0 |
| 2006-07-10 11:05:00 | AAPL | Stock | 2.0011 | 2.0011 | 1.9961 | 1.9961 | 7317744.0 |
| 2006-07-10 11:10:00 | AAPL | Stock | 1.9961 | 1.9993 | 1.9946 | 1.9982 | 7633472.0 |
| 2006-07-10 11:15:00 | AAPL | Stock | 1.9982 | 2.0014 | 1.9964 | 1.9964 | 4887764.0 |
| 2006-07-10 11:20:00 | AAPL | Stock | 1.9971 | 1.9996 | 1.9946 | 1.9971 | 4255748.0 |
| 2006-07-10 11:25:00 | AAPL | Stock | 1.9971 | 2.0011 | 1.9936 | 1.9975 | 4262832.0 |
| 2006-07-10 11:30:00 | AAPL | Stock | 1.9979 | 1.9986 | 1.9936 | 1.9936 | 4432232.0 |
| 2006-07-10 11:35:00 | AAPL | Stock | 1.9939 | 1.9939 | 1.9874 | 1.9898 | 8284696.0 |
| 2006-07-10 11:40:00 | AAPL | Stock | 1.99 | 1.9907 | 1.9846 | 1.9886 | 6389348.0 |
| 2006-07-10 11:45:00 | AAPL | Stock | 1.9889 | 1.9911 | 1.9871 | 1.9882 | 5182352.0 |
| 2006-07-10 11:50:00 | AAPL | Stock | 1.9889 | 1.9889 | 1.9839 | 1.9857 | 4095392.0 |
| 2006-07-10 11:55:00 | AAPL | Stock | 1.9857 | 1.9886 | 1.9836 | 1.9839 | 5045096.0 |
| 2006-07-10 12:00:00 | AAPL | Stock | 1.9843 | 1.9843 | 1.9775 | 1.9789 | 9105068.0 |
| 2006-07-10 12:05:00 | AAPL | Stock | 1.9786 | 1.9814 | 1.9782 | 1.9807 | 3941672.0 |
| 2006-07-10 12:10:00 | AAPL | Stock | 1.98 | 1.9818 | 1.9782 | 1.98 | 2949744.0 |
> showing 50 of 223,923 rows — these rows as CSV