PREVIEW / stock_1min / 2017-12-28
file: by_date/stock_1min/2017/2017-12-28.parquet size: 14.1 MB rows: 1,011,652 symbols: 2,424
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-12-28 04:00:00 | AAPL | Stock | 42.69 | 42.69 | 42.69 | 42.69 | 1000.0 |
| 2017-12-28 04:04:00 | AAPL | Stock | 42.63 | 42.63 | 42.63 | 42.63 | 468.0 |
| 2017-12-28 04:15:00 | AAPL | Stock | 42.7125 | 42.7125 | 42.7125 | 42.7125 | 800.0 |
| 2017-12-28 04:22:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 800.0 |
| 2017-12-28 04:29:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 1600.0 |
| 2017-12-28 04:31:00 | AAPL | Stock | 42.6375 | 42.6375 | 42.6375 | 42.6375 | 400.0 |
| 2017-12-28 05:05:00 | AAPL | Stock | 42.6575 | 42.6625 | 42.6575 | 42.6625 | 1912.0 |
| 2017-12-28 05:18:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 2344.0 |
| 2017-12-28 05:27:00 | AAPL | Stock | 42.625 | 42.63 | 42.625 | 42.625 | 7600.0 |
| 2017-12-28 05:36:00 | AAPL | Stock | 42.6975 | 42.6975 | 42.6975 | 42.6975 | 792.0 |
| 2017-12-28 05:38:00 | AAPL | Stock | 42.6325 | 42.6325 | 42.6325 | 42.6325 | 400.0 |
| 2017-12-28 06:09:00 | AAPL | Stock | 42.675 | 42.69 | 42.675 | 42.69 | 2100.0 |
| 2017-12-28 06:31:00 | AAPL | Stock | 42.7125 | 42.7125 | 42.7125 | 42.7125 | 680.0 |
| 2017-12-28 06:56:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 3600.0 |
| 2017-12-28 07:00:00 | AAPL | Stock | 42.7225 | 42.74 | 42.7225 | 42.725 | 4480.0 |
| 2017-12-28 07:01:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 3200.0 |
| 2017-12-28 07:04:00 | AAPL | Stock | 42.7125 | 42.7125 | 42.7125 | 42.7125 | 3684.0 |
| 2017-12-28 07:06:00 | AAPL | Stock | 42.735 | 42.735 | 42.7125 | 42.7125 | 3580.0 |
| 2017-12-28 07:08:00 | AAPL | Stock | 42.7275 | 42.7275 | 42.7 | 42.7 | 4592.0 |
| 2017-12-28 07:09:00 | AAPL | Stock | 42.7 | 42.725 | 42.6825 | 42.725 | 8800.0 |
| 2017-12-28 07:15:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 2168.0 |
| 2017-12-28 07:18:00 | AAPL | Stock | 42.7375 | 42.7375 | 42.7375 | 42.7375 | 800.0 |
| 2017-12-28 07:19:00 | AAPL | Stock | 42.745 | 42.745 | 42.725 | 42.725 | 21200.0 |
| 2017-12-28 07:21:00 | AAPL | Stock | 42.7375 | 42.7375 | 42.7375 | 42.7375 | 19200.0 |
| 2017-12-28 07:22:00 | AAPL | Stock | 42.75 | 42.7625 | 42.75 | 42.7625 | 3008.0 |
| 2017-12-28 07:23:00 | AAPL | Stock | 42.7625 | 42.7625 | 42.7625 | 42.7625 | 424.0 |
| 2017-12-28 07:24:00 | AAPL | Stock | 42.7925 | 42.7925 | 42.7625 | 42.7625 | 3100.0 |
| 2017-12-28 07:25:00 | AAPL | Stock | 42.7625 | 42.7625 | 42.7625 | 42.7625 | 4000.0 |
| 2017-12-28 07:26:00 | AAPL | Stock | 42.7625 | 42.7625 | 42.7625 | 42.7625 | 3124.0 |
| 2017-12-28 07:27:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 800.0 |
| 2017-12-28 07:28:00 | AAPL | Stock | 42.76 | 42.76 | 42.76 | 42.76 | 4000.0 |
| 2017-12-28 07:29:00 | AAPL | Stock | 42.77 | 42.77 | 42.77 | 42.77 | 2004.0 |
| 2017-12-28 07:36:00 | AAPL | Stock | 42.7725 | 42.7725 | 42.7725 | 42.7725 | 800.0 |
| 2017-12-28 07:37:00 | AAPL | Stock | 42.775 | 42.775 | 42.775 | 42.775 | 760.0 |
| 2017-12-28 07:38:00 | AAPL | Stock | 42.7875 | 42.7875 | 42.7875 | 42.7875 | 9680.0 |
| 2017-12-28 07:40:00 | AAPL | Stock | 42.775 | 42.775 | 42.775 | 42.775 | 5584.0 |
| 2017-12-28 07:48:00 | AAPL | Stock | 42.7575 | 42.7575 | 42.7575 | 42.7575 | 544.0 |
| 2017-12-28 07:50:00 | AAPL | Stock | 42.7575 | 42.7575 | 42.75 | 42.75 | 1144.0 |
| 2017-12-28 07:51:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 1272.0 |
| 2017-12-28 07:57:00 | AAPL | Stock | 42.7525 | 42.7675 | 42.75 | 42.7675 | 9808.0 |
| 2017-12-28 07:59:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 1024.0 |
| 2017-12-28 08:00:00 | AAPL | Stock | 42.745 | 42.7875 | 42.725 | 42.75 | 20160.0 |
| 2017-12-28 08:01:00 | AAPL | Stock | 42.745 | 42.745 | 42.745 | 42.745 | 4000.0 |
| 2017-12-28 08:02:00 | AAPL | Stock | 42.75 | 42.7575 | 42.75 | 42.7575 | 5600.0 |
| 2017-12-28 08:03:00 | AAPL | Stock | 42.7575 | 42.7575 | 42.75 | 42.75 | 11520.0 |
| 2017-12-28 08:04:00 | AAPL | Stock | 42.75 | 42.75 | 42.725 | 42.735 | 2684.0 |
| 2017-12-28 08:05:00 | AAPL | Stock | 42.73 | 42.73 | 42.725 | 42.725 | 1600.0 |
| 2017-12-28 08:06:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 2432.0 |
| 2017-12-28 08:07:00 | AAPL | Stock | 42.7275 | 42.7275 | 42.725 | 42.725 | 1200.0 |
| 2017-12-28 08:09:00 | AAPL | Stock | 42.73 | 42.73 | 42.73 | 42.73 | 800.0 |
> showing 50 of 1,011,652 rows — these rows as CSV