PREVIEW / stock_5min / 2022-04-01
file: by_date/stock_5min/2022/2022-04-01.parquet size: 7.3 MB rows: 454,100 symbols: 2,494
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 |
|---|---|---|---|---|---|---|---|
| 2022-04-01 04:00:00 | AAPL | Stock | 175.25 | 175.88 | 175.1 | 175.45 | 7677.0 |
| 2022-04-01 04:05:00 | AAPL | Stock | 175.45 | 175.45 | 175.37 | 175.37 | 3387.0 |
| 2022-04-01 04:10:00 | AAPL | Stock | 175.44 | 175.44 | 175.3 | 175.3 | 2414.0 |
| 2022-04-01 04:15:00 | AAPL | Stock | 175.23 | 175.3 | 175.17 | 175.19 | 1964.0 |
| 2022-04-01 04:20:00 | AAPL | Stock | 175.22 | 175.42 | 175.22 | 175.42 | 1428.0 |
| 2022-04-01 04:25:00 | AAPL | Stock | 175.35 | 175.42 | 175.34 | 175.35 | 3022.0 |
| 2022-04-01 04:30:00 | AAPL | Stock | 175.32 | 175.35 | 175.32 | 175.32 | 1766.0 |
| 2022-04-01 04:35:00 | AAPL | Stock | 175.37 | 175.37 | 175.37 | 175.37 | 112.0 |
| 2022-04-01 04:45:00 | AAPL | Stock | 175.36 | 175.37 | 175.27 | 175.31 | 2247.0 |
| 2022-04-01 04:50:00 | AAPL | Stock | 175.26 | 175.26 | 175.26 | 175.26 | 400.0 |
| 2022-04-01 05:00:00 | AAPL | Stock | 175.32 | 175.32 | 175.1 | 175.1 | 2119.0 |
| 2022-04-01 05:05:00 | AAPL | Stock | 175.07 | 175.07 | 175.06 | 175.07 | 597.0 |
| 2022-04-01 05:10:00 | AAPL | Stock | 175.06 | 175.06 | 175.06 | 175.06 | 130.0 |
| 2022-04-01 05:15:00 | AAPL | Stock | 175.06 | 175.09 | 175.06 | 175.09 | 798.0 |
| 2022-04-01 05:20:00 | AAPL | Stock | 175.07 | 175.23 | 175.07 | 175.18 | 1816.0 |
| 2022-04-01 05:30:00 | AAPL | Stock | 175.2 | 175.32 | 175.2 | 175.32 | 6044.0 |
| 2022-04-01 05:40:00 | AAPL | Stock | 175.26 | 175.26 | 175.04 | 175.04 | 333.0 |
| 2022-04-01 05:45:00 | AAPL | Stock | 175.15 | 175.15 | 175.15 | 175.15 | 270.0 |
| 2022-04-01 05:50:00 | AAPL | Stock | 175.1 | 175.2 | 175.1 | 175.2 | 867.0 |
| 2022-04-01 05:55:00 | AAPL | Stock | 175.34 | 175.38 | 175.31 | 175.31 | 718.0 |
| 2022-04-01 06:00:00 | AAPL | Stock | 175.43 | 175.48 | 175.33 | 175.33 | 3333.0 |
| 2022-04-01 06:05:00 | AAPL | Stock | 175.38 | 175.54 | 175.38 | 175.5 | 7004.0 |
| 2022-04-01 06:10:00 | AAPL | Stock | 175.54 | 175.54 | 175.45 | 175.45 | 5425.0 |
| 2022-04-01 06:15:00 | AAPL | Stock | 175.5 | 175.51 | 175.49 | 175.51 | 16718.0 |
| 2022-04-01 06:20:00 | AAPL | Stock | 175.51 | 175.51 | 175.5 | 175.51 | 10461.0 |
| 2022-04-01 06:25:00 | AAPL | Stock | 175.51 | 175.51 | 175.5 | 175.5 | 3033.0 |
| 2022-04-01 06:30:00 | AAPL | Stock | 175.5 | 175.5 | 175.5 | 175.5 | 2487.0 |
| 2022-04-01 06:35:00 | AAPL | Stock | 175.51 | 175.51 | 175.49 | 175.49 | 20392.0 |
| 2022-04-01 06:40:00 | AAPL | Stock | 175.5 | 175.68 | 175.49 | 175.68 | 11463.0 |
| 2022-04-01 06:45:00 | AAPL | Stock | 175.51 | 175.55 | 175.5 | 175.51 | 1973.0 |
| 2022-04-01 06:50:00 | AAPL | Stock | 175.6 | 175.72 | 175.51 | 175.55 | 1641.0 |
| 2022-04-01 06:55:00 | AAPL | Stock | 175.47 | 175.55 | 175.45 | 175.5 | 6127.0 |
| 2022-04-01 07:00:00 | AAPL | Stock | 175.54 | 175.6 | 175.09 | 175.1 | 32491.0 |
| 2022-04-01 07:05:00 | AAPL | Stock | 175.09 | 175.19 | 175.05 | 175.11 | 5087.0 |
| 2022-04-01 07:10:00 | AAPL | Stock | 175.11 | 175.11 | 175.04 | 175.09 | 2443.0 |
| 2022-04-01 07:15:00 | AAPL | Stock | 175.09 | 175.16 | 175.04 | 175.06 | 7616.0 |
| 2022-04-01 07:20:00 | AAPL | Stock | 175.05 | 175.1 | 174.95 | 174.98 | 48086.0 |
| 2022-04-01 07:25:00 | AAPL | Stock | 174.98 | 175.0 | 174.8 | 174.8 | 10684.0 |
| 2022-04-01 07:30:00 | AAPL | Stock | 174.76 | 174.85 | 174.69 | 174.85 | 12398.0 |
| 2022-04-01 07:35:00 | AAPL | Stock | 174.92 | 174.98 | 174.87 | 174.87 | 1363.0 |
| 2022-04-01 07:40:00 | AAPL | Stock | 174.95 | 174.95 | 174.93 | 174.94 | 2403.0 |
| 2022-04-01 07:45:00 | AAPL | Stock | 174.94 | 174.95 | 174.94 | 174.94 | 16951.0 |
| 2022-04-01 07:50:00 | AAPL | Stock | 174.94 | 174.94 | 174.8 | 174.84 | 11246.0 |
| 2022-04-01 07:55:00 | AAPL | Stock | 174.84 | 174.86 | 174.82 | 174.82 | 12215.0 |
| 2022-04-01 08:00:00 | AAPL | Stock | 175.49 | 175.52 | 174.174 | 174.79 | 138337.0 |
| 2022-04-01 08:05:00 | AAPL | Stock | 174.81 | 174.92 | 174.79 | 174.9 | 9568.0 |
| 2022-04-01 08:10:00 | AAPL | Stock | 174.89 | 174.92 | 174.87 | 174.89 | 29679.0 |
| 2022-04-01 08:15:00 | AAPL | Stock | 174.81 | 174.95 | 174.81 | 174.871 | 31119.0 |
| 2022-04-01 08:20:00 | AAPL | Stock | 174.9 | 174.96 | 174.87 | 174.96 | 11134.0 |
| 2022-04-01 08:25:00 | AAPL | Stock | 174.98 | 174.98 | 174.8 | 174.88 | 8976.0 |
> showing 50 of 454,100 rows — these rows as CSV