PREVIEW / stock_1min / 2020-08-14
file: by_date/stock_1min/2020/2020-08-14.parquet size: 19.3 MB rows: 1,201,367 symbols: 2,062
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-08-14 04:00:00 | AAPL | Stock | 114.8675 | 114.875 | 114.8625 | 114.875 | 2172.0 |
| 2020-08-14 04:03:00 | AAPL | Stock | 114.8025 | 114.8025 | 114.8025 | 114.8025 | 1400.0 |
| 2020-08-14 04:05:00 | AAPL | Stock | 114.87 | 114.87 | 114.87 | 114.87 | 800.0 |
| 2020-08-14 04:08:00 | AAPL | Stock | 114.8125 | 114.8125 | 114.8 | 114.8 | 2392.0 |
| 2020-08-14 04:10:00 | AAPL | Stock | 114.5825 | 114.5825 | 114.5825 | 114.5825 | 416.0 |
| 2020-08-14 04:13:00 | AAPL | Stock | 114.63 | 114.63 | 114.6275 | 114.6275 | 1192.0 |
| 2020-08-14 04:15:00 | AAPL | Stock | 114.7425 | 114.76 | 114.7425 | 114.76 | 808.0 |
| 2020-08-14 04:17:00 | AAPL | Stock | 114.76 | 114.76 | 114.76 | 114.76 | 400.0 |
| 2020-08-14 04:21:00 | AAPL | Stock | 114.65 | 114.65 | 114.65 | 114.65 | 1140.0 |
| 2020-08-14 04:22:00 | AAPL | Stock | 114.6275 | 114.6275 | 114.6275 | 114.6275 | 576.0 |
| 2020-08-14 04:29:00 | AAPL | Stock | 114.52 | 114.52 | 114.415 | 114.415 | 1116.0 |
| 2020-08-14 04:30:00 | AAPL | Stock | 114.605 | 114.605 | 114.605 | 114.605 | 400.0 |
| 2020-08-14 04:43:00 | AAPL | Stock | 114.5875 | 114.5875 | 114.5725 | 114.5725 | 2472.0 |
| 2020-08-14 04:47:00 | AAPL | Stock | 114.5225 | 114.5225 | 114.5225 | 114.5225 | 400.0 |
| 2020-08-14 04:56:00 | AAPL | Stock | 114.5275 | 114.5275 | 114.5275 | 114.5275 | 408.0 |
| 2020-08-14 05:03:00 | AAPL | Stock | 114.525 | 114.525 | 114.5 | 114.5 | 1216.0 |
| 2020-08-14 05:13:00 | AAPL | Stock | 114.3575 | 114.3575 | 114.3575 | 114.3575 | 400.0 |
| 2020-08-14 05:14:00 | AAPL | Stock | 114.34 | 114.34 | 114.3175 | 114.3175 | 1992.0 |
| 2020-08-14 05:16:00 | AAPL | Stock | 114.4 | 114.4 | 114.4 | 114.4 | 400.0 |
| 2020-08-14 05:21:00 | AAPL | Stock | 114.465 | 114.465 | 114.465 | 114.465 | 5488.0 |
| 2020-08-14 05:23:00 | AAPL | Stock | 114.465 | 114.465 | 114.46 | 114.465 | 2480.0 |
| 2020-08-14 05:27:00 | AAPL | Stock | 114.4125 | 114.4125 | 114.4125 | 114.4125 | 400.0 |
| 2020-08-14 05:28:00 | AAPL | Stock | 114.465 | 114.465 | 114.465 | 114.465 | 2032.0 |
| 2020-08-14 05:33:00 | AAPL | Stock | 114.5575 | 114.5575 | 114.5575 | 114.5575 | 2280.0 |
| 2020-08-14 05:35:00 | AAPL | Stock | 114.5575 | 114.5575 | 114.5575 | 114.5575 | 600.0 |
| 2020-08-14 05:59:00 | AAPL | Stock | 114.65 | 114.65 | 114.65 | 114.65 | 400.0 |
| 2020-08-14 06:02:00 | AAPL | Stock | 114.6325 | 114.6325 | 114.6325 | 114.6325 | 644.0 |
| 2020-08-14 06:07:00 | AAPL | Stock | 114.575 | 114.575 | 114.5675 | 114.5675 | 1040.0 |
| 2020-08-14 06:09:00 | AAPL | Stock | 114.4275 | 114.4275 | 114.4175 | 114.4175 | 10788.0 |
| 2020-08-14 06:11:00 | AAPL | Stock | 114.42 | 114.425 | 114.42 | 114.425 | 1080.0 |
| 2020-08-14 06:19:00 | AAPL | Stock | 114.52 | 114.52 | 114.52 | 114.52 | 400.0 |
| 2020-08-14 06:24:00 | AAPL | Stock | 114.5175 | 114.5175 | 114.5175 | 114.5175 | 1232.0 |
| 2020-08-14 06:49:00 | AAPL | Stock | 114.625 | 114.625 | 114.625 | 114.625 | 7860.0 |
| 2020-08-14 06:50:00 | AAPL | Stock | 114.6575 | 114.85 | 114.6575 | 114.85 | 18424.0 |
| 2020-08-14 06:51:00 | AAPL | Stock | 114.875 | 114.875 | 114.855 | 114.855 | 1200.0 |
| 2020-08-14 06:52:00 | AAPL | Stock | 114.8725 | 114.8725 | 114.8725 | 114.8725 | 400.0 |
| 2020-08-14 06:55:00 | AAPL | Stock | 114.935 | 114.9675 | 114.935 | 114.9675 | 1664.0 |
| 2020-08-14 06:56:00 | AAPL | Stock | 114.925 | 114.925 | 114.925 | 114.925 | 572.0 |
| 2020-08-14 06:59:00 | AAPL | Stock | 114.85 | 114.925 | 114.85 | 114.925 | 1400.0 |
| 2020-08-14 07:00:00 | AAPL | Stock | 114.915 | 114.975 | 114.755 | 114.7575 | 26268.0 |
| 2020-08-14 07:01:00 | AAPL | Stock | 114.825 | 114.875 | 114.825 | 114.875 | 4640.0 |
| 2020-08-14 07:02:00 | AAPL | Stock | 114.8125 | 114.8125 | 114.78 | 114.8075 | 1600.0 |
| 2020-08-14 07:03:00 | AAPL | Stock | 114.805 | 114.805 | 114.75 | 114.75 | 4700.0 |
| 2020-08-14 07:04:00 | AAPL | Stock | 114.73 | 114.73 | 114.6925 | 114.725 | 3600.0 |
| 2020-08-14 07:05:00 | AAPL | Stock | 114.675 | 114.725 | 114.675 | 114.725 | 4176.0 |
| 2020-08-14 07:06:00 | AAPL | Stock | 114.72 | 114.725 | 114.7125 | 114.725 | 2060.0 |
| 2020-08-14 07:07:00 | AAPL | Stock | 114.685 | 114.685 | 114.6275 | 114.6275 | 4596.0 |
| 2020-08-14 07:08:00 | AAPL | Stock | 114.625 | 114.6375 | 114.58 | 114.625 | 2000.0 |
| 2020-08-14 07:09:00 | AAPL | Stock | 114.5775 | 114.6125 | 114.5 | 114.6025 | 23872.0 |
| 2020-08-14 07:10:00 | AAPL | Stock | 114.6 | 114.6 | 114.5325 | 114.595 | 2256.0 |
> showing 50 of 1,201,367 rows — these rows as CSV