PREVIEW / stock_5min / 2019-12-26
file: by_date/stock_5min/2019/2019-12-26.parquet size: 5.6 MB rows: 348,391 symbols: 2,450
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-12-26 04:00:00 | AAPL | Stock | 71.2225 | 71.2225 | 71.2225 | 71.2225 | 1860.0 |
| 2019-12-26 04:45:00 | AAPL | Stock | 71.2225 | 71.2225 | 71.2225 | 71.2225 | 400.0 |
| 2019-12-26 05:15:00 | AAPL | Stock | 71.2225 | 71.2225 | 71.2225 | 71.2225 | 400.0 |
| 2019-12-26 06:40:00 | AAPL | Stock | 71.2125 | 71.2125 | 71.2125 | 71.2125 | 3892.0 |
| 2019-12-26 06:55:00 | AAPL | Stock | 71.18 | 71.18 | 71.18 | 71.18 | 400.0 |
| 2019-12-26 07:00:00 | AAPL | Stock | 71.21 | 71.21 | 71.1525 | 71.195 | 8984.0 |
| 2019-12-26 07:05:00 | AAPL | Stock | 71.1975 | 71.2 | 71.1875 | 71.1875 | 2400.0 |
| 2019-12-26 07:15:00 | AAPL | Stock | 71.1975 | 71.1975 | 71.1825 | 71.1825 | 896.0 |
| 2019-12-26 07:20:00 | AAPL | Stock | 71.175 | 71.175 | 71.175 | 71.175 | 400.0 |
| 2019-12-26 07:30:00 | AAPL | Stock | 71.1875 | 71.2 | 71.1875 | 71.2 | 800.0 |
| 2019-12-26 07:35:00 | AAPL | Stock | 71.18 | 71.18 | 71.18 | 71.18 | 600.0 |
| 2019-12-26 07:40:00 | AAPL | Stock | 71.1875 | 71.1875 | 71.1875 | 71.1875 | 400.0 |
| 2019-12-26 07:50:00 | AAPL | Stock | 71.1975 | 71.1975 | 71.1825 | 71.1825 | 5128.0 |
| 2019-12-26 08:00:00 | AAPL | Stock | 71.188 | 71.2125 | 71.165 | 71.1975 | 80860.0 |
| 2019-12-26 08:05:00 | AAPL | Stock | 71.1875 | 71.195 | 71.1875 | 71.19 | 43824.0 |
| 2019-12-26 08:10:00 | AAPL | Stock | 71.184 | 71.184 | 71.1625 | 71.1625 | 22840.0 |
| 2019-12-26 08:15:00 | AAPL | Stock | 71.1625 | 71.165 | 71.1625 | 71.1625 | 6876.0 |
| 2019-12-26 08:20:00 | AAPL | Stock | 71.1675 | 71.175 | 71.165 | 71.175 | 11876.0 |
| 2019-12-26 08:25:00 | AAPL | Stock | 71.175 | 71.22 | 71.175 | 71.22 | 12768.0 |
| 2019-12-26 08:30:00 | AAPL | Stock | 71.21 | 71.21 | 71.185 | 71.2 | 16144.0 |
| 2019-12-26 08:35:00 | AAPL | Stock | 71.185 | 71.1925 | 71.1675 | 71.185 | 8432.0 |
| 2019-12-26 08:40:00 | AAPL | Stock | 71.175 | 71.1875 | 71.17 | 71.1825 | 10240.0 |
| 2019-12-26 08:45:00 | AAPL | Stock | 71.1875 | 71.1875 | 71.165 | 71.165 | 10892.0 |
| 2019-12-26 08:50:00 | AAPL | Stock | 71.1825 | 71.185 | 71.175 | 71.175 | 2084.0 |
| 2019-12-26 08:55:00 | AAPL | Stock | 71.175 | 71.185 | 71.1625 | 71.1625 | 8688.0 |
| 2019-12-26 09:00:00 | AAPL | Stock | 71.1625 | 71.17 | 71.14 | 71.165 | 27712.0 |
| 2019-12-26 09:05:00 | AAPL | Stock | 71.17 | 71.1725 | 71.1575 | 71.1725 | 26484.0 |
| 2019-12-26 09:10:00 | AAPL | Stock | 71.165 | 71.1725 | 71.1625 | 71.1625 | 14252.0 |
| 2019-12-26 09:15:00 | AAPL | Stock | 71.1575 | 71.1675 | 71.145 | 71.1625 | 36400.0 |
| 2019-12-26 09:20:00 | AAPL | Stock | 71.16 | 71.1625 | 71.16 | 71.1625 | 3368.0 |
| 2019-12-26 09:25:00 | AAPL | Stock | 71.1725 | 71.2075 | 71.1725 | 71.2075 | 22160.0 |
| 2019-12-26 09:30:00 | AAPL | Stock | 71.205 | 71.405 | 71.175 | 71.3888 | 2843388.0 |
| 2019-12-26 09:35:00 | AAPL | Stock | 71.3925 | 71.44 | 71.33 | 71.385 | 1371740.0 |
| 2019-12-26 09:40:00 | AAPL | Stock | 71.385 | 71.4575 | 71.3675 | 71.426 | 1285512.0 |
| 2019-12-26 09:45:00 | AAPL | Stock | 71.43 | 71.495 | 71.4075 | 71.4765 | 1007728.0 |
| 2019-12-26 09:50:00 | AAPL | Stock | 71.4775 | 71.4875 | 71.405 | 71.4225 | 895972.0 |
| 2019-12-26 09:55:00 | AAPL | Stock | 71.4275 | 71.4975 | 71.4275 | 71.4825 | 697976.0 |
| 2019-12-26 10:00:00 | AAPL | Stock | 71.4775 | 71.5972 | 71.475 | 71.5925 | 1465440.0 |
| 2019-12-26 10:05:00 | AAPL | Stock | 71.595 | 71.6 | 71.5555 | 71.5925 | 930956.0 |
| 2019-12-26 10:10:00 | AAPL | Stock | 71.5955 | 71.5975 | 71.5125 | 71.5575 | 912292.0 |
| 2019-12-26 10:15:00 | AAPL | Stock | 71.56 | 71.69 | 71.55 | 71.6812 | 1314696.0 |
| 2019-12-26 10:20:00 | AAPL | Stock | 71.679 | 71.6822 | 71.6275 | 71.653 | 715884.0 |
| 2019-12-26 10:25:00 | AAPL | Stock | 71.657 | 71.675 | 71.625 | 71.6325 | 708272.0 |
| 2019-12-26 10:30:00 | AAPL | Stock | 71.6325 | 71.7225 | 71.6225 | 71.672 | 827848.0 |
| 2019-12-26 10:35:00 | AAPL | Stock | 71.6725 | 71.745 | 71.6725 | 71.7185 | 917612.0 |
| 2019-12-26 10:40:00 | AAPL | Stock | 71.715 | 71.7455 | 71.6918 | 71.6945 | 589544.0 |
| 2019-12-26 10:45:00 | AAPL | Stock | 71.6975 | 71.7698 | 71.6968 | 71.7575 | 1059256.0 |
| 2019-12-26 10:50:00 | AAPL | Stock | 71.765 | 71.8375 | 71.7425 | 71.835 | 1028572.0 |
| 2019-12-26 10:55:00 | AAPL | Stock | 71.8325 | 71.8578 | 71.81 | 71.854 | 1497800.0 |
| 2019-12-26 11:00:00 | AAPL | Stock | 71.8538 | 71.9375 | 71.8538 | 71.89 | 1656720.0 |
> showing 50 of 348,391 rows — these rows as CSV