PREVIEW / stock_30min / 2011-11-03
file: by_date/stock_30min/2011/2011-11-03.parquet size: 1.4 MB rows: 77,109 symbols: 3,509
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-03 04:00:00 | AAPL | Stock | 13.9936 | 14.0607 | 13.9936 | 14.0357 | 268800.0 |
| 2011-11-03 04:30:00 | AAPL | Stock | 14.0536 | 14.0714 | 14.0536 | 14.0714 | 91000.0 |
| 2011-11-03 05:00:00 | AAPL | Stock | 14.0857 | 14.1429 | 14.0857 | 14.1414 | 84840.0 |
| 2011-11-03 05:30:00 | AAPL | Stock | 14.1075 | 14.17 | 14.1036 | 14.17 | 98000.0 |
| 2011-11-03 06:00:00 | AAPL | Stock | 14.1768 | 14.25 | 14.1768 | 14.25 | 28000.0 |
| 2011-11-03 06:30:00 | AAPL | Stock | 14.2143 | 14.2143 | 14.2139 | 14.2139 | 11200.0 |
| 2011-11-03 07:00:00 | AAPL | Stock | 14.2139 | 14.2339 | 14.1796 | 14.2321 | 189000.0 |
| 2011-11-03 07:30:00 | AAPL | Stock | 14.2289 | 14.25 | 14.2143 | 14.235 | 221508.0 |
| 2011-11-03 08:00:00 | AAPL | Stock | 14.2268 | 14.2782 | 14.2182 | 14.2739 | 1273720.0 |
| 2011-11-03 08:30:00 | AAPL | Stock | 14.2732 | 14.3164 | 14.25 | 14.3107 | 2371068.0 |
| 2011-11-03 09:00:00 | AAPL | Stock | 14.3111 | 14.3143 | 14.1932 | 14.2525 | 2504432.0 |
| 2011-11-03 09:30:00 | AAPL | Stock | 14.2525 | 14.2679 | 14.1346 | 14.1564 | 62526464.0 |
| 2011-11-03 10:00:00 | AAPL | Stock | 14.1618 | 14.1804 | 14.12 | 14.1432 | 38851316.0 |
| 2011-11-03 10:30:00 | AAPL | Stock | 14.1432 | 14.2064 | 14.1211 | 14.1721 | 34030332.0 |
| 2011-11-03 11:00:00 | AAPL | Stock | 14.1721 | 14.2582 | 14.1721 | 14.2461 | 29397200.0 |
| 2011-11-03 11:30:00 | AAPL | Stock | 14.2468 | 14.2782 | 14.24 | 14.2425 | 23560264.0 |
| 2011-11-03 12:00:00 | AAPL | Stock | 14.2418 | 14.2654 | 14.2179 | 14.2629 | 16532572.0 |
| 2011-11-03 12:30:00 | AAPL | Stock | 14.2629 | 14.2904 | 14.2536 | 14.2671 | 28867860.0 |
| 2011-11-03 13:00:00 | AAPL | Stock | 14.2679 | 14.3546 | 14.25 | 14.335 | 41983928.0 |
| 2011-11-03 13:30:00 | AAPL | Stock | 14.3364 | 14.3525 | 14.3257 | 14.3311 | 19875016.0 |
| 2011-11-03 14:00:00 | AAPL | Stock | 14.3339 | 14.3375 | 14.2932 | 14.3068 | 23516584.0 |
| 2011-11-03 14:30:00 | AAPL | Stock | 14.3071 | 14.3486 | 14.3071 | 14.3457 | 16692004.0 |
| 2011-11-03 15:00:00 | AAPL | Stock | 14.3448 | 14.4029 | 14.3443 | 14.3896 | 33554976.0 |
| 2011-11-03 15:30:00 | AAPL | Stock | 14.3903 | 14.4071 | 14.3768 | 14.3946 | 39620196.0 |
| 2011-11-03 16:00:00 | AAPL | Stock | 14.3946 | 14.3964 | 14.2029 | 14.3954 | 18032196.0 |
| 2011-11-03 16:30:00 | AAPL | Stock | 14.3707 | 14.3954 | 14.2159 | 14.3782 | 1606248.0 |
| 2011-11-03 17:00:00 | AAPL | Stock | 14.3768 | 14.3821 | 14.3736 | 14.3821 | 62720.0 |
| 2011-11-03 17:30:00 | AAPL | Stock | 14.375 | 14.3954 | 14.375 | 14.3954 | 182000.0 |
| 2011-11-03 18:00:00 | AAPL | Stock | 14.3725 | 14.3954 | 14.3725 | 14.3768 | 79296.0 |
| 2011-11-03 18:30:00 | AAPL | Stock | 14.375 | 14.3904 | 14.375 | 14.3896 | 35728.0 |
| 2011-11-03 19:00:00 | AAPL | Stock | 14.3889 | 14.3889 | 14.3889 | 14.3889 | 8400.0 |
| 2011-11-03 19:30:00 | AAPL | Stock | 14.3879 | 14.3893 | 14.3821 | 14.3857 | 91028.0 |
| 2011-11-03 04:00:00 | MSFT | Stock | 25.85 | 25.85 | 25.68 | 25.68 | 6100.0 |
| 2011-11-03 06:00:00 | MSFT | Stock | 25.9 | 25.95 | 25.9 | 25.95 | 600.0 |
| 2011-11-03 07:00:00 | MSFT | Stock | 25.9 | 25.95 | 25.9 | 25.95 | 7100.0 |
| 2011-11-03 07:30:00 | MSFT | Stock | 25.95 | 25.98 | 25.95 | 25.98 | 1600.0 |
| 2011-11-03 08:00:00 | MSFT | Stock | 25.98 | 26.05 | 25.98 | 26.04 | 33150.0 |
| 2011-11-03 08:30:00 | MSFT | Stock | 26.04 | 26.18 | 25.98 | 26.17 | 32140.0 |
| 2011-11-03 09:00:00 | MSFT | Stock | 26.17 | 26.26 | 26.01 | 26.24 | 202068.0 |
| 2011-11-03 09:30:00 | MSFT | Stock | 26.24 | 26.37 | 26.05 | 26.092 | 5278359.0 |
| 2011-11-03 10:00:00 | MSFT | Stock | 26.1 | 26.25 | 25.98 | 26.222 | 5914446.0 |
| 2011-11-03 10:30:00 | MSFT | Stock | 26.22 | 26.49 | 26.18 | 26.27 | 7415046.0 |
| 2011-11-03 11:00:00 | MSFT | Stock | 26.26 | 26.44 | 26.23 | 26.41 | 3611941.0 |
| 2011-11-03 11:30:00 | MSFT | Stock | 26.405 | 26.44 | 26.31 | 26.31 | 2274286.0 |
| 2011-11-03 12:00:00 | MSFT | Stock | 26.31 | 26.47 | 26.29 | 26.459 | 3091012.0 |
| 2011-11-03 12:30:00 | MSFT | Stock | 26.46 | 26.5 | 26.36 | 26.478 | 2158329.0 |
| 2011-11-03 13:00:00 | MSFT | Stock | 26.47 | 26.57 | 26.44 | 26.5 | 2732177.0 |
| 2011-11-03 13:30:00 | MSFT | Stock | 26.508 | 26.56 | 26.44 | 26.495 | 2753576.0 |
| 2011-11-03 14:00:00 | MSFT | Stock | 26.5 | 26.585 | 26.465 | 26.5 | 3297117.0 |
| 2011-11-03 14:30:00 | MSFT | Stock | 26.5 | 26.52 | 26.44 | 26.495 | 2010069.0 |
> showing 50 of 77,109 rows — these rows as CSV