PREVIEW / stock_1min / 2020-05-01
file: by_date/stock_1min/2020/2020-05-01.parquet size: 19.7 MB rows: 1,287,695 symbols: 2,031
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-05-01 04:00:00 | AAPL | Stock | 71.32 | 71.3325 | 71.32 | 71.3325 | 3144.0 |
| 2020-05-01 04:01:00 | AAPL | Stock | 71.3325 | 71.4175 | 71.2 | 71.2 | 5736.0 |
| 2020-05-01 04:02:00 | AAPL | Stock | 71.175 | 71.175 | 71.175 | 71.175 | 612.0 |
| 2020-05-01 04:03:00 | AAPL | Stock | 71.125 | 71.125 | 71.125 | 71.125 | 2400.0 |
| 2020-05-01 04:05:00 | AAPL | Stock | 71.12 | 71.125 | 71.12 | 71.125 | 1012.0 |
| 2020-05-01 04:07:00 | AAPL | Stock | 71.0975 | 71.0975 | 71.0975 | 71.0975 | 400.0 |
| 2020-05-01 04:08:00 | AAPL | Stock | 71.0 | 71.0 | 71.0 | 71.0 | 2748.0 |
| 2020-05-01 04:11:00 | AAPL | Stock | 71.0025 | 71.0025 | 71.0025 | 71.0025 | 1000.0 |
| 2020-05-01 04:12:00 | AAPL | Stock | 71.0025 | 71.0025 | 71.0 | 71.0 | 3596.0 |
| 2020-05-01 04:21:00 | AAPL | Stock | 71.08 | 71.08 | 71.0325 | 71.0325 | 1304.0 |
| 2020-05-01 04:27:00 | AAPL | Stock | 71.13 | 71.2225 | 71.13 | 71.2225 | 4040.0 |
| 2020-05-01 04:31:00 | AAPL | Stock | 71.22 | 71.22 | 71.22 | 71.22 | 400.0 |
| 2020-05-01 04:33:00 | AAPL | Stock | 71.1525 | 71.1525 | 71.1425 | 71.1425 | 800.0 |
| 2020-05-01 04:43:00 | AAPL | Stock | 71.125 | 71.125 | 71.125 | 71.125 | 2124.0 |
| 2020-05-01 04:53:00 | AAPL | Stock | 71.275 | 71.275 | 71.245 | 71.245 | 3200.0 |
| 2020-05-01 05:01:00 | AAPL | Stock | 71.325 | 71.325 | 71.325 | 71.325 | 1000.0 |
| 2020-05-01 05:04:00 | AAPL | Stock | 71.385 | 71.4 | 71.385 | 71.4 | 2800.0 |
| 2020-05-01 05:05:00 | AAPL | Stock | 71.4 | 71.4 | 71.4 | 71.4 | 1200.0 |
| 2020-05-01 05:06:00 | AAPL | Stock | 71.47 | 71.4975 | 71.47 | 71.495 | 2280.0 |
| 2020-05-01 05:10:00 | AAPL | Stock | 71.375 | 71.375 | 71.37 | 71.375 | 4048.0 |
| 2020-05-01 05:24:00 | AAPL | Stock | 71.28 | 71.28 | 71.28 | 71.28 | 400.0 |
| 2020-05-01 05:26:00 | AAPL | Stock | 71.2775 | 71.2775 | 71.2775 | 71.2775 | 416.0 |
| 2020-05-01 05:36:00 | AAPL | Stock | 71.25 | 71.25 | 71.2 | 71.2 | 1600.0 |
| 2020-05-01 05:47:00 | AAPL | Stock | 71.25 | 71.25 | 71.25 | 71.25 | 1844.0 |
| 2020-05-01 05:48:00 | AAPL | Stock | 71.125 | 71.125 | 71.125 | 71.125 | 724.0 |
| 2020-05-01 05:49:00 | AAPL | Stock | 71.135 | 71.135 | 71.135 | 71.135 | 1320.0 |
| 2020-05-01 06:09:00 | AAPL | Stock | 71.2625 | 71.2625 | 71.26 | 71.26 | 800.0 |
| 2020-05-01 06:16:00 | AAPL | Stock | 71.4375 | 71.4375 | 71.4375 | 71.4375 | 400.0 |
| 2020-05-01 06:17:00 | AAPL | Stock | 71.495 | 71.4975 | 71.495 | 71.4975 | 2400.0 |
| 2020-05-01 06:19:00 | AAPL | Stock | 71.47 | 71.5 | 71.47 | 71.5 | 9436.0 |
| 2020-05-01 06:20:00 | AAPL | Stock | 71.4975 | 71.5 | 71.4975 | 71.5 | 6616.0 |
| 2020-05-01 06:21:00 | AAPL | Stock | 71.5 | 71.5 | 71.5 | 71.5 | 7524.0 |
| 2020-05-01 06:22:00 | AAPL | Stock | 71.5 | 71.5 | 71.5 | 71.5 | 720.0 |
| 2020-05-01 06:25:00 | AAPL | Stock | 71.555 | 71.555 | 71.555 | 71.555 | 1000.0 |
| 2020-05-01 06:28:00 | AAPL | Stock | 71.5725 | 71.5725 | 71.5725 | 71.5725 | 400.0 |
| 2020-05-01 06:29:00 | AAPL | Stock | 71.5625 | 71.5725 | 71.5625 | 71.5725 | 1112.0 |
| 2020-05-01 06:30:00 | AAPL | Stock | 71.56 | 71.57 | 71.56 | 71.57 | 2304.0 |
| 2020-05-01 06:31:00 | AAPL | Stock | 71.57 | 71.57 | 71.57 | 71.57 | 400.0 |
| 2020-05-01 06:32:00 | AAPL | Stock | 71.57 | 71.57 | 71.57 | 71.57 | 800.0 |
| 2020-05-01 06:33:00 | AAPL | Stock | 71.57 | 71.5975 | 71.57 | 71.5975 | 1672.0 |
| 2020-05-01 06:37:00 | AAPL | Stock | 71.62 | 71.62 | 71.62 | 71.62 | 520.0 |
| 2020-05-01 06:38:00 | AAPL | Stock | 71.65 | 71.65 | 71.5 | 71.5 | 6008.0 |
| 2020-05-01 06:42:00 | AAPL | Stock | 71.395 | 71.395 | 71.355 | 71.355 | 800.0 |
| 2020-05-01 06:52:00 | AAPL | Stock | 71.345 | 71.345 | 71.325 | 71.325 | 3816.0 |
| 2020-05-01 06:53:00 | AAPL | Stock | 71.425 | 71.43 | 71.425 | 71.43 | 6860.0 |
| 2020-05-01 06:54:00 | AAPL | Stock | 71.3775 | 71.3775 | 71.3775 | 71.3775 | 400.0 |
| 2020-05-01 07:00:00 | AAPL | Stock | 71.38 | 71.525 | 71.3775 | 71.39 | 15576.0 |
| 2020-05-01 07:01:00 | AAPL | Stock | 71.4025 | 71.4725 | 71.3775 | 71.455 | 10912.0 |
| 2020-05-01 07:02:00 | AAPL | Stock | 71.455 | 71.455 | 71.455 | 71.455 | 800.0 |
| 2020-05-01 07:03:00 | AAPL | Stock | 71.465 | 71.465 | 71.35 | 71.35 | 13228.0 |
> showing 50 of 1,287,695 rows — these rows as CSV