PREVIEW / stock_5min / 2009-12-11
file: by_date/stock_5min/2009/2009-12-11.parquet size: 4.5 MB rows: 310,606 symbols: 3,442
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-11 06:30:00 | AAPL | Stock | 7.0614 | 7.0614 | 7.0614 | 7.0614 | 2800.0 |
| 2009-12-11 06:40:00 | AAPL | Stock | 7.0571 | 7.0571 | 7.0571 | 7.0571 | 2800.0 |
| 2009-12-11 07:05:00 | AAPL | Stock | 7.0536 | 7.0536 | 7.0536 | 7.0536 | 2800.0 |
| 2009-12-11 07:35:00 | AAPL | Stock | 7.06 | 7.0607 | 7.06 | 7.0607 | 18312.0 |
| 2009-12-11 07:40:00 | AAPL | Stock | 7.0604 | 7.0661 | 7.0604 | 7.0661 | 27160.0 |
| 2009-12-11 07:45:00 | AAPL | Stock | 7.0675 | 7.0786 | 7.0675 | 7.0786 | 158788.0 |
| 2009-12-11 07:50:00 | AAPL | Stock | 7.0782 | 7.0786 | 7.0725 | 7.0732 | 35812.0 |
| 2009-12-11 07:55:00 | AAPL | Stock | 7.0761 | 7.0896 | 7.0754 | 7.0754 | 103320.0 |
| 2009-12-11 08:00:00 | AAPL | Stock | 7.0761 | 7.0786 | 7.0154 | 7.0611 | 1045324.0 |
| 2009-12-11 08:05:00 | AAPL | Stock | 7.0607 | 7.0607 | 7.0429 | 7.0561 | 216188.0 |
| 2009-12-11 08:10:00 | AAPL | Stock | 7.0561 | 7.0682 | 7.0521 | 7.0536 | 443268.0 |
| 2009-12-11 08:15:00 | AAPL | Stock | 7.0539 | 7.0546 | 7.045 | 7.0518 | 71400.0 |
| 2009-12-11 08:20:00 | AAPL | Stock | 7.0536 | 7.0582 | 7.0518 | 7.0532 | 79604.0 |
| 2009-12-11 08:25:00 | AAPL | Stock | 7.0518 | 7.0582 | 7.05 | 7.05 | 213864.0 |
| 2009-12-11 08:30:00 | AAPL | Stock | 7.0564 | 7.0654 | 7.05 | 7.0618 | 561148.0 |
| 2009-12-11 08:35:00 | AAPL | Stock | 7.0625 | 7.0714 | 7.0618 | 7.0689 | 435848.0 |
| 2009-12-11 08:40:00 | AAPL | Stock | 7.0654 | 7.0689 | 7.0611 | 7.0664 | 89684.0 |
| 2009-12-11 08:45:00 | AAPL | Stock | 7.0614 | 7.0661 | 7.0614 | 7.0625 | 47600.0 |
| 2009-12-11 08:50:00 | AAPL | Stock | 7.0664 | 7.0671 | 7.0575 | 7.0607 | 116172.0 |
| 2009-12-11 08:55:00 | AAPL | Stock | 7.0625 | 7.0625 | 7.0607 | 7.0607 | 29400.0 |
| 2009-12-11 09:00:00 | AAPL | Stock | 7.0604 | 7.0604 | 7.0554 | 7.0554 | 95200.0 |
| 2009-12-11 09:05:00 | AAPL | Stock | 7.0596 | 7.0596 | 7.0536 | 7.0579 | 241080.0 |
| 2009-12-11 09:10:00 | AAPL | Stock | 7.0579 | 7.0607 | 7.0546 | 7.0546 | 207200.0 |
| 2009-12-11 09:15:00 | AAPL | Stock | 7.0571 | 7.0571 | 7.0475 | 7.055 | 287980.0 |
| 2009-12-11 09:20:00 | AAPL | Stock | 7.0571 | 7.0593 | 7.0536 | 7.0575 | 186340.0 |
| 2009-12-11 09:25:00 | AAPL | Stock | 7.0582 | 7.0643 | 7.0546 | 7.0607 | 218932.0 |
| 2009-12-11 09:30:00 | AAPL | Stock | 7.0636 | 7.0714 | 7.0422 | 7.045 | 12842564.0 |
| 2009-12-11 09:35:00 | AAPL | Stock | 7.0443 | 7.0571 | 7.04 | 7.0564 | 7638204.0 |
| 2009-12-11 09:40:00 | AAPL | Stock | 7.0571 | 7.0679 | 7.0461 | 7.0466 | 8552460.0 |
| 2009-12-11 09:45:00 | AAPL | Stock | 7.0479 | 7.0496 | 7.0154 | 7.0179 | 12492312.0 |
| 2009-12-11 09:50:00 | AAPL | Stock | 7.0182 | 7.0468 | 7.01 | 7.0429 | 11669588.0 |
| 2009-12-11 09:55:00 | AAPL | Stock | 7.0446 | 7.0554 | 7.0268 | 7.0467 | 9525208.0 |
| 2009-12-11 10:00:00 | AAPL | Stock | 7.0475 | 7.0482 | 7.0161 | 7.0161 | 7669116.0 |
| 2009-12-11 10:05:00 | AAPL | Stock | 7.0175 | 7.0211 | 7.0089 | 7.0164 | 6984852.0 |
| 2009-12-11 10:10:00 | AAPL | Stock | 7.0154 | 7.0296 | 7.0125 | 7.0196 | 5981220.0 |
| 2009-12-11 10:15:00 | AAPL | Stock | 7.0179 | 7.0179 | 6.9771 | 6.9993 | 14245196.0 |
| 2009-12-11 10:20:00 | AAPL | Stock | 6.9993 | 6.9993 | 6.9821 | 6.9882 | 5890080.0 |
| 2009-12-11 10:25:00 | AAPL | Stock | 6.9873 | 7.0046 | 6.9857 | 7.0029 | 5110812.0 |
| 2009-12-11 10:30:00 | AAPL | Stock | 7.0039 | 7.0157 | 6.9982 | 7.0125 | 7201768.0 |
| 2009-12-11 10:35:00 | AAPL | Stock | 7.0125 | 7.0161 | 7.0068 | 7.0082 | 5369952.0 |
| 2009-12-11 10:40:00 | AAPL | Stock | 7.01 | 7.01 | 6.9904 | 6.9943 | 5443396.0 |
| 2009-12-11 10:45:00 | AAPL | Stock | 6.9939 | 6.9971 | 6.9875 | 6.9936 | 3684324.0 |
| 2009-12-11 10:50:00 | AAPL | Stock | 6.9932 | 7.0014 | 6.9923 | 6.9979 | 2977716.0 |
| 2009-12-11 10:55:00 | AAPL | Stock | 6.9972 | 7.0086 | 6.9939 | 6.9943 | 2810780.0 |
| 2009-12-11 11:00:00 | AAPL | Stock | 6.9946 | 6.9957 | 6.9839 | 6.9864 | 3312120.0 |
| 2009-12-11 11:05:00 | AAPL | Stock | 6.985 | 6.99 | 6.9786 | 6.98 | 5228384.0 |
| 2009-12-11 11:10:00 | AAPL | Stock | 6.9793 | 6.9818 | 6.9736 | 6.9771 | 4583796.0 |
| 2009-12-11 11:15:00 | AAPL | Stock | 6.9768 | 6.9807 | 6.9679 | 6.9698 | 5175296.0 |
| 2009-12-11 11:20:00 | AAPL | Stock | 6.9689 | 6.9693 | 6.9418 | 6.9443 | 15399720.0 |
| 2009-12-11 11:25:00 | AAPL | Stock | 6.9439 | 6.9518 | 6.9375 | 6.9491 | 10726324.0 |
> showing 50 of 310,606 rows — these rows as CSV