PREVIEW / stock_1min / 2023-04-21
file: by_date/stock_1min/2023/2023-04-21.parquet size: 19.6 MB rows: 1,208,400 symbols: 1,562
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-04-21 04:00:00 | AAPL | Stock | 166.68 | 166.68 | 166.63 | 166.66 | 602.0 |
| 2023-04-21 04:01:00 | AAPL | Stock | 166.6 | 166.6 | 166.6 | 166.6 | 200.0 |
| 2023-04-21 04:02:00 | AAPL | Stock | 166.58 | 166.58 | 166.58 | 166.58 | 261.0 |
| 2023-04-21 04:03:00 | AAPL | Stock | 166.59 | 166.6 | 166.58 | 166.59 | 1159.0 |
| 2023-04-21 04:04:00 | AAPL | Stock | 166.6 | 166.6 | 166.58 | 166.58 | 287.0 |
| 2023-04-21 04:05:00 | AAPL | Stock | 166.53 | 166.56 | 166.5 | 166.56 | 741.0 |
| 2023-04-21 04:07:00 | AAPL | Stock | 166.53 | 166.53 | 166.5 | 166.5 | 1180.0 |
| 2023-04-21 04:08:00 | AAPL | Stock | 166.56 | 166.56 | 166.56 | 166.56 | 100.0 |
| 2023-04-21 04:15:00 | AAPL | Stock | 166.43 | 166.43 | 166.33 | 166.33 | 450.0 |
| 2023-04-21 04:25:00 | AAPL | Stock | 166.45 | 166.45 | 166.43 | 166.43 | 507.0 |
| 2023-04-21 04:27:00 | AAPL | Stock | 166.4 | 166.4 | 166.33 | 166.33 | 220.0 |
| 2023-04-21 04:29:00 | AAPL | Stock | 166.34 | 166.34 | 166.34 | 166.34 | 100.0 |
| 2023-04-21 04:30:00 | AAPL | Stock | 166.32 | 166.32 | 166.32 | 166.32 | 199.0 |
| 2023-04-21 04:33:00 | AAPL | Stock | 166.32 | 166.32 | 166.32 | 166.32 | 100.0 |
| 2023-04-21 04:40:00 | AAPL | Stock | 166.4 | 166.4 | 166.4 | 166.4 | 250.0 |
| 2023-04-21 04:46:00 | AAPL | Stock | 166.5 | 166.6 | 166.5 | 166.6 | 1463.0 |
| 2023-04-21 04:56:00 | AAPL | Stock | 166.58 | 166.58 | 166.58 | 166.58 | 450.0 |
| 2023-04-21 05:01:00 | AAPL | Stock | 166.6 | 166.6 | 166.6 | 166.6 | 233.0 |
| 2023-04-21 05:05:00 | AAPL | Stock | 166.5 | 166.5 | 166.5 | 166.5 | 400.0 |
| 2023-04-21 05:17:00 | AAPL | Stock | 166.56 | 166.56 | 166.56 | 166.56 | 300.0 |
| 2023-04-21 05:30:00 | AAPL | Stock | 166.55 | 166.55 | 166.55 | 166.55 | 329.0 |
| 2023-04-21 05:33:00 | AAPL | Stock | 166.52 | 166.52 | 166.52 | 166.52 | 366.0 |
| 2023-04-21 05:40:00 | AAPL | Stock | 166.65 | 166.65 | 166.65 | 166.65 | 100.0 |
| 2023-04-21 05:42:00 | AAPL | Stock | 166.65 | 166.66 | 166.65 | 166.66 | 359.0 |
| 2023-04-21 05:54:00 | AAPL | Stock | 166.61 | 166.61 | 166.61 | 166.61 | 624.0 |
| 2023-04-21 06:04:00 | AAPL | Stock | 166.57 | 166.57 | 166.57 | 166.57 | 200.0 |
| 2023-04-21 06:10:00 | AAPL | Stock | 166.55 | 166.55 | 166.55 | 166.55 | 100.0 |
| 2023-04-21 06:26:00 | AAPL | Stock | 166.47 | 166.47 | 166.47 | 166.47 | 100.0 |
| 2023-04-21 06:28:00 | AAPL | Stock | 166.38 | 166.38 | 166.37 | 166.37 | 745.0 |
| 2023-04-21 06:29:00 | AAPL | Stock | 166.38 | 166.38 | 166.38 | 166.38 | 166.0 |
| 2023-04-21 06:30:00 | AAPL | Stock | 166.38 | 166.38 | 165.61 | 165.61 | 23538.0 |
| 2023-04-21 06:31:00 | AAPL | Stock | 165.61 | 165.7 | 165.38 | 165.48 | 13857.0 |
| 2023-04-21 06:32:00 | AAPL | Stock | 165.52 | 165.52 | 164.66 | 164.73 | 14944.0 |
| 2023-04-21 06:33:00 | AAPL | Stock | 164.72 | 164.73 | 164.4 | 164.58 | 9219.0 |
| 2023-04-21 06:34:00 | AAPL | Stock | 164.51 | 164.58 | 163.9 | 164.27 | 15181.0 |
| 2023-04-21 06:35:00 | AAPL | Stock | 164.2 | 164.2 | 163.95 | 163.95 | 7197.0 |
| 2023-04-21 06:36:00 | AAPL | Stock | 163.95 | 163.95 | 163.67 | 163.91 | 4939.0 |
| 2023-04-21 06:37:00 | AAPL | Stock | 163.95 | 164.0 | 163.7 | 163.88 | 14383.0 |
| 2023-04-21 06:38:00 | AAPL | Stock | 163.8 | 163.95 | 163.8 | 163.95 | 5384.0 |
| 2023-04-21 06:39:00 | AAPL | Stock | 163.9 | 163.9 | 163.35 | 163.35 | 15278.0 |
| 2023-04-21 06:40:00 | AAPL | Stock | 163.77 | 163.83 | 162.99 | 163.0 | 22081.0 |
| 2023-04-21 06:41:00 | AAPL | Stock | 163.29 | 163.29 | 163.29 | 163.29 | 200.0 |
| 2023-04-21 06:42:00 | AAPL | Stock | 163.48 | 163.68 | 163.26 | 163.68 | 16318.0 |
| 2023-04-21 06:43:00 | AAPL | Stock | 163.57 | 164.25 | 163.57 | 164.17 | 2403.0 |
| 2023-04-21 06:44:00 | AAPL | Stock | 164.17 | 164.18 | 163.71 | 163.71 | 3562.0 |
| 2023-04-21 06:45:00 | AAPL | Stock | 163.7 | 163.82 | 163.7 | 163.82 | 438.0 |
| 2023-04-21 06:46:00 | AAPL | Stock | 163.99 | 164.0 | 163.99 | 164.0 | 4025.0 |
| 2023-04-21 06:47:00 | AAPL | Stock | 163.99 | 164.0 | 163.98 | 163.98 | 1996.0 |
| 2023-04-21 06:48:00 | AAPL | Stock | 163.87 | 163.92 | 163.85 | 163.92 | 5329.0 |
| 2023-04-21 06:49:00 | AAPL | Stock | 163.91 | 163.91 | 163.86 | 163.86 | 200.0 |
> showing 50 of 1,208,400 rows — these rows as CSV