PREVIEW / stock_5min / 2020-08-21
file: by_date/stock_5min/2020/2020-08-21.parquet size: 6.5 MB rows: 405,259 symbols: 2,448
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 |
|---|---|---|---|---|---|---|---|
| 2020-08-21 04:00:00 | AAPL | Stock | 119.345 | 119.345 | 119.225 | 119.225 | 3920.0 |
| 2020-08-21 04:05:00 | AAPL | Stock | 119.1875 | 119.225 | 119.1225 | 119.1225 | 19120.0 |
| 2020-08-21 04:10:00 | AAPL | Stock | 119.0775 | 119.0775 | 119.075 | 119.075 | 3600.0 |
| 2020-08-21 04:15:00 | AAPL | Stock | 119.17 | 119.17 | 119.105 | 119.105 | 1180.0 |
| 2020-08-21 04:20:00 | AAPL | Stock | 119.15 | 119.15 | 119.075 | 119.075 | 2396.0 |
| 2020-08-21 04:25:00 | AAPL | Stock | 119.075 | 119.0775 | 119.075 | 119.075 | 1584.0 |
| 2020-08-21 04:30:00 | AAPL | Stock | 119.05 | 119.05 | 119.01 | 119.0425 | 7192.0 |
| 2020-08-21 04:35:00 | AAPL | Stock | 119.0175 | 119.05 | 119.015 | 119.03 | 8428.0 |
| 2020-08-21 04:40:00 | AAPL | Stock | 119.02 | 119.02 | 118.88 | 118.925 | 7180.0 |
| 2020-08-21 04:45:00 | AAPL | Stock | 118.945 | 119.0 | 118.945 | 119.0 | 10260.0 |
| 2020-08-21 04:50:00 | AAPL | Stock | 119.0 | 119.0 | 119.0 | 119.0 | 2048.0 |
| 2020-08-21 04:55:00 | AAPL | Stock | 119.0 | 119.0625 | 119.0 | 119.0625 | 1600.0 |
| 2020-08-21 05:05:00 | AAPL | Stock | 119.0625 | 119.1 | 119.06 | 119.1 | 5316.0 |
| 2020-08-21 05:10:00 | AAPL | Stock | 119.125 | 119.125 | 119.125 | 119.125 | 1696.0 |
| 2020-08-21 05:15:00 | AAPL | Stock | 119.125 | 119.175 | 119.125 | 119.175 | 2400.0 |
| 2020-08-21 05:20:00 | AAPL | Stock | 119.3 | 119.3 | 119.3 | 119.3 | 1184.0 |
| 2020-08-21 05:25:00 | AAPL | Stock | 119.3175 | 119.3175 | 119.305 | 119.305 | 3396.0 |
| 2020-08-21 05:30:00 | AAPL | Stock | 119.25 | 119.275 | 119.2 | 119.2 | 4060.0 |
| 2020-08-21 05:35:00 | AAPL | Stock | 119.305 | 119.3175 | 119.305 | 119.3175 | 800.0 |
| 2020-08-21 05:40:00 | AAPL | Stock | 119.225 | 119.225 | 119.2 | 119.2 | 2384.0 |
| 2020-08-21 05:45:00 | AAPL | Stock | 119.3 | 119.305 | 119.2975 | 119.2975 | 2400.0 |
| 2020-08-21 05:50:00 | AAPL | Stock | 119.3125 | 119.3125 | 119.2475 | 119.25 | 4568.0 |
| 2020-08-21 05:55:00 | AAPL | Stock | 119.2425 | 119.2425 | 119.2125 | 119.215 | 3740.0 |
| 2020-08-21 06:00:00 | AAPL | Stock | 119.23 | 119.2325 | 119.155 | 119.155 | 4132.0 |
| 2020-08-21 06:05:00 | AAPL | Stock | 119.165 | 119.165 | 119.165 | 119.165 | 400.0 |
| 2020-08-21 06:10:00 | AAPL | Stock | 119.15 | 119.1575 | 119.125 | 119.125 | 3312.0 |
| 2020-08-21 06:20:00 | AAPL | Stock | 119.075 | 119.075 | 119.075 | 119.075 | 800.0 |
| 2020-08-21 06:25:00 | AAPL | Stock | 119.0475 | 119.0475 | 119.0075 | 119.0175 | 7704.0 |
| 2020-08-21 06:30:00 | AAPL | Stock | 119.0975 | 119.1175 | 119.0 | 119.0 | 12316.0 |
| 2020-08-21 06:35:00 | AAPL | Stock | 118.9775 | 119.0025 | 118.92 | 118.92 | 15252.0 |
| 2020-08-21 06:40:00 | AAPL | Stock | 118.8775 | 118.96 | 118.8425 | 118.945 | 16272.0 |
| 2020-08-21 06:45:00 | AAPL | Stock | 118.9275 | 118.94 | 118.7875 | 118.8 | 11784.0 |
| 2020-08-21 06:50:00 | AAPL | Stock | 118.775 | 118.8875 | 118.755 | 118.8 | 26076.0 |
| 2020-08-21 07:00:00 | AAPL | Stock | 118.935 | 119.1825 | 118.8625 | 119.1025 | 137980.0 |
| 2020-08-21 07:05:00 | AAPL | Stock | 119.1 | 119.1725 | 119.005 | 119.015 | 109356.0 |
| 2020-08-21 07:10:00 | AAPL | Stock | 119.0075 | 119.2025 | 118.9775 | 119.0375 | 59424.0 |
| 2020-08-21 07:15:00 | AAPL | Stock | 119.0325 | 119.125 | 119.03 | 119.1 | 43324.0 |
| 2020-08-21 07:20:00 | AAPL | Stock | 119.1075 | 119.1425 | 118.9975 | 119.0 | 26572.0 |
| 2020-08-21 07:25:00 | AAPL | Stock | 119.0025 | 119.0425 | 118.975 | 119.025 | 29876.0 |
| 2020-08-21 07:30:00 | AAPL | Stock | 119.025 | 119.1125 | 119.005 | 119.005 | 125688.0 |
| 2020-08-21 07:35:00 | AAPL | Stock | 119.0125 | 119.0125 | 118.875 | 118.875 | 64776.0 |
| 2020-08-21 07:40:00 | AAPL | Stock | 118.84 | 119.04 | 118.825 | 119.0 | 64328.0 |
| 2020-08-21 07:45:00 | AAPL | Stock | 118.9975 | 119.0025 | 118.8125 | 118.8525 | 59736.0 |
| 2020-08-21 07:50:00 | AAPL | Stock | 118.8125 | 118.955 | 118.8 | 118.93 | 38060.0 |
| 2020-08-21 07:55:00 | AAPL | Stock | 118.9525 | 119.0 | 118.8125 | 118.825 | 79088.0 |
| 2020-08-21 08:00:00 | AAPL | Stock | 119.0988 | 119.1875 | 118.57 | 118.65 | 497452.0 |
| 2020-08-21 08:05:00 | AAPL | Stock | 118.64 | 118.75 | 118.5625 | 118.66 | 115392.0 |
| 2020-08-21 08:10:00 | AAPL | Stock | 118.6725 | 118.675 | 118.5 | 118.6175 | 112220.0 |
| 2020-08-21 08:15:00 | AAPL | Stock | 118.6425 | 118.8102 | 118.6375 | 118.79 | 87348.0 |
| 2020-08-21 08:20:00 | AAPL | Stock | 118.77 | 118.925 | 118.75 | 118.925 | 57848.0 |
> showing 50 of 405,259 rows — these rows as CSV