PREVIEW / stock_1min / 2021-08-20
file: by_date/stock_1min/2021/2021-08-20.parquet size: 22.9 MB rows: 1,327,644 symbols: 2,405
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 |
|---|---|---|---|---|---|---|---|
| 2021-08-20 04:00:00 | AAPL | Stock | 146.0 | 146.0 | 146.0 | 146.0 | 982.0 |
| 2021-08-20 04:01:00 | AAPL | Stock | 145.91 | 146.0 | 145.9 | 145.9 | 1049.0 |
| 2021-08-20 04:02:00 | AAPL | Stock | 145.92 | 145.92 | 145.9 | 145.9 | 695.0 |
| 2021-08-20 04:03:00 | AAPL | Stock | 146.45 | 146.49 | 146.01 | 146.02 | 1462.0 |
| 2021-08-20 04:05:00 | AAPL | Stock | 146.35 | 146.38 | 146.35 | 146.38 | 200.0 |
| 2021-08-20 04:09:00 | AAPL | Stock | 146.38 | 146.38 | 146.38 | 146.38 | 498.0 |
| 2021-08-20 04:10:00 | AAPL | Stock | 146.38 | 146.38 | 146.38 | 146.38 | 381.0 |
| 2021-08-20 04:12:00 | AAPL | Stock | 146.31 | 146.31 | 146.29 | 146.29 | 316.0 |
| 2021-08-20 04:13:00 | AAPL | Stock | 146.27 | 146.27 | 146.27 | 146.27 | 100.0 |
| 2021-08-20 04:14:00 | AAPL | Stock | 146.08 | 146.08 | 146.08 | 146.08 | 859.0 |
| 2021-08-20 04:23:00 | AAPL | Stock | 146.19 | 146.19 | 146.1 | 146.11 | 782.0 |
| 2021-08-20 04:24:00 | AAPL | Stock | 146.18 | 146.18 | 146.18 | 146.18 | 100.0 |
| 2021-08-20 04:26:00 | AAPL | Stock | 146.1 | 146.1 | 146.1 | 146.1 | 899.0 |
| 2021-08-20 04:27:00 | AAPL | Stock | 146.1 | 146.1 | 146.1 | 146.1 | 469.0 |
| 2021-08-20 04:33:00 | AAPL | Stock | 146.1 | 146.1 | 146.1 | 146.1 | 511.0 |
| 2021-08-20 04:38:00 | AAPL | Stock | 146.05 | 146.05 | 146.05 | 146.05 | 150.0 |
| 2021-08-20 04:39:00 | AAPL | Stock | 146.14 | 146.14 | 146.14 | 146.14 | 472.0 |
| 2021-08-20 04:41:00 | AAPL | Stock | 146.15 | 146.15 | 146.15 | 146.15 | 400.0 |
| 2021-08-20 04:42:00 | AAPL | Stock | 146.2 | 146.22 | 146.2 | 146.22 | 447.0 |
| 2021-08-20 04:43:00 | AAPL | Stock | 146.24 | 146.3 | 146.24 | 146.3 | 367.0 |
| 2021-08-20 04:44:00 | AAPL | Stock | 146.3 | 146.31 | 146.3 | 146.31 | 700.0 |
| 2021-08-20 04:49:00 | AAPL | Stock | 146.21 | 146.22 | 146.21 | 146.22 | 1906.0 |
| 2021-08-20 04:50:00 | AAPL | Stock | 146.25 | 146.25 | 146.25 | 146.25 | 100.0 |
| 2021-08-20 04:52:00 | AAPL | Stock | 146.25 | 146.25 | 146.25 | 146.25 | 102.0 |
| 2021-08-20 04:53:00 | AAPL | Stock | 146.25 | 146.25 | 146.24 | 146.24 | 375.0 |
| 2021-08-20 04:54:00 | AAPL | Stock | 146.27 | 146.27 | 146.25 | 146.25 | 897.0 |
| 2021-08-20 04:59:00 | AAPL | Stock | 146.24 | 146.24 | 146.24 | 146.24 | 100.0 |
| 2021-08-20 05:01:00 | AAPL | Stock | 146.22 | 146.22 | 146.22 | 146.22 | 200.0 |
| 2021-08-20 05:03:00 | AAPL | Stock | 146.17 | 146.17 | 146.15 | 146.15 | 800.0 |
| 2021-08-20 05:04:00 | AAPL | Stock | 146.17 | 146.17 | 146.17 | 146.17 | 329.0 |
| 2021-08-20 05:07:00 | AAPL | Stock | 146.17 | 146.23 | 146.17 | 146.23 | 667.0 |
| 2021-08-20 05:12:00 | AAPL | Stock | 146.17 | 146.17 | 146.17 | 146.17 | 100.0 |
| 2021-08-20 05:13:00 | AAPL | Stock | 146.17 | 146.17 | 146.17 | 146.17 | 144.0 |
| 2021-08-20 05:16:00 | AAPL | Stock | 146.17 | 146.17 | 146.17 | 146.17 | 600.0 |
| 2021-08-20 05:21:00 | AAPL | Stock | 146.29 | 146.31 | 146.29 | 146.31 | 2200.0 |
| 2021-08-20 05:22:00 | AAPL | Stock | 146.31 | 146.37 | 146.31 | 146.31 | 2921.0 |
| 2021-08-20 05:23:00 | AAPL | Stock | 146.4 | 146.4 | 146.39 | 146.4 | 800.0 |
| 2021-08-20 05:27:00 | AAPL | Stock | 146.49 | 146.49 | 146.49 | 146.49 | 200.0 |
| 2021-08-20 05:28:00 | AAPL | Stock | 146.5 | 146.5 | 146.5 | 146.5 | 115.0 |
| 2021-08-20 05:29:00 | AAPL | Stock | 146.5 | 146.5 | 146.5 | 146.5 | 100.0 |
| 2021-08-20 05:32:00 | AAPL | Stock | 146.44 | 146.44 | 146.44 | 146.44 | 200.0 |
| 2021-08-20 05:34:00 | AAPL | Stock | 146.48 | 146.48 | 146.48 | 146.48 | 100.0 |
| 2021-08-20 05:36:00 | AAPL | Stock | 146.5 | 146.5 | 146.5 | 146.5 | 105.0 |
| 2021-08-20 05:37:00 | AAPL | Stock | 146.5 | 146.5 | 146.5 | 146.5 | 100.0 |
| 2021-08-20 05:38:00 | AAPL | Stock | 146.5 | 146.5 | 146.5 | 146.5 | 100.0 |
| 2021-08-20 05:41:00 | AAPL | Stock | 146.46 | 146.46 | 146.4 | 146.45 | 785.0 |
| 2021-08-20 05:43:00 | AAPL | Stock | 146.44 | 146.44 | 146.44 | 146.44 | 548.0 |
| 2021-08-20 05:45:00 | AAPL | Stock | 146.5 | 146.5 | 146.5 | 146.5 | 899.0 |
| 2021-08-20 05:53:00 | AAPL | Stock | 146.5 | 146.5 | 146.45 | 146.45 | 515.0 |
| 2021-08-20 05:57:00 | AAPL | Stock | 146.43 | 146.43 | 146.43 | 146.43 | 400.0 |
> showing 50 of 1,327,644 rows — these rows as CSV