PREVIEW / stock_5min / 2013-03-06
file: by_date/stock_5min/2013/2013-03-06.parquet size: 4.9 MB rows: 328,765 symbols: 3,482
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-06 04:00:00 | AAPL | Stock | 15.3979 | 15.3979 | 15.3979 | 15.3979 | 8400.0 |
| 2013-03-06 04:10:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 2800.0 |
| 2013-03-06 04:30:00 | AAPL | Stock | 15.4286 | 15.4286 | 15.4286 | 15.4286 | 2800.0 |
| 2013-03-06 04:35:00 | AAPL | Stock | 15.4286 | 15.4286 | 15.4286 | 15.4286 | 5600.0 |
| 2013-03-06 04:45:00 | AAPL | Stock | 15.4286 | 15.4286 | 15.4286 | 15.4286 | 2800.0 |
| 2013-03-06 05:05:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4007 | 15.4007 | 14000.0 |
| 2013-03-06 05:25:00 | AAPL | Stock | 15.4286 | 15.4286 | 15.4286 | 15.4286 | 7560.0 |
| 2013-03-06 05:40:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4214 | 15.4214 | 5600.0 |
| 2013-03-06 05:55:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4146 | 15.4146 | 8568.0 |
| 2013-03-06 06:00:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4214 | 15.4214 | 2800.0 |
| 2013-03-06 06:05:00 | AAPL | Stock | 15.4125 | 15.4125 | 15.4125 | 15.4125 | 2800.0 |
| 2013-03-06 06:15:00 | AAPL | Stock | 15.4125 | 15.4125 | 15.4125 | 15.4125 | 2800.0 |
| 2013-03-06 06:25:00 | AAPL | Stock | 15.4125 | 15.4232 | 15.4125 | 15.4232 | 22400.0 |
| 2013-03-06 07:00:00 | AAPL | Stock | 15.4196 | 15.4282 | 15.4121 | 15.4282 | 58800.0 |
| 2013-03-06 07:05:00 | AAPL | Stock | 15.4107 | 15.4143 | 15.4018 | 15.4143 | 39032.0 |
| 2013-03-06 07:10:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.4018 | 15.4018 | 5600.0 |
| 2013-03-06 07:15:00 | AAPL | Stock | 15.4107 | 15.4193 | 15.4107 | 15.4193 | 14000.0 |
| 2013-03-06 07:20:00 | AAPL | Stock | 15.4193 | 15.4464 | 15.4193 | 15.4464 | 71680.0 |
| 2013-03-06 07:25:00 | AAPL | Stock | 15.4436 | 15.4554 | 15.4436 | 15.4554 | 23016.0 |
| 2013-03-06 07:30:00 | AAPL | Stock | 15.45 | 15.45 | 15.4286 | 15.4286 | 69860.0 |
| 2013-03-06 07:35:00 | AAPL | Stock | 15.4371 | 15.4371 | 15.4371 | 15.4371 | 2800.0 |
| 2013-03-06 07:40:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.375 | 15.3846 | 98196.0 |
| 2013-03-06 07:45:00 | AAPL | Stock | 15.3661 | 15.3693 | 15.32 | 15.3257 | 243908.0 |
| 2013-03-06 07:50:00 | AAPL | Stock | 15.3375 | 15.3571 | 15.3318 | 15.3561 | 225008.0 |
| 2013-03-06 07:55:00 | AAPL | Stock | 15.3532 | 15.3746 | 15.3393 | 15.3746 | 161700.0 |
| 2013-03-06 08:00:00 | AAPL | Stock | 15.3754 | 15.4286 | 15.3518 | 15.3929 | 301000.0 |
| 2013-03-06 08:05:00 | AAPL | Stock | 15.3921 | 15.4061 | 15.3857 | 15.4036 | 168392.0 |
| 2013-03-06 08:10:00 | AAPL | Stock | 15.4071 | 15.4268 | 15.4054 | 15.4268 | 219968.0 |
| 2013-03-06 08:15:00 | AAPL | Stock | 15.425 | 15.4568 | 15.3929 | 15.4464 | 468916.0 |
| 2013-03-06 08:20:00 | AAPL | Stock | 15.4443 | 15.4532 | 15.4375 | 15.4529 | 82572.0 |
| 2013-03-06 08:25:00 | AAPL | Stock | 15.4529 | 15.4564 | 15.4396 | 15.4464 | 216916.0 |
| 2013-03-06 08:30:00 | AAPL | Stock | 15.4518 | 15.4821 | 15.4464 | 15.473 | 505708.0 |
| 2013-03-06 08:35:00 | AAPL | Stock | 15.4714 | 15.4721 | 15.4475 | 15.4571 | 445228.0 |
| 2013-03-06 08:40:00 | AAPL | Stock | 15.4589 | 15.4593 | 15.4411 | 15.4411 | 216188.0 |
| 2013-03-06 08:45:00 | AAPL | Stock | 15.4457 | 15.4596 | 15.4411 | 15.4557 | 91728.0 |
| 2013-03-06 08:50:00 | AAPL | Stock | 15.4543 | 15.475 | 15.4507 | 15.4679 | 238896.0 |
| 2013-03-06 08:55:00 | AAPL | Stock | 15.4679 | 15.4696 | 15.4557 | 15.4571 | 212184.0 |
| 2013-03-06 09:00:00 | AAPL | Stock | 15.4561 | 15.4643 | 15.45 | 15.4543 | 269836.0 |
| 2013-03-06 09:05:00 | AAPL | Stock | 15.4554 | 15.4843 | 15.4554 | 15.4775 | 205240.0 |
| 2013-03-06 09:10:00 | AAPL | Stock | 15.4775 | 15.4886 | 15.4682 | 15.4854 | 388724.0 |
| 2013-03-06 09:15:00 | AAPL | Stock | 15.4825 | 15.4993 | 15.4821 | 15.4911 | 357280.0 |
| 2013-03-06 09:20:00 | AAPL | Stock | 15.4914 | 15.5132 | 15.4907 | 15.4971 | 941360.0 |
| 2013-03-06 09:25:00 | AAPL | Stock | 15.4968 | 15.5357 | 15.4936 | 15.5243 | 1767696.0 |
| 2013-03-06 09:30:00 | AAPL | Stock | 15.52 | 15.5446 | 15.4611 | 15.4876 | 23992276.0 |
| 2013-03-06 09:35:00 | AAPL | Stock | 15.4896 | 15.4946 | 15.3625 | 15.3859 | 17018232.0 |
| 2013-03-06 09:40:00 | AAPL | Stock | 15.3859 | 15.3946 | 15.3321 | 15.3554 | 15198372.0 |
| 2013-03-06 09:45:00 | AAPL | Stock | 15.3568 | 15.3571 | 15.2839 | 15.2975 | 15841812.0 |
| 2013-03-06 09:50:00 | AAPL | Stock | 15.3025 | 15.3393 | 15.2918 | 15.3164 | 9243612.0 |
| 2013-03-06 09:55:00 | AAPL | Stock | 15.3161 | 15.3179 | 15.2268 | 15.25 | 16451876.0 |
| 2013-03-06 10:00:00 | AAPL | Stock | 15.25 | 15.2679 | 15.2282 | 15.2364 | 10497228.0 |
> showing 50 of 328,765 rows — these rows as CSV