PREVIEW / stock_5min / 2012-06-15
file: by_date/stock_5min/2012/2012-06-15.parquet size: 5.0 MB rows: 341,495 symbols: 3,532
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-06-15 04:15:00 | AAPL | Stock | 20.4714 | 20.4714 | 20.4714 | 20.4714 | 2800.0 |
| 2012-06-15 05:55:00 | AAPL | Stock | 20.48 | 20.48 | 20.48 | 20.48 | 2800.0 |
| 2012-06-15 06:00:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 2800.0 |
| 2012-06-15 06:05:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 11200.0 |
| 2012-06-15 06:10:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 5600.0 |
| 2012-06-15 06:15:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 8960.0 |
| 2012-06-15 07:00:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4732 | 20.4804 | 27048.0 |
| 2012-06-15 07:05:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4804 | 20.4804 | 5600.0 |
| 2012-06-15 07:10:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4679 | 20.4679 | 36400.0 |
| 2012-06-15 07:20:00 | AAPL | Stock | 20.4786 | 20.4804 | 20.4786 | 20.4804 | 11200.0 |
| 2012-06-15 07:25:00 | AAPL | Stock | 20.4804 | 20.4925 | 20.4804 | 20.4925 | 14392.0 |
| 2012-06-15 07:30:00 | AAPL | Stock | 20.4957 | 20.4964 | 20.4957 | 20.4964 | 8400.0 |
| 2012-06-15 07:40:00 | AAPL | Stock | 20.4957 | 20.4957 | 20.4957 | 20.4957 | 5600.0 |
| 2012-06-15 07:50:00 | AAPL | Stock | 20.4829 | 20.4829 | 20.4807 | 20.4807 | 8400.0 |
| 2012-06-15 07:55:00 | AAPL | Stock | 20.4679 | 20.4679 | 20.4679 | 20.4679 | 4200.0 |
| 2012-06-15 08:00:00 | AAPL | Stock | 20.4793 | 20.485 | 20.4604 | 20.4821 | 153804.0 |
| 2012-06-15 08:05:00 | AAPL | Stock | 20.4839 | 20.4921 | 20.4493 | 20.45 | 106372.0 |
| 2012-06-15 08:10:00 | AAPL | Stock | 20.4554 | 20.4554 | 20.4554 | 20.4554 | 2800.0 |
| 2012-06-15 08:15:00 | AAPL | Stock | 20.4521 | 20.4579 | 20.445 | 20.4554 | 44940.0 |
| 2012-06-15 08:20:00 | AAPL | Stock | 20.455 | 20.4589 | 20.4518 | 20.4589 | 29932.0 |
| 2012-06-15 08:25:00 | AAPL | Stock | 20.4557 | 20.4732 | 20.4557 | 20.4668 | 123480.0 |
| 2012-06-15 08:30:00 | AAPL | Stock | 20.4579 | 20.4614 | 20.4393 | 20.4482 | 238000.0 |
| 2012-06-15 08:35:00 | AAPL | Stock | 20.4461 | 20.4546 | 20.4336 | 20.4454 | 76664.0 |
| 2012-06-15 08:40:00 | AAPL | Stock | 20.4454 | 20.4518 | 20.4454 | 20.4518 | 27272.0 |
| 2012-06-15 08:45:00 | AAPL | Stock | 20.4532 | 20.4536 | 20.4454 | 20.4454 | 93128.0 |
| 2012-06-15 08:50:00 | AAPL | Stock | 20.4464 | 20.4464 | 20.4307 | 20.4307 | 171416.0 |
| 2012-06-15 08:55:00 | AAPL | Stock | 20.4361 | 20.4361 | 20.4186 | 20.4214 | 190008.0 |
| 2012-06-15 09:00:00 | AAPL | Stock | 20.4214 | 20.4214 | 20.4129 | 20.4214 | 105000.0 |
| 2012-06-15 09:05:00 | AAPL | Stock | 20.4143 | 20.42 | 20.4129 | 20.42 | 81592.0 |
| 2012-06-15 09:10:00 | AAPL | Stock | 20.4207 | 20.4214 | 20.4143 | 20.4146 | 104916.0 |
| 2012-06-15 09:15:00 | AAPL | Stock | 20.4164 | 20.4211 | 20.4164 | 20.4189 | 42252.0 |
| 2012-06-15 09:20:00 | AAPL | Stock | 20.4214 | 20.4214 | 20.4118 | 20.4196 | 260960.0 |
| 2012-06-15 09:25:00 | AAPL | Stock | 20.4164 | 20.4196 | 20.3711 | 20.3786 | 1402464.0 |
| 2012-06-15 09:30:00 | AAPL | Stock | 20.3864 | 20.4125 | 20.3411 | 20.3768 | 10056256.0 |
| 2012-06-15 09:35:00 | AAPL | Stock | 20.375 | 20.435 | 20.3643 | 20.3846 | 11427052.0 |
| 2012-06-15 09:40:00 | AAPL | Stock | 20.3811 | 20.4036 | 20.3786 | 20.3864 | 5161828.0 |
| 2012-06-15 09:45:00 | AAPL | Stock | 20.3864 | 20.3968 | 20.375 | 20.3929 | 4536196.0 |
| 2012-06-15 09:50:00 | AAPL | Stock | 20.3907 | 20.4282 | 20.3882 | 20.3929 | 5111232.0 |
| 2012-06-15 09:55:00 | AAPL | Stock | 20.3929 | 20.4418 | 20.3889 | 20.4366 | 4489968.0 |
| 2012-06-15 10:00:00 | AAPL | Stock | 20.4314 | 20.4414 | 20.4118 | 20.4286 | 4171860.0 |
| 2012-06-15 10:05:00 | AAPL | Stock | 20.4286 | 20.4514 | 20.4236 | 20.4386 | 6377420.0 |
| 2012-06-15 10:10:00 | AAPL | Stock | 20.439 | 20.439 | 20.4161 | 20.4204 | 3692668.0 |
| 2012-06-15 10:15:00 | AAPL | Stock | 20.4204 | 20.4264 | 20.3829 | 20.3914 | 5052096.0 |
| 2012-06-15 10:20:00 | AAPL | Stock | 20.3911 | 20.4079 | 20.3821 | 20.3822 | 3095708.0 |
| 2012-06-15 10:25:00 | AAPL | Stock | 20.3846 | 20.4068 | 20.3822 | 20.4068 | 2984352.0 |
| 2012-06-15 10:30:00 | AAPL | Stock | 20.4064 | 20.4093 | 20.3857 | 20.3939 | 2906456.0 |
| 2012-06-15 10:35:00 | AAPL | Stock | 20.3925 | 20.4032 | 20.3746 | 20.3805 | 2554720.0 |
| 2012-06-15 10:40:00 | AAPL | Stock | 20.3796 | 20.3893 | 20.3514 | 20.3621 | 3968384.0 |
| 2012-06-15 10:45:00 | AAPL | Stock | 20.3621 | 20.38 | 20.3532 | 20.3771 | 3654196.0 |
| 2012-06-15 10:50:00 | AAPL | Stock | 20.376 | 20.3925 | 20.3704 | 20.3821 | 2906820.0 |
> showing 50 of 341,495 rows — these rows as CSV