PREVIEW / stock_5min / 2016-03-07
file: by_date/stock_5min/2016/2016-03-07.parquet size: 5.6 MB rows: 368,982 symbols: 3,366
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-07 04:00:00 | AAPL | Stock | 25.7525 | 25.7525 | 25.7525 | 25.7525 | 2000.0 |
| 2016-03-07 05:00:00 | AAPL | Stock | 25.6675 | 25.6675 | 25.6675 | 25.6675 | 800.0 |
| 2016-03-07 05:05:00 | AAPL | Stock | 25.6575 | 25.6625 | 25.6575 | 25.6625 | 12800.0 |
| 2016-03-07 05:10:00 | AAPL | Stock | 25.6325 | 25.6375 | 25.6325 | 25.6375 | 2800.0 |
| 2016-03-07 05:20:00 | AAPL | Stock | 25.7025 | 25.7075 | 25.6375 | 25.6375 | 2580.0 |
| 2016-03-07 05:25:00 | AAPL | Stock | 25.645 | 25.685 | 25.63 | 25.685 | 5560.0 |
| 2016-03-07 05:30:00 | AAPL | Stock | 25.685 | 25.69 | 25.685 | 25.69 | 6460.0 |
| 2016-03-07 05:35:00 | AAPL | Stock | 25.64 | 25.64 | 25.63 | 25.63 | 2400.0 |
| 2016-03-07 05:45:00 | AAPL | Stock | 25.63 | 25.63 | 25.63 | 25.63 | 1860.0 |
| 2016-03-07 06:10:00 | AAPL | Stock | 25.6575 | 25.6575 | 25.655 | 25.655 | 6400.0 |
| 2016-03-07 06:15:00 | AAPL | Stock | 25.655 | 25.7125 | 25.6425 | 25.6425 | 28120.0 |
| 2016-03-07 06:20:00 | AAPL | Stock | 25.7 | 25.72 | 25.7 | 25.72 | 26400.0 |
| 2016-03-07 06:25:00 | AAPL | Stock | 25.72 | 25.75 | 25.7175 | 25.75 | 13744.0 |
| 2016-03-07 06:30:00 | AAPL | Stock | 25.725 | 25.725 | 25.725 | 25.725 | 5740.0 |
| 2016-03-07 06:35:00 | AAPL | Stock | 25.7225 | 25.725 | 25.7225 | 25.725 | 1228.0 |
| 2016-03-07 06:40:00 | AAPL | Stock | 25.7275 | 25.7275 | 25.725 | 25.725 | 7720.0 |
| 2016-03-07 06:50:00 | AAPL | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 3608.0 |
| 2016-03-07 06:55:00 | AAPL | Stock | 25.7375 | 25.7375 | 25.7275 | 25.7275 | 2772.0 |
| 2016-03-07 07:00:00 | AAPL | Stock | 25.7275 | 25.7275 | 25.725 | 25.725 | 23060.0 |
| 2016-03-07 07:05:00 | AAPL | Stock | 25.7375 | 25.7375 | 25.7375 | 25.7375 | 4640.0 |
| 2016-03-07 07:10:00 | AAPL | Stock | 25.725 | 25.75 | 25.725 | 25.75 | 3244.0 |
| 2016-03-07 07:15:00 | AAPL | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 5688.0 |
| 2016-03-07 07:20:00 | AAPL | Stock | 25.7275 | 25.7475 | 25.7275 | 25.7475 | 3200.0 |
| 2016-03-07 07:25:00 | AAPL | Stock | 25.7475 | 25.77 | 25.7475 | 25.77 | 43500.0 |
| 2016-03-07 07:30:00 | AAPL | Stock | 25.7725 | 25.795 | 25.75 | 25.75 | 61288.0 |
| 2016-03-07 07:45:00 | AAPL | Stock | 25.775 | 25.78 | 25.7725 | 25.775 | 25344.0 |
| 2016-03-07 07:50:00 | AAPL | Stock | 25.775 | 25.7775 | 25.7725 | 25.775 | 7040.0 |
| 2016-03-07 07:55:00 | AAPL | Stock | 25.775 | 25.795 | 25.775 | 25.795 | 17000.0 |
| 2016-03-07 08:00:00 | AAPL | Stock | 25.7725 | 25.795 | 25.7525 | 25.7875 | 101068.0 |
| 2016-03-07 08:05:00 | AAPL | Stock | 25.775 | 25.775 | 25.76 | 25.7625 | 18444.0 |
| 2016-03-07 08:10:00 | AAPL | Stock | 25.77 | 25.795 | 25.77 | 25.795 | 32200.0 |
| 2016-03-07 08:15:00 | AAPL | Stock | 25.7825 | 25.7875 | 25.765 | 25.7875 | 38880.0 |
| 2016-03-07 08:20:00 | AAPL | Stock | 25.795 | 25.795 | 25.7625 | 25.7675 | 33880.0 |
| 2016-03-07 08:25:00 | AAPL | Stock | 25.7625 | 25.7725 | 25.76 | 25.76 | 32044.0 |
| 2016-03-07 08:30:00 | AAPL | Stock | 25.755 | 25.765 | 25.75 | 25.75 | 28528.0 |
| 2016-03-07 08:35:00 | AAPL | Stock | 25.75 | 25.75 | 25.7125 | 25.715 | 75052.0 |
| 2016-03-07 08:40:00 | AAPL | Stock | 25.715 | 25.72 | 25.7075 | 25.715 | 36688.0 |
| 2016-03-07 08:45:00 | AAPL | Stock | 25.71 | 25.72 | 25.71 | 25.7125 | 16720.0 |
| 2016-03-07 08:50:00 | AAPL | Stock | 25.72 | 25.7225 | 25.7075 | 25.7075 | 13200.0 |
| 2016-03-07 08:55:00 | AAPL | Stock | 25.72 | 25.725 | 25.7125 | 25.725 | 29540.0 |
| 2016-03-07 09:00:00 | AAPL | Stock | 25.73 | 25.73 | 25.7125 | 25.7125 | 27120.0 |
| 2016-03-07 09:05:00 | AAPL | Stock | 25.7125 | 25.7125 | 25.7 | 25.7 | 21692.0 |
| 2016-03-07 09:10:00 | AAPL | Stock | 25.705 | 25.705 | 25.685 | 25.6875 | 62180.0 |
| 2016-03-07 09:15:00 | AAPL | Stock | 25.6775 | 25.6775 | 25.6575 | 25.675 | 37796.0 |
| 2016-03-07 09:20:00 | AAPL | Stock | 25.675 | 25.675 | 25.6625 | 25.675 | 82224.0 |
| 2016-03-07 09:25:00 | AAPL | Stock | 25.6675 | 25.67 | 25.5925 | 25.5925 | 146136.0 |
| 2016-03-07 09:30:00 | AAPL | Stock | 25.595 | 25.6625 | 25.5275 | 25.5712 | 7481752.0 |
| 2016-03-07 09:35:00 | AAPL | Stock | 25.5722 | 25.63 | 25.5712 | 25.5925 | 2801644.0 |
| 2016-03-07 09:40:00 | AAPL | Stock | 25.59 | 25.7 | 25.58 | 25.6875 | 3239960.0 |
| 2016-03-07 09:45:00 | AAPL | Stock | 25.6875 | 25.7075 | 25.6525 | 25.655 | 2169844.0 |
> showing 50 of 368,982 rows — these rows as CSV