PREVIEW / stock_5min / 2019-04-03
file: by_date/stock_5min/2019/2019-04-03.parquet size: 5.8 MB rows: 364,343 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-03 04:00:00 | AAPL | Stock | 48.6775 | 48.7475 | 48.6775 | 48.7475 | 4160.0 |
| 2019-04-03 04:05:00 | AAPL | Stock | 48.7975 | 48.7975 | 48.75 | 48.75 | 7300.0 |
| 2019-04-03 04:15:00 | AAPL | Stock | 48.745 | 48.745 | 48.745 | 48.745 | 400.0 |
| 2019-04-03 04:25:00 | AAPL | Stock | 48.675 | 48.675 | 48.675 | 48.675 | 800.0 |
| 2019-04-03 04:35:00 | AAPL | Stock | 48.73 | 48.73 | 48.7275 | 48.7275 | 1400.0 |
| 2019-04-03 04:40:00 | AAPL | Stock | 48.735 | 48.735 | 48.735 | 48.735 | 1600.0 |
| 2019-04-03 04:55:00 | AAPL | Stock | 48.7275 | 48.7275 | 48.7275 | 48.7275 | 400.0 |
| 2019-04-03 05:05:00 | AAPL | Stock | 48.7175 | 48.7175 | 48.6825 | 48.6825 | 2116.0 |
| 2019-04-03 05:10:00 | AAPL | Stock | 48.6875 | 48.6875 | 48.6825 | 48.6825 | 1184.0 |
| 2019-04-03 05:20:00 | AAPL | Stock | 48.725 | 48.725 | 48.725 | 48.725 | 4000.0 |
| 2019-04-03 05:25:00 | AAPL | Stock | 48.725 | 48.735 | 48.6775 | 48.6775 | 2000.0 |
| 2019-04-03 05:30:00 | AAPL | Stock | 48.6725 | 48.6725 | 48.6725 | 48.6725 | 400.0 |
| 2019-04-03 05:35:00 | AAPL | Stock | 48.7075 | 48.715 | 48.7075 | 48.715 | 16356.0 |
| 2019-04-03 05:40:00 | AAPL | Stock | 48.7 | 48.7 | 48.665 | 48.665 | 3400.0 |
| 2019-04-03 05:45:00 | AAPL | Stock | 48.71 | 48.7125 | 48.71 | 48.7125 | 1212.0 |
| 2019-04-03 05:55:00 | AAPL | Stock | 48.7225 | 48.725 | 48.7225 | 48.725 | 11920.0 |
| 2019-04-03 06:00:00 | AAPL | Stock | 48.7125 | 48.7125 | 48.7125 | 48.7125 | 400.0 |
| 2019-04-03 06:05:00 | AAPL | Stock | 48.6875 | 48.6875 | 48.6725 | 48.6725 | 3192.0 |
| 2019-04-03 06:10:00 | AAPL | Stock | 48.67 | 48.67 | 48.67 | 48.67 | 852.0 |
| 2019-04-03 06:15:00 | AAPL | Stock | 48.675 | 48.675 | 48.6625 | 48.6625 | 4000.0 |
| 2019-04-03 06:20:00 | AAPL | Stock | 48.6525 | 48.6525 | 48.56 | 48.595 | 17156.0 |
| 2019-04-03 06:25:00 | AAPL | Stock | 48.595 | 48.595 | 48.595 | 48.595 | 800.0 |
| 2019-04-03 06:35:00 | AAPL | Stock | 48.5675 | 48.5675 | 48.55 | 48.55 | 10528.0 |
| 2019-04-03 06:40:00 | AAPL | Stock | 48.5325 | 48.56 | 48.475 | 48.5125 | 7584.0 |
| 2019-04-03 06:45:00 | AAPL | Stock | 48.5475 | 48.5475 | 48.5475 | 48.5475 | 400.0 |
| 2019-04-03 06:50:00 | AAPL | Stock | 48.5475 | 48.55 | 48.53 | 48.53 | 5820.0 |
| 2019-04-03 06:55:00 | AAPL | Stock | 48.53 | 48.55 | 48.53 | 48.55 | 5196.0 |
| 2019-04-03 07:00:00 | AAPL | Stock | 48.555 | 48.595 | 48.55 | 48.575 | 11832.0 |
| 2019-04-03 07:05:00 | AAPL | Stock | 48.5825 | 48.5875 | 48.57 | 48.57 | 9736.0 |
| 2019-04-03 07:10:00 | AAPL | Stock | 48.5825 | 48.5925 | 48.5725 | 48.58 | 30940.0 |
| 2019-04-03 07:15:00 | AAPL | Stock | 48.575 | 48.58 | 48.5375 | 48.5375 | 11916.0 |
| 2019-04-03 07:20:00 | AAPL | Stock | 48.5475 | 48.5475 | 48.4875 | 48.5 | 26596.0 |
| 2019-04-03 07:25:00 | AAPL | Stock | 48.53 | 48.53 | 48.4875 | 48.5225 | 23568.0 |
| 2019-04-03 07:30:00 | AAPL | Stock | 48.5025 | 48.56 | 48.5025 | 48.545 | 24240.0 |
| 2019-04-03 07:35:00 | AAPL | Stock | 48.545 | 48.55 | 48.5 | 48.515 | 18392.0 |
| 2019-04-03 07:40:00 | AAPL | Stock | 48.525 | 48.525 | 48.4125 | 48.43 | 26960.0 |
| 2019-04-03 07:45:00 | AAPL | Stock | 48.45 | 48.47 | 48.4125 | 48.4625 | 24360.0 |
| 2019-04-03 07:50:00 | AAPL | Stock | 48.4575 | 48.46 | 48.4125 | 48.425 | 15368.0 |
| 2019-04-03 07:55:00 | AAPL | Stock | 48.435 | 48.4375 | 48.4125 | 48.42 | 11832.0 |
| 2019-04-03 08:00:00 | AAPL | Stock | 48.56 | 48.595 | 48.425 | 48.45 | 190948.0 |
| 2019-04-03 08:05:00 | AAPL | Stock | 48.47 | 48.47 | 48.39 | 48.39 | 47256.0 |
| 2019-04-03 08:10:00 | AAPL | Stock | 48.39 | 48.39 | 48.25 | 48.25 | 127540.0 |
| 2019-04-03 08:15:00 | AAPL | Stock | 48.2625 | 48.3125 | 48.2225 | 48.27 | 86304.0 |
| 2019-04-03 08:20:00 | AAPL | Stock | 48.27 | 48.3425 | 48.27 | 48.3125 | 24460.0 |
| 2019-04-03 08:25:00 | AAPL | Stock | 48.3125 | 48.3125 | 48.2875 | 48.305 | 10912.0 |
| 2019-04-03 08:30:00 | AAPL | Stock | 48.3125 | 48.3575 | 48.3 | 48.3 | 37864.0 |
| 2019-04-03 08:35:00 | AAPL | Stock | 48.3 | 48.3 | 48.2525 | 48.27 | 40832.0 |
| 2019-04-03 08:40:00 | AAPL | Stock | 48.31 | 48.3545 | 48.3025 | 48.325 | 15964.0 |
| 2019-04-03 08:45:00 | AAPL | Stock | 48.3475 | 48.35 | 48.3375 | 48.3375 | 7000.0 |
| 2019-04-03 08:50:00 | AAPL | Stock | 48.345 | 48.3575 | 48.3125 | 48.3375 | 18708.0 |
> showing 50 of 364,343 rows — these rows as CSV