PREVIEW / stock_5min / 2010-10-18
file: by_date/stock_5min/2010/2010-10-18.parquet size: 4.7 MB rows: 325,757 symbols: 3,503
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-18 04:00:00 | AAPL | Stock | 11.3182 | 11.3182 | 11.3182 | 11.3182 | 11060.0 |
| 2010-10-18 05:05:00 | AAPL | Stock | 11.2275 | 11.2275 | 11.2275 | 11.2275 | 4480.0 |
| 2010-10-18 05:50:00 | AAPL | Stock | 11.2789 | 11.2789 | 11.2789 | 11.2789 | 2800.0 |
| 2010-10-18 06:10:00 | AAPL | Stock | 11.2718 | 11.2718 | 11.2693 | 11.2693 | 8400.0 |
| 2010-10-18 06:20:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 3080.0 |
| 2010-10-18 06:35:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-10-18 06:40:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-10-18 07:00:00 | AAPL | Stock | 11.2854 | 11.3 | 11.275 | 11.2964 | 103040.0 |
| 2010-10-18 07:05:00 | AAPL | Stock | 11.3 | 11.3143 | 11.2946 | 11.3036 | 174160.0 |
| 2010-10-18 07:10:00 | AAPL | Stock | 11.3125 | 11.3143 | 11.2911 | 11.3 | 99148.0 |
| 2010-10-18 07:15:00 | AAPL | Stock | 11.2932 | 11.3014 | 11.2714 | 11.3014 | 279888.0 |
| 2010-10-18 07:20:00 | AAPL | Stock | 11.305 | 11.305 | 11.2882 | 11.305 | 11200.0 |
| 2010-10-18 07:25:00 | AAPL | Stock | 11.3018 | 11.3018 | 11.2943 | 11.2943 | 42000.0 |
| 2010-10-18 07:30:00 | AAPL | Stock | 11.2925 | 11.3125 | 11.2925 | 11.3107 | 166908.0 |
| 2010-10-18 07:35:00 | AAPL | Stock | 11.3164 | 11.3239 | 11.3125 | 11.3143 | 101220.0 |
| 2010-10-18 07:40:00 | AAPL | Stock | 11.3211 | 11.33 | 11.3129 | 11.33 | 27720.0 |
| 2010-10-18 07:45:00 | AAPL | Stock | 11.3221 | 11.3314 | 11.3221 | 11.325 | 44800.0 |
| 2010-10-18 07:50:00 | AAPL | Stock | 11.3254 | 11.33 | 11.3125 | 11.3171 | 280000.0 |
| 2010-10-18 07:55:00 | AAPL | Stock | 11.3071 | 11.3071 | 11.2857 | 11.2896 | 261744.0 |
| 2010-10-18 08:00:00 | AAPL | Stock | 11.2964 | 11.4243 | 11.2864 | 11.3393 | 1878772.0 |
| 2010-10-18 08:05:00 | AAPL | Stock | 11.3393 | 11.375 | 11.3393 | 11.345 | 2099524.0 |
| 2010-10-18 08:10:00 | AAPL | Stock | 11.345 | 11.3893 | 11.3414 | 11.3893 | 1368808.0 |
| 2010-10-18 08:15:00 | AAPL | Stock | 11.3893 | 11.4182 | 11.3757 | 11.4014 | 1903132.0 |
| 2010-10-18 08:20:00 | AAPL | Stock | 11.4071 | 11.4243 | 11.395 | 11.4211 | 1986852.0 |
| 2010-10-18 08:25:00 | AAPL | Stock | 11.4196 | 11.4246 | 11.4061 | 11.4232 | 1878968.0 |
| 2010-10-18 08:30:00 | AAPL | Stock | 11.4221 | 11.4232 | 11.4036 | 11.4107 | 1091356.0 |
| 2010-10-18 08:35:00 | AAPL | Stock | 11.4111 | 11.4143 | 11.3893 | 11.3954 | 1563996.0 |
| 2010-10-18 08:40:00 | AAPL | Stock | 11.3964 | 11.3979 | 11.3861 | 11.3875 | 1050196.0 |
| 2010-10-18 08:45:00 | AAPL | Stock | 11.3875 | 11.3932 | 11.3789 | 11.3804 | 1715700.0 |
| 2010-10-18 08:50:00 | AAPL | Stock | 11.3811 | 11.3879 | 11.3757 | 11.3875 | 645288.0 |
| 2010-10-18 08:55:00 | AAPL | Stock | 11.3886 | 11.3893 | 11.3821 | 11.3857 | 567784.0 |
| 2010-10-18 09:00:00 | AAPL | Stock | 11.3839 | 11.3875 | 11.3757 | 11.3782 | 650776.0 |
| 2010-10-18 09:05:00 | AAPL | Stock | 11.3782 | 11.3804 | 11.3714 | 11.3736 | 867440.0 |
| 2010-10-18 09:10:00 | AAPL | Stock | 11.3743 | 11.3821 | 11.3743 | 11.38 | 885920.0 |
| 2010-10-18 09:15:00 | AAPL | Stock | 11.3796 | 11.3846 | 11.3675 | 11.3696 | 712124.0 |
| 2010-10-18 09:20:00 | AAPL | Stock | 11.3707 | 11.3764 | 11.3625 | 11.3657 | 823004.0 |
| 2010-10-18 09:25:00 | AAPL | Stock | 11.3643 | 11.3896 | 11.3625 | 11.3739 | 1946924.0 |
| 2010-10-18 09:30:00 | AAPL | Stock | 11.3732 | 11.3929 | 11.3036 | 11.3071 | 44754724.0 |
| 2010-10-18 09:35:00 | AAPL | Stock | 11.3061 | 11.3111 | 11.2246 | 11.285 | 54885488.0 |
| 2010-10-18 09:40:00 | AAPL | Stock | 11.285 | 11.3361 | 11.2792 | 11.3236 | 37016784.0 |
| 2010-10-18 09:45:00 | AAPL | Stock | 11.3236 | 11.3729 | 11.3218 | 11.3668 | 25431784.0 |
| 2010-10-18 09:50:00 | AAPL | Stock | 11.3661 | 11.3679 | 11.3257 | 11.3268 | 22072092.0 |
| 2010-10-18 09:55:00 | AAPL | Stock | 11.3257 | 11.3518 | 11.3111 | 11.3332 | 16754584.0 |
| 2010-10-18 10:00:00 | AAPL | Stock | 11.3339 | 11.3393 | 11.2893 | 11.29 | 17569244.0 |
| 2010-10-18 10:05:00 | AAPL | Stock | 11.2911 | 11.3368 | 11.2893 | 11.3186 | 17287564.0 |
| 2010-10-18 10:10:00 | AAPL | Stock | 11.3179 | 11.3275 | 11.3043 | 11.3189 | 14827960.0 |
| 2010-10-18 10:15:00 | AAPL | Stock | 11.3186 | 11.3536 | 11.3175 | 11.3225 | 16203544.0 |
| 2010-10-18 10:20:00 | AAPL | Stock | 11.3229 | 11.3371 | 11.3207 | 11.3225 | 10729768.0 |
| 2010-10-18 10:25:00 | AAPL | Stock | 11.3225 | 11.3329 | 11.3143 | 11.3189 | 9259152.0 |
| 2010-10-18 10:30:00 | AAPL | Stock | 11.3186 | 11.3221 | 11.3014 | 11.31 | 11494588.0 |
> showing 50 of 325,757 rows — these rows as CSV