PREVIEW / stock_1min / 2019-10-03
file: by_date/stock_1min/2019/2019-10-03.parquet size: 15.2 MB rows: 1,083,403 symbols: 2,138
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 |
|---|---|---|---|---|---|---|---|
| 2019-10-03 04:00:00 | AAPL | Stock | 54.825 | 54.825 | 54.825 | 54.825 | 3600.0 |
| 2019-10-03 04:03:00 | AAPL | Stock | 54.775 | 54.775 | 54.775 | 54.775 | 1216.0 |
| 2019-10-03 04:07:00 | AAPL | Stock | 54.775 | 54.775 | 54.775 | 54.775 | 1140.0 |
| 2019-10-03 04:12:00 | AAPL | Stock | 54.775 | 54.775 | 54.775 | 54.775 | 428.0 |
| 2019-10-03 04:20:00 | AAPL | Stock | 54.875 | 54.95 | 54.875 | 54.95 | 5716.0 |
| 2019-10-03 04:28:00 | AAPL | Stock | 54.95 | 54.95 | 54.95 | 54.95 | 1200.0 |
| 2019-10-03 04:29:00 | AAPL | Stock | 54.95 | 54.95 | 54.95 | 54.95 | 400.0 |
| 2019-10-03 05:10:00 | AAPL | Stock | 54.805 | 54.805 | 54.805 | 54.805 | 692.0 |
| 2019-10-03 05:35:00 | AAPL | Stock | 54.805 | 54.805 | 54.805 | 54.805 | 1200.0 |
| 2019-10-03 05:53:00 | AAPL | Stock | 54.825 | 54.825 | 54.825 | 54.825 | 2000.0 |
| 2019-10-03 05:56:00 | AAPL | Stock | 54.825 | 54.825 | 54.825 | 54.825 | 1632.0 |
| 2019-10-03 06:25:00 | AAPL | Stock | 54.8125 | 54.8125 | 54.8125 | 54.8125 | 18336.0 |
| 2019-10-03 06:33:00 | AAPL | Stock | 54.815 | 54.815 | 54.8125 | 54.8125 | 1412.0 |
| 2019-10-03 06:41:00 | AAPL | Stock | 54.7825 | 54.7825 | 54.7825 | 54.7825 | 400.0 |
| 2019-10-03 06:51:00 | AAPL | Stock | 54.75 | 54.75 | 54.75 | 54.75 | 400.0 |
| 2019-10-03 07:00:00 | AAPL | Stock | 54.795 | 54.795 | 54.725 | 54.725 | 20080.0 |
| 2019-10-03 07:01:00 | AAPL | Stock | 54.725 | 54.725 | 54.7225 | 54.725 | 3200.0 |
| 2019-10-03 07:02:00 | AAPL | Stock | 54.725 | 54.725 | 54.6925 | 54.6925 | 1228.0 |
| 2019-10-03 07:03:00 | AAPL | Stock | 54.69 | 54.735 | 54.6875 | 54.735 | 4828.0 |
| 2019-10-03 07:04:00 | AAPL | Stock | 54.735 | 54.735 | 54.6325 | 54.7 | 5404.0 |
| 2019-10-03 07:07:00 | AAPL | Stock | 54.675 | 54.675 | 54.675 | 54.675 | 6708.0 |
| 2019-10-03 07:10:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7125 | 54.7125 | 800.0 |
| 2019-10-03 07:11:00 | AAPL | Stock | 54.7075 | 54.7075 | 54.7075 | 54.7075 | 400.0 |
| 2019-10-03 07:14:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7125 | 54.7125 | 3896.0 |
| 2019-10-03 07:15:00 | AAPL | Stock | 54.725 | 54.725 | 54.725 | 54.725 | 4400.0 |
| 2019-10-03 07:20:00 | AAPL | Stock | 54.7025 | 54.7025 | 54.7025 | 54.7025 | 400.0 |
| 2019-10-03 07:23:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7125 | 54.7125 | 400.0 |
| 2019-10-03 07:31:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7125 | 54.7125 | 1928.0 |
| 2019-10-03 07:32:00 | AAPL | Stock | 54.69 | 54.69 | 54.6825 | 54.6875 | 4332.0 |
| 2019-10-03 07:34:00 | AAPL | Stock | 54.685 | 54.685 | 54.685 | 54.685 | 400.0 |
| 2019-10-03 07:37:00 | AAPL | Stock | 54.645 | 54.645 | 54.645 | 54.645 | 1400.0 |
| 2019-10-03 07:38:00 | AAPL | Stock | 54.6575 | 54.685 | 54.625 | 54.625 | 18252.0 |
| 2019-10-03 07:39:00 | AAPL | Stock | 54.6325 | 54.645 | 54.63 | 54.6325 | 6800.0 |
| 2019-10-03 07:42:00 | AAPL | Stock | 54.6375 | 54.6375 | 54.6375 | 54.6375 | 400.0 |
| 2019-10-03 07:43:00 | AAPL | Stock | 54.6375 | 54.6375 | 54.6325 | 54.6325 | 2400.0 |
| 2019-10-03 07:46:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.6725 | 54.6725 | 1308.0 |
| 2019-10-03 07:47:00 | AAPL | Stock | 54.67 | 54.67 | 54.655 | 54.655 | 2036.0 |
| 2019-10-03 07:48:00 | AAPL | Stock | 54.65 | 54.65 | 54.625 | 54.625 | 41640.0 |
| 2019-10-03 07:49:00 | AAPL | Stock | 54.61 | 54.6175 | 54.6 | 54.6 | 2504.0 |
| 2019-10-03 07:50:00 | AAPL | Stock | 54.6 | 54.6 | 54.595 | 54.595 | 2628.0 |
| 2019-10-03 07:51:00 | AAPL | Stock | 54.605 | 54.605 | 54.605 | 54.605 | 800.0 |
| 2019-10-03 07:52:00 | AAPL | Stock | 54.59 | 54.59 | 54.545 | 54.5475 | 9980.0 |
| 2019-10-03 07:53:00 | AAPL | Stock | 54.5425 | 54.5425 | 54.525 | 54.525 | 7904.0 |
| 2019-10-03 07:54:00 | AAPL | Stock | 54.55 | 54.55 | 54.55 | 54.55 | 1200.0 |
| 2019-10-03 07:55:00 | AAPL | Stock | 54.5375 | 54.5375 | 54.5375 | 54.5375 | 1540.0 |
| 2019-10-03 07:57:00 | AAPL | Stock | 54.55 | 54.5625 | 54.55 | 54.5625 | 6800.0 |
| 2019-10-03 07:59:00 | AAPL | Stock | 54.5625 | 54.5625 | 54.5525 | 54.5525 | 1660.0 |
| 2019-10-03 08:00:00 | AAPL | Stock | 54.7 | 54.8125 | 54.525 | 54.555 | 45420.0 |
| 2019-10-03 08:01:00 | AAPL | Stock | 54.5825 | 54.6075 | 54.5825 | 54.6075 | 2400.0 |
| 2019-10-03 08:02:00 | AAPL | Stock | 54.5975 | 54.5975 | 54.575 | 54.575 | 14040.0 |
> showing 50 of 1,083,403 rows — these rows as CSV