PREVIEW / stock_1min / 2018-03-07
file: by_date/stock_1min/2018/2018-03-07.parquet size: 15.6 MB rows: 1,112,979 symbols: 2,378
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 |
|---|---|---|---|---|---|---|---|
| 2018-03-07 04:00:00 | AAPL | Stock | 43.75 | 43.75 | 43.675 | 43.675 | 20164.0 |
| 2018-03-07 04:10:00 | AAPL | Stock | 43.74 | 43.74 | 43.735 | 43.735 | 12568.0 |
| 2018-03-07 04:11:00 | AAPL | Stock | 43.745 | 43.745 | 43.7 | 43.7 | 11280.0 |
| 2018-03-07 04:12:00 | AAPL | Stock | 43.68 | 43.68 | 43.6775 | 43.6775 | 1400.0 |
| 2018-03-07 04:14:00 | AAPL | Stock | 43.6775 | 43.6775 | 43.6775 | 43.6775 | 400.0 |
| 2018-03-07 04:43:00 | AAPL | Stock | 43.65 | 43.65 | 43.65 | 43.65 | 400.0 |
| 2018-03-07 04:50:00 | AAPL | Stock | 43.695 | 43.7475 | 43.695 | 43.7 | 2148.0 |
| 2018-03-07 04:57:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 5600.0 |
| 2018-03-07 05:05:00 | AAPL | Stock | 43.7475 | 43.75 | 43.7475 | 43.75 | 4400.0 |
| 2018-03-07 05:06:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 800.0 |
| 2018-03-07 05:19:00 | AAPL | Stock | 43.77 | 43.77 | 43.77 | 43.77 | 2000.0 |
| 2018-03-07 05:21:00 | AAPL | Stock | 43.815 | 43.815 | 43.8125 | 43.8125 | 8628.0 |
| 2018-03-07 05:22:00 | AAPL | Stock | 43.8125 | 43.8125 | 43.8125 | 43.8125 | 800.0 |
| 2018-03-07 05:37:00 | AAPL | Stock | 43.7575 | 43.7575 | 43.7575 | 43.7575 | 400.0 |
| 2018-03-07 05:38:00 | AAPL | Stock | 43.78 | 43.78 | 43.78 | 43.78 | 400.0 |
| 2018-03-07 05:39:00 | AAPL | Stock | 43.7525 | 43.7525 | 43.7525 | 43.7525 | 400.0 |
| 2018-03-07 05:55:00 | AAPL | Stock | 43.755 | 43.755 | 43.755 | 43.755 | 400.0 |
| 2018-03-07 05:58:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 7964.0 |
| 2018-03-07 06:00:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 800.0 |
| 2018-03-07 06:05:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 400.0 |
| 2018-03-07 06:09:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7125 | 43.7125 | 3064.0 |
| 2018-03-07 06:10:00 | AAPL | Stock | 43.7075 | 43.7075 | 43.69 | 43.69 | 6000.0 |
| 2018-03-07 06:11:00 | AAPL | Stock | 43.69 | 43.7125 | 43.69 | 43.7125 | 7284.0 |
| 2018-03-07 06:16:00 | AAPL | Stock | 43.675 | 43.675 | 43.6575 | 43.6575 | 2400.0 |
| 2018-03-07 06:18:00 | AAPL | Stock | 43.6525 | 43.6575 | 43.6525 | 43.6575 | 1208.0 |
| 2018-03-07 06:19:00 | AAPL | Stock | 43.675 | 43.675 | 43.6625 | 43.6625 | 6800.0 |
| 2018-03-07 06:27:00 | AAPL | Stock | 43.6725 | 43.6725 | 43.6625 | 43.6625 | 9632.0 |
| 2018-03-07 06:30:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 1864.0 |
| 2018-03-07 06:38:00 | AAPL | Stock | 43.6825 | 43.6825 | 43.675 | 43.675 | 10548.0 |
| 2018-03-07 06:46:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7025 | 43.7025 | 800.0 |
| 2018-03-07 07:00:00 | AAPL | Stock | 43.7225 | 43.775 | 43.7125 | 43.775 | 26592.0 |
| 2018-03-07 07:01:00 | AAPL | Stock | 43.755 | 43.84 | 43.75 | 43.7525 | 14816.0 |
| 2018-03-07 07:02:00 | AAPL | Stock | 43.7525 | 43.7525 | 43.725 | 43.75 | 17688.0 |
| 2018-03-07 07:03:00 | AAPL | Stock | 43.7875 | 43.7875 | 43.74 | 43.75 | 4400.0 |
| 2018-03-07 07:04:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 4200.0 |
| 2018-03-07 07:06:00 | AAPL | Stock | 43.7375 | 43.7375 | 43.7375 | 43.7375 | 400.0 |
| 2018-03-07 07:07:00 | AAPL | Stock | 43.745 | 43.775 | 43.745 | 43.775 | 3404.0 |
| 2018-03-07 07:08:00 | AAPL | Stock | 43.775 | 43.775 | 43.74 | 43.74 | 12140.0 |
| 2018-03-07 07:10:00 | AAPL | Stock | 43.7725 | 43.7925 | 43.7725 | 43.7925 | 800.0 |
| 2018-03-07 07:12:00 | AAPL | Stock | 43.7875 | 43.8 | 43.7875 | 43.8 | 5380.0 |
| 2018-03-07 07:13:00 | AAPL | Stock | 43.8 | 43.8 | 43.7975 | 43.7975 | 6972.0 |
| 2018-03-07 07:14:00 | AAPL | Stock | 43.81 | 43.81 | 43.795 | 43.795 | 6440.0 |
| 2018-03-07 07:15:00 | AAPL | Stock | 43.795 | 43.7975 | 43.7875 | 43.7875 | 4624.0 |
| 2018-03-07 07:16:00 | AAPL | Stock | 43.8 | 43.8 | 43.775 | 43.7875 | 19308.0 |
| 2018-03-07 07:17:00 | AAPL | Stock | 43.7875 | 43.8 | 43.7875 | 43.8 | 12264.0 |
| 2018-03-07 07:18:00 | AAPL | Stock | 43.8 | 43.8125 | 43.7825 | 43.8125 | 28948.0 |
| 2018-03-07 07:19:00 | AAPL | Stock | 43.8125 | 43.8125 | 43.79 | 43.79 | 30848.0 |
| 2018-03-07 07:20:00 | AAPL | Stock | 43.7925 | 43.8025 | 43.775 | 43.7875 | 25136.0 |
| 2018-03-07 07:21:00 | AAPL | Stock | 43.7925 | 43.7925 | 43.7925 | 43.7925 | 20000.0 |
| 2018-03-07 07:22:00 | AAPL | Stock | 43.765 | 43.765 | 43.75 | 43.75 | 14396.0 |
> showing 50 of 1,112,979 rows — these rows as CSV