PREVIEW / stock_5min / 2012-01-12
file: by_date/stock_5min/2012/2012-01-12.parquet size: 4.7 MB rows: 322,168 symbols: 3,528
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-12 05:55:00 | AAPL | Stock | 15.1554 | 15.1554 | 15.0957 | 15.0957 | 28840.0 |
| 2012-01-12 07:00:00 | AAPL | Stock | 15.1464 | 15.1786 | 15.1464 | 15.1786 | 45500.0 |
| 2012-01-12 07:05:00 | AAPL | Stock | 15.175 | 15.175 | 15.1518 | 15.1518 | 30800.0 |
| 2012-01-12 07:10:00 | AAPL | Stock | 15.1818 | 15.1818 | 15.1818 | 15.1818 | 2800.0 |
| 2012-01-12 07:15:00 | AAPL | Stock | 15.1736 | 15.1782 | 15.1718 | 15.1782 | 64400.0 |
| 2012-01-12 07:20:00 | AAPL | Stock | 15.1764 | 15.1807 | 15.1764 | 15.1786 | 62160.0 |
| 2012-01-12 07:25:00 | AAPL | Stock | 15.1807 | 15.1807 | 15.1779 | 15.1779 | 24640.0 |
| 2012-01-12 07:30:00 | AAPL | Stock | 15.1696 | 15.1768 | 15.1607 | 15.175 | 19600.0 |
| 2012-01-12 07:35:00 | AAPL | Stock | 15.1661 | 15.1714 | 15.1661 | 15.1714 | 6300.0 |
| 2012-01-12 07:40:00 | AAPL | Stock | 15.1721 | 15.1871 | 15.1718 | 15.1871 | 114184.0 |
| 2012-01-12 07:45:00 | AAPL | Stock | 15.1893 | 15.1925 | 15.1893 | 15.1914 | 33600.0 |
| 2012-01-12 07:50:00 | AAPL | Stock | 15.1907 | 15.1964 | 15.1875 | 15.1964 | 44268.0 |
| 2012-01-12 07:55:00 | AAPL | Stock | 15.1861 | 15.1861 | 15.18 | 15.18 | 8400.0 |
| 2012-01-12 08:00:00 | AAPL | Stock | 15.1789 | 15.1839 | 15.1661 | 15.1786 | 315140.0 |
| 2012-01-12 08:05:00 | AAPL | Stock | 15.1829 | 15.1829 | 15.1618 | 15.1693 | 92232.0 |
| 2012-01-12 08:10:00 | AAPL | Stock | 15.1629 | 15.1629 | 15.1589 | 15.1589 | 44716.0 |
| 2012-01-12 08:15:00 | AAPL | Stock | 15.1639 | 15.1643 | 15.1639 | 15.1643 | 28000.0 |
| 2012-01-12 08:20:00 | AAPL | Stock | 15.1539 | 15.1539 | 15.1429 | 15.1536 | 36120.0 |
| 2012-01-12 08:25:00 | AAPL | Stock | 15.1589 | 15.1589 | 15.1464 | 15.1464 | 31920.0 |
| 2012-01-12 08:30:00 | AAPL | Stock | 15.1429 | 15.1432 | 15.0857 | 15.1071 | 195300.0 |
| 2012-01-12 08:35:00 | AAPL | Stock | 15.1043 | 15.1071 | 15.0854 | 15.1004 | 455868.0 |
| 2012-01-12 08:40:00 | AAPL | Stock | 15.0946 | 15.0993 | 15.0854 | 15.0854 | 88424.0 |
| 2012-01-12 08:45:00 | AAPL | Stock | 15.0893 | 15.0929 | 15.0746 | 15.085 | 242032.0 |
| 2012-01-12 08:50:00 | AAPL | Stock | 15.085 | 15.0875 | 15.0779 | 15.0875 | 136780.0 |
| 2012-01-12 08:55:00 | AAPL | Stock | 15.0896 | 15.0936 | 15.0857 | 15.0864 | 79800.0 |
| 2012-01-12 09:00:00 | AAPL | Stock | 15.0911 | 15.0975 | 15.0896 | 15.0954 | 40600.0 |
| 2012-01-12 09:05:00 | AAPL | Stock | 15.0936 | 15.1064 | 15.0936 | 15.1 | 62300.0 |
| 2012-01-12 09:10:00 | AAPL | Stock | 15.1004 | 15.1143 | 15.095 | 15.1054 | 151900.0 |
| 2012-01-12 09:15:00 | AAPL | Stock | 15.1018 | 15.1018 | 15.0946 | 15.0946 | 60760.0 |
| 2012-01-12 09:20:00 | AAPL | Stock | 15.0936 | 15.1 | 15.0911 | 15.0911 | 84700.0 |
| 2012-01-12 09:25:00 | AAPL | Stock | 15.0929 | 15.0971 | 15.0804 | 15.0889 | 115052.0 |
| 2012-01-12 09:30:00 | AAPL | Stock | 15.0889 | 15.1036 | 15.05 | 15.0518 | 8929564.0 |
| 2012-01-12 09:35:00 | AAPL | Stock | 15.0468 | 15.0821 | 15.0357 | 15.065 | 7747796.0 |
| 2012-01-12 09:40:00 | AAPL | Stock | 15.0664 | 15.0686 | 15.0443 | 15.0446 | 3954160.0 |
| 2012-01-12 09:45:00 | AAPL | Stock | 15.045 | 15.0579 | 15.0261 | 15.0264 | 5360628.0 |
| 2012-01-12 09:50:00 | AAPL | Stock | 15.0279 | 15.0529 | 15.0082 | 15.0464 | 6459488.0 |
| 2012-01-12 09:55:00 | AAPL | Stock | 15.0473 | 15.0643 | 15.0432 | 15.0486 | 3961440.0 |
| 2012-01-12 10:00:00 | AAPL | Stock | 15.0468 | 15.0696 | 15.0304 | 15.0379 | 4155172.0 |
| 2012-01-12 10:05:00 | AAPL | Stock | 15.0356 | 15.0596 | 14.9918 | 14.9946 | 7380156.0 |
| 2012-01-12 10:10:00 | AAPL | Stock | 14.9946 | 15.0264 | 14.9911 | 14.9925 | 7144564.0 |
| 2012-01-12 10:15:00 | AAPL | Stock | 14.9926 | 15.0018 | 14.9857 | 14.9927 | 4459840.0 |
| 2012-01-12 10:20:00 | AAPL | Stock | 14.9929 | 15.0039 | 14.9857 | 14.9871 | 4829216.0 |
| 2012-01-12 10:25:00 | AAPL | Stock | 14.9875 | 15.0175 | 14.9857 | 15.0175 | 3531416.0 |
| 2012-01-12 10:30:00 | AAPL | Stock | 15.0175 | 15.0175 | 15.0 | 15.0025 | 5400948.0 |
| 2012-01-12 10:35:00 | AAPL | Stock | 15.0014 | 15.0064 | 14.9711 | 14.9732 | 4561480.0 |
| 2012-01-12 10:40:00 | AAPL | Stock | 14.9724 | 14.9836 | 14.9654 | 14.9746 | 4818184.0 |
| 2012-01-12 10:45:00 | AAPL | Stock | 14.9739 | 14.9764 | 14.9554 | 14.9682 | 5102916.0 |
| 2012-01-12 10:50:00 | AAPL | Stock | 14.9668 | 14.9886 | 14.9589 | 14.9854 | 3475640.0 |
| 2012-01-12 10:55:00 | AAPL | Stock | 14.9883 | 15.0061 | 14.9836 | 14.9939 | 2999360.0 |
| 2012-01-12 11:00:00 | AAPL | Stock | 14.995 | 15.0068 | 14.9939 | 15.0029 | 1599416.0 |
> showing 50 of 322,168 rows — these rows as CSV