PREVIEW / stock_1min / 2020-03-12
file: by_date/stock_1min/2020/2020-03-12.parquet size: 22.4 MB rows: 1,426,899 symbols: 2,107
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-03-12 04:00:00 | AAPL | Stock | 65.95 | 65.975 | 65.875 | 65.875 | 42556.0 |
| 2020-03-12 04:01:00 | AAPL | Stock | 65.9025 | 66.185 | 65.9 | 66.15 | 6432.0 |
| 2020-03-12 04:02:00 | AAPL | Stock | 66.0025 | 66.125 | 66.0025 | 66.015 | 5808.0 |
| 2020-03-12 04:03:00 | AAPL | Stock | 66.125 | 66.125 | 66.0 | 66.0 | 12032.0 |
| 2020-03-12 04:04:00 | AAPL | Stock | 66.05 | 66.05 | 65.875 | 65.875 | 2808.0 |
| 2020-03-12 04:05:00 | AAPL | Stock | 65.875 | 65.99 | 65.875 | 65.9675 | 3212.0 |
| 2020-03-12 04:06:00 | AAPL | Stock | 66.0875 | 66.185 | 66.0875 | 66.185 | 1176.0 |
| 2020-03-12 04:07:00 | AAPL | Stock | 66.0 | 66.0 | 65.9125 | 65.97 | 2400.0 |
| 2020-03-12 04:08:00 | AAPL | Stock | 65.8975 | 65.8975 | 65.875 | 65.875 | 10052.0 |
| 2020-03-12 04:09:00 | AAPL | Stock | 65.88 | 65.88 | 65.75 | 65.75 | 12804.0 |
| 2020-03-12 04:10:00 | AAPL | Stock | 65.755 | 65.7575 | 65.525 | 65.7375 | 8444.0 |
| 2020-03-12 04:11:00 | AAPL | Stock | 65.7 | 65.7 | 65.7 | 65.7 | 4000.0 |
| 2020-03-12 04:12:00 | AAPL | Stock | 65.6575 | 65.6825 | 65.625 | 65.6575 | 5516.0 |
| 2020-03-12 04:13:00 | AAPL | Stock | 65.625 | 65.7475 | 65.625 | 65.65 | 3516.0 |
| 2020-03-12 04:14:00 | AAPL | Stock | 65.6575 | 65.75 | 65.6575 | 65.75 | 1240.0 |
| 2020-03-12 04:15:00 | AAPL | Stock | 65.75 | 65.87 | 65.75 | 65.87 | 5632.0 |
| 2020-03-12 04:16:00 | AAPL | Stock | 65.795 | 65.9225 | 65.795 | 65.875 | 5320.0 |
| 2020-03-12 04:18:00 | AAPL | Stock | 65.96 | 65.96 | 65.905 | 65.905 | 1600.0 |
| 2020-03-12 04:20:00 | AAPL | Stock | 65.825 | 65.825 | 65.765 | 65.825 | 4524.0 |
| 2020-03-12 04:21:00 | AAPL | Stock | 65.8125 | 65.8125 | 65.7475 | 65.7475 | 10992.0 |
| 2020-03-12 04:25:00 | AAPL | Stock | 65.76 | 65.76 | 65.6125 | 65.6125 | 12180.0 |
| 2020-03-12 04:26:00 | AAPL | Stock | 65.5875 | 65.5875 | 65.5875 | 65.5875 | 460.0 |
| 2020-03-12 04:27:00 | AAPL | Stock | 65.6125 | 65.675 | 65.5275 | 65.675 | 4004.0 |
| 2020-03-12 04:28:00 | AAPL | Stock | 65.675 | 65.675 | 65.675 | 65.675 | 4216.0 |
| 2020-03-12 04:29:00 | AAPL | Stock | 65.675 | 65.675 | 65.555 | 65.555 | 2572.0 |
| 2020-03-12 04:30:00 | AAPL | Stock | 65.57 | 65.71 | 65.5625 | 65.7075 | 2756.0 |
| 2020-03-12 04:31:00 | AAPL | Stock | 65.7075 | 65.7075 | 65.5625 | 65.6075 | 5204.0 |
| 2020-03-12 04:32:00 | AAPL | Stock | 65.5525 | 65.5525 | 65.525 | 65.5275 | 9012.0 |
| 2020-03-12 04:33:00 | AAPL | Stock | 65.54 | 65.5525 | 65.54 | 65.545 | 3000.0 |
| 2020-03-12 04:34:00 | AAPL | Stock | 65.525 | 65.6075 | 65.4125 | 65.6075 | 15516.0 |
| 2020-03-12 04:37:00 | AAPL | Stock | 65.3425 | 65.3425 | 65.25 | 65.275 | 5220.0 |
| 2020-03-12 04:38:00 | AAPL | Stock | 65.29 | 65.35 | 65.29 | 65.35 | 2032.0 |
| 2020-03-12 04:42:00 | AAPL | Stock | 65.3325 | 65.35 | 65.3325 | 65.35 | 888.0 |
| 2020-03-12 04:43:00 | AAPL | Stock | 65.3125 | 65.3125 | 65.25 | 65.25 | 5680.0 |
| 2020-03-12 04:44:00 | AAPL | Stock | 65.275 | 65.3 | 65.26 | 65.3 | 1280.0 |
| 2020-03-12 04:45:00 | AAPL | Stock | 65.29 | 65.29 | 65.195 | 65.195 | 16932.0 |
| 2020-03-12 04:46:00 | AAPL | Stock | 65.2025 | 65.2025 | 65.2025 | 65.2025 | 400.0 |
| 2020-03-12 04:47:00 | AAPL | Stock | 65.215 | 65.215 | 65.1475 | 65.1475 | 1676.0 |
| 2020-03-12 04:48:00 | AAPL | Stock | 65.1125 | 65.18 | 65.0575 | 65.18 | 1200.0 |
| 2020-03-12 04:49:00 | AAPL | Stock | 65.18 | 65.18 | 65.18 | 65.18 | 2000.0 |
| 2020-03-12 04:50:00 | AAPL | Stock | 65.125 | 65.1875 | 65.125 | 65.1875 | 7092.0 |
| 2020-03-12 04:51:00 | AAPL | Stock | 65.2625 | 65.2625 | 65.2625 | 65.2625 | 400.0 |
| 2020-03-12 04:52:00 | AAPL | Stock | 65.1875 | 65.2625 | 65.1875 | 65.2625 | 3200.0 |
| 2020-03-12 04:54:00 | AAPL | Stock | 65.27 | 65.285 | 65.27 | 65.285 | 1600.0 |
| 2020-03-12 04:55:00 | AAPL | Stock | 65.325 | 65.3575 | 65.25 | 65.3575 | 6668.0 |
| 2020-03-12 04:57:00 | AAPL | Stock | 65.3825 | 65.5 | 65.375 | 65.5 | 2084.0 |
| 2020-03-12 04:58:00 | AAPL | Stock | 65.45 | 65.495 | 65.275 | 65.275 | 3400.0 |
| 2020-03-12 05:01:00 | AAPL | Stock | 65.275 | 65.275 | 65.275 | 65.275 | 1200.0 |
| 2020-03-12 05:02:00 | AAPL | Stock | 65.2375 | 65.2375 | 65.1875 | 65.1875 | 2400.0 |
| 2020-03-12 05:03:00 | AAPL | Stock | 65.2 | 65.2 | 65.1875 | 65.1875 | 2800.0 |
> showing 50 of 1,426,899 rows — these rows as CSV