PREVIEW / stock_1min / 2021-10-25
file: by_date/stock_1min/2021/2021-10-25.parquet size: 24.4 MB rows: 1,391,017 symbols: 2,328
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-25 04:00:00 | AAPL | Stock | 148.5 | 148.57 | 148.45 | 148.57 | 2300.0 |
| 2021-10-25 04:01:00 | AAPL | Stock | 148.6 | 148.6 | 148.58 | 148.58 | 600.0 |
| 2021-10-25 04:02:00 | AAPL | Stock | 148.7 | 148.7 | 148.7 | 148.7 | 181.0 |
| 2021-10-25 04:03:00 | AAPL | Stock | 148.68 | 148.68 | 148.68 | 148.68 | 100.0 |
| 2021-10-25 04:05:00 | AAPL | Stock | 148.85 | 148.85 | 148.85 | 148.85 | 126.0 |
| 2021-10-25 04:08:00 | AAPL | Stock | 148.81 | 148.81 | 148.81 | 148.81 | 186.0 |
| 2021-10-25 04:09:00 | AAPL | Stock | 148.81 | 148.83 | 148.8 | 148.81 | 1000.0 |
| 2021-10-25 04:10:00 | AAPL | Stock | 148.81 | 148.83 | 148.8 | 148.8 | 300.0 |
| 2021-10-25 04:12:00 | AAPL | Stock | 148.79 | 148.82 | 148.79 | 148.82 | 1000.0 |
| 2021-10-25 04:14:00 | AAPL | Stock | 148.81 | 148.81 | 148.76 | 148.76 | 308.0 |
| 2021-10-25 04:15:00 | AAPL | Stock | 148.75 | 148.75 | 148.75 | 148.75 | 702.0 |
| 2021-10-25 04:16:00 | AAPL | Stock | 148.71 | 148.71 | 148.69 | 148.7 | 1650.0 |
| 2021-10-25 04:17:00 | AAPL | Stock | 148.66 | 148.66 | 148.64 | 148.64 | 325.0 |
| 2021-10-25 04:18:00 | AAPL | Stock | 148.72 | 148.72 | 148.72 | 148.72 | 200.0 |
| 2021-10-25 04:19:00 | AAPL | Stock | 148.7 | 148.7 | 148.7 | 148.7 | 150.0 |
| 2021-10-25 04:21:00 | AAPL | Stock | 148.68 | 148.7 | 148.68 | 148.7 | 395.0 |
| 2021-10-25 04:22:00 | AAPL | Stock | 148.7 | 148.7 | 148.7 | 148.7 | 907.0 |
| 2021-10-25 04:23:00 | AAPL | Stock | 148.74 | 148.74 | 148.65 | 148.65 | 348.0 |
| 2021-10-25 04:25:00 | AAPL | Stock | 148.7 | 148.7 | 148.7 | 148.7 | 100.0 |
| 2021-10-25 04:28:00 | AAPL | Stock | 148.71 | 148.71 | 148.69 | 148.69 | 3009.0 |
| 2021-10-25 04:34:00 | AAPL | Stock | 148.7 | 148.7 | 148.7 | 148.7 | 200.0 |
| 2021-10-25 04:37:00 | AAPL | Stock | 148.62 | 148.65 | 148.62 | 148.65 | 413.0 |
| 2021-10-25 04:39:00 | AAPL | Stock | 148.62 | 148.62 | 148.6 | 148.6 | 764.0 |
| 2021-10-25 04:40:00 | AAPL | Stock | 148.58 | 148.59 | 148.58 | 148.59 | 738.0 |
| 2021-10-25 04:45:00 | AAPL | Stock | 148.62 | 148.65 | 148.62 | 148.65 | 716.0 |
| 2021-10-25 04:46:00 | AAPL | Stock | 148.68 | 148.68 | 148.68 | 148.68 | 450.0 |
| 2021-10-25 04:47:00 | AAPL | Stock | 148.68 | 148.68 | 148.68 | 148.68 | 200.0 |
| 2021-10-25 04:55:00 | AAPL | Stock | 148.63 | 148.63 | 148.63 | 148.63 | 150.0 |
| 2021-10-25 04:58:00 | AAPL | Stock | 148.61 | 148.61 | 148.61 | 148.61 | 157.0 |
| 2021-10-25 05:02:00 | AAPL | Stock | 148.61 | 148.61 | 148.61 | 148.61 | 483.0 |
| 2021-10-25 05:05:00 | AAPL | Stock | 148.62 | 148.62 | 148.62 | 148.62 | 400.0 |
| 2021-10-25 05:06:00 | AAPL | Stock | 148.62 | 148.62 | 148.62 | 148.62 | 100.0 |
| 2021-10-25 05:08:00 | AAPL | Stock | 148.61 | 148.61 | 148.6 | 148.6 | 2209.0 |
| 2021-10-25 05:15:00 | AAPL | Stock | 148.55 | 148.55 | 148.55 | 148.55 | 540.0 |
| 2021-10-25 05:16:00 | AAPL | Stock | 148.55 | 148.55 | 148.55 | 148.55 | 552.0 |
| 2021-10-25 05:18:00 | AAPL | Stock | 148.52 | 148.52 | 148.52 | 148.52 | 374.0 |
| 2021-10-25 05:20:00 | AAPL | Stock | 148.5 | 148.51 | 148.47 | 148.51 | 2047.0 |
| 2021-10-25 05:21:00 | AAPL | Stock | 148.5 | 148.54 | 148.5 | 148.54 | 3151.0 |
| 2021-10-25 05:26:00 | AAPL | Stock | 148.5 | 148.5 | 148.5 | 148.5 | 1873.0 |
| 2021-10-25 05:27:00 | AAPL | Stock | 148.57 | 148.61 | 148.57 | 148.6 | 1365.0 |
| 2021-10-25 05:28:00 | AAPL | Stock | 148.6 | 148.6 | 148.5 | 148.5 | 1618.0 |
| 2021-10-25 05:30:00 | AAPL | Stock | 148.51 | 148.51 | 148.51 | 148.51 | 100.0 |
| 2021-10-25 05:33:00 | AAPL | Stock | 148.57 | 148.57 | 148.57 | 148.57 | 147.0 |
| 2021-10-25 05:41:00 | AAPL | Stock | 148.55 | 148.55 | 148.55 | 148.55 | 200.0 |
| 2021-10-25 05:44:00 | AAPL | Stock | 148.55 | 148.55 | 148.55 | 148.55 | 200.0 |
| 2021-10-25 05:54:00 | AAPL | Stock | 148.53 | 148.53 | 148.53 | 148.53 | 223.0 |
| 2021-10-25 05:55:00 | AAPL | Stock | 148.5 | 148.52 | 148.5 | 148.52 | 480.0 |
| 2021-10-25 06:00:00 | AAPL | Stock | 148.53 | 148.63 | 148.53 | 148.58 | 637.0 |
| 2021-10-25 06:02:00 | AAPL | Stock | 148.54 | 148.55 | 148.54 | 148.55 | 393.0 |
| 2021-10-25 06:03:00 | AAPL | Stock | 148.54 | 148.55 | 148.5 | 148.5 | 3666.0 |
> showing 50 of 1,391,017 rows — these rows as CSV