PREVIEW / stock_5min / 2019-05-08
file: by_date/stock_5min/2019/2019-05-08.parquet size: 5.6 MB rows: 351,884 symbols: 2,590
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-08 04:00:00 | AAPL | Stock | 50.7625 | 50.7625 | 50.7625 | 50.7625 | 4000.0 |
| 2019-05-08 04:15:00 | AAPL | Stock | 50.9425 | 51.065 | 50.9425 | 51.055 | 14272.0 |
| 2019-05-08 04:25:00 | AAPL | Stock | 50.995 | 50.995 | 50.995 | 50.995 | 4000.0 |
| 2019-05-08 04:30:00 | AAPL | Stock | 50.995 | 50.995 | 50.9375 | 50.95 | 3884.0 |
| 2019-05-08 04:35:00 | AAPL | Stock | 50.9725 | 50.995 | 50.9725 | 50.995 | 2800.0 |
| 2019-05-08 04:40:00 | AAPL | Stock | 51.0375 | 51.0675 | 51.0375 | 51.0675 | 2000.0 |
| 2019-05-08 04:45:00 | AAPL | Stock | 51.0675 | 51.0675 | 50.9 | 50.9 | 14520.0 |
| 2019-05-08 04:50:00 | AAPL | Stock | 50.97 | 50.97 | 50.925 | 50.9325 | 2880.0 |
| 2019-05-08 04:55:00 | AAPL | Stock | 50.935 | 50.935 | 50.935 | 50.935 | 400.0 |
| 2019-05-08 05:00:00 | AAPL | Stock | 50.875 | 50.935 | 50.875 | 50.935 | 1200.0 |
| 2019-05-08 05:05:00 | AAPL | Stock | 50.925 | 50.935 | 50.925 | 50.935 | 7616.0 |
| 2019-05-08 05:10:00 | AAPL | Stock | 50.8925 | 50.9 | 50.8925 | 50.9 | 4800.0 |
| 2019-05-08 05:15:00 | AAPL | Stock | 50.9 | 50.9275 | 50.9 | 50.9275 | 800.0 |
| 2019-05-08 05:20:00 | AAPL | Stock | 50.8875 | 50.8875 | 50.8775 | 50.8775 | 3592.0 |
| 2019-05-08 05:25:00 | AAPL | Stock | 50.86 | 50.92 | 50.85 | 50.905 | 13456.0 |
| 2019-05-08 05:30:00 | AAPL | Stock | 50.8525 | 50.8525 | 50.8 | 50.835 | 9116.0 |
| 2019-05-08 05:35:00 | AAPL | Stock | 50.7725 | 50.7725 | 50.73 | 50.73 | 1200.0 |
| 2019-05-08 05:40:00 | AAPL | Stock | 50.8 | 50.8 | 50.715 | 50.715 | 4808.0 |
| 2019-05-08 05:45:00 | AAPL | Stock | 50.715 | 50.715 | 50.715 | 50.715 | 1200.0 |
| 2019-05-08 05:50:00 | AAPL | Stock | 50.6025 | 50.6025 | 50.6025 | 50.6025 | 2000.0 |
| 2019-05-08 05:55:00 | AAPL | Stock | 50.63 | 50.63 | 50.63 | 50.63 | 1808.0 |
| 2019-05-08 06:10:00 | AAPL | Stock | 50.6075 | 50.61 | 50.4875 | 50.5025 | 40836.0 |
| 2019-05-08 06:15:00 | AAPL | Stock | 50.5025 | 50.5475 | 50.5 | 50.5475 | 9552.0 |
| 2019-05-08 06:20:00 | AAPL | Stock | 50.55 | 50.55 | 50.55 | 50.55 | 4300.0 |
| 2019-05-08 06:25:00 | AAPL | Stock | 50.5675 | 50.575 | 50.55 | 50.55 | 9196.0 |
| 2019-05-08 06:30:00 | AAPL | Stock | 50.55 | 50.55 | 50.55 | 50.55 | 800.0 |
| 2019-05-08 06:35:00 | AAPL | Stock | 50.555 | 50.555 | 50.555 | 50.555 | 628.0 |
| 2019-05-08 06:45:00 | AAPL | Stock | 50.59 | 50.625 | 50.59 | 50.625 | 13444.0 |
| 2019-05-08 06:50:00 | AAPL | Stock | 50.6275 | 50.6275 | 50.6275 | 50.6275 | 400.0 |
| 2019-05-08 06:55:00 | AAPL | Stock | 50.6275 | 50.6275 | 50.6275 | 50.6275 | 800.0 |
| 2019-05-08 07:00:00 | AAPL | Stock | 50.625 | 50.6625 | 50.4375 | 50.4375 | 15728.0 |
| 2019-05-08 07:05:00 | AAPL | Stock | 50.4375 | 50.4625 | 50.4375 | 50.4625 | 7668.0 |
| 2019-05-08 07:10:00 | AAPL | Stock | 50.475 | 50.475 | 50.445 | 50.445 | 4764.0 |
| 2019-05-08 07:15:00 | AAPL | Stock | 50.445 | 50.4625 | 50.3725 | 50.3725 | 100900.0 |
| 2019-05-08 07:20:00 | AAPL | Stock | 50.36 | 50.375 | 50.2675 | 50.3 | 79860.0 |
| 2019-05-08 07:25:00 | AAPL | Stock | 50.2875 | 50.3475 | 50.2875 | 50.3375 | 65964.0 |
| 2019-05-08 07:30:00 | AAPL | Stock | 50.33 | 50.33 | 50.275 | 50.275 | 16428.0 |
| 2019-05-08 07:35:00 | AAPL | Stock | 50.265 | 50.36 | 50.265 | 50.325 | 26884.0 |
| 2019-05-08 07:40:00 | AAPL | Stock | 50.3475 | 50.3475 | 50.255 | 50.2625 | 30664.0 |
| 2019-05-08 07:45:00 | AAPL | Stock | 50.265 | 50.265 | 50.175 | 50.2475 | 31544.0 |
| 2019-05-08 07:50:00 | AAPL | Stock | 50.27 | 50.345 | 50.27 | 50.3375 | 13000.0 |
| 2019-05-08 07:55:00 | AAPL | Stock | 50.3 | 50.3 | 50.275 | 50.3 | 18720.0 |
| 2019-05-08 08:00:00 | AAPL | Stock | 50.5475 | 50.6625 | 50.225 | 50.305 | 197648.0 |
| 2019-05-08 08:05:00 | AAPL | Stock | 50.35 | 50.4 | 50.325 | 50.38 | 19720.0 |
| 2019-05-08 08:10:00 | AAPL | Stock | 50.3875 | 50.445 | 50.385 | 50.4 | 10404.0 |
| 2019-05-08 08:15:00 | AAPL | Stock | 50.375 | 50.395 | 50.325 | 50.375 | 24664.0 |
| 2019-05-08 08:20:00 | AAPL | Stock | 50.385 | 50.425 | 50.346 | 50.425 | 13368.0 |
| 2019-05-08 08:25:00 | AAPL | Stock | 50.4 | 50.4233 | 50.375 | 50.375 | 12480.0 |
| 2019-05-08 08:30:00 | AAPL | Stock | 50.375 | 50.375 | 50.3625 | 50.3625 | 2056.0 |
| 2019-05-08 08:35:00 | AAPL | Stock | 50.32 | 50.3375 | 50.2375 | 50.25 | 100944.0 |
> showing 50 of 351,884 rows — these rows as CSV