PREVIEW / stock_5min / 2019-10-23
file: by_date/stock_5min/2019/2019-10-23.parquet size: 5.5 MB rows: 349,253 symbols: 2,499
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-10-23 04:00:00 | AAPL | Stock | 59.91 | 60.0275 | 59.875 | 59.975 | 18480.0 |
| 2019-10-23 04:05:00 | AAPL | Stock | 59.975 | 60.0175 | 59.95 | 60.0175 | 6000.0 |
| 2019-10-23 04:10:00 | AAPL | Stock | 60.04 | 60.04 | 60.04 | 60.04 | 524.0 |
| 2019-10-23 04:25:00 | AAPL | Stock | 60.05 | 60.05 | 60.05 | 60.05 | 2176.0 |
| 2019-10-23 04:30:00 | AAPL | Stock | 60.05 | 60.05 | 60.05 | 60.05 | 2524.0 |
| 2019-10-23 04:35:00 | AAPL | Stock | 60.0275 | 60.04 | 60.0275 | 60.04 | 1536.0 |
| 2019-10-23 04:40:00 | AAPL | Stock | 60.075 | 60.0825 | 60.075 | 60.0825 | 1200.0 |
| 2019-10-23 05:00:00 | AAPL | Stock | 60.12 | 60.1225 | 60.12 | 60.1225 | 1200.0 |
| 2019-10-23 05:15:00 | AAPL | Stock | 60.12 | 60.1475 | 60.12 | 60.1475 | 5908.0 |
| 2019-10-23 05:20:00 | AAPL | Stock | 60.22 | 60.255 | 60.1775 | 60.2425 | 6872.0 |
| 2019-10-23 05:35:00 | AAPL | Stock | 60.23 | 60.475 | 60.23 | 60.4725 | 28740.0 |
| 2019-10-23 05:40:00 | AAPL | Stock | 60.3425 | 60.4025 | 60.3425 | 60.4025 | 7532.0 |
| 2019-10-23 05:50:00 | AAPL | Stock | 60.39 | 60.3975 | 60.39 | 60.3975 | 1020.0 |
| 2019-10-23 06:00:00 | AAPL | Stock | 60.375 | 60.4 | 60.375 | 60.375 | 24716.0 |
| 2019-10-23 06:10:00 | AAPL | Stock | 60.3125 | 60.315 | 60.3125 | 60.3125 | 2000.0 |
| 2019-10-23 06:30:00 | AAPL | Stock | 60.305 | 60.305 | 60.2875 | 60.2875 | 5928.0 |
| 2019-10-23 06:35:00 | AAPL | Stock | 60.28 | 60.28 | 60.28 | 60.28 | 400.0 |
| 2019-10-23 06:40:00 | AAPL | Stock | 60.3 | 60.3 | 60.2875 | 60.2875 | 2000.0 |
| 2019-10-23 06:45:00 | AAPL | Stock | 60.31 | 60.3575 | 60.215 | 60.215 | 20908.0 |
| 2019-10-23 06:50:00 | AAPL | Stock | 60.22 | 60.23 | 60.175 | 60.1875 | 12432.0 |
| 2019-10-23 06:55:00 | AAPL | Stock | 60.19 | 60.235 | 60.175 | 60.235 | 4916.0 |
| 2019-10-23 07:00:00 | AAPL | Stock | 60.235 | 60.2375 | 60.165 | 60.2175 | 22576.0 |
| 2019-10-23 07:05:00 | AAPL | Stock | 60.235 | 60.25 | 60.2225 | 60.23 | 33016.0 |
| 2019-10-23 07:10:00 | AAPL | Stock | 60.2275 | 60.285 | 60.2175 | 60.2625 | 18376.0 |
| 2019-10-23 07:15:00 | AAPL | Stock | 60.25 | 60.25 | 60.175 | 60.175 | 12576.0 |
| 2019-10-23 07:20:00 | AAPL | Stock | 60.165 | 60.1675 | 60.105 | 60.125 | 26512.0 |
| 2019-10-23 07:25:00 | AAPL | Stock | 60.19 | 60.2075 | 60.19 | 60.2 | 6188.0 |
| 2019-10-23 07:30:00 | AAPL | Stock | 60.125 | 60.2425 | 60.1075 | 60.2425 | 10900.0 |
| 2019-10-23 07:35:00 | AAPL | Stock | 60.1775 | 60.255 | 60.1775 | 60.24 | 9100.0 |
| 2019-10-23 07:40:00 | AAPL | Stock | 60.2475 | 60.3075 | 60.2475 | 60.28 | 9760.0 |
| 2019-10-23 07:45:00 | AAPL | Stock | 60.25 | 60.28 | 60.25 | 60.275 | 7200.0 |
| 2019-10-23 07:50:00 | AAPL | Stock | 60.2825 | 60.325 | 60.2675 | 60.3 | 16364.0 |
| 2019-10-23 07:55:00 | AAPL | Stock | 60.2875 | 60.3 | 60.2675 | 60.2775 | 13360.0 |
| 2019-10-23 08:00:00 | AAPL | Stock | 60.28 | 60.325 | 59.8425 | 59.8425 | 123404.0 |
| 2019-10-23 08:05:00 | AAPL | Stock | 60.2825 | 60.34 | 60.2775 | 60.3375 | 35684.0 |
| 2019-10-23 08:10:00 | AAPL | Stock | 60.34 | 60.365 | 59.8425 | 60.34 | 46708.0 |
| 2019-10-23 08:15:00 | AAPL | Stock | 60.35 | 60.3625 | 60.34 | 60.34 | 9104.0 |
| 2019-10-23 08:20:00 | AAPL | Stock | 60.35 | 60.36 | 60.31 | 60.3475 | 14500.0 |
| 2019-10-23 08:25:00 | AAPL | Stock | 60.345 | 60.3725 | 60.345 | 60.3725 | 21908.0 |
| 2019-10-23 08:30:00 | AAPL | Stock | 60.3625 | 60.37 | 60.335 | 60.34 | 11200.0 |
| 2019-10-23 08:35:00 | AAPL | Stock | 60.3425 | 60.3625 | 60.3425 | 60.35 | 12460.0 |
| 2019-10-23 08:40:00 | AAPL | Stock | 60.3425 | 60.37 | 60.335 | 60.3625 | 26488.0 |
| 2019-10-23 08:45:00 | AAPL | Stock | 60.3625 | 60.375 | 60.33 | 60.375 | 63368.0 |
| 2019-10-23 08:50:00 | AAPL | Stock | 60.375 | 60.375 | 60.325 | 60.3625 | 40304.0 |
| 2019-10-23 08:55:00 | AAPL | Stock | 60.36 | 60.38 | 60.3575 | 60.38 | 39660.0 |
| 2019-10-23 09:00:00 | AAPL | Stock | 60.385 | 60.395 | 60.325 | 60.35 | 41500.0 |
| 2019-10-23 09:05:00 | AAPL | Stock | 60.35 | 60.3725 | 60.35 | 60.3725 | 29484.0 |
| 2019-10-23 09:10:00 | AAPL | Stock | 60.3575 | 60.4075 | 59.99 | 60.4 | 69788.0 |
| 2019-10-23 09:15:00 | AAPL | Stock | 60.4075 | 60.415 | 60.4 | 60.4125 | 54932.0 |
| 2019-10-23 09:20:00 | AAPL | Stock | 60.4125 | 60.4475 | 59.99 | 59.99 | 107368.0 |
> showing 50 of 349,253 rows — these rows as CSV