PREVIEW / stock_1min / 2020-07-17
file: by_date/stock_1min/2020/2020-07-17.parquet size: 19.6 MB rows: 1,244,845 symbols: 2,076
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 |
|---|---|---|---|---|---|---|---|
| 2020-07-17 04:00:00 | AAPL | Stock | 96.2875 | 96.2875 | 96.2875 | 96.2875 | 680.0 |
| 2020-07-17 04:01:00 | AAPL | Stock | 96.255 | 96.255 | 96.255 | 96.255 | 436.0 |
| 2020-07-17 04:16:00 | AAPL | Stock | 96.495 | 96.5 | 96.495 | 96.5 | 1840.0 |
| 2020-07-17 04:19:00 | AAPL | Stock | 96.5 | 96.5125 | 96.5 | 96.5125 | 2800.0 |
| 2020-07-17 04:30:00 | AAPL | Stock | 96.615 | 96.615 | 96.615 | 96.615 | 400.0 |
| 2020-07-17 05:00:00 | AAPL | Stock | 96.6325 | 96.6325 | 96.615 | 96.615 | 1528.0 |
| 2020-07-17 05:04:00 | AAPL | Stock | 96.5725 | 96.5725 | 96.5025 | 96.5025 | 2872.0 |
| 2020-07-17 05:37:00 | AAPL | Stock | 96.75 | 96.75 | 96.75 | 96.75 | 4000.0 |
| 2020-07-17 05:38:00 | AAPL | Stock | 96.75 | 96.75 | 96.75 | 96.75 | 548.0 |
| 2020-07-17 05:45:00 | AAPL | Stock | 96.67 | 96.67 | 96.67 | 96.67 | 720.0 |
| 2020-07-17 05:50:00 | AAPL | Stock | 96.7875 | 96.7875 | 96.7875 | 96.7875 | 800.0 |
| 2020-07-17 05:53:00 | AAPL | Stock | 96.6825 | 96.6825 | 96.6825 | 96.6825 | 800.0 |
| 2020-07-17 05:56:00 | AAPL | Stock | 96.6825 | 96.6825 | 96.6825 | 96.6825 | 800.0 |
| 2020-07-17 05:58:00 | AAPL | Stock | 96.6625 | 96.6625 | 96.6525 | 96.6525 | 1392.0 |
| 2020-07-17 06:00:00 | AAPL | Stock | 96.6525 | 96.6525 | 96.6525 | 96.6525 | 400.0 |
| 2020-07-17 06:22:00 | AAPL | Stock | 96.6375 | 96.6375 | 96.6375 | 96.6375 | 400.0 |
| 2020-07-17 06:35:00 | AAPL | Stock | 96.7 | 96.7 | 96.7 | 96.7 | 2400.0 |
| 2020-07-17 06:36:00 | AAPL | Stock | 96.7 | 96.7 | 96.7 | 96.7 | 400.0 |
| 2020-07-17 07:00:00 | AAPL | Stock | 96.6525 | 96.7425 | 96.64 | 96.725 | 11092.0 |
| 2020-07-17 07:01:00 | AAPL | Stock | 96.725 | 96.805 | 96.725 | 96.805 | 5660.0 |
| 2020-07-17 07:02:00 | AAPL | Stock | 96.7725 | 96.8225 | 96.7725 | 96.8 | 12104.0 |
| 2020-07-17 07:03:00 | AAPL | Stock | 96.7775 | 96.825 | 96.755 | 96.7575 | 7716.0 |
| 2020-07-17 07:04:00 | AAPL | Stock | 96.7775 | 96.7875 | 96.75 | 96.75 | 4380.0 |
| 2020-07-17 07:05:00 | AAPL | Stock | 96.7075 | 96.7075 | 96.7075 | 96.7075 | 744.0 |
| 2020-07-17 07:06:00 | AAPL | Stock | 96.7 | 96.7075 | 96.7 | 96.7 | 7240.0 |
| 2020-07-17 07:08:00 | AAPL | Stock | 96.6925 | 96.6925 | 96.675 | 96.6875 | 1944.0 |
| 2020-07-17 07:09:00 | AAPL | Stock | 96.675 | 96.675 | 96.675 | 96.675 | 400.0 |
| 2020-07-17 07:15:00 | AAPL | Stock | 96.6675 | 96.675 | 96.6625 | 96.675 | 4400.0 |
| 2020-07-17 07:17:00 | AAPL | Stock | 96.6275 | 96.6275 | 96.6275 | 96.6275 | 400.0 |
| 2020-07-17 07:18:00 | AAPL | Stock | 96.6575 | 96.6575 | 96.6575 | 96.6575 | 400.0 |
| 2020-07-17 07:19:00 | AAPL | Stock | 96.6975 | 96.7125 | 96.6975 | 96.7125 | 3600.0 |
| 2020-07-17 07:20:00 | AAPL | Stock | 96.655 | 96.655 | 96.65 | 96.65 | 2040.0 |
| 2020-07-17 07:21:00 | AAPL | Stock | 96.65 | 96.65 | 96.65 | 96.65 | 1864.0 |
| 2020-07-17 07:25:00 | AAPL | Stock | 96.705 | 96.705 | 96.705 | 96.705 | 684.0 |
| 2020-07-17 07:26:00 | AAPL | Stock | 96.71 | 96.7125 | 96.71 | 96.7125 | 5156.0 |
| 2020-07-17 07:27:00 | AAPL | Stock | 96.7375 | 96.7375 | 96.725 | 96.725 | 1112.0 |
| 2020-07-17 07:29:00 | AAPL | Stock | 96.7 | 96.7125 | 96.7 | 96.7125 | 1472.0 |
| 2020-07-17 07:30:00 | AAPL | Stock | 96.7 | 96.7 | 96.6875 | 96.6875 | 800.0 |
| 2020-07-17 07:31:00 | AAPL | Stock | 96.685 | 96.685 | 96.6625 | 96.6625 | 2072.0 |
| 2020-07-17 07:32:00 | AAPL | Stock | 96.665 | 96.69 | 96.5925 | 96.69 | 3764.0 |
| 2020-07-17 07:37:00 | AAPL | Stock | 96.685 | 96.6875 | 96.685 | 96.6875 | 1628.0 |
| 2020-07-17 07:40:00 | AAPL | Stock | 96.65 | 96.65 | 96.65 | 96.65 | 400.0 |
| 2020-07-17 07:41:00 | AAPL | Stock | 96.6575 | 96.6575 | 96.655 | 96.6575 | 3004.0 |
| 2020-07-17 07:43:00 | AAPL | Stock | 96.6375 | 96.6375 | 96.6375 | 96.6375 | 2388.0 |
| 2020-07-17 07:44:00 | AAPL | Stock | 96.65 | 96.65 | 96.625 | 96.65 | 5128.0 |
| 2020-07-17 07:48:00 | AAPL | Stock | 96.6475 | 96.65 | 96.6475 | 96.65 | 1144.0 |
| 2020-07-17 07:53:00 | AAPL | Stock | 96.7 | 96.7 | 96.6875 | 96.6875 | 1200.0 |
| 2020-07-17 07:54:00 | AAPL | Stock | 96.6925 | 96.7 | 96.6925 | 96.7 | 3768.0 |
| 2020-07-17 07:55:00 | AAPL | Stock | 96.7 | 96.7 | 96.7 | 96.7 | 800.0 |
| 2020-07-17 07:57:00 | AAPL | Stock | 96.7275 | 96.7375 | 96.725 | 96.7375 | 2788.0 |
> showing 50 of 1,244,845 rows — these rows as CSV