PREVIEW / stock_5min / 2004-04-07
file: by_date/stock_5min/2004/2004-04-07.parquet size: 2.3 MB rows: 174,357 symbols: 1,759
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-04-07 09:25:00 | AAPL | Stock | 0.4921 | 0.4927 | 0.4909 | 0.492 | 376880.0 |
| 2004-04-07 09:30:00 | AAPL | Stock | 0.4932 | 0.4946 | 0.4879 | 0.4893 | 8286488.0 |
| 2004-04-07 09:35:00 | AAPL | Stock | 0.4893 | 0.4918 | 0.4893 | 0.4909 | 2820552.0 |
| 2004-04-07 09:40:00 | AAPL | Stock | 0.4911 | 0.4911 | 0.4882 | 0.4889 | 5451432.0 |
| 2004-04-07 09:45:00 | AAPL | Stock | 0.4889 | 0.4891 | 0.4873 | 0.4889 | 10896648.0 |
| 2004-04-07 09:50:00 | AAPL | Stock | 0.4889 | 0.4889 | 0.4879 | 0.4884 | 4303096.0 |
| 2004-04-07 09:55:00 | AAPL | Stock | 0.4886 | 0.4889 | 0.4882 | 0.4889 | 5104792.0 |
| 2004-04-07 10:00:00 | AAPL | Stock | 0.4888 | 0.49 | 0.4882 | 0.4893 | 4344424.0 |
| 2004-04-07 10:05:00 | AAPL | Stock | 0.4896 | 0.4898 | 0.4884 | 0.4891 | 9955176.0 |
| 2004-04-07 10:10:00 | AAPL | Stock | 0.4891 | 0.4891 | 0.4873 | 0.488 | 5411672.0 |
| 2004-04-07 10:15:00 | AAPL | Stock | 0.488 | 0.488 | 0.4841 | 0.4847 | 8940848.0 |
| 2004-04-07 10:20:00 | AAPL | Stock | 0.485 | 0.4854 | 0.483 | 0.485 | 5368104.0 |
| 2004-04-07 10:25:00 | AAPL | Stock | 0.485 | 0.4877 | 0.4848 | 0.4873 | 3986976.0 |
| 2004-04-07 10:30:00 | AAPL | Stock | 0.4873 | 0.4873 | 0.4861 | 0.4861 | 1771056.0 |
| 2004-04-07 10:35:00 | AAPL | Stock | 0.4863 | 0.4875 | 0.4854 | 0.4871 | 2886408.0 |
| 2004-04-07 10:40:00 | AAPL | Stock | 0.4871 | 0.4871 | 0.4859 | 0.4863 | 4354000.0 |
| 2004-04-07 10:45:00 | AAPL | Stock | 0.4861 | 0.487 | 0.4859 | 0.4866 | 2975000.0 |
| 2004-04-07 10:50:00 | AAPL | Stock | 0.4863 | 0.4868 | 0.4857 | 0.4859 | 2391760.0 |
| 2004-04-07 10:55:00 | AAPL | Stock | 0.4859 | 0.4864 | 0.4857 | 0.4863 | 921760.0 |
| 2004-04-07 11:00:00 | AAPL | Stock | 0.4863 | 0.4863 | 0.4855 | 0.4861 | 592144.0 |
| 2004-04-07 11:05:00 | AAPL | Stock | 0.4859 | 0.4864 | 0.4854 | 0.4864 | 1376592.0 |
| 2004-04-07 11:10:00 | AAPL | Stock | 0.4864 | 0.4864 | 0.4861 | 0.4863 | 1155280.0 |
| 2004-04-07 11:15:00 | AAPL | Stock | 0.4864 | 0.4868 | 0.4861 | 0.4866 | 2277128.0 |
| 2004-04-07 11:20:00 | AAPL | Stock | 0.4866 | 0.4884 | 0.4866 | 0.4873 | 3306128.0 |
| 2004-04-07 11:25:00 | AAPL | Stock | 0.4871 | 0.4873 | 0.4864 | 0.487 | 2050384.0 |
| 2004-04-07 11:30:00 | AAPL | Stock | 0.487 | 0.487 | 0.4868 | 0.4868 | 616896.0 |
| 2004-04-07 11:35:00 | AAPL | Stock | 0.4868 | 0.487 | 0.4868 | 0.4868 | 890848.0 |
| 2004-04-07 11:40:00 | AAPL | Stock | 0.4868 | 0.487 | 0.4866 | 0.4866 | 3222464.0 |
| 2004-04-07 11:45:00 | AAPL | Stock | 0.4866 | 0.487 | 0.4855 | 0.4855 | 3108952.0 |
| 2004-04-07 11:50:00 | AAPL | Stock | 0.4855 | 0.4861 | 0.4848 | 0.4852 | 3002160.0 |
| 2004-04-07 11:55:00 | AAPL | Stock | 0.4852 | 0.4857 | 0.4838 | 0.4838 | 4224528.0 |
| 2004-04-07 12:00:00 | AAPL | Stock | 0.4838 | 0.4839 | 0.4829 | 0.4832 | 5043920.0 |
| 2004-04-07 12:05:00 | AAPL | Stock | 0.483 | 0.4834 | 0.4829 | 0.4834 | 2568328.0 |
| 2004-04-07 12:10:00 | AAPL | Stock | 0.4834 | 0.4843 | 0.4834 | 0.4839 | 1247624.0 |
| 2004-04-07 12:15:00 | AAPL | Stock | 0.4839 | 0.4839 | 0.4832 | 0.4832 | 4721304.0 |
| 2004-04-07 12:20:00 | AAPL | Stock | 0.4834 | 0.4834 | 0.483 | 0.4832 | 5132568.0 |
| 2004-04-07 12:25:00 | AAPL | Stock | 0.4832 | 0.4838 | 0.483 | 0.4832 | 2144968.0 |
| 2004-04-07 12:30:00 | AAPL | Stock | 0.4832 | 0.4836 | 0.483 | 0.4836 | 3415048.0 |
| 2004-04-07 12:35:00 | AAPL | Stock | 0.4836 | 0.4836 | 0.4832 | 0.4832 | 698040.0 |
| 2004-04-07 12:40:00 | AAPL | Stock | 0.4832 | 0.4834 | 0.483 | 0.483 | 1482712.0 |
| 2004-04-07 12:45:00 | AAPL | Stock | 0.483 | 0.483 | 0.4807 | 0.4809 | 4551736.0 |
| 2004-04-07 12:50:00 | AAPL | Stock | 0.4811 | 0.4827 | 0.4809 | 0.4827 | 2744672.0 |
| 2004-04-07 12:55:00 | AAPL | Stock | 0.4825 | 0.4829 | 0.4814 | 0.4821 | 1430016.0 |
| 2004-04-07 13:00:00 | AAPL | Stock | 0.4821 | 0.4839 | 0.4821 | 0.4839 | 2262344.0 |
| 2004-04-07 13:05:00 | AAPL | Stock | 0.4839 | 0.4852 | 0.4836 | 0.4838 | 2303672.0 |
| 2004-04-07 13:10:00 | AAPL | Stock | 0.4838 | 0.4839 | 0.4836 | 0.4838 | 850080.0 |
| 2004-04-07 13:15:00 | AAPL | Stock | 0.4839 | 0.4848 | 0.4838 | 0.4846 | 2890496.0 |
| 2004-04-07 13:20:00 | AAPL | Stock | 0.4846 | 0.4848 | 0.4846 | 0.4846 | 666400.0 |
| 2004-04-07 13:25:00 | AAPL | Stock | 0.4848 | 0.4857 | 0.4846 | 0.4857 | 2814336.0 |
| 2004-04-07 13:30:00 | AAPL | Stock | 0.4857 | 0.4857 | 0.4854 | 0.4854 | 745136.0 |
> showing 50 of 174,357 rows — these rows as CSV