PREVIEW / stock_5min / 2010-03-15
file: by_date/stock_5min/2010/2010-03-15.parquet size: 4.7 MB rows: 322,678 symbols: 3,465
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-15 05:05:00 | AAPL | Stock | 8.085 | 8.085 | 8.085 | 8.085 | 2800.0 |
| 2010-03-15 07:15:00 | AAPL | Stock | 8.0714 | 8.0714 | 8.0714 | 8.0714 | 2800.0 |
| 2010-03-15 07:25:00 | AAPL | Stock | 8.0714 | 8.0714 | 8.0714 | 8.0714 | 2800.0 |
| 2010-03-15 07:40:00 | AAPL | Stock | 8.0714 | 8.0714 | 8.0714 | 8.0714 | 2800.0 |
| 2010-03-15 07:45:00 | AAPL | Stock | 8.0714 | 8.0732 | 8.0714 | 8.0732 | 19264.0 |
| 2010-03-15 07:50:00 | AAPL | Stock | 8.0682 | 8.0682 | 8.0682 | 8.0682 | 2800.0 |
| 2010-03-15 07:55:00 | AAPL | Stock | 8.0696 | 8.0732 | 8.0679 | 8.0686 | 41720.0 |
| 2010-03-15 08:00:00 | AAPL | Stock | 8.0679 | 8.0682 | 8.0554 | 8.0554 | 120400.0 |
| 2010-03-15 08:05:00 | AAPL | Stock | 8.0589 | 8.0661 | 8.0589 | 8.0661 | 47964.0 |
| 2010-03-15 08:10:00 | AAPL | Stock | 8.0643 | 8.0679 | 8.0643 | 8.0679 | 105560.0 |
| 2010-03-15 08:15:00 | AAPL | Stock | 8.0661 | 8.0679 | 8.0589 | 8.0589 | 96432.0 |
| 2010-03-15 08:20:00 | AAPL | Stock | 8.0593 | 8.0593 | 8.0536 | 8.0568 | 90412.0 |
| 2010-03-15 08:25:00 | AAPL | Stock | 8.0568 | 8.0571 | 8.0507 | 8.0507 | 104860.0 |
| 2010-03-15 08:30:00 | AAPL | Stock | 8.05 | 8.0539 | 8.0486 | 8.0486 | 112448.0 |
| 2010-03-15 08:35:00 | AAPL | Stock | 8.0486 | 8.0489 | 8.0357 | 8.0429 | 195664.0 |
| 2010-03-15 08:40:00 | AAPL | Stock | 8.0425 | 8.0429 | 8.0375 | 8.0393 | 75124.0 |
| 2010-03-15 08:45:00 | AAPL | Stock | 8.0396 | 8.0396 | 8.0214 | 8.0214 | 573076.0 |
| 2010-03-15 08:50:00 | AAPL | Stock | 8.0236 | 8.0286 | 8.0204 | 8.025 | 236964.0 |
| 2010-03-15 08:55:00 | AAPL | Stock | 8.0221 | 8.0461 | 8.0221 | 8.0461 | 122164.0 |
| 2010-03-15 09:00:00 | AAPL | Stock | 8.0379 | 8.0461 | 8.0379 | 8.04 | 48524.0 |
| 2010-03-15 09:05:00 | AAPL | Stock | 8.0404 | 8.0489 | 8.0404 | 8.0475 | 78960.0 |
| 2010-03-15 09:10:00 | AAPL | Stock | 8.0479 | 8.0479 | 8.0429 | 8.0429 | 29820.0 |
| 2010-03-15 09:15:00 | AAPL | Stock | 8.04 | 8.0429 | 8.0389 | 8.0429 | 52612.0 |
| 2010-03-15 09:20:00 | AAPL | Stock | 8.0471 | 8.0518 | 8.0471 | 8.05 | 87640.0 |
| 2010-03-15 09:25:00 | AAPL | Stock | 8.0496 | 8.0532 | 8.0468 | 8.0468 | 42000.0 |
| 2010-03-15 09:30:00 | AAPL | Stock | 8.0493 | 8.0536 | 7.9768 | 8.0111 | 22927828.0 |
| 2010-03-15 09:35:00 | AAPL | Stock | 8.0111 | 8.0357 | 8.0093 | 8.0264 | 7726152.0 |
| 2010-03-15 09:40:00 | AAPL | Stock | 8.0271 | 8.0414 | 8.0129 | 8.0243 | 7530432.0 |
| 2010-03-15 09:45:00 | AAPL | Stock | 8.0257 | 8.045 | 8.0229 | 8.0355 | 10456572.0 |
| 2010-03-15 09:50:00 | AAPL | Stock | 8.0364 | 8.0386 | 8.0071 | 8.0082 | 8965124.0 |
| 2010-03-15 09:55:00 | AAPL | Stock | 8.0089 | 8.0179 | 7.9786 | 7.9796 | 13239436.0 |
| 2010-03-15 10:00:00 | AAPL | Stock | 7.9804 | 7.9807 | 7.94 | 7.9604 | 21092008.0 |
| 2010-03-15 10:05:00 | AAPL | Stock | 7.9604 | 7.9704 | 7.9482 | 7.9704 | 10872736.0 |
| 2010-03-15 10:10:00 | AAPL | Stock | 7.9704 | 7.9743 | 7.9504 | 7.9667 | 8522444.0 |
| 2010-03-15 10:15:00 | AAPL | Stock | 7.9679 | 7.9721 | 7.9536 | 7.97 | 6690880.0 |
| 2010-03-15 10:20:00 | AAPL | Stock | 7.9693 | 7.9821 | 7.9681 | 7.9789 | 5896184.0 |
| 2010-03-15 10:25:00 | AAPL | Stock | 7.979 | 7.9907 | 7.9781 | 7.9834 | 5809132.0 |
| 2010-03-15 10:30:00 | AAPL | Stock | 7.9832 | 7.9946 | 7.965 | 7.9802 | 5990040.0 |
| 2010-03-15 10:35:00 | AAPL | Stock | 7.9804 | 7.9843 | 7.9743 | 7.9789 | 2184644.0 |
| 2010-03-15 10:40:00 | AAPL | Stock | 7.9789 | 8.0015 | 7.9607 | 7.9621 | 3804528.0 |
| 2010-03-15 10:45:00 | AAPL | Stock | 7.9618 | 7.9668 | 7.9457 | 7.9468 | 8344532.0 |
| 2010-03-15 10:50:00 | AAPL | Stock | 7.9464 | 7.9571 | 7.9446 | 7.9464 | 5552232.0 |
| 2010-03-15 10:55:00 | AAPL | Stock | 7.9471 | 7.9514 | 7.9121 | 7.9286 | 17903340.0 |
| 2010-03-15 11:00:00 | AAPL | Stock | 7.9286 | 7.9439 | 7.9211 | 7.9343 | 9948624.0 |
| 2010-03-15 11:05:00 | AAPL | Stock | 7.935 | 7.9357 | 7.9111 | 7.9225 | 8248800.0 |
| 2010-03-15 11:10:00 | AAPL | Stock | 7.9219 | 7.9229 | 7.8793 | 7.88 | 12145532.0 |
| 2010-03-15 11:15:00 | AAPL | Stock | 7.88 | 7.8914 | 7.8661 | 7.8911 | 21080304.0 |
| 2010-03-15 11:20:00 | AAPL | Stock | 7.8907 | 7.8929 | 7.8818 | 7.8929 | 7151928.0 |
| 2010-03-15 11:25:00 | AAPL | Stock | 7.8909 | 7.9007 | 7.8889 | 7.9007 | 6192200.0 |
| 2010-03-15 11:30:00 | AAPL | Stock | 7.9007 | 7.9068 | 7.8946 | 7.9054 | 5405848.0 |
> showing 50 of 322,678 rows — these rows as CSV