PREVIEW / stock_1min / 2018-02-08
file: by_date/stock_1min/2018/2018-02-08.parquet size: 16.8 MB rows: 1,176,046 symbols: 2,391
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-08 04:00:00 | AAPL | Stock | 39.95 | 39.95 | 39.95 | 39.95 | 9836.0 |
| 2018-02-08 04:02:00 | AAPL | Stock | 39.8875 | 39.8875 | 39.8875 | 39.8875 | 2400.0 |
| 2018-02-08 04:07:00 | AAPL | Stock | 39.9525 | 39.9525 | 39.9525 | 39.9525 | 400.0 |
| 2018-02-08 04:08:00 | AAPL | Stock | 39.9525 | 39.9525 | 39.9525 | 39.9525 | 800.0 |
| 2018-02-08 04:10:00 | AAPL | Stock | 39.9525 | 39.955 | 39.9525 | 39.955 | 2400.0 |
| 2018-02-08 04:18:00 | AAPL | Stock | 39.945 | 39.945 | 39.945 | 39.945 | 400.0 |
| 2018-02-08 04:20:00 | AAPL | Stock | 39.975 | 39.975 | 39.975 | 39.975 | 1200.0 |
| 2018-02-08 04:24:00 | AAPL | Stock | 39.9775 | 39.9775 | 39.9775 | 39.9775 | 400.0 |
| 2018-02-08 04:26:00 | AAPL | Stock | 39.975 | 39.975 | 39.975 | 39.975 | 9004.0 |
| 2018-02-08 04:28:00 | AAPL | Stock | 39.955 | 39.955 | 39.955 | 39.955 | 400.0 |
| 2018-02-08 04:29:00 | AAPL | Stock | 39.9375 | 39.9375 | 39.9225 | 39.9225 | 10400.0 |
| 2018-02-08 04:33:00 | AAPL | Stock | 39.8875 | 39.8875 | 39.8875 | 39.8875 | 1600.0 |
| 2018-02-08 04:34:00 | AAPL | Stock | 39.8875 | 39.8875 | 39.8875 | 39.8875 | 400.0 |
| 2018-02-08 04:38:00 | AAPL | Stock | 39.915 | 39.9175 | 39.915 | 39.9175 | 6000.0 |
| 2018-02-08 04:42:00 | AAPL | Stock | 39.925 | 39.925 | 39.925 | 39.925 | 4000.0 |
| 2018-02-08 04:43:00 | AAPL | Stock | 39.9475 | 39.9475 | 39.9475 | 39.9475 | 1036.0 |
| 2018-02-08 04:52:00 | AAPL | Stock | 39.925 | 39.925 | 39.925 | 39.925 | 800.0 |
| 2018-02-08 04:59:00 | AAPL | Stock | 39.9225 | 39.9225 | 39.9225 | 39.9225 | 400.0 |
| 2018-02-08 05:11:00 | AAPL | Stock | 39.8725 | 39.8725 | 39.8725 | 39.8725 | 3000.0 |
| 2018-02-08 05:12:00 | AAPL | Stock | 39.8725 | 39.875 | 39.8725 | 39.875 | 5996.0 |
| 2018-02-08 05:27:00 | AAPL | Stock | 39.83 | 39.83 | 39.83 | 39.83 | 1696.0 |
| 2018-02-08 05:48:00 | AAPL | Stock | 39.8625 | 39.8625 | 39.8625 | 39.8625 | 1200.0 |
| 2018-02-08 05:49:00 | AAPL | Stock | 39.8625 | 39.8625 | 39.8625 | 39.8625 | 1200.0 |
| 2018-02-08 05:51:00 | AAPL | Stock | 39.85 | 39.85 | 39.85 | 39.85 | 7020.0 |
| 2018-02-08 05:52:00 | AAPL | Stock | 39.85 | 39.85 | 39.8325 | 39.8325 | 4400.0 |
| 2018-02-08 05:57:00 | AAPL | Stock | 39.8325 | 39.8325 | 39.825 | 39.825 | 11896.0 |
| 2018-02-08 06:00:00 | AAPL | Stock | 39.815 | 39.815 | 39.815 | 39.815 | 400.0 |
| 2018-02-08 06:01:00 | AAPL | Stock | 39.8125 | 39.8125 | 39.8125 | 39.8125 | 844.0 |
| 2018-02-08 06:03:00 | AAPL | Stock | 39.8 | 39.805 | 39.8 | 39.8 | 7496.0 |
| 2018-02-08 06:08:00 | AAPL | Stock | 39.82 | 39.82 | 39.8 | 39.8 | 8600.0 |
| 2018-02-08 06:09:00 | AAPL | Stock | 39.8 | 39.8 | 39.7775 | 39.7825 | 5600.0 |
| 2018-02-08 06:10:00 | AAPL | Stock | 39.8 | 39.8 | 39.775 | 39.775 | 2408.0 |
| 2018-02-08 06:11:00 | AAPL | Stock | 39.775 | 39.78 | 39.775 | 39.7775 | 9592.0 |
| 2018-02-08 06:15:00 | AAPL | Stock | 39.78 | 39.78 | 39.7775 | 39.7775 | 7668.0 |
| 2018-02-08 06:16:00 | AAPL | Stock | 39.7875 | 39.7875 | 39.7875 | 39.7875 | 400.0 |
| 2018-02-08 06:17:00 | AAPL | Stock | 39.8025 | 39.8025 | 39.7875 | 39.7875 | 800.0 |
| 2018-02-08 06:18:00 | AAPL | Stock | 39.7875 | 39.7875 | 39.7875 | 39.7875 | 800.0 |
| 2018-02-08 06:20:00 | AAPL | Stock | 39.875 | 39.875 | 39.875 | 39.875 | 800.0 |
| 2018-02-08 06:22:00 | AAPL | Stock | 39.875 | 39.875 | 39.875 | 39.875 | 400.0 |
| 2018-02-08 06:27:00 | AAPL | Stock | 39.84 | 39.84 | 39.84 | 39.84 | 600.0 |
| 2018-02-08 06:28:00 | AAPL | Stock | 39.85 | 39.85 | 39.85 | 39.85 | 400.0 |
| 2018-02-08 06:29:00 | AAPL | Stock | 39.85 | 39.85 | 39.835 | 39.835 | 1600.0 |
| 2018-02-08 06:39:00 | AAPL | Stock | 39.7925 | 39.7925 | 39.7925 | 39.7925 | 800.0 |
| 2018-02-08 06:40:00 | AAPL | Stock | 39.7925 | 39.7925 | 39.7925 | 39.7925 | 656.0 |
| 2018-02-08 06:41:00 | AAPL | Stock | 39.7925 | 39.7925 | 39.7925 | 39.7925 | 2368.0 |
| 2018-02-08 06:42:00 | AAPL | Stock | 39.775 | 39.775 | 39.7575 | 39.7575 | 10104.0 |
| 2018-02-08 06:43:00 | AAPL | Stock | 39.7525 | 39.7525 | 39.725 | 39.725 | 12532.0 |
| 2018-02-08 06:44:00 | AAPL | Stock | 39.7275 | 39.7475 | 39.7275 | 39.7475 | 6104.0 |
| 2018-02-08 06:45:00 | AAPL | Stock | 39.75 | 39.75 | 39.75 | 39.75 | 400.0 |
| 2018-02-08 06:47:00 | AAPL | Stock | 39.755 | 39.755 | 39.7525 | 39.7525 | 4000.0 |
> showing 50 of 1,176,046 rows — these rows as CSV