PREVIEW / stock_1min / 2019-11-29
file: by_date/stock_1min/2019/2019-11-29.parquet size: 9.0 MB rows: 615,083 symbols: 2,090
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-11-29 04:00:00 | AAPL | Stock | 66.675 | 66.675 | 66.675 | 66.675 | 484.0 |
| 2019-11-29 04:08:00 | AAPL | Stock | 66.75 | 66.75 | 66.75 | 66.75 | 400.0 |
| 2019-11-29 04:10:00 | AAPL | Stock | 66.75 | 66.75 | 66.75 | 66.75 | 400.0 |
| 2019-11-29 04:19:00 | AAPL | Stock | 66.75 | 66.75 | 66.75 | 66.75 | 1600.0 |
| 2019-11-29 04:26:00 | AAPL | Stock | 66.7475 | 66.75 | 66.7475 | 66.75 | 800.0 |
| 2019-11-29 04:42:00 | AAPL | Stock | 66.7 | 66.7 | 66.7 | 66.7 | 664.0 |
| 2019-11-29 04:45:00 | AAPL | Stock | 66.7 | 66.7 | 66.7 | 66.7 | 800.0 |
| 2019-11-29 05:13:00 | AAPL | Stock | 66.735 | 66.75 | 66.735 | 66.75 | 2160.0 |
| 2019-11-29 05:17:00 | AAPL | Stock | 66.755 | 66.755 | 66.755 | 66.755 | 1600.0 |
| 2019-11-29 05:19:00 | AAPL | Stock | 66.75 | 66.75 | 66.75 | 66.75 | 5112.0 |
| 2019-11-29 05:25:00 | AAPL | Stock | 66.7925 | 66.7925 | 66.7925 | 66.7925 | 1828.0 |
| 2019-11-29 05:42:00 | AAPL | Stock | 66.75 | 66.75 | 66.75 | 66.75 | 4324.0 |
| 2019-11-29 05:57:00 | AAPL | Stock | 66.775 | 66.775 | 66.775 | 66.775 | 4000.0 |
| 2019-11-29 06:06:00 | AAPL | Stock | 66.7825 | 66.7825 | 66.7825 | 66.7825 | 1468.0 |
| 2019-11-29 06:27:00 | AAPL | Stock | 66.7825 | 66.7825 | 66.7825 | 66.7825 | 800.0 |
| 2019-11-29 06:28:00 | AAPL | Stock | 66.7825 | 66.7825 | 66.7825 | 66.7825 | 800.0 |
| 2019-11-29 06:29:00 | AAPL | Stock | 66.7825 | 66.7825 | 66.7825 | 66.7825 | 6800.0 |
| 2019-11-29 06:42:00 | AAPL | Stock | 66.8375 | 66.8375 | 66.8375 | 66.8375 | 4000.0 |
| 2019-11-29 06:54:00 | AAPL | Stock | 66.8375 | 66.8375 | 66.8375 | 66.8375 | 3200.0 |
| 2019-11-29 07:00:00 | AAPL | Stock | 66.775 | 66.8225 | 66.775 | 66.8225 | 1624.0 |
| 2019-11-29 07:01:00 | AAPL | Stock | 66.8 | 66.8375 | 66.8 | 66.8375 | 3200.0 |
| 2019-11-29 07:02:00 | AAPL | Stock | 66.8525 | 66.8625 | 66.8525 | 66.8625 | 5640.0 |
| 2019-11-29 07:04:00 | AAPL | Stock | 66.81 | 66.81 | 66.8025 | 66.8025 | 9564.0 |
| 2019-11-29 07:05:00 | AAPL | Stock | 66.8 | 66.8 | 66.8 | 66.8 | 2000.0 |
| 2019-11-29 07:07:00 | AAPL | Stock | 66.7925 | 66.7925 | 66.7875 | 66.7875 | 10000.0 |
| 2019-11-29 07:13:00 | AAPL | Stock | 66.775 | 66.775 | 66.775 | 66.775 | 540.0 |
| 2019-11-29 07:14:00 | AAPL | Stock | 66.7525 | 66.7525 | 66.7525 | 66.7525 | 400.0 |
| 2019-11-29 07:15:00 | AAPL | Stock | 66.75 | 66.75 | 66.725 | 66.725 | 3292.0 |
| 2019-11-29 07:16:00 | AAPL | Stock | 66.755 | 66.755 | 66.755 | 66.755 | 1992.0 |
| 2019-11-29 07:17:00 | AAPL | Stock | 66.755 | 66.755 | 66.755 | 66.755 | 4616.0 |
| 2019-11-29 07:20:00 | AAPL | Stock | 66.775 | 66.775 | 66.775 | 66.775 | 400.0 |
| 2019-11-29 07:29:00 | AAPL | Stock | 66.8 | 66.8 | 66.8 | 66.8 | 400.0 |
| 2019-11-29 07:31:00 | AAPL | Stock | 66.8175 | 66.8175 | 66.8175 | 66.8175 | 400.0 |
| 2019-11-29 07:32:00 | AAPL | Stock | 66.8 | 66.8 | 66.79 | 66.79 | 880.0 |
| 2019-11-29 07:34:00 | AAPL | Stock | 66.8125 | 66.815 | 66.8125 | 66.815 | 1696.0 |
| 2019-11-29 07:41:00 | AAPL | Stock | 66.7775 | 66.78 | 66.7775 | 66.78 | 1600.0 |
| 2019-11-29 07:43:00 | AAPL | Stock | 66.78 | 66.78 | 66.78 | 66.78 | 400.0 |
| 2019-11-29 07:44:00 | AAPL | Stock | 66.7675 | 66.785 | 66.7675 | 66.785 | 1508.0 |
| 2019-11-29 07:48:00 | AAPL | Stock | 66.7575 | 66.7675 | 66.7575 | 66.7675 | 2092.0 |
| 2019-11-29 07:49:00 | AAPL | Stock | 66.77 | 66.77 | 66.7625 | 66.7625 | 2800.0 |
| 2019-11-29 07:59:00 | AAPL | Stock | 66.765 | 66.765 | 66.765 | 66.765 | 400.0 |
| 2019-11-29 08:00:00 | AAPL | Stock | 66.78 | 66.85 | 66.725 | 66.755 | 85264.0 |
| 2019-11-29 08:01:00 | AAPL | Stock | 66.7975 | 66.7975 | 66.7975 | 66.7975 | 488.0 |
| 2019-11-29 08:02:00 | AAPL | Stock | 66.7725 | 66.8 | 66.7725 | 66.8 | 4100.0 |
| 2019-11-29 08:03:00 | AAPL | Stock | 66.8 | 66.8 | 66.8 | 66.8 | 1196.0 |
| 2019-11-29 08:04:00 | AAPL | Stock | 66.76 | 66.76 | 66.75 | 66.75 | 4160.0 |
| 2019-11-29 08:05:00 | AAPL | Stock | 66.7675 | 66.7675 | 66.7675 | 66.7675 | 400.0 |
| 2019-11-29 08:07:00 | AAPL | Stock | 66.7675 | 66.7675 | 66.7675 | 66.7675 | 400.0 |
| 2019-11-29 08:09:00 | AAPL | Stock | 66.7875 | 66.7925 | 66.7875 | 66.7925 | 14204.0 |
| 2019-11-29 08:11:00 | AAPL | Stock | 66.75 | 66.75 | 66.75 | 66.75 | 400.0 |
> showing 50 of 615,083 rows — these rows as CSV