PREVIEW / stock_5min / 2007-12-21
file: by_date/stock_5min/2007/2007-12-21.parquet size: 4.7 MB rows: 343,499 symbols: 3,246
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-21 07:05:00 | AAPL | Stock | 6.8182 | 6.8182 | 6.8182 | 6.8182 | 28000.0 |
| 2007-12-21 07:10:00 | AAPL | Stock | 6.8036 | 6.8125 | 6.8036 | 6.8125 | 56000.0 |
| 2007-12-21 07:15:00 | AAPL | Stock | 6.8125 | 6.8214 | 6.8125 | 6.8214 | 88592.0 |
| 2007-12-21 07:20:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8107 | 6.8107 | 108640.0 |
| 2007-12-21 07:25:00 | AAPL | Stock | 6.8107 | 6.8107 | 6.8107 | 6.8107 | 216132.0 |
| 2007-12-21 07:30:00 | AAPL | Stock | 6.8075 | 6.8075 | 6.8075 | 6.8075 | 14000.0 |
| 2007-12-21 07:35:00 | AAPL | Stock | 6.8125 | 6.8125 | 6.805 | 6.8111 | 24780.0 |
| 2007-12-21 07:40:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8118 | 6.8118 | 25200.0 |
| 2007-12-21 07:45:00 | AAPL | Stock | 6.8125 | 6.8125 | 6.8125 | 6.8125 | 8400.0 |
| 2007-12-21 07:50:00 | AAPL | Stock | 6.8132 | 6.8132 | 6.8111 | 6.8111 | 53340.0 |
| 2007-12-21 07:55:00 | AAPL | Stock | 6.8107 | 6.8214 | 6.8043 | 6.8043 | 78820.0 |
| 2007-12-21 08:00:00 | AAPL | Stock | 6.8125 | 6.8214 | 6.8018 | 6.8161 | 905940.0 |
| 2007-12-21 08:05:00 | AAPL | Stock | 6.8154 | 6.8214 | 6.8125 | 6.8196 | 632016.0 |
| 2007-12-21 08:10:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8143 | 6.8207 | 205296.0 |
| 2007-12-21 08:15:00 | AAPL | Stock | 6.8214 | 6.8268 | 6.8125 | 6.8268 | 686280.0 |
| 2007-12-21 08:20:00 | AAPL | Stock | 6.8268 | 6.8289 | 6.8143 | 6.8196 | 844312.0 |
| 2007-12-21 08:25:00 | AAPL | Stock | 6.8164 | 6.8286 | 6.8164 | 6.8214 | 376152.0 |
| 2007-12-21 08:30:00 | AAPL | Stock | 6.8214 | 6.8304 | 6.8214 | 6.825 | 1764560.0 |
| 2007-12-21 08:35:00 | AAPL | Stock | 6.825 | 6.825 | 6.8214 | 6.8218 | 746844.0 |
| 2007-12-21 08:40:00 | AAPL | Stock | 6.8232 | 6.8264 | 6.8214 | 6.8225 | 1455160.0 |
| 2007-12-21 08:45:00 | AAPL | Stock | 6.8232 | 6.825 | 6.8214 | 6.8232 | 372960.0 |
| 2007-12-21 08:50:00 | AAPL | Stock | 6.8232 | 6.8321 | 6.8214 | 6.8304 | 324100.0 |
| 2007-12-21 08:55:00 | AAPL | Stock | 6.8279 | 6.8321 | 6.8254 | 6.8268 | 277060.0 |
| 2007-12-21 09:00:00 | AAPL | Stock | 6.8268 | 6.8325 | 6.825 | 6.8304 | 845124.0 |
| 2007-12-21 09:05:00 | AAPL | Stock | 6.8304 | 6.8339 | 6.8143 | 6.8143 | 825776.0 |
| 2007-12-21 09:10:00 | AAPL | Stock | 6.8136 | 6.8214 | 6.8136 | 6.8214 | 229236.0 |
| 2007-12-21 09:15:00 | AAPL | Stock | 6.8189 | 6.825 | 6.8189 | 6.8246 | 408408.0 |
| 2007-12-21 09:20:00 | AAPL | Stock | 6.8246 | 6.8268 | 6.8214 | 6.8232 | 300468.0 |
| 2007-12-21 09:25:00 | AAPL | Stock | 6.8232 | 6.8529 | 6.7821 | 6.7904 | 9166388.0 |
| 2007-12-21 09:30:00 | AAPL | Stock | 6.7904 | 6.8082 | 6.7818 | 6.7904 | 161820064.0 |
| 2007-12-21 09:35:00 | AAPL | Stock | 6.7889 | 6.8304 | 6.7886 | 6.8268 | 29361332.0 |
| 2007-12-21 09:40:00 | AAPL | Stock | 6.8268 | 6.83 | 6.8029 | 6.8163 | 21894040.0 |
| 2007-12-21 09:45:00 | AAPL | Stock | 6.8163 | 6.8304 | 6.8129 | 6.8268 | 17234728.0 |
| 2007-12-21 09:50:00 | AAPL | Stock | 6.8268 | 6.8293 | 6.8079 | 6.8143 | 14458304.0 |
| 2007-12-21 09:55:00 | AAPL | Stock | 6.8143 | 6.8157 | 6.8 | 6.8029 | 14300496.0 |
| 2007-12-21 10:00:00 | AAPL | Stock | 6.8032 | 6.825 | 6.8014 | 6.825 | 15285088.0 |
| 2007-12-21 10:05:00 | AAPL | Stock | 6.825 | 6.8346 | 6.8186 | 6.8282 | 16148412.0 |
| 2007-12-21 10:10:00 | AAPL | Stock | 6.8282 | 6.8557 | 6.8257 | 6.8554 | 19366928.0 |
| 2007-12-21 10:15:00 | AAPL | Stock | 6.855 | 6.8639 | 6.8482 | 6.8576 | 17955308.0 |
| 2007-12-21 10:20:00 | AAPL | Stock | 6.8575 | 6.8696 | 6.8554 | 6.8562 | 18767952.0 |
| 2007-12-21 10:25:00 | AAPL | Stock | 6.8557 | 6.8571 | 6.8407 | 6.8519 | 12359340.0 |
| 2007-12-21 10:30:00 | AAPL | Stock | 6.85 | 6.8564 | 6.8429 | 6.8439 | 7239344.0 |
| 2007-12-21 10:35:00 | AAPL | Stock | 6.8436 | 6.8496 | 6.8336 | 6.8439 | 8955660.0 |
| 2007-12-21 10:40:00 | AAPL | Stock | 6.8439 | 6.8471 | 6.8364 | 6.8457 | 7272552.0 |
| 2007-12-21 10:45:00 | AAPL | Stock | 6.8457 | 6.8536 | 6.8446 | 6.8489 | 7634956.0 |
| 2007-12-21 10:50:00 | AAPL | Stock | 6.8496 | 6.8514 | 6.8404 | 6.8464 | 7396620.0 |
| 2007-12-21 10:55:00 | AAPL | Stock | 6.8454 | 6.8568 | 6.8361 | 6.8525 | 10724112.0 |
| 2007-12-21 11:00:00 | AAPL | Stock | 6.8521 | 6.8588 | 6.8486 | 6.8588 | 7857780.0 |
| 2007-12-21 11:05:00 | AAPL | Stock | 6.8589 | 6.8707 | 6.8521 | 6.8661 | 13045256.0 |
| 2007-12-21 11:10:00 | AAPL | Stock | 6.8661 | 6.8689 | 6.8546 | 6.8586 | 9077320.0 |
> showing 50 of 343,499 rows — these rows as CSV