PREVIEW / stock_5min / 2018-02-27
file: by_date/stock_5min/2018/2018-02-27.parquet size: 5.6 MB rows: 360,654 symbols: 2,889
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-27 04:05:00 | AAPL | Stock | 44.755 | 44.755 | 44.75 | 44.75 | 2800.0 |
| 2018-02-27 04:15:00 | AAPL | Stock | 44.72 | 44.72 | 44.615 | 44.69 | 2896.0 |
| 2018-02-27 04:20:00 | AAPL | Stock | 44.69 | 44.69 | 44.69 | 44.69 | 800.0 |
| 2018-02-27 04:45:00 | AAPL | Stock | 44.6325 | 44.6575 | 44.6325 | 44.6575 | 20960.0 |
| 2018-02-27 04:50:00 | AAPL | Stock | 44.6875 | 44.7375 | 44.6875 | 44.7375 | 26912.0 |
| 2018-02-27 04:55:00 | AAPL | Stock | 44.7375 | 44.7375 | 44.7375 | 44.7375 | 400.0 |
| 2018-02-27 05:00:00 | AAPL | Stock | 44.745 | 44.75 | 44.745 | 44.75 | 7712.0 |
| 2018-02-27 05:05:00 | AAPL | Stock | 44.7625 | 44.7625 | 44.7625 | 44.7625 | 504.0 |
| 2018-02-27 05:10:00 | AAPL | Stock | 44.7625 | 44.7625 | 44.75 | 44.75 | 8764.0 |
| 2018-02-27 05:15:00 | AAPL | Stock | 44.715 | 44.715 | 44.7125 | 44.7125 | 8800.0 |
| 2018-02-27 05:20:00 | AAPL | Stock | 44.7125 | 44.7125 | 44.6875 | 44.6875 | 7200.0 |
| 2018-02-27 05:25:00 | AAPL | Stock | 44.69 | 44.69 | 44.69 | 44.69 | 400.0 |
| 2018-02-27 05:40:00 | AAPL | Stock | 44.7025 | 44.7025 | 44.6875 | 44.6875 | 19512.0 |
| 2018-02-27 05:45:00 | AAPL | Stock | 44.735 | 44.735 | 44.735 | 44.735 | 1792.0 |
| 2018-02-27 05:55:00 | AAPL | Stock | 44.695 | 44.735 | 44.695 | 44.735 | 3576.0 |
| 2018-02-27 06:00:00 | AAPL | Stock | 44.7325 | 44.7325 | 44.6875 | 44.6875 | 1200.0 |
| 2018-02-27 06:05:00 | AAPL | Stock | 44.685 | 44.685 | 44.685 | 44.685 | 400.0 |
| 2018-02-27 06:10:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 3400.0 |
| 2018-02-27 06:15:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 800.0 |
| 2018-02-27 06:20:00 | AAPL | Stock | 44.67 | 44.67 | 44.67 | 44.67 | 400.0 |
| 2018-02-27 06:35:00 | AAPL | Stock | 44.6125 | 44.6125 | 44.6125 | 44.6125 | 992.0 |
| 2018-02-27 06:40:00 | AAPL | Stock | 44.6025 | 44.625 | 44.6025 | 44.625 | 5376.0 |
| 2018-02-27 06:45:00 | AAPL | Stock | 44.605 | 44.605 | 44.575 | 44.575 | 3188.0 |
| 2018-02-27 06:50:00 | AAPL | Stock | 44.575 | 44.5775 | 44.575 | 44.575 | 9200.0 |
| 2018-02-27 06:55:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 12608.0 |
| 2018-02-27 07:00:00 | AAPL | Stock | 44.575 | 44.6325 | 44.575 | 44.6125 | 41092.0 |
| 2018-02-27 07:05:00 | AAPL | Stock | 44.62 | 44.62 | 44.6025 | 44.6125 | 11600.0 |
| 2018-02-27 07:10:00 | AAPL | Stock | 44.6125 | 44.635 | 44.59 | 44.635 | 11992.0 |
| 2018-02-27 07:15:00 | AAPL | Stock | 44.6475 | 44.6725 | 44.64 | 44.65 | 8716.0 |
| 2018-02-27 07:20:00 | AAPL | Stock | 44.65 | 44.65 | 44.63 | 44.63 | 42964.0 |
| 2018-02-27 07:25:00 | AAPL | Stock | 44.6275 | 44.64 | 44.625 | 44.64 | 7284.0 |
| 2018-02-27 07:30:00 | AAPL | Stock | 44.6475 | 44.65 | 44.6375 | 44.6375 | 6000.0 |
| 2018-02-27 07:35:00 | AAPL | Stock | 44.625 | 44.65 | 44.615 | 44.65 | 31180.0 |
| 2018-02-27 07:40:00 | AAPL | Stock | 44.65 | 44.675 | 44.63 | 44.63 | 27220.0 |
| 2018-02-27 07:45:00 | AAPL | Stock | 44.6275 | 44.6375 | 44.6025 | 44.6225 | 8132.0 |
| 2018-02-27 07:50:00 | AAPL | Stock | 44.625 | 44.675 | 44.625 | 44.675 | 14948.0 |
| 2018-02-27 07:55:00 | AAPL | Stock | 44.6575 | 44.6575 | 44.6375 | 44.6375 | 23328.0 |
| 2018-02-27 08:00:00 | AAPL | Stock | 44.595 | 44.675 | 44.595 | 44.65 | 72320.0 |
| 2018-02-27 08:05:00 | AAPL | Stock | 44.6575 | 44.67 | 44.6375 | 44.64 | 23268.0 |
| 2018-02-27 08:10:00 | AAPL | Stock | 44.65 | 44.6675 | 44.65 | 44.6675 | 10384.0 |
| 2018-02-27 08:15:00 | AAPL | Stock | 44.665 | 44.685 | 44.65 | 44.685 | 42212.0 |
| 2018-02-27 08:20:00 | AAPL | Stock | 44.675 | 44.675 | 44.6625 | 44.6625 | 52316.0 |
| 2018-02-27 08:25:00 | AAPL | Stock | 44.675 | 44.685 | 44.6675 | 44.675 | 22932.0 |
| 2018-02-27 08:30:00 | AAPL | Stock | 44.66 | 44.6725 | 44.6125 | 44.625 | 70488.0 |
| 2018-02-27 08:35:00 | AAPL | Stock | 44.625 | 44.655 | 44.625 | 44.65 | 18652.0 |
| 2018-02-27 08:40:00 | AAPL | Stock | 44.65 | 44.6625 | 44.65 | 44.65 | 34684.0 |
| 2018-02-27 08:45:00 | AAPL | Stock | 44.6625 | 44.7075 | 44.6625 | 44.7 | 48808.0 |
| 2018-02-27 08:50:00 | AAPL | Stock | 44.7 | 44.7325 | 44.7 | 44.715 | 66760.0 |
| 2018-02-27 08:55:00 | AAPL | Stock | 44.7175 | 44.77 | 44.7175 | 44.7275 | 124180.0 |
| 2018-02-27 09:00:00 | AAPL | Stock | 44.7275 | 44.775 | 44.725 | 44.7375 | 96180.0 |
> showing 50 of 360,654 rows — these rows as CSV