PREVIEW / stock_5min / 2011-12-16
file: by_date/stock_5min/2011/2011-12-16.parquet size: 5.0 MB rows: 337,744 symbols: 3,542
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-12-16 04:00:00 | AAPL | Stock | 13.5804 | 13.5804 | 13.5804 | 13.5804 | 2800.0 |
| 2011-12-16 05:15:00 | AAPL | Stock | 13.6225 | 13.6225 | 13.6225 | 13.6225 | 2800.0 |
| 2011-12-16 07:15:00 | AAPL | Stock | 13.5982 | 13.5982 | 13.5982 | 13.5982 | 14000.0 |
| 2011-12-16 07:30:00 | AAPL | Stock | 13.6036 | 13.6071 | 13.6036 | 13.6043 | 44800.0 |
| 2011-12-16 07:35:00 | AAPL | Stock | 13.6082 | 13.6179 | 13.6082 | 13.6121 | 26600.0 |
| 2011-12-16 07:40:00 | AAPL | Stock | 13.6071 | 13.6132 | 13.6071 | 13.6093 | 20720.0 |
| 2011-12-16 07:55:00 | AAPL | Stock | 13.6018 | 13.6018 | 13.5964 | 13.5964 | 6300.0 |
| 2011-12-16 08:00:00 | AAPL | Stock | 13.6071 | 13.6071 | 13.5911 | 13.5911 | 54404.0 |
| 2011-12-16 08:05:00 | AAPL | Stock | 13.6068 | 13.6071 | 13.5893 | 13.605 | 108836.0 |
| 2011-12-16 08:10:00 | AAPL | Stock | 13.5982 | 13.6 | 13.5893 | 13.6 | 45640.0 |
| 2011-12-16 08:15:00 | AAPL | Stock | 13.5786 | 13.5939 | 13.5768 | 13.5929 | 16044.0 |
| 2011-12-16 08:20:00 | AAPL | Stock | 13.5982 | 13.605 | 13.5932 | 13.5932 | 52220.0 |
| 2011-12-16 08:25:00 | AAPL | Stock | 13.605 | 13.6071 | 13.6046 | 13.6071 | 87444.0 |
| 2011-12-16 08:30:00 | AAPL | Stock | 13.6 | 13.6 | 13.5804 | 13.5893 | 46760.0 |
| 2011-12-16 08:35:00 | AAPL | Stock | 13.5893 | 13.5893 | 13.5839 | 13.5839 | 8400.0 |
| 2011-12-16 08:40:00 | AAPL | Stock | 13.5839 | 13.5893 | 13.5804 | 13.5804 | 37744.0 |
| 2011-12-16 08:45:00 | AAPL | Stock | 13.5893 | 13.5929 | 13.5893 | 13.5929 | 14840.0 |
| 2011-12-16 08:55:00 | AAPL | Stock | 13.5979 | 13.5982 | 13.5857 | 13.5857 | 55860.0 |
| 2011-12-16 09:00:00 | AAPL | Stock | 13.5929 | 13.5929 | 13.5857 | 13.5911 | 86688.0 |
| 2011-12-16 09:05:00 | AAPL | Stock | 13.5825 | 13.5868 | 13.5789 | 13.5804 | 45080.0 |
| 2011-12-16 09:10:00 | AAPL | Stock | 13.585 | 13.5893 | 13.585 | 13.5893 | 30800.0 |
| 2011-12-16 09:15:00 | AAPL | Stock | 13.5825 | 13.5893 | 13.5746 | 13.5889 | 206332.0 |
| 2011-12-16 09:20:00 | AAPL | Stock | 13.5846 | 13.5846 | 13.5771 | 13.5804 | 16800.0 |
| 2011-12-16 09:25:00 | AAPL | Stock | 13.5786 | 13.6071 | 13.5714 | 13.5921 | 1600116.0 |
| 2011-12-16 09:30:00 | AAPL | Stock | 13.59 | 13.6211 | 13.5626 | 13.5732 | 57841924.0 |
| 2011-12-16 09:35:00 | AAPL | Stock | 13.5739 | 13.6004 | 13.57 | 13.5857 | 5778668.0 |
| 2011-12-16 09:40:00 | AAPL | Stock | 13.5857 | 13.5943 | 13.5561 | 13.5734 | 6998544.0 |
| 2011-12-16 09:45:00 | AAPL | Stock | 13.5711 | 13.5804 | 13.5643 | 13.5775 | 4130952.0 |
| 2011-12-16 09:50:00 | AAPL | Stock | 13.575 | 13.5979 | 13.574 | 13.5946 | 4744880.0 |
| 2011-12-16 09:55:00 | AAPL | Stock | 13.5946 | 13.6118 | 13.5854 | 13.5889 | 5011776.0 |
| 2011-12-16 10:00:00 | AAPL | Stock | 13.5918 | 13.615 | 13.5714 | 13.5989 | 6696844.0 |
| 2011-12-16 10:05:00 | AAPL | Stock | 13.6 | 13.6418 | 13.5978 | 13.6368 | 6598088.0 |
| 2011-12-16 10:10:00 | AAPL | Stock | 13.6368 | 13.6514 | 13.6275 | 13.65 | 7497364.0 |
| 2011-12-16 10:15:00 | AAPL | Stock | 13.65 | 13.7036 | 13.65 | 13.7029 | 11105332.0 |
| 2011-12-16 10:20:00 | AAPL | Stock | 13.7032 | 13.7196 | 13.6857 | 13.6893 | 11851448.0 |
| 2011-12-16 10:25:00 | AAPL | Stock | 13.6918 | 13.6993 | 13.6721 | 13.6771 | 7101556.0 |
| 2011-12-16 10:30:00 | AAPL | Stock | 13.6757 | 13.6818 | 13.6707 | 13.6761 | 3581284.0 |
| 2011-12-16 10:35:00 | AAPL | Stock | 13.6764 | 13.6954 | 13.6739 | 13.6807 | 3556728.0 |
| 2011-12-16 10:40:00 | AAPL | Stock | 13.68 | 13.6818 | 13.6696 | 13.6796 | 3129924.0 |
| 2011-12-16 10:45:00 | AAPL | Stock | 13.6793 | 13.6839 | 13.6629 | 13.6674 | 2367484.0 |
| 2011-12-16 10:50:00 | AAPL | Stock | 13.6671 | 13.6779 | 13.6646 | 13.6739 | 2656584.0 |
| 2011-12-16 10:55:00 | AAPL | Stock | 13.6732 | 13.6786 | 13.6682 | 13.6786 | 4090268.0 |
| 2011-12-16 11:00:00 | AAPL | Stock | 13.6761 | 13.6789 | 13.665 | 13.6686 | 2561272.0 |
| 2011-12-16 11:05:00 | AAPL | Stock | 13.6682 | 13.6729 | 13.6557 | 13.6729 | 3969140.0 |
| 2011-12-16 11:10:00 | AAPL | Stock | 13.6729 | 13.6775 | 13.6671 | 13.6735 | 2922164.0 |
| 2011-12-16 11:15:00 | AAPL | Stock | 13.6711 | 13.6793 | 13.6646 | 13.6704 | 3167780.0 |
| 2011-12-16 11:20:00 | AAPL | Stock | 13.6714 | 13.6793 | 13.6654 | 13.675 | 1785980.0 |
| 2011-12-16 11:25:00 | AAPL | Stock | 13.6754 | 13.68 | 13.6714 | 13.6736 | 2777852.0 |
| 2011-12-16 11:30:00 | AAPL | Stock | 13.6722 | 13.674 | 13.6432 | 13.65 | 5208476.0 |
| 2011-12-16 11:35:00 | AAPL | Stock | 13.6504 | 13.6507 | 13.635 | 13.6357 | 4019316.0 |
> showing 50 of 337,744 rows — these rows as CSV