PREVIEW / stock_1min / 2017-04-03
file: by_date/stock_1min/2017/2017-04-03.parquet size: 15.7 MB rows: 1,135,670 symbols: 2,534
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-04-03 05:23:00 | AAPL | Stock | 35.9 | 35.9 | 35.9 | 35.9 | 7276.0 |
| 2017-04-03 05:24:00 | AAPL | Stock | 35.9 | 35.9075 | 35.9 | 35.9075 | 20952.0 |
| 2017-04-03 05:55:00 | AAPL | Stock | 35.91 | 35.91 | 35.91 | 35.91 | 400.0 |
| 2017-04-03 06:06:00 | AAPL | Stock | 35.975 | 35.975 | 35.975 | 35.975 | 2120.0 |
| 2017-04-03 06:14:00 | AAPL | Stock | 35.9725 | 35.9725 | 35.9725 | 35.9725 | 400.0 |
| 2017-04-03 06:25:00 | AAPL | Stock | 35.975 | 35.975 | 35.975 | 35.975 | 756.0 |
| 2017-04-03 06:29:00 | AAPL | Stock | 35.97 | 35.97 | 35.97 | 35.97 | 2000.0 |
| 2017-04-03 06:40:00 | AAPL | Stock | 35.93 | 35.93 | 35.93 | 35.93 | 496.0 |
| 2017-04-03 07:10:00 | AAPL | Stock | 35.9525 | 35.9525 | 35.9525 | 35.9525 | 600.0 |
| 2017-04-03 07:13:00 | AAPL | Stock | 35.96 | 35.9625 | 35.96 | 35.96 | 8400.0 |
| 2017-04-03 07:15:00 | AAPL | Stock | 35.9675 | 35.9675 | 35.9675 | 35.9675 | 1200.0 |
| 2017-04-03 07:21:00 | AAPL | Stock | 35.94 | 35.955 | 35.94 | 35.95 | 3020.0 |
| 2017-04-03 07:22:00 | AAPL | Stock | 35.95 | 35.95 | 35.95 | 35.95 | 1200.0 |
| 2017-04-03 07:24:00 | AAPL | Stock | 35.95 | 35.95 | 35.94 | 35.94 | 6800.0 |
| 2017-04-03 07:31:00 | AAPL | Stock | 35.94 | 35.94 | 35.94 | 35.94 | 400.0 |
| 2017-04-03 07:36:00 | AAPL | Stock | 35.9325 | 35.9325 | 35.9325 | 35.9325 | 2800.0 |
| 2017-04-03 07:45:00 | AAPL | Stock | 35.9475 | 35.95 | 35.9475 | 35.95 | 2800.0 |
| 2017-04-03 07:51:00 | AAPL | Stock | 35.95 | 35.95 | 35.95 | 35.95 | 1600.0 |
| 2017-04-03 07:54:00 | AAPL | Stock | 35.95 | 35.95 | 35.95 | 35.95 | 3224.0 |
| 2017-04-03 07:56:00 | AAPL | Stock | 35.9475 | 35.9475 | 35.9375 | 35.9375 | 2000.0 |
| 2017-04-03 08:00:00 | AAPL | Stock | 35.9375 | 35.9475 | 35.93 | 35.9375 | 22900.0 |
| 2017-04-03 08:03:00 | AAPL | Stock | 35.92 | 35.92 | 35.92 | 35.92 | 1000.0 |
| 2017-04-03 08:07:00 | AAPL | Stock | 35.92 | 35.9325 | 35.92 | 35.9325 | 6660.0 |
| 2017-04-03 08:11:00 | AAPL | Stock | 35.9075 | 35.9075 | 35.8875 | 35.8875 | 15504.0 |
| 2017-04-03 08:18:00 | AAPL | Stock | 35.8975 | 35.8975 | 35.8975 | 35.8975 | 3664.0 |
| 2017-04-03 08:19:00 | AAPL | Stock | 35.8975 | 35.8975 | 35.8975 | 35.8975 | 2800.0 |
| 2017-04-03 08:20:00 | AAPL | Stock | 35.9 | 35.9 | 35.9 | 35.9 | 6104.0 |
| 2017-04-03 08:22:00 | AAPL | Stock | 35.9075 | 35.92 | 35.9075 | 35.92 | 5356.0 |
| 2017-04-03 08:24:00 | AAPL | Stock | 35.92 | 35.92 | 35.92 | 35.92 | 6148.0 |
| 2017-04-03 08:26:00 | AAPL | Stock | 35.92 | 35.9225 | 35.92 | 35.9225 | 4000.0 |
| 2017-04-03 08:30:00 | AAPL | Stock | 35.905 | 35.905 | 35.9 | 35.9 | 8000.0 |
| 2017-04-03 08:35:00 | AAPL | Stock | 35.9075 | 35.9075 | 35.9075 | 35.9075 | 4000.0 |
| 2017-04-03 08:36:00 | AAPL | Stock | 35.9125 | 35.93 | 35.9125 | 35.93 | 23628.0 |
| 2017-04-03 08:38:00 | AAPL | Stock | 35.93 | 35.93 | 35.93 | 35.93 | 400.0 |
| 2017-04-03 08:40:00 | AAPL | Stock | 35.91 | 35.91 | 35.91 | 35.91 | 400.0 |
| 2017-04-03 08:41:00 | AAPL | Stock | 35.93 | 35.93 | 35.93 | 35.93 | 1600.0 |
| 2017-04-03 08:43:00 | AAPL | Stock | 35.9225 | 35.925 | 35.9225 | 35.925 | 2000.0 |
| 2017-04-03 08:47:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 2492.0 |
| 2017-04-03 08:48:00 | AAPL | Stock | 35.93 | 35.9375 | 35.93 | 35.9375 | 19968.0 |
| 2017-04-03 08:49:00 | AAPL | Stock | 35.945 | 35.945 | 35.945 | 35.945 | 3600.0 |
| 2017-04-03 08:51:00 | AAPL | Stock | 35.945 | 35.945 | 35.945 | 35.945 | 784.0 |
| 2017-04-03 08:52:00 | AAPL | Stock | 35.945 | 35.945 | 35.945 | 35.945 | 2000.0 |
| 2017-04-03 08:54:00 | AAPL | Stock | 35.935 | 35.935 | 35.935 | 35.935 | 400.0 |
| 2017-04-03 08:56:00 | AAPL | Stock | 35.945 | 35.945 | 35.9375 | 35.9375 | 1304.0 |
| 2017-04-03 08:57:00 | AAPL | Stock | 35.9375 | 35.9375 | 35.9375 | 35.9375 | 400.0 |
| 2017-04-03 08:59:00 | AAPL | Stock | 35.94 | 35.94 | 35.93 | 35.93 | 30860.0 |
| 2017-04-03 09:02:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 400.0 |
| 2017-04-03 09:04:00 | AAPL | Stock | 35.925 | 35.9375 | 35.925 | 35.925 | 4604.0 |
| 2017-04-03 09:06:00 | AAPL | Stock | 35.93 | 35.93 | 35.93 | 35.93 | 10000.0 |
| 2017-04-03 09:07:00 | AAPL | Stock | 35.94 | 35.94 | 35.94 | 35.94 | 2460.0 |
> showing 50 of 1,135,670 rows — these rows as CSV