PREVIEW / stock_1min / 2023-03-10
file: by_date/stock_1min/2023/2023-03-10.parquet size: 22.9 MB rows: 1,437,218 symbols: 1,667
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-10 04:00:00 | AAPL | Stock | 150.29 | 150.4 | 150.29 | 150.4 | 676.0 |
| 2023-03-10 04:01:00 | AAPL | Stock | 150.4 | 150.4 | 149.77 | 150.24 | 4662.0 |
| 2023-03-10 04:03:00 | AAPL | Stock | 150.22 | 150.22 | 150.22 | 150.22 | 140.0 |
| 2023-03-10 04:04:00 | AAPL | Stock | 150.22 | 150.25 | 150.21 | 150.25 | 723.0 |
| 2023-03-10 04:05:00 | AAPL | Stock | 150.3 | 150.35 | 150.22 | 150.22 | 998.0 |
| 2023-03-10 04:07:00 | AAPL | Stock | 150.24 | 150.24 | 150.24 | 150.24 | 100.0 |
| 2023-03-10 04:08:00 | AAPL | Stock | 150.26 | 150.26 | 150.26 | 150.26 | 150.0 |
| 2023-03-10 04:09:00 | AAPL | Stock | 150.3 | 150.3 | 150.3 | 150.3 | 1730.0 |
| 2023-03-10 04:10:00 | AAPL | Stock | 150.3 | 150.35 | 150.3 | 150.35 | 930.0 |
| 2023-03-10 04:12:00 | AAPL | Stock | 150.34 | 150.34 | 150.34 | 150.34 | 129.0 |
| 2023-03-10 04:13:00 | AAPL | Stock | 150.32 | 150.32 | 150.32 | 150.32 | 627.0 |
| 2023-03-10 04:18:00 | AAPL | Stock | 150.4 | 150.4 | 150.4 | 150.4 | 200.0 |
| 2023-03-10 04:24:00 | AAPL | Stock | 150.38 | 150.38 | 150.38 | 150.38 | 293.0 |
| 2023-03-10 04:27:00 | AAPL | Stock | 150.4 | 150.4 | 150.4 | 150.4 | 300.0 |
| 2023-03-10 04:30:00 | AAPL | Stock | 150.66 | 150.67 | 150.66 | 150.67 | 777.0 |
| 2023-03-10 04:31:00 | AAPL | Stock | 150.74 | 150.74 | 150.74 | 150.74 | 100.0 |
| 2023-03-10 04:32:00 | AAPL | Stock | 150.79 | 150.79 | 150.79 | 150.79 | 300.0 |
| 2023-03-10 04:33:00 | AAPL | Stock | 150.79 | 150.91 | 150.79 | 150.91 | 275.0 |
| 2023-03-10 04:35:00 | AAPL | Stock | 150.88 | 150.89 | 150.79 | 150.79 | 718.0 |
| 2023-03-10 04:36:00 | AAPL | Stock | 150.78 | 150.8 | 150.78 | 150.78 | 1197.0 |
| 2023-03-10 04:38:00 | AAPL | Stock | 150.7 | 150.7 | 150.69 | 150.69 | 587.0 |
| 2023-03-10 04:41:00 | AAPL | Stock | 150.64 | 150.64 | 150.64 | 150.64 | 100.0 |
| 2023-03-10 04:42:00 | AAPL | Stock | 150.63 | 150.63 | 150.63 | 150.63 | 100.0 |
| 2023-03-10 04:43:00 | AAPL | Stock | 150.61 | 150.61 | 150.5 | 150.5 | 780.0 |
| 2023-03-10 04:44:00 | AAPL | Stock | 150.45 | 150.47 | 150.41 | 150.47 | 532.0 |
| 2023-03-10 04:48:00 | AAPL | Stock | 150.62 | 150.62 | 150.62 | 150.62 | 124.0 |
| 2023-03-10 04:53:00 | AAPL | Stock | 150.63 | 150.63 | 150.62 | 150.62 | 629.0 |
| 2023-03-10 04:55:00 | AAPL | Stock | 150.47 | 150.47 | 150.47 | 150.47 | 282.0 |
| 2023-03-10 04:57:00 | AAPL | Stock | 150.64 | 150.64 | 150.64 | 150.64 | 277.0 |
| 2023-03-10 05:10:00 | AAPL | Stock | 150.58 | 150.58 | 150.58 | 150.58 | 100.0 |
| 2023-03-10 05:13:00 | AAPL | Stock | 150.62 | 150.62 | 150.62 | 150.62 | 100.0 |
| 2023-03-10 05:14:00 | AAPL | Stock | 150.63 | 150.65 | 150.63 | 150.65 | 439.0 |
| 2023-03-10 05:16:00 | AAPL | Stock | 150.64 | 150.64 | 150.64 | 150.64 | 200.0 |
| 2023-03-10 05:18:00 | AAPL | Stock | 150.6 | 150.6 | 150.6 | 150.6 | 150.0 |
| 2023-03-10 05:19:00 | AAPL | Stock | 150.68 | 150.69 | 150.68 | 150.68 | 606.0 |
| 2023-03-10 05:21:00 | AAPL | Stock | 150.75 | 150.88 | 150.75 | 150.88 | 1000.0 |
| 2023-03-10 05:23:00 | AAPL | Stock | 150.85 | 150.93 | 150.85 | 150.93 | 200.0 |
| 2023-03-10 05:25:00 | AAPL | Stock | 150.87 | 150.95 | 150.87 | 150.95 | 200.0 |
| 2023-03-10 05:33:00 | AAPL | Stock | 150.71 | 150.71 | 150.71 | 150.71 | 100.0 |
| 2023-03-10 05:34:00 | AAPL | Stock | 150.63 | 150.63 | 150.6 | 150.6 | 2097.0 |
| 2023-03-10 05:40:00 | AAPL | Stock | 150.6 | 150.6 | 150.6 | 150.6 | 100.0 |
| 2023-03-10 05:42:00 | AAPL | Stock | 150.6 | 150.6 | 150.6 | 150.6 | 288.0 |
| 2023-03-10 05:43:00 | AAPL | Stock | 150.6 | 150.6 | 150.6 | 150.6 | 1661.0 |
| 2023-03-10 05:46:00 | AAPL | Stock | 150.7 | 150.7 | 150.7 | 150.7 | 450.0 |
| 2023-03-10 05:48:00 | AAPL | Stock | 150.68 | 150.68 | 150.67 | 150.67 | 632.0 |
| 2023-03-10 05:55:00 | AAPL | Stock | 150.65 | 150.65 | 150.51 | 150.51 | 2503.0 |
| 2023-03-10 06:00:00 | AAPL | Stock | 150.48 | 150.48 | 150.48 | 150.48 | 400.0 |
| 2023-03-10 06:01:00 | AAPL | Stock | 150.5 | 150.5 | 150.36 | 150.36 | 2617.0 |
| 2023-03-10 06:02:00 | AAPL | Stock | 150.33 | 150.33 | 150.0 | 150.0 | 7242.0 |
| 2023-03-10 06:03:00 | AAPL | Stock | 149.95 | 150.01 | 149.84 | 150.0 | 5880.0 |
> showing 50 of 1,437,218 rows — these rows as CSV