PREVIEW / stock_1min / 2024-08-12
file: by_date/stock_1min/2024/2024-08-12.parquet size: 19.3 MB rows: 1,196,702 symbols: 854
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-08-12 04:00:00 | AAPL | Stock | 216.77 | 217.01 | 216.5 | 216.5 | 1663.0 |
| 2024-08-12 04:01:00 | AAPL | Stock | 216.4 | 216.42 | 216.38 | 216.42 | 1487.0 |
| 2024-08-12 04:02:00 | AAPL | Stock | 216.69 | 216.69 | 216.69 | 216.69 | 147.0 |
| 2024-08-12 04:03:00 | AAPL | Stock | 216.5 | 216.5 | 216.3 | 216.3 | 1099.0 |
| 2024-08-12 04:05:00 | AAPL | Stock | 216.82 | 216.96 | 216.82 | 216.9 | 1310.0 |
| 2024-08-12 04:07:00 | AAPL | Stock | 217.01 | 217.01 | 217.0 | 217.0 | 251.0 |
| 2024-08-12 04:08:00 | AAPL | Stock | 216.97 | 216.97 | 216.97 | 216.97 | 100.0 |
| 2024-08-12 04:09:00 | AAPL | Stock | 216.9 | 216.9 | 216.9 | 216.9 | 100.0 |
| 2024-08-12 04:10:00 | AAPL | Stock | 216.88 | 216.88 | 216.86 | 216.86 | 227.0 |
| 2024-08-12 04:12:00 | AAPL | Stock | 216.9 | 216.9 | 216.9 | 216.9 | 123.0 |
| 2024-08-12 04:17:00 | AAPL | Stock | 216.68 | 216.68 | 216.68 | 216.68 | 100.0 |
| 2024-08-12 04:18:00 | AAPL | Stock | 216.6 | 216.6 | 216.6 | 216.6 | 100.0 |
| 2024-08-12 04:20:00 | AAPL | Stock | 216.63 | 216.63 | 216.63 | 216.63 | 100.0 |
| 2024-08-12 04:27:00 | AAPL | Stock | 216.92 | 216.92 | 216.87 | 216.87 | 200.0 |
| 2024-08-12 04:28:00 | AAPL | Stock | 216.77 | 216.77 | 216.77 | 216.77 | 100.0 |
| 2024-08-12 04:31:00 | AAPL | Stock | 216.75 | 216.75 | 216.75 | 216.75 | 100.0 |
| 2024-08-12 04:36:00 | AAPL | Stock | 216.72 | 216.73 | 216.72 | 216.72 | 1104.0 |
| 2024-08-12 04:37:00 | AAPL | Stock | 216.68 | 216.68 | 216.62 | 216.62 | 612.0 |
| 2024-08-12 04:38:00 | AAPL | Stock | 216.64 | 216.7 | 216.64 | 216.7 | 200.0 |
| 2024-08-12 04:45:00 | AAPL | Stock | 216.66 | 216.66 | 216.66 | 216.66 | 100.0 |
| 2024-08-12 04:46:00 | AAPL | Stock | 216.62 | 216.62 | 216.62 | 216.62 | 243.0 |
| 2024-08-12 04:50:00 | AAPL | Stock | 216.66 | 216.68 | 216.66 | 216.68 | 5804.0 |
| 2024-08-12 04:57:00 | AAPL | Stock | 216.72 | 216.72 | 216.72 | 216.72 | 100.0 |
| 2024-08-12 04:58:00 | AAPL | Stock | 216.7 | 216.7 | 216.7 | 216.7 | 200.0 |
| 2024-08-12 05:09:00 | AAPL | Stock | 216.79 | 216.79 | 216.79 | 216.79 | 100.0 |
| 2024-08-12 05:10:00 | AAPL | Stock | 216.85 | 216.85 | 216.8 | 216.8 | 888.0 |
| 2024-08-12 05:17:00 | AAPL | Stock | 216.83 | 216.83 | 216.83 | 216.83 | 100.0 |
| 2024-08-12 05:23:00 | AAPL | Stock | 216.75 | 216.75 | 216.75 | 216.75 | 100.0 |
| 2024-08-12 05:24:00 | AAPL | Stock | 216.78 | 216.8 | 216.78 | 216.8 | 431.0 |
| 2024-08-12 05:27:00 | AAPL | Stock | 216.81 | 216.81 | 216.76 | 216.76 | 300.0 |
| 2024-08-12 05:33:00 | AAPL | Stock | 216.83 | 216.83 | 216.83 | 216.83 | 258.0 |
| 2024-08-12 05:36:00 | AAPL | Stock | 216.83 | 216.83 | 216.83 | 216.83 | 100.0 |
| 2024-08-12 05:38:00 | AAPL | Stock | 216.83 | 216.83 | 216.83 | 216.83 | 140.0 |
| 2024-08-12 05:40:00 | AAPL | Stock | 216.86 | 216.86 | 216.86 | 216.86 | 100.0 |
| 2024-08-12 05:41:00 | AAPL | Stock | 216.94 | 216.94 | 216.94 | 216.94 | 100.0 |
| 2024-08-12 05:44:00 | AAPL | Stock | 216.9 | 216.9 | 216.9 | 216.9 | 100.0 |
| 2024-08-12 05:45:00 | AAPL | Stock | 216.9 | 216.94 | 216.9 | 216.94 | 200.0 |
| 2024-08-12 05:47:00 | AAPL | Stock | 216.94 | 216.94 | 216.9 | 216.9 | 592.0 |
| 2024-08-12 05:48:00 | AAPL | Stock | 216.8 | 216.8 | 216.8 | 216.8 | 100.0 |
| 2024-08-12 05:53:00 | AAPL | Stock | 216.86 | 216.86 | 216.86 | 216.86 | 100.0 |
| 2024-08-12 05:55:00 | AAPL | Stock | 216.87 | 216.87 | 216.87 | 216.87 | 150.0 |
| 2024-08-12 05:57:00 | AAPL | Stock | 216.88 | 216.88 | 216.87 | 216.87 | 569.0 |
| 2024-08-12 05:58:00 | AAPL | Stock | 216.92 | 216.92 | 216.92 | 216.92 | 100.0 |
| 2024-08-12 06:01:00 | AAPL | Stock | 216.9 | 216.9 | 216.9 | 216.9 | 100.0 |
| 2024-08-12 06:02:00 | AAPL | Stock | 216.85 | 216.85 | 216.85 | 216.85 | 1400.0 |
| 2024-08-12 06:05:00 | AAPL | Stock | 216.77 | 216.9 | 216.76 | 216.9 | 1290.0 |
| 2024-08-12 06:11:00 | AAPL | Stock | 216.85 | 216.85 | 216.75 | 216.75 | 800.0 |
| 2024-08-12 06:12:00 | AAPL | Stock | 216.75 | 216.76 | 216.75 | 216.76 | 300.0 |
| 2024-08-12 06:13:00 | AAPL | Stock | 216.71 | 216.71 | 216.69 | 216.7 | 596.0 |
| 2024-08-12 06:15:00 | AAPL | Stock | 216.75 | 216.75 | 216.75 | 216.75 | 100.0 |
> showing 50 of 1,196,702 rows — these rows as CSV