PREVIEW / stock_1min / 2015-01-21
file: by_date/stock_1min/2015/2015-01-21.parquet size: 14.9 MB rows: 1,080,633 symbols: 2,873
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-21 04:12:00 | AAPL | Stock | 27.2975 | 27.2975 | 27.2975 | 27.2975 | 3932.0 |
| 2015-01-21 04:21:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.2625 | 27.2625 | 4000.0 |
| 2015-01-21 04:27:00 | AAPL | Stock | 27.295 | 27.295 | 27.295 | 27.295 | 400.0 |
| 2015-01-21 04:29:00 | AAPL | Stock | 27.285 | 27.285 | 27.285 | 27.285 | 2000.0 |
| 2015-01-21 04:30:00 | AAPL | Stock | 27.29 | 27.29 | 27.29 | 27.29 | 2000.0 |
| 2015-01-21 04:31:00 | AAPL | Stock | 27.29 | 27.29 | 27.29 | 27.29 | 1600.0 |
| 2015-01-21 04:45:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.2525 | 27.2525 | 4404.0 |
| 2015-01-21 05:13:00 | AAPL | Stock | 27.255 | 27.255 | 27.255 | 27.255 | 400.0 |
| 2015-01-21 05:39:00 | AAPL | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 400.0 |
| 2015-01-21 05:40:00 | AAPL | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 4152.0 |
| 2015-01-21 05:42:00 | AAPL | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 400.0 |
| 2015-01-21 05:44:00 | AAPL | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 1600.0 |
| 2015-01-21 05:46:00 | AAPL | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 400.0 |
| 2015-01-21 05:47:00 | AAPL | Stock | 27.2325 | 27.2325 | 27.2325 | 27.2325 | 400.0 |
| 2015-01-21 06:08:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 400.0 |
| 2015-01-21 06:11:00 | AAPL | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 4000.0 |
| 2015-01-21 06:12:00 | AAPL | Stock | 27.2475 | 27.2475 | 27.2475 | 27.2475 | 4000.0 |
| 2015-01-21 06:13:00 | AAPL | Stock | 27.2475 | 27.2475 | 27.245 | 27.245 | 5844.0 |
| 2015-01-21 06:16:00 | AAPL | Stock | 27.2475 | 27.2475 | 27.245 | 27.245 | 4244.0 |
| 2015-01-21 06:17:00 | AAPL | Stock | 27.2475 | 27.2475 | 27.24 | 27.24 | 2844.0 |
| 2015-01-21 06:18:00 | AAPL | Stock | 27.2325 | 27.2325 | 27.2325 | 27.2325 | 1164.0 |
| 2015-01-21 06:19:00 | AAPL | Stock | 27.24 | 27.24 | 27.24 | 27.24 | 800.0 |
| 2015-01-21 06:20:00 | AAPL | Stock | 27.2475 | 27.2825 | 27.2475 | 27.2475 | 2600.0 |
| 2015-01-21 06:42:00 | AAPL | Stock | 27.2925 | 27.2925 | 27.2925 | 27.2925 | 800.0 |
| 2015-01-21 06:51:00 | AAPL | Stock | 27.2525 | 27.2525 | 27.2525 | 27.2525 | 1064.0 |
| 2015-01-21 06:58:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.25 | 27.25 | 5276.0 |
| 2015-01-21 06:59:00 | AAPL | Stock | 27.2475 | 27.2475 | 27.2475 | 27.2475 | 400.0 |
| 2015-01-21 07:00:00 | AAPL | Stock | 27.2475 | 27.2475 | 27.2475 | 27.2475 | 7600.0 |
| 2015-01-21 07:02:00 | AAPL | Stock | 27.24 | 27.25 | 27.24 | 27.25 | 4400.0 |
| 2015-01-21 07:06:00 | AAPL | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 800.0 |
| 2015-01-21 07:09:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 5200.0 |
| 2015-01-21 07:10:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 4800.0 |
| 2015-01-21 07:12:00 | AAPL | Stock | 27.225 | 27.225 | 27.225 | 27.225 | 2800.0 |
| 2015-01-21 07:13:00 | AAPL | Stock | 27.21 | 27.21 | 27.21 | 27.21 | 2000.0 |
| 2015-01-21 07:14:00 | AAPL | Stock | 27.2075 | 27.2075 | 27.2075 | 27.2075 | 2800.0 |
| 2015-01-21 07:15:00 | AAPL | Stock | 27.2075 | 27.2075 | 27.2075 | 27.2075 | 2564.0 |
| 2015-01-21 07:16:00 | AAPL | Stock | 27.2075 | 27.2075 | 27.2075 | 27.2075 | 8800.0 |
| 2015-01-21 07:17:00 | AAPL | Stock | 27.2075 | 27.2075 | 27.2075 | 27.2075 | 4000.0 |
| 2015-01-21 07:19:00 | AAPL | Stock | 27.205 | 27.205 | 27.205 | 27.205 | 2000.0 |
| 2015-01-21 07:20:00 | AAPL | Stock | 27.2075 | 27.2075 | 27.2075 | 27.2075 | 400.0 |
| 2015-01-21 07:22:00 | AAPL | Stock | 27.2075 | 27.2075 | 27.2075 | 27.2075 | 4000.0 |
| 2015-01-21 07:27:00 | AAPL | Stock | 27.2025 | 27.2025 | 27.2 | 27.2 | 5964.0 |
| 2015-01-21 07:28:00 | AAPL | Stock | 27.19 | 27.19 | 27.19 | 27.19 | 2400.0 |
| 2015-01-21 07:29:00 | AAPL | Stock | 27.2025 | 27.2025 | 27.2025 | 27.2025 | 1564.0 |
| 2015-01-21 07:30:00 | AAPL | Stock | 27.19 | 27.19 | 27.1875 | 27.1875 | 10880.0 |
| 2015-01-21 07:31:00 | AAPL | Stock | 27.185 | 27.185 | 27.18 | 27.18 | 3616.0 |
| 2015-01-21 07:32:00 | AAPL | Stock | 27.175 | 27.175 | 27.175 | 27.175 | 1868.0 |
| 2015-01-21 07:33:00 | AAPL | Stock | 27.175 | 27.175 | 27.175 | 27.175 | 1200.0 |
| 2015-01-21 07:38:00 | AAPL | Stock | 27.1675 | 27.1675 | 27.1675 | 27.1675 | 1800.0 |
| 2015-01-21 07:39:00 | AAPL | Stock | 27.1625 | 27.1625 | 27.1625 | 27.1625 | 6000.0 |
> showing 50 of 1,080,633 rows — these rows as CSV