PREVIEW / stock_5min / 2004-06-21
file: by_date/stock_5min/2004/2004-06-21.parquet size: 2.4 MB rows: 177,405 symbols: 1,786
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-06-21 08:00:00 | AAPL | Stock | 0.5893 | 0.5893 | 0.5893 | 0.5893 | 5600.0 |
| 2004-06-21 08:35:00 | AAPL | Stock | 0.5911 | 0.5929 | 0.5911 | 0.5929 | 168000.0 |
| 2004-06-21 08:40:00 | AAPL | Stock | 0.5946 | 0.5964 | 0.593 | 0.5938 | 235200.0 |
| 2004-06-21 08:50:00 | AAPL | Stock | 0.592 | 0.592 | 0.592 | 0.592 | 33600.0 |
| 2004-06-21 08:55:00 | AAPL | Stock | 0.5879 | 0.5879 | 0.5879 | 0.5879 | 683200.0 |
| 2004-06-21 09:00:00 | AAPL | Stock | 0.592 | 0.592 | 0.5911 | 0.592 | 184800.0 |
| 2004-06-21 09:05:00 | AAPL | Stock | 0.5911 | 0.5911 | 0.5902 | 0.5902 | 22400.0 |
| 2004-06-21 09:15:00 | AAPL | Stock | 0.5871 | 0.5911 | 0.5871 | 0.5911 | 3791200.0 |
| 2004-06-21 09:25:00 | AAPL | Stock | 0.5873 | 0.5911 | 0.5873 | 0.5907 | 1120000.0 |
| 2004-06-21 09:30:00 | AAPL | Stock | 0.5914 | 0.5921 | 0.5863 | 0.5866 | 11136384.0 |
| 2004-06-21 09:35:00 | AAPL | Stock | 0.5866 | 0.5982 | 0.5866 | 0.5932 | 19657680.0 |
| 2004-06-21 09:40:00 | AAPL | Stock | 0.5929 | 0.5939 | 0.5907 | 0.5907 | 6657616.0 |
| 2004-06-21 09:45:00 | AAPL | Stock | 0.5905 | 0.5911 | 0.5852 | 0.5909 | 16333296.0 |
| 2004-06-21 09:50:00 | AAPL | Stock | 0.5909 | 0.5934 | 0.5888 | 0.5907 | 14902664.0 |
| 2004-06-21 09:55:00 | AAPL | Stock | 0.5911 | 0.5911 | 0.5884 | 0.5891 | 8412936.0 |
| 2004-06-21 10:00:00 | AAPL | Stock | 0.5891 | 0.5907 | 0.5888 | 0.5896 | 6753936.0 |
| 2004-06-21 10:05:00 | AAPL | Stock | 0.5895 | 0.5896 | 0.5875 | 0.5893 | 5435080.0 |
| 2004-06-21 10:10:00 | AAPL | Stock | 0.5896 | 0.5904 | 0.5891 | 0.5896 | 3564232.0 |
| 2004-06-21 10:15:00 | AAPL | Stock | 0.5896 | 0.59 | 0.5889 | 0.5898 | 4989152.0 |
| 2004-06-21 10:20:00 | AAPL | Stock | 0.5896 | 0.5898 | 0.5884 | 0.5889 | 2156672.0 |
| 2004-06-21 10:25:00 | AAPL | Stock | 0.5889 | 0.5898 | 0.5886 | 0.5888 | 3172568.0 |
| 2004-06-21 10:30:00 | AAPL | Stock | 0.5888 | 0.5889 | 0.5882 | 0.5884 | 4407984.0 |
| 2004-06-21 10:35:00 | AAPL | Stock | 0.5884 | 0.5893 | 0.5884 | 0.5891 | 3174640.0 |
| 2004-06-21 10:40:00 | AAPL | Stock | 0.5891 | 0.5893 | 0.5889 | 0.5891 | 1896160.0 |
| 2004-06-21 10:45:00 | AAPL | Stock | 0.5891 | 0.5893 | 0.5884 | 0.5893 | 2089976.0 |
| 2004-06-21 10:50:00 | AAPL | Stock | 0.5893 | 0.5902 | 0.5891 | 0.5896 | 7644896.0 |
| 2004-06-21 10:55:00 | AAPL | Stock | 0.5898 | 0.5902 | 0.5895 | 0.5898 | 727664.0 |
| 2004-06-21 11:00:00 | AAPL | Stock | 0.5898 | 0.59 | 0.5893 | 0.5896 | 1487584.0 |
| 2004-06-21 11:05:00 | AAPL | Stock | 0.5895 | 0.5896 | 0.5882 | 0.5884 | 4080944.0 |
| 2004-06-21 11:10:00 | AAPL | Stock | 0.5884 | 0.5888 | 0.5879 | 0.588 | 4870712.0 |
| 2004-06-21 11:15:00 | AAPL | Stock | 0.588 | 0.5889 | 0.5871 | 0.5889 | 3796296.0 |
| 2004-06-21 11:20:00 | AAPL | Stock | 0.5888 | 0.5891 | 0.5871 | 0.5875 | 2366392.0 |
| 2004-06-21 11:25:00 | AAPL | Stock | 0.5875 | 0.5882 | 0.5871 | 0.5879 | 2061472.0 |
| 2004-06-21 11:30:00 | AAPL | Stock | 0.5879 | 0.588 | 0.5866 | 0.5866 | 3417400.0 |
| 2004-06-21 11:35:00 | AAPL | Stock | 0.5866 | 0.5873 | 0.5866 | 0.587 | 2744840.0 |
| 2004-06-21 11:40:00 | AAPL | Stock | 0.5868 | 0.5868 | 0.5864 | 0.5868 | 2309104.0 |
| 2004-06-21 11:45:00 | AAPL | Stock | 0.5868 | 0.5871 | 0.5863 | 0.5871 | 2039128.0 |
| 2004-06-21 11:50:00 | AAPL | Stock | 0.587 | 0.5873 | 0.5859 | 0.5871 | 4629968.0 |
| 2004-06-21 11:55:00 | AAPL | Stock | 0.5873 | 0.5873 | 0.5866 | 0.5866 | 1790936.0 |
| 2004-06-21 12:00:00 | AAPL | Stock | 0.5866 | 0.5871 | 0.5864 | 0.587 | 3498208.0 |
| 2004-06-21 12:05:00 | AAPL | Stock | 0.5868 | 0.587 | 0.5866 | 0.5866 | 1998752.0 |
| 2004-06-21 12:10:00 | AAPL | Stock | 0.5868 | 0.5868 | 0.5866 | 0.5868 | 912016.0 |
| 2004-06-21 12:15:00 | AAPL | Stock | 0.5868 | 0.5871 | 0.5866 | 0.5871 | 774984.0 |
| 2004-06-21 12:20:00 | AAPL | Stock | 0.5871 | 0.5875 | 0.5868 | 0.5873 | 2617104.0 |
| 2004-06-21 12:25:00 | AAPL | Stock | 0.5873 | 0.5875 | 0.587 | 0.5871 | 1875720.0 |
| 2004-06-21 12:30:00 | AAPL | Stock | 0.587 | 0.5871 | 0.5864 | 0.5864 | 1425368.0 |
| 2004-06-21 12:35:00 | AAPL | Stock | 0.5866 | 0.5868 | 0.5866 | 0.5866 | 695408.0 |
| 2004-06-21 12:40:00 | AAPL | Stock | 0.5866 | 0.5868 | 0.5866 | 0.5868 | 282520.0 |
| 2004-06-21 12:45:00 | AAPL | Stock | 0.5868 | 0.5868 | 0.5861 | 0.5863 | 3399424.0 |
| 2004-06-21 12:50:00 | AAPL | Stock | 0.5863 | 0.5863 | 0.5857 | 0.5859 | 943208.0 |
> showing 50 of 177,405 rows — these rows as CSV