PREVIEW / stock_30min / 2015-04-29
file: by_date/stock_30min/2015/2015-04-29.parquet size: 1.6 MB rows: 81,910 symbols: 3,495
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-04-29 04:00:00 | AAPL | Stock | 32.655 | 32.73 | 32.655 | 32.73 | 4560.0 |
| 2015-04-29 04:30:00 | AAPL | Stock | 32.7225 | 32.7225 | 32.7125 | 32.7125 | 12600.0 |
| 2015-04-29 05:00:00 | AAPL | Stock | 32.7225 | 32.7325 | 32.7 | 32.7 | 5020.0 |
| 2015-04-29 05:30:00 | AAPL | Stock | 32.7 | 32.7 | 32.62 | 32.65 | 15716.0 |
| 2015-04-29 06:00:00 | AAPL | Stock | 32.65 | 32.71 | 32.62 | 32.6925 | 50596.0 |
| 2015-04-29 06:30:00 | AAPL | Stock | 32.695 | 32.7475 | 32.66 | 32.685 | 91380.0 |
| 2015-04-29 07:00:00 | AAPL | Stock | 32.68 | 32.77 | 32.635 | 32.665 | 262664.0 |
| 2015-04-29 07:30:00 | AAPL | Stock | 32.6625 | 32.7175 | 32.65 | 32.67 | 38980.0 |
| 2015-04-29 08:00:00 | AAPL | Stock | 32.67 | 32.7325 | 32.6275 | 32.72 | 458560.0 |
| 2015-04-29 08:30:00 | AAPL | Stock | 32.7125 | 32.7925 | 32.65 | 32.6575 | 723836.0 |
| 2015-04-29 09:00:00 | AAPL | Stock | 32.6525 | 32.6575 | 32.475 | 32.5525 | 1192936.0 |
| 2015-04-29 09:30:00 | AAPL | Stock | 32.54 | 32.8975 | 32.45 | 32.6675 | 29487988.0 |
| 2015-04-29 10:00:00 | AAPL | Stock | 32.6675 | 32.7225 | 32.4025 | 32.515 | 20319316.0 |
| 2015-04-29 10:30:00 | AAPL | Stock | 32.515 | 32.595 | 32.3925 | 32.4325 | 16233252.0 |
| 2015-04-29 11:00:00 | AAPL | Stock | 32.4325 | 32.585 | 32.4125 | 32.505 | 11541916.0 |
| 2015-04-29 11:30:00 | AAPL | Stock | 32.5075 | 32.5125 | 32.43 | 32.4482 | 7601572.0 |
| 2015-04-29 12:00:00 | AAPL | Stock | 32.445 | 32.4788 | 32.165 | 32.1945 | 20699652.0 |
| 2015-04-29 12:30:00 | AAPL | Stock | 32.1962 | 32.2625 | 32.0875 | 32.245 | 15623712.0 |
| 2015-04-29 13:00:00 | AAPL | Stock | 32.2475 | 32.2838 | 32.145 | 32.2075 | 9264508.0 |
| 2015-04-29 13:30:00 | AAPL | Stock | 32.21 | 32.3875 | 32.17 | 32.3412 | 10043920.0 |
| 2015-04-29 14:00:00 | AAPL | Stock | 32.34 | 32.395 | 32.1425 | 32.3025 | 17830948.0 |
| 2015-04-29 14:30:00 | AAPL | Stock | 32.3025 | 32.38 | 32.2375 | 32.2575 | 10731352.0 |
| 2015-04-29 15:00:00 | AAPL | Stock | 32.2575 | 32.28 | 32.0875 | 32.1285 | 14418148.0 |
| 2015-04-29 15:30:00 | AAPL | Stock | 32.13 | 32.3468 | 32.075 | 32.16 | 25626512.0 |
| 2015-04-29 16:00:00 | AAPL | Stock | 32.16 | 32.317 | 32.1025 | 32.11 | 9003592.0 |
| 2015-04-29 16:30:00 | AAPL | Stock | 32.1175 | 32.1525 | 31.82 | 31.925 | 1486720.0 |
| 2015-04-29 17:00:00 | AAPL | Stock | 31.935 | 32.0475 | 31.875 | 32.0375 | 793408.0 |
| 2015-04-29 17:30:00 | AAPL | Stock | 32.025 | 32.075 | 31.9625 | 31.9775 | 386176.0 |
| 2015-04-29 18:00:00 | AAPL | Stock | 31.9775 | 32.02 | 31.9625 | 31.9625 | 244220.0 |
| 2015-04-29 18:30:00 | AAPL | Stock | 31.97 | 31.99 | 31.9625 | 31.97 | 181100.0 |
| 2015-04-29 19:00:00 | AAPL | Stock | 31.965 | 31.9875 | 31.9625 | 31.97 | 98516.0 |
| 2015-04-29 19:30:00 | AAPL | Stock | 31.9675 | 31.99 | 31.95 | 31.9525 | 202012.0 |
| 2015-04-29 04:00:00 | MSFT | Stock | 49.01 | 49.01 | 49.01 | 49.01 | 200.0 |
| 2015-04-29 04:30:00 | MSFT | Stock | 49.11 | 49.11 | 49.11 | 49.11 | 100.0 |
| 2015-04-29 05:30:00 | MSFT | Stock | 49.06 | 49.13 | 49.06 | 49.13 | 1600.0 |
| 2015-04-29 06:00:00 | MSFT | Stock | 49.12 | 49.13 | 49.1 | 49.13 | 8300.0 |
| 2015-04-29 06:30:00 | MSFT | Stock | 49.04 | 49.06 | 49.03 | 49.03 | 2700.0 |
| 2015-04-29 07:00:00 | MSFT | Stock | 49.03 | 49.03 | 48.97 | 49.0 | 7438.0 |
| 2015-04-29 07:30:00 | MSFT | Stock | 48.96 | 49.03 | 48.96 | 48.99 | 5001.0 |
| 2015-04-29 08:00:00 | MSFT | Stock | 48.98 | 49.0 | 48.89 | 48.89 | 33349.0 |
| 2015-04-29 08:30:00 | MSFT | Stock | 48.89 | 48.95 | 48.86 | 48.88 | 29596.0 |
| 2015-04-29 09:00:00 | MSFT | Stock | 48.86 | 48.92 | 48.71 | 48.75 | 121256.0 |
| 2015-04-29 09:30:00 | MSFT | Stock | 48.72 | 48.94 | 48.6 | 48.66 | 5821692.0 |
| 2015-04-29 10:00:00 | MSFT | Stock | 48.655 | 48.69 | 48.5 | 48.525 | 3488754.0 |
| 2015-04-29 10:30:00 | MSFT | Stock | 48.53 | 48.93 | 48.51 | 48.89 | 2956464.0 |
| 2015-04-29 11:00:00 | MSFT | Stock | 48.89 | 49.05 | 48.8 | 48.91 | 2696364.0 |
| 2015-04-29 11:30:00 | MSFT | Stock | 48.908 | 48.955 | 48.83 | 48.915 | 2580751.0 |
| 2015-04-29 12:00:00 | MSFT | Stock | 48.91 | 48.926 | 48.69 | 48.805 | 2273244.0 |
| 2015-04-29 12:30:00 | MSFT | Stock | 48.8 | 48.85 | 48.7 | 48.808 | 1959660.0 |
| 2015-04-29 13:00:00 | MSFT | Stock | 48.81 | 48.88 | 48.72 | 48.84 | 2042398.0 |
> showing 50 of 81,910 rows — these rows as CSV