PREVIEW / stock_5min / 2014-03-05
file: by_date/stock_5min/2014/2014-03-05.parquet size: 5.4 MB rows: 357,249 symbols: 3,528
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-05 04:50:00 | AAPL | Stock | 18.9736 | 18.9736 | 18.9736 | 18.9736 | 2800.0 |
| 2014-03-05 05:05:00 | AAPL | Stock | 18.9832 | 18.9832 | 18.9832 | 18.9832 | 5600.0 |
| 2014-03-05 05:50:00 | AAPL | Stock | 18.9889 | 18.9904 | 18.9889 | 18.9904 | 14000.0 |
| 2014-03-05 07:00:00 | AAPL | Stock | 18.9921 | 19.0161 | 18.9921 | 19.0161 | 11200.0 |
| 2014-03-05 07:05:00 | AAPL | Stock | 19.0175 | 19.0207 | 19.0175 | 19.0207 | 12656.0 |
| 2014-03-05 07:10:00 | AAPL | Stock | 19.0039 | 19.0039 | 19.0036 | 19.0036 | 11200.0 |
| 2014-03-05 07:15:00 | AAPL | Stock | 19.0171 | 19.0357 | 19.0171 | 19.0357 | 39396.0 |
| 2014-03-05 07:20:00 | AAPL | Stock | 19.0186 | 19.0186 | 19.0039 | 19.0039 | 16800.0 |
| 2014-03-05 07:30:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 15680.0 |
| 2014-03-05 07:35:00 | AAPL | Stock | 19.0357 | 19.0446 | 19.0357 | 19.0446 | 57540.0 |
| 2014-03-05 07:50:00 | AAPL | Stock | 19.0411 | 19.0411 | 19.0411 | 19.0411 | 2800.0 |
| 2014-03-05 07:55:00 | AAPL | Stock | 19.0393 | 19.0521 | 19.0393 | 19.0521 | 23632.0 |
| 2014-03-05 08:00:00 | AAPL | Stock | 19.0289 | 19.0446 | 18.9286 | 19.0268 | 175252.0 |
| 2014-03-05 08:05:00 | AAPL | Stock | 19.0182 | 19.0336 | 19.0 | 19.0104 | 51632.0 |
| 2014-03-05 08:10:00 | AAPL | Stock | 19.0143 | 19.0179 | 18.9864 | 18.9864 | 45780.0 |
| 2014-03-05 08:15:00 | AAPL | Stock | 18.9875 | 18.9875 | 18.9675 | 18.9714 | 89460.0 |
| 2014-03-05 08:20:00 | AAPL | Stock | 18.9643 | 18.9746 | 18.9561 | 18.9746 | 214900.0 |
| 2014-03-05 08:25:00 | AAPL | Stock | 18.9743 | 18.9861 | 18.9543 | 18.9782 | 33040.0 |
| 2014-03-05 08:30:00 | AAPL | Stock | 18.9661 | 18.9661 | 18.9446 | 18.9643 | 67788.0 |
| 2014-03-05 08:35:00 | AAPL | Stock | 18.9536 | 18.9536 | 18.9293 | 18.9357 | 31808.0 |
| 2014-03-05 08:40:00 | AAPL | Stock | 18.9375 | 18.9375 | 18.9261 | 18.9321 | 71260.0 |
| 2014-03-05 08:45:00 | AAPL | Stock | 18.9321 | 18.9454 | 18.9286 | 18.9454 | 22400.0 |
| 2014-03-05 08:50:00 | AAPL | Stock | 18.9454 | 18.9643 | 18.9375 | 18.9554 | 149604.0 |
| 2014-03-05 08:55:00 | AAPL | Stock | 18.9536 | 18.9536 | 18.9464 | 18.9482 | 28000.0 |
| 2014-03-05 09:00:00 | AAPL | Stock | 18.9475 | 18.9554 | 18.9475 | 18.9475 | 42000.0 |
| 2014-03-05 09:05:00 | AAPL | Stock | 18.9554 | 18.9604 | 18.9464 | 18.9575 | 53200.0 |
| 2014-03-05 09:10:00 | AAPL | Stock | 18.9593 | 18.9593 | 18.9411 | 18.9432 | 30296.0 |
| 2014-03-05 09:15:00 | AAPL | Stock | 18.9539 | 18.9539 | 18.9436 | 18.9507 | 14000.0 |
| 2014-03-05 09:20:00 | AAPL | Stock | 18.9525 | 18.9525 | 18.9525 | 18.9525 | 8400.0 |
| 2014-03-05 09:25:00 | AAPL | Stock | 18.9482 | 18.9482 | 18.9343 | 18.9411 | 124656.0 |
| 2014-03-05 09:30:00 | AAPL | Stock | 18.9614 | 19.0396 | 18.9461 | 18.9893 | 10141432.0 |
| 2014-03-05 09:35:00 | AAPL | Stock | 18.9882 | 19.03 | 18.9361 | 18.9611 | 6294708.0 |
| 2014-03-05 09:40:00 | AAPL | Stock | 18.9618 | 18.9761 | 18.9354 | 18.9693 | 3217396.0 |
| 2014-03-05 09:45:00 | AAPL | Stock | 18.9709 | 18.9761 | 18.9429 | 18.9632 | 2999948.0 |
| 2014-03-05 09:50:00 | AAPL | Stock | 18.9622 | 18.9911 | 18.96 | 18.9646 | 2988776.0 |
| 2014-03-05 09:55:00 | AAPL | Stock | 18.9659 | 18.9811 | 18.9114 | 18.9164 | 4659200.0 |
| 2014-03-05 10:00:00 | AAPL | Stock | 18.9218 | 18.9388 | 18.8975 | 18.9225 | 4328408.0 |
| 2014-03-05 10:05:00 | AAPL | Stock | 18.9243 | 18.9475 | 18.9225 | 18.9375 | 3598448.0 |
| 2014-03-05 10:10:00 | AAPL | Stock | 18.9411 | 18.9718 | 18.9336 | 18.965 | 2819488.0 |
| 2014-03-05 10:15:00 | AAPL | Stock | 18.9646 | 18.9929 | 18.9543 | 18.9721 | 2961196.0 |
| 2014-03-05 10:20:00 | AAPL | Stock | 18.9736 | 18.9836 | 18.9679 | 18.9787 | 1822716.0 |
| 2014-03-05 10:25:00 | AAPL | Stock | 18.9804 | 19.0096 | 18.9718 | 19.0045 | 2547636.0 |
| 2014-03-05 10:30:00 | AAPL | Stock | 19.0054 | 19.0221 | 19.0029 | 19.0121 | 2961784.0 |
| 2014-03-05 10:35:00 | AAPL | Stock | 19.0121 | 19.0157 | 18.9861 | 18.9908 | 1859368.0 |
| 2014-03-05 10:40:00 | AAPL | Stock | 18.9925 | 18.9957 | 18.9736 | 18.9764 | 1446872.0 |
| 2014-03-05 10:45:00 | AAPL | Stock | 18.9764 | 18.9782 | 18.9418 | 18.9491 | 1773352.0 |
| 2014-03-05 10:50:00 | AAPL | Stock | 18.9536 | 18.9679 | 18.9393 | 18.9486 | 1849904.0 |
| 2014-03-05 10:55:00 | AAPL | Stock | 18.9446 | 18.9775 | 18.9418 | 18.9729 | 1693916.0 |
| 2014-03-05 11:00:00 | AAPL | Stock | 18.975 | 18.9821 | 18.9514 | 18.9732 | 1752352.0 |
| 2014-03-05 11:05:00 | AAPL | Stock | 18.9729 | 18.9817 | 18.9693 | 18.9784 | 709520.0 |
> showing 50 of 357,249 rows — these rows as CSV