PREVIEW / stock_5min / 2014-03-07
file: by_date/stock_5min/2014/2014-03-07.parquet size: 5.5 MB rows: 362,844 symbols: 3,554
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-03-07 04:05:00 | AAPL | Stock | 18.9557 | 18.9557 | 18.9554 | 18.9554 | 5600.0 |
| 2014-03-07 06:20:00 | AAPL | Stock | 18.9554 | 18.9554 | 18.9554 | 18.9554 | 5600.0 |
| 2014-03-07 06:35:00 | AAPL | Stock | 18.9796 | 18.9796 | 18.9796 | 18.9796 | 14000.0 |
| 2014-03-07 07:05:00 | AAPL | Stock | 18.9786 | 18.9786 | 18.9786 | 18.9786 | 2800.0 |
| 2014-03-07 07:10:00 | AAPL | Stock | 18.9739 | 18.9786 | 18.9739 | 18.9764 | 14000.0 |
| 2014-03-07 07:50:00 | AAPL | Stock | 18.9646 | 18.9646 | 18.9646 | 18.9646 | 2800.0 |
| 2014-03-07 08:00:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 2800.0 |
| 2014-03-07 08:05:00 | AAPL | Stock | 18.9589 | 18.9589 | 18.9589 | 18.9589 | 14000.0 |
| 2014-03-07 08:10:00 | AAPL | Stock | 18.9571 | 18.9571 | 18.9429 | 18.9429 | 31360.0 |
| 2014-03-07 08:15:00 | AAPL | Stock | 18.9321 | 18.9321 | 18.9196 | 18.9196 | 30632.0 |
| 2014-03-07 08:20:00 | AAPL | Stock | 18.9179 | 18.9179 | 18.8929 | 18.8929 | 59388.0 |
| 2014-03-07 08:25:00 | AAPL | Stock | 18.8929 | 18.91 | 18.8929 | 18.9086 | 24892.0 |
| 2014-03-07 08:30:00 | AAPL | Stock | 18.9179 | 18.975 | 18.8986 | 18.9732 | 424172.0 |
| 2014-03-07 08:35:00 | AAPL | Stock | 18.9682 | 18.9857 | 18.9682 | 18.9732 | 207844.0 |
| 2014-03-07 08:40:00 | AAPL | Stock | 18.98 | 18.9957 | 18.98 | 18.9821 | 106904.0 |
| 2014-03-07 08:45:00 | AAPL | Stock | 18.9889 | 18.9925 | 18.9729 | 18.9729 | 47852.0 |
| 2014-03-07 08:50:00 | AAPL | Stock | 18.975 | 18.9818 | 18.9714 | 18.9818 | 53060.0 |
| 2014-03-07 08:55:00 | AAPL | Stock | 18.975 | 18.975 | 18.9729 | 18.9736 | 25004.0 |
| 2014-03-07 09:00:00 | AAPL | Stock | 18.9664 | 18.9707 | 18.9614 | 18.9632 | 66780.0 |
| 2014-03-07 09:05:00 | AAPL | Stock | 18.9643 | 18.9654 | 18.9582 | 18.9607 | 144900.0 |
| 2014-03-07 09:10:00 | AAPL | Stock | 18.9707 | 18.9768 | 18.9643 | 18.9696 | 131376.0 |
| 2014-03-07 09:15:00 | AAPL | Stock | 18.9732 | 18.9732 | 18.9732 | 18.9732 | 12740.0 |
| 2014-03-07 09:20:00 | AAPL | Stock | 18.9671 | 18.9671 | 18.9607 | 18.9607 | 135996.0 |
| 2014-03-07 09:25:00 | AAPL | Stock | 18.9607 | 18.9843 | 18.9607 | 18.9761 | 188944.0 |
| 2014-03-07 09:30:00 | AAPL | Stock | 18.97 | 18.9993 | 18.9375 | 18.9415 | 9053212.0 |
| 2014-03-07 09:35:00 | AAPL | Stock | 18.9479 | 18.9761 | 18.9043 | 18.9139 | 5983208.0 |
| 2014-03-07 09:40:00 | AAPL | Stock | 18.9111 | 18.9404 | 18.8665 | 18.8796 | 5516308.0 |
| 2014-03-07 09:45:00 | AAPL | Stock | 18.8814 | 18.9029 | 18.8464 | 18.8468 | 5501888.0 |
| 2014-03-07 09:50:00 | AAPL | Stock | 18.8464 | 18.8711 | 18.8111 | 18.8711 | 8557976.0 |
| 2014-03-07 09:55:00 | AAPL | Stock | 18.8707 | 18.8768 | 18.8432 | 18.8642 | 3121972.0 |
| 2014-03-07 10:00:00 | AAPL | Stock | 18.8616 | 18.8768 | 18.8429 | 18.8679 | 3039092.0 |
| 2014-03-07 10:05:00 | AAPL | Stock | 18.8686 | 18.9007 | 18.8464 | 18.8861 | 3715096.0 |
| 2014-03-07 10:10:00 | AAPL | Stock | 18.8896 | 18.9025 | 18.8796 | 18.9 | 2014180.0 |
| 2014-03-07 10:15:00 | AAPL | Stock | 18.9002 | 18.9032 | 18.8836 | 18.9 | 1403920.0 |
| 2014-03-07 10:20:00 | AAPL | Stock | 18.8946 | 18.9 | 18.8768 | 18.88 | 1727936.0 |
| 2014-03-07 10:25:00 | AAPL | Stock | 18.8793 | 18.8793 | 18.8414 | 18.8557 | 3037692.0 |
| 2014-03-07 10:30:00 | AAPL | Stock | 18.8554 | 18.8829 | 18.8554 | 18.8743 | 1259272.0 |
| 2014-03-07 10:35:00 | AAPL | Stock | 18.8754 | 18.8889 | 18.8654 | 18.8714 | 1142148.0 |
| 2014-03-07 10:40:00 | AAPL | Stock | 18.8732 | 18.8857 | 18.8607 | 18.8607 | 1461012.0 |
| 2014-03-07 10:45:00 | AAPL | Stock | 18.8607 | 18.8607 | 18.8364 | 18.8382 | 2331504.0 |
| 2014-03-07 10:50:00 | AAPL | Stock | 18.8379 | 18.8611 | 18.8361 | 18.848 | 2254812.0 |
| 2014-03-07 10:55:00 | AAPL | Stock | 18.8486 | 18.8496 | 18.8289 | 18.84 | 2220932.0 |
| 2014-03-07 11:00:00 | AAPL | Stock | 18.8389 | 18.8396 | 18.8004 | 18.8036 | 3342920.0 |
| 2014-03-07 11:05:00 | AAPL | Stock | 18.8032 | 18.8264 | 18.8014 | 18.8259 | 2667504.0 |
| 2014-03-07 11:10:00 | AAPL | Stock | 18.8261 | 18.8321 | 18.8154 | 18.8294 | 2484860.0 |
| 2014-03-07 11:15:00 | AAPL | Stock | 18.8289 | 18.8318 | 18.8025 | 18.8107 | 1781080.0 |
| 2014-03-07 11:20:00 | AAPL | Stock | 18.8089 | 18.8369 | 18.8046 | 18.8329 | 1215452.0 |
| 2014-03-07 11:25:00 | AAPL | Stock | 18.8343 | 18.8489 | 18.8318 | 18.841 | 1366260.0 |
| 2014-03-07 11:30:00 | AAPL | Stock | 18.8411 | 18.8607 | 18.8346 | 18.8507 | 1560048.0 |
| 2014-03-07 11:35:00 | AAPL | Stock | 18.8557 | 18.8639 | 18.8429 | 18.8464 | 987448.0 |
> showing 50 of 362,844 rows — these rows as CSV