PREVIEW / stock_5min / 2016-06-06
file: by_date/stock_5min/2016/2016-06-06.parquet size: 5.5 MB rows: 364,969 symbols: 3,316
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-06 04:25:00 | AAPL | Stock | 24.48 | 24.5425 | 24.48 | 24.5425 | 10700.0 |
| 2016-06-06 04:30:00 | AAPL | Stock | 24.48 | 24.48 | 24.48 | 24.48 | 920.0 |
| 2016-06-06 04:40:00 | AAPL | Stock | 24.5275 | 24.5275 | 24.5275 | 24.5275 | 800.0 |
| 2016-06-06 07:05:00 | AAPL | Stock | 24.5125 | 24.5125 | 24.5125 | 24.5125 | 2352.0 |
| 2016-06-06 07:10:00 | AAPL | Stock | 24.5125 | 24.5125 | 24.5125 | 24.5125 | 2400.0 |
| 2016-06-06 07:25:00 | AAPL | Stock | 24.5025 | 24.5025 | 24.5 | 24.5 | 4816.0 |
| 2016-06-06 07:35:00 | AAPL | Stock | 24.525 | 24.525 | 24.525 | 24.525 | 400.0 |
| 2016-06-06 07:45:00 | AAPL | Stock | 24.535 | 24.5375 | 24.525 | 24.525 | 4400.0 |
| 2016-06-06 07:50:00 | AAPL | Stock | 24.535 | 24.535 | 24.535 | 24.535 | 2000.0 |
| 2016-06-06 07:55:00 | AAPL | Stock | 24.5375 | 24.5375 | 24.5375 | 24.5375 | 468.0 |
| 2016-06-06 08:00:00 | AAPL | Stock | 24.5125 | 24.5225 | 24.485 | 24.5 | 30288.0 |
| 2016-06-06 08:05:00 | AAPL | Stock | 24.4875 | 24.505 | 24.4825 | 24.49 | 16200.0 |
| 2016-06-06 08:10:00 | AAPL | Stock | 24.4875 | 24.4975 | 24.4875 | 24.4875 | 12920.0 |
| 2016-06-06 08:15:00 | AAPL | Stock | 24.4975 | 24.5 | 24.4875 | 24.4875 | 6800.0 |
| 2016-06-06 08:20:00 | AAPL | Stock | 24.4875 | 24.4875 | 24.4825 | 24.4825 | 3600.0 |
| 2016-06-06 08:25:00 | AAPL | Stock | 24.4875 | 24.495 | 24.4725 | 24.495 | 13560.0 |
| 2016-06-06 08:30:00 | AAPL | Stock | 24.495 | 24.495 | 24.475 | 24.475 | 14600.0 |
| 2016-06-06 08:35:00 | AAPL | Stock | 24.48 | 24.48 | 24.4575 | 24.475 | 23448.0 |
| 2016-06-06 08:40:00 | AAPL | Stock | 24.465 | 24.48 | 24.46 | 24.4625 | 19900.0 |
| 2016-06-06 08:45:00 | AAPL | Stock | 24.46 | 24.4625 | 24.455 | 24.455 | 4800.0 |
| 2016-06-06 08:50:00 | AAPL | Stock | 24.46 | 24.46 | 24.425 | 24.43 | 71660.0 |
| 2016-06-06 08:55:00 | AAPL | Stock | 24.4375 | 24.495 | 24.4375 | 24.495 | 66264.0 |
| 2016-06-06 09:00:00 | AAPL | Stock | 24.475 | 24.4775 | 24.475 | 24.4775 | 2800.0 |
| 2016-06-06 09:05:00 | AAPL | Stock | 24.4775 | 24.4875 | 24.47 | 24.4875 | 8200.0 |
| 2016-06-06 09:10:00 | AAPL | Stock | 24.48 | 24.4825 | 24.475 | 24.4825 | 10920.0 |
| 2016-06-06 09:15:00 | AAPL | Stock | 24.4825 | 24.4825 | 24.4825 | 24.4825 | 10060.0 |
| 2016-06-06 09:20:00 | AAPL | Stock | 24.4775 | 24.4775 | 24.4725 | 24.4725 | 4008.0 |
| 2016-06-06 09:25:00 | AAPL | Stock | 24.46 | 24.5 | 24.45 | 24.4725 | 63844.0 |
| 2016-06-06 09:30:00 | AAPL | Stock | 24.4975 | 24.5125 | 24.3875 | 24.4598 | 4178176.0 |
| 2016-06-06 09:35:00 | AAPL | Stock | 24.4625 | 24.6382 | 24.4575 | 24.6382 | 3905972.0 |
| 2016-06-06 09:40:00 | AAPL | Stock | 24.6382 | 24.67 | 24.6025 | 24.6275 | 3106748.0 |
| 2016-06-06 09:45:00 | AAPL | Stock | 24.6275 | 24.71 | 24.616 | 24.6975 | 2939952.0 |
| 2016-06-06 09:50:00 | AAPL | Stock | 24.7 | 24.73 | 24.67 | 24.7122 | 2496048.0 |
| 2016-06-06 09:55:00 | AAPL | Stock | 24.7115 | 24.7115 | 24.655 | 24.6732 | 1722764.0 |
| 2016-06-06 10:00:00 | AAPL | Stock | 24.675 | 24.6975 | 24.6525 | 24.6675 | 1373032.0 |
| 2016-06-06 10:05:00 | AAPL | Stock | 24.6675 | 24.695 | 24.6625 | 24.6825 | 1222248.0 |
| 2016-06-06 10:10:00 | AAPL | Stock | 24.6825 | 24.6862 | 24.655 | 24.6712 | 1175528.0 |
| 2016-06-06 10:15:00 | AAPL | Stock | 24.6725 | 24.705 | 24.6725 | 24.685 | 1053404.0 |
| 2016-06-06 10:20:00 | AAPL | Stock | 24.685 | 24.69 | 24.6625 | 24.69 | 892428.0 |
| 2016-06-06 10:25:00 | AAPL | Stock | 24.6925 | 24.6925 | 24.6525 | 24.655 | 820092.0 |
| 2016-06-06 10:30:00 | AAPL | Stock | 24.655 | 24.6875 | 24.6525 | 24.6875 | 881216.0 |
| 2016-06-06 10:35:00 | AAPL | Stock | 24.6875 | 24.705 | 24.6825 | 24.6992 | 1042192.0 |
| 2016-06-06 10:40:00 | AAPL | Stock | 24.7 | 24.715 | 24.695 | 24.715 | 969832.0 |
| 2016-06-06 10:45:00 | AAPL | Stock | 24.715 | 24.73 | 24.7025 | 24.71 | 1001244.0 |
| 2016-06-06 10:50:00 | AAPL | Stock | 24.7115 | 24.72 | 24.705 | 24.715 | 855140.0 |
| 2016-06-06 10:55:00 | AAPL | Stock | 24.715 | 24.73 | 24.71 | 24.7248 | 664492.0 |
| 2016-06-06 11:00:00 | AAPL | Stock | 24.725 | 24.7275 | 24.71 | 24.725 | 844324.0 |
| 2016-06-06 11:05:00 | AAPL | Stock | 24.725 | 24.745 | 24.7125 | 24.7425 | 1507724.0 |
| 2016-06-06 11:10:00 | AAPL | Stock | 24.7425 | 24.7475 | 24.7275 | 24.7312 | 809336.0 |
| 2016-06-06 11:15:00 | AAPL | Stock | 24.7312 | 24.7325 | 24.715 | 24.7175 | 992492.0 |
> showing 50 of 364,969 rows — these rows as CSV