PREVIEW / stock_5min / 2019-05-07
file: by_date/stock_5min/2019/2019-05-07.parquet size: 5.7 MB rows: 357,641 symbols: 2,598
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-05-07 04:15:00 | AAPL | Stock | 51.9675 | 51.9675 | 51.9675 | 51.9675 | 400.0 |
| 2019-05-07 04:20:00 | AAPL | Stock | 51.925 | 51.925 | 51.925 | 51.925 | 2000.0 |
| 2019-05-07 04:25:00 | AAPL | Stock | 51.9925 | 51.9925 | 51.9925 | 51.9925 | 800.0 |
| 2019-05-07 04:30:00 | AAPL | Stock | 51.95 | 51.95 | 51.95 | 51.95 | 400.0 |
| 2019-05-07 04:40:00 | AAPL | Stock | 51.97 | 51.97 | 51.97 | 51.97 | 1400.0 |
| 2019-05-07 04:50:00 | AAPL | Stock | 51.9275 | 51.9275 | 51.925 | 51.925 | 3928.0 |
| 2019-05-07 04:55:00 | AAPL | Stock | 51.9 | 51.9 | 51.9 | 51.9 | 1980.0 |
| 2019-05-07 05:05:00 | AAPL | Stock | 51.8875 | 51.8875 | 51.85 | 51.85 | 6156.0 |
| 2019-05-07 05:10:00 | AAPL | Stock | 51.875 | 51.875 | 51.875 | 51.875 | 800.0 |
| 2019-05-07 05:30:00 | AAPL | Stock | 51.85 | 51.85 | 51.85 | 51.85 | 2800.0 |
| 2019-05-07 05:35:00 | AAPL | Stock | 51.83 | 51.83 | 51.83 | 51.83 | 400.0 |
| 2019-05-07 05:55:00 | AAPL | Stock | 51.85 | 51.85 | 51.85 | 51.85 | 400.0 |
| 2019-05-07 06:00:00 | AAPL | Stock | 51.875 | 51.875 | 51.875 | 51.875 | 2000.0 |
| 2019-05-07 06:15:00 | AAPL | Stock | 51.85 | 51.85 | 51.85 | 51.85 | 400.0 |
| 2019-05-07 06:20:00 | AAPL | Stock | 51.85 | 51.85 | 51.85 | 51.85 | 400.0 |
| 2019-05-07 06:25:00 | AAPL | Stock | 51.85 | 51.85 | 51.8425 | 51.8425 | 3172.0 |
| 2019-05-07 06:45:00 | AAPL | Stock | 51.8925 | 51.8925 | 51.8925 | 51.8925 | 400.0 |
| 2019-05-07 06:50:00 | AAPL | Stock | 51.8425 | 51.8425 | 51.8425 | 51.8425 | 1400.0 |
| 2019-05-07 06:55:00 | AAPL | Stock | 51.8125 | 51.8125 | 51.81 | 51.8125 | 8944.0 |
| 2019-05-07 07:00:00 | AAPL | Stock | 51.81 | 51.81 | 51.7 | 51.725 | 27920.0 |
| 2019-05-07 07:05:00 | AAPL | Stock | 51.7225 | 51.725 | 51.6825 | 51.7 | 5976.0 |
| 2019-05-07 07:10:00 | AAPL | Stock | 51.705 | 51.705 | 51.6675 | 51.67 | 44188.0 |
| 2019-05-07 07:15:00 | AAPL | Stock | 51.685 | 51.7375 | 51.685 | 51.7375 | 6004.0 |
| 2019-05-07 07:20:00 | AAPL | Stock | 51.75 | 51.76 | 51.75 | 51.76 | 800.0 |
| 2019-05-07 07:25:00 | AAPL | Stock | 51.775 | 51.7875 | 51.77 | 51.7725 | 7128.0 |
| 2019-05-07 07:30:00 | AAPL | Stock | 51.7725 | 51.8025 | 51.7725 | 51.8025 | 3952.0 |
| 2019-05-07 07:35:00 | AAPL | Stock | 51.81 | 51.8425 | 51.8025 | 51.8175 | 17804.0 |
| 2019-05-07 07:40:00 | AAPL | Stock | 51.8125 | 51.845 | 51.7925 | 51.8075 | 8120.0 |
| 2019-05-07 07:45:00 | AAPL | Stock | 51.82 | 51.825 | 51.82 | 51.825 | 2152.0 |
| 2019-05-07 07:50:00 | AAPL | Stock | 51.795 | 51.795 | 51.6775 | 51.735 | 63384.0 |
| 2019-05-07 07:55:00 | AAPL | Stock | 51.7125 | 51.7125 | 51.635 | 51.6625 | 23164.0 |
| 2019-05-07 08:00:00 | AAPL | Stock | 51.7032 | 51.845 | 51.5575 | 51.5755 | 127100.0 |
| 2019-05-07 08:05:00 | AAPL | Stock | 51.6 | 51.65 | 51.6 | 51.63 | 24852.0 |
| 2019-05-07 08:10:00 | AAPL | Stock | 51.665 | 51.71 | 51.6625 | 51.6875 | 18180.0 |
| 2019-05-07 08:15:00 | AAPL | Stock | 51.69 | 51.75 | 51.69 | 51.7475 | 24692.0 |
| 2019-05-07 08:20:00 | AAPL | Stock | 51.7425 | 51.7425 | 51.6875 | 51.6875 | 4000.0 |
| 2019-05-07 08:25:00 | AAPL | Stock | 51.725 | 51.785 | 51.725 | 51.75 | 22560.0 |
| 2019-05-07 08:30:00 | AAPL | Stock | 51.7375 | 51.7875 | 51.7375 | 51.77 | 11216.0 |
| 2019-05-07 08:35:00 | AAPL | Stock | 51.7775 | 51.7875 | 51.75 | 51.75 | 14700.0 |
| 2019-05-07 08:40:00 | AAPL | Stock | 51.75 | 51.769 | 51.715 | 51.769 | 18564.0 |
| 2019-05-07 08:45:00 | AAPL | Stock | 51.7375 | 51.765 | 51.69 | 51.725 | 21860.0 |
| 2019-05-07 08:50:00 | AAPL | Stock | 51.7225 | 51.74 | 51.685 | 51.6875 | 48960.0 |
| 2019-05-07 08:55:00 | AAPL | Stock | 51.7 | 51.7 | 51.6625 | 51.6725 | 17612.0 |
| 2019-05-07 09:00:00 | AAPL | Stock | 51.6525 | 51.6725 | 51.5875 | 51.5875 | 63792.0 |
| 2019-05-07 09:05:00 | AAPL | Stock | 51.612 | 51.612 | 51.4275 | 51.495 | 149144.0 |
| 2019-05-07 09:10:00 | AAPL | Stock | 51.4625 | 51.5175 | 51.4425 | 51.5125 | 50516.0 |
| 2019-05-07 09:15:00 | AAPL | Stock | 51.5225 | 51.575 | 51.5125 | 51.5475 | 95980.0 |
| 2019-05-07 09:20:00 | AAPL | Stock | 51.52 | 51.525 | 51.4375 | 51.52 | 57672.0 |
| 2019-05-07 09:25:00 | AAPL | Stock | 51.52 | 51.5625 | 51.465 | 51.465 | 54828.0 |
| 2019-05-07 09:30:00 | AAPL | Stock | 51.4825 | 51.8545 | 51.425 | 51.6488 | 5482696.0 |
> showing 50 of 357,641 rows — these rows as CSV