PREVIEW / stock_1min / 2018-10-10
file: by_date/stock_1min/2018/2018-10-10.parquet size: 17.7 MB rows: 1,161,724 symbols: 2,332
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-10-10 04:04:00 | AAPL | Stock | 56.78 | 56.78 | 56.78 | 56.78 | 520.0 |
| 2018-10-10 04:09:00 | AAPL | Stock | 56.7125 | 56.78 | 56.7125 | 56.78 | 9080.0 |
| 2018-10-10 04:10:00 | AAPL | Stock | 56.735 | 56.735 | 56.735 | 56.735 | 4800.0 |
| 2018-10-10 04:15:00 | AAPL | Stock | 56.7125 | 56.7125 | 56.7125 | 56.7125 | 1920.0 |
| 2018-10-10 04:52:00 | AAPL | Stock | 56.7 | 56.7 | 56.7 | 56.7 | 1200.0 |
| 2018-10-10 05:02:00 | AAPL | Stock | 56.735 | 56.75 | 56.735 | 56.75 | 4040.0 |
| 2018-10-10 05:25:00 | AAPL | Stock | 56.705 | 56.7075 | 56.705 | 56.705 | 4864.0 |
| 2018-10-10 05:28:00 | AAPL | Stock | 56.7 | 56.705 | 56.7 | 56.705 | 1200.0 |
| 2018-10-10 05:54:00 | AAPL | Stock | 56.705 | 56.705 | 56.705 | 56.705 | 400.0 |
| 2018-10-10 06:02:00 | AAPL | Stock | 56.7175 | 56.7175 | 56.7175 | 56.7175 | 624.0 |
| 2018-10-10 06:07:00 | AAPL | Stock | 56.7175 | 56.7175 | 56.7175 | 56.7175 | 3128.0 |
| 2018-10-10 06:17:00 | AAPL | Stock | 56.7175 | 56.7175 | 56.7175 | 56.7175 | 1840.0 |
| 2018-10-10 06:20:00 | AAPL | Stock | 56.7175 | 56.7175 | 56.7175 | 56.7175 | 400.0 |
| 2018-10-10 06:25:00 | AAPL | Stock | 56.7175 | 56.7175 | 56.7175 | 56.7175 | 608.0 |
| 2018-10-10 07:00:00 | AAPL | Stock | 56.725 | 56.725 | 56.725 | 56.725 | 1208.0 |
| 2018-10-10 07:01:00 | AAPL | Stock | 56.715 | 56.715 | 56.7075 | 56.7075 | 4800.0 |
| 2018-10-10 07:02:00 | AAPL | Stock | 56.6625 | 56.7 | 56.655 | 56.6875 | 2000.0 |
| 2018-10-10 07:03:00 | AAPL | Stock | 56.6875 | 56.6875 | 56.6875 | 56.6875 | 6688.0 |
| 2018-10-10 07:04:00 | AAPL | Stock | 56.6875 | 56.7075 | 56.6875 | 56.7075 | 1960.0 |
| 2018-10-10 07:05:00 | AAPL | Stock | 56.6875 | 56.6875 | 56.6875 | 56.6875 | 800.0 |
| 2018-10-10 07:09:00 | AAPL | Stock | 56.7 | 56.7075 | 56.7 | 56.7075 | 5200.0 |
| 2018-10-10 07:10:00 | AAPL | Stock | 56.72 | 56.72 | 56.72 | 56.72 | 3960.0 |
| 2018-10-10 07:11:00 | AAPL | Stock | 56.72 | 56.72 | 56.72 | 56.72 | 1360.0 |
| 2018-10-10 07:12:00 | AAPL | Stock | 56.7375 | 56.7375 | 56.7375 | 56.7375 | 400.0 |
| 2018-10-10 07:14:00 | AAPL | Stock | 56.7425 | 56.7425 | 56.735 | 56.735 | 800.0 |
| 2018-10-10 07:16:00 | AAPL | Stock | 56.7375 | 56.75 | 56.7375 | 56.7475 | 9400.0 |
| 2018-10-10 07:17:00 | AAPL | Stock | 56.7475 | 56.7825 | 56.7475 | 56.7825 | 8240.0 |
| 2018-10-10 07:20:00 | AAPL | Stock | 56.8125 | 56.8125 | 56.8125 | 56.8125 | 5844.0 |
| 2018-10-10 07:21:00 | AAPL | Stock | 56.8125 | 56.8125 | 56.7875 | 56.7875 | 2600.0 |
| 2018-10-10 07:23:00 | AAPL | Stock | 56.77 | 56.77 | 56.7675 | 56.7675 | 16000.0 |
| 2018-10-10 07:24:00 | AAPL | Stock | 56.8125 | 56.84 | 56.8125 | 56.84 | 23240.0 |
| 2018-10-10 07:25:00 | AAPL | Stock | 56.8575 | 56.8575 | 56.8575 | 56.8575 | 15600.0 |
| 2018-10-10 07:27:00 | AAPL | Stock | 56.8575 | 56.8575 | 56.8575 | 56.8575 | 4000.0 |
| 2018-10-10 07:28:00 | AAPL | Stock | 56.8575 | 56.8575 | 56.8575 | 56.8575 | 740.0 |
| 2018-10-10 07:30:00 | AAPL | Stock | 56.855 | 56.855 | 56.775 | 56.775 | 4000.0 |
| 2018-10-10 07:32:00 | AAPL | Stock | 56.79 | 56.8125 | 56.79 | 56.8125 | 800.0 |
| 2018-10-10 07:33:00 | AAPL | Stock | 56.795 | 56.795 | 56.7625 | 56.7625 | 14400.0 |
| 2018-10-10 07:34:00 | AAPL | Stock | 56.7625 | 56.7625 | 56.7625 | 56.7625 | 1812.0 |
| 2018-10-10 07:35:00 | AAPL | Stock | 56.7575 | 56.7575 | 56.75 | 56.75 | 6960.0 |
| 2018-10-10 07:36:00 | AAPL | Stock | 56.7375 | 56.75 | 56.7375 | 56.75 | 1200.0 |
| 2018-10-10 07:37:00 | AAPL | Stock | 56.75 | 56.75 | 56.75 | 56.75 | 2032.0 |
| 2018-10-10 07:38:00 | AAPL | Stock | 56.75 | 56.75 | 56.7375 | 56.7375 | 800.0 |
| 2018-10-10 07:39:00 | AAPL | Stock | 56.77 | 56.77 | 56.74 | 56.74 | 5600.0 |
| 2018-10-10 07:41:00 | AAPL | Stock | 56.75 | 56.75 | 56.75 | 56.75 | 400.0 |
| 2018-10-10 07:43:00 | AAPL | Stock | 56.7475 | 56.7475 | 56.7475 | 56.7475 | 584.0 |
| 2018-10-10 07:45:00 | AAPL | Stock | 56.7375 | 56.7375 | 56.7225 | 56.7225 | 8732.0 |
| 2018-10-10 07:46:00 | AAPL | Stock | 56.7075 | 56.7075 | 56.69 | 56.69 | 2800.0 |
| 2018-10-10 07:47:00 | AAPL | Stock | 56.7225 | 56.7225 | 56.7175 | 56.7175 | 2156.0 |
| 2018-10-10 07:49:00 | AAPL | Stock | 56.7 | 56.7 | 56.7 | 56.7 | 400.0 |
| 2018-10-10 07:50:00 | AAPL | Stock | 56.705 | 56.705 | 56.7025 | 56.7025 | 2544.0 |
> showing 50 of 1,161,724 rows — these rows as CSV