PREVIEW / stock_5min / 2011-12-14
file: by_date/stock_5min/2011/2011-12-14.parquet size: 4.9 MB rows: 332,821 symbols: 3,530
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-14 04:20:00 | AAPL | Stock | 13.9054 | 13.9054 | 13.9046 | 13.9046 | 5600.0 |
| 2011-12-14 04:25:00 | AAPL | Stock | 13.9011 | 13.9011 | 13.9011 | 13.9011 | 5600.0 |
| 2011-12-14 04:45:00 | AAPL | Stock | 13.9004 | 13.9004 | 13.9004 | 13.9004 | 2800.0 |
| 2011-12-14 04:50:00 | AAPL | Stock | 13.9014 | 13.9014 | 13.9014 | 13.9014 | 2800.0 |
| 2011-12-14 05:05:00 | AAPL | Stock | 13.9146 | 13.9146 | 13.9146 | 13.9146 | 2800.0 |
| 2011-12-14 06:10:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 8400.0 |
| 2011-12-14 06:15:00 | AAPL | Stock | 13.8821 | 13.8821 | 13.8821 | 13.8821 | 2800.0 |
| 2011-12-14 06:35:00 | AAPL | Stock | 13.8857 | 13.8857 | 13.8857 | 13.8857 | 9800.0 |
| 2011-12-14 06:40:00 | AAPL | Stock | 13.8857 | 13.8857 | 13.8857 | 13.8857 | 11200.0 |
| 2011-12-14 06:55:00 | AAPL | Stock | 13.8857 | 13.8857 | 13.8857 | 13.8857 | 2800.0 |
| 2011-12-14 07:10:00 | AAPL | Stock | 13.8536 | 13.8536 | 13.8536 | 13.8536 | 2800.0 |
| 2011-12-14 07:15:00 | AAPL | Stock | 13.85 | 13.85 | 13.85 | 13.85 | 2800.0 |
| 2011-12-14 07:30:00 | AAPL | Stock | 13.8571 | 13.9039 | 13.8571 | 13.8929 | 30800.0 |
| 2011-12-14 07:35:00 | AAPL | Stock | 13.8771 | 13.8771 | 13.875 | 13.875 | 13300.0 |
| 2011-12-14 07:40:00 | AAPL | Stock | 13.8664 | 13.875 | 13.8643 | 13.8643 | 16800.0 |
| 2011-12-14 07:45:00 | AAPL | Stock | 13.8743 | 13.8743 | 13.8743 | 13.8743 | 7000.0 |
| 2011-12-14 07:50:00 | AAPL | Stock | 13.8714 | 13.8714 | 13.8714 | 13.8714 | 2800.0 |
| 2011-12-14 07:55:00 | AAPL | Stock | 13.8754 | 13.8754 | 13.8754 | 13.8754 | 2800.0 |
| 2011-12-14 08:00:00 | AAPL | Stock | 13.8768 | 13.8843 | 13.875 | 13.875 | 109200.0 |
| 2011-12-14 08:05:00 | AAPL | Stock | 13.8786 | 13.9239 | 13.8786 | 13.9239 | 197540.0 |
| 2011-12-14 08:10:00 | AAPL | Stock | 13.9239 | 13.9239 | 13.9 | 13.9 | 23800.0 |
| 2011-12-14 08:15:00 | AAPL | Stock | 13.9107 | 13.9107 | 13.9107 | 13.9107 | 8400.0 |
| 2011-12-14 08:20:00 | AAPL | Stock | 13.915 | 13.9218 | 13.9054 | 13.9143 | 148708.0 |
| 2011-12-14 08:25:00 | AAPL | Stock | 13.9193 | 13.935 | 13.9107 | 13.935 | 126140.0 |
| 2011-12-14 08:30:00 | AAPL | Stock | 13.9346 | 13.9443 | 13.9218 | 13.9393 | 160412.0 |
| 2011-12-14 08:35:00 | AAPL | Stock | 13.9271 | 13.9393 | 13.9271 | 13.9361 | 91672.0 |
| 2011-12-14 08:40:00 | AAPL | Stock | 13.9375 | 13.9375 | 13.9286 | 13.9286 | 34412.0 |
| 2011-12-14 08:45:00 | AAPL | Stock | 13.9286 | 13.9286 | 13.9286 | 13.9286 | 2800.0 |
| 2011-12-14 08:50:00 | AAPL | Stock | 13.9261 | 13.9261 | 13.9082 | 13.9143 | 186536.0 |
| 2011-12-14 08:55:00 | AAPL | Stock | 13.9086 | 13.9143 | 13.9018 | 13.9021 | 127344.0 |
| 2011-12-14 09:00:00 | AAPL | Stock | 13.9021 | 13.9021 | 13.8861 | 13.8864 | 146328.0 |
| 2011-12-14 09:05:00 | AAPL | Stock | 13.8861 | 13.8864 | 13.865 | 13.8786 | 362040.0 |
| 2011-12-14 09:10:00 | AAPL | Stock | 13.8761 | 13.8761 | 13.8393 | 13.8536 | 244496.0 |
| 2011-12-14 09:15:00 | AAPL | Stock | 13.8546 | 13.8571 | 13.8482 | 13.8482 | 33600.0 |
| 2011-12-14 09:20:00 | AAPL | Stock | 13.8454 | 13.8471 | 13.8393 | 13.8436 | 37828.0 |
| 2011-12-14 09:25:00 | AAPL | Stock | 13.8471 | 13.8554 | 13.8061 | 13.8114 | 1072008.0 |
| 2011-12-14 09:30:00 | AAPL | Stock | 13.8179 | 13.835 | 13.7696 | 13.7836 | 13276004.0 |
| 2011-12-14 09:35:00 | AAPL | Stock | 13.7786 | 13.7832 | 13.7543 | 13.7711 | 8614788.0 |
| 2011-12-14 09:40:00 | AAPL | Stock | 13.7714 | 13.81 | 13.7696 | 13.7714 | 12507936.0 |
| 2011-12-14 09:45:00 | AAPL | Stock | 13.7721 | 13.7811 | 13.6596 | 13.6746 | 20352108.0 |
| 2011-12-14 09:50:00 | AAPL | Stock | 13.6764 | 13.7143 | 13.6539 | 13.7071 | 16648604.0 |
| 2011-12-14 09:55:00 | AAPL | Stock | 13.71 | 13.7214 | 13.6943 | 13.7098 | 8757280.0 |
| 2011-12-14 10:00:00 | AAPL | Stock | 13.7057 | 13.7111 | 13.6714 | 13.6882 | 7218260.0 |
| 2011-12-14 10:05:00 | AAPL | Stock | 13.6861 | 13.7021 | 13.65 | 13.6546 | 9468088.0 |
| 2011-12-14 10:10:00 | AAPL | Stock | 13.655 | 13.655 | 13.6054 | 13.6114 | 10998344.0 |
| 2011-12-14 10:15:00 | AAPL | Stock | 13.6082 | 13.6379 | 13.6082 | 13.6343 | 6183016.0 |
| 2011-12-14 10:20:00 | AAPL | Stock | 13.6314 | 13.6507 | 13.5943 | 13.6229 | 8599948.0 |
| 2011-12-14 10:25:00 | AAPL | Stock | 13.6229 | 13.6511 | 13.6079 | 13.6414 | 5517400.0 |
| 2011-12-14 10:30:00 | AAPL | Stock | 13.6461 | 13.6471 | 13.6086 | 13.6146 | 5331396.0 |
| 2011-12-14 10:35:00 | AAPL | Stock | 13.6136 | 13.6696 | 13.6136 | 13.6568 | 6568016.0 |
> showing 50 of 332,821 rows — these rows as CSV