PREVIEW / stock_1min / 2020-07-21
file: by_date/stock_1min/2020/2020-07-21.parquet size: 20.8 MB rows: 1,303,332 symbols: 2,084
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-07-21 04:00:00 | AAPL | Stock | 99.25 | 99.25 | 99.25 | 99.25 | 2128.0 |
| 2020-07-21 04:02:00 | AAPL | Stock | 99.3625 | 99.3625 | 99.3625 | 99.3625 | 2900.0 |
| 2020-07-21 04:04:00 | AAPL | Stock | 99.425 | 99.425 | 99.4225 | 99.425 | 3420.0 |
| 2020-07-21 04:08:00 | AAPL | Stock | 99.45 | 99.45 | 99.45 | 99.45 | 1600.0 |
| 2020-07-21 04:09:00 | AAPL | Stock | 99.5 | 99.5 | 99.5 | 99.5 | 580.0 |
| 2020-07-21 04:13:00 | AAPL | Stock | 99.5 | 99.5 | 99.5 | 99.5 | 6984.0 |
| 2020-07-21 04:16:00 | AAPL | Stock | 99.45 | 99.45 | 99.45 | 99.45 | 720.0 |
| 2020-07-21 04:20:00 | AAPL | Stock | 99.375 | 99.375 | 99.375 | 99.375 | 400.0 |
| 2020-07-21 04:24:00 | AAPL | Stock | 99.375 | 99.375 | 99.375 | 99.375 | 748.0 |
| 2020-07-21 04:33:00 | AAPL | Stock | 99.4075 | 99.4075 | 99.375 | 99.375 | 1816.0 |
| 2020-07-21 04:34:00 | AAPL | Stock | 99.37 | 99.375 | 99.37 | 99.375 | 5400.0 |
| 2020-07-21 04:43:00 | AAPL | Stock | 99.35 | 99.35 | 99.35 | 99.35 | 1200.0 |
| 2020-07-21 04:49:00 | AAPL | Stock | 99.3325 | 99.3375 | 99.3325 | 99.3375 | 2104.0 |
| 2020-07-21 04:50:00 | AAPL | Stock | 99.335 | 99.335 | 99.3 | 99.3 | 824.0 |
| 2020-07-21 04:55:00 | AAPL | Stock | 99.2875 | 99.2875 | 99.2775 | 99.2775 | 2740.0 |
| 2020-07-21 04:58:00 | AAPL | Stock | 99.2775 | 99.2775 | 99.2775 | 99.2775 | 4556.0 |
| 2020-07-21 05:07:00 | AAPL | Stock | 99.295 | 99.295 | 99.295 | 99.295 | 1164.0 |
| 2020-07-21 05:13:00 | AAPL | Stock | 99.2475 | 99.2475 | 99.2475 | 99.2475 | 400.0 |
| 2020-07-21 05:19:00 | AAPL | Stock | 99.2475 | 99.2475 | 99.2475 | 99.2475 | 816.0 |
| 2020-07-21 05:31:00 | AAPL | Stock | 99.2425 | 99.2425 | 99.2425 | 99.2425 | 400.0 |
| 2020-07-21 05:33:00 | AAPL | Stock | 99.2475 | 99.2475 | 99.2475 | 99.2475 | 400.0 |
| 2020-07-21 05:34:00 | AAPL | Stock | 99.25 | 99.25 | 99.25 | 99.25 | 400.0 |
| 2020-07-21 05:35:00 | AAPL | Stock | 99.25 | 99.25 | 99.25 | 99.25 | 800.0 |
| 2020-07-21 05:36:00 | AAPL | Stock | 99.25 | 99.25 | 99.25 | 99.25 | 1516.0 |
| 2020-07-21 05:57:00 | AAPL | Stock | 99.3225 | 99.3225 | 99.3225 | 99.3225 | 420.0 |
| 2020-07-21 06:07:00 | AAPL | Stock | 99.27 | 99.27 | 99.27 | 99.27 | 400.0 |
| 2020-07-21 06:08:00 | AAPL | Stock | 99.31 | 99.31 | 99.31 | 99.31 | 400.0 |
| 2020-07-21 06:13:00 | AAPL | Stock | 99.2325 | 99.2325 | 99.2325 | 99.2325 | 400.0 |
| 2020-07-21 06:19:00 | AAPL | Stock | 99.175 | 99.175 | 99.175 | 99.175 | 400.0 |
| 2020-07-21 06:23:00 | AAPL | Stock | 99.175 | 99.175 | 99.175 | 99.175 | 2244.0 |
| 2020-07-21 06:24:00 | AAPL | Stock | 99.1825 | 99.1825 | 99.1825 | 99.1825 | 400.0 |
| 2020-07-21 06:27:00 | AAPL | Stock | 99.175 | 99.175 | 99.175 | 99.175 | 1500.0 |
| 2020-07-21 06:29:00 | AAPL | Stock | 99.15 | 99.15 | 99.15 | 99.15 | 400.0 |
| 2020-07-21 06:31:00 | AAPL | Stock | 99.15 | 99.15 | 99.125 | 99.125 | 1600.0 |
| 2020-07-21 06:33:00 | AAPL | Stock | 99.13 | 99.13 | 99.125 | 99.125 | 2744.0 |
| 2020-07-21 06:35:00 | AAPL | Stock | 99.1125 | 99.1125 | 99.1125 | 99.1125 | 1400.0 |
| 2020-07-21 06:36:00 | AAPL | Stock | 99.1575 | 99.1625 | 99.1575 | 99.1625 | 1600.0 |
| 2020-07-21 06:44:00 | AAPL | Stock | 99.2175 | 99.2175 | 99.2125 | 99.2175 | 7204.0 |
| 2020-07-21 06:49:00 | AAPL | Stock | 99.2175 | 99.2175 | 99.2175 | 99.2175 | 1200.0 |
| 2020-07-21 06:50:00 | AAPL | Stock | 99.2175 | 99.2175 | 99.175 | 99.2175 | 2600.0 |
| 2020-07-21 06:52:00 | AAPL | Stock | 99.2175 | 99.2175 | 99.2175 | 99.2175 | 1648.0 |
| 2020-07-21 06:55:00 | AAPL | Stock | 99.2475 | 99.2475 | 99.2475 | 99.2475 | 800.0 |
| 2020-07-21 06:57:00 | AAPL | Stock | 99.0875 | 99.0875 | 99.0875 | 99.0875 | 448.0 |
| 2020-07-21 06:59:00 | AAPL | Stock | 99.2225 | 99.225 | 99.2225 | 99.225 | 3520.0 |
| 2020-07-21 07:00:00 | AAPL | Stock | 99.0775 | 99.2425 | 99.0 | 99.0125 | 46316.0 |
| 2020-07-21 07:01:00 | AAPL | Stock | 99.025 | 99.0375 | 98.95 | 98.95 | 35516.0 |
| 2020-07-21 07:02:00 | AAPL | Stock | 98.9475 | 98.9975 | 98.9475 | 98.9825 | 4124.0 |
| 2020-07-21 07:03:00 | AAPL | Stock | 99.0 | 99.0 | 98.975 | 98.975 | 6364.0 |
| 2020-07-21 07:04:00 | AAPL | Stock | 99.0 | 99.015 | 99.0 | 99.005 | 14520.0 |
| 2020-07-21 07:05:00 | AAPL | Stock | 99.045 | 99.05 | 99.02 | 99.0225 | 2520.0 |
> showing 50 of 1,303,332 rows — these rows as CSV