PREVIEW / stock_5min / 2019-04-09
file: by_date/stock_5min/2019/2019-04-09.parquet size: 5.5 MB rows: 352,135 symbols: 2,630
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-04-09 04:00:00 | AAPL | Stock | 50.025 | 50.025 | 49.9825 | 49.9825 | 5160.0 |
| 2019-04-09 04:05:00 | AAPL | Stock | 50.0125 | 50.0125 | 50.0125 | 50.0125 | 800.0 |
| 2019-04-09 04:10:00 | AAPL | Stock | 50.025 | 50.025 | 49.9925 | 49.9925 | 1772.0 |
| 2019-04-09 04:40:00 | AAPL | Stock | 50.0725 | 50.075 | 50.0725 | 50.075 | 2228.0 |
| 2019-04-09 04:45:00 | AAPL | Stock | 50.0375 | 50.0375 | 50.0375 | 50.0375 | 1100.0 |
| 2019-04-09 05:05:00 | AAPL | Stock | 50.09 | 50.125 | 50.09 | 50.125 | 7948.0 |
| 2019-04-09 05:15:00 | AAPL | Stock | 50.0775 | 50.0775 | 50.0775 | 50.0775 | 800.0 |
| 2019-04-09 05:40:00 | AAPL | Stock | 50.095 | 50.0975 | 50.095 | 50.0975 | 8508.0 |
| 2019-04-09 05:50:00 | AAPL | Stock | 50.1 | 50.1 | 50.1 | 50.1 | 400.0 |
| 2019-04-09 06:00:00 | AAPL | Stock | 50.0975 | 50.1 | 50.0975 | 50.0975 | 2800.0 |
| 2019-04-09 06:05:00 | AAPL | Stock | 50.0975 | 50.0975 | 50.0975 | 50.0975 | 400.0 |
| 2019-04-09 06:25:00 | AAPL | Stock | 50.1 | 50.1 | 50.075 | 50.075 | 2276.0 |
| 2019-04-09 06:30:00 | AAPL | Stock | 50.055 | 50.055 | 50.055 | 50.055 | 3580.0 |
| 2019-04-09 06:35:00 | AAPL | Stock | 50.095 | 50.125 | 50.095 | 50.125 | 3480.0 |
| 2019-04-09 06:40:00 | AAPL | Stock | 50.13 | 50.13 | 50.075 | 50.0825 | 7984.0 |
| 2019-04-09 06:50:00 | AAPL | Stock | 50.0975 | 50.1125 | 50.0975 | 50.1075 | 3748.0 |
| 2019-04-09 07:00:00 | AAPL | Stock | 50.1225 | 50.145 | 50.105 | 50.115 | 9640.0 |
| 2019-04-09 07:05:00 | AAPL | Stock | 50.145 | 50.2425 | 50.145 | 50.1775 | 39680.0 |
| 2019-04-09 07:10:00 | AAPL | Stock | 50.225 | 50.225 | 50.195 | 50.2175 | 2360.0 |
| 2019-04-09 07:15:00 | AAPL | Stock | 50.2225 | 50.2875 | 50.2225 | 50.275 | 41960.0 |
| 2019-04-09 07:20:00 | AAPL | Stock | 50.275 | 50.2925 | 50.2525 | 50.2775 | 8844.0 |
| 2019-04-09 07:25:00 | AAPL | Stock | 50.2875 | 50.2925 | 50.245 | 50.25 | 20752.0 |
| 2019-04-09 07:30:00 | AAPL | Stock | 50.25 | 50.27 | 50.2375 | 50.2375 | 19728.0 |
| 2019-04-09 07:35:00 | AAPL | Stock | 50.2025 | 50.275 | 50.2025 | 50.25 | 6268.0 |
| 2019-04-09 07:40:00 | AAPL | Stock | 50.2625 | 50.2625 | 50.2125 | 50.225 | 21052.0 |
| 2019-04-09 07:45:00 | AAPL | Stock | 50.225 | 50.3 | 50.225 | 50.28 | 31284.0 |
| 2019-04-09 07:50:00 | AAPL | Stock | 50.2825 | 50.3725 | 50.2825 | 50.3725 | 43372.0 |
| 2019-04-09 07:55:00 | AAPL | Stock | 50.3725 | 50.3725 | 50.3175 | 50.3175 | 61492.0 |
| 2019-04-09 08:00:00 | AAPL | Stock | 50.12 | 50.3875 | 50.105 | 50.325 | 229468.0 |
| 2019-04-09 08:05:00 | AAPL | Stock | 50.325 | 50.36 | 50.3125 | 50.3175 | 32032.0 |
| 2019-04-09 08:10:00 | AAPL | Stock | 50.325 | 50.3375 | 50.2375 | 50.2775 | 46968.0 |
| 2019-04-09 08:15:00 | AAPL | Stock | 50.3175 | 50.3175 | 50.2325 | 50.2325 | 35236.0 |
| 2019-04-09 08:20:00 | AAPL | Stock | 50.2275 | 50.25 | 50.1875 | 50.1875 | 61412.0 |
| 2019-04-09 08:25:00 | AAPL | Stock | 50.19 | 50.275 | 50.19 | 50.2 | 50372.0 |
| 2019-04-09 08:30:00 | AAPL | Stock | 50.2 | 50.235 | 50.1875 | 50.2125 | 41656.0 |
| 2019-04-09 08:35:00 | AAPL | Stock | 50.2175 | 50.235 | 50.185 | 50.22 | 22680.0 |
| 2019-04-09 08:40:00 | AAPL | Stock | 50.2375 | 50.2525 | 50.1925 | 50.25 | 56224.0 |
| 2019-04-09 08:45:00 | AAPL | Stock | 50.275 | 50.275 | 50.225 | 50.2575 | 23180.0 |
| 2019-04-09 08:50:00 | AAPL | Stock | 50.25 | 50.25 | 50.195 | 50.195 | 34224.0 |
| 2019-04-09 08:55:00 | AAPL | Stock | 50.195 | 50.2225 | 50.17 | 50.1925 | 54428.0 |
| 2019-04-09 09:00:00 | AAPL | Stock | 50.1675 | 50.2125 | 50.1325 | 50.1525 | 123104.0 |
| 2019-04-09 09:05:00 | AAPL | Stock | 50.1375 | 50.1925 | 50.1375 | 50.1875 | 51996.0 |
| 2019-04-09 09:10:00 | AAPL | Stock | 50.1775 | 50.21 | 50.162 | 50.1975 | 34172.0 |
| 2019-04-09 09:15:00 | AAPL | Stock | 50.2 | 50.205 | 50.1375 | 50.1425 | 38680.0 |
| 2019-04-09 09:20:00 | AAPL | Stock | 50.15 | 50.1625 | 50.11 | 50.11 | 70764.0 |
| 2019-04-09 09:25:00 | AAPL | Stock | 50.1 | 50.1375 | 50.065 | 50.0838 | 221224.0 |
| 2019-04-09 09:30:00 | AAPL | Stock | 50.085 | 50.313 | 49.92 | 50.285 | 7928660.0 |
| 2019-04-09 09:35:00 | AAPL | Stock | 50.29 | 50.325 | 50.155 | 50.225 | 3238932.0 |
| 2019-04-09 09:40:00 | AAPL | Stock | 50.2262 | 50.4875 | 50.2125 | 50.3925 | 4787484.0 |
| 2019-04-09 09:45:00 | AAPL | Stock | 50.3945 | 50.4025 | 50.2025 | 50.2142 | 3026012.0 |
> showing 50 of 352,135 rows — these rows as CSV