PREVIEW / stock_5min / 2011-12-05
file: by_date/stock_5min/2011/2011-12-05.parquet size: 4.9 MB rows: 330,749 symbols: 3,534
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-05 04:45:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 2800.0 |
| 2011-12-05 04:55:00 | AAPL | Stock | 14.0286 | 14.0286 | 14.0286 | 14.0286 | 11844.0 |
| 2011-12-05 05:50:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 12880.0 |
| 2011-12-05 06:20:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 2800.0 |
| 2011-12-05 06:25:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.9821 | 13.9821 | 15316.0 |
| 2011-12-05 06:40:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.9821 | 13.9821 | 2800.0 |
| 2011-12-05 06:45:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.9821 | 13.9821 | 2800.0 |
| 2011-12-05 06:50:00 | AAPL | Stock | 13.9818 | 13.9821 | 13.9818 | 13.9821 | 14000.0 |
| 2011-12-05 07:00:00 | AAPL | Stock | 13.9818 | 13.9911 | 13.9818 | 13.9911 | 22400.0 |
| 2011-12-05 07:05:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 2800.0 |
| 2011-12-05 07:10:00 | AAPL | Stock | 13.9907 | 13.9907 | 13.9871 | 13.9871 | 8120.0 |
| 2011-12-05 07:15:00 | AAPL | Stock | 13.9821 | 14.0107 | 13.9821 | 14.0107 | 16800.0 |
| 2011-12-05 07:20:00 | AAPL | Stock | 14.0179 | 14.0246 | 14.0143 | 14.0246 | 14000.0 |
| 2011-12-05 07:25:00 | AAPL | Stock | 14.0161 | 14.0179 | 14.0161 | 14.0179 | 5600.0 |
| 2011-12-05 07:30:00 | AAPL | Stock | 14.0196 | 14.0357 | 14.0196 | 14.0357 | 25592.0 |
| 2011-12-05 07:35:00 | AAPL | Stock | 14.0339 | 14.0339 | 14.0318 | 14.0318 | 8120.0 |
| 2011-12-05 07:40:00 | AAPL | Stock | 14.0268 | 14.0268 | 14.0164 | 14.0268 | 60200.0 |
| 2011-12-05 07:45:00 | AAPL | Stock | 14.0243 | 14.0243 | 14.0168 | 14.0214 | 53760.0 |
| 2011-12-05 07:50:00 | AAPL | Stock | 14.0182 | 14.0182 | 14.0182 | 14.0182 | 5600.0 |
| 2011-12-05 07:55:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0136 | 14.0171 | 27440.0 |
| 2011-12-05 08:00:00 | AAPL | Stock | 14.0161 | 14.025 | 13.9968 | 13.9968 | 327852.0 |
| 2011-12-05 08:05:00 | AAPL | Stock | 14.0086 | 14.0175 | 13.9968 | 14.0075 | 183596.0 |
| 2011-12-05 08:10:00 | AAPL | Stock | 14.0075 | 14.0175 | 13.9964 | 14.0054 | 229096.0 |
| 2011-12-05 08:15:00 | AAPL | Stock | 14.0057 | 14.0064 | 13.9993 | 14.0 | 74200.0 |
| 2011-12-05 08:20:00 | AAPL | Stock | 13.9964 | 14.0054 | 13.9893 | 13.9986 | 301028.0 |
| 2011-12-05 08:25:00 | AAPL | Stock | 13.9996 | 14.0029 | 13.9939 | 14.0018 | 121576.0 |
| 2011-12-05 08:30:00 | AAPL | Stock | 14.0029 | 14.0029 | 13.9971 | 13.9975 | 62860.0 |
| 2011-12-05 08:35:00 | AAPL | Stock | 13.9996 | 13.9996 | 13.9818 | 13.9893 | 248836.0 |
| 2011-12-05 08:40:00 | AAPL | Stock | 13.9879 | 13.9961 | 13.9875 | 13.9961 | 44800.0 |
| 2011-12-05 08:45:00 | AAPL | Stock | 13.9957 | 13.9993 | 13.9946 | 13.9964 | 56196.0 |
| 2011-12-05 08:50:00 | AAPL | Stock | 13.9986 | 14.0029 | 13.9971 | 13.9971 | 67480.0 |
| 2011-12-05 08:55:00 | AAPL | Stock | 14.0029 | 14.0036 | 13.9982 | 14.0032 | 104020.0 |
| 2011-12-05 09:00:00 | AAPL | Stock | 14.0029 | 14.0064 | 14.0 | 14.0054 | 378168.0 |
| 2011-12-05 09:05:00 | AAPL | Stock | 14.0021 | 14.0071 | 14.0007 | 14.0043 | 81900.0 |
| 2011-12-05 09:10:00 | AAPL | Stock | 14.0036 | 14.0321 | 14.0032 | 14.0196 | 456344.0 |
| 2011-12-05 09:15:00 | AAPL | Stock | 14.0193 | 14.0207 | 14.0136 | 14.0143 | 147672.0 |
| 2011-12-05 09:20:00 | AAPL | Stock | 14.0161 | 14.0214 | 14.0118 | 14.0193 | 90944.0 |
| 2011-12-05 09:25:00 | AAPL | Stock | 14.0179 | 14.0639 | 14.0164 | 14.0532 | 1089676.0 |
| 2011-12-05 09:30:00 | AAPL | Stock | 14.0532 | 14.0864 | 14.0307 | 14.08 | 15459500.0 |
| 2011-12-05 09:35:00 | AAPL | Stock | 14.0792 | 14.0857 | 14.0536 | 14.0707 | 9496284.0 |
| 2011-12-05 09:40:00 | AAPL | Stock | 14.0704 | 14.075 | 14.0536 | 14.0732 | 7560252.0 |
| 2011-12-05 09:45:00 | AAPL | Stock | 14.0711 | 14.0786 | 14.0625 | 14.0775 | 5521348.0 |
| 2011-12-05 09:50:00 | AAPL | Stock | 14.0754 | 14.1025 | 14.0665 | 14.0921 | 6577368.0 |
| 2011-12-05 09:55:00 | AAPL | Stock | 14.0929 | 14.1221 | 14.0861 | 14.1079 | 8857856.0 |
| 2011-12-05 10:00:00 | AAPL | Stock | 14.1068 | 14.1136 | 14.0857 | 14.1089 | 7245644.0 |
| 2011-12-05 10:05:00 | AAPL | Stock | 14.1096 | 14.1118 | 14.09 | 14.1071 | 5316808.0 |
| 2011-12-05 10:10:00 | AAPL | Stock | 14.1071 | 14.135 | 14.1061 | 14.1343 | 7854280.0 |
| 2011-12-05 10:15:00 | AAPL | Stock | 14.135 | 14.14 | 14.1164 | 14.1186 | 4059664.0 |
| 2011-12-05 10:20:00 | AAPL | Stock | 14.1207 | 14.1389 | 14.1161 | 14.1295 | 4756416.0 |
| 2011-12-05 10:25:00 | AAPL | Stock | 14.1271 | 14.1389 | 14.1164 | 14.1239 | 4129524.0 |
> showing 50 of 330,749 rows — these rows as CSV