PREVIEW / stock_5min / 2020-03-27
file: by_date/stock_5min/2020/2020-03-27.parquet size: 6.4 MB rows: 403,779 symbols: 2,443
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-03-27 04:00:00 | AAPL | Stock | 63.61 | 63.61 | 63.4375 | 63.4375 | 8436.0 |
| 2020-03-27 04:10:00 | AAPL | Stock | 63.685 | 63.685 | 63.685 | 63.685 | 1200.0 |
| 2020-03-27 04:15:00 | AAPL | Stock | 63.8 | 63.8 | 63.6 | 63.6 | 21800.0 |
| 2020-03-27 04:20:00 | AAPL | Stock | 63.4075 | 63.4075 | 63.375 | 63.375 | 3200.0 |
| 2020-03-27 04:25:00 | AAPL | Stock | 63.45 | 63.4625 | 63.45 | 63.4625 | 1932.0 |
| 2020-03-27 04:30:00 | AAPL | Stock | 63.5 | 63.5 | 63.5 | 63.5 | 800.0 |
| 2020-03-27 04:35:00 | AAPL | Stock | 63.425 | 63.425 | 63.425 | 63.425 | 400.0 |
| 2020-03-27 04:40:00 | AAPL | Stock | 63.5 | 63.5 | 63.5 | 63.5 | 400.0 |
| 2020-03-27 04:45:00 | AAPL | Stock | 63.5 | 63.5675 | 63.5 | 63.5675 | 2112.0 |
| 2020-03-27 04:50:00 | AAPL | Stock | 63.5 | 63.5 | 63.5 | 63.5 | 1480.0 |
| 2020-03-27 04:55:00 | AAPL | Stock | 63.4925 | 63.4925 | 63.375 | 63.375 | 1016.0 |
| 2020-03-27 05:00:00 | AAPL | Stock | 63.3 | 63.5 | 63.275 | 63.3125 | 6112.0 |
| 2020-03-27 05:05:00 | AAPL | Stock | 63.25 | 63.2525 | 63.0275 | 63.0625 | 4344.0 |
| 2020-03-27 05:10:00 | AAPL | Stock | 63.1875 | 63.1875 | 63.1875 | 63.1875 | 1508.0 |
| 2020-03-27 05:15:00 | AAPL | Stock | 63.25 | 63.28 | 63.25 | 63.25 | 1600.0 |
| 2020-03-27 05:20:00 | AAPL | Stock | 63.25 | 63.25 | 63.25 | 63.25 | 2400.0 |
| 2020-03-27 05:25:00 | AAPL | Stock | 63.25 | 63.25 | 63.155 | 63.155 | 25664.0 |
| 2020-03-27 05:30:00 | AAPL | Stock | 63.0825 | 63.125 | 63.075 | 63.125 | 1336.0 |
| 2020-03-27 05:35:00 | AAPL | Stock | 63.1925 | 63.2225 | 63.0625 | 63.0625 | 9748.0 |
| 2020-03-27 05:40:00 | AAPL | Stock | 63.0625 | 63.1925 | 63.03 | 63.03 | 2560.0 |
| 2020-03-27 05:45:00 | AAPL | Stock | 63.0275 | 63.1 | 63.025 | 63.1 | 1600.0 |
| 2020-03-27 05:50:00 | AAPL | Stock | 63.1225 | 63.1225 | 63.1225 | 63.1225 | 400.0 |
| 2020-03-27 05:55:00 | AAPL | Stock | 63.0 | 63.0 | 63.0 | 63.0 | 2468.0 |
| 2020-03-27 06:00:00 | AAPL | Stock | 63.0 | 63.0 | 62.83 | 62.89 | 10468.0 |
| 2020-03-27 06:05:00 | AAPL | Stock | 62.9775 | 63.1225 | 62.975 | 62.975 | 5304.0 |
| 2020-03-27 06:15:00 | AAPL | Stock | 62.9225 | 62.9225 | 62.85 | 62.8875 | 2800.0 |
| 2020-03-27 06:20:00 | AAPL | Stock | 62.975 | 63.0 | 62.865 | 62.865 | 6360.0 |
| 2020-03-27 06:25:00 | AAPL | Stock | 62.9975 | 63.0 | 62.9975 | 63.0 | 800.0 |
| 2020-03-27 06:30:00 | AAPL | Stock | 62.95 | 63.1925 | 62.9 | 63.1775 | 6948.0 |
| 2020-03-27 06:35:00 | AAPL | Stock | 63.1925 | 63.3275 | 63.1925 | 63.3275 | 5000.0 |
| 2020-03-27 06:40:00 | AAPL | Stock | 63.1875 | 63.25 | 63.075 | 63.2325 | 21380.0 |
| 2020-03-27 06:45:00 | AAPL | Stock | 63.1475 | 63.195 | 63.0825 | 63.195 | 6796.0 |
| 2020-03-27 06:50:00 | AAPL | Stock | 63.025 | 63.025 | 63.0 | 63.0 | 4952.0 |
| 2020-03-27 06:55:00 | AAPL | Stock | 63.02 | 63.02 | 62.825 | 62.825 | 8200.0 |
| 2020-03-27 07:00:00 | AAPL | Stock | 62.9375 | 63.125 | 62.83 | 63.125 | 117792.0 |
| 2020-03-27 07:05:00 | AAPL | Stock | 63.1025 | 63.3225 | 63.1025 | 63.25 | 29404.0 |
| 2020-03-27 07:10:00 | AAPL | Stock | 63.2875 | 63.6125 | 63.25 | 63.5625 | 81256.0 |
| 2020-03-27 07:15:00 | AAPL | Stock | 63.55 | 63.61 | 63.45 | 63.5625 | 118704.0 |
| 2020-03-27 07:20:00 | AAPL | Stock | 63.5175 | 63.5175 | 63.2625 | 63.2875 | 61904.0 |
| 2020-03-27 07:25:00 | AAPL | Stock | 63.25 | 63.3475 | 63.1875 | 63.1875 | 33924.0 |
| 2020-03-27 07:30:00 | AAPL | Stock | 63.2 | 63.2725 | 63.01 | 63.01 | 49080.0 |
| 2020-03-27 07:35:00 | AAPL | Stock | 63.015 | 63.2575 | 63.0 | 63.2575 | 39560.0 |
| 2020-03-27 07:40:00 | AAPL | Stock | 63.2375 | 63.4475 | 63.155 | 63.375 | 37172.0 |
| 2020-03-27 07:45:00 | AAPL | Stock | 63.4675 | 63.5 | 63.0875 | 63.0875 | 32532.0 |
| 2020-03-27 07:50:00 | AAPL | Stock | 63.085 | 63.25 | 62.95 | 63.0025 | 52184.0 |
| 2020-03-27 07:55:00 | AAPL | Stock | 63.025 | 63.2375 | 63.0175 | 63.075 | 19028.0 |
| 2020-03-27 08:00:00 | AAPL | Stock | 63.45 | 63.5875 | 62.92 | 63.125 | 224648.0 |
| 2020-03-27 08:05:00 | AAPL | Stock | 63.1925 | 63.22 | 63.0 | 63.0 | 79724.0 |
| 2020-03-27 08:10:00 | AAPL | Stock | 63.015 | 63.1 | 62.825 | 62.825 | 107480.0 |
| 2020-03-27 08:15:00 | AAPL | Stock | 62.84 | 63.1425 | 62.825 | 63.1425 | 41444.0 |
> showing 50 of 403,779 rows — these rows as CSV