PREVIEW / stock_30min / 2015-05-29
file: by_date/stock_30min/2015/2015-05-29.parquet size: 1.6 MB rows: 82,208 symbols: 3,512
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-05-29 04:00:00 | AAPL | Stock | 32.8575 | 32.875 | 32.7825 | 32.8175 | 38632.0 |
| 2015-05-29 04:30:00 | AAPL | Stock | 32.7875 | 32.8 | 32.7875 | 32.8 | 19480.0 |
| 2015-05-29 05:00:00 | AAPL | Stock | 32.8175 | 32.825 | 32.8175 | 32.82 | 9800.0 |
| 2015-05-29 05:30:00 | AAPL | Stock | 32.8225 | 32.825 | 32.8225 | 32.825 | 5048.0 |
| 2015-05-29 06:00:00 | AAPL | Stock | 32.8775 | 32.905 | 32.875 | 32.905 | 2800.0 |
| 2015-05-29 06:30:00 | AAPL | Stock | 32.945 | 32.955 | 32.925 | 32.955 | 8000.0 |
| 2015-05-29 07:00:00 | AAPL | Stock | 32.95 | 32.97 | 32.8975 | 32.8975 | 50036.0 |
| 2015-05-29 07:30:00 | AAPL | Stock | 32.925 | 32.9425 | 32.9175 | 32.93 | 20768.0 |
| 2015-05-29 08:00:00 | AAPL | Stock | 32.9275 | 32.945 | 32.8575 | 32.8575 | 363176.0 |
| 2015-05-29 08:30:00 | AAPL | Stock | 32.88 | 32.9175 | 32.8375 | 32.85 | 335068.0 |
| 2015-05-29 09:00:00 | AAPL | Stock | 32.85 | 32.905 | 32.785 | 32.8 | 209240.0 |
| 2015-05-29 09:30:00 | AAPL | Stock | 32.8075 | 32.8625 | 32.765 | 32.8105 | 19954584.0 |
| 2015-05-29 10:00:00 | AAPL | Stock | 32.815 | 32.86 | 32.6325 | 32.636 | 16160220.0 |
| 2015-05-29 10:30:00 | AAPL | Stock | 32.6375 | 32.68 | 32.475 | 32.545 | 20131200.0 |
| 2015-05-29 11:00:00 | AAPL | Stock | 32.5475 | 32.6425 | 32.535 | 32.58 | 10754984.0 |
| 2015-05-29 11:30:00 | AAPL | Stock | 32.58 | 32.7 | 32.5675 | 32.661 | 8975432.0 |
| 2015-05-29 12:00:00 | AAPL | Stock | 32.6625 | 32.73 | 32.6625 | 32.7025 | 6856320.0 |
| 2015-05-29 12:30:00 | AAPL | Stock | 32.7025 | 32.815 | 32.695 | 32.75 | 8192132.0 |
| 2015-05-29 13:00:00 | AAPL | Stock | 32.745 | 32.7925 | 32.7175 | 32.785 | 4796116.0 |
| 2015-05-29 13:30:00 | AAPL | Stock | 32.785 | 32.8 | 32.7025 | 32.7175 | 5929964.0 |
| 2015-05-29 14:00:00 | AAPL | Stock | 32.7175 | 32.72 | 32.65 | 32.65 | 7011280.0 |
| 2015-05-29 14:30:00 | AAPL | Stock | 32.6475 | 32.665 | 32.5725 | 32.6475 | 11998784.0 |
| 2015-05-29 15:00:00 | AAPL | Stock | 32.6475 | 32.72 | 32.6325 | 32.68 | 10553836.0 |
| 2015-05-29 15:30:00 | AAPL | Stock | 32.6825 | 32.695 | 32.5575 | 32.58 | 20901216.0 |
| 2015-05-29 16:00:00 | AAPL | Stock | 32.57 | 32.66 | 32.5575 | 32.63 | 25598420.0 |
| 2015-05-29 16:30:00 | AAPL | Stock | 32.6325 | 32.6575 | 32.5685 | 32.645 | 309444.0 |
| 2015-05-29 17:00:00 | AAPL | Stock | 32.6375 | 32.6475 | 32.635 | 32.6425 | 100868.0 |
| 2015-05-29 17:30:00 | AAPL | Stock | 32.6375 | 32.65 | 32.635 | 32.635 | 97080.0 |
| 2015-05-29 18:00:00 | AAPL | Stock | 32.6375 | 32.6425 | 32.6275 | 32.635 | 46416.0 |
| 2015-05-29 18:30:00 | AAPL | Stock | 32.63 | 32.6325 | 32.625 | 32.6325 | 26180.0 |
| 2015-05-29 19:00:00 | AAPL | Stock | 32.6275 | 32.6325 | 32.6275 | 32.6275 | 44200.0 |
| 2015-05-29 19:30:00 | AAPL | Stock | 32.635 | 32.6425 | 32.6275 | 32.6325 | 50740.0 |
| 2015-05-29 04:00:00 | MSFT | Stock | 47.28 | 47.28 | 47.28 | 47.28 | 100.0 |
| 2015-05-29 07:00:00 | MSFT | Stock | 47.38 | 47.4 | 47.38 | 47.4 | 400.0 |
| 2015-05-29 08:00:00 | MSFT | Stock | 47.31 | 47.45 | 47.31 | 47.38 | 3600.0 |
| 2015-05-29 08:30:00 | MSFT | Stock | 47.37 | 47.37 | 47.35 | 47.35 | 3100.0 |
| 2015-05-29 09:00:00 | MSFT | Stock | 47.34 | 47.39 | 47.34 | 47.39 | 14569.0 |
| 2015-05-29 09:30:00 | MSFT | Stock | 47.43 | 47.57 | 47.21 | 47.275 | 3464387.0 |
| 2015-05-29 10:00:00 | MSFT | Stock | 47.28 | 47.295 | 46.83 | 46.84 | 1848642.0 |
| 2015-05-29 10:30:00 | MSFT | Stock | 46.84 | 46.86 | 46.59 | 46.7 | 2566447.0 |
| 2015-05-29 11:00:00 | MSFT | Stock | 46.7 | 46.8 | 46.68 | 46.68 | 1496188.0 |
| 2015-05-29 11:30:00 | MSFT | Stock | 46.68 | 46.93 | 46.665 | 46.87 | 1503899.0 |
| 2015-05-29 12:00:00 | MSFT | Stock | 46.87 | 47.07 | 46.861 | 47.065 | 1477484.0 |
| 2015-05-29 12:30:00 | MSFT | Stock | 47.07 | 47.19 | 47.065 | 47.16 | 1640630.0 |
| 2015-05-29 13:00:00 | MSFT | Stock | 47.155 | 47.2 | 47.14 | 47.19 | 1003478.0 |
| 2015-05-29 13:30:00 | MSFT | Stock | 47.19 | 47.219 | 47.01 | 47.03 | 1250402.0 |
| 2015-05-29 14:00:00 | MSFT | Stock | 47.03 | 47.07 | 46.97 | 46.97 | 1120887.0 |
| 2015-05-29 14:30:00 | MSFT | Stock | 46.97 | 46.98 | 46.785 | 46.885 | 1229884.0 |
| 2015-05-29 15:00:00 | MSFT | Stock | 46.88 | 47.07 | 46.86 | 47.04 | 1519658.0 |
| 2015-05-29 15:30:00 | MSFT | Stock | 47.04 | 47.11 | 46.86 | 46.86 | 5341050.0 |
> showing 50 of 82,208 rows — these rows as CSV