PREVIEW / stock_5min / 2004-07-15
file: by_date/stock_5min/2004/2004-07-15.parquet size: 2.3 MB rows: 173,087 symbols: 1,793
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-07-15 08:00:00 | AAPL | Stock | 0.5796 | 0.5836 | 0.5634 | 0.5821 | 6985944.0 |
| 2004-07-15 08:05:00 | AAPL | Stock | 0.5811 | 0.583 | 0.5771 | 0.5795 | 2764384.0 |
| 2004-07-15 08:10:00 | AAPL | Stock | 0.5791 | 0.58 | 0.5773 | 0.5795 | 2150064.0 |
| 2004-07-15 08:15:00 | AAPL | Stock | 0.5789 | 0.5789 | 0.5763 | 0.5763 | 1108016.0 |
| 2004-07-15 08:20:00 | AAPL | Stock | 0.5763 | 0.5786 | 0.575 | 0.5786 | 4467400.0 |
| 2004-07-15 08:25:00 | AAPL | Stock | 0.5786 | 0.5786 | 0.5768 | 0.5777 | 2489480.0 |
| 2004-07-15 08:30:00 | AAPL | Stock | 0.5782 | 0.5786 | 0.5777 | 0.5777 | 655200.0 |
| 2004-07-15 08:35:00 | AAPL | Stock | 0.577 | 0.5777 | 0.5759 | 0.5759 | 591360.0 |
| 2004-07-15 08:40:00 | AAPL | Stock | 0.5768 | 0.5784 | 0.5768 | 0.5784 | 597520.0 |
| 2004-07-15 08:45:00 | AAPL | Stock | 0.5777 | 0.5839 | 0.5759 | 0.583 | 4954488.0 |
| 2004-07-15 08:50:00 | AAPL | Stock | 0.5825 | 0.5825 | 0.5771 | 0.5788 | 2708720.0 |
| 2004-07-15 08:55:00 | AAPL | Stock | 0.5789 | 0.5807 | 0.5789 | 0.58 | 1332464.0 |
| 2004-07-15 09:00:00 | AAPL | Stock | 0.5804 | 0.5825 | 0.5804 | 0.5825 | 1226400.0 |
| 2004-07-15 09:05:00 | AAPL | Stock | 0.5825 | 0.5839 | 0.5825 | 0.583 | 1892800.0 |
| 2004-07-15 09:10:00 | AAPL | Stock | 0.583 | 0.583 | 0.5798 | 0.5813 | 1179080.0 |
| 2004-07-15 09:15:00 | AAPL | Stock | 0.5768 | 0.5821 | 0.5768 | 0.5805 | 1909600.0 |
| 2004-07-15 09:20:00 | AAPL | Stock | 0.5813 | 0.5855 | 0.5813 | 0.583 | 2855944.0 |
| 2004-07-15 09:25:00 | AAPL | Stock | 0.583 | 0.5841 | 0.5825 | 0.583 | 4688264.0 |
| 2004-07-15 09:30:00 | AAPL | Stock | 0.5813 | 0.5991 | 0.5809 | 0.5947 | 127795192.0 |
| 2004-07-15 09:35:00 | AAPL | Stock | 0.5946 | 0.6005 | 0.5904 | 0.5932 | 91240912.0 |
| 2004-07-15 09:40:00 | AAPL | Stock | 0.5932 | 0.5952 | 0.5866 | 0.5882 | 83940976.0 |
| 2004-07-15 09:45:00 | AAPL | Stock | 0.5884 | 0.5918 | 0.5873 | 0.5916 | 83456800.0 |
| 2004-07-15 09:50:00 | AAPL | Stock | 0.5918 | 0.5929 | 0.5895 | 0.5904 | 76743912.0 |
| 2004-07-15 09:55:00 | AAPL | Stock | 0.5904 | 0.5916 | 0.588 | 0.5889 | 68535096.0 |
| 2004-07-15 10:00:00 | AAPL | Stock | 0.5889 | 0.5893 | 0.5832 | 0.5846 | 55817440.0 |
| 2004-07-15 10:05:00 | AAPL | Stock | 0.5846 | 0.5873 | 0.5829 | 0.5857 | 50932336.0 |
| 2004-07-15 10:10:00 | AAPL | Stock | 0.5855 | 0.5875 | 0.5846 | 0.5863 | 31187688.0 |
| 2004-07-15 10:15:00 | AAPL | Stock | 0.5863 | 0.5866 | 0.5804 | 0.5834 | 38825080.0 |
| 2004-07-15 10:20:00 | AAPL | Stock | 0.5834 | 0.5893 | 0.5834 | 0.5882 | 44384480.0 |
| 2004-07-15 10:25:00 | AAPL | Stock | 0.588 | 0.5911 | 0.5879 | 0.5888 | 46180064.0 |
| 2004-07-15 10:30:00 | AAPL | Stock | 0.5888 | 0.5896 | 0.5866 | 0.5888 | 13654200.0 |
| 2004-07-15 10:35:00 | AAPL | Stock | 0.5888 | 0.5893 | 0.5852 | 0.5868 | 19961872.0 |
| 2004-07-15 10:40:00 | AAPL | Stock | 0.5868 | 0.5871 | 0.5852 | 0.5854 | 18193112.0 |
| 2004-07-15 10:45:00 | AAPL | Stock | 0.5854 | 0.5888 | 0.5854 | 0.5882 | 20518512.0 |
| 2004-07-15 10:50:00 | AAPL | Stock | 0.588 | 0.5881 | 0.5846 | 0.5854 | 10254664.0 |
| 2004-07-15 10:55:00 | AAPL | Stock | 0.5855 | 0.5855 | 0.5816 | 0.5818 | 17874640.0 |
| 2004-07-15 11:00:00 | AAPL | Stock | 0.5818 | 0.5838 | 0.5809 | 0.5834 | 20789104.0 |
| 2004-07-15 11:05:00 | AAPL | Stock | 0.5832 | 0.5852 | 0.5825 | 0.5836 | 14415352.0 |
| 2004-07-15 11:10:00 | AAPL | Stock | 0.5836 | 0.5839 | 0.5775 | 0.5788 | 25294528.0 |
| 2004-07-15 11:15:00 | AAPL | Stock | 0.5788 | 0.5795 | 0.5773 | 0.5779 | 18708200.0 |
| 2004-07-15 11:20:00 | AAPL | Stock | 0.5779 | 0.578 | 0.575 | 0.5769 | 24432968.0 |
| 2004-07-15 11:25:00 | AAPL | Stock | 0.577 | 0.5784 | 0.5759 | 0.5777 | 18818464.0 |
| 2004-07-15 11:30:00 | AAPL | Stock | 0.5775 | 0.5795 | 0.5771 | 0.5788 | 14204680.0 |
| 2004-07-15 11:35:00 | AAPL | Stock | 0.5788 | 0.5789 | 0.575 | 0.5763 | 14053648.0 |
| 2004-07-15 11:40:00 | AAPL | Stock | 0.5764 | 0.5766 | 0.5736 | 0.5738 | 16774296.0 |
| 2004-07-15 11:45:00 | AAPL | Stock | 0.5738 | 0.5766 | 0.5734 | 0.5759 | 26295920.0 |
| 2004-07-15 11:50:00 | AAPL | Stock | 0.5761 | 0.5795 | 0.5755 | 0.5791 | 18921336.0 |
| 2004-07-15 11:55:00 | AAPL | Stock | 0.5791 | 0.5809 | 0.5788 | 0.5802 | 20892928.0 |
| 2004-07-15 12:00:00 | AAPL | Stock | 0.5802 | 0.5832 | 0.58 | 0.5829 | 15235304.0 |
| 2004-07-15 12:05:00 | AAPL | Stock | 0.5829 | 0.5848 | 0.5804 | 0.5846 | 20093304.0 |
> showing 50 of 173,087 rows — these rows as CSV