PREVIEW / stock_5min / 2009-06-04
file: by_date/stock_5min/2009/2009-06-04.parquet size: 4.7 MB rows: 323,622 symbols: 3,347
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-06-04 05:35:00 | AAPL | Stock | 5.0786 | 5.0786 | 5.0786 | 5.0786 | 2800.0 |
| 2009-06-04 06:05:00 | AAPL | Stock | 5.0232 | 5.0232 | 5.0232 | 5.0232 | 9100.0 |
| 2009-06-04 06:20:00 | AAPL | Stock | 5.0286 | 5.0321 | 5.0286 | 5.0321 | 22400.0 |
| 2009-06-04 07:00:00 | AAPL | Stock | 5.0357 | 5.0357 | 5.0186 | 5.0186 | 19180.0 |
| 2009-06-04 07:05:00 | AAPL | Stock | 5.0179 | 5.0179 | 5.0089 | 5.0107 | 197652.0 |
| 2009-06-04 07:10:00 | AAPL | Stock | 5.0107 | 5.0107 | 5.0107 | 5.0107 | 67200.0 |
| 2009-06-04 07:15:00 | AAPL | Stock | 5.0161 | 5.0161 | 5.0161 | 5.0161 | 2800.0 |
| 2009-06-04 07:20:00 | AAPL | Stock | 5.0161 | 5.0161 | 5.0161 | 5.0161 | 2800.0 |
| 2009-06-04 07:30:00 | AAPL | Stock | 5.0161 | 5.0161 | 5.0161 | 5.0161 | 2800.0 |
| 2009-06-04 07:35:00 | AAPL | Stock | 5.0111 | 5.0111 | 5.0107 | 5.0107 | 11200.0 |
| 2009-06-04 07:40:00 | AAPL | Stock | 5.0132 | 5.0175 | 5.0107 | 5.0175 | 15400.0 |
| 2009-06-04 07:45:00 | AAPL | Stock | 5.0175 | 5.0175 | 5.0139 | 5.0139 | 53200.0 |
| 2009-06-04 07:50:00 | AAPL | Stock | 5.0268 | 5.0275 | 5.0179 | 5.0275 | 25200.0 |
| 2009-06-04 07:55:00 | AAPL | Stock | 5.0196 | 5.0196 | 5.0143 | 5.0143 | 66444.0 |
| 2009-06-04 08:00:00 | AAPL | Stock | 5.0179 | 5.0268 | 5.0061 | 5.0061 | 361172.0 |
| 2009-06-04 08:05:00 | AAPL | Stock | 5.0071 | 5.0136 | 5.0032 | 5.0125 | 283052.0 |
| 2009-06-04 08:10:00 | AAPL | Stock | 5.0225 | 5.0225 | 5.0143 | 5.0179 | 86800.0 |
| 2009-06-04 08:15:00 | AAPL | Stock | 5.0146 | 5.0146 | 5.0111 | 5.0111 | 33348.0 |
| 2009-06-04 08:20:00 | AAPL | Stock | 5.0118 | 5.0161 | 5.0107 | 5.0136 | 463344.0 |
| 2009-06-04 08:25:00 | AAPL | Stock | 5.0179 | 5.0179 | 5.0161 | 5.0161 | 88144.0 |
| 2009-06-04 08:30:00 | AAPL | Stock | 5.0189 | 5.0296 | 5.0143 | 5.0246 | 166376.0 |
| 2009-06-04 08:35:00 | AAPL | Stock | 5.0246 | 5.0293 | 5.0214 | 5.0268 | 196000.0 |
| 2009-06-04 08:40:00 | AAPL | Stock | 5.0236 | 5.0236 | 5.0168 | 5.0168 | 197680.0 |
| 2009-06-04 08:45:00 | AAPL | Stock | 5.0168 | 5.0218 | 5.0107 | 5.0107 | 288288.0 |
| 2009-06-04 08:50:00 | AAPL | Stock | 5.0143 | 5.0143 | 5.0107 | 5.0107 | 266000.0 |
| 2009-06-04 08:55:00 | AAPL | Stock | 5.0093 | 5.0093 | 5.0043 | 5.0089 | 634508.0 |
| 2009-06-04 09:00:00 | AAPL | Stock | 5.0089 | 5.0111 | 5.0 | 5.0054 | 839132.0 |
| 2009-06-04 09:05:00 | AAPL | Stock | 5.0036 | 5.0089 | 5.0018 | 5.0068 | 309680.0 |
| 2009-06-04 09:10:00 | AAPL | Stock | 5.0068 | 5.0068 | 4.9971 | 5.0032 | 718228.0 |
| 2009-06-04 09:15:00 | AAPL | Stock | 5.0032 | 5.0339 | 5.0014 | 5.0036 | 236852.0 |
| 2009-06-04 09:20:00 | AAPL | Stock | 5.0011 | 5.0014 | 4.9964 | 5.0 | 236936.0 |
| 2009-06-04 09:25:00 | AAPL | Stock | 4.9986 | 5.005 | 4.9946 | 5.005 | 610876.0 |
| 2009-06-04 09:30:00 | AAPL | Stock | 5.0046 | 5.05 | 5.0014 | 5.0496 | 23693488.0 |
| 2009-06-04 09:35:00 | AAPL | Stock | 5.05 | 5.0711 | 5.045 | 5.0675 | 23082136.0 |
| 2009-06-04 09:40:00 | AAPL | Stock | 5.0672 | 5.0961 | 5.0661 | 5.0839 | 24457832.0 |
| 2009-06-04 09:45:00 | AAPL | Stock | 5.0836 | 5.0911 | 5.0654 | 5.0693 | 14080752.0 |
| 2009-06-04 09:50:00 | AAPL | Stock | 5.0682 | 5.0914 | 5.0679 | 5.0901 | 13455568.0 |
| 2009-06-04 09:55:00 | AAPL | Stock | 5.0911 | 5.1121 | 5.0836 | 5.1079 | 18735752.0 |
| 2009-06-04 10:00:00 | AAPL | Stock | 5.1079 | 5.12 | 5.105 | 5.1111 | 17028816.0 |
| 2009-06-04 10:05:00 | AAPL | Stock | 5.1107 | 5.1161 | 5.0993 | 5.1136 | 13325844.0 |
| 2009-06-04 10:10:00 | AAPL | Stock | 5.1149 | 5.1286 | 5.1107 | 5.1254 | 13829144.0 |
| 2009-06-04 10:15:00 | AAPL | Stock | 5.125 | 5.1261 | 5.1111 | 5.116 | 10381560.0 |
| 2009-06-04 10:20:00 | AAPL | Stock | 5.1154 | 5.1232 | 5.1107 | 5.1164 | 8867712.0 |
| 2009-06-04 10:25:00 | AAPL | Stock | 5.1157 | 5.1182 | 5.0989 | 5.1086 | 10807440.0 |
| 2009-06-04 10:30:00 | AAPL | Stock | 5.1086 | 5.1161 | 5.1029 | 5.1114 | 7119000.0 |
| 2009-06-04 10:35:00 | AAPL | Stock | 5.1114 | 5.1196 | 5.1071 | 5.1182 | 5637800.0 |
| 2009-06-04 10:40:00 | AAPL | Stock | 5.1189 | 5.1204 | 5.1054 | 5.1068 | 6562948.0 |
| 2009-06-04 10:45:00 | AAPL | Stock | 5.1071 | 5.1114 | 5.1007 | 5.1079 | 5807284.0 |
| 2009-06-04 10:50:00 | AAPL | Stock | 5.1079 | 5.1179 | 5.1036 | 5.113 | 6232240.0 |
| 2009-06-04 10:55:00 | AAPL | Stock | 5.1121 | 5.1189 | 5.1121 | 5.1171 | 5153456.0 |
> showing 50 of 323,622 rows — these rows as CSV