PREVIEW / stock_5min / 2017-04-21
file: by_date/stock_5min/2017/2017-04-21.parquet size: 5.3 MB rows: 348,087 symbols: 3,049
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-21 05:10:00 | AAPL | Stock | 35.5775 | 35.5775 | 35.5775 | 35.5775 | 400.0 |
| 2017-04-21 05:50:00 | AAPL | Stock | 35.625 | 35.625 | 35.625 | 35.625 | 1600.0 |
| 2017-04-21 05:55:00 | AAPL | Stock | 35.58 | 35.58 | 35.58 | 35.58 | 400.0 |
| 2017-04-21 06:05:00 | AAPL | Stock | 35.625 | 35.625 | 35.625 | 35.625 | 400.0 |
| 2017-04-21 06:20:00 | AAPL | Stock | 35.6225 | 35.6225 | 35.62 | 35.6225 | 3440.0 |
| 2017-04-21 06:55:00 | AAPL | Stock | 35.62 | 35.62 | 35.62 | 35.62 | 400.0 |
| 2017-04-21 07:00:00 | AAPL | Stock | 35.62 | 35.625 | 35.62 | 35.625 | 4480.0 |
| 2017-04-21 07:05:00 | AAPL | Stock | 35.6475 | 35.65 | 35.63 | 35.65 | 7660.0 |
| 2017-04-21 07:10:00 | AAPL | Stock | 35.6625 | 35.675 | 35.6625 | 35.675 | 7508.0 |
| 2017-04-21 07:25:00 | AAPL | Stock | 35.655 | 35.655 | 35.65 | 35.65 | 5200.0 |
| 2017-04-21 07:30:00 | AAPL | Stock | 35.6375 | 35.6375 | 35.6325 | 35.6325 | 2000.0 |
| 2017-04-21 07:35:00 | AAPL | Stock | 35.6375 | 35.6375 | 35.6375 | 35.6375 | 400.0 |
| 2017-04-21 07:40:00 | AAPL | Stock | 35.6325 | 35.6325 | 35.6325 | 35.6325 | 400.0 |
| 2017-04-21 08:00:00 | AAPL | Stock | 35.6575 | 35.67 | 35.6125 | 35.6125 | 32708.0 |
| 2017-04-21 08:05:00 | AAPL | Stock | 35.6225 | 35.6225 | 35.61 | 35.6225 | 8044.0 |
| 2017-04-21 08:10:00 | AAPL | Stock | 35.6225 | 35.635 | 35.6225 | 35.635 | 4100.0 |
| 2017-04-21 08:15:00 | AAPL | Stock | 35.635 | 35.635 | 35.635 | 35.635 | 1400.0 |
| 2017-04-21 08:25:00 | AAPL | Stock | 35.625 | 35.625 | 35.625 | 35.625 | 1600.0 |
| 2017-04-21 08:30:00 | AAPL | Stock | 35.635 | 35.635 | 35.635 | 35.635 | 888.0 |
| 2017-04-21 08:40:00 | AAPL | Stock | 35.625 | 35.6325 | 35.625 | 35.6275 | 6800.0 |
| 2017-04-21 08:45:00 | AAPL | Stock | 35.6325 | 35.6325 | 35.6325 | 35.6325 | 400.0 |
| 2017-04-21 08:50:00 | AAPL | Stock | 35.63 | 35.63 | 35.615 | 35.615 | 10804.0 |
| 2017-04-21 08:55:00 | AAPL | Stock | 35.625 | 35.625 | 35.625 | 35.625 | 6000.0 |
| 2017-04-21 09:00:00 | AAPL | Stock | 35.625 | 35.625 | 35.62 | 35.625 | 12620.0 |
| 2017-04-21 09:05:00 | AAPL | Stock | 35.625 | 35.625 | 35.615 | 35.615 | 17052.0 |
| 2017-04-21 09:10:00 | AAPL | Stock | 35.615 | 35.63 | 35.615 | 35.625 | 18896.0 |
| 2017-04-21 09:15:00 | AAPL | Stock | 35.625 | 35.635 | 35.625 | 35.635 | 3200.0 |
| 2017-04-21 09:20:00 | AAPL | Stock | 35.625 | 35.625 | 35.6175 | 35.6175 | 6820.0 |
| 2017-04-21 09:25:00 | AAPL | Stock | 35.62 | 35.6425 | 35.615 | 35.625 | 102708.0 |
| 2017-04-21 09:30:00 | AAPL | Stock | 35.61 | 35.64 | 35.55 | 35.565 | 6919944.0 |
| 2017-04-21 09:35:00 | AAPL | Stock | 35.565 | 35.6375 | 35.545 | 35.6225 | 1531880.0 |
| 2017-04-21 09:40:00 | AAPL | Stock | 35.625 | 35.6605 | 35.61 | 35.6375 | 1689424.0 |
| 2017-04-21 09:45:00 | AAPL | Stock | 35.6342 | 35.67 | 35.6175 | 35.625 | 1611744.0 |
| 2017-04-21 09:50:00 | AAPL | Stock | 35.6275 | 35.6375 | 35.5275 | 35.5375 | 1571660.0 |
| 2017-04-21 09:55:00 | AAPL | Stock | 35.5362 | 35.5872 | 35.535 | 35.54 | 1295800.0 |
| 2017-04-21 10:00:00 | AAPL | Stock | 35.54 | 35.585 | 35.54 | 35.5525 | 889556.0 |
| 2017-04-21 10:05:00 | AAPL | Stock | 35.5525 | 35.605 | 35.5525 | 35.5975 | 914128.0 |
| 2017-04-21 10:10:00 | AAPL | Stock | 35.5975 | 35.6 | 35.54 | 35.55 | 681416.0 |
| 2017-04-21 10:15:00 | AAPL | Stock | 35.5475 | 35.625 | 35.545 | 35.6075 | 736184.0 |
| 2017-04-21 10:20:00 | AAPL | Stock | 35.6075 | 35.6275 | 35.6 | 35.625 | 522976.0 |
| 2017-04-21 10:25:00 | AAPL | Stock | 35.625 | 35.625 | 35.575 | 35.594 | 640172.0 |
| 2017-04-21 10:30:00 | AAPL | Stock | 35.5945 | 35.6225 | 35.59 | 35.6175 | 603628.0 |
| 2017-04-21 10:35:00 | AAPL | Stock | 35.6162 | 35.6175 | 35.57 | 35.5838 | 615664.0 |
| 2017-04-21 10:40:00 | AAPL | Stock | 35.5825 | 35.62 | 35.5825 | 35.605 | 571076.0 |
| 2017-04-21 10:45:00 | AAPL | Stock | 35.605 | 35.6225 | 35.585 | 35.5888 | 405464.0 |
| 2017-04-21 10:50:00 | AAPL | Stock | 35.5875 | 35.6075 | 35.585 | 35.5975 | 408992.0 |
| 2017-04-21 10:55:00 | AAPL | Stock | 35.595 | 35.5988 | 35.5675 | 35.59 | 524472.0 |
| 2017-04-21 11:00:00 | AAPL | Stock | 35.5875 | 35.5898 | 35.555 | 35.5725 | 789632.0 |
| 2017-04-21 11:05:00 | AAPL | Stock | 35.5712 | 35.575 | 35.55 | 35.5525 | 474352.0 |
| 2017-04-21 11:10:00 | AAPL | Stock | 35.55 | 35.5622 | 35.53 | 35.545 | 632188.0 |
> showing 50 of 348,087 rows — these rows as CSV