PREVIEW / stock_5min / 2014-12-11
file: by_date/stock_5min/2014/2014-12-11.parquet size: 5.6 MB rows: 373,950 symbols: 3,571
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-11 04:00:00 | AAPL | Stock | 28.05 | 28.05 | 28.015 | 28.0375 | 18400.0 |
| 2014-12-11 04:05:00 | AAPL | Stock | 28.06 | 28.06 | 28.0575 | 28.0575 | 2400.0 |
| 2014-12-11 04:25:00 | AAPL | Stock | 28.0575 | 28.0575 | 28.0375 | 28.0375 | 3784.0 |
| 2014-12-11 04:30:00 | AAPL | Stock | 28.0375 | 28.0375 | 28.0375 | 28.0375 | 3064.0 |
| 2014-12-11 04:40:00 | AAPL | Stock | 28.0475 | 28.0475 | 28.0475 | 28.0475 | 800.0 |
| 2014-12-11 05:00:00 | AAPL | Stock | 28.0525 | 28.0525 | 28.0525 | 28.0525 | 2000.0 |
| 2014-12-11 05:05:00 | AAPL | Stock | 28.0525 | 28.0525 | 28.0375 | 28.0475 | 21440.0 |
| 2014-12-11 05:10:00 | AAPL | Stock | 28.045 | 28.0575 | 28.045 | 28.0475 | 1840.0 |
| 2014-12-11 05:15:00 | AAPL | Stock | 28.055 | 28.055 | 28.055 | 28.055 | 1200.0 |
| 2014-12-11 05:20:00 | AAPL | Stock | 28.055 | 28.07 | 28.05 | 28.0625 | 6320.0 |
| 2014-12-11 05:25:00 | AAPL | Stock | 28.06 | 28.06 | 28.05 | 28.05 | 14400.0 |
| 2014-12-11 05:30:00 | AAPL | Stock | 28.055 | 28.055 | 28.05 | 28.055 | 12400.0 |
| 2014-12-11 05:35:00 | AAPL | Stock | 28.0425 | 28.075 | 28.0425 | 28.075 | 3840.0 |
| 2014-12-11 05:40:00 | AAPL | Stock | 28.0525 | 28.0525 | 28.04 | 28.04 | 800.0 |
| 2014-12-11 06:10:00 | AAPL | Stock | 28.04 | 28.04 | 28.04 | 28.04 | 400.0 |
| 2014-12-11 06:15:00 | AAPL | Stock | 28.0375 | 28.0375 | 28.0375 | 28.0375 | 400.0 |
| 2014-12-11 06:25:00 | AAPL | Stock | 28.0575 | 28.0575 | 28.0375 | 28.0375 | 4200.0 |
| 2014-12-11 06:30:00 | AAPL | Stock | 28.03 | 28.03 | 28.03 | 28.03 | 3064.0 |
| 2014-12-11 06:45:00 | AAPL | Stock | 28.03 | 28.03 | 28.0075 | 28.0075 | 2800.0 |
| 2014-12-11 06:55:00 | AAPL | Stock | 28.0 | 28.0 | 27.9675 | 27.9675 | 5200.0 |
| 2014-12-11 07:00:00 | AAPL | Stock | 27.975 | 27.9925 | 27.9375 | 27.9375 | 12044.0 |
| 2014-12-11 07:05:00 | AAPL | Stock | 27.97 | 27.995 | 27.97 | 27.995 | 3388.0 |
| 2014-12-11 07:10:00 | AAPL | Stock | 28.0 | 28.0 | 27.975 | 27.975 | 13100.0 |
| 2014-12-11 07:15:00 | AAPL | Stock | 27.9775 | 27.995 | 27.9725 | 27.995 | 9188.0 |
| 2014-12-11 07:20:00 | AAPL | Stock | 27.9875 | 27.9875 | 27.9875 | 27.9875 | 3520.0 |
| 2014-12-11 07:25:00 | AAPL | Stock | 27.995 | 28.015 | 27.995 | 28.015 | 10748.0 |
| 2014-12-11 07:30:00 | AAPL | Stock | 28.01 | 28.045 | 28.0075 | 28.045 | 19068.0 |
| 2014-12-11 07:35:00 | AAPL | Stock | 28.03 | 28.0825 | 28.03 | 28.0825 | 17840.0 |
| 2014-12-11 07:40:00 | AAPL | Stock | 28.075 | 28.0875 | 28.075 | 28.0875 | 5200.0 |
| 2014-12-11 07:45:00 | AAPL | Stock | 28.0825 | 28.11 | 28.0825 | 28.0975 | 16984.0 |
| 2014-12-11 07:50:00 | AAPL | Stock | 28.0925 | 28.0925 | 28.0875 | 28.0875 | 8200.0 |
| 2014-12-11 07:55:00 | AAPL | Stock | 28.09 | 28.09 | 28.07 | 28.085 | 37480.0 |
| 2014-12-11 08:00:00 | AAPL | Stock | 28.0825 | 28.1075 | 27.97 | 28.095 | 86268.0 |
| 2014-12-11 08:05:00 | AAPL | Stock | 28.095 | 28.0975 | 28.0875 | 28.095 | 17868.0 |
| 2014-12-11 08:10:00 | AAPL | Stock | 28.0825 | 28.0875 | 28.0675 | 28.085 | 31720.0 |
| 2014-12-11 08:15:00 | AAPL | Stock | 28.085 | 28.085 | 28.0525 | 28.0675 | 77616.0 |
| 2014-12-11 08:20:00 | AAPL | Stock | 28.075 | 28.0875 | 28.075 | 28.08 | 13804.0 |
| 2014-12-11 08:25:00 | AAPL | Stock | 28.0922 | 28.0922 | 28.0825 | 28.0825 | 14416.0 |
| 2014-12-11 08:30:00 | AAPL | Stock | 28.0875 | 28.1475 | 28.0875 | 28.14 | 75384.0 |
| 2014-12-11 08:35:00 | AAPL | Stock | 28.14 | 28.1425 | 28.125 | 28.1375 | 59780.0 |
| 2014-12-11 08:40:00 | AAPL | Stock | 28.14 | 28.14 | 28.105 | 28.105 | 69700.0 |
| 2014-12-11 08:45:00 | AAPL | Stock | 28.1125 | 28.115 | 28.0675 | 28.085 | 29136.0 |
| 2014-12-11 08:50:00 | AAPL | Stock | 28.0875 | 28.11 | 28.0875 | 28.1075 | 71940.0 |
| 2014-12-11 08:55:00 | AAPL | Stock | 28.1125 | 28.1175 | 28.1 | 28.1175 | 23016.0 |
| 2014-12-11 09:00:00 | AAPL | Stock | 28.1125 | 28.125 | 28.11 | 28.125 | 82232.0 |
| 2014-12-11 09:05:00 | AAPL | Stock | 28.1225 | 28.125 | 28.1225 | 28.1228 | 17080.0 |
| 2014-12-11 09:10:00 | AAPL | Stock | 28.1225 | 28.125 | 28.1102 | 28.1175 | 35848.0 |
| 2014-12-11 09:15:00 | AAPL | Stock | 28.1175 | 28.125 | 28.1 | 28.1 | 32912.0 |
| 2014-12-11 09:20:00 | AAPL | Stock | 28.1 | 28.1175 | 28.095 | 28.1125 | 57480.0 |
| 2014-12-11 09:25:00 | AAPL | Stock | 28.11 | 28.125 | 28.0625 | 28.075 | 130516.0 |
> showing 50 of 373,950 rows — these rows as CSV