PREVIEW / stock_5min / 2009-12-21
file: by_date/stock_5min/2009/2009-12-21.parquet size: 4.8 MB rows: 327,533 symbols: 3,457
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-21 05:55:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 5600.0 |
| 2009-12-21 07:00:00 | AAPL | Stock | 6.9911 | 6.9911 | 6.9911 | 6.9911 | 25984.0 |
| 2009-12-21 07:10:00 | AAPL | Stock | 6.9914 | 7.0036 | 6.9914 | 7.0036 | 53424.0 |
| 2009-12-21 07:15:00 | AAPL | Stock | 7.0089 | 7.0089 | 7.0089 | 7.0089 | 11200.0 |
| 2009-12-21 07:20:00 | AAPL | Stock | 7.0089 | 7.0232 | 7.0089 | 7.0232 | 46200.0 |
| 2009-12-21 07:25:00 | AAPL | Stock | 7.0179 | 7.0243 | 7.0146 | 7.0229 | 33600.0 |
| 2009-12-21 07:30:00 | AAPL | Stock | 7.0229 | 7.0229 | 7.0229 | 7.0229 | 2800.0 |
| 2009-12-21 07:35:00 | AAPL | Stock | 7.0179 | 7.0179 | 7.0129 | 7.0129 | 154000.0 |
| 2009-12-21 07:40:00 | AAPL | Stock | 7.0129 | 7.0186 | 7.0129 | 7.0186 | 21000.0 |
| 2009-12-21 07:45:00 | AAPL | Stock | 7.0186 | 7.0186 | 7.0186 | 7.0186 | 21308.0 |
| 2009-12-21 07:50:00 | AAPL | Stock | 7.0129 | 7.0129 | 7.0129 | 7.0129 | 16800.0 |
| 2009-12-21 07:55:00 | AAPL | Stock | 7.0186 | 7.0186 | 7.0154 | 7.0186 | 13776.0 |
| 2009-12-21 08:00:00 | AAPL | Stock | 7.0129 | 7.0186 | 7.0036 | 7.0107 | 544544.0 |
| 2009-12-21 08:05:00 | AAPL | Stock | 7.0129 | 7.0132 | 7.0025 | 7.0039 | 365568.0 |
| 2009-12-21 08:10:00 | AAPL | Stock | 7.0054 | 7.0068 | 6.9961 | 6.9968 | 164920.0 |
| 2009-12-21 08:15:00 | AAPL | Stock | 6.9968 | 6.9968 | 6.9807 | 6.9854 | 117236.0 |
| 2009-12-21 08:20:00 | AAPL | Stock | 6.9854 | 6.9907 | 6.9779 | 6.9807 | 760200.0 |
| 2009-12-21 08:25:00 | AAPL | Stock | 6.9807 | 6.9929 | 6.9807 | 6.9929 | 231560.0 |
| 2009-12-21 08:30:00 | AAPL | Stock | 6.9911 | 6.995 | 6.9864 | 6.9929 | 385672.0 |
| 2009-12-21 08:35:00 | AAPL | Stock | 6.9954 | 6.9964 | 6.9914 | 6.9964 | 43512.0 |
| 2009-12-21 08:40:00 | AAPL | Stock | 6.9989 | 6.9996 | 6.9957 | 6.9964 | 149996.0 |
| 2009-12-21 08:45:00 | AAPL | Stock | 6.9964 | 7.0 | 6.995 | 6.9982 | 341040.0 |
| 2009-12-21 08:50:00 | AAPL | Stock | 7.0 | 7.005 | 7.0 | 7.0 | 126252.0 |
| 2009-12-21 08:55:00 | AAPL | Stock | 7.0029 | 7.0036 | 6.9989 | 7.0 | 265216.0 |
| 2009-12-21 09:00:00 | AAPL | Stock | 7.0 | 7.0071 | 7.0 | 7.0071 | 170072.0 |
| 2009-12-21 09:05:00 | AAPL | Stock | 7.0068 | 7.0089 | 7.0046 | 7.0054 | 405244.0 |
| 2009-12-21 09:10:00 | AAPL | Stock | 7.0061 | 7.0061 | 7.0036 | 7.0036 | 125860.0 |
| 2009-12-21 09:15:00 | AAPL | Stock | 7.0018 | 7.0021 | 7.0007 | 7.0007 | 110376.0 |
| 2009-12-21 09:20:00 | AAPL | Stock | 7.0004 | 7.0004 | 6.9989 | 6.9993 | 178780.0 |
| 2009-12-21 09:25:00 | AAPL | Stock | 7.0 | 7.0036 | 7.0 | 7.0 | 199416.0 |
| 2009-12-21 09:30:00 | AAPL | Stock | 7.0018 | 7.0321 | 6.9882 | 7.0039 | 18562432.0 |
| 2009-12-21 09:35:00 | AAPL | Stock | 7.0054 | 7.0293 | 7.0043 | 7.0207 | 8097628.0 |
| 2009-12-21 09:40:00 | AAPL | Stock | 7.021 | 7.0268 | 7.0093 | 7.0121 | 7700448.0 |
| 2009-12-21 09:45:00 | AAPL | Stock | 7.0129 | 7.0179 | 7.0039 | 7.009 | 6885172.0 |
| 2009-12-21 09:50:00 | AAPL | Stock | 7.0089 | 7.0411 | 7.0064 | 7.035 | 12404280.0 |
| 2009-12-21 09:55:00 | AAPL | Stock | 7.0351 | 7.0604 | 7.0293 | 7.0582 | 11634112.0 |
| 2009-12-21 10:00:00 | AAPL | Stock | 7.0596 | 7.1129 | 7.0579 | 7.105 | 25692828.0 |
| 2009-12-21 10:05:00 | AAPL | Stock | 7.105 | 7.1075 | 7.0889 | 7.0997 | 13170108.0 |
| 2009-12-21 10:10:00 | AAPL | Stock | 7.0996 | 7.1136 | 7.0961 | 7.1118 | 12437628.0 |
| 2009-12-21 10:15:00 | AAPL | Stock | 7.1118 | 7.1196 | 7.1071 | 7.1157 | 7716548.0 |
| 2009-12-21 10:20:00 | AAPL | Stock | 7.1151 | 7.1339 | 7.1125 | 7.1279 | 13117580.0 |
| 2009-12-21 10:25:00 | AAPL | Stock | 7.1279 | 7.1304 | 7.1054 | 7.1066 | 9501548.0 |
| 2009-12-21 10:30:00 | AAPL | Stock | 7.1064 | 7.1107 | 7.1007 | 7.1071 | 5548452.0 |
| 2009-12-21 10:35:00 | AAPL | Stock | 7.1071 | 7.11 | 7.1039 | 7.1048 | 3874640.0 |
| 2009-12-21 10:40:00 | AAPL | Stock | 7.1039 | 7.1121 | 7.0982 | 7.1 | 4453708.0 |
| 2009-12-21 10:45:00 | AAPL | Stock | 7.1018 | 7.1068 | 7.0889 | 7.1018 | 6886516.0 |
| 2009-12-21 10:50:00 | AAPL | Stock | 7.1025 | 7.1068 | 7.0964 | 7.1064 | 3922632.0 |
| 2009-12-21 10:55:00 | AAPL | Stock | 7.1061 | 7.1071 | 7.0957 | 7.1032 | 4338740.0 |
| 2009-12-21 11:00:00 | AAPL | Stock | 7.1021 | 7.1132 | 7.1018 | 7.1121 | 4469444.0 |
| 2009-12-21 11:05:00 | AAPL | Stock | 7.1121 | 7.1279 | 7.1111 | 7.1221 | 8586340.0 |
> showing 50 of 327,533 rows — these rows as CSV