PREVIEW / stock_1min / 2017-02-22
file: by_date/stock_1min/2017/2017-02-22.parquet size: 14.6 MB rows: 1,063,203 symbols: 2,561
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-02-22 04:00:00 | AAPL | Stock | 34.1625 | 34.1625 | 34.1625 | 34.1625 | 1600.0 |
| 2017-02-22 04:31:00 | AAPL | Stock | 34.1375 | 34.1375 | 34.1375 | 34.1375 | 984.0 |
| 2017-02-22 04:40:00 | AAPL | Stock | 34.1375 | 34.1375 | 34.1375 | 34.1375 | 2400.0 |
| 2017-02-22 05:07:00 | AAPL | Stock | 34.1275 | 34.1275 | 34.1275 | 34.1275 | 556.0 |
| 2017-02-22 05:23:00 | AAPL | Stock | 34.1475 | 34.1475 | 34.1475 | 34.1475 | 400.0 |
| 2017-02-22 05:26:00 | AAPL | Stock | 34.1275 | 34.1275 | 34.1275 | 34.1275 | 400.0 |
| 2017-02-22 05:28:00 | AAPL | Stock | 34.1275 | 34.1275 | 34.1275 | 34.1275 | 1044.0 |
| 2017-02-22 05:31:00 | AAPL | Stock | 34.12 | 34.12 | 34.12 | 34.12 | 400.0 |
| 2017-02-22 05:34:00 | AAPL | Stock | 34.12 | 34.12 | 34.12 | 34.12 | 568.0 |
| 2017-02-22 05:36:00 | AAPL | Stock | 34.11 | 34.11 | 34.11 | 34.11 | 784.0 |
| 2017-02-22 05:39:00 | AAPL | Stock | 34.1075 | 34.1075 | 34.1075 | 34.1075 | 400.0 |
| 2017-02-22 06:05:00 | AAPL | Stock | 34.135 | 34.135 | 34.1225 | 34.1225 | 1000.0 |
| 2017-02-22 06:09:00 | AAPL | Stock | 34.1375 | 34.145 | 34.1375 | 34.145 | 1060.0 |
| 2017-02-22 06:28:00 | AAPL | Stock | 34.095 | 34.095 | 34.095 | 34.095 | 732.0 |
| 2017-02-22 06:31:00 | AAPL | Stock | 34.0875 | 34.0875 | 34.0825 | 34.0825 | 2360.0 |
| 2017-02-22 06:38:00 | AAPL | Stock | 34.0825 | 34.0825 | 34.0825 | 34.0825 | 428.0 |
| 2017-02-22 06:41:00 | AAPL | Stock | 34.0825 | 34.0825 | 34.0825 | 34.0825 | 400.0 |
| 2017-02-22 06:45:00 | AAPL | Stock | 34.0975 | 34.0975 | 34.0975 | 34.0975 | 1600.0 |
| 2017-02-22 06:46:00 | AAPL | Stock | 34.0975 | 34.0975 | 34.0975 | 34.0975 | 800.0 |
| 2017-02-22 06:47:00 | AAPL | Stock | 34.0975 | 34.0975 | 34.0975 | 34.0975 | 1200.0 |
| 2017-02-22 06:49:00 | AAPL | Stock | 34.0925 | 34.0925 | 34.0925 | 34.0925 | 400.0 |
| 2017-02-22 06:51:00 | AAPL | Stock | 34.0925 | 34.0925 | 34.0925 | 34.0925 | 2000.0 |
| 2017-02-22 06:53:00 | AAPL | Stock | 34.0925 | 34.0925 | 34.0825 | 34.0925 | 2348.0 |
| 2017-02-22 06:59:00 | AAPL | Stock | 34.0825 | 34.0825 | 34.0825 | 34.0825 | 5480.0 |
| 2017-02-22 07:01:00 | AAPL | Stock | 34.0925 | 34.0925 | 34.0875 | 34.0925 | 11836.0 |
| 2017-02-22 07:02:00 | AAPL | Stock | 34.0925 | 34.0925 | 34.0825 | 34.0825 | 4000.0 |
| 2017-02-22 07:08:00 | AAPL | Stock | 34.075 | 34.075 | 34.075 | 34.075 | 1600.0 |
| 2017-02-22 07:09:00 | AAPL | Stock | 34.075 | 34.075 | 34.075 | 34.075 | 2400.0 |
| 2017-02-22 07:15:00 | AAPL | Stock | 34.075 | 34.075 | 34.075 | 34.075 | 880.0 |
| 2017-02-22 07:16:00 | AAPL | Stock | 34.075 | 34.075 | 34.075 | 34.075 | 3224.0 |
| 2017-02-22 07:25:00 | AAPL | Stock | 34.075 | 34.075 | 34.075 | 34.075 | 1200.0 |
| 2017-02-22 07:28:00 | AAPL | Stock | 34.08 | 34.1 | 34.075 | 34.1 | 13912.0 |
| 2017-02-22 07:30:00 | AAPL | Stock | 34.1 | 34.1 | 34.1 | 34.1 | 400.0 |
| 2017-02-22 07:39:00 | AAPL | Stock | 34.0875 | 34.0875 | 34.0875 | 34.0875 | 3280.0 |
| 2017-02-22 07:40:00 | AAPL | Stock | 34.0975 | 34.0975 | 34.0975 | 34.0975 | 800.0 |
| 2017-02-22 07:43:00 | AAPL | Stock | 34.0975 | 34.0975 | 34.0975 | 34.0975 | 600.0 |
| 2017-02-22 07:50:00 | AAPL | Stock | 34.11 | 34.1125 | 34.11 | 34.1125 | 4000.0 |
| 2017-02-22 07:54:00 | AAPL | Stock | 34.1075 | 34.11 | 34.1075 | 34.11 | 1560.0 |
| 2017-02-22 07:56:00 | AAPL | Stock | 34.11 | 34.11 | 34.11 | 34.11 | 800.0 |
| 2017-02-22 07:59:00 | AAPL | Stock | 34.11 | 34.11 | 34.085 | 34.0975 | 8520.0 |
| 2017-02-22 08:00:00 | AAPL | Stock | 34.1075 | 34.12 | 34.075 | 34.1075 | 31000.0 |
| 2017-02-22 08:03:00 | AAPL | Stock | 34.1225 | 34.1225 | 34.1225 | 34.1225 | 2000.0 |
| 2017-02-22 08:04:00 | AAPL | Stock | 34.1225 | 34.1225 | 34.1225 | 34.1225 | 1200.0 |
| 2017-02-22 08:05:00 | AAPL | Stock | 34.1225 | 34.125 | 34.1225 | 34.125 | 8000.0 |
| 2017-02-22 08:06:00 | AAPL | Stock | 34.125 | 34.125 | 34.125 | 34.125 | 2000.0 |
| 2017-02-22 08:07:00 | AAPL | Stock | 34.1275 | 34.1275 | 34.1175 | 34.125 | 1800.0 |
| 2017-02-22 08:08:00 | AAPL | Stock | 34.125 | 34.125 | 34.125 | 34.125 | 800.0 |
| 2017-02-22 08:10:00 | AAPL | Stock | 34.125 | 34.125 | 34.125 | 34.125 | 1200.0 |
| 2017-02-22 08:11:00 | AAPL | Stock | 34.1325 | 34.135 | 34.1325 | 34.135 | 800.0 |
| 2017-02-22 08:12:00 | AAPL | Stock | 34.1325 | 34.1325 | 34.1325 | 34.1325 | 400.0 |
> showing 50 of 1,063,203 rows — these rows as CSV