PREVIEW / stock_30min / 2015-12-24
file: by_date/stock_30min/2015/2015-12-24.parquet size: 978 KB rows: 46,375 symbols: 3,323
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-12-24 06:30:00 | AAPL | Stock | 27.1425 | 27.1425 | 27.1425 | 27.1425 | 2000.0 |
| 2015-12-24 07:30:00 | AAPL | Stock | 27.1275 | 27.13 | 27.1275 | 27.13 | 1080.0 |
| 2015-12-24 08:00:00 | AAPL | Stock | 27.1225 | 27.175 | 27.1225 | 27.17 | 41608.0 |
| 2015-12-24 08:30:00 | AAPL | Stock | 27.15 | 27.1575 | 27.135 | 27.15 | 24168.0 |
| 2015-12-24 09:00:00 | AAPL | Stock | 27.1625 | 27.25 | 27.1625 | 27.25 | 182360.0 |
| 2015-12-24 09:30:00 | AAPL | Stock | 27.25 | 27.25 | 27.0675 | 27.1075 | 9921932.0 |
| 2015-12-24 10:00:00 | AAPL | Stock | 27.105 | 27.1225 | 26.9875 | 27.085 | 10101580.0 |
| 2015-12-24 10:30:00 | AAPL | Stock | 27.085 | 27.1475 | 27.0575 | 27.1345 | 5114916.0 |
| 2015-12-24 11:00:00 | AAPL | Stock | 27.1325 | 27.1625 | 27.0875 | 27.0925 | 4958480.0 |
| 2015-12-24 11:30:00 | AAPL | Stock | 27.095 | 27.1625 | 27.075 | 27.1275 | 4785984.0 |
| 2015-12-24 12:00:00 | AAPL | Stock | 27.1275 | 27.1325 | 27.0825 | 27.1025 | 3422016.0 |
| 2015-12-24 12:30:00 | AAPL | Stock | 27.1025 | 27.105 | 26.99 | 27.0075 | 7726476.0 |
| 2015-12-24 13:00:00 | AAPL | Stock | 27.0075 | 27.025 | 27.0 | 27.0175 | 4056284.0 |
| 2015-12-24 13:30:00 | AAPL | Stock | 27.0025 | 27.0125 | 27.0 | 27.0125 | 34680.0 |
| 2015-12-24 14:00:00 | AAPL | Stock | 27.01 | 27.025 | 27.01 | 27.02 | 15228.0 |
| 2015-12-24 14:30:00 | AAPL | Stock | 27.01 | 27.0225 | 27.0075 | 27.0225 | 2124.0 |
| 2015-12-24 15:00:00 | AAPL | Stock | 27.0225 | 27.0225 | 27.01 | 27.01 | 1200.0 |
| 2015-12-24 15:30:00 | AAPL | Stock | 27.02 | 27.0325 | 27.0 | 27.0075 | 23988.0 |
| 2015-12-24 16:30:00 | AAPL | Stock | 27.005 | 27.005 | 27.0025 | 27.0025 | 3048.0 |
| 2015-12-24 07:00:00 | MSFT | Stock | 55.04 | 55.82 | 55.04 | 55.82 | 200.0 |
| 2015-12-24 08:00:00 | MSFT | Stock | 55.75 | 55.75 | 55.75 | 55.75 | 1800.0 |
| 2015-12-24 08:30:00 | MSFT | Stock | 55.65 | 55.81 | 55.65 | 55.65 | 2915.0 |
| 2015-12-24 09:00:00 | MSFT | Stock | 55.75 | 55.8 | 55.75 | 55.75 | 2046.0 |
| 2015-12-24 09:30:00 | MSFT | Stock | 55.86 | 55.96 | 55.752 | 55.79 | 1679969.0 |
| 2015-12-24 10:00:00 | MSFT | Stock | 55.79 | 55.96 | 55.68 | 55.81 | 1306766.0 |
| 2015-12-24 10:30:00 | MSFT | Stock | 55.81 | 55.83 | 55.575 | 55.66 | 1041148.0 |
| 2015-12-24 11:00:00 | MSFT | Stock | 55.66 | 55.695 | 55.5 | 55.516 | 864183.0 |
| 2015-12-24 11:30:00 | MSFT | Stock | 55.535 | 55.71 | 55.43 | 55.684 | 940309.0 |
| 2015-12-24 12:00:00 | MSFT | Stock | 55.68 | 55.83 | 55.68 | 55.81 | 760454.0 |
| 2015-12-24 12:30:00 | MSFT | Stock | 55.81 | 55.83 | 55.65 | 55.68 | 1389024.0 |
| 2015-12-24 13:00:00 | MSFT | Stock | 55.67 | 55.67 | 55.45 | 55.67 | 1032713.0 |
| 2015-12-24 14:00:00 | MSFT | Stock | 55.74 | 55.74 | 55.67 | 55.67 | 1770.0 |
| 2015-12-24 14:30:00 | MSFT | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 2000.0 |
| 2015-12-24 16:00:00 | MSFT | Stock | 55.62 | 55.62 | 55.62 | 55.62 | 400.0 |
| 2015-12-24 16:30:00 | MSFT | Stock | 55.62 | 55.62 | 55.62 | 55.62 | 600.0 |
| 2015-12-24 08:00:00 | NVDA | Stock | 0.8265 | 0.83 | 0.8265 | 0.83 | 92000.0 |
| 2015-12-24 09:30:00 | NVDA | Stock | 0.824 | 0.8298 | 0.8228 | 0.827 | 7463200.0 |
| 2015-12-24 10:00:00 | NVDA | Stock | 0.8268 | 0.829 | 0.8258 | 0.829 | 6180120.0 |
| 2015-12-24 10:30:00 | NVDA | Stock | 0.8289 | 0.8309 | 0.828 | 0.8298 | 5791720.0 |
| 2015-12-24 11:00:00 | NVDA | Stock | 0.8298 | 0.8306 | 0.829 | 0.8296 | 4988320.0 |
| 2015-12-24 11:30:00 | NVDA | Stock | 0.8298 | 0.8308 | 0.8281 | 0.8305 | 4253600.0 |
| 2015-12-24 12:00:00 | NVDA | Stock | 0.8304 | 0.8312 | 0.8288 | 0.8298 | 5458160.0 |
| 2015-12-24 12:30:00 | NVDA | Stock | 0.8298 | 0.8312 | 0.8288 | 0.8292 | 11027280.0 |
| 2015-12-24 13:00:00 | NVDA | Stock | 0.8292 | 0.8292 | 0.8292 | 0.8292 | 4750280.0 |
| 2015-12-24 07:00:00 | AMZN | Stock | 33.1 | 33.1695 | 33.1 | 33.159 | 18000.0 |
| 2015-12-24 08:00:00 | AMZN | Stock | 33.17 | 33.17 | 33.0125 | 33.1495 | 24220.0 |
| 2015-12-24 08:30:00 | AMZN | Stock | 33.175 | 33.175 | 33.175 | 33.175 | 4000.0 |
| 2015-12-24 09:30:00 | AMZN | Stock | 33.1675 | 33.1685 | 33.03 | 33.065 | 2970500.0 |
| 2015-12-24 10:00:00 | AMZN | Stock | 33.0792 | 33.1465 | 33.05 | 33.1175 | 2848600.0 |
| 2015-12-24 10:30:00 | AMZN | Stock | 33.1202 | 33.1202 | 33.051 | 33.0896 | 1220080.0 |
> showing 50 of 46,375 rows — these rows as CSV