PREVIEW / stock_1min / 2017-08-29
file: by_date/stock_1min/2017/2017-08-29.parquet size: 13.8 MB rows: 1,009,058 symbols: 2,468
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-08-29 04:00:00 | AAPL | Stock | 40.05 | 40.05 | 39.95 | 39.95 | 2020.0 |
| 2017-08-29 04:08:00 | AAPL | Stock | 39.975 | 39.975 | 39.975 | 39.975 | 1600.0 |
| 2017-08-29 04:12:00 | AAPL | Stock | 39.975 | 39.975 | 39.975 | 39.975 | 1996.0 |
| 2017-08-29 04:13:00 | AAPL | Stock | 40.0 | 40.0 | 40.0 | 40.0 | 4000.0 |
| 2017-08-29 04:27:00 | AAPL | Stock | 39.92 | 39.92 | 39.92 | 39.92 | 400.0 |
| 2017-08-29 04:29:00 | AAPL | Stock | 39.945 | 39.945 | 39.945 | 39.945 | 1992.0 |
| 2017-08-29 04:30:00 | AAPL | Stock | 39.95 | 39.95 | 39.95 | 39.95 | 3600.0 |
| 2017-08-29 04:41:00 | AAPL | Stock | 39.9075 | 39.9075 | 39.8875 | 39.8875 | 3796.0 |
| 2017-08-29 04:49:00 | AAPL | Stock | 39.9125 | 39.9125 | 39.9 | 39.9 | 2228.0 |
| 2017-08-29 04:50:00 | AAPL | Stock | 39.8875 | 39.8875 | 39.8875 | 39.8875 | 3872.0 |
| 2017-08-29 04:58:00 | AAPL | Stock | 39.945 | 39.945 | 39.945 | 39.945 | 1912.0 |
| 2017-08-29 04:59:00 | AAPL | Stock | 39.9125 | 39.9125 | 39.9125 | 39.9125 | 800.0 |
| 2017-08-29 05:00:00 | AAPL | Stock | 39.9025 | 39.9025 | 39.875 | 39.8875 | 11096.0 |
| 2017-08-29 05:12:00 | AAPL | Stock | 39.9 | 39.9 | 39.9 | 39.9 | 2480.0 |
| 2017-08-29 05:15:00 | AAPL | Stock | 39.9225 | 39.9225 | 39.9225 | 39.9225 | 400.0 |
| 2017-08-29 05:24:00 | AAPL | Stock | 39.93 | 39.93 | 39.925 | 39.925 | 2800.0 |
| 2017-08-29 05:31:00 | AAPL | Stock | 39.975 | 39.975 | 39.975 | 39.975 | 1644.0 |
| 2017-08-29 05:35:00 | AAPL | Stock | 39.975 | 39.9925 | 39.975 | 39.9925 | 1200.0 |
| 2017-08-29 05:36:00 | AAPL | Stock | 40.0 | 40.0 | 40.0 | 40.0 | 800.0 |
| 2017-08-29 05:41:00 | AAPL | Stock | 40.0 | 40.0 | 40.0 | 40.0 | 868.0 |
| 2017-08-29 05:43:00 | AAPL | Stock | 40.025 | 40.025 | 40.025 | 40.025 | 400.0 |
| 2017-08-29 05:46:00 | AAPL | Stock | 40.0375 | 40.0375 | 40.025 | 40.025 | 2592.0 |
| 2017-08-29 05:47:00 | AAPL | Stock | 40.035 | 40.035 | 40.025 | 40.025 | 4784.0 |
| 2017-08-29 05:48:00 | AAPL | Stock | 40.025 | 40.025 | 40.025 | 40.025 | 1248.0 |
| 2017-08-29 05:49:00 | AAPL | Stock | 40.025 | 40.025 | 40.025 | 40.025 | 5200.0 |
| 2017-08-29 05:52:00 | AAPL | Stock | 40.025 | 40.025 | 40.025 | 40.025 | 3520.0 |
| 2017-08-29 05:53:00 | AAPL | Stock | 40.025 | 40.025 | 40.025 | 40.025 | 1200.0 |
| 2017-08-29 05:57:00 | AAPL | Stock | 40.025 | 40.025 | 40.025 | 40.025 | 400.0 |
| 2017-08-29 05:59:00 | AAPL | Stock | 40.025 | 40.025 | 40.025 | 40.025 | 3656.0 |
| 2017-08-29 06:01:00 | AAPL | Stock | 40.0025 | 40.0025 | 40.0025 | 40.0025 | 2080.0 |
| 2017-08-29 06:02:00 | AAPL | Stock | 40.0025 | 40.0025 | 40.0025 | 40.0025 | 2800.0 |
| 2017-08-29 06:03:00 | AAPL | Stock | 40.0025 | 40.0025 | 40.0025 | 40.0025 | 1580.0 |
| 2017-08-29 06:04:00 | AAPL | Stock | 40.005 | 40.005 | 40.0025 | 40.0025 | 5960.0 |
| 2017-08-29 06:05:00 | AAPL | Stock | 40.0025 | 40.0025 | 40.0025 | 40.0025 | 4000.0 |
| 2017-08-29 06:06:00 | AAPL | Stock | 40.0025 | 40.0025 | 40.0 | 40.0 | 2400.0 |
| 2017-08-29 06:07:00 | AAPL | Stock | 39.9775 | 39.9775 | 39.9775 | 39.9775 | 800.0 |
| 2017-08-29 06:08:00 | AAPL | Stock | 39.9775 | 39.9775 | 39.9775 | 39.9775 | 3200.0 |
| 2017-08-29 06:11:00 | AAPL | Stock | 40.0 | 40.0 | 40.0 | 40.0 | 7656.0 |
| 2017-08-29 06:12:00 | AAPL | Stock | 40.0 | 40.0225 | 40.0 | 40.0225 | 3256.0 |
| 2017-08-29 06:13:00 | AAPL | Stock | 40.0225 | 40.0375 | 40.0225 | 40.0375 | 6400.0 |
| 2017-08-29 06:14:00 | AAPL | Stock | 40.035 | 40.035 | 40.035 | 40.035 | 1856.0 |
| 2017-08-29 06:17:00 | AAPL | Stock | 40.0 | 40.0 | 40.0 | 40.0 | 400.0 |
| 2017-08-29 06:20:00 | AAPL | Stock | 40.0 | 40.0325 | 40.0 | 40.0325 | 7600.0 |
| 2017-08-29 06:21:00 | AAPL | Stock | 40.0 | 40.0 | 40.0 | 40.0 | 5648.0 |
| 2017-08-29 06:22:00 | AAPL | Stock | 40.035 | 40.035 | 40.035 | 40.035 | 400.0 |
| 2017-08-29 06:23:00 | AAPL | Stock | 40.035 | 40.035 | 40.035 | 40.035 | 800.0 |
| 2017-08-29 06:27:00 | AAPL | Stock | 40.035 | 40.04 | 40.03 | 40.03 | 7736.0 |
| 2017-08-29 06:29:00 | AAPL | Stock | 40.0375 | 40.0375 | 40.0375 | 40.0375 | 800.0 |
| 2017-08-29 06:30:00 | AAPL | Stock | 40.025 | 40.025 | 40.025 | 40.025 | 1864.0 |
| 2017-08-29 06:34:00 | AAPL | Stock | 40.05 | 40.05 | 40.05 | 40.05 | 400.0 |
> showing 50 of 1,009,058 rows — these rows as CSV