PREVIEW / stock_1min / 2018-04-06
file: by_date/stock_1min/2018/2018-04-06.parquet size: 15.3 MB rows: 1,095,368 symbols: 2,367
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-04-06 04:00:00 | AAPL | Stock | 42.7025 | 42.715 | 42.6275 | 42.715 | 5976.0 |
| 2018-04-06 04:01:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 784.0 |
| 2018-04-06 04:02:00 | AAPL | Stock | 42.75 | 42.7525 | 42.75 | 42.7525 | 2600.0 |
| 2018-04-06 04:04:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 5412.0 |
| 2018-04-06 04:06:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 1200.0 |
| 2018-04-06 04:10:00 | AAPL | Stock | 42.735 | 42.735 | 42.735 | 42.735 | 400.0 |
| 2018-04-06 04:33:00 | AAPL | Stock | 42.7875 | 42.7875 | 42.7875 | 42.7875 | 2000.0 |
| 2018-04-06 04:41:00 | AAPL | Stock | 42.7875 | 42.7875 | 42.7875 | 42.7875 | 400.0 |
| 2018-04-06 04:56:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 800.0 |
| 2018-04-06 05:05:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 3200.0 |
| 2018-04-06 05:06:00 | AAPL | Stock | 42.7 | 42.7 | 42.7 | 42.7 | 1200.0 |
| 2018-04-06 05:20:00 | AAPL | Stock | 42.73 | 42.73 | 42.73 | 42.73 | 1200.0 |
| 2018-04-06 05:22:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 400.0 |
| 2018-04-06 05:24:00 | AAPL | Stock | 42.75 | 42.75 | 42.75 | 42.75 | 2716.0 |
| 2018-04-06 05:45:00 | AAPL | Stock | 42.8075 | 42.8075 | 42.8075 | 42.8075 | 780.0 |
| 2018-04-06 06:11:00 | AAPL | Stock | 42.825 | 42.825 | 42.825 | 42.825 | 800.0 |
| 2018-04-06 06:27:00 | AAPL | Stock | 42.85 | 42.85 | 42.825 | 42.825 | 3600.0 |
| 2018-04-06 06:28:00 | AAPL | Stock | 42.85 | 42.85 | 42.85 | 42.85 | 1204.0 |
| 2018-04-06 06:34:00 | AAPL | Stock | 42.85 | 42.85 | 42.85 | 42.85 | 400.0 |
| 2018-04-06 06:35:00 | AAPL | Stock | 42.85 | 42.85 | 42.85 | 42.85 | 800.0 |
| 2018-04-06 06:36:00 | AAPL | Stock | 42.85 | 42.85 | 42.825 | 42.825 | 2664.0 |
| 2018-04-06 06:41:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.8125 | 42.8125 | 2000.0 |
| 2018-04-06 06:43:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.8125 | 42.8125 | 1200.0 |
| 2018-04-06 06:44:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.8125 | 42.8125 | 1200.0 |
| 2018-04-06 06:46:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.8125 | 42.8125 | 1200.0 |
| 2018-04-06 06:47:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.8125 | 42.8125 | 1600.0 |
| 2018-04-06 06:48:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.7775 | 42.7775 | 6304.0 |
| 2018-04-06 06:54:00 | AAPL | Stock | 42.7675 | 42.7675 | 42.7675 | 42.7675 | 4000.0 |
| 2018-04-06 06:55:00 | AAPL | Stock | 42.7675 | 42.7675 | 42.7675 | 42.7675 | 3600.0 |
| 2018-04-06 06:58:00 | AAPL | Stock | 42.755 | 42.755 | 42.755 | 42.755 | 600.0 |
| 2018-04-06 07:00:00 | AAPL | Stock | 42.76 | 42.8 | 42.675 | 42.6875 | 14488.0 |
| 2018-04-06 07:01:00 | AAPL | Stock | 42.69 | 42.69 | 42.69 | 42.69 | 1200.0 |
| 2018-04-06 07:02:00 | AAPL | Stock | 42.69 | 42.7475 | 42.69 | 42.7475 | 2000.0 |
| 2018-04-06 07:03:00 | AAPL | Stock | 42.695 | 42.695 | 42.6875 | 42.6875 | 7760.0 |
| 2018-04-06 07:04:00 | AAPL | Stock | 42.7225 | 42.7225 | 42.7225 | 42.7225 | 440.0 |
| 2018-04-06 07:05:00 | AAPL | Stock | 42.695 | 42.695 | 42.6925 | 42.6925 | 5792.0 |
| 2018-04-06 07:06:00 | AAPL | Stock | 42.6875 | 42.6875 | 42.65 | 42.65 | 15504.0 |
| 2018-04-06 07:07:00 | AAPL | Stock | 42.625 | 42.625 | 42.6225 | 42.6225 | 14860.0 |
| 2018-04-06 07:08:00 | AAPL | Stock | 42.6 | 42.6 | 42.5925 | 42.5925 | 12568.0 |
| 2018-04-06 07:09:00 | AAPL | Stock | 42.5925 | 42.5925 | 42.5375 | 42.5375 | 22772.0 |
| 2018-04-06 07:10:00 | AAPL | Stock | 42.54 | 42.55 | 42.525 | 42.54 | 31388.0 |
| 2018-04-06 07:11:00 | AAPL | Stock | 42.525 | 42.5375 | 42.5175 | 42.5375 | 4840.0 |
| 2018-04-06 07:12:00 | AAPL | Stock | 42.545 | 42.5925 | 42.5375 | 42.5925 | 26272.0 |
| 2018-04-06 07:14:00 | AAPL | Stock | 42.6 | 42.6 | 42.555 | 42.555 | 6800.0 |
| 2018-04-06 07:16:00 | AAPL | Stock | 42.5875 | 42.5875 | 42.5875 | 42.5875 | 400.0 |
| 2018-04-06 07:17:00 | AAPL | Stock | 42.56 | 42.5875 | 42.55 | 42.555 | 5300.0 |
| 2018-04-06 07:18:00 | AAPL | Stock | 42.5475 | 42.555 | 42.5475 | 42.555 | 8124.0 |
| 2018-04-06 07:19:00 | AAPL | Stock | 42.5625 | 42.5625 | 42.5625 | 42.5625 | 1200.0 |
| 2018-04-06 07:20:00 | AAPL | Stock | 42.5875 | 42.5875 | 42.555 | 42.5875 | 5252.0 |
| 2018-04-06 07:22:00 | AAPL | Stock | 42.6175 | 42.6175 | 42.6175 | 42.6175 | 500.0 |
> showing 50 of 1,095,368 rows — these rows as CSV