PREVIEW / stock_1min / 2020-10-15
file: by_date/stock_1min/2020/2020-10-15.parquet size: 19.6 MB rows: 1,210,193 symbols: 2,101
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-10-15 04:00:00 | AAPL | Stock | 119.58 | 119.8 | 119.2 | 119.2 | 7292.0 |
| 2020-10-15 04:01:00 | AAPL | Stock | 119.19 | 119.23 | 119.15 | 119.19 | 1847.0 |
| 2020-10-15 04:02:00 | AAPL | Stock | 119.2 | 119.32 | 119.2 | 119.2 | 699.0 |
| 2020-10-15 04:03:00 | AAPL | Stock | 119.06 | 119.06 | 119.0 | 119.0 | 2419.0 |
| 2020-10-15 04:04:00 | AAPL | Stock | 118.99 | 119.0 | 118.28 | 118.28 | 15460.0 |
| 2020-10-15 04:05:00 | AAPL | Stock | 118.28 | 118.5 | 118.28 | 118.5 | 5056.0 |
| 2020-10-15 04:06:00 | AAPL | Stock | 118.4 | 118.6 | 118.4 | 118.6 | 4415.0 |
| 2020-10-15 04:07:00 | AAPL | Stock | 118.6 | 118.6 | 118.43 | 118.55 | 2590.0 |
| 2020-10-15 04:08:00 | AAPL | Stock | 118.6 | 118.6 | 118.5 | 118.55 | 1450.0 |
| 2020-10-15 04:09:00 | AAPL | Stock | 118.5 | 118.5 | 118.43 | 118.45 | 4296.0 |
| 2020-10-15 04:10:00 | AAPL | Stock | 118.45 | 118.54 | 118.43 | 118.48 | 5853.0 |
| 2020-10-15 04:11:00 | AAPL | Stock | 118.47 | 118.47 | 118.35 | 118.35 | 3981.0 |
| 2020-10-15 04:12:00 | AAPL | Stock | 118.35 | 118.5 | 118.35 | 118.43 | 6547.0 |
| 2020-10-15 04:13:00 | AAPL | Stock | 118.44 | 118.44 | 118.21 | 118.21 | 2831.0 |
| 2020-10-15 04:14:00 | AAPL | Stock | 118.21 | 118.28 | 118.13 | 118.21 | 16602.0 |
| 2020-10-15 04:15:00 | AAPL | Stock | 118.25 | 118.25 | 118.0 | 118.0 | 2047.0 |
| 2020-10-15 04:16:00 | AAPL | Stock | 118.1 | 118.1 | 118.0 | 118.02 | 1746.0 |
| 2020-10-15 04:17:00 | AAPL | Stock | 118.1 | 118.23 | 118.1 | 118.23 | 3891.0 |
| 2020-10-15 04:18:00 | AAPL | Stock | 118.24 | 118.36 | 118.2 | 118.3 | 2760.0 |
| 2020-10-15 04:19:00 | AAPL | Stock | 118.31 | 118.31 | 118.2 | 118.2 | 2571.0 |
| 2020-10-15 04:20:00 | AAPL | Stock | 118.13 | 118.19 | 117.88 | 117.88 | 9160.0 |
| 2020-10-15 04:21:00 | AAPL | Stock | 117.82 | 117.94 | 117.82 | 117.94 | 2013.0 |
| 2020-10-15 04:22:00 | AAPL | Stock | 117.91 | 118.09 | 117.9 | 118.09 | 2750.0 |
| 2020-10-15 04:23:00 | AAPL | Stock | 118.09 | 118.11 | 118.09 | 118.11 | 508.0 |
| 2020-10-15 04:24:00 | AAPL | Stock | 118.01 | 118.12 | 118.0 | 118.01 | 1287.0 |
| 2020-10-15 04:25:00 | AAPL | Stock | 118.09 | 118.12 | 118.04 | 118.04 | 573.0 |
| 2020-10-15 04:26:00 | AAPL | Stock | 118.09 | 118.2 | 118.07 | 118.08 | 1702.0 |
| 2020-10-15 04:27:00 | AAPL | Stock | 118.1 | 118.11 | 118.02 | 118.1 | 1622.0 |
| 2020-10-15 04:28:00 | AAPL | Stock | 118.11 | 118.13 | 118.0 | 118.0 | 2225.0 |
| 2020-10-15 04:29:00 | AAPL | Stock | 118.08 | 118.09 | 118.08 | 118.09 | 2145.0 |
| 2020-10-15 04:30:00 | AAPL | Stock | 118.09 | 118.1 | 117.93 | 117.93 | 2305.0 |
| 2020-10-15 04:31:00 | AAPL | Stock | 117.93 | 117.93 | 117.75 | 117.8 | 13797.0 |
| 2020-10-15 04:32:00 | AAPL | Stock | 117.84 | 117.84 | 117.8 | 117.8 | 726.0 |
| 2020-10-15 04:33:00 | AAPL | Stock | 117.81 | 117.85 | 117.8 | 117.8 | 2933.0 |
| 2020-10-15 04:34:00 | AAPL | Stock | 117.75 | 117.75 | 117.67 | 117.67 | 2257.0 |
| 2020-10-15 04:35:00 | AAPL | Stock | 117.68 | 117.79 | 117.65 | 117.7 | 4512.0 |
| 2020-10-15 04:36:00 | AAPL | Stock | 117.7 | 117.74 | 117.5 | 117.55 | 5571.0 |
| 2020-10-15 04:37:00 | AAPL | Stock | 117.6 | 117.6 | 117.51 | 117.55 | 3935.0 |
| 2020-10-15 04:38:00 | AAPL | Stock | 117.55 | 117.58 | 117.53 | 117.58 | 2922.0 |
| 2020-10-15 04:39:00 | AAPL | Stock | 117.6 | 117.6 | 117.58 | 117.58 | 1461.0 |
| 2020-10-15 04:40:00 | AAPL | Stock | 117.58 | 117.58 | 117.4 | 117.41 | 7961.0 |
| 2020-10-15 04:41:00 | AAPL | Stock | 117.4 | 117.4 | 117.4 | 117.4 | 572.0 |
| 2020-10-15 04:42:00 | AAPL | Stock | 117.4 | 117.41 | 117.3 | 117.3 | 1873.0 |
| 2020-10-15 04:43:00 | AAPL | Stock | 117.31 | 117.4 | 117.26 | 117.35 | 3571.0 |
| 2020-10-15 04:44:00 | AAPL | Stock | 117.35 | 117.4 | 117.35 | 117.4 | 5650.0 |
| 2020-10-15 04:45:00 | AAPL | Stock | 117.42 | 117.61 | 117.42 | 117.61 | 3359.0 |
| 2020-10-15 04:46:00 | AAPL | Stock | 117.62 | 117.62 | 117.5 | 117.5 | 7955.0 |
| 2020-10-15 04:47:00 | AAPL | Stock | 117.62 | 117.75 | 117.5 | 117.63 | 2648.0 |
| 2020-10-15 04:48:00 | AAPL | Stock | 117.51 | 117.62 | 117.51 | 117.56 | 1494.0 |
| 2020-10-15 04:49:00 | AAPL | Stock | 117.53 | 117.54 | 117.4 | 117.41 | 5855.0 |
> showing 50 of 1,210,193 rows — these rows as CSV