PREVIEW / stock_5min / 2011-11-08
file: by_date/stock_5min/2011/2011-11-08.parquet size: 4.9 MB rows: 327,008 symbols: 3,524
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-11-08 04:05:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 14000.0 |
| 2011-11-08 04:30:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 2800.0 |
| 2011-11-08 04:45:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 2800.0 |
| 2011-11-08 07:00:00 | AAPL | Stock | 14.3293 | 14.3293 | 14.3293 | 14.3293 | 2800.0 |
| 2011-11-08 07:05:00 | AAPL | Stock | 14.3225 | 14.3225 | 14.3225 | 14.3225 | 4200.0 |
| 2011-11-08 07:10:00 | AAPL | Stock | 14.3225 | 14.3225 | 14.3214 | 14.3214 | 24360.0 |
| 2011-11-08 07:15:00 | AAPL | Stock | 14.3196 | 14.3214 | 14.3196 | 14.3214 | 5600.0 |
| 2011-11-08 07:25:00 | AAPL | Stock | 14.325 | 14.325 | 14.325 | 14.325 | 5600.0 |
| 2011-11-08 07:30:00 | AAPL | Stock | 14.3354 | 14.3379 | 14.3354 | 14.3379 | 11200.0 |
| 2011-11-08 07:35:00 | AAPL | Stock | 14.34 | 14.3436 | 14.34 | 14.3436 | 5600.0 |
| 2011-11-08 07:45:00 | AAPL | Stock | 14.3539 | 14.3821 | 14.3539 | 14.3686 | 118944.0 |
| 2011-11-08 07:50:00 | AAPL | Stock | 14.3679 | 14.3786 | 14.3679 | 14.3746 | 75852.0 |
| 2011-11-08 07:55:00 | AAPL | Stock | 14.3832 | 14.3836 | 14.3721 | 14.3836 | 90132.0 |
| 2011-11-08 08:00:00 | AAPL | Stock | 14.3818 | 14.3818 | 14.3586 | 14.375 | 280112.0 |
| 2011-11-08 08:05:00 | AAPL | Stock | 14.3729 | 14.3746 | 14.3571 | 14.3625 | 133028.0 |
| 2011-11-08 08:10:00 | AAPL | Stock | 14.3621 | 14.3621 | 14.3429 | 14.3436 | 148316.0 |
| 2011-11-08 08:15:00 | AAPL | Stock | 14.3496 | 14.3529 | 14.3468 | 14.35 | 42672.0 |
| 2011-11-08 08:20:00 | AAPL | Stock | 14.3475 | 14.3536 | 14.3454 | 14.3482 | 139888.0 |
| 2011-11-08 08:25:00 | AAPL | Stock | 14.35 | 14.355 | 14.3464 | 14.3543 | 130900.0 |
| 2011-11-08 08:30:00 | AAPL | Stock | 14.3543 | 14.3571 | 14.35 | 14.3539 | 74760.0 |
| 2011-11-08 08:35:00 | AAPL | Stock | 14.3557 | 14.3661 | 14.3557 | 14.3661 | 174440.0 |
| 2011-11-08 08:40:00 | AAPL | Stock | 14.3679 | 14.3725 | 14.3661 | 14.3696 | 62720.0 |
| 2011-11-08 08:45:00 | AAPL | Stock | 14.3714 | 14.3714 | 14.3657 | 14.3714 | 48608.0 |
| 2011-11-08 08:50:00 | AAPL | Stock | 14.3718 | 14.3736 | 14.3696 | 14.3696 | 35056.0 |
| 2011-11-08 08:55:00 | AAPL | Stock | 14.3714 | 14.3857 | 14.3714 | 14.3839 | 320208.0 |
| 2011-11-08 09:00:00 | AAPL | Stock | 14.3789 | 14.3821 | 14.375 | 14.375 | 35000.0 |
| 2011-11-08 09:05:00 | AAPL | Stock | 14.375 | 14.3754 | 14.3714 | 14.3746 | 83440.0 |
| 2011-11-08 09:10:00 | AAPL | Stock | 14.3718 | 14.3786 | 14.3714 | 14.3779 | 101584.0 |
| 2011-11-08 09:15:00 | AAPL | Stock | 14.3786 | 14.38 | 14.3786 | 14.3786 | 106400.0 |
| 2011-11-08 09:20:00 | AAPL | Stock | 14.3786 | 14.38 | 14.3679 | 14.3682 | 124152.0 |
| 2011-11-08 09:25:00 | AAPL | Stock | 14.3679 | 14.3679 | 14.3561 | 14.3661 | 116956.0 |
| 2011-11-08 09:30:00 | AAPL | Stock | 14.3661 | 14.4425 | 14.3414 | 14.4179 | 18294584.0 |
| 2011-11-08 09:35:00 | AAPL | Stock | 14.4235 | 14.4425 | 14.3879 | 14.4379 | 18620448.0 |
| 2011-11-08 09:40:00 | AAPL | Stock | 14.4393 | 14.4586 | 14.4354 | 14.4446 | 13852916.0 |
| 2011-11-08 09:45:00 | AAPL | Stock | 14.4443 | 14.4725 | 14.4431 | 14.465 | 21738892.0 |
| 2011-11-08 09:50:00 | AAPL | Stock | 14.4643 | 14.4779 | 14.4411 | 14.4432 | 8966636.0 |
| 2011-11-08 09:55:00 | AAPL | Stock | 14.4432 | 14.4911 | 14.4432 | 14.4846 | 10934084.0 |
| 2011-11-08 10:00:00 | AAPL | Stock | 14.4817 | 14.4992 | 14.4817 | 14.4964 | 8947960.0 |
| 2011-11-08 10:05:00 | AAPL | Stock | 14.4974 | 14.505 | 14.4661 | 14.4796 | 12767412.0 |
| 2011-11-08 10:10:00 | AAPL | Stock | 14.4789 | 14.4821 | 14.4446 | 14.465 | 8032808.0 |
| 2011-11-08 10:15:00 | AAPL | Stock | 14.4679 | 14.4768 | 14.45 | 14.4743 | 6821052.0 |
| 2011-11-08 10:20:00 | AAPL | Stock | 14.4739 | 14.4786 | 14.4639 | 14.473 | 4782904.0 |
| 2011-11-08 10:25:00 | AAPL | Stock | 14.4729 | 14.4746 | 14.4429 | 14.4504 | 7601216.0 |
| 2011-11-08 10:30:00 | AAPL | Stock | 14.452 | 14.4689 | 14.4439 | 14.4464 | 5299000.0 |
| 2011-11-08 10:35:00 | AAPL | Stock | 14.4457 | 14.4643 | 14.4446 | 14.4562 | 4047932.0 |
| 2011-11-08 10:40:00 | AAPL | Stock | 14.4568 | 14.4857 | 14.4496 | 14.4739 | 5044256.0 |
| 2011-11-08 10:45:00 | AAPL | Stock | 14.4764 | 14.4936 | 14.4686 | 14.4839 | 5542936.0 |
| 2011-11-08 10:50:00 | AAPL | Stock | 14.4829 | 14.4839 | 14.4654 | 14.47 | 4682272.0 |
| 2011-11-08 10:55:00 | AAPL | Stock | 14.4705 | 14.4764 | 14.4643 | 14.4757 | 3218376.0 |
| 2011-11-08 11:00:00 | AAPL | Stock | 14.4736 | 14.4925 | 14.4682 | 14.4811 | 4199216.0 |
> showing 50 of 327,008 rows — these rows as CSV