PREVIEW / stock_1min / 2023-08-11
file: by_date/stock_1min/2023/2023-08-11.parquet size: 19.8 MB rows: 1,219,699 symbols: 1,425
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-08-11 04:00:00 | AAPL | Stock | 178.43 | 178.48 | 178.43 | 178.43 | 325.0 |
| 2023-08-11 04:02:00 | AAPL | Stock | 178.37 | 178.38 | 178.25 | 178.25 | 1082.0 |
| 2023-08-11 04:03:00 | AAPL | Stock | 178.2 | 178.2 | 178.06 | 178.06 | 600.0 |
| 2023-08-11 04:04:00 | AAPL | Stock | 178.11 | 178.11 | 178.1 | 178.1 | 2757.0 |
| 2023-08-11 04:05:00 | AAPL | Stock | 178.14 | 178.14 | 178.14 | 178.14 | 100.0 |
| 2023-08-11 04:09:00 | AAPL | Stock | 178.05 | 178.05 | 178.05 | 178.05 | 697.0 |
| 2023-08-11 04:10:00 | AAPL | Stock | 178.0 | 178.0 | 178.0 | 178.0 | 3305.0 |
| 2023-08-11 04:11:00 | AAPL | Stock | 178.08 | 178.08 | 177.97 | 177.97 | 1513.0 |
| 2023-08-11 04:13:00 | AAPL | Stock | 177.93 | 177.93 | 177.8 | 177.82 | 2729.0 |
| 2023-08-11 04:15:00 | AAPL | Stock | 177.81 | 177.81 | 177.81 | 177.81 | 292.0 |
| 2023-08-11 04:19:00 | AAPL | Stock | 177.87 | 178.09 | 177.87 | 178.09 | 1025.0 |
| 2023-08-11 04:21:00 | AAPL | Stock | 177.86 | 177.86 | 177.86 | 177.86 | 400.0 |
| 2023-08-11 04:22:00 | AAPL | Stock | 177.82 | 177.82 | 177.82 | 177.82 | 180.0 |
| 2023-08-11 04:23:00 | AAPL | Stock | 177.77 | 177.77 | 177.68 | 177.75 | 2328.0 |
| 2023-08-11 04:24:00 | AAPL | Stock | 177.86 | 177.88 | 177.86 | 177.88 | 747.0 |
| 2023-08-11 04:28:00 | AAPL | Stock | 177.82 | 177.83 | 177.82 | 177.83 | 302.0 |
| 2023-08-11 04:29:00 | AAPL | Stock | 177.8 | 177.83 | 177.73 | 177.73 | 875.0 |
| 2023-08-11 04:30:00 | AAPL | Stock | 177.68 | 177.68 | 177.51 | 177.51 | 1152.0 |
| 2023-08-11 04:34:00 | AAPL | Stock | 177.6 | 177.6 | 177.59 | 177.59 | 340.0 |
| 2023-08-11 04:35:00 | AAPL | Stock | 177.6 | 177.77 | 177.6 | 177.77 | 887.0 |
| 2023-08-11 04:36:00 | AAPL | Stock | 177.55 | 177.55 | 177.55 | 177.55 | 189.0 |
| 2023-08-11 04:37:00 | AAPL | Stock | 177.5 | 177.5 | 177.5 | 177.5 | 380.0 |
| 2023-08-11 04:42:00 | AAPL | Stock | 177.45 | 177.46 | 177.4 | 177.4 | 1456.0 |
| 2023-08-11 04:46:00 | AAPL | Stock | 177.49 | 177.49 | 177.49 | 177.49 | 598.0 |
| 2023-08-11 04:50:00 | AAPL | Stock | 177.46 | 177.46 | 177.46 | 177.46 | 112.0 |
| 2023-08-11 04:54:00 | AAPL | Stock | 177.5 | 177.5 | 177.5 | 177.5 | 220.0 |
| 2023-08-11 04:55:00 | AAPL | Stock | 177.55 | 177.69 | 177.55 | 177.68 | 1615.0 |
| 2023-08-11 04:57:00 | AAPL | Stock | 177.69 | 177.69 | 177.69 | 177.69 | 100.0 |
| 2023-08-11 04:59:00 | AAPL | Stock | 177.69 | 177.69 | 177.69 | 177.69 | 100.0 |
| 2023-08-11 05:04:00 | AAPL | Stock | 177.74 | 177.74 | 177.7 | 177.7 | 983.0 |
| 2023-08-11 05:07:00 | AAPL | Stock | 177.77 | 177.77 | 177.7 | 177.7 | 1425.0 |
| 2023-08-11 05:11:00 | AAPL | Stock | 177.7 | 177.7 | 177.7 | 177.7 | 400.0 |
| 2023-08-11 05:16:00 | AAPL | Stock | 177.77 | 177.77 | 177.77 | 177.77 | 184.0 |
| 2023-08-11 05:18:00 | AAPL | Stock | 177.68 | 177.68 | 177.68 | 177.68 | 172.0 |
| 2023-08-11 05:31:00 | AAPL | Stock | 177.75 | 177.75 | 177.75 | 177.75 | 100.0 |
| 2023-08-11 05:33:00 | AAPL | Stock | 177.74 | 177.74 | 177.74 | 177.74 | 100.0 |
| 2023-08-11 05:34:00 | AAPL | Stock | 177.77 | 177.77 | 177.77 | 177.77 | 288.0 |
| 2023-08-11 05:40:00 | AAPL | Stock | 177.68 | 177.68 | 177.68 | 177.68 | 250.0 |
| 2023-08-11 05:41:00 | AAPL | Stock | 177.8 | 177.8 | 177.8 | 177.8 | 300.0 |
| 2023-08-11 05:49:00 | AAPL | Stock | 177.75 | 177.75 | 177.74 | 177.74 | 1060.0 |
| 2023-08-11 05:51:00 | AAPL | Stock | 177.67 | 177.67 | 177.52 | 177.52 | 312.0 |
| 2023-08-11 05:53:00 | AAPL | Stock | 177.45 | 177.46 | 177.4 | 177.4 | 1479.0 |
| 2023-08-11 05:54:00 | AAPL | Stock | 177.4 | 177.4 | 177.4 | 177.4 | 144.0 |
| 2023-08-11 05:55:00 | AAPL | Stock | 177.38 | 177.38 | 177.38 | 177.38 | 399.0 |
| 2023-08-11 05:57:00 | AAPL | Stock | 177.39 | 177.39 | 177.37 | 177.37 | 405.0 |
| 2023-08-11 05:59:00 | AAPL | Stock | 177.46 | 177.58 | 177.46 | 177.58 | 1208.0 |
| 2023-08-11 06:02:00 | AAPL | Stock | 177.62 | 177.62 | 177.62 | 177.62 | 352.0 |
| 2023-08-11 06:03:00 | AAPL | Stock | 177.62 | 177.62 | 177.62 | 177.62 | 523.0 |
| 2023-08-11 06:06:00 | AAPL | Stock | 177.53 | 177.57 | 177.53 | 177.57 | 1041.0 |
| 2023-08-11 06:07:00 | AAPL | Stock | 177.56 | 177.56 | 177.56 | 177.56 | 373.0 |
> showing 50 of 1,219,699 rows — these rows as CSV