PREVIEW / stock_5min / 2014-09-24
file: by_date/stock_5min/2014/2014-09-24.parquet size: 5.4 MB rows: 354,866 symbols: 3,566
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-24 04:15:00 | AAPL | Stock | 25.595 | 25.595 | 25.5775 | 25.5775 | 800.0 |
| 2014-09-24 04:25:00 | AAPL | Stock | 25.575 | 25.575 | 25.5625 | 25.5625 | 3200.0 |
| 2014-09-24 04:35:00 | AAPL | Stock | 25.585 | 25.585 | 25.57 | 25.57 | 1528.0 |
| 2014-09-24 04:40:00 | AAPL | Stock | 25.6175 | 25.6175 | 25.6175 | 25.6175 | 800.0 |
| 2014-09-24 05:05:00 | AAPL | Stock | 25.575 | 25.575 | 25.575 | 25.575 | 400.0 |
| 2014-09-24 05:15:00 | AAPL | Stock | 25.575 | 25.575 | 25.575 | 25.575 | 480.0 |
| 2014-09-24 05:20:00 | AAPL | Stock | 25.605 | 25.605 | 25.605 | 25.605 | 2000.0 |
| 2014-09-24 05:35:00 | AAPL | Stock | 25.605 | 25.605 | 25.605 | 25.605 | 400.0 |
| 2014-09-24 05:40:00 | AAPL | Stock | 25.605 | 25.605 | 25.605 | 25.605 | 400.0 |
| 2014-09-24 05:45:00 | AAPL | Stock | 25.6125 | 25.6125 | 25.605 | 25.605 | 1200.0 |
| 2014-09-24 05:50:00 | AAPL | Stock | 25.6125 | 25.6125 | 25.6125 | 25.6125 | 1200.0 |
| 2014-09-24 05:55:00 | AAPL | Stock | 25.605 | 25.605 | 25.605 | 25.605 | 800.0 |
| 2014-09-24 06:00:00 | AAPL | Stock | 25.605 | 25.605 | 25.575 | 25.58 | 3260.0 |
| 2014-09-24 06:05:00 | AAPL | Stock | 25.58 | 25.58 | 25.58 | 25.58 | 476.0 |
| 2014-09-24 06:10:00 | AAPL | Stock | 25.58 | 25.585 | 25.575 | 25.585 | 2268.0 |
| 2014-09-24 06:25:00 | AAPL | Stock | 25.6025 | 25.63 | 25.5875 | 25.5875 | 6980.0 |
| 2014-09-24 06:30:00 | AAPL | Stock | 25.5875 | 25.635 | 25.585 | 25.615 | 13528.0 |
| 2014-09-24 06:35:00 | AAPL | Stock | 25.615 | 25.615 | 25.5875 | 25.5875 | 4000.0 |
| 2014-09-24 06:40:00 | AAPL | Stock | 25.6 | 25.6225 | 25.6 | 25.6225 | 800.0 |
| 2014-09-24 06:45:00 | AAPL | Stock | 25.595 | 25.605 | 25.5875 | 25.605 | 15200.0 |
| 2014-09-24 06:50:00 | AAPL | Stock | 25.605 | 25.605 | 25.5975 | 25.5975 | 2000.0 |
| 2014-09-24 06:55:00 | AAPL | Stock | 25.61 | 25.6125 | 25.5875 | 25.5875 | 17656.0 |
| 2014-09-24 07:00:00 | AAPL | Stock | 25.6075 | 25.6075 | 25.5025 | 25.5025 | 51564.0 |
| 2014-09-24 07:05:00 | AAPL | Stock | 25.505 | 25.535 | 25.475 | 25.525 | 95464.0 |
| 2014-09-24 07:10:00 | AAPL | Stock | 25.5225 | 25.55 | 25.5225 | 25.54 | 23656.0 |
| 2014-09-24 07:15:00 | AAPL | Stock | 25.555 | 25.555 | 25.4875 | 25.4875 | 47040.0 |
| 2014-09-24 07:20:00 | AAPL | Stock | 25.4975 | 25.52 | 25.485 | 25.4875 | 82672.0 |
| 2014-09-24 07:25:00 | AAPL | Stock | 25.4875 | 25.5 | 25.4825 | 25.4825 | 86604.0 |
| 2014-09-24 07:30:00 | AAPL | Stock | 25.495 | 25.5425 | 25.49 | 25.535 | 25864.0 |
| 2014-09-24 07:35:00 | AAPL | Stock | 25.535 | 25.55 | 25.5325 | 25.5425 | 52696.0 |
| 2014-09-24 07:40:00 | AAPL | Stock | 25.5425 | 25.545 | 25.5375 | 25.5375 | 11600.0 |
| 2014-09-24 07:45:00 | AAPL | Stock | 25.535 | 25.535 | 25.5125 | 25.5125 | 72512.0 |
| 2014-09-24 07:50:00 | AAPL | Stock | 25.5125 | 25.525 | 25.5025 | 25.525 | 53200.0 |
| 2014-09-24 07:55:00 | AAPL | Stock | 25.52 | 25.525 | 25.5125 | 25.525 | 52100.0 |
| 2014-09-24 08:00:00 | AAPL | Stock | 25.5125 | 25.66 | 25.485 | 25.535 | 8195764.0 |
| 2014-09-24 08:05:00 | AAPL | Stock | 25.535 | 25.55 | 25.535 | 25.5425 | 113612.0 |
| 2014-09-24 08:10:00 | AAPL | Stock | 25.5475 | 25.55 | 25.525 | 25.5375 | 120244.0 |
| 2014-09-24 08:15:00 | AAPL | Stock | 25.5325 | 25.5475 | 25.525 | 25.5275 | 90312.0 |
| 2014-09-24 08:20:00 | AAPL | Stock | 25.5225 | 25.5225 | 25.4875 | 25.4975 | 330488.0 |
| 2014-09-24 08:25:00 | AAPL | Stock | 25.49 | 25.51 | 25.4775 | 25.4975 | 136964.0 |
| 2014-09-24 08:30:00 | AAPL | Stock | 25.5 | 25.5 | 25.4625 | 25.47 | 174048.0 |
| 2014-09-24 08:35:00 | AAPL | Stock | 25.47 | 25.485 | 25.4625 | 25.47 | 114568.0 |
| 2014-09-24 08:40:00 | AAPL | Stock | 25.47 | 25.475 | 25.4575 | 25.465 | 82928.0 |
| 2014-09-24 08:45:00 | AAPL | Stock | 25.4675 | 25.495 | 25.465 | 25.4925 | 76148.0 |
| 2014-09-24 08:50:00 | AAPL | Stock | 25.4875 | 25.5175 | 25.4775 | 25.4875 | 136488.0 |
| 2014-09-24 08:55:00 | AAPL | Stock | 25.49 | 25.5 | 25.48 | 25.4975 | 103300.0 |
| 2014-09-24 09:00:00 | AAPL | Stock | 25.4975 | 25.505 | 25.4925 | 25.505 | 64172.0 |
| 2014-09-24 09:05:00 | AAPL | Stock | 25.5 | 25.5125 | 25.5 | 25.5025 | 99764.0 |
| 2014-09-24 09:10:00 | AAPL | Stock | 25.505 | 25.52 | 25.5 | 25.515 | 177492.0 |
| 2014-09-24 09:15:00 | AAPL | Stock | 25.515 | 25.53 | 25.515 | 25.525 | 60852.0 |
> showing 50 of 354,866 rows — these rows as CSV