PREVIEW / stock_5min / 2004-05-07
file: by_date/stock_5min/2004/2004-05-07.parquet size: 2.6 MB rows: 181,969 symbols: 1,772
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 |
|---|---|---|---|---|---|---|---|
| 2004-05-07 08:25:00 | AAPL | Stock | 0.4759 | 0.4759 | 0.4759 | 0.4759 | 11200.0 |
| 2004-05-07 08:30:00 | AAPL | Stock | 0.475 | 0.475 | 0.4746 | 0.4746 | 168000.0 |
| 2004-05-07 08:35:00 | AAPL | Stock | 0.4746 | 0.4746 | 0.4746 | 0.4746 | 56000.0 |
| 2004-05-07 08:45:00 | AAPL | Stock | 0.4748 | 0.4748 | 0.4746 | 0.4746 | 33600.0 |
| 2004-05-07 08:50:00 | AAPL | Stock | 0.4746 | 0.4746 | 0.4746 | 0.4746 | 50400.0 |
| 2004-05-07 08:55:00 | AAPL | Stock | 0.4746 | 0.4746 | 0.4746 | 0.4746 | 28000.0 |
| 2004-05-07 09:00:00 | AAPL | Stock | 0.4746 | 0.4746 | 0.4746 | 0.4746 | 5600.0 |
| 2004-05-07 09:10:00 | AAPL | Stock | 0.4746 | 0.4746 | 0.4745 | 0.4745 | 397600.0 |
| 2004-05-07 09:15:00 | AAPL | Stock | 0.4739 | 0.4739 | 0.4739 | 0.4739 | 68600.0 |
| 2004-05-07 09:20:00 | AAPL | Stock | 0.4739 | 0.4739 | 0.4739 | 0.4739 | 168000.0 |
| 2004-05-07 09:25:00 | AAPL | Stock | 0.4741 | 0.4748 | 0.4741 | 0.4741 | 604016.0 |
| 2004-05-07 09:30:00 | AAPL | Stock | 0.4745 | 0.4784 | 0.4741 | 0.4777 | 11967816.0 |
| 2004-05-07 09:35:00 | AAPL | Stock | 0.4779 | 0.4807 | 0.4773 | 0.4796 | 8846096.0 |
| 2004-05-07 09:40:00 | AAPL | Stock | 0.4791 | 0.4829 | 0.4791 | 0.4821 | 17828608.0 |
| 2004-05-07 09:45:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.4788 | 0.4805 | 7978264.0 |
| 2004-05-07 09:50:00 | AAPL | Stock | 0.4805 | 0.4813 | 0.4795 | 0.4807 | 12331200.0 |
| 2004-05-07 09:55:00 | AAPL | Stock | 0.4809 | 0.482 | 0.48 | 0.48 | 13061552.0 |
| 2004-05-07 10:00:00 | AAPL | Stock | 0.48 | 0.4829 | 0.4777 | 0.4795 | 10986304.0 |
| 2004-05-07 10:05:00 | AAPL | Stock | 0.4795 | 0.4804 | 0.4782 | 0.4802 | 6718768.0 |
| 2004-05-07 10:10:00 | AAPL | Stock | 0.48 | 0.4804 | 0.4795 | 0.48 | 5226536.0 |
| 2004-05-07 10:15:00 | AAPL | Stock | 0.48 | 0.4802 | 0.4788 | 0.4795 | 6381592.0 |
| 2004-05-07 10:20:00 | AAPL | Stock | 0.4796 | 0.482 | 0.4796 | 0.4818 | 9003512.0 |
| 2004-05-07 10:25:00 | AAPL | Stock | 0.4818 | 0.482 | 0.4814 | 0.482 | 8622096.0 |
| 2004-05-07 10:30:00 | AAPL | Stock | 0.482 | 0.4829 | 0.4816 | 0.4827 | 12036640.0 |
| 2004-05-07 10:35:00 | AAPL | Stock | 0.4829 | 0.4838 | 0.4827 | 0.4836 | 7896952.0 |
| 2004-05-07 10:40:00 | AAPL | Stock | 0.4834 | 0.4852 | 0.4832 | 0.4843 | 10949680.0 |
| 2004-05-07 10:45:00 | AAPL | Stock | 0.4843 | 0.4886 | 0.4843 | 0.4882 | 10396736.0 |
| 2004-05-07 10:50:00 | AAPL | Stock | 0.4882 | 0.4891 | 0.4877 | 0.4879 | 6607552.0 |
| 2004-05-07 10:55:00 | AAPL | Stock | 0.488 | 0.4884 | 0.487 | 0.4884 | 5786704.0 |
| 2004-05-07 11:00:00 | AAPL | Stock | 0.4882 | 0.4888 | 0.4877 | 0.4886 | 6571656.0 |
| 2004-05-07 11:05:00 | AAPL | Stock | 0.4886 | 0.4891 | 0.488 | 0.4888 | 4171104.0 |
| 2004-05-07 11:10:00 | AAPL | Stock | 0.4888 | 0.4891 | 0.4884 | 0.4891 | 5578104.0 |
| 2004-05-07 11:15:00 | AAPL | Stock | 0.4889 | 0.4904 | 0.4888 | 0.49 | 5282200.0 |
| 2004-05-07 11:20:00 | AAPL | Stock | 0.49 | 0.4904 | 0.4886 | 0.4895 | 3918488.0 |
| 2004-05-07 11:25:00 | AAPL | Stock | 0.4893 | 0.4916 | 0.4893 | 0.4916 | 9566984.0 |
| 2004-05-07 11:30:00 | AAPL | Stock | 0.4916 | 0.492 | 0.4911 | 0.4916 | 4010160.0 |
| 2004-05-07 11:35:00 | AAPL | Stock | 0.4916 | 0.4923 | 0.4914 | 0.4916 | 7392336.0 |
| 2004-05-07 11:40:00 | AAPL | Stock | 0.4916 | 0.4923 | 0.4911 | 0.4911 | 2619624.0 |
| 2004-05-07 11:45:00 | AAPL | Stock | 0.4911 | 0.4911 | 0.4902 | 0.4904 | 6563144.0 |
| 2004-05-07 11:50:00 | AAPL | Stock | 0.4903 | 0.4913 | 0.4903 | 0.4911 | 3339784.0 |
| 2004-05-07 11:55:00 | AAPL | Stock | 0.4911 | 0.4914 | 0.4905 | 0.4907 | 1494920.0 |
| 2004-05-07 12:00:00 | AAPL | Stock | 0.4907 | 0.4909 | 0.4893 | 0.4895 | 2671480.0 |
| 2004-05-07 12:05:00 | AAPL | Stock | 0.4895 | 0.49 | 0.4888 | 0.4893 | 1836576.0 |
| 2004-05-07 12:10:00 | AAPL | Stock | 0.4891 | 0.4893 | 0.4879 | 0.4879 | 1938944.0 |
| 2004-05-07 12:15:00 | AAPL | Stock | 0.488 | 0.4884 | 0.4873 | 0.4882 | 1971872.0 |
| 2004-05-07 12:20:00 | AAPL | Stock | 0.488 | 0.4884 | 0.4879 | 0.4884 | 3117464.0 |
| 2004-05-07 12:25:00 | AAPL | Stock | 0.4884 | 0.4886 | 0.488 | 0.4882 | 900144.0 |
| 2004-05-07 12:30:00 | AAPL | Stock | 0.4882 | 0.4895 | 0.4879 | 0.4893 | 2578184.0 |
| 2004-05-07 12:35:00 | AAPL | Stock | 0.4891 | 0.4893 | 0.4886 | 0.4886 | 593600.0 |
| 2004-05-07 12:40:00 | AAPL | Stock | 0.4886 | 0.4888 | 0.4882 | 0.4884 | 801752.0 |
> showing 50 of 181,969 rows — these rows as CSV