PREVIEW / stock_30min / 2015-08-06
file: by_date/stock_30min/2015/2015-08-06.parquet size: 1.6 MB rows: 82,158 symbols: 3,486
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-06 04:00:00 | AAPL | Stock | 28.8875 | 28.8875 | 28.875 | 28.8875 | 33008.0 |
| 2015-08-06 04:30:00 | AAPL | Stock | 28.8875 | 28.8875 | 28.875 | 28.875 | 5472.0 |
| 2015-08-06 05:00:00 | AAPL | Stock | 28.875 | 28.875 | 28.865 | 28.875 | 4840.0 |
| 2015-08-06 05:30:00 | AAPL | Stock | 28.84 | 28.8525 | 28.84 | 28.8525 | 3280.0 |
| 2015-08-06 06:00:00 | AAPL | Stock | 28.86 | 28.9275 | 28.86 | 28.9275 | 3200.0 |
| 2015-08-06 06:30:00 | AAPL | Stock | 28.875 | 28.8875 | 28.855 | 28.855 | 22240.0 |
| 2015-08-06 07:00:00 | AAPL | Stock | 28.875 | 28.875 | 28.8475 | 28.85 | 68388.0 |
| 2015-08-06 07:30:00 | AAPL | Stock | 28.8525 | 28.9125 | 28.85 | 28.885 | 186796.0 |
| 2015-08-06 08:00:00 | AAPL | Stock | 28.8775 | 28.95 | 28.8475 | 28.925 | 658308.0 |
| 2015-08-06 08:30:00 | AAPL | Stock | 28.925 | 28.985 | 28.875 | 28.9475 | 695980.0 |
| 2015-08-06 09:00:00 | AAPL | Stock | 28.955 | 29.03 | 28.9225 | 28.9925 | 769488.0 |
| 2015-08-06 09:30:00 | AAPL | Stock | 28.9925 | 29.125 | 28.6775 | 28.7475 | 37932584.0 |
| 2015-08-06 10:00:00 | AAPL | Stock | 28.75 | 28.79 | 28.5775 | 28.6225 | 22104456.0 |
| 2015-08-06 10:30:00 | AAPL | Stock | 28.6225 | 28.7475 | 28.595 | 28.61 | 16486828.0 |
| 2015-08-06 11:00:00 | AAPL | Stock | 28.61 | 28.6848 | 28.5288 | 28.6225 | 14466868.0 |
| 2015-08-06 11:30:00 | AAPL | Stock | 28.6275 | 28.7625 | 28.5952 | 28.65 | 14116400.0 |
| 2015-08-06 12:00:00 | AAPL | Stock | 28.6525 | 28.6925 | 28.595 | 28.665 | 8192400.0 |
| 2015-08-06 12:30:00 | AAPL | Stock | 28.6635 | 28.715 | 28.5725 | 28.7125 | 9088140.0 |
| 2015-08-06 13:00:00 | AAPL | Stock | 28.71 | 28.8125 | 28.665 | 28.7875 | 10728208.0 |
| 2015-08-06 13:30:00 | AAPL | Stock | 28.785 | 28.8 | 28.7 | 28.715 | 7869508.0 |
| 2015-08-06 14:00:00 | AAPL | Stock | 28.7125 | 28.9425 | 28.7125 | 28.935 | 11210696.0 |
| 2015-08-06 14:30:00 | AAPL | Stock | 28.934 | 28.95 | 28.7725 | 28.81 | 9875724.0 |
| 2015-08-06 15:00:00 | AAPL | Stock | 28.8075 | 28.8225 | 28.7325 | 28.7328 | 8267300.0 |
| 2015-08-06 15:30:00 | AAPL | Stock | 28.7325 | 28.8375 | 28.7025 | 28.785 | 17815500.0 |
| 2015-08-06 16:00:00 | AAPL | Stock | 28.7825 | 28.819 | 28.755 | 28.7825 | 6692292.0 |
| 2015-08-06 16:30:00 | AAPL | Stock | 28.775 | 28.79 | 28.715 | 28.755 | 73204.0 |
| 2015-08-06 17:00:00 | AAPL | Stock | 28.765 | 28.765 | 28.715 | 28.75 | 47452.0 |
| 2015-08-06 17:30:00 | AAPL | Stock | 28.75 | 28.78 | 28.75 | 28.7725 | 17496.0 |
| 2015-08-06 18:00:00 | AAPL | Stock | 28.7775 | 28.785 | 28.7675 | 28.785 | 13744.0 |
| 2015-08-06 18:30:00 | AAPL | Stock | 28.785 | 28.795 | 28.775 | 28.775 | 42992.0 |
| 2015-08-06 19:00:00 | AAPL | Stock | 28.77 | 28.79 | 28.7625 | 28.79 | 55488.0 |
| 2015-08-06 19:30:00 | AAPL | Stock | 28.7725 | 28.775 | 28.76 | 28.775 | 28012.0 |
| 2015-08-06 04:30:00 | MSFT | Stock | 47.5 | 47.5 | 47.48 | 47.48 | 992.0 |
| 2015-08-06 08:00:00 | MSFT | Stock | 47.6 | 47.69 | 47.6 | 47.64 | 300.0 |
| 2015-08-06 08:30:00 | MSFT | Stock | 47.603 | 47.603 | 47.603 | 47.603 | 100.0 |
| 2015-08-06 09:00:00 | MSFT | Stock | 47.6 | 47.75 | 47.6 | 47.75 | 1500.0 |
| 2015-08-06 09:30:00 | MSFT | Stock | 47.71 | 47.77 | 46.93 | 47.09 | 2925447.0 |
| 2015-08-06 10:00:00 | MSFT | Stock | 47.095 | 47.26 | 46.93 | 46.975 | 1818269.0 |
| 2015-08-06 10:30:00 | MSFT | Stock | 46.975 | 47.04 | 46.93 | 46.935 | 1649195.0 |
| 2015-08-06 11:00:00 | MSFT | Stock | 46.93 | 46.98 | 46.79 | 46.87 | 1766175.0 |
| 2015-08-06 11:30:00 | MSFT | Stock | 46.88 | 46.9 | 46.69 | 46.735 | 1601207.0 |
| 2015-08-06 12:00:00 | MSFT | Stock | 46.74 | 46.76 | 46.545 | 46.555 | 1552191.0 |
| 2015-08-06 12:30:00 | MSFT | Stock | 46.569 | 46.69 | 46.47 | 46.65 | 1233798.0 |
| 2015-08-06 13:00:00 | MSFT | Stock | 46.65 | 46.665 | 46.585 | 46.625 | 1077944.0 |
| 2015-08-06 13:30:00 | MSFT | Stock | 46.63 | 46.65 | 46.38 | 46.409 | 1549434.0 |
| 2015-08-06 14:00:00 | MSFT | Stock | 46.41 | 46.475 | 46.33 | 46.42 | 1612250.0 |
| 2015-08-06 14:30:00 | MSFT | Stock | 46.42 | 46.51 | 46.355 | 46.37 | 1632346.0 |
| 2015-08-06 15:00:00 | MSFT | Stock | 46.37 | 46.51 | 46.36 | 46.46 | 1908598.0 |
| 2015-08-06 15:30:00 | MSFT | Stock | 46.455 | 46.68 | 46.44 | 46.61 | 3370224.0 |
| 2015-08-06 16:00:00 | MSFT | Stock | 46.62 | 46.752 | 46.61 | 46.752 | 1769638.0 |
> showing 50 of 82,158 rows — these rows as CSV