PREVIEW / stock_5min / 2020-05-05
file: by_date/stock_5min/2020/2020-05-05.parquet size: 6.4 MB rows: 402,682 symbols: 2,363
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-05-05 04:00:00 | AAPL | Stock | 73.9 | 74.015 | 73.9 | 74.0 | 2752.0 |
| 2020-05-05 04:05:00 | AAPL | Stock | 74.0 | 74.025 | 74.0 | 74.0 | 7992.0 |
| 2020-05-05 04:10:00 | AAPL | Stock | 74.0 | 74.04 | 74.0 | 74.01 | 4076.0 |
| 2020-05-05 04:15:00 | AAPL | Stock | 74.0 | 74.0 | 73.7775 | 73.7775 | 2420.0 |
| 2020-05-05 04:20:00 | AAPL | Stock | 73.78 | 73.95 | 73.78 | 73.95 | 3192.0 |
| 2020-05-05 04:25:00 | AAPL | Stock | 73.995 | 73.995 | 73.995 | 73.995 | 1076.0 |
| 2020-05-05 04:30:00 | AAPL | Stock | 73.93 | 73.985 | 73.9 | 73.9 | 3792.0 |
| 2020-05-05 04:35:00 | AAPL | Stock | 73.875 | 73.875 | 73.875 | 73.875 | 1040.0 |
| 2020-05-05 04:40:00 | AAPL | Stock | 73.775 | 73.775 | 73.6375 | 73.7475 | 5176.0 |
| 2020-05-05 04:45:00 | AAPL | Stock | 73.715 | 73.715 | 73.715 | 73.715 | 400.0 |
| 2020-05-05 04:50:00 | AAPL | Stock | 73.635 | 73.635 | 73.5375 | 73.55 | 4436.0 |
| 2020-05-05 04:55:00 | AAPL | Stock | 73.5075 | 73.5075 | 73.38 | 73.38 | 3600.0 |
| 2020-05-05 05:00:00 | AAPL | Stock | 73.38 | 73.575 | 73.3 | 73.4975 | 3200.0 |
| 2020-05-05 05:05:00 | AAPL | Stock | 73.5 | 73.5 | 73.5 | 73.5 | 4664.0 |
| 2020-05-05 05:10:00 | AAPL | Stock | 73.5 | 73.5 | 73.5 | 73.5 | 7728.0 |
| 2020-05-05 05:20:00 | AAPL | Stock | 73.5 | 73.5 | 73.5 | 73.5 | 800.0 |
| 2020-05-05 05:25:00 | AAPL | Stock | 73.5 | 73.5 | 73.5 | 73.5 | 2400.0 |
| 2020-05-05 05:30:00 | AAPL | Stock | 73.5 | 73.5 | 73.5 | 73.5 | 1680.0 |
| 2020-05-05 05:40:00 | AAPL | Stock | 73.5925 | 73.67 | 73.5925 | 73.67 | 5784.0 |
| 2020-05-05 05:45:00 | AAPL | Stock | 73.75 | 73.75 | 73.72 | 73.7225 | 1276.0 |
| 2020-05-05 05:50:00 | AAPL | Stock | 73.72 | 73.72 | 73.72 | 73.72 | 4000.0 |
| 2020-05-05 05:55:00 | AAPL | Stock | 73.7625 | 73.77 | 73.7625 | 73.77 | 8592.0 |
| 2020-05-05 06:00:00 | AAPL | Stock | 73.775 | 73.785 | 73.7 | 73.785 | 13608.0 |
| 2020-05-05 06:10:00 | AAPL | Stock | 73.785 | 73.785 | 73.785 | 73.785 | 660.0 |
| 2020-05-05 06:20:00 | AAPL | Stock | 73.7025 | 73.7025 | 73.7025 | 73.7025 | 400.0 |
| 2020-05-05 06:25:00 | AAPL | Stock | 73.7025 | 73.7325 | 73.7025 | 73.7325 | 4388.0 |
| 2020-05-05 06:30:00 | AAPL | Stock | 73.725 | 73.745 | 73.685 | 73.745 | 11252.0 |
| 2020-05-05 06:35:00 | AAPL | Stock | 73.7425 | 73.7425 | 73.7425 | 73.7425 | 1600.0 |
| 2020-05-05 06:40:00 | AAPL | Stock | 73.7325 | 73.75 | 73.7325 | 73.75 | 11064.0 |
| 2020-05-05 06:50:00 | AAPL | Stock | 73.8075 | 73.8075 | 73.8075 | 73.8075 | 1200.0 |
| 2020-05-05 07:00:00 | AAPL | Stock | 73.75 | 73.85 | 73.75 | 73.75 | 50220.0 |
| 2020-05-05 07:05:00 | AAPL | Stock | 73.75 | 73.775 | 73.7375 | 73.7725 | 16552.0 |
| 2020-05-05 07:10:00 | AAPL | Stock | 73.765 | 73.9025 | 73.765 | 73.9 | 8212.0 |
| 2020-05-05 07:15:00 | AAPL | Stock | 73.8775 | 73.8775 | 73.81 | 73.81 | 11200.0 |
| 2020-05-05 07:20:00 | AAPL | Stock | 73.825 | 73.8475 | 73.785 | 73.825 | 20260.0 |
| 2020-05-05 07:25:00 | AAPL | Stock | 73.825 | 73.85 | 73.825 | 73.845 | 8252.0 |
| 2020-05-05 07:30:00 | AAPL | Stock | 73.85 | 73.85 | 73.835 | 73.85 | 4240.0 |
| 2020-05-05 07:35:00 | AAPL | Stock | 73.875 | 73.9375 | 73.8525 | 73.9075 | 18264.0 |
| 2020-05-05 07:40:00 | AAPL | Stock | 73.9075 | 73.93 | 73.8725 | 73.91 | 13836.0 |
| 2020-05-05 07:45:00 | AAPL | Stock | 73.9125 | 73.96 | 73.91 | 73.9575 | 15468.0 |
| 2020-05-05 07:50:00 | AAPL | Stock | 73.9475 | 74.0 | 73.9475 | 74.0 | 33020.0 |
| 2020-05-05 07:55:00 | AAPL | Stock | 73.9875 | 73.9875 | 73.96 | 73.96 | 6872.0 |
| 2020-05-05 08:00:00 | AAPL | Stock | 73.8 | 74.0125 | 73.73 | 74.0125 | 126084.0 |
| 2020-05-05 08:05:00 | AAPL | Stock | 74.02 | 74.035 | 73.9625 | 74.0 | 30616.0 |
| 2020-05-05 08:10:00 | AAPL | Stock | 74.0125 | 74.06 | 74.0125 | 74.025 | 29444.0 |
| 2020-05-05 08:15:00 | AAPL | Stock | 74.015 | 74.05 | 74.0 | 74.0375 | 49888.0 |
| 2020-05-05 08:20:00 | AAPL | Stock | 74.0075 | 74.025 | 74.0 | 74.0 | 27620.0 |
| 2020-05-05 08:25:00 | AAPL | Stock | 74.0 | 74.0295 | 74.0 | 74.0295 | 8212.0 |
| 2020-05-05 08:30:00 | AAPL | Stock | 74.03 | 74.035 | 73.9575 | 73.9575 | 30956.0 |
| 2020-05-05 08:35:00 | AAPL | Stock | 74.0 | 74.0 | 73.8875 | 73.95 | 14700.0 |
> showing 50 of 402,682 rows — these rows as CSV