PREVIEW / stock_5min / 2013-10-14
file: by_date/stock_5min/2013/2013-10-14.parquet size: 5.0 MB rows: 332,761 symbols: 3,512
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-14 04:00:00 | AAPL | Stock | 17.2789 | 17.5361 | 17.2789 | 17.5 | 19180.0 |
| 2013-10-14 04:05:00 | AAPL | Stock | 17.5289 | 17.5304 | 17.5007 | 17.5007 | 28000.0 |
| 2013-10-14 04:15:00 | AAPL | Stock | 17.5043 | 17.5179 | 17.5043 | 17.5179 | 11200.0 |
| 2013-10-14 04:30:00 | AAPL | Stock | 17.5014 | 17.5054 | 17.4946 | 17.4946 | 69244.0 |
| 2013-10-14 04:35:00 | AAPL | Stock | 17.4946 | 17.4946 | 17.4893 | 17.4893 | 34720.0 |
| 2013-10-14 04:40:00 | AAPL | Stock | 17.4718 | 17.4718 | 17.4718 | 17.4718 | 4200.0 |
| 2013-10-14 04:50:00 | AAPL | Stock | 17.4825 | 17.4893 | 17.4825 | 17.4893 | 5600.0 |
| 2013-10-14 04:55:00 | AAPL | Stock | 17.4754 | 17.4754 | 17.4732 | 17.4732 | 12600.0 |
| 2013-10-14 05:00:00 | AAPL | Stock | 17.4746 | 17.4746 | 17.4746 | 17.4746 | 5600.0 |
| 2013-10-14 05:05:00 | AAPL | Stock | 17.4739 | 17.4739 | 17.4739 | 17.4739 | 22400.0 |
| 2013-10-14 05:15:00 | AAPL | Stock | 17.4886 | 17.4939 | 17.4886 | 17.4939 | 5600.0 |
| 2013-10-14 06:05:00 | AAPL | Stock | 17.5054 | 17.5054 | 17.5054 | 17.5054 | 2800.0 |
| 2013-10-14 06:10:00 | AAPL | Stock | 17.4968 | 17.4968 | 17.4968 | 17.4968 | 2800.0 |
| 2013-10-14 06:15:00 | AAPL | Stock | 17.4964 | 17.4964 | 17.4964 | 17.4964 | 7840.0 |
| 2013-10-14 06:20:00 | AAPL | Stock | 17.5114 | 17.5118 | 17.5114 | 17.5118 | 16800.0 |
| 2013-10-14 07:00:00 | AAPL | Stock | 17.5054 | 17.5164 | 17.5036 | 17.5164 | 51800.0 |
| 2013-10-14 07:10:00 | AAPL | Stock | 17.5082 | 17.5082 | 17.5082 | 17.5082 | 9100.0 |
| 2013-10-14 07:15:00 | AAPL | Stock | 17.5082 | 17.5089 | 17.5082 | 17.5089 | 12600.0 |
| 2013-10-14 07:20:00 | AAPL | Stock | 17.5111 | 17.5193 | 17.5111 | 17.5193 | 5600.0 |
| 2013-10-14 07:25:00 | AAPL | Stock | 17.5 | 17.5014 | 17.4946 | 17.5014 | 71876.0 |
| 2013-10-14 07:30:00 | AAPL | Stock | 17.5075 | 17.5075 | 17.5075 | 17.5075 | 11200.0 |
| 2013-10-14 07:35:00 | AAPL | Stock | 17.5039 | 17.5039 | 17.5039 | 17.5039 | 5600.0 |
| 2013-10-14 07:45:00 | AAPL | Stock | 17.4943 | 17.4943 | 17.4629 | 17.4639 | 105952.0 |
| 2013-10-14 07:50:00 | AAPL | Stock | 17.4664 | 17.4904 | 17.4518 | 17.4625 | 182560.0 |
| 2013-10-14 07:55:00 | AAPL | Stock | 17.4718 | 17.4839 | 17.4718 | 17.4839 | 35280.0 |
| 2013-10-14 08:00:00 | AAPL | Stock | 17.4714 | 17.5089 | 17.4379 | 17.4486 | 558880.0 |
| 2013-10-14 08:05:00 | AAPL | Stock | 17.4618 | 17.4643 | 17.4282 | 17.4282 | 427476.0 |
| 2013-10-14 08:10:00 | AAPL | Stock | 17.4264 | 17.4464 | 17.4196 | 17.4339 | 297472.0 |
| 2013-10-14 08:15:00 | AAPL | Stock | 17.435 | 17.46 | 17.435 | 17.4579 | 44800.0 |
| 2013-10-14 08:20:00 | AAPL | Stock | 17.4482 | 17.4575 | 17.4314 | 17.4382 | 107100.0 |
| 2013-10-14 08:25:00 | AAPL | Stock | 17.455 | 17.4596 | 17.445 | 17.4596 | 94920.0 |
| 2013-10-14 08:30:00 | AAPL | Stock | 17.4589 | 17.4714 | 17.4518 | 17.4643 | 72380.0 |
| 2013-10-14 08:35:00 | AAPL | Stock | 17.4711 | 17.4718 | 17.4679 | 17.4718 | 84000.0 |
| 2013-10-14 08:40:00 | AAPL | Stock | 17.4714 | 17.4743 | 17.4679 | 17.4707 | 63280.0 |
| 2013-10-14 08:45:00 | AAPL | Stock | 17.4675 | 17.4721 | 17.4643 | 17.4654 | 156688.0 |
| 2013-10-14 08:50:00 | AAPL | Stock | 17.4761 | 17.4868 | 17.4721 | 17.4868 | 64400.0 |
| 2013-10-14 08:55:00 | AAPL | Stock | 17.485 | 17.5061 | 17.4821 | 17.4954 | 121436.0 |
| 2013-10-14 09:00:00 | AAPL | Stock | 17.4957 | 17.4957 | 17.4704 | 17.4704 | 92176.0 |
| 2013-10-14 09:05:00 | AAPL | Stock | 17.4768 | 17.4925 | 17.4729 | 17.4886 | 92904.0 |
| 2013-10-14 09:10:00 | AAPL | Stock | 17.4904 | 17.4904 | 17.4821 | 17.4857 | 41384.0 |
| 2013-10-14 09:15:00 | AAPL | Stock | 17.4879 | 17.4893 | 17.4821 | 17.4893 | 68040.0 |
| 2013-10-14 09:20:00 | AAPL | Stock | 17.4857 | 17.4893 | 17.4789 | 17.4857 | 54460.0 |
| 2013-10-14 09:25:00 | AAPL | Stock | 17.4868 | 17.5004 | 17.48 | 17.4832 | 359996.0 |
| 2013-10-14 09:30:00 | AAPL | Stock | 17.4911 | 17.5807 | 17.4768 | 17.5746 | 13606964.0 |
| 2013-10-14 09:35:00 | AAPL | Stock | 17.5743 | 17.6536 | 17.5739 | 17.5954 | 10927140.0 |
| 2013-10-14 09:40:00 | AAPL | Stock | 17.5954 | 17.6696 | 17.5918 | 17.6679 | 8134448.0 |
| 2013-10-14 09:45:00 | AAPL | Stock | 17.6675 | 17.7021 | 17.6629 | 17.69 | 9456440.0 |
| 2013-10-14 09:50:00 | AAPL | Stock | 17.6875 | 17.7246 | 17.6789 | 17.7229 | 7745108.0 |
| 2013-10-14 09:55:00 | AAPL | Stock | 17.7232 | 17.7464 | 17.7118 | 17.7425 | 7852236.0 |
| 2013-10-14 10:00:00 | AAPL | Stock | 17.7425 | 17.76 | 17.7221 | 17.7443 | 6124216.0 |
> showing 50 of 332,761 rows — these rows as CSV