PREVIEW / stock_5min / 2018-10-26
file: by_date/stock_5min/2018/2018-10-26.parquet size: 5.8 MB rows: 364,705 symbols: 2,748
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-26 04:00:00 | AAPL | Stock | 54.625 | 54.625 | 54.445 | 54.445 | 3800.0 |
| 2018-10-26 04:05:00 | AAPL | Stock | 54.4125 | 54.425 | 54.375 | 54.375 | 12404.0 |
| 2018-10-26 04:10:00 | AAPL | Stock | 54.31 | 54.3725 | 54.31 | 54.3725 | 1024.0 |
| 2018-10-26 04:15:00 | AAPL | Stock | 54.31 | 54.325 | 54.2375 | 54.2375 | 34376.0 |
| 2018-10-26 04:20:00 | AAPL | Stock | 54.25 | 54.25 | 54.1575 | 54.2375 | 5420.0 |
| 2018-10-26 04:25:00 | AAPL | Stock | 54.2625 | 54.2625 | 54.2 | 54.225 | 5680.0 |
| 2018-10-26 04:30:00 | AAPL | Stock | 54.25 | 54.25 | 54.25 | 54.25 | 400.0 |
| 2018-10-26 04:40:00 | AAPL | Stock | 54.175 | 54.2125 | 54.175 | 54.19 | 5200.0 |
| 2018-10-26 04:45:00 | AAPL | Stock | 54.13 | 54.16 | 54.13 | 54.16 | 8000.0 |
| 2018-10-26 04:50:00 | AAPL | Stock | 54.1875 | 54.1875 | 54.12 | 54.12 | 9404.0 |
| 2018-10-26 04:55:00 | AAPL | Stock | 54.11 | 54.11 | 54.1075 | 54.1075 | 3600.0 |
| 2018-10-26 05:00:00 | AAPL | Stock | 54.13 | 54.1375 | 54.1 | 54.1 | 17380.0 |
| 2018-10-26 05:05:00 | AAPL | Stock | 54.1 | 54.1 | 54.1 | 54.1 | 2800.0 |
| 2018-10-26 05:10:00 | AAPL | Stock | 54.1125 | 54.1125 | 54.0625 | 54.0625 | 11340.0 |
| 2018-10-26 05:15:00 | AAPL | Stock | 54.03 | 54.0375 | 54.0 | 54.0 | 4788.0 |
| 2018-10-26 05:20:00 | AAPL | Stock | 53.94 | 53.94 | 53.8775 | 53.8875 | 34916.0 |
| 2018-10-26 05:25:00 | AAPL | Stock | 53.8675 | 53.8675 | 53.75 | 53.75 | 19000.0 |
| 2018-10-26 05:30:00 | AAPL | Stock | 53.675 | 53.68 | 53.5275 | 53.5975 | 56484.0 |
| 2018-10-26 05:35:00 | AAPL | Stock | 53.5975 | 53.6625 | 53.53 | 53.6625 | 21060.0 |
| 2018-10-26 05:40:00 | AAPL | Stock | 53.6475 | 53.715 | 53.6475 | 53.6975 | 13696.0 |
| 2018-10-26 05:45:00 | AAPL | Stock | 53.705 | 53.705 | 53.5825 | 53.5825 | 8836.0 |
| 2018-10-26 05:50:00 | AAPL | Stock | 53.6125 | 53.6125 | 53.5 | 53.6 | 12680.0 |
| 2018-10-26 05:55:00 | AAPL | Stock | 53.6 | 53.725 | 53.6 | 53.725 | 20704.0 |
| 2018-10-26 06:00:00 | AAPL | Stock | 53.6975 | 53.7425 | 53.675 | 53.675 | 54200.0 |
| 2018-10-26 06:05:00 | AAPL | Stock | 53.7125 | 53.7125 | 53.6625 | 53.6625 | 7924.0 |
| 2018-10-26 06:10:00 | AAPL | Stock | 53.65 | 53.7125 | 53.65 | 53.7 | 46700.0 |
| 2018-10-26 06:15:00 | AAPL | Stock | 53.725 | 53.8375 | 53.725 | 53.8375 | 9992.0 |
| 2018-10-26 06:20:00 | AAPL | Stock | 53.8525 | 53.87 | 53.8 | 53.8625 | 45764.0 |
| 2018-10-26 06:25:00 | AAPL | Stock | 53.8125 | 53.8125 | 53.775 | 53.775 | 2768.0 |
| 2018-10-26 06:30:00 | AAPL | Stock | 53.8425 | 53.96 | 53.84 | 53.96 | 5600.0 |
| 2018-10-26 06:35:00 | AAPL | Stock | 53.96 | 53.9625 | 53.89 | 53.935 | 5468.0 |
| 2018-10-26 06:40:00 | AAPL | Stock | 53.9125 | 53.9375 | 53.825 | 53.825 | 27440.0 |
| 2018-10-26 06:45:00 | AAPL | Stock | 53.8225 | 53.835 | 53.82 | 53.835 | 5880.0 |
| 2018-10-26 06:50:00 | AAPL | Stock | 53.825 | 53.8775 | 53.8225 | 53.875 | 8300.0 |
| 2018-10-26 06:55:00 | AAPL | Stock | 53.875 | 53.8775 | 53.7925 | 53.8275 | 10976.0 |
| 2018-10-26 07:00:00 | AAPL | Stock | 53.8125 | 54.075 | 53.8125 | 54.005 | 111528.0 |
| 2018-10-26 07:05:00 | AAPL | Stock | 54.03 | 54.075 | 53.95 | 54.025 | 48152.0 |
| 2018-10-26 07:10:00 | AAPL | Stock | 54.0625 | 54.1625 | 53.985 | 54.0 | 64236.0 |
| 2018-10-26 07:15:00 | AAPL | Stock | 54.0225 | 54.15 | 53.9925 | 54.125 | 20868.0 |
| 2018-10-26 07:20:00 | AAPL | Stock | 54.125 | 54.1625 | 54.04 | 54.125 | 7256.0 |
| 2018-10-26 07:25:00 | AAPL | Stock | 54.1475 | 54.22 | 54.1 | 54.1 | 65056.0 |
| 2018-10-26 07:30:00 | AAPL | Stock | 54.1575 | 54.165 | 54.0 | 54.075 | 41908.0 |
| 2018-10-26 07:35:00 | AAPL | Stock | 54.0925 | 54.125 | 53.9075 | 54.0575 | 88548.0 |
| 2018-10-26 07:40:00 | AAPL | Stock | 54.0325 | 54.0375 | 53.99 | 54.0 | 18112.0 |
| 2018-10-26 07:45:00 | AAPL | Stock | 54.0 | 54.0375 | 53.9375 | 54.0 | 56804.0 |
| 2018-10-26 07:50:00 | AAPL | Stock | 53.995 | 54.0 | 53.95 | 53.98 | 18720.0 |
| 2018-10-26 07:55:00 | AAPL | Stock | 54.0 | 54.0725 | 53.985 | 54.025 | 54976.0 |
| 2018-10-26 08:00:00 | AAPL | Stock | 53.975 | 54.2075 | 53.8612 | 53.895 | 190652.0 |
| 2018-10-26 08:05:00 | AAPL | Stock | 53.895 | 53.95 | 53.85 | 53.915 | 72636.0 |
| 2018-10-26 08:10:00 | AAPL | Stock | 53.945 | 54.045 | 53.9275 | 54.0 | 69588.0 |
> showing 50 of 364,705 rows — these rows as CSV