PREVIEW / stock_5min / 2018-01-11
file: by_date/stock_5min/2018/2018-01-11.parquet size: 5.8 MB rows: 368,934 symbols: 2,906
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 |
|---|---|---|---|---|---|---|---|
| 2018-01-11 04:00:00 | AAPL | Stock | 43.62 | 43.62 | 43.62 | 43.62 | 400.0 |
| 2018-01-11 04:55:00 | AAPL | Stock | 43.5725 | 43.5725 | 43.5725 | 43.5725 | 400.0 |
| 2018-01-11 05:05:00 | AAPL | Stock | 43.5625 | 43.5625 | 43.5625 | 43.5625 | 3200.0 |
| 2018-01-11 05:45:00 | AAPL | Stock | 43.5575 | 43.5575 | 43.5575 | 43.5575 | 1200.0 |
| 2018-01-11 05:55:00 | AAPL | Stock | 43.5025 | 43.5025 | 43.5 | 43.5 | 2800.0 |
| 2018-01-11 06:30:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 400.0 |
| 2018-01-11 06:35:00 | AAPL | Stock | 43.55 | 43.55 | 43.55 | 43.55 | 400.0 |
| 2018-01-11 06:50:00 | AAPL | Stock | 43.525 | 43.525 | 43.525 | 43.525 | 2000.0 |
| 2018-01-11 07:00:00 | AAPL | Stock | 43.595 | 43.595 | 43.595 | 43.595 | 796.0 |
| 2018-01-11 07:05:00 | AAPL | Stock | 43.575 | 43.62 | 43.575 | 43.62 | 1096.0 |
| 2018-01-11 07:10:00 | AAPL | Stock | 43.6225 | 43.625 | 43.6 | 43.6175 | 4064.0 |
| 2018-01-11 07:15:00 | AAPL | Stock | 43.6325 | 43.6525 | 43.6325 | 43.64 | 5820.0 |
| 2018-01-11 07:20:00 | AAPL | Stock | 43.6375 | 43.6375 | 43.6375 | 43.6375 | 664.0 |
| 2018-01-11 07:25:00 | AAPL | Stock | 43.62 | 43.6825 | 43.585 | 43.6575 | 23780.0 |
| 2018-01-11 07:30:00 | AAPL | Stock | 43.6825 | 43.6875 | 43.6825 | 43.6875 | 3220.0 |
| 2018-01-11 07:35:00 | AAPL | Stock | 43.6875 | 43.6875 | 43.6725 | 43.68 | 3200.0 |
| 2018-01-11 07:40:00 | AAPL | Stock | 43.68 | 43.68 | 43.675 | 43.68 | 4400.0 |
| 2018-01-11 07:45:00 | AAPL | Stock | 43.675 | 43.6825 | 43.6625 | 43.6825 | 11600.0 |
| 2018-01-11 07:55:00 | AAPL | Stock | 43.6825 | 43.6825 | 43.675 | 43.675 | 5824.0 |
| 2018-01-11 08:00:00 | AAPL | Stock | 43.675 | 43.695 | 43.5775 | 43.655 | 31156.0 |
| 2018-01-11 08:05:00 | AAPL | Stock | 43.6525 | 43.68 | 43.65 | 43.68 | 18160.0 |
| 2018-01-11 08:10:00 | AAPL | Stock | 43.6875 | 43.7 | 43.685 | 43.6875 | 18944.0 |
| 2018-01-11 08:15:00 | AAPL | Stock | 43.69 | 43.69 | 43.665 | 43.68 | 19804.0 |
| 2018-01-11 08:20:00 | AAPL | Stock | 43.68 | 43.68 | 43.6775 | 43.6775 | 15600.0 |
| 2018-01-11 08:30:00 | AAPL | Stock | 43.68 | 43.68 | 43.6575 | 43.675 | 8828.0 |
| 2018-01-11 08:35:00 | AAPL | Stock | 43.6725 | 43.6725 | 43.655 | 43.655 | 27652.0 |
| 2018-01-11 08:40:00 | AAPL | Stock | 43.67 | 43.6725 | 43.65 | 43.65 | 6412.0 |
| 2018-01-11 08:45:00 | AAPL | Stock | 43.65 | 43.655 | 43.625 | 43.6475 | 27352.0 |
| 2018-01-11 08:50:00 | AAPL | Stock | 43.6275 | 43.64 | 43.625 | 43.6325 | 4500.0 |
| 2018-01-11 08:55:00 | AAPL | Stock | 43.6425 | 43.65 | 43.6425 | 43.65 | 5380.0 |
| 2018-01-11 09:00:00 | AAPL | Stock | 43.6475 | 43.65 | 43.645 | 43.65 | 11768.0 |
| 2018-01-11 09:05:00 | AAPL | Stock | 43.6725 | 43.675 | 43.6675 | 43.6675 | 6188.0 |
| 2018-01-11 09:10:00 | AAPL | Stock | 43.6675 | 43.6675 | 43.635 | 43.635 | 8292.0 |
| 2018-01-11 09:15:00 | AAPL | Stock | 43.635 | 43.635 | 43.6125 | 43.6125 | 23396.0 |
| 2018-01-11 09:20:00 | AAPL | Stock | 43.62 | 43.65 | 43.62 | 43.65 | 14236.0 |
| 2018-01-11 09:25:00 | AAPL | Stock | 43.65 | 43.65 | 43.585 | 43.6475 | 28928.0 |
| 2018-01-11 09:30:00 | AAPL | Stock | 43.6475 | 43.835 | 43.6225 | 43.8262 | 4529296.0 |
| 2018-01-11 09:35:00 | AAPL | Stock | 43.8275 | 43.865 | 43.7525 | 43.77 | 2737112.0 |
| 2018-01-11 09:40:00 | AAPL | Stock | 43.77 | 43.87 | 43.7 | 43.845 | 2090376.0 |
| 2018-01-11 09:45:00 | AAPL | Stock | 43.845 | 43.855 | 43.7425 | 43.8175 | 1434828.0 |
| 2018-01-11 09:50:00 | AAPL | Stock | 43.8175 | 43.83 | 43.755 | 43.8 | 1004576.0 |
| 2018-01-11 09:55:00 | AAPL | Stock | 43.795 | 43.8078 | 43.75 | 43.775 | 852856.0 |
| 2018-01-11 10:00:00 | AAPL | Stock | 43.7775 | 43.8722 | 43.77 | 43.82 | 1693920.0 |
| 2018-01-11 10:05:00 | AAPL | Stock | 43.8188 | 43.84 | 43.7642 | 43.8013 | 731556.0 |
| 2018-01-11 10:10:00 | AAPL | Stock | 43.8 | 43.83 | 43.7775 | 43.7838 | 899352.0 |
| 2018-01-11 10:15:00 | AAPL | Stock | 43.7845 | 43.8 | 43.7725 | 43.7958 | 615584.0 |
| 2018-01-11 10:20:00 | AAPL | Stock | 43.7958 | 43.8 | 43.705 | 43.7375 | 1409148.0 |
| 2018-01-11 10:25:00 | AAPL | Stock | 43.7375 | 43.7875 | 43.7375 | 43.7525 | 523408.0 |
| 2018-01-11 10:30:00 | AAPL | Stock | 43.7525 | 43.7862 | 43.7225 | 43.725 | 775620.0 |
| 2018-01-11 10:35:00 | AAPL | Stock | 43.725 | 43.785 | 43.7075 | 43.7825 | 723364.0 |
> showing 50 of 368,934 rows — these rows as CSV