PREVIEW / stock_5min / 2021-07-06
file: by_date/stock_5min/2021/2021-07-06.parquet size: 7.6 MB rows: 467,204 symbols: 2,914
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-07-06 04:00:00 | AAPL | Stock | 139.5 | 139.9 | 139.5 | 139.7 | 7046.0 |
| 2021-07-06 04:05:00 | AAPL | Stock | 139.71 | 139.78 | 139.7 | 139.77 | 2956.0 |
| 2021-07-06 04:10:00 | AAPL | Stock | 139.81 | 139.81 | 139.81 | 139.81 | 200.0 |
| 2021-07-06 04:15:00 | AAPL | Stock | 139.85 | 139.85 | 139.7 | 139.78 | 12501.0 |
| 2021-07-06 04:20:00 | AAPL | Stock | 139.83 | 139.83 | 139.79 | 139.79 | 934.0 |
| 2021-07-06 04:25:00 | AAPL | Stock | 139.8 | 139.8 | 139.39 | 139.65 | 7637.0 |
| 2021-07-06 04:30:00 | AAPL | Stock | 139.57 | 139.63 | 139.56 | 139.63 | 1800.0 |
| 2021-07-06 04:35:00 | AAPL | Stock | 139.57 | 139.65 | 139.57 | 139.65 | 2448.0 |
| 2021-07-06 04:40:00 | AAPL | Stock | 139.58 | 139.58 | 139.57 | 139.57 | 1519.0 |
| 2021-07-06 04:45:00 | AAPL | Stock | 139.57 | 139.65 | 139.52 | 139.54 | 1662.0 |
| 2021-07-06 04:50:00 | AAPL | Stock | 139.65 | 139.65 | 139.6 | 139.6 | 664.0 |
| 2021-07-06 04:55:00 | AAPL | Stock | 139.69 | 139.69 | 139.69 | 139.69 | 155.0 |
| 2021-07-06 05:05:00 | AAPL | Stock | 139.66 | 139.7 | 139.66 | 139.7 | 700.0 |
| 2021-07-06 05:10:00 | AAPL | Stock | 139.79 | 139.8 | 139.69 | 139.7 | 4365.0 |
| 2021-07-06 05:20:00 | AAPL | Stock | 139.78 | 139.79 | 139.78 | 139.79 | 868.0 |
| 2021-07-06 05:25:00 | AAPL | Stock | 139.85 | 139.9 | 139.85 | 139.9 | 1065.0 |
| 2021-07-06 05:30:00 | AAPL | Stock | 139.89 | 139.89 | 139.75 | 139.75 | 1587.0 |
| 2021-07-06 05:40:00 | AAPL | Stock | 139.72 | 139.72 | 139.72 | 139.72 | 184.0 |
| 2021-07-06 05:45:00 | AAPL | Stock | 139.72 | 139.72 | 139.71 | 139.71 | 816.0 |
| 2021-07-06 05:55:00 | AAPL | Stock | 139.7 | 139.72 | 139.7 | 139.72 | 401.0 |
| 2021-07-06 06:00:00 | AAPL | Stock | 139.77 | 139.77 | 139.73 | 139.74 | 626.0 |
| 2021-07-06 06:05:00 | AAPL | Stock | 139.78 | 139.8 | 139.78 | 139.78 | 653.0 |
| 2021-07-06 06:10:00 | AAPL | Stock | 139.78 | 139.78 | 139.78 | 139.78 | 759.0 |
| 2021-07-06 06:15:00 | AAPL | Stock | 139.77 | 139.78 | 139.77 | 139.78 | 289.0 |
| 2021-07-06 06:20:00 | AAPL | Stock | 139.76 | 139.76 | 139.69 | 139.74 | 3774.0 |
| 2021-07-06 06:25:00 | AAPL | Stock | 139.7 | 139.7 | 139.7 | 139.7 | 200.0 |
| 2021-07-06 06:40:00 | AAPL | Stock | 139.72 | 139.74 | 139.7 | 139.74 | 1239.0 |
| 2021-07-06 06:45:00 | AAPL | Stock | 139.73 | 139.9 | 139.73 | 139.9 | 5677.0 |
| 2021-07-06 06:50:00 | AAPL | Stock | 139.85 | 140.0 | 139.85 | 139.99 | 3417.0 |
| 2021-07-06 06:55:00 | AAPL | Stock | 139.96 | 139.96 | 139.94 | 139.94 | 200.0 |
| 2021-07-06 07:00:00 | AAPL | Stock | 139.92 | 140.09 | 139.84 | 140.0 | 46805.0 |
| 2021-07-06 07:05:00 | AAPL | Stock | 140.1 | 140.21 | 140.05 | 140.19 | 28222.0 |
| 2021-07-06 07:10:00 | AAPL | Stock | 140.18 | 140.31 | 140.18 | 140.25 | 27666.0 |
| 2021-07-06 07:15:00 | AAPL | Stock | 140.23 | 140.36 | 140.2 | 140.339 | 20901.0 |
| 2021-07-06 07:20:00 | AAPL | Stock | 140.34 | 140.38 | 140.25 | 140.31 | 36809.0 |
| 2021-07-06 07:25:00 | AAPL | Stock | 140.32 | 140.34 | 140.29 | 140.33 | 10182.0 |
| 2021-07-06 07:30:00 | AAPL | Stock | 140.329 | 140.33 | 140.26 | 140.28 | 17194.0 |
| 2021-07-06 07:35:00 | AAPL | Stock | 140.28 | 140.28 | 140.2 | 140.25 | 11853.0 |
| 2021-07-06 07:40:00 | AAPL | Stock | 140.26 | 140.27 | 140.18 | 140.2 | 10752.0 |
| 2021-07-06 07:45:00 | AAPL | Stock | 140.19 | 140.26 | 140.19 | 140.25 | 13923.0 |
| 2021-07-06 07:50:00 | AAPL | Stock | 140.26 | 140.3 | 140.25 | 140.25 | 9312.0 |
| 2021-07-06 07:55:00 | AAPL | Stock | 140.24 | 140.32 | 140.23 | 140.31 | 11830.0 |
| 2021-07-06 08:00:00 | AAPL | Stock | 139.9402 | 140.38 | 139.611 | 140.35 | 111167.0 |
| 2021-07-06 08:05:00 | AAPL | Stock | 140.35 | 140.38 | 140.28 | 140.35 | 15146.0 |
| 2021-07-06 08:10:00 | AAPL | Stock | 140.35 | 140.38 | 140.35 | 140.38 | 18680.0 |
| 2021-07-06 08:15:00 | AAPL | Stock | 140.35 | 140.38 | 140.25 | 140.27 | 37315.0 |
| 2021-07-06 08:20:00 | AAPL | Stock | 140.27 | 140.29 | 140.231 | 140.25 | 9148.0 |
| 2021-07-06 08:25:00 | AAPL | Stock | 140.26 | 140.32 | 140.26 | 140.31 | 18795.0 |
| 2021-07-06 08:30:00 | AAPL | Stock | 140.31 | 140.35 | 140.25 | 140.28 | 22687.0 |
| 2021-07-06 08:35:00 | AAPL | Stock | 140.28 | 140.33 | 140.27 | 140.27 | 13373.0 |
> showing 50 of 467,204 rows — these rows as CSV