PREVIEW / stock_5min / 2020-01-14
file: by_date/stock_5min/2020/2020-01-14.parquet size: 6.0 MB rows: 372,505 symbols: 2,471
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-01-14 04:00:00 | AAPL | Stock | 79.125 | 79.135 | 79.015 | 79.1275 | 14780.0 |
| 2020-01-14 04:05:00 | AAPL | Stock | 79.1325 | 79.1575 | 79.075 | 79.0775 | 24236.0 |
| 2020-01-14 04:10:00 | AAPL | Stock | 79.175 | 79.175 | 79.15 | 79.15 | 8276.0 |
| 2020-01-14 04:15:00 | AAPL | Stock | 79.105 | 79.1675 | 79.105 | 79.1675 | 11608.0 |
| 2020-01-14 04:20:00 | AAPL | Stock | 79.1825 | 79.1825 | 79.04 | 79.04 | 26216.0 |
| 2020-01-14 04:25:00 | AAPL | Stock | 79.0425 | 79.0425 | 78.93 | 78.9675 | 27628.0 |
| 2020-01-14 04:30:00 | AAPL | Stock | 78.96 | 79.05 | 78.96 | 79.05 | 8700.0 |
| 2020-01-14 04:35:00 | AAPL | Stock | 79.0875 | 79.0875 | 79.0875 | 79.0875 | 2000.0 |
| 2020-01-14 04:40:00 | AAPL | Stock | 79.085 | 79.1 | 79.08 | 79.1 | 7580.0 |
| 2020-01-14 04:45:00 | AAPL | Stock | 79.0875 | 79.125 | 79.085 | 79.085 | 14744.0 |
| 2020-01-14 04:50:00 | AAPL | Stock | 79.1575 | 79.1625 | 79.075 | 79.145 | 2000.0 |
| 2020-01-14 04:55:00 | AAPL | Stock | 79.1275 | 79.1325 | 79.125 | 79.125 | 10944.0 |
| 2020-01-14 05:00:00 | AAPL | Stock | 79.0875 | 79.1125 | 79.0875 | 79.1125 | 824.0 |
| 2020-01-14 05:05:00 | AAPL | Stock | 79.1625 | 79.1675 | 79.1625 | 79.1675 | 5640.0 |
| 2020-01-14 05:10:00 | AAPL | Stock | 79.1375 | 79.1675 | 79.1375 | 79.1675 | 3248.0 |
| 2020-01-14 05:15:00 | AAPL | Stock | 79.175 | 79.175 | 79.175 | 79.175 | 900.0 |
| 2020-01-14 05:20:00 | AAPL | Stock | 79.175 | 79.175 | 79.0875 | 79.0875 | 4148.0 |
| 2020-01-14 05:30:00 | AAPL | Stock | 79.0925 | 79.0925 | 79.0925 | 79.0925 | 800.0 |
| 2020-01-14 05:40:00 | AAPL | Stock | 79.1575 | 79.1575 | 79.09 | 79.09 | 4800.0 |
| 2020-01-14 05:45:00 | AAPL | Stock | 79.09 | 79.1175 | 79.0025 | 79.0025 | 38908.0 |
| 2020-01-14 05:55:00 | AAPL | Stock | 79.005 | 79.005 | 79.005 | 79.005 | 7340.0 |
| 2020-01-14 06:05:00 | AAPL | Stock | 79.095 | 79.095 | 79.0625 | 79.0625 | 2564.0 |
| 2020-01-14 06:10:00 | AAPL | Stock | 79.005 | 79.005 | 78.9125 | 78.95 | 25476.0 |
| 2020-01-14 06:15:00 | AAPL | Stock | 78.96 | 78.975 | 78.9375 | 78.975 | 9984.0 |
| 2020-01-14 06:30:00 | AAPL | Stock | 78.99 | 78.99 | 78.9525 | 78.9525 | 2788.0 |
| 2020-01-14 06:35:00 | AAPL | Stock | 78.9875 | 79.0725 | 78.9875 | 79.0725 | 7300.0 |
| 2020-01-14 06:40:00 | AAPL | Stock | 79.05 | 79.075 | 79.0125 | 79.0125 | 11076.0 |
| 2020-01-14 06:45:00 | AAPL | Stock | 79.0125 | 79.0125 | 79.0125 | 79.0125 | 2612.0 |
| 2020-01-14 06:50:00 | AAPL | Stock | 79.0475 | 79.1225 | 79.0475 | 79.1225 | 17848.0 |
| 2020-01-14 06:55:00 | AAPL | Stock | 79.1175 | 79.12 | 79.08 | 79.08 | 5600.0 |
| 2020-01-14 07:00:00 | AAPL | Stock | 79.12 | 79.2875 | 79.0525 | 79.2875 | 146844.0 |
| 2020-01-14 07:05:00 | AAPL | Stock | 79.275 | 79.275 | 79.2125 | 79.225 | 70788.0 |
| 2020-01-14 07:10:00 | AAPL | Stock | 79.2425 | 79.2975 | 79.225 | 79.29 | 48316.0 |
| 2020-01-14 07:15:00 | AAPL | Stock | 79.2875 | 79.2975 | 79.2525 | 79.2775 | 18056.0 |
| 2020-01-14 07:20:00 | AAPL | Stock | 79.2875 | 79.325 | 79.2875 | 79.325 | 13904.0 |
| 2020-01-14 07:25:00 | AAPL | Stock | 79.32 | 79.4325 | 79.32 | 79.4 | 100976.0 |
| 2020-01-14 07:30:00 | AAPL | Stock | 79.405 | 79.4425 | 79.4 | 79.4125 | 55044.0 |
| 2020-01-14 07:35:00 | AAPL | Stock | 79.4025 | 79.4225 | 79.3975 | 79.4125 | 23076.0 |
| 2020-01-14 07:40:00 | AAPL | Stock | 79.4125 | 79.4375 | 79.3125 | 79.3125 | 65660.0 |
| 2020-01-14 07:45:00 | AAPL | Stock | 79.3025 | 79.315 | 79.2625 | 79.3075 | 62208.0 |
| 2020-01-14 07:50:00 | AAPL | Stock | 79.31 | 79.3375 | 79.3 | 79.325 | 11912.0 |
| 2020-01-14 07:55:00 | AAPL | Stock | 79.3375 | 79.3375 | 79.3125 | 79.3125 | 13296.0 |
| 2020-01-14 08:00:00 | AAPL | Stock | 79.255 | 79.4425 | 79.1225 | 79.3538 | 268696.0 |
| 2020-01-14 08:05:00 | AAPL | Stock | 79.3575 | 79.4125 | 79.345 | 79.3925 | 69896.0 |
| 2020-01-14 08:10:00 | AAPL | Stock | 79.4 | 79.415 | 79.36 | 79.3622 | 31212.0 |
| 2020-01-14 08:15:00 | AAPL | Stock | 79.355 | 79.36 | 79.255 | 79.265 | 103880.0 |
| 2020-01-14 08:20:00 | AAPL | Stock | 79.2675 | 79.275 | 79.1575 | 79.175 | 312652.0 |
| 2020-01-14 08:25:00 | AAPL | Stock | 79.1625 | 79.1825 | 79.1275 | 79.1525 | 61964.0 |
| 2020-01-14 08:30:00 | AAPL | Stock | 79.17 | 79.25 | 79.1075 | 79.25 | 132872.0 |
| 2020-01-14 08:35:00 | AAPL | Stock | 79.25 | 79.275 | 79.225 | 79.2375 | 43516.0 |
> showing 50 of 372,505 rows — these rows as CSV