PREVIEW / stock_5min / 2023-07-17
file: by_date/stock_5min/2023/2023-07-17.parquet size: 6.7 MB rows: 408,692 symbols: 1,541
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-07-17 04:00:00 | AAPL | Stock | 190.67 | 190.79 | 190.65 | 190.79 | 2225.0 |
| 2023-07-17 04:05:00 | AAPL | Stock | 190.8 | 190.85 | 190.74 | 190.76 | 892.0 |
| 2023-07-17 04:10:00 | AAPL | Stock | 190.85 | 190.94 | 190.85 | 190.94 | 2083.0 |
| 2023-07-17 04:15:00 | AAPL | Stock | 190.99 | 191.0 | 190.96 | 190.98 | 2586.0 |
| 2023-07-17 04:20:00 | AAPL | Stock | 190.97 | 190.99 | 190.97 | 190.99 | 1408.0 |
| 2023-07-17 04:25:00 | AAPL | Stock | 190.99 | 191.0 | 190.99 | 191.0 | 816.0 |
| 2023-07-17 04:30:00 | AAPL | Stock | 190.98 | 191.0 | 190.98 | 191.0 | 3730.0 |
| 2023-07-17 04:35:00 | AAPL | Stock | 191.0 | 191.0 | 190.99 | 190.99 | 592.0 |
| 2023-07-17 04:40:00 | AAPL | Stock | 190.92 | 190.93 | 190.89 | 190.91 | 1344.0 |
| 2023-07-17 04:45:00 | AAPL | Stock | 190.93 | 190.93 | 190.85 | 190.91 | 507.0 |
| 2023-07-17 04:50:00 | AAPL | Stock | 190.91 | 190.91 | 190.9 | 190.9 | 482.0 |
| 2023-07-17 04:55:00 | AAPL | Stock | 190.9 | 190.9 | 190.9 | 190.9 | 170.0 |
| 2023-07-17 05:05:00 | AAPL | Stock | 190.83 | 190.83 | 190.71 | 190.71 | 1806.0 |
| 2023-07-17 05:10:00 | AAPL | Stock | 190.72 | 190.72 | 190.72 | 190.72 | 200.0 |
| 2023-07-17 05:20:00 | AAPL | Stock | 190.84 | 190.95 | 190.84 | 190.94 | 1872.0 |
| 2023-07-17 05:25:00 | AAPL | Stock | 190.93 | 191.0 | 190.93 | 190.96 | 3132.0 |
| 2023-07-17 05:30:00 | AAPL | Stock | 190.99 | 190.99 | 190.99 | 190.99 | 103.0 |
| 2023-07-17 05:40:00 | AAPL | Stock | 191.0 | 191.0 | 190.94 | 190.94 | 3853.0 |
| 2023-07-17 05:50:00 | AAPL | Stock | 190.8 | 190.88 | 190.8 | 190.8 | 936.0 |
| 2023-07-17 05:55:00 | AAPL | Stock | 190.77 | 190.78 | 190.77 | 190.78 | 1330.0 |
| 2023-07-17 06:05:00 | AAPL | Stock | 190.96 | 190.97 | 190.84 | 190.84 | 485.0 |
| 2023-07-17 06:15:00 | AAPL | Stock | 190.88 | 190.88 | 190.78 | 190.88 | 724.0 |
| 2023-07-17 06:20:00 | AAPL | Stock | 190.88 | 190.88 | 190.88 | 190.88 | 417.0 |
| 2023-07-17 06:25:00 | AAPL | Stock | 190.84 | 190.85 | 190.84 | 190.85 | 209.0 |
| 2023-07-17 06:30:00 | AAPL | Stock | 190.84 | 190.94 | 190.84 | 190.94 | 1049.0 |
| 2023-07-17 06:35:00 | AAPL | Stock | 190.83 | 190.83 | 190.76 | 190.76 | 864.0 |
| 2023-07-17 06:40:00 | AAPL | Stock | 190.78 | 190.86 | 190.78 | 190.86 | 203.0 |
| 2023-07-17 06:45:00 | AAPL | Stock | 190.86 | 191.0 | 190.86 | 190.9 | 3848.0 |
| 2023-07-17 06:50:00 | AAPL | Stock | 190.93 | 190.93 | 190.86 | 190.86 | 1075.0 |
| 2023-07-17 06:55:00 | AAPL | Stock | 190.86 | 190.86 | 190.86 | 190.86 | 1878.0 |
| 2023-07-17 07:00:00 | AAPL | Stock | 190.86 | 190.92 | 190.86 | 190.86 | 2643.0 |
| 2023-07-17 07:05:00 | AAPL | Stock | 190.91 | 191.0 | 190.91 | 191.0 | 6128.0 |
| 2023-07-17 07:10:00 | AAPL | Stock | 190.94 | 190.99 | 190.94 | 190.99 | 1008.0 |
| 2023-07-17 07:15:00 | AAPL | Stock | 190.95 | 191.0 | 190.91 | 191.0 | 4262.0 |
| 2023-07-17 07:20:00 | AAPL | Stock | 190.99 | 191.05 | 190.94 | 190.94 | 23463.0 |
| 2023-07-17 07:25:00 | AAPL | Stock | 190.9 | 191.03 | 190.9 | 191.03 | 6401.0 |
| 2023-07-17 07:30:00 | AAPL | Stock | 191.0 | 191.04 | 191.0 | 191.0 | 1730.0 |
| 2023-07-17 07:35:00 | AAPL | Stock | 191.0 | 191.01 | 190.97 | 190.97 | 1630.0 |
| 2023-07-17 07:40:00 | AAPL | Stock | 190.98 | 191.06 | 190.95 | 191.06 | 6227.0 |
| 2023-07-17 07:45:00 | AAPL | Stock | 191.03 | 191.13 | 191.02 | 191.06 | 7010.0 |
| 2023-07-17 07:50:00 | AAPL | Stock | 191.1 | 191.13 | 190.99 | 191.12 | 13000.0 |
| 2023-07-17 07:55:00 | AAPL | Stock | 191.16 | 191.25 | 191.15 | 191.2 | 5871.0 |
| 2023-07-17 08:00:00 | AAPL | Stock | 190.8996 | 191.61 | 190.22 | 191.56 | 82219.0 |
| 2023-07-17 08:05:00 | AAPL | Stock | 191.5 | 191.52 | 190.9 | 191.1199 | 62485.0 |
| 2023-07-17 08:10:00 | AAPL | Stock | 191.09 | 191.36 | 191.09 | 191.296 | 15199.0 |
| 2023-07-17 08:15:00 | AAPL | Stock | 191.3 | 191.45 | 191.3 | 191.34 | 7992.0 |
| 2023-07-17 08:20:00 | AAPL | Stock | 191.39 | 191.3984 | 191.28 | 191.3501 | 6978.0 |
| 2023-07-17 08:25:00 | AAPL | Stock | 191.38 | 191.4398 | 191.29 | 191.36 | 5582.0 |
| 2023-07-17 08:30:00 | AAPL | Stock | 191.29 | 191.4 | 191.27 | 191.37 | 10828.0 |
| 2023-07-17 08:35:00 | AAPL | Stock | 191.37 | 191.37 | 191.23 | 191.24 | 9797.0 |
> showing 50 of 408,692 rows — these rows as CSV