PREVIEW / stock_5min / 2015-05-14
file: by_date/stock_5min/2015/2015-05-14.parquet size: 5.5 MB rows: 364,575 symbols: 3,511
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-05-14 04:00:00 | AAPL | Stock | 29.0 | 31.5025 | 29.0 | 31.5025 | 4000.0 |
| 2015-05-14 04:20:00 | AAPL | Stock | 31.5775 | 31.5775 | 31.5625 | 31.5625 | 3200.0 |
| 2015-05-14 04:30:00 | AAPL | Stock | 31.6075 | 31.61 | 31.6075 | 31.61 | 1500.0 |
| 2015-05-14 04:35:00 | AAPL | Stock | 31.6 | 31.62 | 31.6 | 31.6 | 4840.0 |
| 2015-05-14 04:40:00 | AAPL | Stock | 31.6 | 31.6 | 31.6 | 31.6 | 400.0 |
| 2015-05-14 04:50:00 | AAPL | Stock | 31.6275 | 31.63 | 31.6275 | 31.63 | 2884.0 |
| 2015-05-14 04:55:00 | AAPL | Stock | 31.63 | 31.63 | 31.63 | 31.63 | 2216.0 |
| 2015-05-14 05:15:00 | AAPL | Stock | 31.605 | 31.605 | 31.5625 | 31.5625 | 3532.0 |
| 2015-05-14 05:25:00 | AAPL | Stock | 31.625 | 31.625 | 31.625 | 31.625 | 400.0 |
| 2015-05-14 06:00:00 | AAPL | Stock | 31.5875 | 31.5875 | 31.5875 | 31.5875 | 800.0 |
| 2015-05-14 06:10:00 | AAPL | Stock | 31.6225 | 31.6225 | 31.6225 | 31.6225 | 400.0 |
| 2015-05-14 06:20:00 | AAPL | Stock | 31.6125 | 31.6125 | 31.6125 | 31.6125 | 2000.0 |
| 2015-05-14 06:25:00 | AAPL | Stock | 31.61 | 31.625 | 31.61 | 31.625 | 3032.0 |
| 2015-05-14 06:30:00 | AAPL | Stock | 31.6125 | 31.6125 | 31.6125 | 31.6125 | 6284.0 |
| 2015-05-14 06:40:00 | AAPL | Stock | 31.6125 | 31.6125 | 31.6125 | 31.6125 | 7200.0 |
| 2015-05-14 06:45:00 | AAPL | Stock | 31.6125 | 31.6125 | 31.61 | 31.6125 | 7200.0 |
| 2015-05-14 06:50:00 | AAPL | Stock | 31.61 | 31.6625 | 31.61 | 31.66 | 65332.0 |
| 2015-05-14 06:55:00 | AAPL | Stock | 31.6625 | 31.6825 | 31.6625 | 31.6825 | 11200.0 |
| 2015-05-14 07:00:00 | AAPL | Stock | 31.67 | 31.7125 | 31.67 | 31.6825 | 46904.0 |
| 2015-05-14 07:05:00 | AAPL | Stock | 31.6825 | 31.6825 | 31.655 | 31.66 | 42396.0 |
| 2015-05-14 07:10:00 | AAPL | Stock | 31.6575 | 31.6575 | 31.65 | 31.65 | 4800.0 |
| 2015-05-14 07:15:00 | AAPL | Stock | 31.66 | 31.7125 | 31.66 | 31.7125 | 30904.0 |
| 2015-05-14 07:20:00 | AAPL | Stock | 31.68 | 31.7 | 31.6575 | 31.6925 | 28200.0 |
| 2015-05-14 07:25:00 | AAPL | Stock | 31.6925 | 31.7075 | 31.69 | 31.7 | 16228.0 |
| 2015-05-14 07:30:00 | AAPL | Stock | 31.6925 | 31.7025 | 31.6925 | 31.7 | 20820.0 |
| 2015-05-14 07:35:00 | AAPL | Stock | 31.6875 | 31.6875 | 31.675 | 31.685 | 18800.0 |
| 2015-05-14 07:40:00 | AAPL | Stock | 31.6775 | 31.6775 | 31.655 | 31.675 | 27000.0 |
| 2015-05-14 07:45:00 | AAPL | Stock | 31.6775 | 31.7 | 31.6775 | 31.695 | 21200.0 |
| 2015-05-14 07:50:00 | AAPL | Stock | 31.6975 | 31.725 | 31.6925 | 31.725 | 54624.0 |
| 2015-05-14 07:55:00 | AAPL | Stock | 31.725 | 31.725 | 31.7175 | 31.7175 | 18684.0 |
| 2015-05-14 08:00:00 | AAPL | Stock | 31.715 | 31.7275 | 31.6525 | 31.7075 | 215692.0 |
| 2015-05-14 08:05:00 | AAPL | Stock | 31.7 | 31.7275 | 31.69 | 31.7275 | 106092.0 |
| 2015-05-14 08:10:00 | AAPL | Stock | 31.73 | 31.77 | 31.73 | 31.77 | 131780.0 |
| 2015-05-14 08:15:00 | AAPL | Stock | 31.76 | 31.76 | 31.7375 | 31.75 | 105060.0 |
| 2015-05-14 08:20:00 | AAPL | Stock | 31.75 | 31.7725 | 31.75 | 31.7725 | 62896.0 |
| 2015-05-14 08:25:00 | AAPL | Stock | 31.775 | 31.775 | 31.7575 | 31.7575 | 83252.0 |
| 2015-05-14 08:30:00 | AAPL | Stock | 31.7575 | 31.7875 | 31.7575 | 31.775 | 123108.0 |
| 2015-05-14 08:35:00 | AAPL | Stock | 31.775 | 31.7875 | 31.7725 | 31.7775 | 73992.0 |
| 2015-05-14 08:40:00 | AAPL | Stock | 31.775 | 31.775 | 31.7675 | 31.775 | 85900.0 |
| 2015-05-14 08:45:00 | AAPL | Stock | 31.7725 | 31.7875 | 31.7725 | 31.7775 | 53116.0 |
| 2015-05-14 08:50:00 | AAPL | Stock | 31.7775 | 31.8 | 31.7625 | 31.785 | 113936.0 |
| 2015-05-14 08:55:00 | AAPL | Stock | 31.785 | 31.7925 | 31.765 | 31.7825 | 66024.0 |
| 2015-05-14 09:00:00 | AAPL | Stock | 31.785 | 31.785 | 31.775 | 31.7825 | 20124.0 |
| 2015-05-14 09:05:00 | AAPL | Stock | 31.7775 | 31.795 | 31.775 | 31.795 | 76396.0 |
| 2015-05-14 09:10:00 | AAPL | Stock | 31.795 | 31.8075 | 31.7875 | 31.8 | 104020.0 |
| 2015-05-14 09:15:00 | AAPL | Stock | 31.8075 | 31.8475 | 31.8 | 31.8425 | 148208.0 |
| 2015-05-14 09:20:00 | AAPL | Stock | 31.8325 | 31.8625 | 31.7872 | 31.7875 | 176268.0 |
| 2015-05-14 09:25:00 | AAPL | Stock | 31.7825 | 31.8725 | 31.775 | 31.87 | 171332.0 |
| 2015-05-14 09:30:00 | AAPL | Stock | 31.855 | 31.9225 | 31.815 | 31.87 | 10118420.0 |
| 2015-05-14 09:35:00 | AAPL | Stock | 31.87 | 31.9275 | 31.825 | 31.8822 | 5008232.0 |
> showing 50 of 364,575 rows — these rows as CSV