PREVIEW / stock_1min / 2020-07-27
file: by_date/stock_1min/2020/2020-07-27.parquet size: 19.8 MB rows: 1,249,040 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-27 04:00:00 | AAPL | Stock | 93.0025 | 93.0025 | 93.0 | 93.0 | 6872.0 |
| 2020-07-27 04:02:00 | AAPL | Stock | 93.0275 | 93.0275 | 92.83 | 92.83 | 7464.0 |
| 2020-07-27 04:10:00 | AAPL | Stock | 93.0 | 93.0 | 93.0 | 93.0 | 2000.0 |
| 2020-07-27 04:12:00 | AAPL | Stock | 93.0 | 93.0 | 93.0 | 93.0 | 1200.0 |
| 2020-07-27 04:14:00 | AAPL | Stock | 93.0 | 93.0 | 93.0 | 93.0 | 400.0 |
| 2020-07-27 04:37:00 | AAPL | Stock | 92.9975 | 92.9975 | 92.9975 | 92.9975 | 600.0 |
| 2020-07-27 04:38:00 | AAPL | Stock | 92.9975 | 92.9975 | 92.9975 | 92.9975 | 532.0 |
| 2020-07-27 04:41:00 | AAPL | Stock | 93.08 | 93.08 | 93.08 | 93.08 | 2000.0 |
| 2020-07-27 04:45:00 | AAPL | Stock | 93.08 | 93.08 | 93.08 | 93.08 | 416.0 |
| 2020-07-27 05:10:00 | AAPL | Stock | 93.0825 | 93.1125 | 93.0825 | 93.1125 | 1200.0 |
| 2020-07-27 05:22:00 | AAPL | Stock | 93.215 | 93.25 | 93.215 | 93.25 | 800.0 |
| 2020-07-27 05:32:00 | AAPL | Stock | 93.4775 | 93.4875 | 93.3875 | 93.3875 | 2000.0 |
| 2020-07-27 05:33:00 | AAPL | Stock | 93.3825 | 93.5 | 93.3825 | 93.5 | 3684.0 |
| 2020-07-27 05:49:00 | AAPL | Stock | 93.5 | 93.5 | 93.45 | 93.45 | 2000.0 |
| 2020-07-27 05:58:00 | AAPL | Stock | 93.45 | 93.45 | 93.45 | 93.45 | 400.0 |
| 2020-07-27 06:03:00 | AAPL | Stock | 93.535 | 93.535 | 93.49 | 93.49 | 2600.0 |
| 2020-07-27 06:11:00 | AAPL | Stock | 93.52 | 93.5675 | 93.52 | 93.5675 | 6476.0 |
| 2020-07-27 06:12:00 | AAPL | Stock | 93.5675 | 93.5675 | 93.4775 | 93.4775 | 3152.0 |
| 2020-07-27 06:16:00 | AAPL | Stock | 93.4975 | 93.4975 | 93.475 | 93.475 | 5428.0 |
| 2020-07-27 06:17:00 | AAPL | Stock | 93.4725 | 93.4725 | 93.4725 | 93.4725 | 500.0 |
| 2020-07-27 06:18:00 | AAPL | Stock | 93.4525 | 93.4525 | 93.45 | 93.45 | 2440.0 |
| 2020-07-27 06:19:00 | AAPL | Stock | 93.475 | 93.475 | 93.475 | 93.475 | 1600.0 |
| 2020-07-27 06:20:00 | AAPL | Stock | 93.475 | 93.5675 | 93.475 | 93.5675 | 1796.0 |
| 2020-07-27 06:29:00 | AAPL | Stock | 93.695 | 93.875 | 93.695 | 93.875 | 1304.0 |
| 2020-07-27 06:30:00 | AAPL | Stock | 93.8975 | 93.8975 | 93.8975 | 93.8975 | 640.0 |
| 2020-07-27 06:32:00 | AAPL | Stock | 93.785 | 93.785 | 93.785 | 93.785 | 740.0 |
| 2020-07-27 06:33:00 | AAPL | Stock | 93.7825 | 93.7825 | 93.7825 | 93.7825 | 800.0 |
| 2020-07-27 06:37:00 | AAPL | Stock | 94.0 | 94.0 | 94.0 | 94.0 | 400.0 |
| 2020-07-27 06:41:00 | AAPL | Stock | 93.975 | 93.975 | 93.975 | 93.975 | 400.0 |
| 2020-07-27 06:45:00 | AAPL | Stock | 93.925 | 93.925 | 93.925 | 93.925 | 908.0 |
| 2020-07-27 06:46:00 | AAPL | Stock | 93.925 | 93.925 | 93.9125 | 93.9125 | 1400.0 |
| 2020-07-27 06:47:00 | AAPL | Stock | 93.91 | 93.91 | 93.8075 | 93.8075 | 3088.0 |
| 2020-07-27 06:49:00 | AAPL | Stock | 93.87 | 93.87 | 93.87 | 93.87 | 400.0 |
| 2020-07-27 06:51:00 | AAPL | Stock | 93.7875 | 93.7875 | 93.7775 | 93.7775 | 1200.0 |
| 2020-07-27 06:58:00 | AAPL | Stock | 93.67 | 93.67 | 93.65 | 93.65 | 4896.0 |
| 2020-07-27 07:00:00 | AAPL | Stock | 93.625 | 93.7375 | 93.505 | 93.7375 | 19284.0 |
| 2020-07-27 07:01:00 | AAPL | Stock | 93.675 | 93.7325 | 93.675 | 93.6775 | 8800.0 |
| 2020-07-27 07:02:00 | AAPL | Stock | 93.6325 | 93.6325 | 93.475 | 93.5 | 31196.0 |
| 2020-07-27 07:03:00 | AAPL | Stock | 93.5 | 93.5 | 93.4375 | 93.4375 | 10012.0 |
| 2020-07-27 07:04:00 | AAPL | Stock | 93.475 | 93.4925 | 93.4275 | 93.4275 | 7772.0 |
| 2020-07-27 07:05:00 | AAPL | Stock | 93.475 | 93.475 | 93.3725 | 93.3725 | 21828.0 |
| 2020-07-27 07:06:00 | AAPL | Stock | 93.3925 | 93.4 | 93.375 | 93.375 | 13368.0 |
| 2020-07-27 07:07:00 | AAPL | Stock | 93.42 | 93.44 | 93.42 | 93.44 | 9916.0 |
| 2020-07-27 07:08:00 | AAPL | Stock | 93.44 | 93.44 | 93.4125 | 93.4125 | 2020.0 |
| 2020-07-27 07:09:00 | AAPL | Stock | 93.4175 | 93.4725 | 93.4175 | 93.4725 | 880.0 |
| 2020-07-27 07:10:00 | AAPL | Stock | 93.475 | 93.475 | 93.475 | 93.475 | 4848.0 |
| 2020-07-27 07:11:00 | AAPL | Stock | 93.475 | 93.5 | 93.4625 | 93.5 | 3128.0 |
| 2020-07-27 07:12:00 | AAPL | Stock | 93.4975 | 93.5 | 93.4275 | 93.5 | 16440.0 |
| 2020-07-27 07:13:00 | AAPL | Stock | 93.5 | 93.62 | 93.4925 | 93.5325 | 6460.0 |
| 2020-07-27 07:14:00 | AAPL | Stock | 93.55 | 93.6625 | 93.55 | 93.66 | 8540.0 |
> showing 50 of 1,249,040 rows — these rows as CSV