PREVIEW / stock_5min / 2011-01-21
file: by_date/stock_5min/2011/2011-01-21.parquet size: 5.0 MB rows: 339,000 symbols: 3,526
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-01-21 04:25:00 | AAPL | Stock | 11.9118 | 11.9118 | 11.9118 | 11.9118 | 5600.0 |
| 2011-01-21 04:50:00 | AAPL | Stock | 11.9064 | 11.9064 | 11.9064 | 11.9064 | 5600.0 |
| 2011-01-21 05:00:00 | AAPL | Stock | 11.9064 | 11.9064 | 11.9064 | 11.9064 | 2800.0 |
| 2011-01-21 05:25:00 | AAPL | Stock | 11.9471 | 11.9536 | 11.9471 | 11.9536 | 11200.0 |
| 2011-01-21 05:55:00 | AAPL | Stock | 11.9425 | 11.9429 | 11.9425 | 11.9429 | 8400.0 |
| 2011-01-21 06:00:00 | AAPL | Stock | 11.9429 | 11.9429 | 11.9429 | 11.9429 | 5600.0 |
| 2011-01-21 06:05:00 | AAPL | Stock | 11.9429 | 11.9429 | 11.9429 | 11.9429 | 5600.0 |
| 2011-01-21 06:15:00 | AAPL | Stock | 11.9436 | 11.9536 | 11.9436 | 11.9536 | 5600.0 |
| 2011-01-21 06:25:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9464 | 11.9464 | 5600.0 |
| 2011-01-21 06:35:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9464 | 11.9464 | 4200.0 |
| 2011-01-21 06:40:00 | AAPL | Stock | 11.9536 | 11.9536 | 11.9536 | 11.9536 | 2800.0 |
| 2011-01-21 06:45:00 | AAPL | Stock | 11.9536 | 11.9536 | 11.9536 | 11.9536 | 5600.0 |
| 2011-01-21 07:00:00 | AAPL | Stock | 11.9507 | 11.9507 | 11.9411 | 11.9432 | 81032.0 |
| 2011-01-21 07:05:00 | AAPL | Stock | 11.9432 | 11.9471 | 11.9393 | 11.9471 | 57120.0 |
| 2011-01-21 07:10:00 | AAPL | Stock | 11.9418 | 11.9418 | 11.9396 | 11.9396 | 11200.0 |
| 2011-01-21 07:15:00 | AAPL | Stock | 11.9461 | 11.9461 | 11.9389 | 11.9389 | 5600.0 |
| 2011-01-21 07:20:00 | AAPL | Stock | 11.9411 | 11.9411 | 11.9389 | 11.9389 | 30548.0 |
| 2011-01-21 07:25:00 | AAPL | Stock | 11.9407 | 11.9407 | 11.9407 | 11.9407 | 8400.0 |
| 2011-01-21 07:30:00 | AAPL | Stock | 11.9354 | 11.9375 | 11.9354 | 11.9375 | 5600.0 |
| 2011-01-21 07:35:00 | AAPL | Stock | 11.9393 | 11.9407 | 11.9286 | 11.9379 | 93688.0 |
| 2011-01-21 07:40:00 | AAPL | Stock | 11.9389 | 11.9389 | 11.9357 | 11.9357 | 36400.0 |
| 2011-01-21 07:45:00 | AAPL | Stock | 11.9389 | 11.9461 | 11.9389 | 11.9461 | 71960.0 |
| 2011-01-21 07:50:00 | AAPL | Stock | 11.9446 | 11.9464 | 11.9411 | 11.9414 | 66920.0 |
| 2011-01-21 07:55:00 | AAPL | Stock | 11.9439 | 11.9464 | 11.9411 | 11.9464 | 69496.0 |
| 2011-01-21 08:00:00 | AAPL | Stock | 11.9429 | 11.9536 | 11.9329 | 11.9464 | 759164.0 |
| 2011-01-21 08:05:00 | AAPL | Stock | 11.9461 | 11.9504 | 11.9411 | 11.9493 | 136500.0 |
| 2011-01-21 08:10:00 | AAPL | Stock | 11.9525 | 11.9579 | 11.9479 | 11.9525 | 189532.0 |
| 2011-01-21 08:15:00 | AAPL | Stock | 11.9539 | 11.9604 | 11.9521 | 11.9596 | 248640.0 |
| 2011-01-21 08:20:00 | AAPL | Stock | 11.9589 | 11.9729 | 11.9589 | 11.9711 | 579908.0 |
| 2011-01-21 08:25:00 | AAPL | Stock | 11.9718 | 11.9993 | 11.9704 | 11.9814 | 693784.0 |
| 2011-01-21 08:30:00 | AAPL | Stock | 11.9811 | 11.9929 | 11.9789 | 11.9839 | 437192.0 |
| 2011-01-21 08:35:00 | AAPL | Stock | 11.9843 | 11.9964 | 11.9825 | 11.9943 | 234668.0 |
| 2011-01-21 08:40:00 | AAPL | Stock | 11.9911 | 11.9929 | 11.9811 | 11.9868 | 221956.0 |
| 2011-01-21 08:45:00 | AAPL | Stock | 11.9875 | 11.9896 | 11.9686 | 11.9804 | 462532.0 |
| 2011-01-21 08:50:00 | AAPL | Stock | 11.9804 | 11.9804 | 11.9732 | 11.975 | 238952.0 |
| 2011-01-21 08:55:00 | AAPL | Stock | 11.9732 | 11.975 | 11.9629 | 11.9643 | 345604.0 |
| 2011-01-21 09:00:00 | AAPL | Stock | 11.9643 | 11.9643 | 11.9571 | 11.9571 | 310968.0 |
| 2011-01-21 09:05:00 | AAPL | Stock | 11.9564 | 11.9707 | 11.9536 | 11.9675 | 530880.0 |
| 2011-01-21 09:10:00 | AAPL | Stock | 11.9671 | 11.9711 | 11.9571 | 11.9625 | 332080.0 |
| 2011-01-21 09:15:00 | AAPL | Stock | 11.9611 | 11.9632 | 11.9461 | 11.9464 | 317604.0 |
| 2011-01-21 09:20:00 | AAPL | Stock | 11.9536 | 11.9611 | 11.9346 | 11.9529 | 398608.0 |
| 2011-01-21 09:25:00 | AAPL | Stock | 11.9436 | 11.9436 | 11.9054 | 11.9154 | 2108064.0 |
| 2011-01-21 09:30:00 | AAPL | Stock | 11.915 | 11.96 | 11.8954 | 11.9593 | 60481848.0 |
| 2011-01-21 09:35:00 | AAPL | Stock | 11.96 | 11.96 | 11.9071 | 11.9325 | 16264948.0 |
| 2011-01-21 09:40:00 | AAPL | Stock | 11.9325 | 11.9393 | 11.9106 | 11.9286 | 12069344.0 |
| 2011-01-21 09:45:00 | AAPL | Stock | 11.9282 | 11.9375 | 11.9089 | 11.9179 | 10595284.0 |
| 2011-01-21 09:50:00 | AAPL | Stock | 11.9189 | 11.9379 | 11.8971 | 11.9311 | 14400176.0 |
| 2011-01-21 09:55:00 | AAPL | Stock | 11.932 | 11.9464 | 11.9204 | 11.9246 | 11877236.0 |
| 2011-01-21 10:00:00 | AAPL | Stock | 11.9236 | 11.94 | 11.9071 | 11.9231 | 9412564.0 |
| 2011-01-21 10:05:00 | AAPL | Stock | 11.925 | 11.9339 | 11.9207 | 11.9257 | 7849156.0 |
> showing 50 of 339,000 rows — these rows as CSV