PREVIEW / stock_5min / 2019-03-13
file: by_date/stock_5min/2019/2019-03-13.parquet size: 5.7 MB rows: 362,664 symbols: 2,644
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-03-13 04:25:00 | AAPL | Stock | 45.235 | 45.235 | 45.235 | 45.235 | 400.0 |
| 2019-03-13 04:40:00 | AAPL | Stock | 45.2625 | 45.2625 | 45.25 | 45.25 | 3604.0 |
| 2019-03-13 05:55:00 | AAPL | Stock | 45.2775 | 45.2775 | 45.2775 | 45.2775 | 1592.0 |
| 2019-03-13 06:00:00 | AAPL | Stock | 45.34 | 45.34 | 45.34 | 45.34 | 5960.0 |
| 2019-03-13 06:20:00 | AAPL | Stock | 45.35 | 45.35 | 45.35 | 45.35 | 800.0 |
| 2019-03-13 06:25:00 | AAPL | Stock | 45.345 | 45.345 | 45.345 | 45.345 | 400.0 |
| 2019-03-13 06:55:00 | AAPL | Stock | 45.325 | 45.325 | 45.325 | 45.325 | 1108.0 |
| 2019-03-13 07:00:00 | AAPL | Stock | 45.33 | 45.375 | 45.3275 | 45.375 | 14580.0 |
| 2019-03-13 07:05:00 | AAPL | Stock | 45.375 | 45.375 | 45.3725 | 45.3725 | 4392.0 |
| 2019-03-13 07:10:00 | AAPL | Stock | 45.4 | 45.4 | 45.3725 | 45.3725 | 13524.0 |
| 2019-03-13 07:15:00 | AAPL | Stock | 45.3825 | 45.3825 | 45.3825 | 45.3825 | 1600.0 |
| 2019-03-13 07:20:00 | AAPL | Stock | 45.39 | 45.39 | 45.39 | 45.39 | 400.0 |
| 2019-03-13 07:25:00 | AAPL | Stock | 45.39 | 45.39 | 45.39 | 45.39 | 1600.0 |
| 2019-03-13 07:30:00 | AAPL | Stock | 45.3825 | 45.3825 | 45.3725 | 45.3825 | 10912.0 |
| 2019-03-13 07:35:00 | AAPL | Stock | 45.3825 | 45.3825 | 45.3825 | 45.3825 | 2400.0 |
| 2019-03-13 07:40:00 | AAPL | Stock | 45.4 | 45.4 | 45.4 | 45.4 | 800.0 |
| 2019-03-13 07:45:00 | AAPL | Stock | 45.4 | 45.4 | 45.385 | 45.4 | 9644.0 |
| 2019-03-13 07:50:00 | AAPL | Stock | 45.3975 | 45.475 | 45.3975 | 45.4125 | 55568.0 |
| 2019-03-13 07:55:00 | AAPL | Stock | 45.415 | 45.46 | 45.415 | 45.46 | 8812.0 |
| 2019-03-13 08:00:00 | AAPL | Stock | 45.375 | 45.5 | 45.3512 | 45.4825 | 90380.0 |
| 2019-03-13 08:05:00 | AAPL | Stock | 45.47 | 45.5 | 45.34 | 45.5 | 24056.0 |
| 2019-03-13 08:10:00 | AAPL | Stock | 45.4925 | 45.4925 | 45.4075 | 45.415 | 36968.0 |
| 2019-03-13 08:15:00 | AAPL | Stock | 45.425 | 45.4625 | 45.4125 | 45.415 | 29220.0 |
| 2019-03-13 08:20:00 | AAPL | Stock | 45.4225 | 45.4325 | 45.4225 | 45.4325 | 20204.0 |
| 2019-03-13 08:25:00 | AAPL | Stock | 45.4325 | 45.4325 | 45.3875 | 45.42 | 18368.0 |
| 2019-03-13 08:30:00 | AAPL | Stock | 45.4225 | 45.4325 | 45.4075 | 45.4175 | 27864.0 |
| 2019-03-13 08:35:00 | AAPL | Stock | 45.425 | 45.4325 | 45.4125 | 45.425 | 23268.0 |
| 2019-03-13 08:40:00 | AAPL | Stock | 45.425 | 45.4625 | 45.425 | 45.4525 | 37304.0 |
| 2019-03-13 08:45:00 | AAPL | Stock | 45.4675 | 45.4675 | 45.405 | 45.42 | 34312.0 |
| 2019-03-13 08:50:00 | AAPL | Stock | 45.415 | 45.4375 | 45.4125 | 45.4325 | 4800.0 |
| 2019-03-13 08:55:00 | AAPL | Stock | 45.4175 | 45.435 | 45.4075 | 45.4325 | 16992.0 |
| 2019-03-13 09:00:00 | AAPL | Stock | 45.4125 | 45.4425 | 45.4125 | 45.4275 | 38168.0 |
| 2019-03-13 09:05:00 | AAPL | Stock | 45.4325 | 45.475 | 45.4325 | 45.4625 | 13284.0 |
| 2019-03-13 09:10:00 | AAPL | Stock | 45.4625 | 45.4875 | 45.45 | 45.475 | 13920.0 |
| 2019-03-13 09:15:00 | AAPL | Stock | 45.475 | 45.5725 | 45.4725 | 45.5725 | 51560.0 |
| 2019-03-13 09:20:00 | AAPL | Stock | 45.5575 | 45.62 | 45.55 | 45.6125 | 41400.0 |
| 2019-03-13 09:25:00 | AAPL | Stock | 45.5975 | 45.5975 | 45.51 | 45.585 | 43400.0 |
| 2019-03-13 09:30:00 | AAPL | Stock | 45.5725 | 45.825 | 45.515 | 45.6518 | 5501296.0 |
| 2019-03-13 09:35:00 | AAPL | Stock | 45.6532 | 45.7075 | 45.5988 | 45.6392 | 2389784.0 |
| 2019-03-13 09:40:00 | AAPL | Stock | 45.64 | 45.6425 | 45.505 | 45.5645 | 2066004.0 |
| 2019-03-13 09:45:00 | AAPL | Stock | 45.5675 | 45.5925 | 45.3888 | 45.4462 | 2322328.0 |
| 2019-03-13 09:50:00 | AAPL | Stock | 45.4475 | 45.5475 | 45.435 | 45.545 | 1388056.0 |
| 2019-03-13 09:55:00 | AAPL | Stock | 45.5475 | 45.55 | 45.4175 | 45.4275 | 2146716.0 |
| 2019-03-13 10:00:00 | AAPL | Stock | 45.4325 | 45.4875 | 45.4125 | 45.435 | 1139088.0 |
| 2019-03-13 10:05:00 | AAPL | Stock | 45.435 | 45.4442 | 45.3925 | 45.4225 | 1281048.0 |
| 2019-03-13 10:10:00 | AAPL | Stock | 45.4225 | 45.425 | 45.24 | 45.27 | 2689944.0 |
| 2019-03-13 10:15:00 | AAPL | Stock | 45.2705 | 45.3175 | 45.23 | 45.305 | 1410392.0 |
| 2019-03-13 10:20:00 | AAPL | Stock | 45.3045 | 45.335 | 45.24 | 45.2575 | 1279116.0 |
| 2019-03-13 10:25:00 | AAPL | Stock | 45.26 | 45.305 | 45.2325 | 45.2875 | 1060364.0 |
| 2019-03-13 10:30:00 | AAPL | Stock | 45.2862 | 45.29 | 45.23 | 45.24 | 1523900.0 |
> showing 50 of 362,664 rows — these rows as CSV