PREVIEW / stock_5min / 2011-01-20
file: by_date/stock_5min/2011/2011-01-20.parquet size: 5.0 MB rows: 338,486 symbols: 3,514
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-20 04:35:00 | AAPL | Stock | 12.0736 | 12.0736 | 12.0736 | 12.0736 | 2800.0 |
| 2011-01-20 04:45:00 | AAPL | Stock | 12.0696 | 12.0696 | 12.0696 | 12.0696 | 2800.0 |
| 2011-01-20 04:50:00 | AAPL | Stock | 12.0736 | 12.0736 | 12.0736 | 12.0736 | 8400.0 |
| 2011-01-20 04:55:00 | AAPL | Stock | 12.0821 | 12.0821 | 12.0821 | 12.0821 | 2800.0 |
| 2011-01-20 05:35:00 | AAPL | Stock | 12.0714 | 12.0714 | 12.0714 | 12.0714 | 8400.0 |
| 2011-01-20 05:40:00 | AAPL | Stock | 12.0714 | 12.0771 | 12.0714 | 12.0771 | 16800.0 |
| 2011-01-20 05:55:00 | AAPL | Stock | 12.0714 | 12.0714 | 12.0714 | 12.0714 | 31360.0 |
| 2011-01-20 06:05:00 | AAPL | Stock | 12.0707 | 12.0707 | 12.0707 | 12.0707 | 22400.0 |
| 2011-01-20 06:30:00 | AAPL | Stock | 12.0714 | 12.0714 | 12.0714 | 12.0714 | 12320.0 |
| 2011-01-20 06:45:00 | AAPL | Stock | 12.0429 | 12.0429 | 12.0429 | 12.0429 | 2800.0 |
| 2011-01-20 06:55:00 | AAPL | Stock | 12.0714 | 12.0714 | 12.0714 | 12.0714 | 8400.0 |
| 2011-01-20 07:00:00 | AAPL | Stock | 12.0693 | 12.0714 | 12.0589 | 12.0589 | 41300.0 |
| 2011-01-20 07:05:00 | AAPL | Stock | 12.0568 | 12.075 | 12.0568 | 12.075 | 138376.0 |
| 2011-01-20 07:10:00 | AAPL | Stock | 12.075 | 12.0936 | 12.0714 | 12.0846 | 103684.0 |
| 2011-01-20 07:15:00 | AAPL | Stock | 12.0714 | 12.0714 | 12.0679 | 12.0704 | 19600.0 |
| 2011-01-20 07:20:00 | AAPL | Stock | 12.0643 | 12.0675 | 12.0361 | 12.0468 | 75600.0 |
| 2011-01-20 07:25:00 | AAPL | Stock | 12.0525 | 12.0611 | 12.0496 | 12.0586 | 33600.0 |
| 2011-01-20 07:30:00 | AAPL | Stock | 12.0532 | 12.0536 | 12.0436 | 12.0536 | 28000.0 |
| 2011-01-20 07:35:00 | AAPL | Stock | 12.0518 | 12.0679 | 12.0518 | 12.0625 | 84000.0 |
| 2011-01-20 07:40:00 | AAPL | Stock | 12.0625 | 12.0714 | 12.0454 | 12.0454 | 98000.0 |
| 2011-01-20 07:50:00 | AAPL | Stock | 12.0589 | 12.0707 | 12.0589 | 12.0707 | 47600.0 |
| 2011-01-20 07:55:00 | AAPL | Stock | 12.0557 | 12.0557 | 12.0532 | 12.0532 | 8400.0 |
| 2011-01-20 08:00:00 | AAPL | Stock | 12.0536 | 12.0646 | 12.0461 | 12.0482 | 127316.0 |
| 2011-01-20 08:05:00 | AAPL | Stock | 12.0482 | 12.0539 | 12.0179 | 12.0411 | 591024.0 |
| 2011-01-20 08:10:00 | AAPL | Stock | 12.0446 | 12.0464 | 12.0357 | 12.0446 | 124880.0 |
| 2011-01-20 08:15:00 | AAPL | Stock | 12.0421 | 12.0593 | 12.0393 | 12.0464 | 179200.0 |
| 2011-01-20 08:20:00 | AAPL | Stock | 12.05 | 12.0571 | 12.0429 | 12.0454 | 32508.0 |
| 2011-01-20 08:25:00 | AAPL | Stock | 12.0436 | 12.0454 | 12.0368 | 12.0368 | 66388.0 |
| 2011-01-20 08:30:00 | AAPL | Stock | 12.0464 | 12.0614 | 12.0425 | 12.0532 | 350980.0 |
| 2011-01-20 08:35:00 | AAPL | Stock | 12.0461 | 12.0589 | 12.0446 | 12.0564 | 47600.0 |
| 2011-01-20 08:40:00 | AAPL | Stock | 12.0582 | 12.0611 | 12.0489 | 12.0489 | 384608.0 |
| 2011-01-20 08:45:00 | AAPL | Stock | 12.0493 | 12.0536 | 12.0471 | 12.0536 | 71736.0 |
| 2011-01-20 08:50:00 | AAPL | Stock | 12.0507 | 12.0625 | 12.0504 | 12.0625 | 184632.0 |
| 2011-01-20 08:55:00 | AAPL | Stock | 12.0661 | 12.0661 | 12.0593 | 12.0636 | 77896.0 |
| 2011-01-20 09:00:00 | AAPL | Stock | 12.0621 | 12.0646 | 12.0593 | 12.0643 | 234808.0 |
| 2011-01-20 09:05:00 | AAPL | Stock | 12.0646 | 12.0646 | 12.0357 | 12.0464 | 483896.0 |
| 2011-01-20 09:10:00 | AAPL | Stock | 12.0464 | 12.0589 | 12.0357 | 12.0521 | 668332.0 |
| 2011-01-20 09:15:00 | AAPL | Stock | 12.0468 | 12.0504 | 12.0357 | 12.0375 | 262444.0 |
| 2011-01-20 09:20:00 | AAPL | Stock | 12.0361 | 12.0361 | 12.0214 | 12.025 | 249228.0 |
| 2011-01-20 09:25:00 | AAPL | Stock | 12.0264 | 12.0339 | 12.0004 | 12.0004 | 1175048.0 |
| 2011-01-20 09:30:00 | AAPL | Stock | 12.0154 | 12.0821 | 12.0 | 12.0232 | 23490292.0 |
| 2011-01-20 09:35:00 | AAPL | Stock | 12.0233 | 12.0279 | 11.9196 | 11.9525 | 37793896.0 |
| 2011-01-20 09:40:00 | AAPL | Stock | 11.9539 | 11.9707 | 11.88 | 11.9068 | 32273584.0 |
| 2011-01-20 09:45:00 | AAPL | Stock | 11.9079 | 11.9721 | 11.9068 | 11.959 | 24642632.0 |
| 2011-01-20 09:50:00 | AAPL | Stock | 11.9621 | 11.9685 | 11.9464 | 11.9464 | 12409572.0 |
| 2011-01-20 09:55:00 | AAPL | Stock | 11.9465 | 11.9467 | 11.9136 | 11.9393 | 12984944.0 |
| 2011-01-20 10:00:00 | AAPL | Stock | 11.9393 | 11.942 | 11.8843 | 11.885 | 20727224.0 |
| 2011-01-20 10:05:00 | AAPL | Stock | 11.8871 | 11.8889 | 11.7904 | 11.7925 | 47063688.0 |
| 2011-01-20 10:10:00 | AAPL | Stock | 11.7937 | 11.8443 | 11.79 | 11.8387 | 33037760.0 |
| 2011-01-20 10:15:00 | AAPL | Stock | 11.8371 | 11.8532 | 11.8079 | 11.8114 | 17949876.0 |
> showing 50 of 338,486 rows — these rows as CSV