PREVIEW / stock_5min / 2019-09-03
file: by_date/stock_5min/2019/2019-09-03.parquet size: 5.6 MB rows: 361,027 symbols: 2,560
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-09-03 04:00:00 | AAPL | Stock | 51.425 | 51.67 | 51.365 | 51.515 | 5964.0 |
| 2019-09-03 04:05:00 | AAPL | Stock | 51.575 | 51.575 | 51.575 | 51.575 | 1200.0 |
| 2019-09-03 04:10:00 | AAPL | Stock | 51.6875 | 51.7275 | 51.6875 | 51.7275 | 1600.0 |
| 2019-09-03 04:15:00 | AAPL | Stock | 51.8475 | 51.8475 | 51.7975 | 51.7975 | 960.0 |
| 2019-09-03 04:20:00 | AAPL | Stock | 51.6875 | 51.725 | 51.675 | 51.675 | 3600.0 |
| 2019-09-03 04:25:00 | AAPL | Stock | 51.68 | 51.68 | 51.68 | 51.68 | 404.0 |
| 2019-09-03 04:30:00 | AAPL | Stock | 51.68 | 51.68 | 51.6275 | 51.6275 | 7224.0 |
| 2019-09-03 04:35:00 | AAPL | Stock | 51.6675 | 51.6675 | 51.6675 | 51.6675 | 4472.0 |
| 2019-09-03 04:50:00 | AAPL | Stock | 51.6275 | 51.6275 | 51.6275 | 51.6275 | 400.0 |
| 2019-09-03 05:00:00 | AAPL | Stock | 51.7325 | 51.75 | 51.7 | 51.7 | 9560.0 |
| 2019-09-03 05:05:00 | AAPL | Stock | 51.7 | 51.7625 | 51.7 | 51.7625 | 9200.0 |
| 2019-09-03 05:15:00 | AAPL | Stock | 51.75 | 51.775 | 51.75 | 51.75 | 23000.0 |
| 2019-09-03 05:25:00 | AAPL | Stock | 51.7575 | 51.7575 | 51.625 | 51.63 | 3492.0 |
| 2019-09-03 05:40:00 | AAPL | Stock | 51.55 | 51.55 | 51.5275 | 51.5275 | 4100.0 |
| 2019-09-03 05:55:00 | AAPL | Stock | 51.49 | 51.525 | 51.45 | 51.45 | 4480.0 |
| 2019-09-03 06:00:00 | AAPL | Stock | 51.45 | 51.5875 | 51.425 | 51.5875 | 4000.0 |
| 2019-09-03 06:05:00 | AAPL | Stock | 51.5875 | 51.5875 | 51.5 | 51.5 | 852.0 |
| 2019-09-03 06:15:00 | AAPL | Stock | 51.5425 | 51.5425 | 51.5425 | 51.5425 | 400.0 |
| 2019-09-03 06:35:00 | AAPL | Stock | 51.575 | 51.575 | 51.575 | 51.575 | 800.0 |
| 2019-09-03 06:45:00 | AAPL | Stock | 51.595 | 51.675 | 51.565 | 51.565 | 5976.0 |
| 2019-09-03 06:50:00 | AAPL | Stock | 51.565 | 51.625 | 51.565 | 51.625 | 1200.0 |
| 2019-09-03 07:00:00 | AAPL | Stock | 51.575 | 51.75 | 51.575 | 51.6925 | 9188.0 |
| 2019-09-03 07:05:00 | AAPL | Stock | 51.625 | 51.625 | 51.5625 | 51.6 | 4800.0 |
| 2019-09-03 07:10:00 | AAPL | Stock | 51.6 | 51.625 | 51.6 | 51.625 | 10196.0 |
| 2019-09-03 07:20:00 | AAPL | Stock | 51.6625 | 51.6725 | 51.6625 | 51.6725 | 2444.0 |
| 2019-09-03 07:25:00 | AAPL | Stock | 51.625 | 51.6325 | 51.605 | 51.6325 | 12500.0 |
| 2019-09-03 07:30:00 | AAPL | Stock | 51.6325 | 51.6625 | 51.625 | 51.6275 | 6992.0 |
| 2019-09-03 07:35:00 | AAPL | Stock | 51.6625 | 51.675 | 51.6475 | 51.65 | 36776.0 |
| 2019-09-03 07:40:00 | AAPL | Stock | 51.655 | 51.675 | 51.6375 | 51.675 | 5820.0 |
| 2019-09-03 07:45:00 | AAPL | Stock | 51.645 | 51.6725 | 51.59 | 51.63 | 20804.0 |
| 2019-09-03 07:50:00 | AAPL | Stock | 51.625 | 51.625 | 51.5625 | 51.5625 | 11456.0 |
| 2019-09-03 07:55:00 | AAPL | Stock | 51.59 | 51.59 | 51.5775 | 51.5775 | 3736.0 |
| 2019-09-03 08:00:00 | AAPL | Stock | 51.625 | 51.675 | 51.55 | 51.62 | 124872.0 |
| 2019-09-03 08:05:00 | AAPL | Stock | 51.6125 | 51.62 | 51.55 | 51.57 | 15880.0 |
| 2019-09-03 08:10:00 | AAPL | Stock | 51.57 | 51.57 | 51.5025 | 51.525 | 18224.0 |
| 2019-09-03 08:15:00 | AAPL | Stock | 51.545 | 51.5625 | 51.525 | 51.54 | 19664.0 |
| 2019-09-03 08:20:00 | AAPL | Stock | 51.5625 | 51.565 | 51.525 | 51.525 | 17980.0 |
| 2019-09-03 08:25:00 | AAPL | Stock | 51.52 | 51.65 | 51.5025 | 51.65 | 43520.0 |
| 2019-09-03 08:30:00 | AAPL | Stock | 51.645 | 51.65 | 51.6025 | 51.6125 | 13860.0 |
| 2019-09-03 08:35:00 | AAPL | Stock | 51.6075 | 51.77 | 51.6075 | 51.7 | 41992.0 |
| 2019-09-03 08:40:00 | AAPL | Stock | 51.6775 | 51.7125 | 51.6575 | 51.6808 | 19076.0 |
| 2019-09-03 08:45:00 | AAPL | Stock | 51.735 | 51.735 | 51.65 | 51.6775 | 19500.0 |
| 2019-09-03 08:50:00 | AAPL | Stock | 51.675 | 51.715 | 51.5875 | 51.5875 | 26096.0 |
| 2019-09-03 08:55:00 | AAPL | Stock | 51.5875 | 51.5875 | 51.55 | 51.585 | 10408.0 |
| 2019-09-03 09:00:00 | AAPL | Stock | 51.585 | 51.615 | 51.5525 | 51.5525 | 19152.0 |
| 2019-09-03 09:05:00 | AAPL | Stock | 51.5932 | 51.6075 | 51.5575 | 51.5575 | 6908.0 |
| 2019-09-03 09:10:00 | AAPL | Stock | 51.55 | 51.625 | 51.54 | 51.6 | 31108.0 |
| 2019-09-03 09:15:00 | AAPL | Stock | 51.6 | 51.6575 | 51.575 | 51.575 | 14088.0 |
| 2019-09-03 09:20:00 | AAPL | Stock | 51.6 | 51.6 | 51.5625 | 51.5625 | 17608.0 |
| 2019-09-03 09:25:00 | AAPL | Stock | 51.6 | 51.705 | 51.5875 | 51.605 | 30172.0 |
> showing 50 of 361,027 rows — these rows as CSV