PREVIEW / stock_5min / 2004-05-19
file: by_date/stock_5min/2004/2004-05-19.parquet size: 2.4 MB rows: 177,483 symbols: 1,781
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-19 08:00:00 | AAPL | Stock | 0.4832 | 0.4832 | 0.4832 | 0.4832 | 448000.0 |
| 2004-05-19 08:50:00 | AAPL | Stock | 0.4893 | 0.4893 | 0.4893 | 0.4893 | 5600.0 |
| 2004-05-19 08:55:00 | AAPL | Stock | 0.4886 | 0.4886 | 0.4866 | 0.4866 | 196000.0 |
| 2004-05-19 09:00:00 | AAPL | Stock | 0.4875 | 0.4875 | 0.4875 | 0.4875 | 22400.0 |
| 2004-05-19 09:10:00 | AAPL | Stock | 0.487 | 0.487 | 0.487 | 0.487 | 11200.0 |
| 2004-05-19 09:20:00 | AAPL | Stock | 0.4875 | 0.4875 | 0.4875 | 0.4875 | 16800.0 |
| 2004-05-19 09:25:00 | AAPL | Stock | 0.4884 | 0.4893 | 0.4868 | 0.4893 | 291200.0 |
| 2004-05-19 09:30:00 | AAPL | Stock | 0.4895 | 0.4911 | 0.4886 | 0.4904 | 7301728.0 |
| 2004-05-19 09:35:00 | AAPL | Stock | 0.4902 | 0.4911 | 0.4886 | 0.4888 | 3740016.0 |
| 2004-05-19 09:40:00 | AAPL | Stock | 0.4889 | 0.4893 | 0.4866 | 0.4871 | 4516512.0 |
| 2004-05-19 09:45:00 | AAPL | Stock | 0.4873 | 0.4886 | 0.4866 | 0.4877 | 11904872.0 |
| 2004-05-19 09:50:00 | AAPL | Stock | 0.4877 | 0.4879 | 0.4859 | 0.4866 | 8519336.0 |
| 2004-05-19 09:55:00 | AAPL | Stock | 0.4866 | 0.487 | 0.4864 | 0.487 | 2605120.0 |
| 2004-05-19 10:00:00 | AAPL | Stock | 0.487 | 0.487 | 0.4863 | 0.4866 | 5493320.0 |
| 2004-05-19 10:05:00 | AAPL | Stock | 0.4868 | 0.4875 | 0.4863 | 0.4868 | 6175904.0 |
| 2004-05-19 10:10:00 | AAPL | Stock | 0.4866 | 0.4873 | 0.4866 | 0.4868 | 5167624.0 |
| 2004-05-19 10:15:00 | AAPL | Stock | 0.4868 | 0.4877 | 0.4866 | 0.4873 | 2590392.0 |
| 2004-05-19 10:20:00 | AAPL | Stock | 0.4871 | 0.4871 | 0.4863 | 0.4864 | 3324384.0 |
| 2004-05-19 10:25:00 | AAPL | Stock | 0.4864 | 0.4871 | 0.4863 | 0.487 | 1460312.0 |
| 2004-05-19 10:30:00 | AAPL | Stock | 0.4871 | 0.4871 | 0.4859 | 0.4861 | 5686520.0 |
| 2004-05-19 10:35:00 | AAPL | Stock | 0.4859 | 0.4882 | 0.4859 | 0.4882 | 8639176.0 |
| 2004-05-19 10:40:00 | AAPL | Stock | 0.4882 | 0.4893 | 0.488 | 0.4891 | 9352448.0 |
| 2004-05-19 10:45:00 | AAPL | Stock | 0.4893 | 0.4893 | 0.488 | 0.4882 | 3849552.0 |
| 2004-05-19 10:50:00 | AAPL | Stock | 0.4882 | 0.4889 | 0.4873 | 0.4877 | 2374176.0 |
| 2004-05-19 10:55:00 | AAPL | Stock | 0.4877 | 0.4879 | 0.4866 | 0.4868 | 3410736.0 |
| 2004-05-19 11:00:00 | AAPL | Stock | 0.4873 | 0.4879 | 0.4866 | 0.4866 | 2283288.0 |
| 2004-05-19 11:05:00 | AAPL | Stock | 0.4866 | 0.4875 | 0.4866 | 0.4875 | 1313480.0 |
| 2004-05-19 11:10:00 | AAPL | Stock | 0.4875 | 0.4875 | 0.4873 | 0.4875 | 1785616.0 |
| 2004-05-19 11:15:00 | AAPL | Stock | 0.4873 | 0.4875 | 0.4873 | 0.4873 | 818440.0 |
| 2004-05-19 11:20:00 | AAPL | Stock | 0.4873 | 0.4882 | 0.4873 | 0.4877 | 1626576.0 |
| 2004-05-19 11:25:00 | AAPL | Stock | 0.4875 | 0.488 | 0.4873 | 0.4879 | 2827552.0 |
| 2004-05-19 11:30:00 | AAPL | Stock | 0.4879 | 0.488 | 0.4866 | 0.4866 | 1052688.0 |
| 2004-05-19 11:35:00 | AAPL | Stock | 0.4866 | 0.487 | 0.4864 | 0.4866 | 2349480.0 |
| 2004-05-19 11:40:00 | AAPL | Stock | 0.4866 | 0.4868 | 0.4864 | 0.4864 | 1663032.0 |
| 2004-05-19 11:45:00 | AAPL | Stock | 0.4868 | 0.4868 | 0.4852 | 0.4857 | 2545200.0 |
| 2004-05-19 11:50:00 | AAPL | Stock | 0.4857 | 0.4866 | 0.4857 | 0.4863 | 1369200.0 |
| 2004-05-19 11:55:00 | AAPL | Stock | 0.4866 | 0.4866 | 0.4863 | 0.4866 | 708400.0 |
| 2004-05-19 12:00:00 | AAPL | Stock | 0.4866 | 0.4866 | 0.4861 | 0.4863 | 1800736.0 |
| 2004-05-19 12:05:00 | AAPL | Stock | 0.4861 | 0.4871 | 0.4861 | 0.487 | 1450176.0 |
| 2004-05-19 12:10:00 | AAPL | Stock | 0.487 | 0.4871 | 0.4868 | 0.487 | 465080.0 |
| 2004-05-19 12:15:00 | AAPL | Stock | 0.487 | 0.4871 | 0.4868 | 0.487 | 645400.0 |
| 2004-05-19 12:20:00 | AAPL | Stock | 0.487 | 0.4871 | 0.4866 | 0.4866 | 455952.0 |
| 2004-05-19 12:25:00 | AAPL | Stock | 0.4868 | 0.4873 | 0.4868 | 0.4871 | 534576.0 |
| 2004-05-19 12:30:00 | AAPL | Stock | 0.4871 | 0.4873 | 0.4868 | 0.487 | 1097208.0 |
| 2004-05-19 12:35:00 | AAPL | Stock | 0.4873 | 0.4873 | 0.4866 | 0.4866 | 1821400.0 |
| 2004-05-19 12:40:00 | AAPL | Stock | 0.4866 | 0.4866 | 0.4864 | 0.4864 | 1976800.0 |
| 2004-05-19 12:45:00 | AAPL | Stock | 0.4864 | 0.4866 | 0.4857 | 0.4864 | 1628704.0 |
| 2004-05-19 12:50:00 | AAPL | Stock | 0.4863 | 0.4866 | 0.4859 | 0.4866 | 866880.0 |
| 2004-05-19 12:55:00 | AAPL | Stock | 0.4866 | 0.4866 | 0.4861 | 0.4864 | 1462328.0 |
| 2004-05-19 13:00:00 | AAPL | Stock | 0.4863 | 0.4866 | 0.4861 | 0.4866 | 850864.0 |
> showing 50 of 177,483 rows — these rows as CSV