PREVIEW / stock_1min / 2020-03-16
file: by_date/stock_1min/2020/2020-03-16.parquet size: 20.9 MB rows: 1,370,730 symbols: 2,083
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-16 04:00:00 | AAPL | Stock | 63.17 | 64.075 | 63.0 | 63.65 | 24016.0 |
| 2020-03-16 04:01:00 | AAPL | Stock | 63.6875 | 63.7 | 63.6725 | 63.7 | 6480.0 |
| 2020-03-16 04:02:00 | AAPL | Stock | 63.69 | 63.7575 | 63.69 | 63.7525 | 2000.0 |
| 2020-03-16 04:03:00 | AAPL | Stock | 63.75 | 63.75 | 63.685 | 63.685 | 1400.0 |
| 2020-03-16 04:04:00 | AAPL | Stock | 63.6275 | 63.6275 | 63.4525 | 63.4525 | 3944.0 |
| 2020-03-16 04:05:00 | AAPL | Stock | 63.275 | 63.275 | 63.075 | 63.13 | 9268.0 |
| 2020-03-16 04:06:00 | AAPL | Stock | 63.24 | 63.24 | 63.1 | 63.1 | 7288.0 |
| 2020-03-16 04:07:00 | AAPL | Stock | 63.2875 | 63.375 | 63.19 | 63.19 | 6800.0 |
| 2020-03-16 04:08:00 | AAPL | Stock | 63.44 | 63.45 | 63.44 | 63.45 | 1600.0 |
| 2020-03-16 04:09:00 | AAPL | Stock | 63.33 | 63.66 | 63.3275 | 63.66 | 9544.0 |
| 2020-03-16 04:10:00 | AAPL | Stock | 63.6875 | 63.6875 | 63.3 | 63.5 | 12112.0 |
| 2020-03-16 04:11:00 | AAPL | Stock | 63.5 | 63.5 | 63.3775 | 63.485 | 8976.0 |
| 2020-03-16 04:12:00 | AAPL | Stock | 63.4875 | 63.5625 | 63.3775 | 63.3775 | 9248.0 |
| 2020-03-16 04:13:00 | AAPL | Stock | 63.4 | 63.4 | 63.4 | 63.4 | 420.0 |
| 2020-03-16 04:14:00 | AAPL | Stock | 63.4925 | 63.4925 | 63.4925 | 63.4925 | 400.0 |
| 2020-03-16 04:15:00 | AAPL | Stock | 63.4925 | 63.4925 | 63.305 | 63.3075 | 3796.0 |
| 2020-03-16 04:16:00 | AAPL | Stock | 63.305 | 63.315 | 63.25 | 63.28 | 2536.0 |
| 2020-03-16 04:17:00 | AAPL | Stock | 63.3725 | 63.375 | 63.3725 | 63.375 | 2256.0 |
| 2020-03-16 04:18:00 | AAPL | Stock | 63.395 | 63.4225 | 63.3075 | 63.3075 | 2420.0 |
| 2020-03-16 04:19:00 | AAPL | Stock | 63.265 | 63.3275 | 63.25 | 63.25 | 2796.0 |
| 2020-03-16 04:20:00 | AAPL | Stock | 63.25 | 63.3275 | 63.25 | 63.25 | 8400.0 |
| 2020-03-16 04:21:00 | AAPL | Stock | 63.25 | 63.25 | 63.1375 | 63.1375 | 1996.0 |
| 2020-03-16 04:22:00 | AAPL | Stock | 63.1575 | 63.175 | 63.0 | 63.0 | 18580.0 |
| 2020-03-16 04:23:00 | AAPL | Stock | 62.95 | 62.95 | 62.925 | 62.925 | 1160.0 |
| 2020-03-16 04:24:00 | AAPL | Stock | 62.9725 | 62.9725 | 62.92 | 62.92 | 800.0 |
| 2020-03-16 04:25:00 | AAPL | Stock | 62.75 | 62.75 | 62.625 | 62.625 | 6136.0 |
| 2020-03-16 04:26:00 | AAPL | Stock | 62.55 | 62.7 | 62.5325 | 62.5775 | 12456.0 |
| 2020-03-16 04:27:00 | AAPL | Stock | 62.6375 | 62.6375 | 62.6375 | 62.6375 | 408.0 |
| 2020-03-16 04:28:00 | AAPL | Stock | 62.7525 | 62.7525 | 62.7525 | 62.7525 | 400.0 |
| 2020-03-16 04:29:00 | AAPL | Stock | 62.6325 | 62.6325 | 62.4975 | 62.4975 | 21680.0 |
| 2020-03-16 04:30:00 | AAPL | Stock | 62.375 | 62.4425 | 62.3 | 62.3 | 2000.0 |
| 2020-03-16 04:31:00 | AAPL | Stock | 62.3125 | 62.3125 | 62.25 | 62.25 | 3556.0 |
| 2020-03-16 04:32:00 | AAPL | Stock | 62.25 | 62.25 | 62.25 | 62.25 | 400.0 |
| 2020-03-16 04:33:00 | AAPL | Stock | 62.245 | 62.2525 | 62.245 | 62.2525 | 1600.0 |
| 2020-03-16 04:34:00 | AAPL | Stock | 62.325 | 62.345 | 62.2525 | 62.345 | 1200.0 |
| 2020-03-16 04:35:00 | AAPL | Stock | 62.135 | 62.225 | 62.0 | 62.0 | 4216.0 |
| 2020-03-16 04:36:00 | AAPL | Stock | 62.1975 | 62.3725 | 62.0 | 62.125 | 27536.0 |
| 2020-03-16 04:37:00 | AAPL | Stock | 62.125 | 62.2375 | 62.125 | 62.13 | 4736.0 |
| 2020-03-16 04:38:00 | AAPL | Stock | 62.1775 | 62.345 | 62.1775 | 62.275 | 2800.0 |
| 2020-03-16 04:39:00 | AAPL | Stock | 62.3725 | 62.4325 | 62.3725 | 62.4325 | 4800.0 |
| 2020-03-16 04:40:00 | AAPL | Stock | 62.4325 | 62.4325 | 62.4325 | 62.4325 | 800.0 |
| 2020-03-16 04:41:00 | AAPL | Stock | 62.4325 | 62.4325 | 62.2925 | 62.2925 | 2168.0 |
| 2020-03-16 04:42:00 | AAPL | Stock | 62.3025 | 62.3025 | 62.29 | 62.29 | 1200.0 |
| 2020-03-16 04:43:00 | AAPL | Stock | 62.0 | 62.0 | 62.0 | 62.0 | 400.0 |
| 2020-03-16 04:44:00 | AAPL | Stock | 61.9975 | 62.0 | 61.9975 | 62.0 | 1464.0 |
| 2020-03-16 04:45:00 | AAPL | Stock | 62.2125 | 62.2125 | 62.125 | 62.1375 | 2000.0 |
| 2020-03-16 04:46:00 | AAPL | Stock | 62.025 | 62.275 | 62.025 | 62.275 | 2680.0 |
| 2020-03-16 04:48:00 | AAPL | Stock | 62.25 | 62.25 | 62.125 | 62.195 | 6192.0 |
| 2020-03-16 04:49:00 | AAPL | Stock | 62.1425 | 62.1875 | 62.1425 | 62.1875 | 800.0 |
| 2020-03-16 04:50:00 | AAPL | Stock | 62.05 | 62.05 | 61.875 | 61.875 | 5572.0 |
> showing 50 of 1,370,730 rows — these rows as CSV