PREVIEW / stock_5min / 2011-06-13
file: by_date/stock_5min/2011/2011-06-13.parquet size: 5.1 MB rows: 348,362 symbols: 3,567
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-13 05:20:00 | AAPL | Stock | 11.6393 | 11.6393 | 11.6393 | 11.6393 | 2800.0 |
| 2011-06-13 05:45:00 | AAPL | Stock | 11.6389 | 11.6389 | 11.6389 | 11.6389 | 2800.0 |
| 2011-06-13 06:20:00 | AAPL | Stock | 11.6696 | 11.6696 | 11.6696 | 11.6696 | 4200.0 |
| 2011-06-13 06:50:00 | AAPL | Stock | 11.6782 | 11.6782 | 11.6782 | 11.6782 | 25760.0 |
| 2011-06-13 07:00:00 | AAPL | Stock | 11.6696 | 11.6929 | 11.6696 | 11.6929 | 42000.0 |
| 2011-06-13 07:10:00 | AAPL | Stock | 11.6875 | 11.6889 | 11.6768 | 11.6768 | 50400.0 |
| 2011-06-13 07:20:00 | AAPL | Stock | 11.6871 | 11.6871 | 11.6871 | 11.6871 | 2800.0 |
| 2011-06-13 07:25:00 | AAPL | Stock | 11.6871 | 11.6893 | 11.6871 | 11.6893 | 36680.0 |
| 2011-06-13 07:35:00 | AAPL | Stock | 11.6946 | 11.6946 | 11.6904 | 11.6904 | 5600.0 |
| 2011-06-13 07:40:00 | AAPL | Stock | 11.6875 | 11.69 | 11.6786 | 11.6836 | 105084.0 |
| 2011-06-13 07:50:00 | AAPL | Stock | 11.6793 | 11.6854 | 11.6786 | 11.6854 | 37436.0 |
| 2011-06-13 07:55:00 | AAPL | Stock | 11.6854 | 11.6889 | 11.6854 | 11.6889 | 39200.0 |
| 2011-06-13 08:00:00 | AAPL | Stock | 11.68 | 11.6907 | 11.6786 | 11.6786 | 241136.0 |
| 2011-06-13 08:05:00 | AAPL | Stock | 11.6793 | 11.6875 | 11.6786 | 11.6804 | 61152.0 |
| 2011-06-13 08:10:00 | AAPL | Stock | 11.6807 | 11.6807 | 11.6804 | 11.6804 | 30744.0 |
| 2011-06-13 08:15:00 | AAPL | Stock | 11.6821 | 11.6875 | 11.6786 | 11.6875 | 110740.0 |
| 2011-06-13 08:20:00 | AAPL | Stock | 11.6875 | 11.6946 | 11.6875 | 11.6896 | 97580.0 |
| 2011-06-13 08:25:00 | AAPL | Stock | 11.6929 | 11.7011 | 11.6929 | 11.7007 | 85680.0 |
| 2011-06-13 08:30:00 | AAPL | Stock | 11.6989 | 11.7011 | 11.6964 | 11.6982 | 61264.0 |
| 2011-06-13 08:35:00 | AAPL | Stock | 11.695 | 11.7036 | 11.6946 | 11.6946 | 89180.0 |
| 2011-06-13 08:40:00 | AAPL | Stock | 11.6957 | 11.7029 | 11.6939 | 11.6964 | 53928.0 |
| 2011-06-13 08:45:00 | AAPL | Stock | 11.6996 | 11.6996 | 11.6914 | 11.6993 | 55692.0 |
| 2011-06-13 08:50:00 | AAPL | Stock | 11.6929 | 11.6971 | 11.6929 | 11.6964 | 21000.0 |
| 2011-06-13 08:55:00 | AAPL | Stock | 11.6964 | 11.6996 | 11.6964 | 11.6964 | 27076.0 |
| 2011-06-13 09:00:00 | AAPL | Stock | 11.6986 | 11.6986 | 11.6857 | 11.6864 | 51800.0 |
| 2011-06-13 09:05:00 | AAPL | Stock | 11.6921 | 11.6925 | 11.6857 | 11.6861 | 64680.0 |
| 2011-06-13 09:10:00 | AAPL | Stock | 11.6886 | 11.6893 | 11.6829 | 11.6868 | 117908.0 |
| 2011-06-13 09:15:00 | AAPL | Stock | 11.6866 | 11.6893 | 11.6832 | 11.6861 | 168140.0 |
| 2011-06-13 09:20:00 | AAPL | Stock | 11.6875 | 11.6911 | 11.6789 | 11.6821 | 130564.0 |
| 2011-06-13 09:25:00 | AAPL | Stock | 11.6839 | 11.6857 | 11.6746 | 11.6839 | 167076.0 |
| 2011-06-13 09:30:00 | AAPL | Stock | 11.6843 | 11.6857 | 11.6446 | 11.6459 | 14940716.0 |
| 2011-06-13 09:35:00 | AAPL | Stock | 11.6461 | 11.6461 | 11.6096 | 11.6186 | 14538748.0 |
| 2011-06-13 09:40:00 | AAPL | Stock | 11.6179 | 11.6725 | 11.6154 | 11.6615 | 10212524.0 |
| 2011-06-13 09:45:00 | AAPL | Stock | 11.6614 | 11.6625 | 11.6229 | 11.6293 | 7483560.0 |
| 2011-06-13 09:50:00 | AAPL | Stock | 11.6261 | 11.6436 | 11.6186 | 11.6325 | 4549944.0 |
| 2011-06-13 09:55:00 | AAPL | Stock | 11.635 | 11.6954 | 11.635 | 11.678 | 10503976.0 |
| 2011-06-13 10:00:00 | AAPL | Stock | 11.675 | 11.6943 | 11.66 | 11.6793 | 5695088.0 |
| 2011-06-13 10:05:00 | AAPL | Stock | 11.6793 | 11.6818 | 11.6482 | 11.6789 | 5386640.0 |
| 2011-06-13 10:10:00 | AAPL | Stock | 11.6789 | 11.6886 | 11.6537 | 11.6616 | 5026168.0 |
| 2011-06-13 10:15:00 | AAPL | Stock | 11.6621 | 11.6857 | 11.6371 | 11.6854 | 6491520.0 |
| 2011-06-13 10:20:00 | AAPL | Stock | 11.6857 | 11.6859 | 11.6689 | 11.6811 | 4167884.0 |
| 2011-06-13 10:25:00 | AAPL | Stock | 11.6796 | 11.7125 | 11.6771 | 11.7032 | 8176840.0 |
| 2011-06-13 10:30:00 | AAPL | Stock | 11.7019 | 11.7064 | 11.6832 | 11.6911 | 3866828.0 |
| 2011-06-13 10:35:00 | AAPL | Stock | 11.6911 | 11.7046 | 11.685 | 11.687 | 3299632.0 |
| 2011-06-13 10:40:00 | AAPL | Stock | 11.69 | 11.6929 | 11.6732 | 11.6761 | 3002944.0 |
| 2011-06-13 10:45:00 | AAPL | Stock | 11.6771 | 11.6957 | 11.6661 | 11.6793 | 5085556.0 |
| 2011-06-13 10:50:00 | AAPL | Stock | 11.6796 | 11.6839 | 11.6579 | 11.6589 | 3063788.0 |
| 2011-06-13 10:55:00 | AAPL | Stock | 11.6593 | 11.6736 | 11.6557 | 11.6696 | 2912084.0 |
| 2011-06-13 11:00:00 | AAPL | Stock | 11.6671 | 11.6727 | 11.6524 | 11.6536 | 2095044.0 |
| 2011-06-13 11:05:00 | AAPL | Stock | 11.6536 | 11.6689 | 11.6536 | 11.6604 | 1580740.0 |
> showing 50 of 348,362 rows — these rows as CSV