PREVIEW / stock_1min / 2024-01-18
file: by_date/stock_1min/2024/2024-01-18.parquet size: 20.5 MB rows: 1,249,707 symbols: 1,163
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-18 04:00:00 | AAPL | Stock | 182.55 | 182.83 | 182.55 | 182.83 | 400.0 |
| 2024-01-18 04:02:00 | AAPL | Stock | 182.77 | 182.77 | 182.77 | 182.77 | 350.0 |
| 2024-01-18 04:04:00 | AAPL | Stock | 182.76 | 182.76 | 182.76 | 182.76 | 1098.0 |
| 2024-01-18 04:05:00 | AAPL | Stock | 182.71 | 182.71 | 182.54 | 182.6 | 2427.0 |
| 2024-01-18 04:06:00 | AAPL | Stock | 182.6 | 182.6 | 182.6 | 182.6 | 100.0 |
| 2024-01-18 04:07:00 | AAPL | Stock | 182.6 | 182.6 | 182.6 | 182.6 | 200.0 |
| 2024-01-18 04:08:00 | AAPL | Stock | 182.6 | 182.6 | 182.6 | 182.6 | 1398.0 |
| 2024-01-18 04:10:00 | AAPL | Stock | 182.6 | 182.63 | 182.6 | 182.63 | 200.0 |
| 2024-01-18 04:12:00 | AAPL | Stock | 182.71 | 182.71 | 182.71 | 182.71 | 100.0 |
| 2024-01-18 04:13:00 | AAPL | Stock | 182.6 | 182.6 | 182.58 | 182.58 | 599.0 |
| 2024-01-18 04:14:00 | AAPL | Stock | 182.55 | 182.65 | 182.55 | 182.65 | 474.0 |
| 2024-01-18 04:16:00 | AAPL | Stock | 182.5 | 182.5 | 182.5 | 182.5 | 163.0 |
| 2024-01-18 04:23:00 | AAPL | Stock | 182.59 | 182.59 | 182.59 | 182.59 | 131.0 |
| 2024-01-18 04:24:00 | AAPL | Stock | 182.5 | 182.5 | 182.5 | 182.5 | 505.0 |
| 2024-01-18 04:25:00 | AAPL | Stock | 182.5 | 182.6 | 182.5 | 182.6 | 322.0 |
| 2024-01-18 04:26:00 | AAPL | Stock | 182.5 | 182.5 | 182.5 | 182.5 | 112.0 |
| 2024-01-18 04:27:00 | AAPL | Stock | 182.54 | 182.54 | 182.49 | 182.49 | 428.0 |
| 2024-01-18 04:32:00 | AAPL | Stock | 182.37 | 182.37 | 182.37 | 182.37 | 129.0 |
| 2024-01-18 04:34:00 | AAPL | Stock | 182.41 | 182.45 | 182.41 | 182.45 | 200.0 |
| 2024-01-18 04:36:00 | AAPL | Stock | 182.45 | 182.45 | 182.45 | 182.45 | 475.0 |
| 2024-01-18 04:38:00 | AAPL | Stock | 182.41 | 182.41 | 182.41 | 182.41 | 163.0 |
| 2024-01-18 04:40:00 | AAPL | Stock | 182.44 | 182.45 | 182.44 | 182.45 | 702.0 |
| 2024-01-18 04:41:00 | AAPL | Stock | 182.45 | 182.56 | 182.45 | 182.53 | 470.0 |
| 2024-01-18 04:42:00 | AAPL | Stock | 182.45 | 182.45 | 182.45 | 182.45 | 200.0 |
| 2024-01-18 04:43:00 | AAPL | Stock | 182.4 | 182.4 | 182.37 | 182.37 | 333.0 |
| 2024-01-18 04:46:00 | AAPL | Stock | 182.46 | 182.49 | 182.46 | 182.49 | 240.0 |
| 2024-01-18 04:49:00 | AAPL | Stock | 182.46 | 182.46 | 182.46 | 182.46 | 100.0 |
| 2024-01-18 04:51:00 | AAPL | Stock | 182.42 | 182.42 | 182.42 | 182.42 | 760.0 |
| 2024-01-18 04:52:00 | AAPL | Stock | 182.39 | 182.4 | 182.37 | 182.37 | 562.0 |
| 2024-01-18 04:55:00 | AAPL | Stock | 182.31 | 182.31 | 182.31 | 182.31 | 200.0 |
| 2024-01-18 04:56:00 | AAPL | Stock | 182.2 | 182.2 | 182.2 | 182.2 | 100.0 |
| 2024-01-18 05:03:00 | AAPL | Stock | 182.3 | 182.3 | 182.3 | 182.3 | 180.0 |
| 2024-01-18 05:06:00 | AAPL | Stock | 182.23 | 182.23 | 182.23 | 182.23 | 300.0 |
| 2024-01-18 05:08:00 | AAPL | Stock | 182.2 | 182.2 | 182.2 | 182.2 | 100.0 |
| 2024-01-18 05:10:00 | AAPL | Stock | 182.2 | 182.2 | 182.2 | 182.2 | 287.0 |
| 2024-01-18 05:11:00 | AAPL | Stock | 182.15 | 182.15 | 182.11 | 182.11 | 225.0 |
| 2024-01-18 05:13:00 | AAPL | Stock | 182.18 | 182.18 | 182.18 | 182.18 | 123.0 |
| 2024-01-18 05:19:00 | AAPL | Stock | 182.2 | 182.2 | 182.2 | 182.2 | 220.0 |
| 2024-01-18 05:22:00 | AAPL | Stock | 182.37 | 182.37 | 182.37 | 182.37 | 117.0 |
| 2024-01-18 05:23:00 | AAPL | Stock | 182.32 | 182.32 | 182.32 | 182.32 | 100.0 |
| 2024-01-18 05:35:00 | AAPL | Stock | 182.32 | 182.32 | 182.32 | 182.32 | 2493.0 |
| 2024-01-18 05:36:00 | AAPL | Stock | 182.33 | 182.33 | 182.33 | 182.33 | 112.0 |
| 2024-01-18 05:40:00 | AAPL | Stock | 182.3 | 182.3 | 182.3 | 182.3 | 171.0 |
| 2024-01-18 05:41:00 | AAPL | Stock | 182.36 | 182.36 | 182.36 | 182.36 | 125.0 |
| 2024-01-18 05:44:00 | AAPL | Stock | 182.39 | 182.39 | 182.39 | 182.39 | 100.0 |
| 2024-01-18 05:46:00 | AAPL | Stock | 182.39 | 182.43 | 182.39 | 182.43 | 1120.0 |
| 2024-01-18 05:53:00 | AAPL | Stock | 182.48 | 182.48 | 182.48 | 182.48 | 100.0 |
| 2024-01-18 05:56:00 | AAPL | Stock | 182.55 | 182.55 | 182.55 | 182.55 | 100.0 |
| 2024-01-18 05:59:00 | AAPL | Stock | 182.55 | 182.55 | 182.55 | 182.55 | 100.0 |
| 2024-01-18 06:01:00 | AAPL | Stock | 182.55 | 183.5 | 182.55 | 183.5 | 12787.0 |
> showing 50 of 1,249,707 rows — these rows as CSV