PREVIEW / stock_5min / 2011-10-06
file: by_date/stock_5min/2011/2011-10-06.parquet size: 4.8 MB rows: 323,693 symbols: 3,473
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-06 07:10:00 | AAPL | Stock | 13.2143 | 13.375 | 13.2143 | 13.325 | 2315992.0 |
| 2011-10-06 07:15:00 | AAPL | Stock | 13.3368 | 13.4286 | 13.3254 | 13.3861 | 1225308.0 |
| 2011-10-06 07:20:00 | AAPL | Stock | 13.3829 | 13.3964 | 13.3661 | 13.3661 | 568008.0 |
| 2011-10-06 07:25:00 | AAPL | Stock | 13.3661 | 13.3921 | 13.3421 | 13.3921 | 462896.0 |
| 2011-10-06 07:30:00 | AAPL | Stock | 13.3875 | 13.3875 | 13.3571 | 13.3857 | 424872.0 |
| 2011-10-06 07:35:00 | AAPL | Stock | 13.3821 | 13.3821 | 13.3429 | 13.3429 | 936600.0 |
| 2011-10-06 07:40:00 | AAPL | Stock | 13.345 | 13.3768 | 13.3429 | 13.3657 | 414428.0 |
| 2011-10-06 07:45:00 | AAPL | Stock | 13.3636 | 13.3636 | 13.3311 | 13.335 | 608524.0 |
| 2011-10-06 07:50:00 | AAPL | Stock | 13.3321 | 13.3393 | 13.3214 | 13.3375 | 568652.0 |
| 2011-10-06 07:55:00 | AAPL | Stock | 13.3382 | 13.3393 | 13.3214 | 13.3268 | 180040.0 |
| 2011-10-06 08:00:00 | AAPL | Stock | 13.3039 | 13.3929 | 13.2639 | 13.2857 | 2410016.0 |
| 2011-10-06 08:05:00 | AAPL | Stock | 13.2857 | 13.3529 | 13.2786 | 13.3529 | 2066008.0 |
| 2011-10-06 08:10:00 | AAPL | Stock | 13.35 | 13.4189 | 13.3482 | 13.3914 | 2531732.0 |
| 2011-10-06 08:15:00 | AAPL | Stock | 13.3861 | 13.4179 | 13.3839 | 13.3943 | 1655612.0 |
| 2011-10-06 08:20:00 | AAPL | Stock | 13.4014 | 13.4014 | 13.3511 | 13.3643 | 1178744.0 |
| 2011-10-06 08:25:00 | AAPL | Stock | 13.3686 | 13.4018 | 13.3682 | 13.3857 | 1149456.0 |
| 2011-10-06 08:30:00 | AAPL | Stock | 13.3886 | 13.4036 | 13.3661 | 13.3961 | 1032052.0 |
| 2011-10-06 08:35:00 | AAPL | Stock | 13.3929 | 13.4714 | 13.3879 | 13.4657 | 2998324.0 |
| 2011-10-06 08:40:00 | AAPL | Stock | 13.4714 | 13.4761 | 13.4307 | 13.4318 | 1718752.0 |
| 2011-10-06 08:45:00 | AAPL | Stock | 13.4421 | 13.4643 | 13.4318 | 13.4321 | 935872.0 |
| 2011-10-06 08:50:00 | AAPL | Stock | 13.4321 | 13.45 | 13.4043 | 13.4464 | 1195768.0 |
| 2011-10-06 08:55:00 | AAPL | Stock | 13.4464 | 13.4682 | 13.4321 | 13.4643 | 1252608.0 |
| 2011-10-06 09:00:00 | AAPL | Stock | 13.4646 | 13.4696 | 13.4471 | 13.4554 | 1027432.0 |
| 2011-10-06 09:05:00 | AAPL | Stock | 13.4536 | 13.455 | 13.4111 | 13.4132 | 2052596.0 |
| 2011-10-06 09:10:00 | AAPL | Stock | 13.4132 | 13.4211 | 13.3971 | 13.3975 | 1928304.0 |
| 2011-10-06 09:15:00 | AAPL | Stock | 13.3982 | 13.4239 | 13.3829 | 13.4107 | 1329468.0 |
| 2011-10-06 09:20:00 | AAPL | Stock | 13.4104 | 13.4104 | 13.3857 | 13.3882 | 1120560.0 |
| 2011-10-06 09:25:00 | AAPL | Stock | 13.3921 | 13.4086 | 13.3271 | 13.3289 | 3239180.0 |
| 2011-10-06 09:30:00 | AAPL | Stock | 13.3354 | 13.48 | 13.3064 | 13.4796 | 44194136.0 |
| 2011-10-06 09:35:00 | AAPL | Stock | 13.4796 | 13.5268 | 13.4011 | 13.5179 | 28889560.0 |
| 2011-10-06 09:40:00 | AAPL | Stock | 13.5193 | 13.5225 | 13.4471 | 13.4636 | 18248188.0 |
| 2011-10-06 09:45:00 | AAPL | Stock | 13.4643 | 13.4889 | 13.3846 | 13.395 | 17442460.0 |
| 2011-10-06 09:50:00 | AAPL | Stock | 13.3968 | 13.45 | 13.38 | 13.4282 | 13302856.0 |
| 2011-10-06 09:55:00 | AAPL | Stock | 13.4286 | 13.491 | 13.4079 | 13.4564 | 13550908.0 |
| 2011-10-06 10:00:00 | AAPL | Stock | 13.4621 | 13.4821 | 13.4196 | 13.4774 | 11526984.0 |
| 2011-10-06 10:05:00 | AAPL | Stock | 13.4766 | 13.5114 | 13.4646 | 13.4804 | 12107368.0 |
| 2011-10-06 10:10:00 | AAPL | Stock | 13.4871 | 13.5654 | 13.4807 | 13.555 | 18633720.0 |
| 2011-10-06 10:15:00 | AAPL | Stock | 13.5554 | 13.5714 | 13.5104 | 13.5714 | 14734692.0 |
| 2011-10-06 10:20:00 | AAPL | Stock | 13.5714 | 13.6696 | 13.5679 | 13.6586 | 26349120.0 |
| 2011-10-06 10:25:00 | AAPL | Stock | 13.6664 | 13.6786 | 13.5989 | 13.6532 | 17235484.0 |
| 2011-10-06 10:30:00 | AAPL | Stock | 13.6532 | 13.7086 | 13.6429 | 13.7064 | 16943080.0 |
| 2011-10-06 10:35:00 | AAPL | Stock | 13.7054 | 13.7421 | 13.7044 | 13.7107 | 16820048.0 |
| 2011-10-06 10:40:00 | AAPL | Stock | 13.7114 | 13.7228 | 13.6811 | 13.7228 | 9252544.0 |
| 2011-10-06 10:45:00 | AAPL | Stock | 13.7219 | 13.7232 | 13.6607 | 13.6668 | 9343404.0 |
| 2011-10-06 10:50:00 | AAPL | Stock | 13.6671 | 13.6671 | 13.6304 | 13.6596 | 9670304.0 |
| 2011-10-06 10:55:00 | AAPL | Stock | 13.6575 | 13.6811 | 13.62 | 13.6214 | 8276912.0 |
| 2011-10-06 11:00:00 | AAPL | Stock | 13.6225 | 13.6536 | 13.5854 | 13.6382 | 11826360.0 |
| 2011-10-06 11:05:00 | AAPL | Stock | 13.6378 | 13.7071 | 13.6339 | 13.7066 | 9454928.0 |
| 2011-10-06 11:10:00 | AAPL | Stock | 13.7062 | 13.7086 | 13.6711 | 13.7007 | 5533836.0 |
| 2011-10-06 11:15:00 | AAPL | Stock | 13.7007 | 13.7007 | 13.6511 | 13.655 | 4991840.0 |
> showing 50 of 323,693 rows — these rows as CSV