PREVIEW / stock_5min / 2010-06-16
file: by_date/stock_5min/2010/2010-06-16.parquet size: 4.7 MB rows: 322,376 symbols: 3,459
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-06-16 05:00:00 | AAPL | Stock | 9.2321 | 9.2321 | 9.2321 | 9.2321 | 5600.0 |
| 2010-06-16 05:45:00 | AAPL | Stock | 9.2196 | 9.2196 | 9.2196 | 9.2196 | 3500.0 |
| 2010-06-16 06:00:00 | AAPL | Stock | 9.22 | 9.2239 | 9.2196 | 9.2196 | 26600.0 |
| 2010-06-16 07:00:00 | AAPL | Stock | 9.2554 | 9.2554 | 9.2464 | 9.2464 | 8400.0 |
| 2010-06-16 07:10:00 | AAPL | Stock | 9.2425 | 9.2425 | 9.2389 | 9.2389 | 8400.0 |
| 2010-06-16 07:25:00 | AAPL | Stock | 9.2482 | 9.2554 | 9.2482 | 9.2554 | 8400.0 |
| 2010-06-16 07:30:00 | AAPL | Stock | 9.2554 | 9.2554 | 9.2554 | 9.2554 | 2800.0 |
| 2010-06-16 07:35:00 | AAPL | Stock | 9.2557 | 9.275 | 9.2543 | 9.275 | 58800.0 |
| 2010-06-16 07:40:00 | AAPL | Stock | 9.275 | 9.2821 | 9.2575 | 9.2575 | 144984.0 |
| 2010-06-16 07:45:00 | AAPL | Stock | 9.2696 | 9.2821 | 9.2457 | 9.2589 | 58800.0 |
| 2010-06-16 07:50:00 | AAPL | Stock | 9.2568 | 9.2568 | 9.2546 | 9.2546 | 23856.0 |
| 2010-06-16 07:55:00 | AAPL | Stock | 9.2518 | 9.2518 | 9.2518 | 9.2518 | 56000.0 |
| 2010-06-16 08:00:00 | AAPL | Stock | 9.2536 | 9.2582 | 9.2279 | 9.2339 | 340760.0 |
| 2010-06-16 08:05:00 | AAPL | Stock | 9.2357 | 9.2389 | 9.2275 | 9.2289 | 225344.0 |
| 2010-06-16 08:10:00 | AAPL | Stock | 9.2321 | 9.2321 | 9.2214 | 9.225 | 245672.0 |
| 2010-06-16 08:15:00 | AAPL | Stock | 9.225 | 9.2318 | 9.2221 | 9.2304 | 116984.0 |
| 2010-06-16 08:20:00 | AAPL | Stock | 9.2282 | 9.2414 | 9.2254 | 9.2254 | 178080.0 |
| 2010-06-16 08:25:00 | AAPL | Stock | 9.2239 | 9.2293 | 9.2214 | 9.2221 | 107380.0 |
| 2010-06-16 08:30:00 | AAPL | Stock | 9.2225 | 9.2286 | 9.2071 | 9.2257 | 669928.0 |
| 2010-06-16 08:35:00 | AAPL | Stock | 9.2257 | 9.2379 | 9.2257 | 9.2339 | 557480.0 |
| 2010-06-16 08:40:00 | AAPL | Stock | 9.2336 | 9.2411 | 9.2261 | 9.2411 | 215880.0 |
| 2010-06-16 08:45:00 | AAPL | Stock | 9.2304 | 9.243 | 9.2304 | 9.2386 | 103600.0 |
| 2010-06-16 08:50:00 | AAPL | Stock | 9.2389 | 9.2696 | 9.2361 | 9.2696 | 774900.0 |
| 2010-06-16 08:55:00 | AAPL | Stock | 9.268 | 9.2721 | 9.2643 | 9.2679 | 400988.0 |
| 2010-06-16 09:00:00 | AAPL | Stock | 9.2643 | 9.2889 | 9.26 | 9.2889 | 751240.0 |
| 2010-06-16 09:05:00 | AAPL | Stock | 9.2929 | 9.3168 | 9.2911 | 9.3132 | 1296596.0 |
| 2010-06-16 09:10:00 | AAPL | Stock | 9.3136 | 9.3332 | 9.3136 | 9.3318 | 1223712.0 |
| 2010-06-16 09:15:00 | AAPL | Stock | 9.3286 | 9.3489 | 9.3286 | 9.3461 | 861112.0 |
| 2010-06-16 09:20:00 | AAPL | Stock | 9.3436 | 9.3464 | 9.325 | 9.3321 | 513576.0 |
| 2010-06-16 09:25:00 | AAPL | Stock | 9.3318 | 9.3475 | 9.3071 | 9.325 | 1089508.0 |
| 2010-06-16 09:30:00 | AAPL | Stock | 9.325 | 9.3704 | 9.3082 | 9.3632 | 31929548.0 |
| 2010-06-16 09:35:00 | AAPL | Stock | 9.3636 | 9.4014 | 9.3593 | 9.3896 | 24534972.0 |
| 2010-06-16 09:40:00 | AAPL | Stock | 9.3904 | 9.4161 | 9.3832 | 9.4161 | 18409832.0 |
| 2010-06-16 09:45:00 | AAPL | Stock | 9.4161 | 9.4239 | 9.4054 | 9.4171 | 17690764.0 |
| 2010-06-16 09:50:00 | AAPL | Stock | 9.4171 | 9.4193 | 9.3875 | 9.3957 | 15844332.0 |
| 2010-06-16 09:55:00 | AAPL | Stock | 9.3957 | 9.4107 | 9.3936 | 9.4104 | 9285304.0 |
| 2010-06-16 10:00:00 | AAPL | Stock | 9.4104 | 9.4136 | 9.3982 | 9.4089 | 8239420.0 |
| 2010-06-16 10:05:00 | AAPL | Stock | 9.4098 | 9.4124 | 9.3864 | 9.3871 | 9483936.0 |
| 2010-06-16 10:10:00 | AAPL | Stock | 9.3871 | 9.4036 | 9.3807 | 9.3996 | 8683808.0 |
| 2010-06-16 10:15:00 | AAPL | Stock | 9.4 | 9.4011 | 9.3882 | 9.3957 | 5798212.0 |
| 2010-06-16 10:20:00 | AAPL | Stock | 9.395 | 9.395 | 9.3771 | 9.3789 | 7953148.0 |
| 2010-06-16 10:25:00 | AAPL | Stock | 9.3786 | 9.3932 | 9.3764 | 9.3893 | 8638952.0 |
| 2010-06-16 10:30:00 | AAPL | Stock | 9.3871 | 9.3961 | 9.3714 | 9.382 | 10000116.0 |
| 2010-06-16 10:35:00 | AAPL | Stock | 9.3821 | 9.4003 | 9.3779 | 9.3907 | 9964164.0 |
| 2010-06-16 10:40:00 | AAPL | Stock | 9.3907 | 9.4093 | 9.39 | 9.4075 | 10149692.0 |
| 2010-06-16 10:45:00 | AAPL | Stock | 9.4072 | 9.4089 | 9.3932 | 9.3932 | 7122864.0 |
| 2010-06-16 10:50:00 | AAPL | Stock | 9.3939 | 9.4032 | 9.3896 | 9.3954 | 7174132.0 |
| 2010-06-16 10:55:00 | AAPL | Stock | 9.395 | 9.4271 | 9.395 | 9.4271 | 14271180.0 |
| 2010-06-16 11:00:00 | AAPL | Stock | 9.4271 | 9.4275 | 9.4082 | 9.4158 | 8788276.0 |
| 2010-06-16 11:05:00 | AAPL | Stock | 9.4161 | 9.4482 | 9.4161 | 9.4379 | 16459464.0 |
> showing 50 of 322,376 rows — these rows as CSV