PREVIEW / stock_1min / 2021-10-27
file: by_date/stock_1min/2021/2021-10-27.parquet size: 24.6 MB rows: 1,402,095 symbols: 2,318
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-10-27 04:01:00 | AAPL | Stock | 149.47 | 149.47 | 149.47 | 149.47 | 100.0 |
| 2021-10-27 04:02:00 | AAPL | Stock | 149.51 | 149.51 | 149.51 | 149.51 | 200.0 |
| 2021-10-27 04:03:00 | AAPL | Stock | 149.52 | 149.52 | 149.52 | 149.52 | 119.0 |
| 2021-10-27 04:07:00 | AAPL | Stock | 149.66 | 149.72 | 149.66 | 149.72 | 750.0 |
| 2021-10-27 04:09:00 | AAPL | Stock | 149.6 | 149.6 | 149.6 | 149.6 | 643.0 |
| 2021-10-27 04:11:00 | AAPL | Stock | 149.72 | 149.72 | 149.72 | 149.72 | 200.0 |
| 2021-10-27 04:14:00 | AAPL | Stock | 149.66 | 149.66 | 149.51 | 149.51 | 3904.0 |
| 2021-10-27 04:15:00 | AAPL | Stock | 149.51 | 149.68 | 149.51 | 149.68 | 479.0 |
| 2021-10-27 04:24:00 | AAPL | Stock | 149.65 | 149.68 | 149.65 | 149.68 | 365.0 |
| 2021-10-27 04:30:00 | AAPL | Stock | 149.6 | 149.6 | 149.6 | 149.6 | 500.0 |
| 2021-10-27 04:37:00 | AAPL | Stock | 149.6 | 149.6 | 149.6 | 149.6 | 316.0 |
| 2021-10-27 04:38:00 | AAPL | Stock | 149.52 | 149.52 | 149.52 | 149.52 | 100.0 |
| 2021-10-27 04:42:00 | AAPL | Stock | 149.52 | 149.52 | 149.52 | 149.52 | 109.0 |
| 2021-10-27 04:43:00 | AAPL | Stock | 149.58 | 149.59 | 149.58 | 149.59 | 300.0 |
| 2021-10-27 04:46:00 | AAPL | Stock | 149.55 | 149.55 | 149.55 | 149.55 | 100.0 |
| 2021-10-27 04:52:00 | AAPL | Stock | 149.55 | 149.55 | 149.55 | 149.55 | 685.0 |
| 2021-10-27 04:53:00 | AAPL | Stock | 149.46 | 149.5 | 149.45 | 149.45 | 782.0 |
| 2021-10-27 04:54:00 | AAPL | Stock | 149.45 | 149.45 | 149.45 | 149.45 | 150.0 |
| 2021-10-27 04:55:00 | AAPL | Stock | 149.41 | 149.41 | 149.41 | 149.41 | 202.0 |
| 2021-10-27 04:57:00 | AAPL | Stock | 149.35 | 149.35 | 149.35 | 149.35 | 500.0 |
| 2021-10-27 04:58:00 | AAPL | Stock | 149.33 | 149.33 | 149.33 | 149.33 | 800.0 |
| 2021-10-27 05:00:00 | AAPL | Stock | 149.3 | 149.3 | 149.21 | 149.21 | 600.0 |
| 2021-10-27 05:01:00 | AAPL | Stock | 149.1 | 149.11 | 149.1 | 149.11 | 467.0 |
| 2021-10-27 05:02:00 | AAPL | Stock | 149.1 | 149.1 | 149.1 | 149.1 | 1047.0 |
| 2021-10-27 05:03:00 | AAPL | Stock | 149.08 | 149.2 | 149.08 | 149.15 | 1116.0 |
| 2021-10-27 05:06:00 | AAPL | Stock | 149.14 | 149.14 | 149.14 | 149.14 | 894.0 |
| 2021-10-27 05:10:00 | AAPL | Stock | 149.08 | 149.08 | 149.0 | 149.0 | 200.0 |
| 2021-10-27 05:13:00 | AAPL | Stock | 149.15 | 149.15 | 149.15 | 149.15 | 134.0 |
| 2021-10-27 05:14:00 | AAPL | Stock | 149.13 | 149.13 | 149.13 | 149.13 | 500.0 |
| 2021-10-27 05:15:00 | AAPL | Stock | 149.06 | 149.06 | 149.06 | 149.06 | 110.0 |
| 2021-10-27 05:18:00 | AAPL | Stock | 149.2 | 149.2 | 149.2 | 149.2 | 112.0 |
| 2021-10-27 05:21:00 | AAPL | Stock | 149.27 | 149.27 | 149.27 | 149.27 | 400.0 |
| 2021-10-27 05:22:00 | AAPL | Stock | 149.19 | 149.19 | 149.19 | 149.19 | 128.0 |
| 2021-10-27 05:24:00 | AAPL | Stock | 149.15 | 149.15 | 149.15 | 149.15 | 250.0 |
| 2021-10-27 05:26:00 | AAPL | Stock | 149.44 | 149.44 | 149.44 | 149.44 | 115.0 |
| 2021-10-27 05:27:00 | AAPL | Stock | 149.28 | 149.28 | 149.25 | 149.25 | 200.0 |
| 2021-10-27 05:29:00 | AAPL | Stock | 149.3 | 149.3 | 149.3 | 149.3 | 100.0 |
| 2021-10-27 05:34:00 | AAPL | Stock | 149.31 | 149.31 | 149.3 | 149.3 | 1413.0 |
| 2021-10-27 05:35:00 | AAPL | Stock | 149.21 | 149.21 | 149.21 | 149.21 | 134.0 |
| 2021-10-27 05:36:00 | AAPL | Stock | 149.28 | 149.28 | 149.28 | 149.28 | 271.0 |
| 2021-10-27 05:41:00 | AAPL | Stock | 149.18 | 149.18 | 149.18 | 149.18 | 100.0 |
| 2021-10-27 05:42:00 | AAPL | Stock | 149.18 | 149.19 | 149.18 | 149.19 | 404.0 |
| 2021-10-27 05:43:00 | AAPL | Stock | 149.18 | 149.18 | 149.18 | 149.18 | 360.0 |
| 2021-10-27 05:50:00 | AAPL | Stock | 149.18 | 149.18 | 149.18 | 149.18 | 100.0 |
| 2021-10-27 05:52:00 | AAPL | Stock | 149.16 | 149.16 | 148.98 | 149.1 | 2047.0 |
| 2021-10-27 05:56:00 | AAPL | Stock | 149.03 | 149.03 | 149.03 | 149.03 | 295.0 |
| 2021-10-27 05:57:00 | AAPL | Stock | 149.05 | 149.05 | 149.05 | 149.05 | 605.0 |
| 2021-10-27 05:58:00 | AAPL | Stock | 149.1 | 149.1 | 149.09 | 149.09 | 332.0 |
| 2021-10-27 05:59:00 | AAPL | Stock | 149.12 | 149.12 | 149.12 | 149.12 | 396.0 |
| 2021-10-27 06:04:00 | AAPL | Stock | 149.11 | 149.12 | 149.11 | 149.12 | 258.0 |
> showing 50 of 1,402,095 rows — these rows as CSV