PREVIEW / stock_5min / 2014-12-15
file: by_date/stock_5min/2014/2014-12-15.parquet size: 5.8 MB rows: 382,176 symbols: 3,563
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-12-15 04:00:00 | AAPL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 800.0 |
| 2014-12-15 04:10:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.5625 | 27.5625 | 1092.0 |
| 2014-12-15 04:15:00 | AAPL | Stock | 27.565 | 27.565 | 27.5625 | 27.5625 | 2000.0 |
| 2014-12-15 04:20:00 | AAPL | Stock | 27.6 | 27.6125 | 27.6 | 27.6125 | 18400.0 |
| 2014-12-15 04:25:00 | AAPL | Stock | 27.67 | 27.6875 | 27.67 | 27.6875 | 6000.0 |
| 2014-12-15 04:30:00 | AAPL | Stock | 27.655 | 27.655 | 27.6275 | 27.6275 | 12000.0 |
| 2014-12-15 04:40:00 | AAPL | Stock | 27.655 | 27.655 | 27.655 | 27.655 | 4800.0 |
| 2014-12-15 04:45:00 | AAPL | Stock | 27.635 | 27.635 | 27.635 | 27.635 | 800.0 |
| 2014-12-15 04:55:00 | AAPL | Stock | 27.6375 | 27.6375 | 27.6375 | 27.6375 | 1200.0 |
| 2014-12-15 05:05:00 | AAPL | Stock | 27.655 | 27.655 | 27.655 | 27.655 | 400.0 |
| 2014-12-15 05:10:00 | AAPL | Stock | 27.65 | 27.65 | 27.65 | 27.65 | 400.0 |
| 2014-12-15 05:15:00 | AAPL | Stock | 27.65 | 27.65 | 27.65 | 27.65 | 2400.0 |
| 2014-12-15 05:20:00 | AAPL | Stock | 27.65 | 27.65 | 27.65 | 27.65 | 2000.0 |
| 2014-12-15 05:35:00 | AAPL | Stock | 27.7 | 27.7 | 27.7 | 27.7 | 400.0 |
| 2014-12-15 05:55:00 | AAPL | Stock | 27.675 | 27.675 | 27.675 | 27.675 | 400.0 |
| 2014-12-15 06:00:00 | AAPL | Stock | 27.675 | 27.745 | 27.675 | 27.745 | 3708.0 |
| 2014-12-15 06:05:00 | AAPL | Stock | 27.6725 | 27.6725 | 27.67 | 27.67 | 1200.0 |
| 2014-12-15 06:10:00 | AAPL | Stock | 27.67 | 27.67 | 27.67 | 27.67 | 800.0 |
| 2014-12-15 06:25:00 | AAPL | Stock | 27.65 | 27.6675 | 27.635 | 27.635 | 1780.0 |
| 2014-12-15 06:30:00 | AAPL | Stock | 27.66 | 27.66 | 27.66 | 27.66 | 600.0 |
| 2014-12-15 06:50:00 | AAPL | Stock | 27.65 | 27.6625 | 27.65 | 27.6625 | 10960.0 |
| 2014-12-15 06:55:00 | AAPL | Stock | 27.66 | 27.6625 | 27.66 | 27.6625 | 12800.0 |
| 2014-12-15 07:00:00 | AAPL | Stock | 27.6525 | 27.6525 | 27.6325 | 27.6475 | 33440.0 |
| 2014-12-15 07:05:00 | AAPL | Stock | 27.6475 | 27.6475 | 27.6325 | 27.635 | 2800.0 |
| 2014-12-15 07:10:00 | AAPL | Stock | 27.635 | 27.6475 | 27.6325 | 27.645 | 20140.0 |
| 2014-12-15 07:15:00 | AAPL | Stock | 27.635 | 27.6625 | 27.625 | 27.6625 | 28332.0 |
| 2014-12-15 07:20:00 | AAPL | Stock | 27.66 | 27.66 | 27.65 | 27.66 | 7600.0 |
| 2014-12-15 07:25:00 | AAPL | Stock | 27.65 | 27.6625 | 27.65 | 27.6625 | 13920.0 |
| 2014-12-15 07:30:00 | AAPL | Stock | 27.6625 | 27.6825 | 27.6575 | 27.6575 | 67916.0 |
| 2014-12-15 07:35:00 | AAPL | Stock | 27.6725 | 27.68 | 27.6725 | 27.675 | 12884.0 |
| 2014-12-15 07:40:00 | AAPL | Stock | 27.6725 | 27.675 | 27.6725 | 27.6725 | 8116.0 |
| 2014-12-15 07:45:00 | AAPL | Stock | 27.6625 | 27.67 | 27.6625 | 27.67 | 4800.0 |
| 2014-12-15 07:50:00 | AAPL | Stock | 27.675 | 27.675 | 27.66 | 27.66 | 800.0 |
| 2014-12-15 07:55:00 | AAPL | Stock | 27.645 | 27.65 | 27.6425 | 27.6425 | 23920.0 |
| 2014-12-15 08:00:00 | AAPL | Stock | 27.6275 | 27.6825 | 27.625 | 27.6475 | 164892.0 |
| 2014-12-15 08:05:00 | AAPL | Stock | 27.6475 | 27.6875 | 27.6475 | 27.6775 | 170868.0 |
| 2014-12-15 08:10:00 | AAPL | Stock | 27.6775 | 27.68 | 27.6722 | 27.675 | 34600.0 |
| 2014-12-15 08:15:00 | AAPL | Stock | 27.6875 | 27.695 | 27.6625 | 27.6875 | 84548.0 |
| 2014-12-15 08:20:00 | AAPL | Stock | 27.685 | 27.685 | 27.6725 | 27.675 | 19056.0 |
| 2014-12-15 08:25:00 | AAPL | Stock | 27.68 | 27.68 | 27.675 | 27.6798 | 21916.0 |
| 2014-12-15 08:30:00 | AAPL | Stock | 27.675 | 27.675 | 27.6625 | 27.6725 | 42312.0 |
| 2014-12-15 08:35:00 | AAPL | Stock | 27.6725 | 27.6725 | 27.635 | 27.6375 | 119288.0 |
| 2014-12-15 08:40:00 | AAPL | Stock | 27.635 | 27.6375 | 27.6275 | 27.63 | 35432.0 |
| 2014-12-15 08:45:00 | AAPL | Stock | 27.6375 | 27.6375 | 27.62 | 27.62 | 82132.0 |
| 2014-12-15 08:50:00 | AAPL | Stock | 27.6225 | 27.6375 | 27.6225 | 27.63 | 50912.0 |
| 2014-12-15 08:55:00 | AAPL | Stock | 27.635 | 27.635 | 27.6 | 27.615 | 103172.0 |
| 2014-12-15 09:00:00 | AAPL | Stock | 27.605 | 27.63 | 27.605 | 27.615 | 41368.0 |
| 2014-12-15 09:05:00 | AAPL | Stock | 27.615 | 27.62 | 27.6 | 27.6075 | 123396.0 |
| 2014-12-15 09:10:00 | AAPL | Stock | 27.6075 | 27.6225 | 27.6 | 27.61 | 144624.0 |
| 2014-12-15 09:15:00 | AAPL | Stock | 27.6 | 27.615 | 27.4325 | 27.6125 | 80412.0 |
> showing 50 of 382,176 rows — these rows as CSV