PREVIEW / stock_5min / 2016-08-16
file: by_date/stock_5min/2016/2016-08-16.parquet size: 5.3 MB rows: 351,602 symbols: 3,276
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-08-16 04:00:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.49 | 27.49 | 13724.0 |
| 2016-08-16 04:05:00 | AAPL | Stock | 27.4275 | 27.45 | 27.4275 | 27.45 | 5720.0 |
| 2016-08-16 04:10:00 | AAPL | Stock | 27.485 | 27.495 | 27.485 | 27.4925 | 6480.0 |
| 2016-08-16 04:15:00 | AAPL | Stock | 27.4925 | 27.4975 | 27.4925 | 27.4975 | 11268.0 |
| 2016-08-16 04:25:00 | AAPL | Stock | 27.495 | 27.4975 | 27.495 | 27.4975 | 1628.0 |
| 2016-08-16 04:30:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.4975 | 27.4975 | 24996.0 |
| 2016-08-16 04:50:00 | AAPL | Stock | 27.475 | 27.475 | 27.475 | 27.475 | 400.0 |
| 2016-08-16 05:10:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.495 | 27.4975 | 3600.0 |
| 2016-08-16 05:40:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.4975 | 27.4975 | 808.0 |
| 2016-08-16 05:45:00 | AAPL | Stock | 27.4775 | 27.4775 | 27.4775 | 27.4775 | 2000.0 |
| 2016-08-16 05:50:00 | AAPL | Stock | 27.4975 | 27.4975 | 27.465 | 27.465 | 2972.0 |
| 2016-08-16 06:00:00 | AAPL | Stock | 27.465 | 27.465 | 27.4625 | 27.4625 | 2968.0 |
| 2016-08-16 06:05:00 | AAPL | Stock | 27.475 | 27.475 | 27.475 | 27.475 | 500.0 |
| 2016-08-16 06:10:00 | AAPL | Stock | 27.4425 | 27.4425 | 27.4425 | 27.4425 | 400.0 |
| 2016-08-16 06:20:00 | AAPL | Stock | 27.4525 | 27.4675 | 27.44 | 27.445 | 22256.0 |
| 2016-08-16 06:25:00 | AAPL | Stock | 27.445 | 27.4475 | 27.445 | 27.445 | 18892.0 |
| 2016-08-16 06:30:00 | AAPL | Stock | 27.415 | 27.415 | 27.415 | 27.415 | 800.0 |
| 2016-08-16 06:35:00 | AAPL | Stock | 27.4375 | 27.4375 | 27.4375 | 27.4375 | 20000.0 |
| 2016-08-16 06:40:00 | AAPL | Stock | 27.445 | 27.4475 | 27.4425 | 27.4425 | 1600.0 |
| 2016-08-16 06:45:00 | AAPL | Stock | 27.4475 | 27.4675 | 27.4475 | 27.4675 | 6400.0 |
| 2016-08-16 06:55:00 | AAPL | Stock | 27.4825 | 27.485 | 27.4825 | 27.485 | 1600.0 |
| 2016-08-16 07:00:00 | AAPL | Stock | 27.4825 | 27.4825 | 27.4825 | 27.4825 | 31480.0 |
| 2016-08-16 07:05:00 | AAPL | Stock | 27.47 | 27.47 | 27.4675 | 27.47 | 14340.0 |
| 2016-08-16 07:10:00 | AAPL | Stock | 27.4825 | 27.4825 | 27.4825 | 27.4825 | 1200.0 |
| 2016-08-16 07:15:00 | AAPL | Stock | 27.475 | 27.475 | 27.475 | 27.475 | 400.0 |
| 2016-08-16 07:20:00 | AAPL | Stock | 27.485 | 27.4975 | 27.475 | 27.475 | 45308.0 |
| 2016-08-16 07:25:00 | AAPL | Stock | 27.475 | 27.475 | 27.4675 | 27.4675 | 8400.0 |
| 2016-08-16 07:30:00 | AAPL | Stock | 27.475 | 27.475 | 27.475 | 27.475 | 400.0 |
| 2016-08-16 07:35:00 | AAPL | Stock | 27.475 | 27.475 | 27.46 | 27.46 | 14712.0 |
| 2016-08-16 07:40:00 | AAPL | Stock | 27.46 | 27.4625 | 27.45 | 27.45 | 56752.0 |
| 2016-08-16 07:45:00 | AAPL | Stock | 27.445 | 27.45 | 27.4 | 27.4 | 15064.0 |
| 2016-08-16 07:50:00 | AAPL | Stock | 27.4225 | 27.4225 | 27.4075 | 27.4075 | 15820.0 |
| 2016-08-16 07:55:00 | AAPL | Stock | 27.41 | 27.435 | 27.41 | 27.435 | 2936.0 |
| 2016-08-16 08:00:00 | AAPL | Stock | 27.435 | 27.485 | 27.4325 | 27.4675 | 66040.0 |
| 2016-08-16 08:05:00 | AAPL | Stock | 27.455 | 27.4675 | 27.45 | 27.4675 | 14164.0 |
| 2016-08-16 08:10:00 | AAPL | Stock | 27.47 | 27.475 | 27.465 | 27.475 | 40960.0 |
| 2016-08-16 08:15:00 | AAPL | Stock | 27.4725 | 27.475 | 27.47 | 27.47 | 8440.0 |
| 2016-08-16 08:20:00 | AAPL | Stock | 27.4675 | 27.4675 | 27.45 | 27.455 | 60580.0 |
| 2016-08-16 08:25:00 | AAPL | Stock | 27.4575 | 27.46 | 27.43 | 27.43 | 35156.0 |
| 2016-08-16 08:30:00 | AAPL | Stock | 27.4475 | 27.4675 | 27.445 | 27.4525 | 36284.0 |
| 2016-08-16 08:35:00 | AAPL | Stock | 27.4525 | 27.4525 | 27.4125 | 27.425 | 57596.0 |
| 2016-08-16 08:40:00 | AAPL | Stock | 27.42 | 27.425 | 27.405 | 27.405 | 45796.0 |
| 2016-08-16 08:45:00 | AAPL | Stock | 27.4075 | 27.41 | 27.4 | 27.4 | 34424.0 |
| 2016-08-16 08:50:00 | AAPL | Stock | 27.4 | 27.4125 | 27.4 | 27.4125 | 40628.0 |
| 2016-08-16 08:55:00 | AAPL | Stock | 27.4275 | 27.4375 | 27.425 | 27.4325 | 14360.0 |
| 2016-08-16 09:00:00 | AAPL | Stock | 27.4225 | 27.435 | 27.4175 | 27.43 | 13628.0 |
| 2016-08-16 09:05:00 | AAPL | Stock | 27.43 | 27.43 | 27.4225 | 27.4225 | 12400.0 |
| 2016-08-16 09:10:00 | AAPL | Stock | 27.425 | 27.43 | 27.4175 | 27.425 | 17688.0 |
| 2016-08-16 09:15:00 | AAPL | Stock | 27.4175 | 27.4225 | 27.4025 | 27.4225 | 20068.0 |
| 2016-08-16 09:20:00 | AAPL | Stock | 27.41 | 27.4125 | 27.405 | 27.4125 | 32028.0 |
> showing 50 of 351,602 rows — these rows as CSV