PREVIEW / stock_5min / 2005-02-24
file: by_date/stock_5min/2005/2005-02-24.parquet size: 2.7 MB rows: 191,376 symbols: 1,937
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-02-24 08:00:00 | AAPL | Stock | 1.5771 | 1.582 | 1.5768 | 1.5795 | 289240.0 |
| 2005-02-24 08:05:00 | AAPL | Stock | 1.5793 | 1.5793 | 1.5709 | 1.5732 | 1188936.0 |
| 2005-02-24 08:10:00 | AAPL | Stock | 1.5714 | 1.5732 | 1.5666 | 1.5695 | 801472.0 |
| 2005-02-24 08:15:00 | AAPL | Stock | 1.5696 | 1.5713 | 1.5688 | 1.5696 | 421624.0 |
| 2005-02-24 08:20:00 | AAPL | Stock | 1.5698 | 1.5748 | 1.5696 | 1.5732 | 704424.0 |
| 2005-02-24 08:25:00 | AAPL | Stock | 1.5732 | 1.5757 | 1.5732 | 1.5757 | 135576.0 |
| 2005-02-24 08:30:00 | AAPL | Stock | 1.5757 | 1.5759 | 1.5714 | 1.5727 | 1800400.0 |
| 2005-02-24 08:35:00 | AAPL | Stock | 1.5727 | 1.5739 | 1.5714 | 1.5739 | 106400.0 |
| 2005-02-24 08:40:00 | AAPL | Stock | 1.5734 | 1.5734 | 1.5679 | 1.5696 | 823480.0 |
| 2005-02-24 08:45:00 | AAPL | Stock | 1.5696 | 1.5714 | 1.5689 | 1.5693 | 1459920.0 |
| 2005-02-24 08:50:00 | AAPL | Stock | 1.5696 | 1.57 | 1.5661 | 1.5661 | 865200.0 |
| 2005-02-24 08:55:00 | AAPL | Stock | 1.5668 | 1.568 | 1.5643 | 1.5671 | 885136.0 |
| 2005-02-24 09:00:00 | AAPL | Stock | 1.5661 | 1.5675 | 1.5654 | 1.5675 | 401296.0 |
| 2005-02-24 09:05:00 | AAPL | Stock | 1.567 | 1.567 | 1.5652 | 1.5659 | 596792.0 |
| 2005-02-24 09:10:00 | AAPL | Stock | 1.5652 | 1.5661 | 1.5646 | 1.5661 | 380800.0 |
| 2005-02-24 09:15:00 | AAPL | Stock | 1.5661 | 1.5688 | 1.5659 | 1.5677 | 553448.0 |
| 2005-02-24 09:20:00 | AAPL | Stock | 1.5679 | 1.5734 | 1.5661 | 1.5714 | 812392.0 |
| 2005-02-24 09:25:00 | AAPL | Stock | 1.5732 | 1.5823 | 1.5702 | 1.5802 | 2641352.0 |
| 2005-02-24 09:30:00 | AAPL | Stock | 1.58 | 1.588 | 1.5693 | 1.5723 | 53258968.0 |
| 2005-02-24 09:35:00 | AAPL | Stock | 1.5721 | 1.5841 | 1.5695 | 1.5825 | 45662736.0 |
| 2005-02-24 09:40:00 | AAPL | Stock | 1.5827 | 1.5918 | 1.5739 | 1.5855 | 42602728.0 |
| 2005-02-24 09:45:00 | AAPL | Stock | 1.5855 | 1.5855 | 1.5768 | 1.5802 | 28897008.0 |
| 2005-02-24 09:50:00 | AAPL | Stock | 1.58 | 1.5807 | 1.5666 | 1.5705 | 36880088.0 |
| 2005-02-24 09:55:00 | AAPL | Stock | 1.5698 | 1.5784 | 1.5698 | 1.5757 | 25231416.0 |
| 2005-02-24 10:00:00 | AAPL | Stock | 1.5757 | 1.5784 | 1.5711 | 1.5775 | 20895000.0 |
| 2005-02-24 10:05:00 | AAPL | Stock | 1.5777 | 1.5834 | 1.5732 | 1.5818 | 27452376.0 |
| 2005-02-24 10:10:00 | AAPL | Stock | 1.5818 | 1.5868 | 1.5793 | 1.585 | 25010720.0 |
| 2005-02-24 10:15:00 | AAPL | Stock | 1.585 | 1.5873 | 1.5822 | 1.5846 | 24018232.0 |
| 2005-02-24 10:20:00 | AAPL | Stock | 1.5848 | 1.5911 | 1.5816 | 1.5875 | 27501096.0 |
| 2005-02-24 10:25:00 | AAPL | Stock | 1.5871 | 1.5907 | 1.5857 | 1.5871 | 22202992.0 |
| 2005-02-24 10:30:00 | AAPL | Stock | 1.587 | 1.5939 | 1.5864 | 1.5925 | 43106336.0 |
| 2005-02-24 10:35:00 | AAPL | Stock | 1.5927 | 1.5946 | 1.5895 | 1.5904 | 25675384.0 |
| 2005-02-24 10:40:00 | AAPL | Stock | 1.5898 | 1.5948 | 1.5879 | 1.5925 | 21959112.0 |
| 2005-02-24 10:45:00 | AAPL | Stock | 1.5925 | 1.5936 | 1.5877 | 1.5902 | 17281600.0 |
| 2005-02-24 10:50:00 | AAPL | Stock | 1.5902 | 1.5923 | 1.5845 | 1.5857 | 15207416.0 |
| 2005-02-24 10:55:00 | AAPL | Stock | 1.5857 | 1.5929 | 1.5809 | 1.5821 | 19592776.0 |
| 2005-02-24 11:00:00 | AAPL | Stock | 1.5821 | 1.5864 | 1.5789 | 1.5863 | 19284776.0 |
| 2005-02-24 11:05:00 | AAPL | Stock | 1.5863 | 1.587 | 1.5821 | 1.5854 | 9629200.0 |
| 2005-02-24 11:10:00 | AAPL | Stock | 1.5854 | 1.587 | 1.5839 | 1.5848 | 8466920.0 |
| 2005-02-24 11:15:00 | AAPL | Stock | 1.5848 | 1.5911 | 1.5846 | 1.5893 | 14089152.0 |
| 2005-02-24 11:20:00 | AAPL | Stock | 1.5893 | 1.5938 | 1.5888 | 1.5898 | 14407176.0 |
| 2005-02-24 11:25:00 | AAPL | Stock | 1.5893 | 1.5911 | 1.5871 | 1.5873 | 7851760.0 |
| 2005-02-24 11:30:00 | AAPL | Stock | 1.5873 | 1.5889 | 1.5861 | 1.5884 | 7743624.0 |
| 2005-02-24 11:35:00 | AAPL | Stock | 1.5882 | 1.5893 | 1.587 | 1.5879 | 6576192.0 |
| 2005-02-24 11:40:00 | AAPL | Stock | 1.5884 | 1.5891 | 1.5877 | 1.5891 | 2504152.0 |
| 2005-02-24 11:45:00 | AAPL | Stock | 1.5893 | 1.5914 | 1.5886 | 1.5893 | 9535960.0 |
| 2005-02-24 11:50:00 | AAPL | Stock | 1.5893 | 1.5895 | 1.5864 | 1.587 | 8365448.0 |
| 2005-02-24 11:55:00 | AAPL | Stock | 1.587 | 1.5873 | 1.5839 | 1.5863 | 9069984.0 |
| 2005-02-24 12:00:00 | AAPL | Stock | 1.5859 | 1.5859 | 1.5804 | 1.582 | 14618184.0 |
| 2005-02-24 12:05:00 | AAPL | Stock | 1.582 | 1.5845 | 1.5798 | 1.5834 | 10314248.0 |
> showing 50 of 191,376 rows — these rows as CSV