PREVIEW / stock_1min / 2020-09-15
file: by_date/stock_1min/2020/2020-09-15.parquet size: 19.6 MB rows: 1,242,419 symbols: 2,104
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-09-15 04:00:00 | AAPL | Stock | 116.54 | 116.54 | 116.11 | 116.38 | 4841.0 |
| 2020-09-15 04:01:00 | AAPL | Stock | 116.25 | 116.5 | 116.25 | 116.5 | 2057.0 |
| 2020-09-15 04:02:00 | AAPL | Stock | 116.5 | 116.65 | 116.2 | 116.25 | 5075.0 |
| 2020-09-15 04:03:00 | AAPL | Stock | 116.47 | 116.65 | 116.47 | 116.57 | 2941.0 |
| 2020-09-15 04:04:00 | AAPL | Stock | 116.55 | 116.64 | 116.54 | 116.64 | 1577.0 |
| 2020-09-15 04:05:00 | AAPL | Stock | 116.54 | 116.54 | 116.47 | 116.47 | 1910.0 |
| 2020-09-15 04:06:00 | AAPL | Stock | 116.5 | 116.63 | 116.5 | 116.56 | 1443.0 |
| 2020-09-15 04:07:00 | AAPL | Stock | 116.56 | 116.59 | 116.56 | 116.59 | 2766.0 |
| 2020-09-15 04:09:00 | AAPL | Stock | 116.56 | 116.59 | 116.56 | 116.59 | 264.0 |
| 2020-09-15 04:11:00 | AAPL | Stock | 116.54 | 116.54 | 116.5 | 116.5 | 415.0 |
| 2020-09-15 04:13:00 | AAPL | Stock | 116.59 | 116.59 | 116.49 | 116.49 | 1416.0 |
| 2020-09-15 04:14:00 | AAPL | Stock | 116.43 | 116.43 | 116.2 | 116.39 | 2312.0 |
| 2020-09-15 04:15:00 | AAPL | Stock | 116.4 | 116.4 | 116.39 | 116.4 | 1180.0 |
| 2020-09-15 04:17:00 | AAPL | Stock | 116.45 | 116.5 | 116.45 | 116.5 | 1029.0 |
| 2020-09-15 04:18:00 | AAPL | Stock | 116.5 | 116.5 | 116.5 | 116.5 | 1200.0 |
| 2020-09-15 04:19:00 | AAPL | Stock | 116.5 | 116.5 | 116.5 | 116.5 | 500.0 |
| 2020-09-15 04:20:00 | AAPL | Stock | 116.58 | 116.6 | 116.58 | 116.6 | 311.0 |
| 2020-09-15 04:21:00 | AAPL | Stock | 116.61 | 116.65 | 116.61 | 116.65 | 940.0 |
| 2020-09-15 04:22:00 | AAPL | Stock | 116.65 | 116.65 | 116.65 | 116.65 | 264.0 |
| 2020-09-15 04:24:00 | AAPL | Stock | 116.7 | 116.72 | 116.7 | 116.72 | 368.0 |
| 2020-09-15 04:26:00 | AAPL | Stock | 116.75 | 116.75 | 116.7 | 116.7 | 438.0 |
| 2020-09-15 04:27:00 | AAPL | Stock | 116.7 | 116.82 | 116.7 | 116.82 | 2793.0 |
| 2020-09-15 04:28:00 | AAPL | Stock | 116.81 | 116.81 | 116.8 | 116.8 | 681.0 |
| 2020-09-15 04:29:00 | AAPL | Stock | 116.84 | 116.86 | 116.75 | 116.85 | 631.0 |
| 2020-09-15 04:30:00 | AAPL | Stock | 116.83 | 116.83 | 116.71 | 116.71 | 2147.0 |
| 2020-09-15 04:31:00 | AAPL | Stock | 116.78 | 116.78 | 116.78 | 116.78 | 100.0 |
| 2020-09-15 04:32:00 | AAPL | Stock | 116.75 | 116.75 | 116.74 | 116.74 | 593.0 |
| 2020-09-15 04:33:00 | AAPL | Stock | 116.7 | 116.79 | 116.7 | 116.79 | 200.0 |
| 2020-09-15 04:34:00 | AAPL | Stock | 116.75 | 116.75 | 116.7 | 116.7 | 499.0 |
| 2020-09-15 04:35:00 | AAPL | Stock | 116.75 | 116.75 | 116.75 | 116.75 | 100.0 |
| 2020-09-15 04:37:00 | AAPL | Stock | 116.83 | 116.88 | 116.83 | 116.88 | 1199.0 |
| 2020-09-15 04:38:00 | AAPL | Stock | 116.91 | 116.91 | 116.91 | 116.91 | 200.0 |
| 2020-09-15 04:39:00 | AAPL | Stock | 116.93 | 116.96 | 116.93 | 116.96 | 422.0 |
| 2020-09-15 04:40:00 | AAPL | Stock | 116.98 | 117.2 | 116.98 | 117.1 | 4977.0 |
| 2020-09-15 04:41:00 | AAPL | Stock | 117.11 | 117.2 | 117.11 | 117.19 | 2486.0 |
| 2020-09-15 04:42:00 | AAPL | Stock | 117.19 | 117.19 | 117.1 | 117.1 | 1029.0 |
| 2020-09-15 04:43:00 | AAPL | Stock | 117.12 | 117.12 | 117.12 | 117.12 | 281.0 |
| 2020-09-15 04:44:00 | AAPL | Stock | 117.14 | 117.14 | 117.14 | 117.14 | 150.0 |
| 2020-09-15 04:45:00 | AAPL | Stock | 117.14 | 117.14 | 117.04 | 117.1 | 2267.0 |
| 2020-09-15 04:46:00 | AAPL | Stock | 117.1 | 117.15 | 117.1 | 117.15 | 725.0 |
| 2020-09-15 04:47:00 | AAPL | Stock | 117.2 | 117.2 | 117.18 | 117.2 | 1236.0 |
| 2020-09-15 04:48:00 | AAPL | Stock | 117.2 | 117.2 | 117.19 | 117.19 | 999.0 |
| 2020-09-15 04:49:00 | AAPL | Stock | 117.22 | 117.22 | 117.21 | 117.21 | 500.0 |
| 2020-09-15 04:50:00 | AAPL | Stock | 117.18 | 117.18 | 117.18 | 117.18 | 1028.0 |
| 2020-09-15 04:51:00 | AAPL | Stock | 117.22 | 117.22 | 117.18 | 117.2 | 1450.0 |
| 2020-09-15 04:52:00 | AAPL | Stock | 117.2 | 117.21 | 117.2 | 117.2 | 988.0 |
| 2020-09-15 04:53:00 | AAPL | Stock | 117.19 | 117.22 | 117.02 | 117.2 | 3721.0 |
| 2020-09-15 04:54:00 | AAPL | Stock | 117.15 | 117.15 | 117.15 | 117.15 | 205.0 |
| 2020-09-15 04:55:00 | AAPL | Stock | 117.15 | 117.15 | 117.15 | 117.15 | 370.0 |
| 2020-09-15 04:56:00 | AAPL | Stock | 117.19 | 117.2 | 117.19 | 117.2 | 933.0 |
> showing 50 of 1,242,419 rows — these rows as CSV