PREVIEW / stock_5min / 2012-06-08
file: by_date/stock_5min/2012/2012-06-08.parquet size: 4.7 MB rows: 321,480 symbols: 3,498
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-06-08 04:00:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 28000.0 |
| 2012-06-08 04:50:00 | AAPL | Stock | 20.3368 | 20.3368 | 20.3368 | 20.3368 | 2800.0 |
| 2012-06-08 05:00:00 | AAPL | Stock | 20.2611 | 20.2611 | 20.2607 | 20.2607 | 9800.0 |
| 2012-06-08 05:05:00 | AAPL | Stock | 20.3207 | 20.3207 | 20.3207 | 20.3207 | 2800.0 |
| 2012-06-08 05:10:00 | AAPL | Stock | 20.3207 | 20.3207 | 20.3207 | 20.3207 | 2800.0 |
| 2012-06-08 05:25:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 2800.0 |
| 2012-06-08 05:30:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 11200.0 |
| 2012-06-08 05:35:00 | AAPL | Stock | 20.3389 | 20.3389 | 20.3389 | 20.3389 | 11200.0 |
| 2012-06-08 05:45:00 | AAPL | Stock | 20.3682 | 20.3682 | 20.3682 | 20.3682 | 2800.0 |
| 2012-06-08 05:50:00 | AAPL | Stock | 20.3682 | 20.3682 | 20.3682 | 20.3682 | 2800.0 |
| 2012-06-08 06:10:00 | AAPL | Stock | 20.3689 | 20.3711 | 20.3689 | 20.3711 | 5600.0 |
| 2012-06-08 06:25:00 | AAPL | Stock | 20.3711 | 20.3711 | 20.3679 | 20.3679 | 22148.0 |
| 2012-06-08 06:30:00 | AAPL | Stock | 20.3686 | 20.3686 | 20.3686 | 20.3686 | 2800.0 |
| 2012-06-08 06:40:00 | AAPL | Stock | 20.3464 | 20.3464 | 20.3464 | 20.3464 | 8120.0 |
| 2012-06-08 06:45:00 | AAPL | Stock | 20.3575 | 20.3575 | 20.3575 | 20.3575 | 14000.0 |
| 2012-06-08 07:00:00 | AAPL | Stock | 20.3393 | 20.3568 | 20.3321 | 20.3407 | 18984.0 |
| 2012-06-08 07:05:00 | AAPL | Stock | 20.3482 | 20.3482 | 20.3482 | 20.3482 | 2800.0 |
| 2012-06-08 07:10:00 | AAPL | Stock | 20.3321 | 20.3321 | 20.3214 | 20.3286 | 59416.0 |
| 2012-06-08 07:15:00 | AAPL | Stock | 20.3325 | 20.3325 | 20.3321 | 20.3321 | 8652.0 |
| 2012-06-08 07:20:00 | AAPL | Stock | 20.3325 | 20.3575 | 20.3325 | 20.3575 | 35784.0 |
| 2012-06-08 07:25:00 | AAPL | Stock | 20.3743 | 20.3907 | 20.3743 | 20.3875 | 22400.0 |
| 2012-06-08 07:30:00 | AAPL | Stock | 20.3871 | 20.3882 | 20.3871 | 20.3882 | 8400.0 |
| 2012-06-08 07:35:00 | AAPL | Stock | 20.3857 | 20.3857 | 20.3646 | 20.3646 | 19600.0 |
| 2012-06-08 07:40:00 | AAPL | Stock | 20.3832 | 20.3836 | 20.3832 | 20.3836 | 9800.0 |
| 2012-06-08 07:45:00 | AAPL | Stock | 20.3836 | 20.3907 | 20.3836 | 20.3907 | 16800.0 |
| 2012-06-08 07:55:00 | AAPL | Stock | 20.3718 | 20.3786 | 20.3621 | 20.3707 | 36400.0 |
| 2012-06-08 08:00:00 | AAPL | Stock | 20.3621 | 20.3893 | 20.355 | 20.3886 | 109480.0 |
| 2012-06-08 08:05:00 | AAPL | Stock | 20.3839 | 20.3921 | 20.3821 | 20.3821 | 100296.0 |
| 2012-06-08 08:10:00 | AAPL | Stock | 20.3775 | 20.3811 | 20.3714 | 20.3714 | 93716.0 |
| 2012-06-08 08:15:00 | AAPL | Stock | 20.3725 | 20.375 | 20.3643 | 20.3643 | 87192.0 |
| 2012-06-08 08:20:00 | AAPL | Stock | 20.3682 | 20.3682 | 20.3429 | 20.3589 | 148876.0 |
| 2012-06-08 08:25:00 | AAPL | Stock | 20.3614 | 20.3721 | 20.3614 | 20.3643 | 44800.0 |
| 2012-06-08 08:30:00 | AAPL | Stock | 20.3646 | 20.375 | 20.3596 | 20.375 | 66444.0 |
| 2012-06-08 08:35:00 | AAPL | Stock | 20.3768 | 20.3768 | 20.3732 | 20.375 | 44800.0 |
| 2012-06-08 08:40:00 | AAPL | Stock | 20.3818 | 20.3964 | 20.3775 | 20.3929 | 56364.0 |
| 2012-06-08 08:45:00 | AAPL | Stock | 20.3932 | 20.4089 | 20.3825 | 20.4043 | 291116.0 |
| 2012-06-08 08:50:00 | AAPL | Stock | 20.3996 | 20.4107 | 20.3829 | 20.3964 | 503104.0 |
| 2012-06-08 08:55:00 | AAPL | Stock | 20.3979 | 20.4029 | 20.3929 | 20.3946 | 118776.0 |
| 2012-06-08 09:00:00 | AAPL | Stock | 20.3996 | 20.4096 | 20.3929 | 20.4 | 98980.0 |
| 2012-06-08 09:05:00 | AAPL | Stock | 20.4064 | 20.4411 | 20.4064 | 20.4411 | 221480.0 |
| 2012-06-08 09:10:00 | AAPL | Stock | 20.4446 | 20.4571 | 20.4214 | 20.4286 | 270256.0 |
| 2012-06-08 09:15:00 | AAPL | Stock | 20.4375 | 20.4375 | 20.4286 | 20.4286 | 16800.0 |
| 2012-06-08 09:20:00 | AAPL | Stock | 20.4296 | 20.4321 | 20.415 | 20.4275 | 72100.0 |
| 2012-06-08 09:25:00 | AAPL | Stock | 20.4239 | 20.4243 | 20.3929 | 20.3996 | 592648.0 |
| 2012-06-08 09:30:00 | AAPL | Stock | 20.4143 | 20.4171 | 20.3214 | 20.3696 | 10026688.0 |
| 2012-06-08 09:35:00 | AAPL | Stock | 20.3641 | 20.3832 | 20.3414 | 20.3604 | 6789244.0 |
| 2012-06-08 09:40:00 | AAPL | Stock | 20.3581 | 20.3761 | 20.3382 | 20.3639 | 6233892.0 |
| 2012-06-08 09:45:00 | AAPL | Stock | 20.3646 | 20.3711 | 20.3446 | 20.3525 | 4970168.0 |
| 2012-06-08 09:50:00 | AAPL | Stock | 20.3497 | 20.3821 | 20.3239 | 20.3811 | 6899564.0 |
| 2012-06-08 09:55:00 | AAPL | Stock | 20.3811 | 20.4232 | 20.3771 | 20.4152 | 7961044.0 |
> showing 50 of 321,480 rows — these rows as CSV