PREVIEW / stock_5min / 2009-08-05
file: by_date/stock_5min/2009/2009-08-05.parquet size: 4.7 MB rows: 325,314 symbols: 3,362
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-08-05 07:05:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 5600.0 |
| 2009-08-05 07:15:00 | AAPL | Stock | 5.9246 | 5.9246 | 5.9246 | 5.9246 | 4200.0 |
| 2009-08-05 07:45:00 | AAPL | Stock | 5.9018 | 5.9018 | 5.9018 | 5.9018 | 5600.0 |
| 2009-08-05 08:00:00 | AAPL | Stock | 5.9107 | 5.9179 | 5.8946 | 5.9179 | 81060.0 |
| 2009-08-05 08:05:00 | AAPL | Stock | 5.9196 | 5.9232 | 5.9146 | 5.9146 | 96152.0 |
| 2009-08-05 08:10:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.9143 | 5.9143 | 2800.0 |
| 2009-08-05 08:15:00 | AAPL | Stock | 5.9146 | 5.9214 | 5.9107 | 5.915 | 112924.0 |
| 2009-08-05 08:20:00 | AAPL | Stock | 5.9207 | 5.9254 | 5.9179 | 5.925 | 129416.0 |
| 2009-08-05 08:25:00 | AAPL | Stock | 5.9286 | 5.9364 | 5.9254 | 5.9321 | 189728.0 |
| 2009-08-05 08:30:00 | AAPL | Stock | 5.9314 | 5.9321 | 5.9143 | 5.925 | 191156.0 |
| 2009-08-05 08:35:00 | AAPL | Stock | 5.9282 | 5.9282 | 5.9186 | 5.9186 | 47600.0 |
| 2009-08-05 08:40:00 | AAPL | Stock | 5.9171 | 5.9246 | 5.915 | 5.9179 | 109900.0 |
| 2009-08-05 08:45:00 | AAPL | Stock | 5.9179 | 5.9275 | 5.9179 | 5.9264 | 114800.0 |
| 2009-08-05 08:50:00 | AAPL | Stock | 5.9261 | 5.9268 | 5.9261 | 5.9261 | 43400.0 |
| 2009-08-05 08:55:00 | AAPL | Stock | 5.9264 | 5.9286 | 5.9264 | 5.9268 | 136444.0 |
| 2009-08-05 09:00:00 | AAPL | Stock | 5.9254 | 5.9254 | 5.9239 | 5.9243 | 158200.0 |
| 2009-08-05 09:05:00 | AAPL | Stock | 5.9264 | 5.9282 | 5.9232 | 5.9279 | 100800.0 |
| 2009-08-05 09:10:00 | AAPL | Stock | 5.9232 | 5.9232 | 5.9229 | 5.9229 | 11200.0 |
| 2009-08-05 09:15:00 | AAPL | Stock | 5.9264 | 5.9271 | 5.9264 | 5.9271 | 10780.0 |
| 2009-08-05 09:20:00 | AAPL | Stock | 5.9271 | 5.9271 | 5.925 | 5.925 | 50400.0 |
| 2009-08-05 09:25:00 | AAPL | Stock | 5.925 | 5.925 | 5.9221 | 5.9221 | 22400.0 |
| 2009-08-05 09:30:00 | AAPL | Stock | 5.9214 | 5.9393 | 5.9189 | 5.9393 | 10591728.0 |
| 2009-08-05 09:35:00 | AAPL | Stock | 5.9375 | 5.9621 | 5.9375 | 5.9621 | 17624040.0 |
| 2009-08-05 09:40:00 | AAPL | Stock | 5.9621 | 5.9782 | 5.9554 | 5.9718 | 15101716.0 |
| 2009-08-05 09:45:00 | AAPL | Stock | 5.9714 | 5.975 | 5.9279 | 5.9511 | 14743792.0 |
| 2009-08-05 09:50:00 | AAPL | Stock | 5.9511 | 5.9555 | 5.9311 | 5.9418 | 11280248.0 |
| 2009-08-05 09:55:00 | AAPL | Stock | 5.9418 | 5.9425 | 5.9107 | 5.9236 | 9399096.0 |
| 2009-08-05 10:00:00 | AAPL | Stock | 5.9236 | 5.9239 | 5.9086 | 5.9164 | 9317644.0 |
| 2009-08-05 10:05:00 | AAPL | Stock | 5.9164 | 5.9268 | 5.915 | 5.9229 | 7847840.0 |
| 2009-08-05 10:10:00 | AAPL | Stock | 5.9218 | 5.9225 | 5.9071 | 5.9219 | 7625520.0 |
| 2009-08-05 10:15:00 | AAPL | Stock | 5.9218 | 5.9225 | 5.8893 | 5.8936 | 11423580.0 |
| 2009-08-05 10:20:00 | AAPL | Stock | 5.8939 | 5.9118 | 5.8886 | 5.9107 | 7576492.0 |
| 2009-08-05 10:25:00 | AAPL | Stock | 5.9111 | 5.9218 | 5.9104 | 5.92 | 4511444.0 |
| 2009-08-05 10:30:00 | AAPL | Stock | 5.9193 | 5.9201 | 5.9114 | 5.9133 | 4109420.0 |
| 2009-08-05 10:35:00 | AAPL | Stock | 5.9136 | 5.9171 | 5.9039 | 5.9046 | 5059180.0 |
| 2009-08-05 10:40:00 | AAPL | Stock | 5.9054 | 5.9089 | 5.8946 | 5.8964 | 5028940.0 |
| 2009-08-05 10:45:00 | AAPL | Stock | 5.8961 | 5.8996 | 5.8893 | 5.8979 | 5777520.0 |
| 2009-08-05 10:50:00 | AAPL | Stock | 5.8982 | 5.8989 | 5.8929 | 5.8971 | 3579380.0 |
| 2009-08-05 10:55:00 | AAPL | Stock | 5.8968 | 5.8993 | 5.8904 | 5.8932 | 4268236.0 |
| 2009-08-05 11:00:00 | AAPL | Stock | 5.8936 | 5.8982 | 5.8893 | 5.8968 | 5120136.0 |
| 2009-08-05 11:05:00 | AAPL | Stock | 5.8964 | 5.9075 | 5.8893 | 5.9064 | 5139624.0 |
| 2009-08-05 11:10:00 | AAPL | Stock | 5.9061 | 5.9089 | 5.8989 | 5.9036 | 2781212.0 |
| 2009-08-05 11:15:00 | AAPL | Stock | 5.9036 | 5.9036 | 5.8921 | 5.8936 | 2493036.0 |
| 2009-08-05 11:20:00 | AAPL | Stock | 5.8944 | 5.8954 | 5.8821 | 5.8821 | 4892468.0 |
| 2009-08-05 11:25:00 | AAPL | Stock | 5.8821 | 5.8918 | 5.8821 | 5.8889 | 2743300.0 |
| 2009-08-05 11:30:00 | AAPL | Stock | 5.8886 | 5.8957 | 5.8839 | 5.8942 | 4023432.0 |
| 2009-08-05 11:35:00 | AAPL | Stock | 5.8936 | 5.8957 | 5.8786 | 5.8857 | 5851496.0 |
| 2009-08-05 11:40:00 | AAPL | Stock | 5.8846 | 5.8918 | 5.8825 | 5.8862 | 2483012.0 |
| 2009-08-05 11:45:00 | AAPL | Stock | 5.8864 | 5.8879 | 5.8814 | 5.8864 | 2158996.0 |
| 2009-08-05 11:50:00 | AAPL | Stock | 5.8861 | 5.8921 | 5.8857 | 5.8875 | 1829576.0 |
> showing 50 of 325,314 rows — these rows as CSV