PREVIEW / stock_5min / 2023-09-20
file: by_date/stock_5min/2023/2023-09-20.parquet size: 6.3 MB rows: 383,225 symbols: 1,433
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-09-20 04:00:00 | AAPL | Stock | 178.98 | 178.99 | 178.85 | 178.85 | 1296.0 |
| 2023-09-20 04:05:00 | AAPL | Stock | 178.85 | 178.93 | 178.85 | 178.93 | 2077.0 |
| 2023-09-20 04:10:00 | AAPL | Stock | 178.97 | 179.0 | 178.97 | 179.0 | 1412.0 |
| 2023-09-20 04:15:00 | AAPL | Stock | 179.0 | 179.06 | 179.0 | 179.06 | 2564.0 |
| 2023-09-20 04:20:00 | AAPL | Stock | 179.16 | 179.16 | 179.16 | 179.16 | 112.0 |
| 2023-09-20 04:25:00 | AAPL | Stock | 179.2 | 179.2 | 179.2 | 179.2 | 233.0 |
| 2023-09-20 04:30:00 | AAPL | Stock | 179.19 | 179.23 | 179.19 | 179.23 | 673.0 |
| 2023-09-20 04:35:00 | AAPL | Stock | 179.28 | 179.29 | 179.27 | 179.27 | 408.0 |
| 2023-09-20 04:40:00 | AAPL | Stock | 179.26 | 179.27 | 179.23 | 179.27 | 2780.0 |
| 2023-09-20 04:45:00 | AAPL | Stock | 179.26 | 179.36 | 179.26 | 179.29 | 1016.0 |
| 2023-09-20 04:50:00 | AAPL | Stock | 179.28 | 179.29 | 179.28 | 179.29 | 1779.0 |
| 2023-09-20 05:00:00 | AAPL | Stock | 179.33 | 179.44 | 179.33 | 179.44 | 1261.0 |
| 2023-09-20 05:05:00 | AAPL | Stock | 179.45 | 179.45 | 179.45 | 179.45 | 100.0 |
| 2023-09-20 05:15:00 | AAPL | Stock | 179.28 | 179.28 | 179.28 | 179.28 | 100.0 |
| 2023-09-20 05:20:00 | AAPL | Stock | 179.3 | 179.3 | 179.28 | 179.28 | 300.0 |
| 2023-09-20 05:25:00 | AAPL | Stock | 179.25 | 179.25 | 179.25 | 179.25 | 100.0 |
| 2023-09-20 05:35:00 | AAPL | Stock | 179.25 | 179.3 | 179.25 | 179.3 | 684.0 |
| 2023-09-20 05:55:00 | AAPL | Stock | 179.35 | 179.38 | 179.34 | 179.35 | 3444.0 |
| 2023-09-20 06:00:00 | AAPL | Stock | 179.36 | 179.4 | 179.36 | 179.4 | 1220.0 |
| 2023-09-20 06:05:00 | AAPL | Stock | 179.25 | 179.25 | 179.24 | 179.24 | 1072.0 |
| 2023-09-20 06:10:00 | AAPL | Stock | 179.23 | 179.3 | 179.23 | 179.3 | 580.0 |
| 2023-09-20 06:15:00 | AAPL | Stock | 179.24 | 179.24 | 179.2 | 179.23 | 479.0 |
| 2023-09-20 06:20:00 | AAPL | Stock | 179.33 | 179.33 | 179.33 | 179.33 | 168.0 |
| 2023-09-20 06:25:00 | AAPL | Stock | 179.25 | 179.25 | 179.25 | 179.25 | 200.0 |
| 2023-09-20 06:30:00 | AAPL | Stock | 179.22 | 179.22 | 179.22 | 179.22 | 1496.0 |
| 2023-09-20 06:40:00 | AAPL | Stock | 179.21 | 179.25 | 179.16 | 179.25 | 2700.0 |
| 2023-09-20 06:45:00 | AAPL | Stock | 179.28 | 179.28 | 179.25 | 179.25 | 695.0 |
| 2023-09-20 06:50:00 | AAPL | Stock | 179.3 | 179.3 | 179.28 | 179.3 | 1514.0 |
| 2023-09-20 07:00:00 | AAPL | Stock | 179.25 | 179.35 | 179.25 | 179.35 | 2998.0 |
| 2023-09-20 07:05:00 | AAPL | Stock | 179.35 | 179.38 | 179.34 | 179.35 | 1095.0 |
| 2023-09-20 07:10:00 | AAPL | Stock | 179.39 | 179.39 | 178.85 | 178.85 | 20364.0 |
| 2023-09-20 07:15:00 | AAPL | Stock | 178.95 | 178.98 | 178.8 | 178.9 | 4373.0 |
| 2023-09-20 07:20:00 | AAPL | Stock | 178.99 | 179.0 | 178.75 | 178.75 | 11133.0 |
| 2023-09-20 07:25:00 | AAPL | Stock | 178.7 | 178.7 | 178.52 | 178.52 | 6216.0 |
| 2023-09-20 07:30:00 | AAPL | Stock | 178.59 | 178.75 | 178.56 | 178.75 | 3754.0 |
| 2023-09-20 07:35:00 | AAPL | Stock | 178.75 | 178.77 | 178.7 | 178.72 | 9968.0 |
| 2023-09-20 07:40:00 | AAPL | Stock | 178.76 | 178.76 | 178.74 | 178.75 | 3456.0 |
| 2023-09-20 07:45:00 | AAPL | Stock | 178.76 | 178.76 | 178.74 | 178.76 | 2288.0 |
| 2023-09-20 07:50:00 | AAPL | Stock | 178.76 | 178.76 | 178.73 | 178.73 | 3348.0 |
| 2023-09-20 07:55:00 | AAPL | Stock | 178.71 | 178.76 | 178.65 | 178.65 | 4344.0 |
| 2023-09-20 08:00:00 | AAPL | Stock | 179.32 | 179.38 | 178.31 | 178.705 | 58338.0 |
| 2023-09-20 08:05:00 | AAPL | Stock | 178.75 | 178.76 | 178.75 | 178.76 | 2242.0 |
| 2023-09-20 08:10:00 | AAPL | Stock | 178.75 | 178.76 | 178.62 | 178.64 | 6702.0 |
| 2023-09-20 08:15:00 | AAPL | Stock | 178.64 | 178.8089 | 178.62 | 178.76 | 8562.0 |
| 2023-09-20 08:20:00 | AAPL | Stock | 178.76 | 178.8 | 178.7136 | 178.76 | 11804.0 |
| 2023-09-20 08:25:00 | AAPL | Stock | 178.75 | 178.77 | 178.685 | 178.685 | 3880.0 |
| 2023-09-20 08:30:00 | AAPL | Stock | 178.71 | 178.98 | 178.67 | 178.97 | 19043.0 |
| 2023-09-20 08:35:00 | AAPL | Stock | 178.85 | 178.86 | 178.79 | 178.85 | 6205.0 |
| 2023-09-20 08:40:00 | AAPL | Stock | 178.8286 | 178.96 | 178.8 | 178.96 | 20451.0 |
| 2023-09-20 08:45:00 | AAPL | Stock | 178.9783 | 179.0986 | 178.911 | 179.07 | 14365.0 |
> showing 50 of 383,225 rows — these rows as CSV