PREVIEW / stock_5min / 2013-06-11
file: by_date/stock_5min/2013/2013-06-11.parquet size: 5.1 MB rows: 341,478 symbols: 3,495
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-06-11 04:00:00 | AAPL | Stock | 15.6764 | 15.6764 | 15.6764 | 15.6764 | 8400.0 |
| 2013-06-11 06:00:00 | AAPL | Stock | 15.6036 | 15.6036 | 15.6036 | 15.6036 | 2800.0 |
| 2013-06-11 06:10:00 | AAPL | Stock | 15.6032 | 15.6032 | 15.6032 | 15.6032 | 2800.0 |
| 2013-06-11 06:40:00 | AAPL | Stock | 15.5821 | 15.5821 | 15.5714 | 15.5714 | 19600.0 |
| 2013-06-11 06:45:00 | AAPL | Stock | 15.5607 | 15.5607 | 15.5354 | 15.5354 | 52920.0 |
| 2013-06-11 06:50:00 | AAPL | Stock | 15.5339 | 15.5339 | 15.5339 | 15.5339 | 2800.0 |
| 2013-06-11 06:55:00 | AAPL | Stock | 15.5464 | 15.5464 | 15.5429 | 15.5429 | 8400.0 |
| 2013-06-11 07:00:00 | AAPL | Stock | 15.5371 | 15.5532 | 15.5371 | 15.5532 | 32340.0 |
| 2013-06-11 07:05:00 | AAPL | Stock | 15.5625 | 15.5625 | 15.5625 | 15.5625 | 2800.0 |
| 2013-06-11 07:10:00 | AAPL | Stock | 15.555 | 15.5554 | 15.5529 | 15.5554 | 8400.0 |
| 2013-06-11 07:15:00 | AAPL | Stock | 15.5489 | 15.5493 | 15.5357 | 15.5357 | 57820.0 |
| 2013-06-11 07:20:00 | AAPL | Stock | 15.5321 | 15.5321 | 15.525 | 15.525 | 57120.0 |
| 2013-06-11 07:25:00 | AAPL | Stock | 15.5339 | 15.5339 | 15.5339 | 15.5339 | 2800.0 |
| 2013-06-11 07:30:00 | AAPL | Stock | 15.5496 | 15.5496 | 15.5382 | 15.5382 | 25200.0 |
| 2013-06-11 07:35:00 | AAPL | Stock | 15.5375 | 15.5618 | 15.5375 | 15.5618 | 28280.0 |
| 2013-06-11 07:40:00 | AAPL | Stock | 15.5604 | 15.5611 | 15.5536 | 15.5571 | 13608.0 |
| 2013-06-11 07:45:00 | AAPL | Stock | 15.5604 | 15.5604 | 15.5604 | 15.5604 | 2800.0 |
| 2013-06-11 07:50:00 | AAPL | Stock | 15.5614 | 15.5786 | 15.5614 | 15.5786 | 41608.0 |
| 2013-06-11 07:55:00 | AAPL | Stock | 15.5718 | 15.5764 | 15.5679 | 15.5764 | 48860.0 |
| 2013-06-11 08:00:00 | AAPL | Stock | 15.5714 | 15.6036 | 15.5189 | 15.5714 | 258720.0 |
| 2013-06-11 08:05:00 | AAPL | Stock | 15.5714 | 15.7143 | 15.5711 | 15.5714 | 136920.0 |
| 2013-06-11 08:10:00 | AAPL | Stock | 15.5646 | 15.5893 | 15.5646 | 15.5818 | 141904.0 |
| 2013-06-11 08:15:00 | AAPL | Stock | 15.5857 | 15.5893 | 15.575 | 15.575 | 228200.0 |
| 2013-06-11 08:20:00 | AAPL | Stock | 15.5732 | 15.5754 | 15.5614 | 15.5661 | 146048.0 |
| 2013-06-11 08:25:00 | AAPL | Stock | 15.5564 | 15.5636 | 15.5429 | 15.5429 | 104804.0 |
| 2013-06-11 08:30:00 | AAPL | Stock | 15.545 | 15.5589 | 15.5411 | 15.5511 | 226660.0 |
| 2013-06-11 08:35:00 | AAPL | Stock | 15.5532 | 15.5536 | 15.5375 | 15.5518 | 56112.0 |
| 2013-06-11 08:40:00 | AAPL | Stock | 15.5454 | 15.5521 | 15.5446 | 15.5521 | 98420.0 |
| 2013-06-11 08:45:00 | AAPL | Stock | 15.5529 | 15.5536 | 15.5446 | 15.5464 | 211092.0 |
| 2013-06-11 08:50:00 | AAPL | Stock | 15.545 | 15.5536 | 15.545 | 15.5507 | 109844.0 |
| 2013-06-11 08:55:00 | AAPL | Stock | 15.5504 | 15.5536 | 15.5446 | 15.5536 | 184464.0 |
| 2013-06-11 09:00:00 | AAPL | Stock | 15.5518 | 15.5996 | 15.5518 | 15.5996 | 209244.0 |
| 2013-06-11 09:05:00 | AAPL | Stock | 15.5996 | 15.6046 | 15.5889 | 15.5896 | 123340.0 |
| 2013-06-11 09:10:00 | AAPL | Stock | 15.5986 | 15.6286 | 15.5964 | 15.6157 | 262108.0 |
| 2013-06-11 09:15:00 | AAPL | Stock | 15.6107 | 15.6261 | 15.6107 | 15.6111 | 69104.0 |
| 2013-06-11 09:20:00 | AAPL | Stock | 15.6111 | 15.6111 | 15.5893 | 15.5936 | 236936.0 |
| 2013-06-11 09:25:00 | AAPL | Stock | 15.5961 | 15.6118 | 15.5657 | 15.5679 | 522984.0 |
| 2013-06-11 09:30:00 | AAPL | Stock | 15.5679 | 15.6439 | 15.535 | 15.5375 | 17229772.0 |
| 2013-06-11 09:35:00 | AAPL | Stock | 15.54 | 15.5464 | 15.4757 | 15.5126 | 11777892.0 |
| 2013-06-11 09:40:00 | AAPL | Stock | 15.5075 | 15.5779 | 15.5071 | 15.5539 | 6751024.0 |
| 2013-06-11 09:45:00 | AAPL | Stock | 15.5539 | 15.6321 | 15.5357 | 15.5821 | 8212736.0 |
| 2013-06-11 09:50:00 | AAPL | Stock | 15.5854 | 15.6729 | 15.5714 | 15.6546 | 7954324.0 |
| 2013-06-11 09:55:00 | AAPL | Stock | 15.6546 | 15.7518 | 15.6154 | 15.7229 | 13869744.0 |
| 2013-06-11 10:00:00 | AAPL | Stock | 15.7189 | 15.7857 | 15.7189 | 15.7464 | 11857580.0 |
| 2013-06-11 10:05:00 | AAPL | Stock | 15.7414 | 15.7868 | 15.7279 | 15.7286 | 9167368.0 |
| 2013-06-11 10:10:00 | AAPL | Stock | 15.7286 | 15.7353 | 15.69 | 15.72 | 7440328.0 |
| 2013-06-11 10:15:00 | AAPL | Stock | 15.7207 | 15.7282 | 15.69 | 15.7268 | 4748716.0 |
| 2013-06-11 10:20:00 | AAPL | Stock | 15.7211 | 15.7979 | 15.7104 | 15.7846 | 7439964.0 |
| 2013-06-11 10:25:00 | AAPL | Stock | 15.7795 | 15.7809 | 15.7361 | 15.7575 | 5035408.0 |
| 2013-06-11 10:30:00 | AAPL | Stock | 15.7575 | 15.7743 | 15.7436 | 15.7621 | 4707668.0 |
> showing 50 of 341,478 rows — these rows as CSV