PREVIEW / stock_30min / 2011-11-04
file: by_date/stock_30min/2011/2011-11-04.parquet size: 1.4 MB rows: 72,502 symbols: 3,488
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-04 04:00:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3571 | 14.3571 | 5600.0 |
| 2011-11-04 05:00:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3571 | 14.3571 | 19600.0 |
| 2011-11-04 05:30:00 | AAPL | Stock | 14.3929 | 14.3929 | 14.3929 | 14.3929 | 2800.0 |
| 2011-11-04 06:00:00 | AAPL | Stock | 14.4068 | 14.4068 | 14.4068 | 14.4068 | 2800.0 |
| 2011-11-04 07:00:00 | AAPL | Stock | 14.3929 | 14.3932 | 14.3832 | 14.3932 | 56000.0 |
| 2011-11-04 07:30:00 | AAPL | Stock | 14.3939 | 14.4175 | 14.3571 | 14.3571 | 289856.0 |
| 2011-11-04 08:00:00 | AAPL | Stock | 14.3696 | 14.3832 | 14.3214 | 14.3421 | 660464.0 |
| 2011-11-04 08:30:00 | AAPL | Stock | 14.3421 | 14.4057 | 14.2857 | 14.3554 | 2328816.0 |
| 2011-11-04 09:00:00 | AAPL | Stock | 14.3461 | 14.3704 | 14.3246 | 14.3629 | 1086652.0 |
| 2011-11-04 09:30:00 | AAPL | Stock | 14.3586 | 14.4086 | 14.3182 | 14.3329 | 54116776.0 |
| 2011-11-04 10:00:00 | AAPL | Stock | 14.3286 | 14.3536 | 14.2857 | 14.2964 | 29937460.0 |
| 2011-11-04 10:30:00 | AAPL | Stock | 14.295 | 14.3136 | 14.2857 | 14.2957 | 24093944.0 |
| 2011-11-04 11:00:00 | AAPL | Stock | 14.2936 | 14.3075 | 14.2557 | 14.2757 | 28154448.0 |
| 2011-11-04 11:30:00 | AAPL | Stock | 14.2779 | 14.3036 | 14.2726 | 14.2921 | 14582988.0 |
| 2011-11-04 12:00:00 | AAPL | Stock | 14.2927 | 14.3279 | 14.2926 | 14.305 | 17260908.0 |
| 2011-11-04 12:30:00 | AAPL | Stock | 14.3064 | 14.3139 | 14.2914 | 14.3 | 7574252.0 |
| 2011-11-04 13:00:00 | AAPL | Stock | 14.3004 | 14.3375 | 14.2946 | 14.3211 | 12180504.0 |
| 2011-11-04 13:30:00 | AAPL | Stock | 14.3236 | 14.3529 | 14.3125 | 14.3346 | 15497216.0 |
| 2011-11-04 14:00:00 | AAPL | Stock | 14.3341 | 14.3532 | 14.3271 | 14.3479 | 10539368.0 |
| 2011-11-04 14:30:00 | AAPL | Stock | 14.3482 | 14.3529 | 14.3268 | 14.3364 | 11529756.0 |
| 2011-11-04 15:00:00 | AAPL | Stock | 14.3346 | 14.3393 | 14.2975 | 14.3061 | 17921876.0 |
| 2011-11-04 15:30:00 | AAPL | Stock | 14.305 | 14.3157 | 14.2861 | 14.2943 | 35535920.0 |
| 2011-11-04 16:00:00 | AAPL | Stock | 14.2943 | 14.3189 | 14.2857 | 14.2893 | 13393324.0 |
| 2011-11-04 16:30:00 | AAPL | Stock | 14.2893 | 14.3954 | 14.2839 | 14.285 | 2308012.0 |
| 2011-11-04 17:00:00 | AAPL | Stock | 14.2857 | 14.2864 | 14.25 | 14.2821 | 612920.0 |
| 2011-11-04 17:30:00 | AAPL | Stock | 14.2836 | 14.2857 | 14.2786 | 14.2854 | 183792.0 |
| 2011-11-04 18:00:00 | AAPL | Stock | 14.2829 | 14.2943 | 14.2668 | 14.2679 | 85120.0 |
| 2011-11-04 18:30:00 | AAPL | Stock | 14.2679 | 14.2857 | 14.2611 | 14.2857 | 226016.0 |
| 2011-11-04 19:00:00 | AAPL | Stock | 14.2929 | 14.3086 | 14.2857 | 14.2929 | 193032.0 |
| 2011-11-04 19:30:00 | AAPL | Stock | 14.3036 | 14.3393 | 14.3036 | 14.3393 | 226184.0 |
| 2011-11-04 07:00:00 | MSFT | Stock | 26.44 | 26.44 | 26.44 | 26.44 | 300.0 |
| 2011-11-04 08:00:00 | MSFT | Stock | 26.44 | 26.44 | 26.3 | 26.33 | 8700.0 |
| 2011-11-04 08:30:00 | MSFT | Stock | 26.33 | 26.4 | 26.3 | 26.34 | 36844.0 |
| 2011-11-04 09:00:00 | MSFT | Stock | 26.33 | 26.41 | 26.26 | 26.38 | 28556.0 |
| 2011-11-04 09:30:00 | MSFT | Stock | 26.37 | 26.41 | 26.1 | 26.14 | 4963277.0 |
| 2011-11-04 10:00:00 | MSFT | Stock | 26.14 | 26.24 | 26.02 | 26.07 | 3334241.0 |
| 2011-11-04 10:30:00 | MSFT | Stock | 26.079 | 26.11 | 26.0 | 26.09 | 2378618.0 |
| 2011-11-04 11:00:00 | MSFT | Stock | 26.09 | 26.12 | 26.01 | 26.07 | 2558620.0 |
| 2011-11-04 11:30:00 | MSFT | Stock | 26.075 | 26.13 | 26.05 | 26.06 | 1661722.0 |
| 2011-11-04 12:00:00 | MSFT | Stock | 26.07 | 26.14 | 26.06 | 26.1 | 1600123.0 |
| 2011-11-04 12:30:00 | MSFT | Stock | 26.1 | 26.105 | 26.02 | 26.098 | 1682785.0 |
| 2011-11-04 13:00:00 | MSFT | Stock | 26.1 | 26.185 | 26.062 | 26.14 | 1813864.0 |
| 2011-11-04 13:30:00 | MSFT | Stock | 26.14 | 26.29 | 26.13 | 26.25 | 2083009.0 |
| 2011-11-04 14:00:00 | MSFT | Stock | 26.248 | 26.28 | 26.2 | 26.269 | 1303296.0 |
| 2011-11-04 14:30:00 | MSFT | Stock | 26.268 | 26.281 | 26.18 | 26.21 | 1330031.0 |
| 2011-11-04 15:00:00 | MSFT | Stock | 26.219 | 26.22 | 26.14 | 26.195 | 2321489.0 |
| 2011-11-04 15:30:00 | MSFT | Stock | 26.19 | 26.28 | 26.17 | 26.25 | 4947035.0 |
| 2011-11-04 16:00:00 | MSFT | Stock | 26.25 | 26.26 | 26.068 | 26.25 | 2767312.0 |
| 2011-11-04 16:30:00 | MSFT | Stock | 26.227 | 26.53 | 26.227 | 26.25 | 508012.0 |
| 2011-11-04 17:00:00 | MSFT | Stock | 26.24 | 26.24 | 26.24 | 26.24 | 300.0 |
> showing 50 of 72,502 rows — these rows as CSV