PREVIEW / stock_1min / 2024-07-19
file: by_date/stock_1min/2024/2024-07-19.parquet size: 18.3 MB rows: 1,175,819 symbols: 882
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-07-19 04:00:00 | AAPL | Stock | 224.13 | 224.18 | 224.0 | 224.18 | 1562.0 |
| 2024-07-19 04:03:00 | AAPL | Stock | 223.93 | 223.93 | 223.93 | 223.93 | 350.0 |
| 2024-07-19 04:04:00 | AAPL | Stock | 224.14 | 224.14 | 224.14 | 224.14 | 100.0 |
| 2024-07-19 04:05:00 | AAPL | Stock | 224.16 | 224.16 | 224.16 | 224.16 | 100.0 |
| 2024-07-19 04:06:00 | AAPL | Stock | 224.13 | 224.16 | 224.13 | 224.16 | 3037.0 |
| 2024-07-19 04:07:00 | AAPL | Stock | 224.19 | 224.19 | 224.19 | 224.19 | 202.0 |
| 2024-07-19 04:08:00 | AAPL | Stock | 224.2 | 224.2 | 224.2 | 224.2 | 330.0 |
| 2024-07-19 04:09:00 | AAPL | Stock | 224.15 | 224.15 | 224.14 | 224.14 | 642.0 |
| 2024-07-19 04:10:00 | AAPL | Stock | 224.14 | 224.14 | 224.14 | 224.14 | 178.0 |
| 2024-07-19 04:11:00 | AAPL | Stock | 224.15 | 224.15 | 224.15 | 224.15 | 191.0 |
| 2024-07-19 04:13:00 | AAPL | Stock | 224.17 | 224.17 | 224.15 | 224.15 | 400.0 |
| 2024-07-19 04:14:00 | AAPL | Stock | 224.01 | 224.01 | 224.01 | 224.01 | 330.0 |
| 2024-07-19 04:15:00 | AAPL | Stock | 224.0 | 224.01 | 223.9 | 223.9 | 3904.0 |
| 2024-07-19 04:16:00 | AAPL | Stock | 223.9 | 223.9 | 223.9 | 223.9 | 1718.0 |
| 2024-07-19 04:17:00 | AAPL | Stock | 223.7 | 223.7 | 223.7 | 223.7 | 100.0 |
| 2024-07-19 04:18:00 | AAPL | Stock | 223.6 | 223.6 | 223.3 | 223.3 | 878.0 |
| 2024-07-19 04:19:00 | AAPL | Stock | 223.22 | 223.22 | 223.19 | 223.19 | 724.0 |
| 2024-07-19 04:20:00 | AAPL | Stock | 223.2 | 223.2 | 223.0 | 223.0 | 1267.0 |
| 2024-07-19 04:21:00 | AAPL | Stock | 222.65 | 222.65 | 222.65 | 222.65 | 200.0 |
| 2024-07-19 04:22:00 | AAPL | Stock | 222.5 | 222.5 | 222.0 | 222.0 | 3219.0 |
| 2024-07-19 04:23:00 | AAPL | Stock | 222.02 | 222.3 | 222.0 | 222.19 | 1417.0 |
| 2024-07-19 04:24:00 | AAPL | Stock | 222.3 | 222.3 | 222.01 | 222.18 | 3006.0 |
| 2024-07-19 04:26:00 | AAPL | Stock | 222.36 | 222.36 | 222.31 | 222.33 | 1760.0 |
| 2024-07-19 04:27:00 | AAPL | Stock | 222.33 | 222.43 | 222.17 | 222.18 | 1895.0 |
| 2024-07-19 04:28:00 | AAPL | Stock | 222.35 | 222.68 | 222.35 | 222.61 | 4364.0 |
| 2024-07-19 04:29:00 | AAPL | Stock | 222.63 | 222.71 | 222.6 | 222.7 | 1090.0 |
| 2024-07-19 04:30:00 | AAPL | Stock | 222.64 | 222.64 | 222.62 | 222.62 | 300.0 |
| 2024-07-19 04:31:00 | AAPL | Stock | 222.76 | 222.8 | 222.76 | 222.8 | 659.0 |
| 2024-07-19 04:32:00 | AAPL | Stock | 222.79 | 222.79 | 222.74 | 222.75 | 410.0 |
| 2024-07-19 04:35:00 | AAPL | Stock | 222.84 | 222.84 | 222.84 | 222.84 | 200.0 |
| 2024-07-19 04:36:00 | AAPL | Stock | 222.85 | 222.85 | 222.8 | 222.8 | 1152.0 |
| 2024-07-19 04:37:00 | AAPL | Stock | 222.99 | 222.99 | 222.99 | 222.99 | 330.0 |
| 2024-07-19 04:38:00 | AAPL | Stock | 223.1 | 223.2 | 223.1 | 223.2 | 452.0 |
| 2024-07-19 04:39:00 | AAPL | Stock | 223.07 | 223.18 | 223.06 | 223.18 | 1874.0 |
| 2024-07-19 04:42:00 | AAPL | Stock | 223.05 | 223.06 | 223.04 | 223.06 | 490.0 |
| 2024-07-19 04:47:00 | AAPL | Stock | 223.13 | 223.18 | 223.0 | 223.0 | 1423.0 |
| 2024-07-19 04:48:00 | AAPL | Stock | 223.0 | 223.0 | 223.0 | 223.0 | 360.0 |
| 2024-07-19 04:51:00 | AAPL | Stock | 223.0 | 223.0 | 223.0 | 223.0 | 829.0 |
| 2024-07-19 04:54:00 | AAPL | Stock | 222.92 | 222.92 | 222.92 | 222.92 | 100.0 |
| 2024-07-19 04:55:00 | AAPL | Stock | 223.0 | 223.0 | 223.0 | 223.0 | 100.0 |
| 2024-07-19 04:56:00 | AAPL | Stock | 223.0 | 223.0 | 223.0 | 223.0 | 440.0 |
| 2024-07-19 04:58:00 | AAPL | Stock | 223.0 | 223.0 | 223.0 | 223.0 | 120.0 |
| 2024-07-19 04:59:00 | AAPL | Stock | 223.0 | 223.0 | 223.0 | 223.0 | 653.0 |
| 2024-07-19 05:01:00 | AAPL | Stock | 222.93 | 222.93 | 222.91 | 222.91 | 260.0 |
| 2024-07-19 05:02:00 | AAPL | Stock | 223.25 | 223.67 | 223.25 | 223.55 | 920.0 |
| 2024-07-19 05:03:00 | AAPL | Stock | 223.46 | 223.46 | 223.46 | 223.46 | 1713.0 |
| 2024-07-19 05:05:00 | AAPL | Stock | 223.29 | 223.32 | 223.2 | 223.32 | 1117.0 |
| 2024-07-19 05:06:00 | AAPL | Stock | 223.35 | 223.35 | 223.35 | 223.35 | 400.0 |
| 2024-07-19 05:07:00 | AAPL | Stock | 223.56 | 223.57 | 223.37 | 223.37 | 1640.0 |
| 2024-07-19 05:09:00 | AAPL | Stock | 223.37 | 223.37 | 223.37 | 223.37 | 120.0 |
> showing 50 of 1,175,819 rows — these rows as CSV