PREVIEW / stock_1min / 2024-06-28
file: by_date/stock_1min/2024/2024-06-28.parquet size: 20.3 MB rows: 1,290,113 symbols: 908
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 |
|---|---|---|---|---|---|---|---|
| 2024-06-28 04:00:00 | AAPL | Stock | 214.12 | 214.93 | 214.12 | 214.65 | 739.0 |
| 2024-06-28 04:01:00 | AAPL | Stock | 214.72 | 214.72 | 214.72 | 214.72 | 367.0 |
| 2024-06-28 04:02:00 | AAPL | Stock | 214.7 | 214.7 | 214.7 | 214.7 | 185.0 |
| 2024-06-28 04:03:00 | AAPL | Stock | 214.7 | 214.7 | 214.7 | 214.7 | 2559.0 |
| 2024-06-28 04:06:00 | AAPL | Stock | 214.62 | 214.62 | 214.62 | 214.62 | 100.0 |
| 2024-06-28 04:07:00 | AAPL | Stock | 214.57 | 214.57 | 214.57 | 214.57 | 100.0 |
| 2024-06-28 04:09:00 | AAPL | Stock | 214.61 | 214.62 | 214.61 | 214.62 | 700.0 |
| 2024-06-28 04:10:00 | AAPL | Stock | 214.65 | 214.65 | 214.65 | 214.65 | 100.0 |
| 2024-06-28 04:16:00 | AAPL | Stock | 214.61 | 214.61 | 214.59 | 214.61 | 1319.0 |
| 2024-06-28 04:44:00 | AAPL | Stock | 214.71 | 214.71 | 214.71 | 214.71 | 418.0 |
| 2024-06-28 04:45:00 | AAPL | Stock | 214.69 | 214.69 | 214.69 | 214.69 | 125.0 |
| 2024-06-28 05:02:00 | AAPL | Stock | 214.68 | 215.0 | 214.68 | 215.0 | 1571.0 |
| 2024-06-28 05:05:00 | AAPL | Stock | 215.18 | 215.18 | 215.16 | 215.16 | 238.0 |
| 2024-06-28 05:06:00 | AAPL | Stock | 215.16 | 215.16 | 215.16 | 215.16 | 100.0 |
| 2024-06-28 05:08:00 | AAPL | Stock | 215.16 | 215.26 | 215.16 | 215.26 | 320.0 |
| 2024-06-28 05:15:00 | AAPL | Stock | 215.19 | 215.2 | 215.19 | 215.2 | 1300.0 |
| 2024-06-28 05:17:00 | AAPL | Stock | 215.17 | 215.2 | 215.17 | 215.2 | 200.0 |
| 2024-06-28 05:18:00 | AAPL | Stock | 215.2 | 215.21 | 215.14 | 215.21 | 770.0 |
| 2024-06-28 05:19:00 | AAPL | Stock | 215.21 | 215.21 | 215.21 | 215.21 | 101.0 |
| 2024-06-28 05:21:00 | AAPL | Stock | 215.39 | 215.39 | 215.39 | 215.39 | 310.0 |
| 2024-06-28 05:22:00 | AAPL | Stock | 215.45 | 215.45 | 215.45 | 215.45 | 100.0 |
| 2024-06-28 05:23:00 | AAPL | Stock | 215.5 | 215.63 | 215.5 | 215.63 | 1090.0 |
| 2024-06-28 05:25:00 | AAPL | Stock | 215.59 | 215.59 | 215.5 | 215.5 | 300.0 |
| 2024-06-28 05:32:00 | AAPL | Stock | 215.4 | 215.4 | 215.4 | 215.4 | 100.0 |
| 2024-06-28 05:33:00 | AAPL | Stock | 215.35 | 215.36 | 215.35 | 215.36 | 350.0 |
| 2024-06-28 05:34:00 | AAPL | Stock | 215.25 | 215.25 | 215.25 | 215.25 | 500.0 |
| 2024-06-28 05:37:00 | AAPL | Stock | 215.3 | 215.5 | 215.3 | 215.5 | 3908.0 |
| 2024-06-28 05:39:00 | AAPL | Stock | 215.5 | 215.6 | 215.5 | 215.6 | 3222.0 |
| 2024-06-28 05:40:00 | AAPL | Stock | 215.6 | 215.6 | 215.6 | 215.6 | 2375.0 |
| 2024-06-28 05:41:00 | AAPL | Stock | 215.51 | 215.59 | 215.51 | 215.59 | 1209.0 |
| 2024-06-28 05:43:00 | AAPL | Stock | 215.65 | 215.69 | 215.6 | 215.6 | 693.0 |
| 2024-06-28 05:44:00 | AAPL | Stock | 215.6 | 215.6 | 215.6 | 215.6 | 1290.0 |
| 2024-06-28 05:45:00 | AAPL | Stock | 215.61 | 215.61 | 215.61 | 215.61 | 400.0 |
| 2024-06-28 05:46:00 | AAPL | Stock | 215.67 | 215.67 | 215.67 | 215.67 | 200.0 |
| 2024-06-28 05:47:00 | AAPL | Stock | 215.7 | 215.8 | 215.7 | 215.79 | 3023.0 |
| 2024-06-28 05:48:00 | AAPL | Stock | 215.81 | 215.84 | 215.81 | 215.84 | 998.0 |
| 2024-06-28 05:49:00 | AAPL | Stock | 215.9 | 215.9 | 215.9 | 215.9 | 100.0 |
| 2024-06-28 05:50:00 | AAPL | Stock | 216.0 | 216.0 | 215.96 | 216.0 | 1758.0 |
| 2024-06-28 05:51:00 | AAPL | Stock | 216.0 | 216.0 | 216.0 | 216.0 | 1150.0 |
| 2024-06-28 05:52:00 | AAPL | Stock | 216.0 | 216.0 | 216.0 | 216.0 | 800.0 |
| 2024-06-28 05:53:00 | AAPL | Stock | 216.0 | 216.37 | 216.0 | 216.37 | 2333.0 |
| 2024-06-28 05:54:00 | AAPL | Stock | 216.24 | 216.24 | 216.24 | 216.24 | 552.0 |
| 2024-06-28 05:55:00 | AAPL | Stock | 216.2 | 216.2 | 216.2 | 216.2 | 489.0 |
| 2024-06-28 05:56:00 | AAPL | Stock | 216.11 | 216.31 | 216.11 | 216.31 | 4127.0 |
| 2024-06-28 05:57:00 | AAPL | Stock | 216.2 | 216.2 | 216.12 | 216.2 | 5810.0 |
| 2024-06-28 05:58:00 | AAPL | Stock | 216.2 | 216.31 | 216.2 | 216.31 | 1504.0 |
| 2024-06-28 05:59:00 | AAPL | Stock | 216.3 | 216.32 | 216.3 | 216.32 | 4747.0 |
| 2024-06-28 06:00:00 | AAPL | Stock | 216.3 | 216.3 | 216.2 | 216.2 | 950.0 |
| 2024-06-28 06:01:00 | AAPL | Stock | 216.25 | 216.25 | 216.25 | 216.25 | 133.0 |
| 2024-06-28 06:03:00 | AAPL | Stock | 216.26 | 216.26 | 216.25 | 216.25 | 200.0 |
> showing 50 of 1,290,113 rows — these rows as CSV