PREVIEW / stock_30min / 2015-11-27
file: by_date/stock_30min/2015/2015-11-27.parquet size: 1007 KB rows: 48,051 symbols: 3,334
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-11-27 04:00:00 | AAPL | Stock | 29.5075 | 29.535 | 29.5 | 29.5 | 25960.0 |
| 2015-11-27 04:30:00 | AAPL | Stock | 29.5 | 29.5125 | 29.5 | 29.5 | 3800.0 |
| 2015-11-27 05:00:00 | AAPL | Stock | 29.5125 | 29.525 | 29.495 | 29.525 | 23268.0 |
| 2015-11-27 05:30:00 | AAPL | Stock | 29.5575 | 29.5675 | 29.55 | 29.5675 | 4224.0 |
| 2015-11-27 06:00:00 | AAPL | Stock | 29.575 | 29.6 | 29.575 | 29.5875 | 5068.0 |
| 2015-11-27 06:30:00 | AAPL | Stock | 29.57 | 29.595 | 29.57 | 29.575 | 14776.0 |
| 2015-11-27 07:00:00 | AAPL | Stock | 29.5725 | 29.58 | 29.565 | 29.575 | 42752.0 |
| 2015-11-27 07:30:00 | AAPL | Stock | 29.58 | 29.65 | 29.58 | 29.65 | 79048.0 |
| 2015-11-27 08:00:00 | AAPL | Stock | 29.65 | 29.66 | 29.565 | 29.6125 | 145544.0 |
| 2015-11-27 08:30:00 | AAPL | Stock | 29.61 | 29.61 | 29.575 | 29.5875 | 110036.0 |
| 2015-11-27 09:00:00 | AAPL | Stock | 29.59 | 29.625 | 29.5075 | 29.5625 | 234488.0 |
| 2015-11-27 09:30:00 | AAPL | Stock | 29.535 | 29.6025 | 29.4 | 29.47 | 12032312.0 |
| 2015-11-27 10:00:00 | AAPL | Stock | 29.47 | 29.5075 | 29.425 | 29.475 | 5762660.0 |
| 2015-11-27 10:30:00 | AAPL | Stock | 29.4725 | 29.4975 | 29.415 | 29.43 | 4293836.0 |
| 2015-11-27 11:00:00 | AAPL | Stock | 29.43 | 29.535 | 29.43 | 29.5225 | 5269796.0 |
| 2015-11-27 11:30:00 | AAPL | Stock | 29.525 | 29.55 | 29.465 | 29.4812 | 4499360.0 |
| 2015-11-27 12:00:00 | AAPL | Stock | 29.4818 | 29.5375 | 29.4775 | 29.495 | 4847572.0 |
| 2015-11-27 12:30:00 | AAPL | Stock | 29.4975 | 29.52 | 29.455 | 29.455 | 5926856.0 |
| 2015-11-27 13:00:00 | AAPL | Stock | 29.455 | 29.48 | 29.415 | 29.4525 | 5324764.0 |
| 2015-11-27 13:30:00 | AAPL | Stock | 29.4175 | 29.445 | 29.4 | 29.435 | 77184.0 |
| 2015-11-27 14:00:00 | AAPL | Stock | 29.4375 | 29.4375 | 29.4125 | 29.4375 | 21440.0 |
| 2015-11-27 14:30:00 | AAPL | Stock | 29.4375 | 29.4375 | 29.4275 | 29.4375 | 6260.0 |
| 2015-11-27 15:00:00 | AAPL | Stock | 29.4375 | 29.4375 | 29.425 | 29.4375 | 8440.0 |
| 2015-11-27 15:30:00 | AAPL | Stock | 29.435 | 29.45 | 29.435 | 29.4375 | 21600.0 |
| 2015-11-27 16:00:00 | AAPL | Stock | 29.425 | 29.45 | 29.4125 | 29.4125 | 18144.0 |
| 2015-11-27 16:30:00 | AAPL | Stock | 29.4375 | 29.4475 | 29.4375 | 29.4475 | 12644.0 |
| 2015-11-27 18:00:00 | AAPL | Stock | 29.478 | 29.478 | 29.478 | 29.478 | 6800.0 |
| 2015-11-27 05:30:00 | MSFT | Stock | 53.77 | 53.77 | 53.77 | 53.77 | 600.0 |
| 2015-11-27 07:00:00 | MSFT | Stock | 53.79 | 53.81 | 53.76 | 53.76 | 500.0 |
| 2015-11-27 07:30:00 | MSFT | Stock | 53.87 | 53.91 | 53.87 | 53.91 | 6400.0 |
| 2015-11-27 08:00:00 | MSFT | Stock | 53.88 | 53.88 | 53.86 | 53.87 | 2700.0 |
| 2015-11-27 08:30:00 | MSFT | Stock | 53.86 | 53.89 | 53.78 | 53.79 | 10798.0 |
| 2015-11-27 09:00:00 | MSFT | Stock | 53.79 | 53.94 | 53.79 | 53.93 | 33119.0 |
| 2015-11-27 09:30:00 | MSFT | Stock | 53.81 | 54.07 | 53.79 | 53.92 | 2212583.0 |
| 2015-11-27 10:00:00 | MSFT | Stock | 53.93 | 53.96 | 53.84 | 53.86 | 1000242.0 |
| 2015-11-27 10:30:00 | MSFT | Stock | 53.865 | 53.93 | 53.845 | 53.91 | 761623.0 |
| 2015-11-27 11:00:00 | MSFT | Stock | 53.91 | 54.07 | 53.89 | 54.02 | 781839.0 |
| 2015-11-27 11:30:00 | MSFT | Stock | 54.03 | 54.08 | 53.91 | 53.915 | 613760.0 |
| 2015-11-27 12:00:00 | MSFT | Stock | 53.92 | 54.03 | 53.875 | 54.02 | 663259.0 |
| 2015-11-27 12:30:00 | MSFT | Stock | 54.015 | 54.03 | 53.91 | 53.94 | 1568545.0 |
| 2015-11-27 13:00:00 | MSFT | Stock | 53.95 | 54.02 | 53.71 | 53.93 | 785742.0 |
| 2015-11-27 13:30:00 | MSFT | Stock | 53.86 | 53.92 | 53.81 | 53.92 | 1000.0 |
| 2015-11-27 15:30:00 | MSFT | Stock | 53.95 | 54.0 | 53.95 | 54.0 | 1900.0 |
| 2015-11-27 07:30:00 | NVDA | Stock | 0.7818 | 0.7818 | 0.7818 | 0.7818 | 4000.0 |
| 2015-11-27 08:00:00 | NVDA | Stock | 0.7818 | 0.7818 | 0.7818 | 0.7818 | 12000.0 |
| 2015-11-27 09:00:00 | NVDA | Stock | 0.7805 | 0.7805 | 0.7805 | 0.7805 | 5800.0 |
| 2015-11-27 09:30:00 | NVDA | Stock | 0.7798 | 0.7825 | 0.7758 | 0.7818 | 17158840.0 |
| 2015-11-27 10:00:00 | NVDA | Stock | 0.7818 | 0.7845 | 0.7798 | 0.7836 | 15581560.0 |
| 2015-11-27 10:30:00 | NVDA | Stock | 0.7838 | 0.785 | 0.7825 | 0.784 | 9041560.0 |
| 2015-11-27 11:00:00 | NVDA | Stock | 0.7843 | 0.7872 | 0.7842 | 0.7848 | 7447800.0 |
> showing 50 of 48,051 rows — these rows as CSV