PREVIEW / stock_5min / 2011-06-30
file: by_date/stock_5min/2011/2011-06-30.parquet size: 4.8 MB rows: 329,986 symbols: 3,549
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-06-30 07:00:00 | AAPL | Stock | 11.9639 | 11.9639 | 11.9639 | 11.9639 | 2800.0 |
| 2011-06-30 07:15:00 | AAPL | Stock | 11.9675 | 11.9679 | 11.9675 | 11.9679 | 19600.0 |
| 2011-06-30 07:20:00 | AAPL | Stock | 11.9732 | 11.9732 | 11.9725 | 11.9725 | 33600.0 |
| 2011-06-30 07:30:00 | AAPL | Stock | 11.9725 | 11.9725 | 11.9725 | 11.9725 | 15400.0 |
| 2011-06-30 07:40:00 | AAPL | Stock | 11.9679 | 11.9679 | 11.9679 | 11.9679 | 4200.0 |
| 2011-06-30 07:45:00 | AAPL | Stock | 11.9643 | 11.9643 | 11.9571 | 11.9571 | 33600.0 |
| 2011-06-30 07:50:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9464 | 11.9464 | 6160.0 |
| 2011-06-30 07:55:00 | AAPL | Stock | 11.9607 | 11.9607 | 11.9607 | 11.9607 | 5600.0 |
| 2011-06-30 08:00:00 | AAPL | Stock | 11.9482 | 11.96 | 11.9471 | 11.96 | 19460.0 |
| 2011-06-30 08:10:00 | AAPL | Stock | 11.9589 | 11.9589 | 11.9589 | 11.9589 | 2800.0 |
| 2011-06-30 08:15:00 | AAPL | Stock | 11.9536 | 11.9536 | 11.9393 | 11.9393 | 54124.0 |
| 2011-06-30 08:20:00 | AAPL | Stock | 11.9379 | 11.9439 | 11.9357 | 11.9429 | 67284.0 |
| 2011-06-30 08:25:00 | AAPL | Stock | 11.9436 | 11.9525 | 11.9436 | 11.9518 | 55804.0 |
| 2011-06-30 08:30:00 | AAPL | Stock | 11.9443 | 11.9529 | 11.9357 | 11.9529 | 23688.0 |
| 2011-06-30 08:35:00 | AAPL | Stock | 11.9486 | 11.9554 | 11.9475 | 11.9554 | 25200.0 |
| 2011-06-30 08:40:00 | AAPL | Stock | 11.955 | 11.955 | 11.955 | 11.955 | 2800.0 |
| 2011-06-30 08:45:00 | AAPL | Stock | 11.9486 | 11.95 | 11.9475 | 11.95 | 94500.0 |
| 2011-06-30 08:50:00 | AAPL | Stock | 11.9525 | 11.9525 | 11.95 | 11.9507 | 25200.0 |
| 2011-06-30 08:55:00 | AAPL | Stock | 11.9504 | 11.955 | 11.95 | 11.955 | 58100.0 |
| 2011-06-30 09:00:00 | AAPL | Stock | 11.9625 | 11.9643 | 11.9557 | 11.9639 | 52500.0 |
| 2011-06-30 09:05:00 | AAPL | Stock | 11.9607 | 11.9607 | 11.9536 | 11.9536 | 8400.0 |
| 2011-06-30 09:10:00 | AAPL | Stock | 11.9561 | 11.9561 | 11.9521 | 11.9529 | 22400.0 |
| 2011-06-30 09:15:00 | AAPL | Stock | 11.9586 | 11.9586 | 11.9464 | 11.95 | 256200.0 |
| 2011-06-30 09:20:00 | AAPL | Stock | 11.9536 | 11.9539 | 11.9314 | 11.9354 | 256900.0 |
| 2011-06-30 09:25:00 | AAPL | Stock | 11.9346 | 11.9532 | 11.9304 | 11.95 | 355992.0 |
| 2011-06-30 09:30:00 | AAPL | Stock | 11.9536 | 11.9604 | 11.9179 | 11.9354 | 9088128.0 |
| 2011-06-30 09:35:00 | AAPL | Stock | 11.9343 | 11.9554 | 11.8911 | 11.9014 | 9685368.0 |
| 2011-06-30 09:40:00 | AAPL | Stock | 11.8996 | 11.9325 | 11.8871 | 11.9094 | 10661112.0 |
| 2011-06-30 09:45:00 | AAPL | Stock | 11.9095 | 11.9525 | 11.8971 | 11.9436 | 10512712.0 |
| 2011-06-30 09:50:00 | AAPL | Stock | 11.9436 | 11.9496 | 11.9179 | 11.9243 | 6601476.0 |
| 2011-06-30 09:55:00 | AAPL | Stock | 11.9254 | 11.9339 | 11.9125 | 11.9146 | 4705288.0 |
| 2011-06-30 10:00:00 | AAPL | Stock | 11.9171 | 11.94 | 11.9136 | 11.9361 | 6672736.0 |
| 2011-06-30 10:05:00 | AAPL | Stock | 11.9386 | 11.9621 | 11.9329 | 11.9536 | 9393440.0 |
| 2011-06-30 10:10:00 | AAPL | Stock | 11.9568 | 11.9689 | 11.9475 | 11.9679 | 7499268.0 |
| 2011-06-30 10:15:00 | AAPL | Stock | 11.965 | 11.9929 | 11.9638 | 11.9889 | 10261580.0 |
| 2011-06-30 10:20:00 | AAPL | Stock | 11.9886 | 12.0046 | 11.9821 | 11.9982 | 9521428.0 |
| 2011-06-30 10:25:00 | AAPL | Stock | 11.9979 | 12.0 | 11.9686 | 11.9718 | 5735352.0 |
| 2011-06-30 10:30:00 | AAPL | Stock | 11.9729 | 11.9786 | 11.9607 | 11.9682 | 5774076.0 |
| 2011-06-30 10:35:00 | AAPL | Stock | 11.9682 | 11.9821 | 11.9596 | 11.96 | 5005140.0 |
| 2011-06-30 10:40:00 | AAPL | Stock | 11.96 | 11.9711 | 11.9439 | 11.9536 | 8211364.0 |
| 2011-06-30 10:45:00 | AAPL | Stock | 11.9535 | 11.9582 | 11.9386 | 11.955 | 6128864.0 |
| 2011-06-30 10:50:00 | AAPL | Stock | 11.9557 | 11.9643 | 11.9382 | 11.9436 | 4427836.0 |
| 2011-06-30 10:55:00 | AAPL | Stock | 11.9436 | 11.9604 | 11.9286 | 11.9546 | 5685484.0 |
| 2011-06-30 11:00:00 | AAPL | Stock | 11.9554 | 11.9846 | 11.9518 | 11.9834 | 4984980.0 |
| 2011-06-30 11:05:00 | AAPL | Stock | 11.9829 | 11.9879 | 11.9643 | 11.9704 | 5269964.0 |
| 2011-06-30 11:10:00 | AAPL | Stock | 11.9698 | 11.9704 | 11.9536 | 11.9546 | 3493364.0 |
| 2011-06-30 11:15:00 | AAPL | Stock | 11.9568 | 11.9678 | 11.9546 | 11.9607 | 2754108.0 |
| 2011-06-30 11:20:00 | AAPL | Stock | 11.9601 | 11.9836 | 11.9601 | 11.9775 | 3636360.0 |
| 2011-06-30 11:25:00 | AAPL | Stock | 11.9775 | 11.9821 | 11.975 | 11.9814 | 1529948.0 |
| 2011-06-30 11:30:00 | AAPL | Stock | 11.9821 | 11.996 | 11.9818 | 11.9861 | 5156984.0 |
> showing 50 of 329,986 rows — these rows as CSV