PREVIEW / stock_5min / 2019-05-01
file: by_date/stock_5min/2019/2019-05-01.parquet size: 5.7 MB rows: 357,763 symbols: 2,624
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-01 04:00:00 | AAPL | Stock | 52.7 | 52.8 | 52.7 | 52.775 | 24500.0 |
| 2019-05-01 04:05:00 | AAPL | Stock | 52.775 | 52.775 | 52.7725 | 52.7725 | 1200.0 |
| 2019-05-01 04:10:00 | AAPL | Stock | 52.7625 | 52.7625 | 52.7625 | 52.7625 | 640.0 |
| 2019-05-01 04:15:00 | AAPL | Stock | 52.79 | 52.79 | 52.765 | 52.7675 | 4640.0 |
| 2019-05-01 04:20:00 | AAPL | Stock | 52.8 | 52.8 | 52.8 | 52.8 | 1200.0 |
| 2019-05-01 04:30:00 | AAPL | Stock | 52.82 | 52.82 | 52.82 | 52.82 | 400.0 |
| 2019-05-01 04:45:00 | AAPL | Stock | 52.85 | 52.85 | 52.85 | 52.85 | 400.0 |
| 2019-05-01 04:55:00 | AAPL | Stock | 52.8 | 52.8 | 52.8 | 52.8 | 4800.0 |
| 2019-05-01 05:00:00 | AAPL | Stock | 52.7825 | 52.8425 | 52.75 | 52.7825 | 12800.0 |
| 2019-05-01 05:05:00 | AAPL | Stock | 52.8425 | 52.8425 | 52.83 | 52.8375 | 1600.0 |
| 2019-05-01 05:10:00 | AAPL | Stock | 52.765 | 52.8 | 52.765 | 52.8 | 960.0 |
| 2019-05-01 05:15:00 | AAPL | Stock | 52.8 | 52.875 | 52.8 | 52.875 | 15048.0 |
| 2019-05-01 05:20:00 | AAPL | Stock | 52.875 | 52.875 | 52.875 | 52.875 | 400.0 |
| 2019-05-01 05:25:00 | AAPL | Stock | 52.9175 | 52.9175 | 52.9175 | 52.9175 | 4400.0 |
| 2019-05-01 05:30:00 | AAPL | Stock | 52.925 | 52.925 | 52.925 | 52.925 | 400.0 |
| 2019-05-01 05:35:00 | AAPL | Stock | 52.9325 | 52.9325 | 52.9 | 52.9 | 2400.0 |
| 2019-05-01 05:45:00 | AAPL | Stock | 52.9175 | 52.92 | 52.9175 | 52.92 | 1200.0 |
| 2019-05-01 05:50:00 | AAPL | Stock | 52.965 | 53.0 | 52.965 | 53.0 | 10012.0 |
| 2019-05-01 05:55:00 | AAPL | Stock | 53.0 | 53.0 | 52.9875 | 53.0 | 3200.0 |
| 2019-05-01 06:00:00 | AAPL | Stock | 53.0 | 53.0 | 52.98 | 52.98 | 5220.0 |
| 2019-05-01 06:05:00 | AAPL | Stock | 52.975 | 52.975 | 52.975 | 52.975 | 400.0 |
| 2019-05-01 06:10:00 | AAPL | Stock | 52.995 | 53.0025 | 52.995 | 53.0025 | 6400.0 |
| 2019-05-01 06:15:00 | AAPL | Stock | 53.0 | 53.025 | 53.0 | 53.025 | 16888.0 |
| 2019-05-01 06:20:00 | AAPL | Stock | 53.025 | 53.0275 | 53.0 | 53.0 | 4200.0 |
| 2019-05-01 06:25:00 | AAPL | Stock | 53.0 | 53.0 | 53.0 | 53.0 | 3600.0 |
| 2019-05-01 06:30:00 | AAPL | Stock | 53.025 | 53.1175 | 53.025 | 53.11 | 14976.0 |
| 2019-05-01 06:35:00 | AAPL | Stock | 53.1 | 53.1175 | 53.1 | 53.1175 | 5460.0 |
| 2019-05-01 06:40:00 | AAPL | Stock | 53.1125 | 53.1675 | 53.08 | 53.08 | 10272.0 |
| 2019-05-01 06:45:00 | AAPL | Stock | 53.0675 | 53.0675 | 53.0075 | 53.0075 | 1780.0 |
| 2019-05-01 06:50:00 | AAPL | Stock | 53.0675 | 53.1675 | 53.06 | 53.06 | 41504.0 |
| 2019-05-01 06:55:00 | AAPL | Stock | 53.0725 | 53.11 | 53.0725 | 53.1075 | 11416.0 |
| 2019-05-01 07:00:00 | AAPL | Stock | 53.1 | 53.1 | 53.0 | 53.0375 | 103280.0 |
| 2019-05-01 07:05:00 | AAPL | Stock | 53.025 | 53.0975 | 53.0225 | 53.0975 | 23324.0 |
| 2019-05-01 07:10:00 | AAPL | Stock | 53.0875 | 53.1875 | 53.0875 | 53.185 | 126028.0 |
| 2019-05-01 07:15:00 | AAPL | Stock | 53.175 | 53.175 | 53.0075 | 53.0625 | 66872.0 |
| 2019-05-01 07:20:00 | AAPL | Stock | 53.05 | 53.1 | 53.0 | 53.025 | 138960.0 |
| 2019-05-01 07:25:00 | AAPL | Stock | 53.05 | 53.0975 | 53.0325 | 53.0975 | 24236.0 |
| 2019-05-01 07:30:00 | AAPL | Stock | 53.055 | 53.0675 | 53.0 | 53.025 | 68008.0 |
| 2019-05-01 07:35:00 | AAPL | Stock | 53.03 | 53.05 | 53.0 | 53.0025 | 36164.0 |
| 2019-05-01 07:40:00 | AAPL | Stock | 53.0 | 53.05 | 52.9125 | 52.9475 | 108876.0 |
| 2019-05-01 07:45:00 | AAPL | Stock | 52.95 | 52.965 | 52.915 | 52.9325 | 38040.0 |
| 2019-05-01 07:50:00 | AAPL | Stock | 52.945 | 53.0225 | 52.9375 | 52.9625 | 78428.0 |
| 2019-05-01 07:55:00 | AAPL | Stock | 52.9525 | 52.9625 | 52.8525 | 52.875 | 102812.0 |
| 2019-05-01 08:00:00 | AAPL | Stock | 53.0225 | 53.1875 | 52.755 | 52.775 | 503044.0 |
| 2019-05-01 08:05:00 | AAPL | Stock | 52.775 | 52.8125 | 52.7625 | 52.775 | 125828.0 |
| 2019-05-01 08:10:00 | AAPL | Stock | 52.775 | 52.8125 | 52.7725 | 52.8 | 92764.0 |
| 2019-05-01 08:15:00 | AAPL | Stock | 52.8125 | 52.8375 | 52.7 | 52.71 | 202656.0 |
| 2019-05-01 08:20:00 | AAPL | Stock | 52.73 | 52.825 | 52.7125 | 52.7525 | 139524.0 |
| 2019-05-01 08:25:00 | AAPL | Stock | 52.75 | 52.8475 | 52.75 | 52.82 | 133228.0 |
| 2019-05-01 08:30:00 | AAPL | Stock | 52.8125 | 52.8322 | 52.72 | 52.72 | 130960.0 |
> showing 50 of 357,763 rows — these rows as CSV