PREVIEW / stock_30min / 2016-10-06
file: by_date/stock_30min/2016/2016-10-06.parquet size: 1.6 MB rows: 79,182 symbols: 3,179
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-06 05:30:00 | AAPL | Stock | 28.255 | 28.255 | 28.255 | 28.255 | 400.0 |
| 2016-10-06 06:30:00 | AAPL | Stock | 28.2525 | 28.375 | 28.2525 | 28.375 | 5816.0 |
| 2016-10-06 07:00:00 | AAPL | Stock | 28.365 | 28.435 | 28.365 | 28.41 | 23848.0 |
| 2016-10-06 07:30:00 | AAPL | Stock | 28.41 | 28.4575 | 28.4 | 28.435 | 46592.0 |
| 2016-10-06 08:00:00 | AAPL | Stock | 28.415 | 28.435 | 28.2 | 28.375 | 184860.0 |
| 2016-10-06 08:30:00 | AAPL | Stock | 28.375 | 28.43 | 28.355 | 28.415 | 161076.0 |
| 2016-10-06 09:00:00 | AAPL | Stock | 28.405 | 28.44 | 28.3825 | 28.4175 | 368252.0 |
| 2016-10-06 09:30:00 | AAPL | Stock | 28.4225 | 28.5125 | 28.335 | 28.385 | 20704556.0 |
| 2016-10-06 10:00:00 | AAPL | Stock | 28.385 | 28.4425 | 28.345 | 28.415 | 8140804.0 |
| 2016-10-06 10:30:00 | AAPL | Stock | 28.417 | 28.42 | 28.2825 | 28.3798 | 8550064.0 |
| 2016-10-06 11:00:00 | AAPL | Stock | 28.3775 | 28.3812 | 28.2825 | 28.34 | 5476228.0 |
| 2016-10-06 11:30:00 | AAPL | Stock | 28.3425 | 28.495 | 28.33 | 28.4758 | 7516544.0 |
| 2016-10-06 12:00:00 | AAPL | Stock | 28.4775 | 28.5575 | 28.4575 | 28.5488 | 9902912.0 |
| 2016-10-06 12:30:00 | AAPL | Stock | 28.5488 | 28.569 | 28.4925 | 28.535 | 6071564.0 |
| 2016-10-06 13:00:00 | AAPL | Stock | 28.5325 | 28.57 | 28.53 | 28.566 | 4200740.0 |
| 2016-10-06 13:30:00 | AAPL | Stock | 28.5662 | 28.5825 | 28.54 | 28.57 | 5546288.0 |
| 2016-10-06 14:00:00 | AAPL | Stock | 28.5675 | 28.58 | 28.55 | 28.5712 | 4238224.0 |
| 2016-10-06 14:30:00 | AAPL | Stock | 28.5712 | 28.585 | 28.5075 | 28.5338 | 4791380.0 |
| 2016-10-06 15:00:00 | AAPL | Stock | 28.5325 | 28.57 | 28.5075 | 28.5175 | 4333608.0 |
| 2016-10-06 15:30:00 | AAPL | Stock | 28.5175 | 28.5325 | 28.4675 | 28.4775 | 9502716.0 |
| 2016-10-06 16:00:00 | AAPL | Stock | 28.4725 | 28.5075 | 28.4175 | 28.485 | 6220400.0 |
| 2016-10-06 16:30:00 | AAPL | Stock | 28.4775 | 28.4825 | 28.4725 | 28.4825 | 33940.0 |
| 2016-10-06 17:00:00 | AAPL | Stock | 28.4825 | 28.4825 | 28.4725 | 28.4725 | 889752.0 |
| 2016-10-06 17:30:00 | AAPL | Stock | 28.48 | 28.4925 | 28.4725 | 28.4875 | 23752.0 |
| 2016-10-06 18:00:00 | AAPL | Stock | 28.4875 | 28.4875 | 28.475 | 28.475 | 4920.0 |
| 2016-10-06 18:30:00 | AAPL | Stock | 28.485 | 28.4875 | 28.485 | 28.4875 | 29600.0 |
| 2016-10-06 19:00:00 | AAPL | Stock | 28.475 | 28.485 | 28.46 | 28.46 | 44912.0 |
| 2016-10-06 19:30:00 | AAPL | Stock | 28.4525 | 28.485 | 28.4525 | 28.485 | 15160.0 |
| 2016-10-06 07:30:00 | MSFT | Stock | 57.6 | 57.6 | 57.6 | 57.6 | 300.0 |
| 2016-10-06 08:30:00 | MSFT | Stock | 57.54 | 57.54 | 57.54 | 57.54 | 371.0 |
| 2016-10-06 09:00:00 | MSFT | Stock | 57.55 | 57.59 | 57.55 | 57.59 | 4800.0 |
| 2016-10-06 09:30:00 | MSFT | Stock | 57.74 | 57.74 | 57.28 | 57.44 | 2270754.0 |
| 2016-10-06 10:00:00 | MSFT | Stock | 57.43 | 57.49 | 57.37 | 57.465 | 1076002.0 |
| 2016-10-06 10:30:00 | MSFT | Stock | 57.46 | 57.68 | 57.395 | 57.66 | 1222005.0 |
| 2016-10-06 11:00:00 | MSFT | Stock | 57.66 | 57.7 | 57.365 | 57.58 | 1233149.0 |
| 2016-10-06 11:30:00 | MSFT | Stock | 57.58 | 57.82 | 57.495 | 57.74 | 1132821.0 |
| 2016-10-06 12:00:00 | MSFT | Stock | 57.74 | 57.86 | 57.73 | 57.805 | 738066.0 |
| 2016-10-06 12:30:00 | MSFT | Stock | 57.8 | 57.83 | 57.74 | 57.76 | 432024.0 |
| 2016-10-06 13:00:00 | MSFT | Stock | 57.76 | 57.786 | 57.715 | 57.74 | 439825.0 |
| 2016-10-06 13:30:00 | MSFT | Stock | 57.745 | 57.78 | 57.66 | 57.7 | 845964.0 |
| 2016-10-06 14:00:00 | MSFT | Stock | 57.7 | 57.8 | 57.7 | 57.76 | 470589.0 |
| 2016-10-06 14:30:00 | MSFT | Stock | 57.755 | 57.8 | 57.705 | 57.8 | 723552.0 |
| 2016-10-06 15:00:00 | MSFT | Stock | 57.8 | 57.84 | 57.72 | 57.73 | 929560.0 |
| 2016-10-06 15:30:00 | MSFT | Stock | 57.73 | 57.8 | 57.7 | 57.74 | 1858231.0 |
| 2016-10-06 16:00:00 | MSFT | Stock | 57.74 | 57.75 | 57.604 | 57.74 | 1952986.0 |
| 2016-10-06 19:00:00 | MSFT | Stock | 57.74 | 57.74 | 57.74 | 57.74 | 4300.0 |
| 2016-10-06 19:30:00 | MSFT | Stock | 57.74 | 57.74 | 57.74 | 57.74 | 1000.0 |
| 2016-10-06 05:00:00 | NVDA | Stock | 1.6748 | 1.6748 | 1.6748 | 1.6748 | 10000.0 |
| 2016-10-06 06:00:00 | NVDA | Stock | 1.678 | 1.678 | 1.636 | 1.636 | 246640.0 |
| 2016-10-06 07:00:00 | NVDA | Stock | 1.6435 | 1.6688 | 1.6428 | 1.6675 | 129920.0 |
> showing 50 of 79,182 rows — these rows as CSV