PREVIEW / stock_1min / 2023-04-17
file: by_date/stock_1min/2023/2023-04-17.parquet size: 20.6 MB rows: 1,268,940 symbols: 1,589
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-17 04:00:00 | AAPL | Stock | 165.25 | 165.61 | 165.25 | 165.61 | 1630.0 |
| 2023-04-17 04:01:00 | AAPL | Stock | 165.62 | 165.62 | 165.36 | 165.36 | 526.0 |
| 2023-04-17 04:02:00 | AAPL | Stock | 165.5 | 165.5 | 165.5 | 165.5 | 102.0 |
| 2023-04-17 04:03:00 | AAPL | Stock | 165.5 | 165.5 | 165.5 | 165.5 | 857.0 |
| 2023-04-17 04:06:00 | AAPL | Stock | 165.5 | 165.5 | 165.5 | 165.5 | 2210.0 |
| 2023-04-17 04:07:00 | AAPL | Stock | 165.42 | 165.42 | 165.42 | 165.42 | 380.0 |
| 2023-04-17 04:10:00 | AAPL | Stock | 165.39 | 165.39 | 165.39 | 165.39 | 100.0 |
| 2023-04-17 04:11:00 | AAPL | Stock | 165.39 | 165.39 | 165.29 | 165.29 | 925.0 |
| 2023-04-17 04:13:00 | AAPL | Stock | 165.39 | 165.5 | 165.39 | 165.5 | 6575.0 |
| 2023-04-17 04:14:00 | AAPL | Stock | 165.5 | 165.5 | 165.5 | 165.5 | 557.0 |
| 2023-04-17 04:18:00 | AAPL | Stock | 165.43 | 165.54 | 165.43 | 165.5 | 3050.0 |
| 2023-04-17 04:20:00 | AAPL | Stock | 165.5 | 165.51 | 165.5 | 165.5 | 4364.0 |
| 2023-04-17 04:21:00 | AAPL | Stock | 165.51 | 165.51 | 165.5 | 165.5 | 1500.0 |
| 2023-04-17 04:22:00 | AAPL | Stock | 165.41 | 165.41 | 165.41 | 165.41 | 100.0 |
| 2023-04-17 04:33:00 | AAPL | Stock | 165.3 | 165.3 | 165.3 | 165.3 | 130.0 |
| 2023-04-17 04:37:00 | AAPL | Stock | 165.31 | 165.32 | 165.3 | 165.32 | 830.0 |
| 2023-04-17 04:38:00 | AAPL | Stock | 165.26 | 165.26 | 165.25 | 165.25 | 435.0 |
| 2023-04-17 04:43:00 | AAPL | Stock | 165.3 | 165.3 | 165.3 | 165.3 | 100.0 |
| 2023-04-17 04:46:00 | AAPL | Stock | 165.26 | 165.26 | 165.26 | 165.26 | 227.0 |
| 2023-04-17 04:47:00 | AAPL | Stock | 165.27 | 165.27 | 165.27 | 165.27 | 110.0 |
| 2023-04-17 04:54:00 | AAPL | Stock | 165.4 | 165.4 | 165.4 | 165.4 | 178.0 |
| 2023-04-17 04:55:00 | AAPL | Stock | 165.39 | 165.39 | 165.39 | 165.39 | 220.0 |
| 2023-04-17 04:56:00 | AAPL | Stock | 165.38 | 165.39 | 165.38 | 165.39 | 415.0 |
| 2023-04-17 05:04:00 | AAPL | Stock | 165.39 | 165.39 | 165.39 | 165.39 | 300.0 |
| 2023-04-17 05:07:00 | AAPL | Stock | 165.27 | 165.27 | 165.25 | 165.25 | 608.0 |
| 2023-04-17 05:08:00 | AAPL | Stock | 165.24 | 165.24 | 165.21 | 165.21 | 833.0 |
| 2023-04-17 05:12:00 | AAPL | Stock | 165.21 | 165.21 | 165.21 | 165.21 | 260.0 |
| 2023-04-17 05:18:00 | AAPL | Stock | 165.23 | 165.23 | 165.23 | 165.23 | 155.0 |
| 2023-04-17 05:23:00 | AAPL | Stock | 165.13 | 165.14 | 165.13 | 165.14 | 447.0 |
| 2023-04-17 05:30:00 | AAPL | Stock | 165.14 | 165.14 | 165.14 | 165.14 | 264.0 |
| 2023-04-17 05:34:00 | AAPL | Stock | 165.17 | 165.17 | 165.17 | 165.17 | 188.0 |
| 2023-04-17 05:36:00 | AAPL | Stock | 165.19 | 165.19 | 165.19 | 165.19 | 151.0 |
| 2023-04-17 05:39:00 | AAPL | Stock | 165.15 | 165.15 | 165.15 | 165.15 | 100.0 |
| 2023-04-17 05:40:00 | AAPL | Stock | 165.1 | 165.1 | 165.1 | 165.1 | 100.0 |
| 2023-04-17 05:43:00 | AAPL | Stock | 165.08 | 165.08 | 165.08 | 165.08 | 143.0 |
| 2023-04-17 05:45:00 | AAPL | Stock | 165.01 | 165.01 | 165.01 | 165.01 | 200.0 |
| 2023-04-17 05:46:00 | AAPL | Stock | 165.05 | 165.05 | 165.05 | 165.05 | 100.0 |
| 2023-04-17 05:49:00 | AAPL | Stock | 164.96 | 165.0 | 164.96 | 165.0 | 206.0 |
| 2023-04-17 05:51:00 | AAPL | Stock | 165.05 | 165.05 | 165.05 | 165.05 | 210.0 |
| 2023-04-17 05:53:00 | AAPL | Stock | 165.0 | 165.0 | 164.95 | 164.95 | 1400.0 |
| 2023-04-17 05:54:00 | AAPL | Stock | 164.95 | 164.95 | 164.95 | 164.95 | 2765.0 |
| 2023-04-17 06:07:00 | AAPL | Stock | 165.01 | 165.01 | 165.01 | 165.01 | 100.0 |
| 2023-04-17 06:10:00 | AAPL | Stock | 165.0 | 165.0 | 165.0 | 165.0 | 100.0 |
| 2023-04-17 06:12:00 | AAPL | Stock | 165.1 | 165.1 | 165.1 | 165.1 | 125.0 |
| 2023-04-17 06:13:00 | AAPL | Stock | 165.1 | 165.24 | 165.1 | 165.24 | 267.0 |
| 2023-04-17 06:14:00 | AAPL | Stock | 165.24 | 165.24 | 165.24 | 165.24 | 1270.0 |
| 2023-04-17 06:15:00 | AAPL | Stock | 165.24 | 165.35 | 165.24 | 165.35 | 1436.0 |
| 2023-04-17 06:19:00 | AAPL | Stock | 165.35 | 165.35 | 165.35 | 165.35 | 865.0 |
| 2023-04-17 06:21:00 | AAPL | Stock | 165.33 | 165.35 | 165.33 | 165.35 | 3266.0 |
| 2023-04-17 06:26:00 | AAPL | Stock | 165.21 | 165.21 | 165.21 | 165.21 | 412.0 |
> showing 50 of 1,268,940 rows — these rows as CSV