PREVIEW / stock_30min / 2012-12-26
file: by_date/stock_30min/2012/2012-12-26.parquet size: 1.4 MB rows: 72,985 symbols: 3,481
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-26 07:00:00 | AAPL | Stock | 18.6468 | 18.6468 | 18.6164 | 18.6418 | 72800.0 |
| 2012-12-26 07:30:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6071 | 18.6136 | 85540.0 |
| 2012-12-26 08:00:00 | AAPL | Stock | 18.6111 | 18.6429 | 18.56 | 18.6057 | 533204.0 |
| 2012-12-26 08:30:00 | AAPL | Stock | 18.5986 | 18.6054 | 18.5668 | 18.57 | 420700.0 |
| 2012-12-26 09:00:00 | AAPL | Stock | 18.5696 | 18.5821 | 18.515 | 18.5275 | 1164632.0 |
| 2012-12-26 09:30:00 | AAPL | Stock | 18.535 | 18.5521 | 18.4439 | 18.5118 | 32228980.0 |
| 2012-12-26 10:00:00 | AAPL | Stock | 18.5064 | 18.5232 | 18.4146 | 18.4321 | 19990964.0 |
| 2012-12-26 10:30:00 | AAPL | Stock | 18.4354 | 18.4386 | 18.3239 | 18.3375 | 36140244.0 |
| 2012-12-26 11:00:00 | AAPL | Stock | 18.3375 | 18.3607 | 18.2679 | 18.2921 | 32896108.0 |
| 2012-12-26 11:30:00 | AAPL | Stock | 18.2964 | 18.3536 | 18.2543 | 18.35 | 22263052.0 |
| 2012-12-26 12:00:00 | AAPL | Stock | 18.3496 | 18.3539 | 18.2961 | 18.3054 | 14066752.0 |
| 2012-12-26 12:30:00 | AAPL | Stock | 18.305 | 18.3571 | 18.2836 | 18.355 | 11770892.0 |
| 2012-12-26 13:00:00 | AAPL | Stock | 18.3511 | 18.415 | 18.3393 | 18.4136 | 16186828.0 |
| 2012-12-26 13:30:00 | AAPL | Stock | 18.413 | 18.4232 | 18.3661 | 18.3832 | 16410996.0 |
| 2012-12-26 14:00:00 | AAPL | Stock | 18.3825 | 18.4239 | 18.3321 | 18.3321 | 16416624.0 |
| 2012-12-26 14:30:00 | AAPL | Stock | 18.3368 | 18.3882 | 18.3182 | 18.3811 | 16088436.0 |
| 2012-12-26 15:00:00 | AAPL | Stock | 18.3746 | 18.3921 | 18.3393 | 18.3618 | 13645380.0 |
| 2012-12-26 15:30:00 | AAPL | Stock | 18.3625 | 18.3682 | 18.2889 | 18.3179 | 35775964.0 |
| 2012-12-26 16:00:00 | AAPL | Stock | 18.325 | 18.3839 | 18.2939 | 18.2946 | 7134764.0 |
| 2012-12-26 16:30:00 | AAPL | Stock | 18.2954 | 18.3068 | 18.2896 | 18.295 | 321132.0 |
| 2012-12-26 17:00:00 | AAPL | Stock | 18.295 | 18.295 | 18.2811 | 18.2843 | 355964.0 |
| 2012-12-26 17:30:00 | AAPL | Stock | 18.2839 | 18.2857 | 18.2793 | 18.2857 | 65044.0 |
| 2012-12-26 18:00:00 | AAPL | Stock | 18.2854 | 18.2857 | 18.2793 | 18.2793 | 26936.0 |
| 2012-12-26 18:30:00 | AAPL | Stock | 18.2818 | 18.2857 | 18.2786 | 18.2786 | 104020.0 |
| 2012-12-26 19:00:00 | AAPL | Stock | 18.2768 | 18.2889 | 18.2743 | 18.2857 | 155008.0 |
| 2012-12-26 19:30:00 | AAPL | Stock | 18.2857 | 18.2889 | 18.2679 | 18.2707 | 179508.0 |
| 2012-12-26 08:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.09 | 27.09 | 2564.0 |
| 2012-12-26 08:30:00 | MSFT | Stock | 27.09 | 27.12 | 27.08 | 27.08 | 2620.0 |
| 2012-12-26 09:00:00 | MSFT | Stock | 27.08 | 27.09 | 27.01 | 27.06 | 18585.0 |
| 2012-12-26 09:30:00 | MSFT | Stock | 27.03 | 27.2 | 27.01 | 27.12 | 3584622.0 |
| 2012-12-26 10:00:00 | MSFT | Stock | 27.13 | 27.15 | 26.98 | 27.0 | 2823775.0 |
| 2012-12-26 10:30:00 | MSFT | Stock | 27.0 | 27.01 | 26.82 | 26.82 | 2204423.0 |
| 2012-12-26 11:00:00 | MSFT | Stock | 26.825 | 26.83 | 26.75 | 26.76 | 3037095.0 |
| 2012-12-26 11:30:00 | MSFT | Stock | 26.758 | 26.975 | 26.7 | 26.945 | 2979268.0 |
| 2012-12-26 12:00:00 | MSFT | Stock | 26.945 | 26.95 | 26.81 | 26.845 | 1362497.0 |
| 2012-12-26 12:30:00 | MSFT | Stock | 26.845 | 26.9 | 26.8 | 26.862 | 1674975.0 |
| 2012-12-26 13:00:00 | MSFT | Stock | 26.87 | 26.91 | 26.8 | 26.85 | 1229726.0 |
| 2012-12-26 13:30:00 | MSFT | Stock | 26.84 | 26.92 | 26.82 | 26.82 | 2164570.0 |
| 2012-12-26 14:00:00 | MSFT | Stock | 26.83 | 26.93 | 26.82 | 26.85 | 1250594.0 |
| 2012-12-26 14:30:00 | MSFT | Stock | 26.85 | 26.95 | 26.82 | 26.92 | 1669381.0 |
| 2012-12-26 15:00:00 | MSFT | Stock | 26.92 | 26.93 | 26.84 | 26.87 | 1776067.0 |
| 2012-12-26 15:30:00 | MSFT | Stock | 26.88 | 26.89 | 26.81 | 26.885 | 4374006.0 |
| 2012-12-26 16:00:00 | MSFT | Stock | 26.86 | 26.899 | 26.86 | 26.89 | 1233663.0 |
| 2012-12-26 16:30:00 | MSFT | Stock | 26.89 | 26.89 | 26.86 | 26.86 | 1654.0 |
| 2012-12-26 17:00:00 | MSFT | Stock | 26.86 | 26.86 | 26.85 | 26.86 | 979.0 |
| 2012-12-26 17:30:00 | MSFT | Stock | 26.88 | 26.88 | 26.85 | 26.85 | 350.0 |
| 2012-12-26 18:00:00 | MSFT | Stock | 26.87 | 26.87 | 26.87 | 26.87 | 400.0 |
| 2012-12-26 18:30:00 | MSFT | Stock | 26.87 | 26.87 | 26.86 | 26.86 | 4620.0 |
| 2012-12-26 19:30:00 | MSFT | Stock | 26.86 | 26.86 | 26.85 | 26.85 | 5268.0 |
| 2012-12-26 09:30:00 | NVDA | Stock | 0.3055 | 0.3105 | 0.3055 | 0.3093 | 28758320.0 |
> showing 50 of 72,985 rows — these rows as CSV