PREVIEW / stock_5min / 2011-08-25
file: by_date/stock_5min/2011/2011-08-25.parquet size: 4.8 MB rows: 326,135 symbols: 3,490
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-08-25 04:00:00 | AAPL | Stock | 12.7821 | 12.8214 | 12.75 | 12.7957 | 103684.0 |
| 2011-08-25 04:05:00 | AAPL | Stock | 12.8146 | 12.8146 | 12.7857 | 12.7946 | 161840.0 |
| 2011-08-25 04:10:00 | AAPL | Stock | 12.7946 | 12.8032 | 12.7857 | 12.8032 | 96460.0 |
| 2011-08-25 04:15:00 | AAPL | Stock | 12.8125 | 12.8393 | 12.8125 | 12.8393 | 58940.0 |
| 2011-08-25 04:20:00 | AAPL | Stock | 12.8393 | 12.8393 | 12.8214 | 12.8214 | 28280.0 |
| 2011-08-25 04:25:00 | AAPL | Stock | 12.8125 | 12.8125 | 12.8125 | 12.8125 | 5740.0 |
| 2011-08-25 04:30:00 | AAPL | Stock | 12.8125 | 12.8125 | 12.8071 | 12.8125 | 56980.0 |
| 2011-08-25 04:35:00 | AAPL | Stock | 12.8107 | 12.8125 | 12.8036 | 12.8036 | 22400.0 |
| 2011-08-25 04:40:00 | AAPL | Stock | 12.8068 | 12.8232 | 12.8068 | 12.8232 | 120260.0 |
| 2011-08-25 04:45:00 | AAPL | Stock | 12.8232 | 12.8232 | 12.8214 | 12.8214 | 11200.0 |
| 2011-08-25 04:50:00 | AAPL | Stock | 12.8214 | 12.8214 | 12.8214 | 12.8214 | 2800.0 |
| 2011-08-25 04:55:00 | AAPL | Stock | 12.8036 | 12.8179 | 12.7943 | 12.7943 | 28000.0 |
| 2011-08-25 05:00:00 | AAPL | Stock | 12.7861 | 12.7861 | 12.7857 | 12.7857 | 30100.0 |
| 2011-08-25 05:05:00 | AAPL | Stock | 12.7857 | 12.7857 | 12.7857 | 12.7857 | 2800.0 |
| 2011-08-25 05:10:00 | AAPL | Stock | 12.7857 | 12.7875 | 12.7857 | 12.7857 | 89040.0 |
| 2011-08-25 05:15:00 | AAPL | Stock | 12.7857 | 12.7861 | 12.7857 | 12.7861 | 50400.0 |
| 2011-08-25 05:25:00 | AAPL | Stock | 12.8036 | 12.8071 | 12.8036 | 12.8071 | 18760.0 |
| 2011-08-25 05:30:00 | AAPL | Stock | 12.8057 | 12.8143 | 12.7946 | 12.8054 | 30660.0 |
| 2011-08-25 05:35:00 | AAPL | Stock | 12.8036 | 12.8054 | 12.8036 | 12.8043 | 19600.0 |
| 2011-08-25 05:40:00 | AAPL | Stock | 12.8054 | 12.8054 | 12.7946 | 12.8 | 37800.0 |
| 2011-08-25 05:45:00 | AAPL | Stock | 12.805 | 12.825 | 12.805 | 12.825 | 256172.0 |
| 2011-08-25 05:50:00 | AAPL | Stock | 12.8218 | 12.8268 | 12.8125 | 12.8214 | 56280.0 |
| 2011-08-25 05:55:00 | AAPL | Stock | 12.8214 | 12.8214 | 12.8125 | 12.8125 | 8400.0 |
| 2011-08-25 06:00:00 | AAPL | Stock | 12.8218 | 12.8304 | 12.8218 | 12.8218 | 22400.0 |
| 2011-08-25 06:05:00 | AAPL | Stock | 12.8282 | 12.8464 | 12.8282 | 12.8464 | 55720.0 |
| 2011-08-25 06:10:00 | AAPL | Stock | 12.8443 | 12.8443 | 12.8214 | 12.8214 | 8400.0 |
| 2011-08-25 06:20:00 | AAPL | Stock | 12.8286 | 12.8571 | 12.8286 | 12.8571 | 222040.0 |
| 2011-08-25 06:25:00 | AAPL | Stock | 12.85 | 12.8786 | 12.85 | 12.8575 | 102480.0 |
| 2011-08-25 06:30:00 | AAPL | Stock | 12.8571 | 12.8782 | 12.8571 | 12.8782 | 26040.0 |
| 2011-08-25 06:35:00 | AAPL | Stock | 12.8746 | 12.9071 | 12.8746 | 12.8939 | 177800.0 |
| 2011-08-25 06:40:00 | AAPL | Stock | 12.9071 | 12.9071 | 12.8714 | 12.8714 | 81788.0 |
| 2011-08-25 06:45:00 | AAPL | Stock | 12.875 | 12.875 | 12.875 | 12.875 | 5600.0 |
| 2011-08-25 06:50:00 | AAPL | Stock | 12.8736 | 12.8821 | 12.8632 | 12.8679 | 39200.0 |
| 2011-08-25 06:55:00 | AAPL | Stock | 12.8571 | 12.8679 | 12.8482 | 12.8571 | 138460.0 |
| 2011-08-25 07:00:00 | AAPL | Stock | 12.8579 | 13.0357 | 12.8579 | 13.0143 | 1678208.0 |
| 2011-08-25 07:05:00 | AAPL | Stock | 13.0236 | 13.0714 | 13.0075 | 13.0361 | 2324420.0 |
| 2011-08-25 07:10:00 | AAPL | Stock | 13.0318 | 13.0714 | 13.0318 | 13.0464 | 884716.0 |
| 2011-08-25 07:15:00 | AAPL | Stock | 13.0464 | 13.0975 | 13.0393 | 13.0854 | 943796.0 |
| 2011-08-25 07:20:00 | AAPL | Stock | 13.0854 | 13.1029 | 13.0536 | 13.075 | 1831284.0 |
| 2011-08-25 07:25:00 | AAPL | Stock | 13.0779 | 13.0861 | 13.0536 | 13.0718 | 904540.0 |
| 2011-08-25 07:30:00 | AAPL | Stock | 13.0718 | 13.1143 | 13.0714 | 13.1132 | 1967588.0 |
| 2011-08-25 07:35:00 | AAPL | Stock | 13.1075 | 13.1132 | 13.0768 | 13.0868 | 995820.0 |
| 2011-08-25 07:40:00 | AAPL | Stock | 13.0771 | 13.1286 | 13.0714 | 13.125 | 1522332.0 |
| 2011-08-25 07:45:00 | AAPL | Stock | 13.1229 | 13.125 | 13.0714 | 13.1046 | 1016764.0 |
| 2011-08-25 07:50:00 | AAPL | Stock | 13.1036 | 13.1379 | 13.1 | 13.1068 | 1203720.0 |
| 2011-08-25 07:55:00 | AAPL | Stock | 13.1032 | 13.1175 | 13.0896 | 13.1136 | 698040.0 |
| 2011-08-25 08:00:00 | AAPL | Stock | 13.0497 | 13.1739 | 13.0497 | 13.1593 | 5313952.0 |
| 2011-08-25 08:05:00 | AAPL | Stock | 13.1618 | 13.2457 | 13.1586 | 13.2439 | 6369748.0 |
| 2011-08-25 08:10:00 | AAPL | Stock | 13.2375 | 13.2375 | 13.1879 | 13.2039 | 4816840.0 |
| 2011-08-25 08:15:00 | AAPL | Stock | 13.2025 | 13.2357 | 13.1757 | 13.1857 | 5203968.0 |
> showing 50 of 326,135 rows — these rows as CSV