PREVIEW / stock_1min / 2020-07-13
file: by_date/stock_1min/2020/2020-07-13.parquet size: 21.3 MB rows: 1,339,791 symbols: 2,079
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-13 04:00:00 | AAPL | Stock | 96.6 | 96.6025 | 96.575 | 96.6025 | 4528.0 |
| 2020-07-13 04:01:00 | AAPL | Stock | 96.6 | 96.7475 | 96.575 | 96.7375 | 8752.0 |
| 2020-07-13 04:02:00 | AAPL | Stock | 96.6575 | 96.75 | 96.6575 | 96.75 | 800.0 |
| 2020-07-13 04:03:00 | AAPL | Stock | 96.75 | 96.8 | 96.75 | 96.8 | 18096.0 |
| 2020-07-13 04:04:00 | AAPL | Stock | 96.6775 | 96.6775 | 96.6775 | 96.6775 | 400.0 |
| 2020-07-13 04:05:00 | AAPL | Stock | 96.6675 | 96.6675 | 96.6675 | 96.6675 | 640.0 |
| 2020-07-13 04:08:00 | AAPL | Stock | 96.775 | 96.775 | 96.775 | 96.775 | 524.0 |
| 2020-07-13 04:09:00 | AAPL | Stock | 96.75 | 96.7725 | 96.75 | 96.75 | 1616.0 |
| 2020-07-13 04:11:00 | AAPL | Stock | 96.75 | 96.75 | 96.75 | 96.75 | 784.0 |
| 2020-07-13 04:12:00 | AAPL | Stock | 96.7725 | 96.7725 | 96.75 | 96.75 | 2812.0 |
| 2020-07-13 04:16:00 | AAPL | Stock | 96.75 | 96.75 | 96.7 | 96.7 | 5928.0 |
| 2020-07-13 04:18:00 | AAPL | Stock | 96.6575 | 96.695 | 96.6575 | 96.695 | 800.0 |
| 2020-07-13 04:19:00 | AAPL | Stock | 96.69 | 96.69 | 96.625 | 96.625 | 1600.0 |
| 2020-07-13 04:20:00 | AAPL | Stock | 96.68 | 96.7 | 96.68 | 96.68 | 5272.0 |
| 2020-07-13 04:21:00 | AAPL | Stock | 96.6975 | 96.6975 | 96.695 | 96.695 | 800.0 |
| 2020-07-13 04:22:00 | AAPL | Stock | 96.6325 | 96.6325 | 96.625 | 96.625 | 960.0 |
| 2020-07-13 04:24:00 | AAPL | Stock | 96.695 | 96.7 | 96.695 | 96.7 | 10956.0 |
| 2020-07-13 04:25:00 | AAPL | Stock | 96.7 | 96.7 | 96.7 | 96.7 | 456.0 |
| 2020-07-13 04:26:00 | AAPL | Stock | 96.685 | 96.685 | 96.6375 | 96.6375 | 4340.0 |
| 2020-07-13 04:27:00 | AAPL | Stock | 96.6275 | 96.63 | 96.625 | 96.625 | 4796.0 |
| 2020-07-13 04:32:00 | AAPL | Stock | 96.6325 | 96.6325 | 96.62 | 96.62 | 1716.0 |
| 2020-07-13 04:34:00 | AAPL | Stock | 96.6 | 96.6 | 96.6 | 96.6 | 8000.0 |
| 2020-07-13 04:36:00 | AAPL | Stock | 96.605 | 96.6625 | 96.6 | 96.6625 | 5584.0 |
| 2020-07-13 04:38:00 | AAPL | Stock | 96.7375 | 96.7725 | 96.7375 | 96.7725 | 6572.0 |
| 2020-07-13 04:39:00 | AAPL | Stock | 96.7525 | 96.755 | 96.75 | 96.7525 | 4400.0 |
| 2020-07-13 04:40:00 | AAPL | Stock | 96.8125 | 96.8125 | 96.8125 | 96.8125 | 3300.0 |
| 2020-07-13 04:41:00 | AAPL | Stock | 96.8175 | 96.8175 | 96.7725 | 96.8125 | 8416.0 |
| 2020-07-13 04:42:00 | AAPL | Stock | 96.815 | 96.815 | 96.815 | 96.815 | 400.0 |
| 2020-07-13 04:43:00 | AAPL | Stock | 96.8175 | 96.8175 | 96.8125 | 96.8125 | 3872.0 |
| 2020-07-13 04:47:00 | AAPL | Stock | 96.8125 | 96.8125 | 96.8125 | 96.8125 | 2540.0 |
| 2020-07-13 04:48:00 | AAPL | Stock | 96.8125 | 96.8525 | 96.8125 | 96.8525 | 1600.0 |
| 2020-07-13 04:51:00 | AAPL | Stock | 96.8375 | 96.8375 | 96.8375 | 96.8375 | 800.0 |
| 2020-07-13 04:52:00 | AAPL | Stock | 96.8525 | 96.8525 | 96.8525 | 96.8525 | 1200.0 |
| 2020-07-13 04:54:00 | AAPL | Stock | 96.8375 | 96.8375 | 96.8375 | 96.8375 | 852.0 |
| 2020-07-13 04:55:00 | AAPL | Stock | 96.8375 | 96.9225 | 96.8375 | 96.9225 | 4068.0 |
| 2020-07-13 04:56:00 | AAPL | Stock | 96.875 | 96.875 | 96.875 | 96.875 | 796.0 |
| 2020-07-13 05:00:00 | AAPL | Stock | 96.9625 | 96.9625 | 96.9625 | 96.9625 | 2200.0 |
| 2020-07-13 05:01:00 | AAPL | Stock | 96.9625 | 96.975 | 96.9625 | 96.975 | 3600.0 |
| 2020-07-13 05:02:00 | AAPL | Stock | 96.975 | 96.975 | 96.975 | 96.975 | 400.0 |
| 2020-07-13 05:07:00 | AAPL | Stock | 96.9625 | 96.9625 | 96.9625 | 96.9625 | 400.0 |
| 2020-07-13 05:09:00 | AAPL | Stock | 96.975 | 96.995 | 96.975 | 96.975 | 6000.0 |
| 2020-07-13 05:10:00 | AAPL | Stock | 96.9625 | 96.9625 | 96.9625 | 96.9625 | 2000.0 |
| 2020-07-13 05:12:00 | AAPL | Stock | 96.9625 | 96.9625 | 96.9625 | 96.9625 | 1640.0 |
| 2020-07-13 05:13:00 | AAPL | Stock | 96.9625 | 96.9625 | 96.9625 | 96.9625 | 2800.0 |
| 2020-07-13 05:15:00 | AAPL | Stock | 96.9625 | 96.9625 | 96.9625 | 96.9625 | 400.0 |
| 2020-07-13 05:18:00 | AAPL | Stock | 97.0 | 97.025 | 97.0 | 97.025 | 2520.0 |
| 2020-07-13 05:20:00 | AAPL | Stock | 96.98 | 96.98 | 96.97 | 96.97 | 3132.0 |
| 2020-07-13 05:21:00 | AAPL | Stock | 96.9675 | 96.9675 | 96.925 | 96.925 | 3256.0 |
| 2020-07-13 05:22:00 | AAPL | Stock | 96.9 | 96.9 | 96.8125 | 96.8125 | 3864.0 |
| 2020-07-13 05:23:00 | AAPL | Stock | 96.7575 | 96.7575 | 96.7575 | 96.7575 | 400.0 |
> showing 50 of 1,339,791 rows — these rows as CSV