PREVIEW / stock_5min / 2021-10-05
file: by_date/stock_5min/2021/2021-10-05.parquet size: 7.3 MB rows: 444,342 symbols: 2,682
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-05 04:00:00 | AAPL | Stock | 139.43 | 139.43 | 139.01 | 139.25 | 5394.0 |
| 2021-10-05 04:05:00 | AAPL | Stock | 139.36 | 139.4 | 139.36 | 139.36 | 1718.0 |
| 2021-10-05 04:10:00 | AAPL | Stock | 139.4 | 139.49 | 139.36 | 139.49 | 1515.0 |
| 2021-10-05 04:15:00 | AAPL | Stock | 139.6 | 139.63 | 139.55 | 139.55 | 535.0 |
| 2021-10-05 04:20:00 | AAPL | Stock | 139.56 | 139.56 | 139.5 | 139.56 | 1760.0 |
| 2021-10-05 04:25:00 | AAPL | Stock | 139.45 | 139.53 | 139.36 | 139.53 | 2681.0 |
| 2021-10-05 04:30:00 | AAPL | Stock | 139.66 | 139.67 | 139.66 | 139.67 | 1449.0 |
| 2021-10-05 04:35:00 | AAPL | Stock | 139.6 | 139.6 | 139.38 | 139.39 | 678.0 |
| 2021-10-05 04:40:00 | AAPL | Stock | 139.48 | 139.56 | 139.48 | 139.56 | 1736.0 |
| 2021-10-05 04:45:00 | AAPL | Stock | 139.46 | 139.46 | 139.45 | 139.45 | 388.0 |
| 2021-10-05 04:50:00 | AAPL | Stock | 139.58 | 139.79 | 139.57 | 139.67 | 4897.0 |
| 2021-10-05 04:55:00 | AAPL | Stock | 139.68 | 139.68 | 139.68 | 139.68 | 716.0 |
| 2021-10-05 05:00:00 | AAPL | Stock | 139.67 | 139.79 | 139.62 | 139.79 | 3236.0 |
| 2021-10-05 05:05:00 | AAPL | Stock | 139.85 | 139.9 | 139.85 | 139.88 | 811.0 |
| 2021-10-05 05:10:00 | AAPL | Stock | 139.88 | 139.88 | 139.77 | 139.88 | 5938.0 |
| 2021-10-05 05:15:00 | AAPL | Stock | 139.87 | 139.87 | 139.75 | 139.8 | 860.0 |
| 2021-10-05 05:20:00 | AAPL | Stock | 139.8 | 139.91 | 139.8 | 139.9 | 4175.0 |
| 2021-10-05 05:25:00 | AAPL | Stock | 139.88 | 139.97 | 139.8 | 139.8 | 3220.0 |
| 2021-10-05 05:30:00 | AAPL | Stock | 139.8 | 139.88 | 139.66 | 139.87 | 2989.0 |
| 2021-10-05 05:40:00 | AAPL | Stock | 139.91 | 139.96 | 139.9 | 139.9 | 1729.0 |
| 2021-10-05 05:45:00 | AAPL | Stock | 139.97 | 139.97 | 139.97 | 139.97 | 467.0 |
| 2021-10-05 05:55:00 | AAPL | Stock | 139.87 | 139.87 | 139.81 | 139.81 | 760.0 |
| 2021-10-05 06:00:00 | AAPL | Stock | 139.96 | 139.97 | 139.67 | 139.87 | 3420.0 |
| 2021-10-05 06:05:00 | AAPL | Stock | 139.75 | 139.75 | 139.63 | 139.65 | 691.0 |
| 2021-10-05 06:15:00 | AAPL | Stock | 139.78 | 139.78 | 139.78 | 139.78 | 369.0 |
| 2021-10-05 06:20:00 | AAPL | Stock | 139.71 | 139.71 | 139.69 | 139.7 | 8577.0 |
| 2021-10-05 06:25:00 | AAPL | Stock | 139.75 | 139.75 | 139.64 | 139.66 | 1902.0 |
| 2021-10-05 06:30:00 | AAPL | Stock | 139.62 | 139.62 | 139.36 | 139.36 | 5848.0 |
| 2021-10-05 06:35:00 | AAPL | Stock | 139.38 | 139.6 | 139.36 | 139.6 | 3771.0 |
| 2021-10-05 06:40:00 | AAPL | Stock | 139.64 | 139.64 | 139.6 | 139.6 | 692.0 |
| 2021-10-05 06:45:00 | AAPL | Stock | 139.41 | 139.44 | 139.31 | 139.31 | 3287.0 |
| 2021-10-05 06:50:00 | AAPL | Stock | 139.39 | 139.39 | 139.31 | 139.31 | 637.0 |
| 2021-10-05 06:55:00 | AAPL | Stock | 139.33 | 139.48 | 139.33 | 139.47 | 1364.0 |
| 2021-10-05 07:00:00 | AAPL | Stock | 139.52 | 139.52 | 139.39 | 139.5 | 37453.0 |
| 2021-10-05 07:05:00 | AAPL | Stock | 139.51 | 139.51 | 139.44 | 139.48 | 23716.0 |
| 2021-10-05 07:10:00 | AAPL | Stock | 139.49 | 139.49 | 139.41 | 139.41 | 26613.0 |
| 2021-10-05 07:15:00 | AAPL | Stock | 139.41 | 139.56 | 139.38 | 139.47 | 14132.0 |
| 2021-10-05 07:20:00 | AAPL | Stock | 139.52 | 139.58 | 139.33 | 139.38 | 16769.0 |
| 2021-10-05 07:25:00 | AAPL | Stock | 139.38 | 139.69 | 139.37 | 139.67 | 13516.0 |
| 2021-10-05 07:30:00 | AAPL | Stock | 139.65 | 139.65 | 139.58 | 139.62 | 7001.0 |
| 2021-10-05 07:35:00 | AAPL | Stock | 139.63 | 139.81 | 139.63 | 139.8 | 22908.0 |
| 2021-10-05 07:40:00 | AAPL | Stock | 139.8 | 139.8 | 139.72 | 139.75 | 8478.0 |
| 2021-10-05 07:45:00 | AAPL | Stock | 139.74 | 139.74 | 139.71 | 139.72 | 1919.0 |
| 2021-10-05 07:50:00 | AAPL | Stock | 139.73 | 139.8 | 139.57 | 139.62 | 23762.0 |
| 2021-10-05 07:55:00 | AAPL | Stock | 139.62 | 139.65 | 139.53 | 139.55 | 12157.0 |
| 2021-10-05 08:00:00 | AAPL | Stock | 139.56 | 139.8 | 139.4 | 139.563 | 142429.0 |
| 2021-10-05 08:05:00 | AAPL | Stock | 139.55 | 139.59 | 139.5 | 139.57 | 22579.0 |
| 2021-10-05 08:10:00 | AAPL | Stock | 139.57 | 139.71 | 139.57 | 139.71 | 13357.0 |
| 2021-10-05 08:15:00 | AAPL | Stock | 139.71 | 139.72 | 139.62 | 139.71 | 13536.0 |
| 2021-10-05 08:20:00 | AAPL | Stock | 139.7 | 139.71 | 139.5801 | 139.61 | 14322.0 |
> showing 50 of 444,342 rows — these rows as CSV