PREVIEW / stock_5min / 2022-07-21
file: by_date/stock_5min/2022/2022-07-21.parquet size: 6.6 MB rows: 413,739 symbols: 2,268
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-07-21 04:00:00 | AAPL | Stock | 152.46 | 153.01 | 152.46 | 152.78 | 11115.0 |
| 2022-07-21 04:05:00 | AAPL | Stock | 152.77 | 152.81 | 152.76 | 152.81 | 1348.0 |
| 2022-07-21 04:15:00 | AAPL | Stock | 152.8 | 152.8 | 152.7 | 152.7 | 4689.0 |
| 2022-07-21 04:20:00 | AAPL | Stock | 152.7 | 152.71 | 152.7 | 152.7 | 1842.0 |
| 2022-07-21 04:25:00 | AAPL | Stock | 152.62 | 152.66 | 152.6 | 152.66 | 2222.0 |
| 2022-07-21 04:30:00 | AAPL | Stock | 152.63 | 152.71 | 152.61 | 152.71 | 1381.0 |
| 2022-07-21 04:35:00 | AAPL | Stock | 152.78 | 152.89 | 152.78 | 152.89 | 610.0 |
| 2022-07-21 04:40:00 | AAPL | Stock | 152.85 | 152.85 | 152.74 | 152.74 | 355.0 |
| 2022-07-21 04:45:00 | AAPL | Stock | 152.76 | 152.76 | 152.76 | 152.76 | 122.0 |
| 2022-07-21 04:50:00 | AAPL | Stock | 152.76 | 152.77 | 152.76 | 152.77 | 450.0 |
| 2022-07-21 04:55:00 | AAPL | Stock | 152.82 | 153.0 | 152.82 | 152.99 | 3117.0 |
| 2022-07-21 05:00:00 | AAPL | Stock | 152.93 | 153.02 | 152.89 | 152.89 | 2622.0 |
| 2022-07-21 05:05:00 | AAPL | Stock | 152.98 | 153.0 | 152.98 | 153.0 | 1335.0 |
| 2022-07-21 05:10:00 | AAPL | Stock | 153.04 | 153.11 | 153.04 | 153.09 | 890.0 |
| 2022-07-21 05:20:00 | AAPL | Stock | 153.01 | 153.1 | 153.01 | 153.1 | 647.0 |
| 2022-07-21 05:25:00 | AAPL | Stock | 153.15 | 153.15 | 153.12 | 153.12 | 624.0 |
| 2022-07-21 05:30:00 | AAPL | Stock | 153.07 | 153.07 | 153.07 | 153.07 | 912.0 |
| 2022-07-21 05:35:00 | AAPL | Stock | 153.0 | 153.0 | 153.0 | 153.0 | 200.0 |
| 2022-07-21 05:40:00 | AAPL | Stock | 153.1 | 153.1 | 153.05 | 153.05 | 1400.0 |
| 2022-07-21 05:50:00 | AAPL | Stock | 153.16 | 153.18 | 153.16 | 153.18 | 1441.0 |
| 2022-07-21 05:55:00 | AAPL | Stock | 153.27 | 153.27 | 153.26 | 153.26 | 4845.0 |
| 2022-07-21 06:00:00 | AAPL | Stock | 153.33 | 153.5 | 153.32 | 153.43 | 3972.0 |
| 2022-07-21 06:05:00 | AAPL | Stock | 153.42 | 153.6 | 153.42 | 153.6 | 2065.0 |
| 2022-07-21 06:10:00 | AAPL | Stock | 153.62 | 153.7 | 153.52 | 153.56 | 4131.0 |
| 2022-07-21 06:15:00 | AAPL | Stock | 153.52 | 153.65 | 153.52 | 153.65 | 1050.0 |
| 2022-07-21 06:20:00 | AAPL | Stock | 153.65 | 153.65 | 153.45 | 153.47 | 2938.0 |
| 2022-07-21 06:25:00 | AAPL | Stock | 153.57 | 153.62 | 153.51 | 153.51 | 1708.0 |
| 2022-07-21 06:30:00 | AAPL | Stock | 153.48 | 153.48 | 153.48 | 153.48 | 267.0 |
| 2022-07-21 06:35:00 | AAPL | Stock | 153.45 | 153.47 | 153.31 | 153.4 | 3716.0 |
| 2022-07-21 06:40:00 | AAPL | Stock | 153.34 | 153.38 | 153.31 | 153.38 | 575.0 |
| 2022-07-21 06:45:00 | AAPL | Stock | 153.32 | 153.35 | 153.32 | 153.35 | 203.0 |
| 2022-07-21 06:50:00 | AAPL | Stock | 153.38 | 153.38 | 153.38 | 153.38 | 300.0 |
| 2022-07-21 06:55:00 | AAPL | Stock | 153.25 | 153.4 | 153.25 | 153.36 | 1832.0 |
| 2022-07-21 07:00:00 | AAPL | Stock | 153.3 | 153.44 | 153.2 | 153.2 | 15112.0 |
| 2022-07-21 07:05:00 | AAPL | Stock | 153.16 | 153.4 | 153.11 | 153.4 | 9756.0 |
| 2022-07-21 07:10:00 | AAPL | Stock | 153.34 | 153.4 | 153.32 | 153.4 | 20203.0 |
| 2022-07-21 07:15:00 | AAPL | Stock | 153.44 | 153.49 | 153.4 | 153.46 | 4218.0 |
| 2022-07-21 07:20:00 | AAPL | Stock | 153.46 | 153.47 | 153.3 | 153.3 | 6489.0 |
| 2022-07-21 07:25:00 | AAPL | Stock | 153.3 | 153.3 | 153.2 | 153.2 | 3758.0 |
| 2022-07-21 07:30:00 | AAPL | Stock | 153.29 | 153.3 | 153.23 | 153.3 | 1097.0 |
| 2022-07-21 07:35:00 | AAPL | Stock | 153.37 | 153.39 | 153.2 | 153.29 | 5740.0 |
| 2022-07-21 07:40:00 | AAPL | Stock | 153.28 | 153.34 | 153.23 | 153.23 | 2300.0 |
| 2022-07-21 07:45:00 | AAPL | Stock | 153.26 | 153.38 | 153.24 | 153.37 | 3339.0 |
| 2022-07-21 07:50:00 | AAPL | Stock | 153.44 | 153.56 | 153.44 | 153.52 | 6865.0 |
| 2022-07-21 07:55:00 | AAPL | Stock | 153.49 | 153.5 | 153.48 | 153.48 | 3085.0 |
| 2022-07-21 08:00:00 | AAPL | Stock | 153.3 | 153.69 | 152.38 | 153.69 | 88264.0 |
| 2022-07-21 08:05:00 | AAPL | Stock | 153.63 | 153.75 | 153.6 | 153.63 | 13793.0 |
| 2022-07-21 08:10:00 | AAPL | Stock | 153.67 | 153.74 | 153.58 | 153.58 | 13479.0 |
| 2022-07-21 08:15:00 | AAPL | Stock | 153.53 | 153.97 | 153.1 | 153.89 | 62202.0 |
| 2022-07-21 08:20:00 | AAPL | Stock | 153.87 | 154.15 | 153.8 | 153.9 | 87811.0 |
> showing 50 of 413,739 rows — these rows as CSV