PREVIEW / stock_5min / 2005-03-02
file: by_date/stock_5min/2005/2005-03-02.parquet size: 2.7 MB rows: 194,702 symbols: 1,947
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-02 08:00:00 | AAPL | Stock | 1.5786 | 1.5786 | 1.5743 | 1.5743 | 48020.0 |
| 2005-03-02 08:05:00 | AAPL | Stock | 1.5779 | 1.5804 | 1.5768 | 1.5786 | 85400.0 |
| 2005-03-02 08:15:00 | AAPL | Stock | 1.5768 | 1.5771 | 1.5768 | 1.5771 | 36400.0 |
| 2005-03-02 08:20:00 | AAPL | Stock | 1.5804 | 1.5821 | 1.5771 | 1.58 | 275800.0 |
| 2005-03-02 08:25:00 | AAPL | Stock | 1.5793 | 1.58 | 1.5786 | 1.5786 | 46200.0 |
| 2005-03-02 08:30:00 | AAPL | Stock | 1.5796 | 1.5846 | 1.5793 | 1.58 | 127400.0 |
| 2005-03-02 08:35:00 | AAPL | Stock | 1.5807 | 1.5807 | 1.5807 | 1.5807 | 2800.0 |
| 2005-03-02 08:40:00 | AAPL | Stock | 1.5793 | 1.5793 | 1.5786 | 1.5786 | 7000.0 |
| 2005-03-02 08:45:00 | AAPL | Stock | 1.5793 | 1.5804 | 1.5793 | 1.5793 | 37800.0 |
| 2005-03-02 08:50:00 | AAPL | Stock | 1.5818 | 1.5818 | 1.5818 | 1.5818 | 56000.0 |
| 2005-03-02 08:55:00 | AAPL | Stock | 1.5818 | 1.5818 | 1.5818 | 1.5818 | 21000.0 |
| 2005-03-02 09:00:00 | AAPL | Stock | 1.5818 | 1.5818 | 1.5804 | 1.5804 | 26572.0 |
| 2005-03-02 09:05:00 | AAPL | Stock | 1.5807 | 1.5807 | 1.5786 | 1.5807 | 142800.0 |
| 2005-03-02 09:10:00 | AAPL | Stock | 1.5793 | 1.5804 | 1.5786 | 1.5796 | 85820.0 |
| 2005-03-02 09:15:00 | AAPL | Stock | 1.58 | 1.58 | 1.5786 | 1.5796 | 58800.0 |
| 2005-03-02 09:20:00 | AAPL | Stock | 1.5804 | 1.5804 | 1.5804 | 1.5804 | 16800.0 |
| 2005-03-02 09:25:00 | AAPL | Stock | 1.5804 | 1.5821 | 1.5782 | 1.5804 | 322812.0 |
| 2005-03-02 09:30:00 | AAPL | Stock | 1.5804 | 1.585 | 1.5743 | 1.5807 | 13534892.0 |
| 2005-03-02 09:35:00 | AAPL | Stock | 1.5807 | 1.5875 | 1.5782 | 1.5857 | 11919740.0 |
| 2005-03-02 09:40:00 | AAPL | Stock | 1.5861 | 1.5871 | 1.5811 | 1.5836 | 7730716.0 |
| 2005-03-02 09:45:00 | AAPL | Stock | 1.5839 | 1.5918 | 1.5818 | 1.5893 | 9492644.0 |
| 2005-03-02 09:50:00 | AAPL | Stock | 1.5893 | 1.5896 | 1.5807 | 1.5807 | 7178612.0 |
| 2005-03-02 09:55:00 | AAPL | Stock | 1.5807 | 1.585 | 1.5804 | 1.5825 | 6791260.0 |
| 2005-03-02 10:00:00 | AAPL | Stock | 1.5825 | 1.5846 | 1.5814 | 1.5825 | 11404316.0 |
| 2005-03-02 10:05:00 | AAPL | Stock | 1.5825 | 1.5832 | 1.5782 | 1.5793 | 7954436.0 |
| 2005-03-02 10:10:00 | AAPL | Stock | 1.58 | 1.5821 | 1.579 | 1.5814 | 5585888.0 |
| 2005-03-02 10:15:00 | AAPL | Stock | 1.5814 | 1.5825 | 1.5789 | 1.5807 | 2571996.0 |
| 2005-03-02 10:20:00 | AAPL | Stock | 1.5807 | 1.5839 | 1.5764 | 1.5789 | 7409668.0 |
| 2005-03-02 10:25:00 | AAPL | Stock | 1.5793 | 1.5818 | 1.5768 | 1.5808 | 7160188.0 |
| 2005-03-02 10:30:00 | AAPL | Stock | 1.5814 | 1.5836 | 1.5793 | 1.5796 | 5369140.0 |
| 2005-03-02 10:35:00 | AAPL | Stock | 1.5793 | 1.5825 | 1.5779 | 1.5807 | 3473988.0 |
| 2005-03-02 10:40:00 | AAPL | Stock | 1.5811 | 1.5825 | 1.5796 | 1.5814 | 3864112.0 |
| 2005-03-02 10:45:00 | AAPL | Stock | 1.5811 | 1.5829 | 1.5804 | 1.5807 | 4711448.0 |
| 2005-03-02 10:50:00 | AAPL | Stock | 1.5804 | 1.5829 | 1.5804 | 1.5825 | 3762052.0 |
| 2005-03-02 10:55:00 | AAPL | Stock | 1.5829 | 1.5893 | 1.5804 | 1.5886 | 10177720.0 |
| 2005-03-02 11:00:00 | AAPL | Stock | 1.5889 | 1.5929 | 1.5864 | 1.5929 | 9316608.0 |
| 2005-03-02 11:05:00 | AAPL | Stock | 1.5929 | 1.5943 | 1.5893 | 1.5914 | 6879852.0 |
| 2005-03-02 11:10:00 | AAPL | Stock | 1.5914 | 1.5961 | 1.5911 | 1.5961 | 8973748.0 |
| 2005-03-02 11:15:00 | AAPL | Stock | 1.5961 | 1.6032 | 1.5954 | 1.6 | 13752676.0 |
| 2005-03-02 11:20:00 | AAPL | Stock | 1.5996 | 1.6004 | 1.5929 | 1.5954 | 9838864.0 |
| 2005-03-02 11:25:00 | AAPL | Stock | 1.5954 | 1.5989 | 1.595 | 1.5986 | 4385080.0 |
| 2005-03-02 11:30:00 | AAPL | Stock | 1.5986 | 1.6011 | 1.5964 | 1.5968 | 7428596.0 |
| 2005-03-02 11:35:00 | AAPL | Stock | 1.5975 | 1.5995 | 1.5954 | 1.5954 | 5030200.0 |
| 2005-03-02 11:40:00 | AAPL | Stock | 1.595 | 1.5975 | 1.5946 | 1.5957 | 2983932.0 |
| 2005-03-02 11:45:00 | AAPL | Stock | 1.5961 | 1.5975 | 1.5946 | 1.5954 | 3690708.0 |
| 2005-03-02 11:50:00 | AAPL | Stock | 1.5957 | 1.5961 | 1.5929 | 1.5932 | 2654316.0 |
| 2005-03-02 11:55:00 | AAPL | Stock | 1.5929 | 1.5936 | 1.5893 | 1.591 | 3763536.0 |
| 2005-03-02 12:00:00 | AAPL | Stock | 1.5909 | 1.5932 | 1.5907 | 1.5921 | 2925664.0 |
| 2005-03-02 12:05:00 | AAPL | Stock | 1.5918 | 1.5982 | 1.5914 | 1.5964 | 5781748.0 |
| 2005-03-02 12:10:00 | AAPL | Stock | 1.5964 | 1.5979 | 1.5932 | 1.5936 | 3557736.0 |
> showing 50 of 194,702 rows — these rows as CSV