PREVIEW / stock_30min / 2015-09-22
file: by_date/stock_30min/2015/2015-09-22.parquet size: 1.6 MB rows: 82,042 symbols: 3,434
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-09-22 04:00:00 | AAPL | Stock | 28.525 | 28.625 | 28.525 | 28.525 | 8400.0 |
| 2015-09-22 04:30:00 | AAPL | Stock | 28.5 | 28.5 | 28.45 | 28.475 | 4800.0 |
| 2015-09-22 05:00:00 | AAPL | Stock | 28.4675 | 28.485 | 28.3875 | 28.3875 | 6400.0 |
| 2015-09-22 05:30:00 | AAPL | Stock | 28.4 | 28.5275 | 28.385 | 28.455 | 34632.0 |
| 2015-09-22 06:00:00 | AAPL | Stock | 28.455 | 28.455 | 28.315 | 28.35 | 48512.0 |
| 2015-09-22 06:30:00 | AAPL | Stock | 28.4 | 28.52 | 28.345 | 28.5 | 111132.0 |
| 2015-09-22 07:00:00 | AAPL | Stock | 28.5 | 28.55 | 28.43 | 28.5475 | 124516.0 |
| 2015-09-22 07:30:00 | AAPL | Stock | 28.5475 | 28.5725 | 28.475 | 28.5725 | 98300.0 |
| 2015-09-22 08:00:00 | AAPL | Stock | 28.3692 | 28.575 | 28.3692 | 28.485 | 634388.0 |
| 2015-09-22 08:30:00 | AAPL | Stock | 28.4875 | 28.4925 | 28.375 | 28.455 | 641172.0 |
| 2015-09-22 09:00:00 | AAPL | Stock | 28.45 | 28.46 | 28.3475 | 28.3675 | 525052.0 |
| 2015-09-22 09:30:00 | AAPL | Stock | 28.345 | 28.545 | 28.325 | 28.42 | 27406452.0 |
| 2015-09-22 10:00:00 | AAPL | Stock | 28.42 | 28.5175 | 28.3775 | 28.428 | 15137424.0 |
| 2015-09-22 10:30:00 | AAPL | Stock | 28.4275 | 28.4425 | 28.27 | 28.3112 | 15467328.0 |
| 2015-09-22 11:00:00 | AAPL | Stock | 28.3125 | 28.365 | 28.257 | 28.257 | 9883260.0 |
| 2015-09-22 11:30:00 | AAPL | Stock | 28.255 | 28.2975 | 28.19 | 28.255 | 13390704.0 |
| 2015-09-22 12:00:00 | AAPL | Stock | 28.2548 | 28.305 | 28.19 | 28.225 | 8718568.0 |
| 2015-09-22 12:30:00 | AAPL | Stock | 28.2275 | 28.26 | 28.1475 | 28.1612 | 9677660.0 |
| 2015-09-22 13:00:00 | AAPL | Stock | 28.1598 | 28.225 | 28.1325 | 28.1425 | 7352868.0 |
| 2015-09-22 13:30:00 | AAPL | Stock | 28.1412 | 28.2775 | 28.13 | 28.275 | 9732576.0 |
| 2015-09-22 14:00:00 | AAPL | Stock | 28.275 | 28.2755 | 28.1825 | 28.27 | 9455276.0 |
| 2015-09-22 14:30:00 | AAPL | Stock | 28.27 | 28.3225 | 28.2025 | 28.305 | 10577936.0 |
| 2015-09-22 15:00:00 | AAPL | Stock | 28.3025 | 28.305 | 28.1928 | 28.2775 | 9911768.0 |
| 2015-09-22 15:30:00 | AAPL | Stock | 28.2775 | 28.3875 | 28.27 | 28.3425 | 20864408.0 |
| 2015-09-22 16:00:00 | AAPL | Stock | 28.35 | 28.454 | 28.35 | 28.37 | 18012348.0 |
| 2015-09-22 16:30:00 | AAPL | Stock | 28.37 | 28.37 | 28.35 | 28.3625 | 106000.0 |
| 2015-09-22 17:00:00 | AAPL | Stock | 28.3625 | 28.3625 | 28.35 | 28.35 | 7278988.0 |
| 2015-09-22 17:30:00 | AAPL | Stock | 28.35 | 28.3625 | 28.35 | 28.355 | 18480.0 |
| 2015-09-22 18:00:00 | AAPL | Stock | 28.3625 | 28.37 | 28.35 | 28.355 | 59132.0 |
| 2015-09-22 18:30:00 | AAPL | Stock | 28.3525 | 28.3625 | 28.345 | 28.345 | 38208.0 |
| 2015-09-22 19:00:00 | AAPL | Stock | 28.35 | 28.35 | 28.3275 | 28.3275 | 20000.0 |
| 2015-09-22 19:30:00 | AAPL | Stock | 28.3175 | 28.3175 | 28.2575 | 28.275 | 103720.0 |
| 2015-09-22 06:00:00 | MSFT | Stock | 43.64 | 43.64 | 43.48 | 43.48 | 1820.0 |
| 2015-09-22 07:30:00 | MSFT | Stock | 43.33 | 43.6 | 43.32 | 43.6 | 2155.0 |
| 2015-09-22 08:00:00 | MSFT | Stock | 43.6 | 43.6 | 43.4 | 43.4 | 30547.0 |
| 2015-09-22 08:30:00 | MSFT | Stock | 43.4 | 43.4 | 43.31 | 43.35 | 15375.0 |
| 2015-09-22 09:00:00 | MSFT | Stock | 43.37 | 43.45 | 43.3 | 43.3 | 9265.0 |
| 2015-09-22 09:30:00 | MSFT | Stock | 43.38 | 43.713 | 43.34 | 43.54 | 3397885.0 |
| 2015-09-22 10:00:00 | MSFT | Stock | 43.54 | 43.69 | 43.4 | 43.5 | 1892462.0 |
| 2015-09-22 10:30:00 | MSFT | Stock | 43.51 | 43.51 | 43.31 | 43.455 | 1572474.0 |
| 2015-09-22 11:00:00 | MSFT | Stock | 43.46 | 43.69 | 43.455 | 43.576 | 1893718.0 |
| 2015-09-22 11:30:00 | MSFT | Stock | 43.57 | 43.77 | 43.55 | 43.7 | 1605292.0 |
| 2015-09-22 12:00:00 | MSFT | Stock | 43.7 | 43.813 | 43.59 | 43.63 | 1232090.0 |
| 2015-09-22 12:30:00 | MSFT | Stock | 43.64 | 43.65 | 43.44 | 43.493 | 1204343.0 |
| 2015-09-22 13:00:00 | MSFT | Stock | 43.49 | 43.63 | 43.37 | 43.39 | 1345033.0 |
| 2015-09-22 13:30:00 | MSFT | Stock | 43.39 | 43.68 | 43.37 | 43.635 | 1550008.0 |
| 2015-09-22 14:00:00 | MSFT | Stock | 43.63 | 43.68 | 43.505 | 43.599 | 1012956.0 |
| 2015-09-22 14:30:00 | MSFT | Stock | 43.595 | 43.77 | 43.56 | 43.75 | 1903060.0 |
| 2015-09-22 15:00:00 | MSFT | Stock | 43.746 | 43.945 | 43.66 | 43.92 | 1952708.0 |
| 2015-09-22 15:30:00 | MSFT | Stock | 43.924 | 44.05 | 43.83 | 43.9 | 3379623.0 |
> showing 50 of 82,042 rows — these rows as CSV