PREVIEW / stock_5min / 2019-10-31
file: by_date/stock_5min/2019/2019-10-31.parquet size: 5.7 MB rows: 365,255 symbols: 2,503
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-10-31 04:00:00 | AAPL | Stock | 62.3225 | 62.4 | 62.2575 | 62.2575 | 9420.0 |
| 2019-10-31 04:10:00 | AAPL | Stock | 62.4125 | 62.45 | 62.4125 | 62.4425 | 3200.0 |
| 2019-10-31 04:15:00 | AAPL | Stock | 62.4425 | 62.4425 | 62.34 | 62.34 | 20436.0 |
| 2019-10-31 04:20:00 | AAPL | Stock | 62.4 | 62.4375 | 62.4 | 62.4125 | 5312.0 |
| 2019-10-31 04:25:00 | AAPL | Stock | 62.405 | 62.405 | 62.3925 | 62.3925 | 1120.0 |
| 2019-10-31 04:30:00 | AAPL | Stock | 62.41 | 62.41 | 62.3625 | 62.3625 | 16920.0 |
| 2019-10-31 04:35:00 | AAPL | Stock | 62.34 | 62.34 | 62.3175 | 62.3175 | 9160.0 |
| 2019-10-31 04:40:00 | AAPL | Stock | 62.33 | 62.33 | 62.33 | 62.33 | 3192.0 |
| 2019-10-31 04:45:00 | AAPL | Stock | 62.33 | 62.33 | 62.305 | 62.305 | 11420.0 |
| 2019-10-31 04:50:00 | AAPL | Stock | 62.3 | 62.33 | 62.3 | 62.33 | 4768.0 |
| 2019-10-31 04:55:00 | AAPL | Stock | 62.335 | 62.3425 | 62.325 | 62.3275 | 11620.0 |
| 2019-10-31 05:00:00 | AAPL | Stock | 62.325 | 62.3425 | 62.305 | 62.305 | 2328.0 |
| 2019-10-31 05:05:00 | AAPL | Stock | 62.305 | 62.305 | 62.01 | 62.15 | 22788.0 |
| 2019-10-31 05:10:00 | AAPL | Stock | 62.125 | 62.1925 | 62.0 | 62.0375 | 13872.0 |
| 2019-10-31 05:15:00 | AAPL | Stock | 61.9625 | 62.0375 | 61.9125 | 61.925 | 8432.0 |
| 2019-10-31 05:20:00 | AAPL | Stock | 61.8825 | 61.925 | 61.88 | 61.925 | 2056.0 |
| 2019-10-31 05:25:00 | AAPL | Stock | 61.9125 | 62.125 | 61.8875 | 62.05 | 11696.0 |
| 2019-10-31 05:30:00 | AAPL | Stock | 62.05 | 62.05 | 61.7 | 61.7 | 26224.0 |
| 2019-10-31 05:35:00 | AAPL | Stock | 61.6825 | 61.8375 | 61.6525 | 61.8375 | 6000.0 |
| 2019-10-31 05:40:00 | AAPL | Stock | 61.825 | 61.85 | 61.825 | 61.85 | 4320.0 |
| 2019-10-31 05:45:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.7325 | 61.7325 | 22452.0 |
| 2019-10-31 05:50:00 | AAPL | Stock | 61.725 | 61.775 | 61.725 | 61.725 | 10796.0 |
| 2019-10-31 05:55:00 | AAPL | Stock | 61.775 | 61.775 | 61.76 | 61.76 | 1992.0 |
| 2019-10-31 06:00:00 | AAPL | Stock | 61.8125 | 61.9675 | 61.8125 | 61.9625 | 17500.0 |
| 2019-10-31 06:05:00 | AAPL | Stock | 61.95 | 61.95 | 61.9025 | 61.9025 | 2220.0 |
| 2019-10-31 06:10:00 | AAPL | Stock | 61.91 | 61.9975 | 61.91 | 61.9975 | 15720.0 |
| 2019-10-31 06:15:00 | AAPL | Stock | 62.0 | 62.0 | 62.0 | 62.0 | 2628.0 |
| 2019-10-31 06:20:00 | AAPL | Stock | 62.0125 | 62.0125 | 62.0125 | 62.0125 | 1576.0 |
| 2019-10-31 06:25:00 | AAPL | Stock | 62.05 | 62.06 | 62.025 | 62.05 | 10400.0 |
| 2019-10-31 06:30:00 | AAPL | Stock | 62.0275 | 62.12 | 62.025 | 62.03 | 25252.0 |
| 2019-10-31 06:35:00 | AAPL | Stock | 62.0375 | 62.0375 | 62.0325 | 62.0325 | 800.0 |
| 2019-10-31 06:40:00 | AAPL | Stock | 62.0375 | 62.065 | 62.035 | 62.065 | 2008.0 |
| 2019-10-31 06:45:00 | AAPL | Stock | 62.0825 | 62.1075 | 62.08 | 62.08 | 11532.0 |
| 2019-10-31 06:50:00 | AAPL | Stock | 62.1725 | 62.18 | 62.1725 | 62.18 | 3200.0 |
| 2019-10-31 06:55:00 | AAPL | Stock | 62.1825 | 62.2 | 62.115 | 62.1175 | 12312.0 |
| 2019-10-31 07:00:00 | AAPL | Stock | 62.1175 | 62.1225 | 61.945 | 61.945 | 49892.0 |
| 2019-10-31 07:05:00 | AAPL | Stock | 61.945 | 61.975 | 61.9125 | 61.9125 | 21704.0 |
| 2019-10-31 07:10:00 | AAPL | Stock | 61.9175 | 61.965 | 61.82 | 61.82 | 75356.0 |
| 2019-10-31 07:15:00 | AAPL | Stock | 61.825 | 61.875 | 61.81 | 61.8125 | 12728.0 |
| 2019-10-31 07:20:00 | AAPL | Stock | 61.825 | 61.8875 | 61.825 | 61.8875 | 19500.0 |
| 2019-10-31 07:25:00 | AAPL | Stock | 61.9 | 61.9875 | 61.9 | 61.9025 | 39076.0 |
| 2019-10-31 07:30:00 | AAPL | Stock | 61.9525 | 61.9525 | 61.7975 | 61.825 | 70964.0 |
| 2019-10-31 07:35:00 | AAPL | Stock | 61.8125 | 61.85 | 61.78 | 61.78 | 34352.0 |
| 2019-10-31 07:40:00 | AAPL | Stock | 61.7875 | 61.795 | 61.755 | 61.7625 | 52180.0 |
| 2019-10-31 07:45:00 | AAPL | Stock | 61.78 | 61.8375 | 61.7575 | 61.81 | 22172.0 |
| 2019-10-31 07:50:00 | AAPL | Stock | 61.77 | 61.8125 | 61.675 | 61.8125 | 90740.0 |
| 2019-10-31 07:55:00 | AAPL | Stock | 61.795 | 61.855 | 61.765 | 61.855 | 23508.0 |
| 2019-10-31 08:00:00 | AAPL | Stock | 62.0975 | 62.1125 | 61.6775 | 61.725 | 287844.0 |
| 2019-10-31 08:05:00 | AAPL | Stock | 61.705 | 61.7475 | 61.6275 | 61.6625 | 89436.0 |
| 2019-10-31 08:10:00 | AAPL | Stock | 61.675 | 61.8375 | 61.6625 | 61.825 | 77332.0 |
> showing 50 of 365,255 rows — these rows as CSV