PREVIEW / stock_1min / 2020-12-08
file: by_date/stock_1min/2020/2020-12-08.parquet size: 23.3 MB rows: 1,383,384 symbols: 2,253
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-12-08 04:00:00 | AAPL | Stock | 123.65 | 123.65 | 123.65 | 123.65 | 458.0 |
| 2020-12-08 04:01:00 | AAPL | Stock | 123.73 | 123.73 | 123.73 | 123.73 | 100.0 |
| 2020-12-08 04:02:00 | AAPL | Stock | 123.75 | 123.75 | 123.75 | 123.75 | 100.0 |
| 2020-12-08 04:03:00 | AAPL | Stock | 123.65 | 123.65 | 123.65 | 123.65 | 171.0 |
| 2020-12-08 04:04:00 | AAPL | Stock | 123.69 | 123.69 | 123.69 | 123.69 | 257.0 |
| 2020-12-08 04:06:00 | AAPL | Stock | 123.78 | 123.78 | 123.78 | 123.78 | 100.0 |
| 2020-12-08 04:08:00 | AAPL | Stock | 123.8 | 123.8 | 123.78 | 123.78 | 291.0 |
| 2020-12-08 04:11:00 | AAPL | Stock | 123.88 | 123.88 | 123.88 | 123.88 | 186.0 |
| 2020-12-08 04:13:00 | AAPL | Stock | 123.88 | 123.88 | 123.83 | 123.83 | 324.0 |
| 2020-12-08 04:15:00 | AAPL | Stock | 123.77 | 123.77 | 123.77 | 123.77 | 100.0 |
| 2020-12-08 04:19:00 | AAPL | Stock | 123.75 | 123.75 | 123.75 | 123.75 | 100.0 |
| 2020-12-08 04:20:00 | AAPL | Stock | 123.7 | 123.7 | 123.66 | 123.66 | 290.0 |
| 2020-12-08 04:22:00 | AAPL | Stock | 123.65 | 123.65 | 123.65 | 123.65 | 400.0 |
| 2020-12-08 04:23:00 | AAPL | Stock | 123.65 | 123.65 | 123.65 | 123.65 | 170.0 |
| 2020-12-08 04:24:00 | AAPL | Stock | 123.58 | 123.59 | 123.58 | 123.59 | 637.0 |
| 2020-12-08 04:25:00 | AAPL | Stock | 123.6 | 123.6 | 123.6 | 123.6 | 587.0 |
| 2020-12-08 04:26:00 | AAPL | Stock | 123.61 | 123.61 | 123.61 | 123.61 | 160.0 |
| 2020-12-08 04:27:00 | AAPL | Stock | 123.6 | 123.6 | 123.56 | 123.56 | 239.0 |
| 2020-12-08 04:28:00 | AAPL | Stock | 123.59 | 123.59 | 123.59 | 123.59 | 100.0 |
| 2020-12-08 04:30:00 | AAPL | Stock | 123.58 | 123.59 | 123.58 | 123.59 | 1000.0 |
| 2020-12-08 04:31:00 | AAPL | Stock | 123.53 | 123.54 | 123.53 | 123.54 | 1028.0 |
| 2020-12-08 04:41:00 | AAPL | Stock | 123.57 | 123.57 | 123.53 | 123.53 | 870.0 |
| 2020-12-08 04:42:00 | AAPL | Stock | 123.59 | 123.59 | 123.59 | 123.59 | 173.0 |
| 2020-12-08 04:43:00 | AAPL | Stock | 123.55 | 123.55 | 123.55 | 123.55 | 100.0 |
| 2020-12-08 04:44:00 | AAPL | Stock | 123.55 | 123.55 | 123.55 | 123.55 | 184.0 |
| 2020-12-08 04:45:00 | AAPL | Stock | 123.5 | 123.5 | 123.5 | 123.5 | 200.0 |
| 2020-12-08 04:46:00 | AAPL | Stock | 123.45 | 123.45 | 123.45 | 123.45 | 600.0 |
| 2020-12-08 04:47:00 | AAPL | Stock | 123.45 | 123.45 | 123.45 | 123.45 | 800.0 |
| 2020-12-08 04:57:00 | AAPL | Stock | 123.45 | 123.45 | 123.45 | 123.45 | 470.0 |
| 2020-12-08 04:58:00 | AAPL | Stock | 123.49 | 123.49 | 123.49 | 123.49 | 117.0 |
| 2020-12-08 05:00:00 | AAPL | Stock | 123.51 | 123.51 | 123.51 | 123.51 | 414.0 |
| 2020-12-08 05:01:00 | AAPL | Stock | 123.51 | 123.51 | 123.51 | 123.51 | 123.0 |
| 2020-12-08 05:02:00 | AAPL | Stock | 123.54 | 123.54 | 123.54 | 123.54 | 100.0 |
| 2020-12-08 05:05:00 | AAPL | Stock | 123.51 | 123.51 | 123.51 | 123.51 | 150.0 |
| 2020-12-08 05:08:00 | AAPL | Stock | 123.51 | 123.51 | 123.51 | 123.51 | 139.0 |
| 2020-12-08 05:13:00 | AAPL | Stock | 123.47 | 123.47 | 123.45 | 123.45 | 615.0 |
| 2020-12-08 05:15:00 | AAPL | Stock | 123.38 | 123.38 | 123.38 | 123.38 | 3950.0 |
| 2020-12-08 05:16:00 | AAPL | Stock | 123.39 | 123.39 | 123.39 | 123.39 | 100.0 |
| 2020-12-08 05:20:00 | AAPL | Stock | 123.4 | 123.4 | 123.4 | 123.4 | 300.0 |
| 2020-12-08 05:23:00 | AAPL | Stock | 123.32 | 123.32 | 123.3 | 123.3 | 887.0 |
| 2020-12-08 05:24:00 | AAPL | Stock | 123.3 | 123.3 | 123.3 | 123.3 | 3309.0 |
| 2020-12-08 05:27:00 | AAPL | Stock | 123.33 | 123.33 | 123.33 | 123.33 | 398.0 |
| 2020-12-08 05:31:00 | AAPL | Stock | 123.4 | 123.45 | 123.4 | 123.45 | 200.0 |
| 2020-12-08 05:33:00 | AAPL | Stock | 123.42 | 123.42 | 123.42 | 123.42 | 100.0 |
| 2020-12-08 05:34:00 | AAPL | Stock | 123.41 | 123.41 | 123.41 | 123.41 | 600.0 |
| 2020-12-08 05:38:00 | AAPL | Stock | 123.41 | 123.41 | 123.41 | 123.41 | 900.0 |
| 2020-12-08 05:41:00 | AAPL | Stock | 123.59 | 123.59 | 123.59 | 123.59 | 818.0 |
| 2020-12-08 05:44:00 | AAPL | Stock | 123.51 | 123.51 | 123.51 | 123.51 | 537.0 |
| 2020-12-08 05:47:00 | AAPL | Stock | 123.54 | 123.54 | 123.54 | 123.54 | 600.0 |
| 2020-12-08 06:01:00 | AAPL | Stock | 123.58 | 123.58 | 123.58 | 123.58 | 100.0 |
> showing 50 of 1,383,384 rows — these rows as CSV