PREVIEW / stock_5min / 2012-02-23
file: by_date/stock_5min/2012/2012-02-23.parquet size: 4.9 MB rows: 331,346 symbols: 3,525
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-02-23 04:00:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 19600.0 |
| 2012-02-23 04:05:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 11200.0 |
| 2012-02-23 04:10:00 | AAPL | Stock | 18.4054 | 18.4054 | 18.4054 | 18.4054 | 2800.0 |
| 2012-02-23 04:15:00 | AAPL | Stock | 18.405 | 18.4054 | 18.405 | 18.4054 | 5600.0 |
| 2012-02-23 04:30:00 | AAPL | Stock | 18.3904 | 18.3904 | 18.3904 | 18.3904 | 2800.0 |
| 2012-02-23 04:40:00 | AAPL | Stock | 18.375 | 18.375 | 18.3614 | 18.3614 | 13720.0 |
| 2012-02-23 04:45:00 | AAPL | Stock | 18.3611 | 18.3611 | 18.3596 | 18.3596 | 8400.0 |
| 2012-02-23 04:50:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3821 | 18.3821 | 22400.0 |
| 2012-02-23 04:55:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3821 | 18.3821 | 5600.0 |
| 2012-02-23 05:00:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 2800.0 |
| 2012-02-23 05:15:00 | AAPL | Stock | 18.3786 | 18.3786 | 18.3786 | 18.3786 | 25200.0 |
| 2012-02-23 05:25:00 | AAPL | Stock | 18.3575 | 18.3575 | 18.3575 | 18.3575 | 16800.0 |
| 2012-02-23 05:30:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 2800.0 |
| 2012-02-23 05:35:00 | AAPL | Stock | 18.3679 | 18.3679 | 18.3575 | 18.3575 | 30800.0 |
| 2012-02-23 05:50:00 | AAPL | Stock | 18.3407 | 18.3571 | 18.3407 | 18.3571 | 16800.0 |
| 2012-02-23 05:55:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 15120.0 |
| 2012-02-23 06:05:00 | AAPL | Stock | 18.3679 | 18.3707 | 18.3643 | 18.3643 | 64400.0 |
| 2012-02-23 06:10:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 8400.0 |
| 2012-02-23 06:20:00 | AAPL | Stock | 18.3679 | 18.3679 | 18.3679 | 18.3679 | 38360.0 |
| 2012-02-23 07:00:00 | AAPL | Stock | 18.3736 | 18.3786 | 18.3571 | 18.3718 | 77504.0 |
| 2012-02-23 07:05:00 | AAPL | Stock | 18.3804 | 18.3804 | 18.3714 | 18.3782 | 65072.0 |
| 2012-02-23 07:10:00 | AAPL | Stock | 18.3804 | 18.3839 | 18.3732 | 18.3754 | 47320.0 |
| 2012-02-23 07:15:00 | AAPL | Stock | 18.3804 | 18.3804 | 18.3804 | 18.3804 | 22400.0 |
| 2012-02-23 07:20:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3818 | 18.3818 | 28000.0 |
| 2012-02-23 07:25:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3661 | 18.3714 | 72800.0 |
| 2012-02-23 07:30:00 | AAPL | Stock | 18.3714 | 18.3929 | 18.3714 | 18.3929 | 230860.0 |
| 2012-02-23 07:35:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3786 | 18.3821 | 77336.0 |
| 2012-02-23 07:40:00 | AAPL | Stock | 18.3871 | 18.4011 | 18.3871 | 18.3964 | 61432.0 |
| 2012-02-23 07:45:00 | AAPL | Stock | 18.3932 | 18.4018 | 18.3929 | 18.3929 | 75040.0 |
| 2012-02-23 07:50:00 | AAPL | Stock | 18.3932 | 18.4089 | 18.3932 | 18.4071 | 150472.0 |
| 2012-02-23 07:55:00 | AAPL | Stock | 18.4111 | 18.4171 | 18.4 | 18.4061 | 84252.0 |
| 2012-02-23 08:00:00 | AAPL | Stock | 18.4 | 18.4 | 18.38 | 18.3839 | 667968.0 |
| 2012-02-23 08:05:00 | AAPL | Stock | 18.3857 | 18.4107 | 18.3857 | 18.4082 | 448560.0 |
| 2012-02-23 08:10:00 | AAPL | Stock | 18.4071 | 18.4232 | 18.4054 | 18.4175 | 319648.0 |
| 2012-02-23 08:15:00 | AAPL | Stock | 18.4211 | 18.4279 | 18.4143 | 18.4279 | 415632.0 |
| 2012-02-23 08:20:00 | AAPL | Stock | 18.425 | 18.4282 | 18.4196 | 18.4243 | 402276.0 |
| 2012-02-23 08:25:00 | AAPL | Stock | 18.4243 | 18.425 | 18.4157 | 18.4246 | 289352.0 |
| 2012-02-23 08:30:00 | AAPL | Stock | 18.425 | 18.4257 | 18.4075 | 18.4168 | 273700.0 |
| 2012-02-23 08:35:00 | AAPL | Stock | 18.4182 | 18.4225 | 18.4118 | 18.4175 | 134176.0 |
| 2012-02-23 08:40:00 | AAPL | Stock | 18.4154 | 18.4204 | 18.4118 | 18.4175 | 104720.0 |
| 2012-02-23 08:45:00 | AAPL | Stock | 18.4193 | 18.4221 | 18.4143 | 18.4221 | 174132.0 |
| 2012-02-23 08:50:00 | AAPL | Stock | 18.4214 | 18.4214 | 18.3982 | 18.4018 | 408492.0 |
| 2012-02-23 08:55:00 | AAPL | Stock | 18.3982 | 18.4164 | 18.3979 | 18.4014 | 341768.0 |
| 2012-02-23 09:00:00 | AAPL | Stock | 18.4029 | 18.4107 | 18.3989 | 18.4064 | 245140.0 |
| 2012-02-23 09:05:00 | AAPL | Stock | 18.41 | 18.41 | 18.4004 | 18.4032 | 416780.0 |
| 2012-02-23 09:10:00 | AAPL | Stock | 18.4018 | 18.4175 | 18.3982 | 18.4043 | 274484.0 |
| 2012-02-23 09:15:00 | AAPL | Stock | 18.4071 | 18.4107 | 18.3964 | 18.4068 | 235060.0 |
| 2012-02-23 09:20:00 | AAPL | Stock | 18.4032 | 18.4064 | 18.3929 | 18.3929 | 227724.0 |
| 2012-02-23 09:25:00 | AAPL | Stock | 18.3893 | 18.4014 | 18.3754 | 18.4014 | 321496.0 |
| 2012-02-23 09:30:00 | AAPL | Stock | 18.3982 | 18.4364 | 18.3571 | 18.4196 | 20589100.0 |
> showing 50 of 331,346 rows — these rows as CSV