PREVIEW / stock_1min / 2019-03-12
file: by_date/stock_1min/2019/2019-03-12.parquet size: 15.5 MB rows: 1,099,694 symbols: 2,225
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-03-12 04:00:00 | AAPL | Stock | 45.0 | 45.0 | 45.0 | 45.0 | 800.0 |
| 2019-03-12 04:07:00 | AAPL | Stock | 44.9625 | 44.9625 | 44.95 | 44.95 | 10416.0 |
| 2019-03-12 04:08:00 | AAPL | Stock | 44.95 | 44.9925 | 44.9075 | 44.9925 | 1432.0 |
| 2019-03-12 04:10:00 | AAPL | Stock | 44.99 | 45.0 | 44.99 | 45.0 | 876.0 |
| 2019-03-12 04:11:00 | AAPL | Stock | 44.95 | 44.95 | 44.95 | 44.95 | 488.0 |
| 2019-03-12 04:13:00 | AAPL | Stock | 44.9925 | 44.9925 | 44.9925 | 44.9925 | 400.0 |
| 2019-03-12 04:20:00 | AAPL | Stock | 44.9875 | 44.9875 | 44.9875 | 44.9875 | 400.0 |
| 2019-03-12 04:22:00 | AAPL | Stock | 44.965 | 44.965 | 44.9625 | 44.9625 | 1200.0 |
| 2019-03-12 04:23:00 | AAPL | Stock | 44.9525 | 44.9525 | 44.945 | 44.945 | 1620.0 |
| 2019-03-12 04:32:00 | AAPL | Stock | 44.9625 | 44.9625 | 44.95 | 44.9525 | 2400.0 |
| 2019-03-12 04:33:00 | AAPL | Stock | 44.9525 | 44.9525 | 44.9525 | 44.9525 | 400.0 |
| 2019-03-12 04:34:00 | AAPL | Stock | 44.9525 | 44.9525 | 44.93 | 44.93 | 1492.0 |
| 2019-03-12 04:36:00 | AAPL | Stock | 44.95 | 44.975 | 44.95 | 44.975 | 7992.0 |
| 2019-03-12 04:54:00 | AAPL | Stock | 44.9675 | 44.9675 | 44.9675 | 44.9675 | 400.0 |
| 2019-03-12 04:55:00 | AAPL | Stock | 44.9125 | 44.9125 | 44.9125 | 44.9125 | 400.0 |
| 2019-03-12 04:57:00 | AAPL | Stock | 44.9175 | 44.9175 | 44.9125 | 44.9125 | 800.0 |
| 2019-03-12 05:04:00 | AAPL | Stock | 44.955 | 44.955 | 44.95 | 44.95 | 3200.0 |
| 2019-03-12 05:06:00 | AAPL | Stock | 44.9525 | 44.9525 | 44.9525 | 44.9525 | 1180.0 |
| 2019-03-12 05:15:00 | AAPL | Stock | 44.955 | 44.955 | 44.9425 | 44.9425 | 7620.0 |
| 2019-03-12 05:21:00 | AAPL | Stock | 44.9425 | 44.9425 | 44.9425 | 44.9425 | 512.0 |
| 2019-03-12 05:35:00 | AAPL | Stock | 44.9425 | 44.9425 | 44.9425 | 44.9425 | 400.0 |
| 2019-03-12 06:04:00 | AAPL | Stock | 44.8875 | 44.8875 | 44.8875 | 44.8875 | 400.0 |
| 2019-03-12 06:05:00 | AAPL | Stock | 44.8875 | 44.8875 | 44.875 | 44.875 | 8624.0 |
| 2019-03-12 06:06:00 | AAPL | Stock | 44.86 | 44.86 | 44.86 | 44.86 | 4092.0 |
| 2019-03-12 06:10:00 | AAPL | Stock | 44.85 | 44.85 | 44.85 | 44.85 | 1000.0 |
| 2019-03-12 06:12:00 | AAPL | Stock | 44.85 | 44.85 | 44.85 | 44.85 | 4000.0 |
| 2019-03-12 06:19:00 | AAPL | Stock | 44.88 | 44.88 | 44.88 | 44.88 | 400.0 |
| 2019-03-12 06:21:00 | AAPL | Stock | 44.88 | 44.88 | 44.88 | 44.88 | 784.0 |
| 2019-03-12 06:27:00 | AAPL | Stock | 44.88 | 44.88 | 44.88 | 44.88 | 1616.0 |
| 2019-03-12 06:28:00 | AAPL | Stock | 44.88 | 44.88 | 44.88 | 44.88 | 2036.0 |
| 2019-03-12 06:42:00 | AAPL | Stock | 44.88 | 44.88 | 44.88 | 44.88 | 508.0 |
| 2019-03-12 06:48:00 | AAPL | Stock | 44.85 | 44.85 | 44.85 | 44.85 | 5012.0 |
| 2019-03-12 07:00:00 | AAPL | Stock | 44.855 | 44.915 | 44.855 | 44.8725 | 11748.0 |
| 2019-03-12 07:04:00 | AAPL | Stock | 44.87 | 44.87 | 44.8375 | 44.8375 | 8408.0 |
| 2019-03-12 07:05:00 | AAPL | Stock | 44.8125 | 44.8125 | 44.8125 | 44.8125 | 1872.0 |
| 2019-03-12 07:06:00 | AAPL | Stock | 44.8125 | 44.875 | 44.8075 | 44.8075 | 15188.0 |
| 2019-03-12 07:07:00 | AAPL | Stock | 44.795 | 44.795 | 44.775 | 44.795 | 2560.0 |
| 2019-03-12 07:08:00 | AAPL | Stock | 44.8275 | 44.8275 | 44.8275 | 44.8275 | 400.0 |
| 2019-03-12 07:09:00 | AAPL | Stock | 44.7775 | 44.7775 | 44.7575 | 44.7575 | 4400.0 |
| 2019-03-12 07:10:00 | AAPL | Stock | 44.7625 | 44.7625 | 44.7575 | 44.7575 | 4472.0 |
| 2019-03-12 07:12:00 | AAPL | Stock | 44.7775 | 44.8025 | 44.7775 | 44.8025 | 1496.0 |
| 2019-03-12 07:16:00 | AAPL | Stock | 44.795 | 44.795 | 44.795 | 44.795 | 992.0 |
| 2019-03-12 07:19:00 | AAPL | Stock | 44.8225 | 44.8375 | 44.8225 | 44.8375 | 1780.0 |
| 2019-03-12 07:20:00 | AAPL | Stock | 44.8 | 44.8 | 44.79 | 44.79 | 3600.0 |
| 2019-03-12 07:21:00 | AAPL | Stock | 44.7975 | 44.7975 | 44.7975 | 44.7975 | 1192.0 |
| 2019-03-12 07:22:00 | AAPL | Stock | 44.7875 | 44.7875 | 44.7875 | 44.7875 | 400.0 |
| 2019-03-12 07:23:00 | AAPL | Stock | 44.7875 | 44.7875 | 44.7875 | 44.7875 | 19424.0 |
| 2019-03-12 07:30:00 | AAPL | Stock | 44.82 | 44.82 | 44.82 | 44.82 | 400.0 |
| 2019-03-12 07:31:00 | AAPL | Stock | 44.8 | 44.8 | 44.8 | 44.8 | 1528.0 |
| 2019-03-12 07:32:00 | AAPL | Stock | 44.8 | 44.8125 | 44.8 | 44.8125 | 2388.0 |
> showing 50 of 1,099,694 rows — these rows as CSV