PREVIEW / stock_1min / 2023-03-28
file: by_date/stock_1min/2023/2023-03-28.parquet size: 19.3 MB rows: 1,224,758 symbols: 1,630
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-03-28 04:00:00 | AAPL | Stock | 157.95 | 158.06 | 157.7 | 157.7 | 1826.0 |
| 2023-03-28 04:01:00 | AAPL | Stock | 157.68 | 157.68 | 157.49 | 157.52 | 2561.0 |
| 2023-03-28 04:02:00 | AAPL | Stock | 157.56 | 157.9 | 157.26 | 157.6 | 2090.0 |
| 2023-03-28 04:03:00 | AAPL | Stock | 157.5 | 157.5 | 157.33 | 157.33 | 341.0 |
| 2023-03-28 04:04:00 | AAPL | Stock | 157.28 | 157.35 | 157.28 | 157.35 | 357.0 |
| 2023-03-28 04:05:00 | AAPL | Stock | 157.45 | 157.56 | 157.45 | 157.56 | 680.0 |
| 2023-03-28 04:06:00 | AAPL | Stock | 157.45 | 157.45 | 157.45 | 157.45 | 163.0 |
| 2023-03-28 04:07:00 | AAPL | Stock | 157.47 | 157.5 | 157.46 | 157.5 | 646.0 |
| 2023-03-28 04:08:00 | AAPL | Stock | 157.45 | 157.45 | 157.45 | 157.45 | 300.0 |
| 2023-03-28 04:09:00 | AAPL | Stock | 157.5 | 157.5 | 157.41 | 157.47 | 909.0 |
| 2023-03-28 04:10:00 | AAPL | Stock | 157.47 | 157.47 | 157.45 | 157.45 | 305.0 |
| 2023-03-28 04:11:00 | AAPL | Stock | 157.41 | 157.41 | 157.4 | 157.4 | 618.0 |
| 2023-03-28 04:12:00 | AAPL | Stock | 157.37 | 157.37 | 157.34 | 157.34 | 505.0 |
| 2023-03-28 04:15:00 | AAPL | Stock | 157.37 | 157.37 | 157.3 | 157.3 | 1883.0 |
| 2023-03-28 04:18:00 | AAPL | Stock | 157.33 | 157.33 | 157.33 | 157.33 | 196.0 |
| 2023-03-28 04:21:00 | AAPL | Stock | 157.44 | 157.44 | 157.44 | 157.44 | 100.0 |
| 2023-03-28 04:29:00 | AAPL | Stock | 157.58 | 157.58 | 157.58 | 157.58 | 100.0 |
| 2023-03-28 04:31:00 | AAPL | Stock | 157.6 | 157.6 | 157.59 | 157.59 | 1000.0 |
| 2023-03-28 04:35:00 | AAPL | Stock | 157.53 | 157.53 | 157.46 | 157.46 | 343.0 |
| 2023-03-28 04:40:00 | AAPL | Stock | 157.48 | 157.48 | 157.44 | 157.45 | 1235.0 |
| 2023-03-28 04:41:00 | AAPL | Stock | 157.42 | 157.42 | 157.42 | 157.42 | 195.0 |
| 2023-03-28 04:45:00 | AAPL | Stock | 157.5 | 157.5 | 157.5 | 157.5 | 160.0 |
| 2023-03-28 04:46:00 | AAPL | Stock | 157.5 | 157.5 | 157.5 | 157.5 | 400.0 |
| 2023-03-28 04:48:00 | AAPL | Stock | 157.47 | 157.47 | 157.47 | 157.47 | 440.0 |
| 2023-03-28 04:55:00 | AAPL | Stock | 157.57 | 157.57 | 157.57 | 157.57 | 211.0 |
| 2023-03-28 05:01:00 | AAPL | Stock | 157.55 | 157.55 | 157.55 | 157.55 | 100.0 |
| 2023-03-28 05:02:00 | AAPL | Stock | 157.56 | 157.57 | 157.56 | 157.57 | 500.0 |
| 2023-03-28 05:05:00 | AAPL | Stock | 157.64 | 157.64 | 157.64 | 157.64 | 200.0 |
| 2023-03-28 05:07:00 | AAPL | Stock | 157.64 | 157.64 | 157.64 | 157.64 | 800.0 |
| 2023-03-28 05:14:00 | AAPL | Stock | 157.56 | 157.56 | 157.56 | 157.56 | 189.0 |
| 2023-03-28 05:20:00 | AAPL | Stock | 157.6 | 157.6 | 157.6 | 157.6 | 991.0 |
| 2023-03-28 05:32:00 | AAPL | Stock | 157.55 | 157.55 | 157.55 | 157.55 | 260.0 |
| 2023-03-28 05:35:00 | AAPL | Stock | 157.59 | 157.59 | 157.59 | 157.59 | 495.0 |
| 2023-03-28 05:37:00 | AAPL | Stock | 157.6 | 157.6 | 157.6 | 157.6 | 180.0 |
| 2023-03-28 05:45:00 | AAPL | Stock | 157.5 | 157.5 | 157.5 | 157.5 | 445.0 |
| 2023-03-28 05:56:00 | AAPL | Stock | 157.59 | 157.6 | 157.59 | 157.6 | 2433.0 |
| 2023-03-28 06:00:00 | AAPL | Stock | 157.6 | 157.6 | 157.6 | 157.6 | 200.0 |
| 2023-03-28 06:02:00 | AAPL | Stock | 157.6 | 157.6 | 157.6 | 157.6 | 1300.0 |
| 2023-03-28 06:23:00 | AAPL | Stock | 157.67 | 157.67 | 157.67 | 157.67 | 245.0 |
| 2023-03-28 06:26:00 | AAPL | Stock | 157.66 | 157.67 | 157.66 | 157.67 | 299.0 |
| 2023-03-28 06:31:00 | AAPL | Stock | 157.62 | 157.62 | 157.62 | 157.62 | 188.0 |
| 2023-03-28 06:37:00 | AAPL | Stock | 157.53 | 157.53 | 157.51 | 157.51 | 722.0 |
| 2023-03-28 06:38:00 | AAPL | Stock | 157.51 | 157.52 | 157.5 | 157.5 | 5383.0 |
| 2023-03-28 06:41:00 | AAPL | Stock | 157.45 | 157.49 | 157.44 | 157.44 | 955.0 |
| 2023-03-28 06:42:00 | AAPL | Stock | 157.41 | 157.41 | 157.41 | 157.41 | 463.0 |
| 2023-03-28 06:45:00 | AAPL | Stock | 157.45 | 157.45 | 157.45 | 157.45 | 1000.0 |
| 2023-03-28 06:47:00 | AAPL | Stock | 157.42 | 157.42 | 157.38 | 157.38 | 654.0 |
| 2023-03-28 06:48:00 | AAPL | Stock | 157.39 | 157.39 | 157.38 | 157.38 | 561.0 |
| 2023-03-28 06:50:00 | AAPL | Stock | 157.45 | 157.45 | 157.45 | 157.45 | 1000.0 |
| 2023-03-28 06:57:00 | AAPL | Stock | 157.5 | 157.5 | 157.5 | 157.5 | 100.0 |
> showing 50 of 1,224,758 rows — these rows as CSV