PREVIEW / stock_1min / 2022-05-24
file: by_date/stock_1min/2022/2022-05-24.parquet size: 21.8 MB rows: 1,413,384 symbols: 2,119
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 |
|---|---|---|---|---|---|---|---|
| 2022-05-24 04:00:00 | AAPL | Stock | 140.69 | 141.0 | 139.9 | 140.42 | 4550.0 |
| 2022-05-24 04:01:00 | AAPL | Stock | 140.49 | 140.51 | 140.2 | 140.3 | 12786.0 |
| 2022-05-24 04:02:00 | AAPL | Stock | 140.33 | 140.36 | 140.32 | 140.36 | 450.0 |
| 2022-05-24 04:03:00 | AAPL | Stock | 140.36 | 140.39 | 140.25 | 140.25 | 3084.0 |
| 2022-05-24 04:04:00 | AAPL | Stock | 140.3 | 140.3 | 140.3 | 140.3 | 287.0 |
| 2022-05-24 04:05:00 | AAPL | Stock | 140.3 | 140.3 | 140.3 | 140.3 | 634.0 |
| 2022-05-24 04:06:00 | AAPL | Stock | 140.31 | 140.34 | 140.27 | 140.34 | 1683.0 |
| 2022-05-24 04:07:00 | AAPL | Stock | 140.33 | 140.33 | 140.3 | 140.31 | 1563.0 |
| 2022-05-24 04:09:00 | AAPL | Stock | 140.32 | 140.5 | 140.32 | 140.5 | 2350.0 |
| 2022-05-24 04:10:00 | AAPL | Stock | 140.5 | 140.76 | 140.5 | 140.76 | 3011.0 |
| 2022-05-24 04:11:00 | AAPL | Stock | 140.77 | 140.77 | 140.75 | 140.75 | 924.0 |
| 2022-05-24 04:13:00 | AAPL | Stock | 140.63 | 140.63 | 140.59 | 140.59 | 806.0 |
| 2022-05-24 04:14:00 | AAPL | Stock | 140.62 | 140.62 | 140.6 | 140.6 | 596.0 |
| 2022-05-24 04:15:00 | AAPL | Stock | 140.61 | 140.61 | 140.6 | 140.6 | 1016.0 |
| 2022-05-24 04:16:00 | AAPL | Stock | 140.57 | 140.57 | 140.57 | 140.57 | 659.0 |
| 2022-05-24 04:17:00 | AAPL | Stock | 140.6 | 140.6 | 140.41 | 140.41 | 1919.0 |
| 2022-05-24 04:18:00 | AAPL | Stock | 140.52 | 140.52 | 140.43 | 140.43 | 700.0 |
| 2022-05-24 04:19:00 | AAPL | Stock | 140.47 | 140.5 | 140.46 | 140.46 | 1475.0 |
| 2022-05-24 04:20:00 | AAPL | Stock | 140.5 | 140.58 | 140.42 | 140.42 | 5193.0 |
| 2022-05-24 04:21:00 | AAPL | Stock | 140.5 | 140.5 | 140.42 | 140.5 | 1704.0 |
| 2022-05-24 04:23:00 | AAPL | Stock | 140.57 | 140.6 | 140.57 | 140.6 | 400.0 |
| 2022-05-24 04:24:00 | AAPL | Stock | 140.6 | 140.6 | 140.6 | 140.6 | 714.0 |
| 2022-05-24 04:26:00 | AAPL | Stock | 140.64 | 140.64 | 140.64 | 140.64 | 100.0 |
| 2022-05-24 04:27:00 | AAPL | Stock | 140.54 | 140.54 | 140.54 | 140.54 | 195.0 |
| 2022-05-24 04:29:00 | AAPL | Stock | 140.65 | 140.7 | 140.65 | 140.7 | 1500.0 |
| 2022-05-24 04:31:00 | AAPL | Stock | 140.74 | 140.74 | 140.74 | 140.74 | 448.0 |
| 2022-05-24 04:32:00 | AAPL | Stock | 140.72 | 140.77 | 140.7 | 140.7 | 405.0 |
| 2022-05-24 04:33:00 | AAPL | Stock | 140.63 | 140.63 | 140.63 | 140.63 | 371.0 |
| 2022-05-24 04:34:00 | AAPL | Stock | 140.69 | 140.69 | 140.69 | 140.69 | 100.0 |
| 2022-05-24 04:35:00 | AAPL | Stock | 140.7 | 140.7 | 140.69 | 140.69 | 1171.0 |
| 2022-05-24 04:36:00 | AAPL | Stock | 140.59 | 140.59 | 140.55 | 140.55 | 1009.0 |
| 2022-05-24 04:38:00 | AAPL | Stock | 140.64 | 140.64 | 140.64 | 140.64 | 200.0 |
| 2022-05-24 04:41:00 | AAPL | Stock | 140.7 | 140.7 | 140.7 | 140.7 | 200.0 |
| 2022-05-24 04:42:00 | AAPL | Stock | 140.69 | 140.69 | 140.69 | 140.69 | 100.0 |
| 2022-05-24 04:43:00 | AAPL | Stock | 140.68 | 140.68 | 140.63 | 140.63 | 413.0 |
| 2022-05-24 04:45:00 | AAPL | Stock | 140.69 | 140.69 | 140.64 | 140.64 | 214.0 |
| 2022-05-24 04:46:00 | AAPL | Stock | 140.68 | 140.69 | 140.68 | 140.69 | 339.0 |
| 2022-05-24 04:50:00 | AAPL | Stock | 140.64 | 140.64 | 140.62 | 140.62 | 1369.0 |
| 2022-05-24 04:51:00 | AAPL | Stock | 140.6 | 140.6 | 140.59 | 140.6 | 1529.0 |
| 2022-05-24 04:52:00 | AAPL | Stock | 140.62 | 140.62 | 140.62 | 140.62 | 161.0 |
| 2022-05-24 04:53:00 | AAPL | Stock | 140.52 | 140.52 | 140.5 | 140.5 | 1279.0 |
| 2022-05-24 04:54:00 | AAPL | Stock | 140.41 | 140.41 | 140.41 | 140.41 | 100.0 |
| 2022-05-24 04:58:00 | AAPL | Stock | 140.41 | 140.41 | 140.41 | 140.41 | 200.0 |
| 2022-05-24 04:59:00 | AAPL | Stock | 140.42 | 140.48 | 140.41 | 140.43 | 1249.0 |
| 2022-05-24 05:01:00 | AAPL | Stock | 140.5 | 140.5 | 140.5 | 140.5 | 494.0 |
| 2022-05-24 05:06:00 | AAPL | Stock | 140.45 | 140.46 | 140.45 | 140.46 | 437.0 |
| 2022-05-24 05:14:00 | AAPL | Stock | 140.46 | 140.46 | 140.44 | 140.44 | 3291.0 |
| 2022-05-24 05:15:00 | AAPL | Stock | 140.46 | 140.46 | 140.46 | 140.46 | 100.0 |
| 2022-05-24 05:16:00 | AAPL | Stock | 140.46 | 140.46 | 140.46 | 140.46 | 136.0 |
| 2022-05-24 05:17:00 | AAPL | Stock | 140.46 | 140.46 | 140.46 | 140.46 | 156.0 |
> showing 50 of 1,413,384 rows — these rows as CSV