PREVIEW / stock_5min / 2016-05-19
file: by_date/stock_5min/2016/2016-05-19.parquet size: 5.3 MB rows: 357,397 symbols: 3,280
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-19 04:00:00 | AAPL | Stock | 23.65 | 23.65 | 23.65 | 23.65 | 400.0 |
| 2016-05-19 04:10:00 | AAPL | Stock | 23.665 | 23.665 | 23.665 | 23.665 | 756.0 |
| 2016-05-19 04:20:00 | AAPL | Stock | 23.6575 | 23.6575 | 23.6575 | 23.6575 | 400.0 |
| 2016-05-19 04:35:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6375 | 23.6375 | 2000.0 |
| 2016-05-19 04:40:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6375 | 23.6375 | 400.0 |
| 2016-05-19 04:55:00 | AAPL | Stock | 23.6125 | 23.6125 | 23.6125 | 23.6125 | 800.0 |
| 2016-05-19 05:10:00 | AAPL | Stock | 23.6075 | 23.62 | 23.6075 | 23.6075 | 3724.0 |
| 2016-05-19 05:30:00 | AAPL | Stock | 23.62 | 23.62 | 23.62 | 23.62 | 400.0 |
| 2016-05-19 05:40:00 | AAPL | Stock | 23.62 | 23.62 | 23.62 | 23.62 | 400.0 |
| 2016-05-19 05:45:00 | AAPL | Stock | 23.64 | 23.64 | 23.64 | 23.64 | 400.0 |
| 2016-05-19 06:10:00 | AAPL | Stock | 23.655 | 23.655 | 23.655 | 23.655 | 400.0 |
| 2016-05-19 06:35:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6375 | 23.6375 | 4000.0 |
| 2016-05-19 06:45:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6375 | 23.6375 | 3200.0 |
| 2016-05-19 06:50:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6375 | 23.6375 | 400.0 |
| 2016-05-19 07:05:00 | AAPL | Stock | 23.655 | 23.665 | 23.65 | 23.6625 | 9580.0 |
| 2016-05-19 07:20:00 | AAPL | Stock | 23.67 | 23.67 | 23.67 | 23.67 | 1600.0 |
| 2016-05-19 07:25:00 | AAPL | Stock | 23.67 | 23.67 | 23.67 | 23.67 | 4000.0 |
| 2016-05-19 07:35:00 | AAPL | Stock | 23.7 | 23.7025 | 23.7 | 23.7025 | 5512.0 |
| 2016-05-19 07:40:00 | AAPL | Stock | 23.6875 | 23.7 | 23.6875 | 23.7 | 4916.0 |
| 2016-05-19 07:50:00 | AAPL | Stock | 23.6875 | 23.6875 | 23.6875 | 23.6875 | 480.0 |
| 2016-05-19 07:55:00 | AAPL | Stock | 23.69 | 23.69 | 23.69 | 23.69 | 1200.0 |
| 2016-05-19 08:00:00 | AAPL | Stock | 23.6925 | 23.6925 | 23.625 | 23.675 | 22636.0 |
| 2016-05-19 08:05:00 | AAPL | Stock | 23.68 | 23.68 | 23.6525 | 23.66 | 22760.0 |
| 2016-05-19 08:10:00 | AAPL | Stock | 23.66 | 23.66 | 23.65 | 23.655 | 25264.0 |
| 2016-05-19 08:15:00 | AAPL | Stock | 23.655 | 23.6575 | 23.6525 | 23.6525 | 2840.0 |
| 2016-05-19 08:20:00 | AAPL | Stock | 23.65 | 23.65 | 23.63 | 23.63 | 16540.0 |
| 2016-05-19 08:25:00 | AAPL | Stock | 23.63 | 23.6375 | 23.63 | 23.6375 | 6216.0 |
| 2016-05-19 08:30:00 | AAPL | Stock | 23.6362 | 23.6375 | 23.6025 | 23.6125 | 59024.0 |
| 2016-05-19 08:35:00 | AAPL | Stock | 23.605 | 23.6125 | 23.59 | 23.59 | 14800.0 |
| 2016-05-19 08:40:00 | AAPL | Stock | 23.5875 | 23.5875 | 23.58 | 23.5875 | 1600.0 |
| 2016-05-19 08:45:00 | AAPL | Stock | 23.585 | 23.6125 | 23.5825 | 23.6025 | 22840.0 |
| 2016-05-19 08:50:00 | AAPL | Stock | 23.61 | 23.6125 | 23.5975 | 23.61 | 5596.0 |
| 2016-05-19 08:55:00 | AAPL | Stock | 23.6125 | 23.6125 | 23.6075 | 23.61 | 10684.0 |
| 2016-05-19 09:00:00 | AAPL | Stock | 23.61 | 23.615 | 23.5875 | 23.615 | 24336.0 |
| 2016-05-19 09:05:00 | AAPL | Stock | 23.6125 | 23.63 | 23.6125 | 23.625 | 14760.0 |
| 2016-05-19 09:10:00 | AAPL | Stock | 23.625 | 23.625 | 23.6075 | 23.6075 | 8400.0 |
| 2016-05-19 09:15:00 | AAPL | Stock | 23.63 | 23.63 | 23.6125 | 23.6125 | 3200.0 |
| 2016-05-19 09:20:00 | AAPL | Stock | 23.615 | 23.615 | 23.605 | 23.605 | 5200.0 |
| 2016-05-19 09:25:00 | AAPL | Stock | 23.6125 | 23.6675 | 23.6125 | 23.66 | 56740.0 |
| 2016-05-19 09:30:00 | AAPL | Stock | 23.6575 | 23.66 | 23.45 | 23.4712 | 7481872.0 |
| 2016-05-19 09:35:00 | AAPL | Stock | 23.47 | 23.5325 | 23.465 | 23.4875 | 2865720.0 |
| 2016-05-19 09:40:00 | AAPL | Stock | 23.4862 | 23.4975 | 23.4138 | 23.4575 | 2830080.0 |
| 2016-05-19 09:45:00 | AAPL | Stock | 23.4575 | 23.5125 | 23.4425 | 23.45 | 1998388.0 |
| 2016-05-19 09:50:00 | AAPL | Stock | 23.45 | 23.46 | 23.4125 | 23.451 | 2482840.0 |
| 2016-05-19 09:55:00 | AAPL | Stock | 23.45 | 23.5075 | 23.4275 | 23.43 | 2841432.0 |
| 2016-05-19 10:00:00 | AAPL | Stock | 23.4275 | 23.475 | 23.4125 | 23.457 | 1998436.0 |
| 2016-05-19 10:05:00 | AAPL | Stock | 23.4575 | 23.48 | 23.415 | 23.455 | 1626404.0 |
| 2016-05-19 10:10:00 | AAPL | Stock | 23.4525 | 23.475 | 23.4275 | 23.4338 | 1253392.0 |
| 2016-05-19 10:15:00 | AAPL | Stock | 23.4348 | 23.4875 | 23.4175 | 23.485 | 1439632.0 |
| 2016-05-19 10:20:00 | AAPL | Stock | 23.485 | 23.52 | 23.455 | 23.5125 | 1994536.0 |
> showing 50 of 357,397 rows — these rows as CSV