PREVIEW / stock_5min / 2015-10-13
file: by_date/stock_5min/2015/2015-10-13.parquet size: 5.2 MB rows: 345,654 symbols: 3,417
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-13 04:00:00 | AAPL | Stock | 27.7625 | 27.7625 | 27.7625 | 27.7625 | 400.0 |
| 2015-10-13 04:05:00 | AAPL | Stock | 27.7275 | 27.7275 | 27.7275 | 27.7275 | 1380.0 |
| 2015-10-13 04:10:00 | AAPL | Stock | 27.7 | 27.7 | 27.675 | 27.68 | 2000.0 |
| 2015-10-13 04:20:00 | AAPL | Stock | 27.7 | 27.7 | 27.7 | 27.7 | 400.0 |
| 2015-10-13 04:25:00 | AAPL | Stock | 27.715 | 27.715 | 27.715 | 27.715 | 400.0 |
| 2015-10-13 04:30:00 | AAPL | Stock | 27.7 | 27.7 | 27.7 | 27.7 | 3916.0 |
| 2015-10-13 04:40:00 | AAPL | Stock | 27.72 | 27.72 | 27.72 | 27.72 | 400.0 |
| 2015-10-13 05:00:00 | AAPL | Stock | 27.6925 | 27.6925 | 27.6925 | 27.6925 | 3200.0 |
| 2015-10-13 05:40:00 | AAPL | Stock | 27.7075 | 27.7475 | 27.7075 | 27.7425 | 2000.0 |
| 2015-10-13 06:00:00 | AAPL | Stock | 27.755 | 27.755 | 27.755 | 27.755 | 800.0 |
| 2015-10-13 06:10:00 | AAPL | Stock | 27.73 | 27.73 | 27.73 | 27.73 | 800.0 |
| 2015-10-13 06:25:00 | AAPL | Stock | 27.7475 | 27.7475 | 27.7475 | 27.7475 | 400.0 |
| 2015-10-13 06:50:00 | AAPL | Stock | 27.73 | 27.73 | 27.73 | 27.73 | 5088.0 |
| 2015-10-13 06:55:00 | AAPL | Stock | 27.7475 | 27.7475 | 27.7475 | 27.7475 | 7740.0 |
| 2015-10-13 07:05:00 | AAPL | Stock | 27.7675 | 27.7675 | 27.7675 | 27.7675 | 800.0 |
| 2015-10-13 07:10:00 | AAPL | Stock | 27.775 | 27.7825 | 27.775 | 27.775 | 8100.0 |
| 2015-10-13 07:15:00 | AAPL | Stock | 27.7575 | 27.78 | 27.755 | 27.7625 | 14988.0 |
| 2015-10-13 07:25:00 | AAPL | Stock | 27.7675 | 27.77 | 27.7675 | 27.77 | 800.0 |
| 2015-10-13 07:30:00 | AAPL | Stock | 27.7575 | 27.7575 | 27.75 | 27.7525 | 3720.0 |
| 2015-10-13 07:35:00 | AAPL | Stock | 27.755 | 27.7575 | 27.7475 | 27.7575 | 21892.0 |
| 2015-10-13 07:40:00 | AAPL | Stock | 27.75 | 27.75 | 27.7375 | 27.74 | 5600.0 |
| 2015-10-13 07:45:00 | AAPL | Stock | 27.7475 | 27.75 | 27.7375 | 27.7375 | 5708.0 |
| 2015-10-13 07:50:00 | AAPL | Stock | 27.7475 | 27.7475 | 27.745 | 27.745 | 800.0 |
| 2015-10-13 08:00:00 | AAPL | Stock | 27.75 | 27.775 | 27.725 | 27.775 | 462524.0 |
| 2015-10-13 08:05:00 | AAPL | Stock | 27.77 | 27.77 | 27.7625 | 27.7625 | 9048.0 |
| 2015-10-13 08:10:00 | AAPL | Stock | 27.7625 | 27.79 | 27.76 | 27.785 | 8664.0 |
| 2015-10-13 08:15:00 | AAPL | Stock | 27.7975 | 27.8 | 27.785 | 27.8 | 34972.0 |
| 2015-10-13 08:20:00 | AAPL | Stock | 27.7875 | 27.7975 | 27.785 | 27.785 | 1688.0 |
| 2015-10-13 08:25:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7675 | 27.7675 | 26280.0 |
| 2015-10-13 08:30:00 | AAPL | Stock | 27.7675 | 27.7775 | 27.7675 | 27.775 | 9980.0 |
| 2015-10-13 08:35:00 | AAPL | Stock | 27.77 | 27.7775 | 27.77 | 27.7775 | 4400.0 |
| 2015-10-13 08:40:00 | AAPL | Stock | 27.7825 | 27.785 | 27.7675 | 27.7675 | 18188.0 |
| 2015-10-13 08:45:00 | AAPL | Stock | 27.775 | 27.775 | 27.775 | 27.775 | 5860.0 |
| 2015-10-13 08:50:00 | AAPL | Stock | 27.775 | 27.7775 | 27.75 | 27.75 | 54860.0 |
| 2015-10-13 08:55:00 | AAPL | Stock | 27.75 | 27.755 | 27.73 | 27.7375 | 54176.0 |
| 2015-10-13 09:00:00 | AAPL | Stock | 27.7425 | 27.7575 | 27.7375 | 27.7375 | 6960.0 |
| 2015-10-13 09:05:00 | AAPL | Stock | 27.745 | 27.745 | 27.7275 | 27.735 | 3600.0 |
| 2015-10-13 09:10:00 | AAPL | Stock | 27.7275 | 27.735 | 27.725 | 27.725 | 46776.0 |
| 2015-10-13 09:15:00 | AAPL | Stock | 27.725 | 27.725 | 27.7025 | 27.705 | 37868.0 |
| 2015-10-13 09:20:00 | AAPL | Stock | 27.7025 | 27.73 | 27.7 | 27.7275 | 37144.0 |
| 2015-10-13 09:25:00 | AAPL | Stock | 27.725 | 27.775 | 27.7 | 27.7075 | 90564.0 |
| 2015-10-13 09:30:00 | AAPL | Stock | 27.705 | 27.7575 | 27.67 | 27.7575 | 4563504.0 |
| 2015-10-13 09:35:00 | AAPL | Stock | 27.755 | 27.8525 | 27.7475 | 27.8475 | 2740876.0 |
| 2015-10-13 09:40:00 | AAPL | Stock | 27.85 | 27.8575 | 27.775 | 27.8325 | 3142384.0 |
| 2015-10-13 09:45:00 | AAPL | Stock | 27.8325 | 27.9075 | 27.7975 | 27.9025 | 2566720.0 |
| 2015-10-13 09:50:00 | AAPL | Stock | 27.905 | 27.965 | 27.8925 | 27.9125 | 3451132.0 |
| 2015-10-13 09:55:00 | AAPL | Stock | 27.9125 | 27.94 | 27.8875 | 27.9338 | 1606928.0 |
| 2015-10-13 10:00:00 | AAPL | Stock | 27.9338 | 27.939 | 27.8125 | 27.89 | 3119556.0 |
| 2015-10-13 10:05:00 | AAPL | Stock | 27.89 | 27.9075 | 27.8475 | 27.8925 | 1566252.0 |
| 2015-10-13 10:10:00 | AAPL | Stock | 27.895 | 27.92 | 27.8775 | 27.8825 | 2053824.0 |
> showing 50 of 345,654 rows — these rows as CSV