PREVIEW / stock_30min / 2015-06-11
file: by_date/stock_30min/2015/2015-06-11.parquet size: 1.6 MB rows: 82,554 symbols: 3,519
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-06-11 04:00:00 | AAPL | Stock | 32.2825 | 32.2825 | 32.2825 | 32.2825 | 400.0 |
| 2015-06-11 04:30:00 | AAPL | Stock | 32.2875 | 32.2875 | 32.2775 | 32.2875 | 5276.0 |
| 2015-06-11 05:30:00 | AAPL | Stock | 32.25 | 32.2875 | 32.25 | 32.275 | 5264.0 |
| 2015-06-11 06:00:00 | AAPL | Stock | 32.285 | 32.3 | 32.285 | 32.3 | 9384.0 |
| 2015-06-11 06:30:00 | AAPL | Stock | 32.295 | 32.3025 | 32.2775 | 32.3 | 8616.0 |
| 2015-06-11 07:00:00 | AAPL | Stock | 32.3025 | 32.3125 | 32.28 | 32.3 | 40452.0 |
| 2015-06-11 07:30:00 | AAPL | Stock | 32.295 | 32.3275 | 32.295 | 32.3275 | 18780.0 |
| 2015-06-11 08:00:00 | AAPL | Stock | 32.3225 | 32.325 | 32.2775 | 32.305 | 167812.0 |
| 2015-06-11 08:30:00 | AAPL | Stock | 32.295 | 32.32 | 32.29 | 32.3 | 209460.0 |
| 2015-06-11 09:00:00 | AAPL | Stock | 32.2958 | 32.315 | 32.29 | 32.295 | 320628.0 |
| 2015-06-11 09:30:00 | AAPL | Stock | 32.295 | 32.545 | 32.275 | 32.5225 | 24271572.0 |
| 2015-06-11 10:00:00 | AAPL | Stock | 32.515 | 32.5225 | 32.3925 | 32.3955 | 11496292.0 |
| 2015-06-11 10:30:00 | AAPL | Stock | 32.395 | 32.3975 | 32.2875 | 32.32 | 12812604.0 |
| 2015-06-11 11:00:00 | AAPL | Stock | 32.32 | 32.41 | 32.305 | 32.3275 | 7825248.0 |
| 2015-06-11 11:30:00 | AAPL | Stock | 32.3275 | 32.375 | 32.32 | 32.325 | 4988128.0 |
| 2015-06-11 12:00:00 | AAPL | Stock | 32.325 | 32.36 | 32.1188 | 32.2875 | 9888836.0 |
| 2015-06-11 12:30:00 | AAPL | Stock | 32.2875 | 32.365 | 32.2675 | 32.3325 | 5392460.0 |
| 2015-06-11 13:00:00 | AAPL | Stock | 32.3325 | 32.335 | 32.265 | 32.2975 | 4468260.0 |
| 2015-06-11 13:30:00 | AAPL | Stock | 32.2985 | 32.335 | 32.2808 | 32.3125 | 3697944.0 |
| 2015-06-11 14:00:00 | AAPL | Stock | 32.3108 | 32.33 | 32.22 | 32.2425 | 5203680.0 |
| 2015-06-11 14:30:00 | AAPL | Stock | 32.2425 | 32.2675 | 32.1675 | 32.175 | 6111060.0 |
| 2015-06-11 15:00:00 | AAPL | Stock | 32.175 | 32.2225 | 32.1575 | 32.1712 | 5680696.0 |
| 2015-06-11 15:30:00 | AAPL | Stock | 32.17 | 32.21 | 32.1475 | 32.15 | 13708292.0 |
| 2015-06-11 16:00:00 | AAPL | Stock | 32.1475 | 32.2125 | 32.1475 | 32.1575 | 15923976.0 |
| 2015-06-11 16:30:00 | AAPL | Stock | 32.1582 | 32.1775 | 32.1575 | 32.1775 | 21772.0 |
| 2015-06-11 17:00:00 | AAPL | Stock | 32.17 | 32.1825 | 32.1625 | 32.165 | 22320.0 |
| 2015-06-11 17:30:00 | AAPL | Stock | 32.1625 | 32.175 | 32.1475 | 32.1625 | 31896.0 |
| 2015-06-11 18:00:00 | AAPL | Stock | 32.1625 | 32.175 | 32.155 | 32.155 | 27744.0 |
| 2015-06-11 18:30:00 | AAPL | Stock | 32.155 | 32.17 | 32.1475 | 32.15 | 46980.0 |
| 2015-06-11 19:00:00 | AAPL | Stock | 32.15 | 32.1725 | 32.1475 | 32.1625 | 12756.0 |
| 2015-06-11 19:30:00 | AAPL | Stock | 32.1625 | 32.1725 | 32.15 | 32.17 | 31656.0 |
| 2015-06-11 04:00:00 | MSFT | Stock | 46.65 | 46.65 | 46.65 | 46.65 | 100.0 |
| 2015-06-11 07:30:00 | MSFT | Stock | 46.65 | 46.65 | 46.65 | 46.65 | 2300.0 |
| 2015-06-11 08:00:00 | MSFT | Stock | 46.65 | 46.7 | 46.563 | 46.7 | 16000.0 |
| 2015-06-11 08:30:00 | MSFT | Stock | 46.65 | 46.69 | 46.6 | 46.65 | 10562.0 |
| 2015-06-11 09:00:00 | MSFT | Stock | 46.66 | 46.77 | 46.6 | 46.76 | 11850.0 |
| 2015-06-11 09:30:00 | MSFT | Stock | 46.66 | 46.92 | 46.66 | 46.75 | 2643665.0 |
| 2015-06-11 10:00:00 | MSFT | Stock | 46.755 | 46.81 | 46.49 | 46.56 | 2188465.0 |
| 2015-06-11 10:30:00 | MSFT | Stock | 46.56 | 46.56 | 46.32 | 46.34 | 2163069.0 |
| 2015-06-11 11:00:00 | MSFT | Stock | 46.34 | 46.46 | 46.28 | 46.295 | 1552302.0 |
| 2015-06-11 11:30:00 | MSFT | Stock | 46.29 | 46.365 | 46.27 | 46.329 | 1229160.0 |
| 2015-06-11 12:00:00 | MSFT | Stock | 46.325 | 46.365 | 46.17 | 46.21 | 994765.0 |
| 2015-06-11 12:30:00 | MSFT | Stock | 46.215 | 46.27 | 46.19 | 46.235 | 830350.0 |
| 2015-06-11 13:00:00 | MSFT | Stock | 46.23 | 46.24 | 46.13 | 46.205 | 874498.0 |
| 2015-06-11 13:30:00 | MSFT | Stock | 46.21 | 46.37 | 46.194 | 46.32 | 1248747.0 |
| 2015-06-11 14:00:00 | MSFT | Stock | 46.315 | 46.38 | 46.3 | 46.371 | 888404.0 |
| 2015-06-11 14:30:00 | MSFT | Stock | 46.375 | 46.475 | 46.36 | 46.43 | 1296354.0 |
| 2015-06-11 15:00:00 | MSFT | Stock | 46.43 | 46.48 | 46.42 | 46.445 | 896142.0 |
| 2015-06-11 15:30:00 | MSFT | Stock | 46.45 | 46.51 | 46.39 | 46.44 | 4879349.0 |
| 2015-06-11 16:00:00 | MSFT | Stock | 46.44 | 46.51 | 46.44 | 46.51 | 4422591.0 |
> showing 50 of 82,554 rows — these rows as CSV