PREVIEW / stock_5min / 2015-03-10
file: by_date/stock_5min/2015/2015-03-10.parquet size: 5.6 MB rows: 369,165 symbols: 3,505
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-03-10 04:00:00 | AAPL | Stock | 31.7625 | 32.0 | 31.7625 | 31.785 | 6400.0 |
| 2015-03-10 04:05:00 | AAPL | Stock | 31.7575 | 31.7575 | 31.7575 | 31.7575 | 400.0 |
| 2015-03-10 04:55:00 | AAPL | Stock | 31.6475 | 31.67 | 31.6475 | 31.67 | 2800.0 |
| 2015-03-10 05:05:00 | AAPL | Stock | 31.68 | 31.68 | 31.6775 | 31.6775 | 1600.0 |
| 2015-03-10 05:10:00 | AAPL | Stock | 31.6925 | 31.6925 | 31.685 | 31.685 | 5708.0 |
| 2015-03-10 05:15:00 | AAPL | Stock | 31.6375 | 31.6375 | 31.6375 | 31.6375 | 2000.0 |
| 2015-03-10 05:20:00 | AAPL | Stock | 31.6275 | 31.6275 | 31.595 | 31.595 | 8756.0 |
| 2015-03-10 05:25:00 | AAPL | Stock | 31.6025 | 31.6025 | 31.575 | 31.5825 | 6404.0 |
| 2015-03-10 05:30:00 | AAPL | Stock | 31.59 | 31.59 | 31.57 | 31.57 | 3200.0 |
| 2015-03-10 05:35:00 | AAPL | Stock | 31.5925 | 31.5925 | 31.5925 | 31.5925 | 800.0 |
| 2015-03-10 05:40:00 | AAPL | Stock | 31.565 | 31.565 | 31.565 | 31.565 | 400.0 |
| 2015-03-10 05:45:00 | AAPL | Stock | 31.575 | 31.575 | 31.575 | 31.575 | 844.0 |
| 2015-03-10 05:50:00 | AAPL | Stock | 31.55 | 31.55 | 31.55 | 31.55 | 1660.0 |
| 2015-03-10 05:55:00 | AAPL | Stock | 31.5925 | 31.6025 | 31.5925 | 31.6 | 12400.0 |
| 2015-03-10 06:00:00 | AAPL | Stock | 31.6 | 31.6 | 31.56 | 31.575 | 3800.0 |
| 2015-03-10 06:05:00 | AAPL | Stock | 31.5625 | 31.5625 | 31.5625 | 31.5625 | 4000.0 |
| 2015-03-10 06:10:00 | AAPL | Stock | 31.54 | 31.54 | 31.5025 | 31.5025 | 10400.0 |
| 2015-03-10 06:15:00 | AAPL | Stock | 31.5 | 31.5175 | 31.5 | 31.5 | 6508.0 |
| 2015-03-10 06:20:00 | AAPL | Stock | 31.5 | 31.5 | 31.4675 | 31.48 | 6000.0 |
| 2015-03-10 06:25:00 | AAPL | Stock | 31.4575 | 31.5 | 31.4575 | 31.5 | 6636.0 |
| 2015-03-10 06:30:00 | AAPL | Stock | 31.52 | 31.5425 | 31.52 | 31.54 | 12200.0 |
| 2015-03-10 06:35:00 | AAPL | Stock | 31.5375 | 31.5425 | 31.525 | 31.5425 | 1212.0 |
| 2015-03-10 06:40:00 | AAPL | Stock | 31.5 | 31.56 | 31.5 | 31.56 | 4240.0 |
| 2015-03-10 06:45:00 | AAPL | Stock | 31.56 | 31.5625 | 31.525 | 31.5375 | 22000.0 |
| 2015-03-10 06:50:00 | AAPL | Stock | 31.5625 | 31.595 | 31.5625 | 31.5625 | 21600.0 |
| 2015-03-10 07:00:00 | AAPL | Stock | 31.5975 | 31.6 | 31.5375 | 31.55 | 18044.0 |
| 2015-03-10 07:05:00 | AAPL | Stock | 31.5475 | 31.6125 | 31.525 | 31.6125 | 11804.0 |
| 2015-03-10 07:10:00 | AAPL | Stock | 31.5625 | 31.575 | 31.525 | 31.55 | 25100.0 |
| 2015-03-10 07:15:00 | AAPL | Stock | 31.55 | 31.55 | 31.495 | 31.495 | 15292.0 |
| 2015-03-10 07:20:00 | AAPL | Stock | 31.5025 | 31.5375 | 31.5025 | 31.525 | 20176.0 |
| 2015-03-10 07:25:00 | AAPL | Stock | 31.53 | 31.53 | 31.4775 | 31.5025 | 74288.0 |
| 2015-03-10 07:30:00 | AAPL | Stock | 31.525 | 31.5875 | 31.5025 | 31.575 | 26816.0 |
| 2015-03-10 07:35:00 | AAPL | Stock | 31.565 | 31.5875 | 31.5575 | 31.5875 | 16956.0 |
| 2015-03-10 07:40:00 | AAPL | Stock | 31.5975 | 31.6375 | 31.5975 | 31.615 | 101144.0 |
| 2015-03-10 07:45:00 | AAPL | Stock | 31.6175 | 31.6225 | 31.6 | 31.6025 | 26908.0 |
| 2015-03-10 07:50:00 | AAPL | Stock | 31.6025 | 31.685 | 31.6 | 31.65 | 53704.0 |
| 2015-03-10 07:55:00 | AAPL | Stock | 31.64 | 31.655 | 31.615 | 31.615 | 16084.0 |
| 2015-03-10 08:00:00 | AAPL | Stock | 31.6175 | 31.655 | 31.5 | 31.65 | 231656.0 |
| 2015-03-10 08:05:00 | AAPL | Stock | 31.645 | 31.685 | 31.6325 | 31.675 | 87184.0 |
| 2015-03-10 08:10:00 | AAPL | Stock | 31.685 | 31.72 | 31.6725 | 31.7 | 129324.0 |
| 2015-03-10 08:15:00 | AAPL | Stock | 31.6875 | 31.6975 | 31.645 | 31.6525 | 65120.0 |
| 2015-03-10 08:20:00 | AAPL | Stock | 31.655 | 31.66 | 31.6 | 31.61 | 96444.0 |
| 2015-03-10 08:25:00 | AAPL | Stock | 31.62 | 31.62 | 31.58 | 31.6 | 94656.0 |
| 2015-03-10 08:30:00 | AAPL | Stock | 31.595 | 31.6 | 31.5475 | 31.5825 | 196828.0 |
| 2015-03-10 08:35:00 | AAPL | Stock | 31.585 | 31.625 | 31.575 | 31.6075 | 90276.0 |
| 2015-03-10 08:40:00 | AAPL | Stock | 31.61 | 31.61 | 31.575 | 31.575 | 103140.0 |
| 2015-03-10 08:45:00 | AAPL | Stock | 31.5725 | 31.5975 | 31.5725 | 31.5875 | 85848.0 |
| 2015-03-10 08:50:00 | AAPL | Stock | 31.595 | 31.64 | 31.59 | 31.625 | 84328.0 |
| 2015-03-10 08:55:00 | AAPL | Stock | 31.6275 | 31.63 | 31.605 | 31.61 | 25380.0 |
| 2015-03-10 09:00:00 | AAPL | Stock | 31.605 | 31.605 | 31.5625 | 31.57 | 101420.0 |
> showing 50 of 369,165 rows — these rows as CSV