PREVIEW / stock_1min / 2020-02-03
file: by_date/stock_1min/2020/2020-02-03.parquet size: 17.9 MB rows: 1,169,603 symbols: 2,057
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-02-03 04:00:00 | AAPL | Stock | 77.5525 | 77.625 | 77.55 | 77.625 | 19004.0 |
| 2020-02-03 04:02:00 | AAPL | Stock | 77.6575 | 77.6875 | 77.6575 | 77.6875 | 1480.0 |
| 2020-02-03 04:03:00 | AAPL | Stock | 77.68 | 77.68 | 77.585 | 77.6625 | 2316.0 |
| 2020-02-03 04:06:00 | AAPL | Stock | 77.6075 | 77.6075 | 77.6075 | 77.6075 | 2000.0 |
| 2020-02-03 04:07:00 | AAPL | Stock | 77.58 | 77.58 | 77.55 | 77.55 | 2184.0 |
| 2020-02-03 04:08:00 | AAPL | Stock | 77.55 | 77.55 | 77.5 | 77.55 | 7656.0 |
| 2020-02-03 04:10:00 | AAPL | Stock | 77.54 | 77.54 | 77.54 | 77.54 | 416.0 |
| 2020-02-03 04:12:00 | AAPL | Stock | 77.55 | 77.55 | 77.55 | 77.55 | 400.0 |
| 2020-02-03 04:13:00 | AAPL | Stock | 77.6 | 77.6125 | 77.6 | 77.6125 | 2512.0 |
| 2020-02-03 04:15:00 | AAPL | Stock | 77.6 | 77.6 | 77.6 | 77.6 | 1524.0 |
| 2020-02-03 04:16:00 | AAPL | Stock | 77.6 | 77.6125 | 77.575 | 77.6125 | 2120.0 |
| 2020-02-03 04:21:00 | AAPL | Stock | 77.55 | 77.55 | 77.55 | 77.55 | 2284.0 |
| 2020-02-03 04:23:00 | AAPL | Stock | 77.5 | 77.5 | 77.5 | 77.5 | 400.0 |
| 2020-02-03 04:25:00 | AAPL | Stock | 77.465 | 77.465 | 77.465 | 77.465 | 400.0 |
| 2020-02-03 04:33:00 | AAPL | Stock | 77.4625 | 77.4625 | 77.445 | 77.445 | 1428.0 |
| 2020-02-03 04:36:00 | AAPL | Stock | 77.4 | 77.4 | 77.4 | 77.4 | 8800.0 |
| 2020-02-03 04:37:00 | AAPL | Stock | 77.4 | 77.4 | 77.4 | 77.4 | 2000.0 |
| 2020-02-03 04:38:00 | AAPL | Stock | 77.3725 | 77.3725 | 77.3725 | 77.3725 | 1668.0 |
| 2020-02-03 04:39:00 | AAPL | Stock | 77.35 | 77.35 | 77.35 | 77.35 | 1880.0 |
| 2020-02-03 04:42:00 | AAPL | Stock | 77.305 | 77.305 | 77.2525 | 77.2525 | 2976.0 |
| 2020-02-03 04:43:00 | AAPL | Stock | 77.255 | 77.255 | 77.125 | 77.125 | 9368.0 |
| 2020-02-03 04:44:00 | AAPL | Stock | 77.2375 | 77.25 | 77.125 | 77.125 | 3796.0 |
| 2020-02-03 04:45:00 | AAPL | Stock | 77.1325 | 77.1325 | 77.125 | 77.125 | 4768.0 |
| 2020-02-03 04:46:00 | AAPL | Stock | 77.0675 | 77.0675 | 77.0575 | 77.0575 | 2324.0 |
| 2020-02-03 04:48:00 | AAPL | Stock | 77.0575 | 77.0575 | 77.0575 | 77.0575 | 440.0 |
| 2020-02-03 04:49:00 | AAPL | Stock | 77.15 | 77.15 | 77.15 | 77.15 | 440.0 |
| 2020-02-03 04:50:00 | AAPL | Stock | 77.155 | 77.155 | 77.155 | 77.155 | 800.0 |
| 2020-02-03 04:52:00 | AAPL | Stock | 77.155 | 77.155 | 77.155 | 77.155 | 1076.0 |
| 2020-02-03 04:55:00 | AAPL | Stock | 77.04 | 77.04 | 77.04 | 77.04 | 800.0 |
| 2020-02-03 04:56:00 | AAPL | Stock | 77.0 | 77.0 | 76.945 | 76.95 | 6200.0 |
| 2020-02-03 04:57:00 | AAPL | Stock | 76.8875 | 76.8875 | 76.8 | 76.8 | 14680.0 |
| 2020-02-03 04:58:00 | AAPL | Stock | 76.76 | 76.76 | 76.76 | 76.76 | 1200.0 |
| 2020-02-03 04:59:00 | AAPL | Stock | 76.825 | 76.825 | 76.8 | 76.8 | 1668.0 |
| 2020-02-03 05:00:00 | AAPL | Stock | 76.6875 | 76.6875 | 76.6875 | 76.6875 | 2800.0 |
| 2020-02-03 05:01:00 | AAPL | Stock | 76.625 | 76.625 | 76.5625 | 76.5625 | 3944.0 |
| 2020-02-03 05:02:00 | AAPL | Stock | 76.5125 | 76.5125 | 76.5125 | 76.5125 | 1600.0 |
| 2020-02-03 05:03:00 | AAPL | Stock | 76.5075 | 76.5075 | 76.3 | 76.3 | 6244.0 |
| 2020-02-03 05:04:00 | AAPL | Stock | 76.375 | 76.375 | 76.2775 | 76.3 | 8500.0 |
| 2020-02-03 05:05:00 | AAPL | Stock | 76.2775 | 76.325 | 76.2625 | 76.2625 | 12600.0 |
| 2020-02-03 05:06:00 | AAPL | Stock | 76.25 | 76.2775 | 76.25 | 76.25 | 6468.0 |
| 2020-02-03 05:07:00 | AAPL | Stock | 76.375 | 76.375 | 76.375 | 76.375 | 520.0 |
| 2020-02-03 05:08:00 | AAPL | Stock | 76.4025 | 76.4025 | 76.4025 | 76.4025 | 632.0 |
| 2020-02-03 05:09:00 | AAPL | Stock | 76.375 | 76.375 | 76.375 | 76.375 | 460.0 |
| 2020-02-03 05:12:00 | AAPL | Stock | 76.5 | 76.5 | 76.5 | 76.5 | 1524.0 |
| 2020-02-03 05:13:00 | AAPL | Stock | 76.5 | 76.545 | 76.5 | 76.545 | 1880.0 |
| 2020-02-03 05:14:00 | AAPL | Stock | 76.5 | 76.545 | 76.5 | 76.545 | 6788.0 |
| 2020-02-03 05:15:00 | AAPL | Stock | 76.6275 | 76.6275 | 76.6275 | 76.6275 | 520.0 |
| 2020-02-03 05:18:00 | AAPL | Stock | 76.625 | 76.625 | 76.625 | 76.625 | 600.0 |
| 2020-02-03 05:19:00 | AAPL | Stock | 76.65 | 76.65 | 76.625 | 76.625 | 9200.0 |
| 2020-02-03 05:20:00 | AAPL | Stock | 76.625 | 76.625 | 76.625 | 76.625 | 800.0 |
> showing 50 of 1,169,603 rows — these rows as CSV