PREVIEW / stock_5min / 2020-08-20
file: by_date/stock_5min/2020/2020-08-20.parquet size: 6.4 MB rows: 403,457 symbols: 2,459
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-20 04:00:00 | AAPL | Stock | 115.675 | 115.675 | 115.675 | 115.675 | 1684.0 |
| 2020-08-20 04:05:00 | AAPL | Stock | 115.625 | 115.625 | 115.625 | 115.625 | 2540.0 |
| 2020-08-20 04:10:00 | AAPL | Stock | 115.625 | 115.625 | 115.545 | 115.545 | 800.0 |
| 2020-08-20 04:20:00 | AAPL | Stock | 115.4975 | 115.4975 | 115.265 | 115.265 | 3320.0 |
| 2020-08-20 04:25:00 | AAPL | Stock | 115.25 | 115.25 | 115.25 | 115.25 | 800.0 |
| 2020-08-20 04:30:00 | AAPL | Stock | 115.25 | 115.25 | 115.25 | 115.25 | 400.0 |
| 2020-08-20 04:35:00 | AAPL | Stock | 115.25 | 115.305 | 115.25 | 115.305 | 1200.0 |
| 2020-08-20 04:50:00 | AAPL | Stock | 115.43 | 115.43 | 115.43 | 115.43 | 400.0 |
| 2020-08-20 04:55:00 | AAPL | Stock | 115.425 | 115.425 | 115.425 | 115.425 | 400.0 |
| 2020-08-20 05:00:00 | AAPL | Stock | 115.4925 | 115.4925 | 115.4925 | 115.4925 | 1600.0 |
| 2020-08-20 05:35:00 | AAPL | Stock | 115.6225 | 115.7225 | 115.6225 | 115.7 | 5556.0 |
| 2020-08-20 05:40:00 | AAPL | Stock | 115.7775 | 115.8325 | 115.7775 | 115.8325 | 1596.0 |
| 2020-08-20 05:50:00 | AAPL | Stock | 115.9625 | 115.9625 | 115.95 | 115.95 | 1200.0 |
| 2020-08-20 06:10:00 | AAPL | Stock | 115.9825 | 115.9825 | 115.965 | 115.965 | 1600.0 |
| 2020-08-20 06:15:00 | AAPL | Stock | 115.95 | 115.97 | 115.95 | 115.97 | 1616.0 |
| 2020-08-20 06:20:00 | AAPL | Stock | 115.93 | 116.02 | 115.93 | 116.02 | 1200.0 |
| 2020-08-20 06:25:00 | AAPL | Stock | 116.0775 | 116.1625 | 116.0775 | 116.1625 | 5944.0 |
| 2020-08-20 06:30:00 | AAPL | Stock | 116.15 | 116.1875 | 116.15 | 116.1875 | 1600.0 |
| 2020-08-20 06:35:00 | AAPL | Stock | 116.13 | 116.13 | 116.1125 | 116.13 | 7204.0 |
| 2020-08-20 06:40:00 | AAPL | Stock | 116.13 | 116.175 | 116.125 | 116.175 | 4400.0 |
| 2020-08-20 06:45:00 | AAPL | Stock | 116.1525 | 116.155 | 116.1525 | 116.1525 | 1600.0 |
| 2020-08-20 06:50:00 | AAPL | Stock | 116.175 | 116.235 | 116.175 | 116.235 | 3988.0 |
| 2020-08-20 06:55:00 | AAPL | Stock | 116.2475 | 116.3625 | 116.245 | 116.3625 | 5580.0 |
| 2020-08-20 07:00:00 | AAPL | Stock | 116.35 | 116.37 | 116.125 | 116.24 | 54228.0 |
| 2020-08-20 07:05:00 | AAPL | Stock | 116.2375 | 116.35 | 116.23 | 116.325 | 23576.0 |
| 2020-08-20 07:10:00 | AAPL | Stock | 116.3175 | 116.3775 | 116.25 | 116.25 | 61876.0 |
| 2020-08-20 07:15:00 | AAPL | Stock | 116.2475 | 116.25 | 116.15 | 116.2125 | 18820.0 |
| 2020-08-20 07:20:00 | AAPL | Stock | 116.1975 | 116.1975 | 116.0325 | 116.1625 | 29596.0 |
| 2020-08-20 07:25:00 | AAPL | Stock | 116.1625 | 116.1625 | 116.1375 | 116.1625 | 10872.0 |
| 2020-08-20 07:30:00 | AAPL | Stock | 116.185 | 116.225 | 116.165 | 116.21 | 5476.0 |
| 2020-08-20 07:35:00 | AAPL | Stock | 116.2325 | 116.275 | 116.215 | 116.215 | 21364.0 |
| 2020-08-20 07:40:00 | AAPL | Stock | 116.2375 | 116.2425 | 116.0 | 116.08 | 85156.0 |
| 2020-08-20 07:45:00 | AAPL | Stock | 116.13 | 116.1875 | 116.105 | 116.1775 | 15760.0 |
| 2020-08-20 07:50:00 | AAPL | Stock | 116.175 | 116.185 | 116.135 | 116.135 | 10112.0 |
| 2020-08-20 07:55:00 | AAPL | Stock | 116.165 | 116.17 | 116.125 | 116.16 | 5496.0 |
| 2020-08-20 08:00:00 | AAPL | Stock | 116.16 | 116.35 | 115.995 | 116.1325 | 128288.0 |
| 2020-08-20 08:05:00 | AAPL | Stock | 116.155 | 116.185 | 116.09 | 116.1375 | 55520.0 |
| 2020-08-20 08:10:00 | AAPL | Stock | 116.17 | 116.194 | 116.14 | 116.155 | 16596.0 |
| 2020-08-20 08:15:00 | AAPL | Stock | 116.17 | 116.1875 | 116.03 | 116.0625 | 21460.0 |
| 2020-08-20 08:20:00 | AAPL | Stock | 116.0475 | 116.1625 | 116.03 | 116.125 | 25600.0 |
| 2020-08-20 08:25:00 | AAPL | Stock | 116.14 | 116.1825 | 116.14 | 116.1725 | 8812.0 |
| 2020-08-20 08:30:00 | AAPL | Stock | 116.15 | 116.1825 | 115.96 | 115.9625 | 40144.0 |
| 2020-08-20 08:35:00 | AAPL | Stock | 116.0 | 116.0 | 115.875 | 115.9975 | 49068.0 |
| 2020-08-20 08:40:00 | AAPL | Stock | 115.975 | 116.075 | 115.9625 | 116.0 | 39780.0 |
| 2020-08-20 08:45:00 | AAPL | Stock | 115.995 | 116.062 | 115.995 | 116.0125 | 18892.0 |
| 2020-08-20 08:50:00 | AAPL | Stock | 116.0475 | 116.06 | 115.9975 | 116.0032 | 35424.0 |
| 2020-08-20 08:55:00 | AAPL | Stock | 116.0175 | 116.03 | 115.975 | 116.0 | 25244.0 |
| 2020-08-20 09:00:00 | AAPL | Stock | 115.976 | 116.02 | 115.9275 | 115.976 | 27284.0 |
| 2020-08-20 09:05:00 | AAPL | Stock | 115.975 | 115.9945 | 115.86 | 115.875 | 29260.0 |
| 2020-08-20 09:10:00 | AAPL | Stock | 115.875 | 115.875 | 115.75 | 115.795 | 38908.0 |
> showing 50 of 403,457 rows — these rows as CSV