PREVIEW / stock_5min / 2019-01-09
file: by_date/stock_5min/2019/2019-01-09.parquet size: 5.7 MB rows: 363,433 symbols: 2,697
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-01-09 04:00:00 | AAPL | Stock | 37.8 | 37.975 | 37.8 | 37.975 | 8464.0 |
| 2019-01-09 04:05:00 | AAPL | Stock | 37.9375 | 37.9975 | 37.9375 | 37.975 | 6720.0 |
| 2019-01-09 04:10:00 | AAPL | Stock | 37.9975 | 37.9975 | 37.9875 | 37.9925 | 1796.0 |
| 2019-01-09 04:15:00 | AAPL | Stock | 37.9975 | 38.025 | 37.9975 | 38.025 | 1928.0 |
| 2019-01-09 04:20:00 | AAPL | Stock | 38.11 | 38.11 | 38.11 | 38.11 | 400.0 |
| 2019-01-09 04:25:00 | AAPL | Stock | 38.1 | 38.1 | 38.0875 | 38.0875 | 1704.0 |
| 2019-01-09 04:30:00 | AAPL | Stock | 38.1 | 38.1 | 38.0975 | 38.1 | 3024.0 |
| 2019-01-09 04:35:00 | AAPL | Stock | 38.07 | 38.1 | 38.07 | 38.1 | 3696.0 |
| 2019-01-09 04:40:00 | AAPL | Stock | 38.0525 | 38.1 | 38.05 | 38.095 | 5864.0 |
| 2019-01-09 04:45:00 | AAPL | Stock | 38.1 | 38.1 | 38.0625 | 38.095 | 2640.0 |
| 2019-01-09 04:50:00 | AAPL | Stock | 38.0625 | 38.0625 | 38.025 | 38.0375 | 6008.0 |
| 2019-01-09 04:55:00 | AAPL | Stock | 38.0375 | 38.0375 | 38.035 | 38.0375 | 5416.0 |
| 2019-01-09 05:00:00 | AAPL | Stock | 38.075 | 38.1 | 38.0375 | 38.1 | 20112.0 |
| 2019-01-09 05:05:00 | AAPL | Stock | 38.0725 | 38.1 | 38.0675 | 38.095 | 11260.0 |
| 2019-01-09 05:10:00 | AAPL | Stock | 38.1 | 38.12 | 38.1 | 38.12 | 9252.0 |
| 2019-01-09 05:15:00 | AAPL | Stock | 38.1325 | 38.25 | 38.1325 | 38.25 | 37016.0 |
| 2019-01-09 05:20:00 | AAPL | Stock | 38.25 | 38.25 | 38.1575 | 38.2 | 16932.0 |
| 2019-01-09 05:25:00 | AAPL | Stock | 38.2 | 38.22 | 38.1375 | 38.2 | 20416.0 |
| 2019-01-09 05:30:00 | AAPL | Stock | 38.1825 | 38.1825 | 38.15 | 38.1525 | 6896.0 |
| 2019-01-09 05:40:00 | AAPL | Stock | 38.1875 | 38.1875 | 38.175 | 38.175 | 2244.0 |
| 2019-01-09 05:45:00 | AAPL | Stock | 38.15 | 38.22 | 38.15 | 38.22 | 5720.0 |
| 2019-01-09 05:50:00 | AAPL | Stock | 38.22 | 38.25 | 38.22 | 38.25 | 7552.0 |
| 2019-01-09 05:55:00 | AAPL | Stock | 38.275 | 38.3 | 38.25 | 38.3 | 5496.0 |
| 2019-01-09 06:00:00 | AAPL | Stock | 38.2725 | 38.2875 | 38.25 | 38.25 | 25936.0 |
| 2019-01-09 06:05:00 | AAPL | Stock | 38.25 | 38.2875 | 38.25 | 38.25 | 15488.0 |
| 2019-01-09 06:10:00 | AAPL | Stock | 38.225 | 38.225 | 38.15 | 38.15 | 12852.0 |
| 2019-01-09 06:15:00 | AAPL | Stock | 38.1525 | 38.225 | 38.15 | 38.1775 | 5056.0 |
| 2019-01-09 06:20:00 | AAPL | Stock | 38.225 | 38.3 | 38.225 | 38.25 | 21048.0 |
| 2019-01-09 06:25:00 | AAPL | Stock | 38.25 | 38.275 | 38.22 | 38.22 | 18840.0 |
| 2019-01-09 06:30:00 | AAPL | Stock | 38.1775 | 38.1825 | 38.1525 | 38.175 | 15628.0 |
| 2019-01-09 06:35:00 | AAPL | Stock | 38.165 | 38.175 | 38.1625 | 38.175 | 2536.0 |
| 2019-01-09 06:40:00 | AAPL | Stock | 38.1775 | 38.2 | 38.1775 | 38.2 | 7600.0 |
| 2019-01-09 06:45:00 | AAPL | Stock | 38.1775 | 38.2 | 38.1625 | 38.1625 | 16704.0 |
| 2019-01-09 06:50:00 | AAPL | Stock | 38.195 | 38.2 | 38.165 | 38.165 | 3560.0 |
| 2019-01-09 06:55:00 | AAPL | Stock | 38.175 | 38.175 | 38.175 | 38.175 | 400.0 |
| 2019-01-09 07:00:00 | AAPL | Stock | 38.185 | 38.2225 | 38.0375 | 38.0375 | 96956.0 |
| 2019-01-09 07:05:00 | AAPL | Stock | 38.05 | 38.09 | 38.0025 | 38.025 | 50396.0 |
| 2019-01-09 07:10:00 | AAPL | Stock | 38.0375 | 38.0375 | 37.9625 | 37.9625 | 53336.0 |
| 2019-01-09 07:15:00 | AAPL | Stock | 37.9525 | 38.025 | 37.95 | 37.975 | 48904.0 |
| 2019-01-09 07:20:00 | AAPL | Stock | 37.975 | 38.0125 | 37.95 | 37.95 | 22672.0 |
| 2019-01-09 07:25:00 | AAPL | Stock | 37.935 | 37.9625 | 37.905 | 37.9625 | 52508.0 |
| 2019-01-09 07:30:00 | AAPL | Stock | 37.955 | 37.965 | 37.9375 | 37.965 | 20860.0 |
| 2019-01-09 07:35:00 | AAPL | Stock | 37.95 | 38.015 | 37.94 | 37.995 | 70472.0 |
| 2019-01-09 07:40:00 | AAPL | Stock | 38.01 | 38.0125 | 37.975 | 38.0 | 16104.0 |
| 2019-01-09 07:45:00 | AAPL | Stock | 38.0 | 38.025 | 37.875 | 37.885 | 54632.0 |
| 2019-01-09 07:50:00 | AAPL | Stock | 37.86 | 37.92 | 37.8325 | 37.8325 | 48724.0 |
| 2019-01-09 07:55:00 | AAPL | Stock | 37.8725 | 37.925 | 37.8725 | 37.92 | 98236.0 |
| 2019-01-09 08:00:00 | AAPL | Stock | 38.0 | 38.19 | 37.84 | 37.8875 | 258048.0 |
| 2019-01-09 08:05:00 | AAPL | Stock | 37.9125 | 37.9175 | 37.855 | 37.88 | 48256.0 |
| 2019-01-09 08:10:00 | AAPL | Stock | 37.88 | 37.91 | 37.8525 | 37.8875 | 176040.0 |
> showing 50 of 363,433 rows — these rows as CSV