PREVIEW / stock_30min / 2013-11-29
file: by_date/stock_30min/2013/2013-11-29.parquet size: 983 KB rows: 46,389 symbols: 3,448
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-29 04:00:00 | AAPL | Stock | 19.5754 | 19.6332 | 19.5754 | 19.6311 | 81228.0 |
| 2013-11-29 04:30:00 | AAPL | Stock | 19.6236 | 19.6314 | 19.6154 | 19.6157 | 28336.0 |
| 2013-11-29 05:00:00 | AAPL | Stock | 19.6421 | 19.6607 | 19.6421 | 19.6607 | 22064.0 |
| 2013-11-29 05:30:00 | AAPL | Stock | 19.6464 | 19.6464 | 19.6157 | 19.6182 | 28000.0 |
| 2013-11-29 06:00:00 | AAPL | Stock | 19.6425 | 19.6821 | 19.6368 | 19.6714 | 339500.0 |
| 2013-11-29 06:30:00 | AAPL | Stock | 19.6429 | 19.6607 | 19.6236 | 19.6536 | 173516.0 |
| 2013-11-29 07:00:00 | AAPL | Stock | 19.6536 | 19.6607 | 19.6429 | 19.6429 | 402500.0 |
| 2013-11-29 07:30:00 | AAPL | Stock | 19.6429 | 19.6518 | 19.6293 | 19.6393 | 479836.0 |
| 2013-11-29 08:00:00 | AAPL | Stock | 19.6379 | 19.6939 | 19.4821 | 19.6682 | 2469824.0 |
| 2013-11-29 08:30:00 | AAPL | Stock | 19.6696 | 19.6764 | 19.6432 | 19.65 | 1060892.0 |
| 2013-11-29 09:00:00 | AAPL | Stock | 19.6482 | 19.6568 | 19.5982 | 19.6243 | 1835148.0 |
| 2013-11-29 09:30:00 | AAPL | Stock | 19.6243 | 19.6607 | 19.5646 | 19.6445 | 64368164.0 |
| 2013-11-29 10:00:00 | AAPL | Stock | 19.6483 | 19.7082 | 19.6204 | 19.6925 | 30304064.0 |
| 2013-11-29 10:30:00 | AAPL | Stock | 19.6927 | 19.7089 | 19.6646 | 19.7079 | 20622812.0 |
| 2013-11-29 11:00:00 | AAPL | Stock | 19.7082 | 19.8193 | 19.6964 | 19.8168 | 37037756.0 |
| 2013-11-29 11:30:00 | AAPL | Stock | 19.8181 | 19.9046 | 19.8057 | 19.8554 | 45418212.0 |
| 2013-11-29 12:00:00 | AAPL | Stock | 19.8571 | 19.9404 | 19.8514 | 19.9257 | 30993508.0 |
| 2013-11-29 12:30:00 | AAPL | Stock | 19.9261 | 19.9271 | 19.8475 | 19.86 | 45610152.0 |
| 2013-11-29 13:00:00 | AAPL | Stock | 19.8596 | 19.8875 | 19.7634 | 19.8597 | 32599644.0 |
| 2013-11-29 13:30:00 | AAPL | Stock | 19.8786 | 19.8929 | 19.8607 | 19.8929 | 806064.0 |
| 2013-11-29 14:00:00 | AAPL | Stock | 19.8929 | 19.8929 | 19.8596 | 19.8818 | 503776.0 |
| 2013-11-29 14:30:00 | AAPL | Stock | 19.8818 | 19.8907 | 19.8818 | 19.8843 | 97412.0 |
| 2013-11-29 15:00:00 | AAPL | Stock | 19.8839 | 19.8886 | 19.8839 | 19.8857 | 53760.0 |
| 2013-11-29 15:30:00 | AAPL | Stock | 19.8879 | 19.8879 | 19.8814 | 19.8814 | 150836.0 |
| 2013-11-29 16:00:00 | AAPL | Stock | 19.8779 | 19.8814 | 19.8732 | 19.8771 | 66080.0 |
| 2013-11-29 16:30:00 | AAPL | Stock | 19.8661 | 19.8679 | 19.8607 | 19.8607 | 219212.0 |
| 2013-11-29 04:00:00 | MSFT | Stock | 37.75 | 37.75 | 37.75 | 37.75 | 400.0 |
| 2013-11-29 07:30:00 | MSFT | Stock | 37.82 | 37.85 | 37.82 | 37.85 | 4470.0 |
| 2013-11-29 08:00:00 | MSFT | Stock | 37.83 | 37.86 | 37.8 | 37.83 | 10892.0 |
| 2013-11-29 08:30:00 | MSFT | Stock | 37.86 | 37.87 | 37.84 | 37.85 | 1990.0 |
| 2013-11-29 09:00:00 | MSFT | Stock | 37.86 | 37.96 | 37.81 | 37.81 | 59717.0 |
| 2013-11-29 09:30:00 | MSFT | Stock | 37.81 | 38.189 | 37.8 | 38.15 | 4893334.0 |
| 2013-11-29 10:00:00 | MSFT | Stock | 38.157 | 38.29 | 38.11 | 38.26 | 2641122.0 |
| 2013-11-29 10:30:00 | MSFT | Stock | 38.255 | 38.27 | 38.15 | 38.25 | 1953158.0 |
| 2013-11-29 11:00:00 | MSFT | Stock | 38.24 | 38.29 | 38.21 | 38.243 | 1262518.0 |
| 2013-11-29 11:30:00 | MSFT | Stock | 38.245 | 38.26 | 38.14 | 38.15 | 2086459.0 |
| 2013-11-29 12:00:00 | MSFT | Stock | 38.15 | 38.24 | 38.14 | 38.18 | 1390588.0 |
| 2013-11-29 12:30:00 | MSFT | Stock | 38.185 | 38.21 | 38.1 | 38.13 | 3608647.0 |
| 2013-11-29 13:00:00 | MSFT | Stock | 38.13 | 38.224 | 38.12 | 38.132 | 3921169.0 |
| 2013-11-29 13:30:00 | MSFT | Stock | 38.15 | 38.15 | 38.04 | 38.04 | 14136.0 |
| 2013-11-29 14:00:00 | MSFT | Stock | 38.03 | 38.03 | 38.0 | 38.0 | 6445.0 |
| 2013-11-29 15:30:00 | MSFT | Stock | 38.12 | 38.12 | 38.12 | 38.12 | 1000.0 |
| 2013-11-29 16:30:00 | MSFT | Stock | 38.186 | 38.186 | 38.186 | 38.186 | 37600.0 |
| 2013-11-29 09:30:00 | NVDA | Stock | 0.3925 | 0.3935 | 0.39 | 0.3918 | 11928400.0 |
| 2013-11-29 10:00:00 | NVDA | Stock | 0.3918 | 0.3925 | 0.3913 | 0.3925 | 10528760.0 |
| 2013-11-29 10:30:00 | NVDA | Stock | 0.3922 | 0.3925 | 0.3905 | 0.3905 | 5860080.0 |
| 2013-11-29 11:00:00 | NVDA | Stock | 0.3905 | 0.3913 | 0.3905 | 0.391 | 7106200.0 |
| 2013-11-29 11:30:00 | NVDA | Stock | 0.391 | 0.3915 | 0.3902 | 0.3902 | 6770560.0 |
| 2013-11-29 12:00:00 | NVDA | Stock | 0.3902 | 0.3905 | 0.3885 | 0.3885 | 7820440.0 |
| 2013-11-29 12:30:00 | NVDA | Stock | 0.3885 | 0.3908 | 0.3875 | 0.3902 | 47994680.0 |
> showing 50 of 46,389 rows — these rows as CSV