PREVIEW / stock_30min / 2004-06-28
file: by_date/stock_30min/2004/2004-06-28.parquet size: 791 KB rows: 41,762 symbols: 1,783
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-28 08:00:00 | AAPL | Stock | 0.6071 | 0.6127 | 0.6071 | 0.6107 | 1640240.0 |
| 2004-06-28 08:30:00 | AAPL | Stock | 0.6114 | 0.6114 | 0.6071 | 0.608 | 872480.0 |
| 2004-06-28 09:00:00 | AAPL | Stock | 0.608 | 0.6098 | 0.5989 | 0.607 | 4120760.0 |
| 2004-06-28 09:30:00 | AAPL | Stock | 0.6054 | 0.6105 | 0.5902 | 0.5925 | 68277888.0 |
| 2004-06-28 10:00:00 | AAPL | Stock | 0.5923 | 0.5979 | 0.592 | 0.5941 | 30239384.0 |
| 2004-06-28 10:30:00 | AAPL | Stock | 0.5943 | 0.5954 | 0.5871 | 0.5879 | 47438272.0 |
| 2004-06-28 11:00:00 | AAPL | Stock | 0.5879 | 0.588 | 0.5836 | 0.5866 | 59170216.0 |
| 2004-06-28 11:30:00 | AAPL | Stock | 0.5866 | 0.5884 | 0.5841 | 0.5863 | 31807776.0 |
| 2004-06-28 12:00:00 | AAPL | Stock | 0.5863 | 0.5884 | 0.5846 | 0.5854 | 24580584.0 |
| 2004-06-28 12:30:00 | AAPL | Stock | 0.5854 | 0.5866 | 0.5839 | 0.585 | 14840504.0 |
| 2004-06-28 13:00:00 | AAPL | Stock | 0.5852 | 0.5893 | 0.585 | 0.5875 | 29192296.0 |
| 2004-06-28 13:30:00 | AAPL | Stock | 0.5875 | 0.5884 | 0.5848 | 0.5865 | 14511056.0 |
| 2004-06-28 14:00:00 | AAPL | Stock | 0.5868 | 0.5875 | 0.5839 | 0.5843 | 32734128.0 |
| 2004-06-28 14:30:00 | AAPL | Stock | 0.5843 | 0.5857 | 0.5816 | 0.5829 | 30075136.0 |
| 2004-06-28 15:00:00 | AAPL | Stock | 0.5827 | 0.583 | 0.5766 | 0.5795 | 56127904.0 |
| 2004-06-28 15:30:00 | AAPL | Stock | 0.5793 | 0.5814 | 0.5752 | 0.5795 | 48186712.0 |
| 2004-06-28 16:00:00 | AAPL | Stock | 0.5795 | 0.5813 | 0.5789 | 0.5813 | 5065480.0 |
| 2004-06-28 16:30:00 | AAPL | Stock | 0.5789 | 0.5802 | 0.5784 | 0.5786 | 1075200.0 |
| 2004-06-28 17:00:00 | AAPL | Stock | 0.5872 | 0.5872 | 0.5872 | 0.5872 | 181664.0 |
| 2004-06-28 08:00:00 | MSFT | Stock | 28.74 | 28.84 | 28.69 | 28.81 | 37720.0 |
| 2004-06-28 08:30:00 | MSFT | Stock | 28.83 | 28.84 | 28.57 | 28.58 | 70226.0 |
| 2004-06-28 09:00:00 | MSFT | Stock | 28.68 | 28.84 | 28.6 | 28.64 | 290813.0 |
| 2004-06-28 09:30:00 | MSFT | Stock | 28.6 | 28.75 | 28.59 | 28.67 | 9543906.0 |
| 2004-06-28 10:00:00 | MSFT | Stock | 28.67 | 28.7 | 28.62 | 28.67 | 5466603.0 |
| 2004-06-28 10:30:00 | MSFT | Stock | 28.67 | 28.7 | 28.63 | 28.66 | 4413649.0 |
| 2004-06-28 11:00:00 | MSFT | Stock | 28.66 | 28.69 | 28.63 | 28.64 | 3232204.0 |
| 2004-06-28 11:30:00 | MSFT | Stock | 28.641 | 28.66 | 28.59 | 28.64 | 3486213.0 |
| 2004-06-28 12:00:00 | MSFT | Stock | 28.64 | 28.67 | 28.6 | 28.61 | 3820654.0 |
| 2004-06-28 12:30:00 | MSFT | Stock | 28.611 | 28.62 | 28.55 | 28.55 | 3106333.0 |
| 2004-06-28 13:00:00 | MSFT | Stock | 28.55 | 28.61 | 28.48 | 28.52 | 3732569.0 |
| 2004-06-28 13:30:00 | MSFT | Stock | 28.52 | 28.55 | 28.44 | 28.467 | 3103129.0 |
| 2004-06-28 14:00:00 | MSFT | Stock | 28.469 | 28.48 | 28.23 | 28.31 | 7994357.0 |
| 2004-06-28 14:30:00 | MSFT | Stock | 28.3 | 28.42 | 28.23 | 28.27 | 8248452.0 |
| 2004-06-28 15:00:00 | MSFT | Stock | 28.27 | 28.33 | 28.21 | 28.24 | 7006396.0 |
| 2004-06-28 15:30:00 | MSFT | Stock | 28.24 | 28.31 | 28.17 | 28.26 | 8448086.0 |
| 2004-06-28 16:00:00 | MSFT | Stock | 28.28 | 28.32 | 28.24 | 28.24 | 2857054.0 |
| 2004-06-28 16:30:00 | MSFT | Stock | 28.28 | 28.28 | 28.22 | 28.23 | 534680.0 |
| 2004-06-28 17:00:00 | MSFT | Stock | 28.19 | 28.5593 | 28.19 | 28.4782 | 54391.0 |
| 2004-06-28 17:30:00 | MSFT | Stock | 28.21 | 28.28 | 28.21 | 28.28 | 36870.0 |
| 2004-06-28 18:00:00 | MSFT | Stock | 28.23 | 28.24 | 28.23 | 28.24 | 3880.0 |
| 2004-06-28 08:30:00 | NVDA | Stock | 0.17 | 0.1739 | 0.17 | 0.1739 | 120000.0 |
| 2004-06-28 09:00:00 | NVDA | Stock | 0.1709 | 0.1712 | 0.1703 | 0.1712 | 1932000.0 |
| 2004-06-28 09:30:00 | NVDA | Stock | 0.1712 | 0.1717 | 0.1697 | 0.1704 | 49333440.0 |
| 2004-06-28 10:00:00 | NVDA | Stock | 0.1704 | 0.1709 | 0.1694 | 0.1694 | 25280160.0 |
| 2004-06-28 10:30:00 | NVDA | Stock | 0.1697 | 0.1706 | 0.1694 | 0.1703 | 13884480.0 |
| 2004-06-28 11:00:00 | NVDA | Stock | 0.1704 | 0.1707 | 0.1693 | 0.1696 | 15348360.0 |
| 2004-06-28 11:30:00 | NVDA | Stock | 0.1695 | 0.1702 | 0.1688 | 0.1699 | 12258960.0 |
| 2004-06-28 12:00:00 | NVDA | Stock | 0.1699 | 0.1704 | 0.1697 | 0.1703 | 6952080.0 |
| 2004-06-28 12:30:00 | NVDA | Stock | 0.1703 | 0.1703 | 0.1696 | 0.1699 | 5650200.0 |
| 2004-06-28 13:00:00 | NVDA | Stock | 0.1698 | 0.1698 | 0.1692 | 0.1693 | 9586200.0 |
> showing 50 of 41,762 rows — these rows as CSV