PREVIEW / stock_5min / 2013-04-12
file: by_date/stock_5min/2013/2013-04-12.parquet size: 4.8 MB rows: 320,502 symbols: 3,491
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-04-12 04:35:00 | AAPL | Stock | 15.4821 | 15.4821 | 15.4821 | 15.4821 | 2800.0 |
| 2013-04-12 06:50:00 | AAPL | Stock | 15.4579 | 15.4579 | 15.4579 | 15.4579 | 11200.0 |
| 2013-04-12 07:10:00 | AAPL | Stock | 15.4568 | 15.4568 | 15.4568 | 15.4568 | 2800.0 |
| 2013-04-12 07:20:00 | AAPL | Stock | 15.4143 | 15.4143 | 15.4107 | 15.4143 | 14000.0 |
| 2013-04-12 07:35:00 | AAPL | Stock | 15.4154 | 15.4154 | 15.4154 | 15.4154 | 5600.0 |
| 2013-04-12 07:45:00 | AAPL | Stock | 15.4282 | 15.4282 | 15.4282 | 15.4282 | 2800.0 |
| 2013-04-12 07:50:00 | AAPL | Stock | 15.4379 | 15.4607 | 15.4379 | 15.4607 | 30604.0 |
| 2013-04-12 07:55:00 | AAPL | Stock | 15.4464 | 15.4464 | 15.4464 | 15.4464 | 2800.0 |
| 2013-04-12 08:00:00 | AAPL | Stock | 15.4421 | 15.5143 | 15.4286 | 15.4414 | 42616.0 |
| 2013-04-12 08:05:00 | AAPL | Stock | 15.4286 | 15.4479 | 15.4286 | 15.4464 | 34440.0 |
| 2013-04-12 08:10:00 | AAPL | Stock | 15.4571 | 15.4571 | 15.4357 | 15.4357 | 59500.0 |
| 2013-04-12 08:15:00 | AAPL | Stock | 15.4368 | 15.4425 | 15.4368 | 15.4425 | 7112.0 |
| 2013-04-12 08:20:00 | AAPL | Stock | 15.4339 | 15.4357 | 15.4289 | 15.4339 | 52920.0 |
| 2013-04-12 08:25:00 | AAPL | Stock | 15.4314 | 15.4393 | 15.4304 | 15.4393 | 58520.0 |
| 2013-04-12 08:30:00 | AAPL | Stock | 15.4311 | 15.4314 | 15.4121 | 15.4146 | 437836.0 |
| 2013-04-12 08:35:00 | AAPL | Stock | 15.415 | 15.4193 | 15.3929 | 15.3964 | 525840.0 |
| 2013-04-12 08:40:00 | AAPL | Stock | 15.3932 | 15.3968 | 15.3793 | 15.3893 | 414372.0 |
| 2013-04-12 08:45:00 | AAPL | Stock | 15.3893 | 15.4193 | 15.3893 | 15.4189 | 108192.0 |
| 2013-04-12 08:50:00 | AAPL | Stock | 15.4121 | 15.4196 | 15.4089 | 15.4096 | 184800.0 |
| 2013-04-12 08:55:00 | AAPL | Stock | 15.4136 | 15.4168 | 15.4136 | 15.4143 | 19600.0 |
| 2013-04-12 09:00:00 | AAPL | Stock | 15.4082 | 15.4111 | 15.4082 | 15.4111 | 27160.0 |
| 2013-04-12 09:05:00 | AAPL | Stock | 15.4193 | 15.4193 | 15.4143 | 15.4161 | 102256.0 |
| 2013-04-12 09:10:00 | AAPL | Stock | 15.4146 | 15.4146 | 15.3968 | 15.3986 | 152600.0 |
| 2013-04-12 09:15:00 | AAPL | Stock | 15.4107 | 15.4143 | 15.4107 | 15.4139 | 170716.0 |
| 2013-04-12 09:20:00 | AAPL | Stock | 15.4232 | 15.4282 | 15.4143 | 15.4282 | 50400.0 |
| 2013-04-12 09:25:00 | AAPL | Stock | 15.4286 | 15.4982 | 15.4179 | 15.4979 | 1135988.0 |
| 2013-04-12 09:30:00 | AAPL | Stock | 15.4961 | 15.5054 | 15.4164 | 15.4564 | 14314692.0 |
| 2013-04-12 09:35:00 | AAPL | Stock | 15.4564 | 15.4985 | 15.4164 | 15.45 | 6379744.0 |
| 2013-04-12 09:40:00 | AAPL | Stock | 15.4432 | 15.4571 | 15.4196 | 15.4375 | 3959704.0 |
| 2013-04-12 09:45:00 | AAPL | Stock | 15.4404 | 15.4414 | 15.4107 | 15.4332 | 4558904.0 |
| 2013-04-12 09:50:00 | AAPL | Stock | 15.4297 | 15.4354 | 15.4029 | 15.4032 | 5363204.0 |
| 2013-04-12 09:55:00 | AAPL | Stock | 15.405 | 15.4361 | 15.4032 | 15.4173 | 3752000.0 |
| 2013-04-12 10:00:00 | AAPL | Stock | 15.4143 | 15.4225 | 15.4054 | 15.4121 | 3371284.0 |
| 2013-04-12 10:05:00 | AAPL | Stock | 15.4121 | 15.4429 | 15.4082 | 15.4296 | 3684268.0 |
| 2013-04-12 10:10:00 | AAPL | Stock | 15.4321 | 15.4786 | 15.425 | 15.4639 | 7265356.0 |
| 2013-04-12 10:15:00 | AAPL | Stock | 15.4643 | 15.4667 | 15.4418 | 15.4436 | 2337720.0 |
| 2013-04-12 10:20:00 | AAPL | Stock | 15.4418 | 15.4546 | 15.4352 | 15.4411 | 1798468.0 |
| 2013-04-12 10:25:00 | AAPL | Stock | 15.4407 | 15.46 | 15.4304 | 15.4571 | 1724044.0 |
| 2013-04-12 10:30:00 | AAPL | Stock | 15.4554 | 15.4636 | 15.4382 | 15.4436 | 3019912.0 |
| 2013-04-12 10:35:00 | AAPL | Stock | 15.4436 | 15.4436 | 15.4204 | 15.4332 | 2556540.0 |
| 2013-04-12 10:40:00 | AAPL | Stock | 15.4307 | 15.4307 | 15.4054 | 15.4086 | 3289580.0 |
| 2013-04-12 10:45:00 | AAPL | Stock | 15.4118 | 15.4118 | 15.3596 | 15.362 | 8273636.0 |
| 2013-04-12 10:50:00 | AAPL | Stock | 15.3629 | 15.3746 | 15.3411 | 15.3586 | 9668820.0 |
| 2013-04-12 10:55:00 | AAPL | Stock | 15.3601 | 15.3743 | 15.3482 | 15.3661 | 5618536.0 |
| 2013-04-12 11:00:00 | AAPL | Stock | 15.3646 | 15.3711 | 15.3525 | 15.3529 | 2981244.0 |
| 2013-04-12 11:05:00 | AAPL | Stock | 15.3521 | 15.3571 | 15.3307 | 15.3418 | 4568340.0 |
| 2013-04-12 11:10:00 | AAPL | Stock | 15.3418 | 15.3557 | 15.3388 | 15.3514 | 3032988.0 |
| 2013-04-12 11:15:00 | AAPL | Stock | 15.3539 | 15.3707 | 15.3464 | 15.3656 | 2995748.0 |
| 2013-04-12 11:20:00 | AAPL | Stock | 15.365 | 15.3689 | 15.3518 | 15.3557 | 2847404.0 |
| 2013-04-12 11:25:00 | AAPL | Stock | 15.3529 | 15.3689 | 15.3304 | 15.3686 | 2731260.0 |
> showing 50 of 320,502 rows — these rows as CSV