PREVIEW / stock_5min / 2017-11-30
file: by_date/stock_5min/2017/2017-11-30.parquet size: 5.8 MB rows: 373,108 symbols: 2,957
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-11-30 04:00:00 | AAPL | Stock | 42.3 | 42.3 | 42.3 | 42.3 | 13600.0 |
| 2017-11-30 04:10:00 | AAPL | Stock | 42.325 | 42.325 | 42.325 | 42.325 | 860.0 |
| 2017-11-30 04:15:00 | AAPL | Stock | 42.425 | 42.425 | 42.4225 | 42.4225 | 2824.0 |
| 2017-11-30 04:20:00 | AAPL | Stock | 42.4225 | 42.4225 | 42.4225 | 42.4225 | 1716.0 |
| 2017-11-30 04:25:00 | AAPL | Stock | 42.4225 | 42.4225 | 42.4225 | 42.4225 | 800.0 |
| 2017-11-30 04:35:00 | AAPL | Stock | 42.4425 | 42.4425 | 42.4425 | 42.4425 | 2000.0 |
| 2017-11-30 04:50:00 | AAPL | Stock | 42.4275 | 42.4275 | 42.4275 | 42.4275 | 1200.0 |
| 2017-11-30 05:05:00 | AAPL | Stock | 42.4725 | 42.4875 | 42.45 | 42.45 | 14316.0 |
| 2017-11-30 05:20:00 | AAPL | Stock | 42.5 | 42.5225 | 42.5 | 42.5225 | 8196.0 |
| 2017-11-30 05:25:00 | AAPL | Stock | 42.525 | 42.525 | 42.525 | 42.525 | 1200.0 |
| 2017-11-30 05:35:00 | AAPL | Stock | 42.5475 | 42.5475 | 42.5475 | 42.5475 | 792.0 |
| 2017-11-30 05:45:00 | AAPL | Stock | 42.5475 | 42.55 | 42.5475 | 42.55 | 3200.0 |
| 2017-11-30 06:00:00 | AAPL | Stock | 42.57 | 42.5725 | 42.545 | 42.5725 | 6272.0 |
| 2017-11-30 06:05:00 | AAPL | Stock | 42.5725 | 42.575 | 42.5575 | 42.5575 | 5268.0 |
| 2017-11-30 06:15:00 | AAPL | Stock | 42.5575 | 42.5575 | 42.5575 | 42.5575 | 616.0 |
| 2017-11-30 06:25:00 | AAPL | Stock | 42.5775 | 42.5775 | 42.5775 | 42.5775 | 3952.0 |
| 2017-11-30 06:30:00 | AAPL | Stock | 42.595 | 42.595 | 42.595 | 42.595 | 3784.0 |
| 2017-11-30 06:35:00 | AAPL | Stock | 42.54 | 42.5775 | 42.54 | 42.5775 | 1200.0 |
| 2017-11-30 06:40:00 | AAPL | Stock | 42.5775 | 42.5775 | 42.555 | 42.555 | 3200.0 |
| 2017-11-30 06:50:00 | AAPL | Stock | 42.5625 | 42.5625 | 42.5625 | 42.5625 | 400.0 |
| 2017-11-30 07:00:00 | AAPL | Stock | 42.575 | 42.575 | 42.505 | 42.5275 | 23148.0 |
| 2017-11-30 07:05:00 | AAPL | Stock | 42.545 | 42.545 | 42.5125 | 42.5125 | 7800.0 |
| 2017-11-30 07:10:00 | AAPL | Stock | 42.525 | 42.55 | 42.525 | 42.5275 | 18736.0 |
| 2017-11-30 07:15:00 | AAPL | Stock | 42.53 | 42.5475 | 42.515 | 42.515 | 9264.0 |
| 2017-11-30 07:20:00 | AAPL | Stock | 42.525 | 42.5375 | 42.525 | 42.5375 | 4000.0 |
| 2017-11-30 07:25:00 | AAPL | Stock | 42.54 | 42.6 | 42.54 | 42.595 | 11252.0 |
| 2017-11-30 07:30:00 | AAPL | Stock | 42.6 | 42.605 | 42.5625 | 42.5625 | 98060.0 |
| 2017-11-30 07:35:00 | AAPL | Stock | 42.5575 | 42.5575 | 42.55 | 42.5575 | 34320.0 |
| 2017-11-30 07:40:00 | AAPL | Stock | 42.5525 | 42.575 | 42.5525 | 42.575 | 5200.0 |
| 2017-11-30 07:45:00 | AAPL | Stock | 42.5975 | 42.5975 | 42.5575 | 42.5575 | 9652.0 |
| 2017-11-30 07:50:00 | AAPL | Stock | 42.5625 | 42.57 | 42.5625 | 42.57 | 16400.0 |
| 2017-11-30 07:55:00 | AAPL | Stock | 42.57 | 42.6 | 42.57 | 42.6 | 22768.0 |
| 2017-11-30 08:00:00 | AAPL | Stock | 42.605 | 42.6275 | 42.515 | 42.615 | 103140.0 |
| 2017-11-30 08:05:00 | AAPL | Stock | 42.61 | 42.6375 | 42.59 | 42.6125 | 55092.0 |
| 2017-11-30 08:10:00 | AAPL | Stock | 42.6125 | 42.6625 | 42.6 | 42.6625 | 59624.0 |
| 2017-11-30 08:15:00 | AAPL | Stock | 42.6275 | 42.675 | 42.6275 | 42.6625 | 27880.0 |
| 2017-11-30 08:20:00 | AAPL | Stock | 42.675 | 42.6875 | 42.64 | 42.6825 | 41768.0 |
| 2017-11-30 08:25:00 | AAPL | Stock | 42.6775 | 42.7 | 42.675 | 42.7 | 41520.0 |
| 2017-11-30 08:30:00 | AAPL | Stock | 42.71 | 42.71 | 42.675 | 42.6875 | 82016.0 |
| 2017-11-30 08:35:00 | AAPL | Stock | 42.6875 | 42.7025 | 42.675 | 42.675 | 35112.0 |
| 2017-11-30 08:40:00 | AAPL | Stock | 42.6625 | 42.6725 | 42.64 | 42.645 | 29840.0 |
| 2017-11-30 08:45:00 | AAPL | Stock | 42.67 | 42.67 | 42.6425 | 42.655 | 13912.0 |
| 2017-11-30 08:50:00 | AAPL | Stock | 42.6575 | 42.6775 | 42.6375 | 42.6775 | 29672.0 |
| 2017-11-30 08:55:00 | AAPL | Stock | 42.6875 | 42.6925 | 42.6625 | 42.685 | 41228.0 |
| 2017-11-30 09:00:00 | AAPL | Stock | 42.68 | 42.6875 | 42.655 | 42.6875 | 65720.0 |
| 2017-11-30 09:05:00 | AAPL | Stock | 42.675 | 42.765 | 42.675 | 42.75 | 86964.0 |
| 2017-11-30 09:10:00 | AAPL | Stock | 42.7525 | 42.91 | 42.75 | 42.825 | 247448.0 |
| 2017-11-30 09:15:00 | AAPL | Stock | 42.825 | 42.825 | 42.8 | 42.8 | 61648.0 |
| 2017-11-30 09:20:00 | AAPL | Stock | 42.8 | 42.825 | 42.7975 | 42.8025 | 103688.0 |
| 2017-11-30 09:25:00 | AAPL | Stock | 42.81 | 42.81 | 42.5975 | 42.62 | 455852.0 |
> showing 50 of 373,108 rows — these rows as CSV