PREVIEW / stock_30min / 2004-11-19
file: by_date/stock_30min/2004/2004-11-19.parquet size: 792 KB rows: 42,658 symbols: 1,877
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-11-19 08:00:00 | AAPL | Stock | 0.9905 | 0.9911 | 0.9905 | 0.9911 | 25200.0 |
| 2004-11-19 08:30:00 | AAPL | Stock | 0.9893 | 0.9893 | 0.9893 | 0.9893 | 123200.0 |
| 2004-11-19 09:00:00 | AAPL | Stock | 0.9911 | 0.9936 | 0.9884 | 0.9884 | 2902368.0 |
| 2004-11-19 09:30:00 | AAPL | Stock | 0.9909 | 0.9929 | 0.9827 | 0.9927 | 69536152.0 |
| 2004-11-19 10:00:00 | AAPL | Stock | 0.9925 | 1.0163 | 0.9902 | 0.9948 | 205689904.0 |
| 2004-11-19 10:30:00 | AAPL | Stock | 0.9946 | 0.9948 | 0.9732 | 0.9821 | 123030992.0 |
| 2004-11-19 11:00:00 | AAPL | Stock | 0.9814 | 0.9959 | 0.9813 | 0.9916 | 63469224.0 |
| 2004-11-19 11:30:00 | AAPL | Stock | 0.9918 | 0.9954 | 0.9891 | 0.9921 | 23386216.0 |
| 2004-11-19 12:00:00 | AAPL | Stock | 0.9921 | 0.9923 | 0.9821 | 0.9829 | 22380624.0 |
| 2004-11-19 12:30:00 | AAPL | Stock | 0.9825 | 0.9855 | 0.9818 | 0.9839 | 19064360.0 |
| 2004-11-19 13:00:00 | AAPL | Stock | 0.9839 | 0.9914 | 0.9839 | 0.9886 | 15872416.0 |
| 2004-11-19 13:30:00 | AAPL | Stock | 0.9888 | 0.995 | 0.987 | 0.9905 | 14887264.0 |
| 2004-11-19 14:00:00 | AAPL | Stock | 0.9905 | 0.9905 | 0.9852 | 0.9873 | 19602128.0 |
| 2004-11-19 14:30:00 | AAPL | Stock | 0.9871 | 0.9907 | 0.9843 | 0.9873 | 22864296.0 |
| 2004-11-19 15:00:00 | AAPL | Stock | 0.9875 | 0.9895 | 0.9866 | 0.9879 | 25008648.0 |
| 2004-11-19 15:30:00 | AAPL | Stock | 0.9879 | 0.9882 | 0.9813 | 0.9857 | 93738232.0 |
| 2004-11-19 16:00:00 | AAPL | Stock | 0.9854 | 0.9866 | 0.9825 | 0.9827 | 16497376.0 |
| 2004-11-19 16:30:00 | AAPL | Stock | 0.983 | 0.983 | 0.9827 | 0.9827 | 1400000.0 |
| 2004-11-19 17:00:00 | AAPL | Stock | 0.9848 | 0.9848 | 0.9827 | 0.9835 | 164640.0 |
| 2004-11-19 17:30:00 | AAPL | Stock | 0.9835 | 0.9835 | 0.9835 | 0.9835 | 5600.0 |
| 2004-11-19 18:00:00 | AAPL | Stock | 0.9829 | 0.9829 | 0.9816 | 0.9816 | 350336.0 |
| 2004-11-19 08:00:00 | MSFT | Stock | 27.04 | 27.04 | 27.01 | 27.04 | 8664.0 |
| 2004-11-19 08:30:00 | MSFT | Stock | 27.04 | 27.05 | 27.0 | 27.0 | 10151.0 |
| 2004-11-19 09:00:00 | MSFT | Stock | 27.0 | 27.05 | 27.0 | 27.05 | 248873.0 |
| 2004-11-19 09:30:00 | MSFT | Stock | 27.04 | 27.07 | 26.97 | 26.99 | 10141374.0 |
| 2004-11-19 10:00:00 | MSFT | Stock | 26.99 | 27.0 | 26.9 | 26.92 | 12224462.0 |
| 2004-11-19 10:30:00 | MSFT | Stock | 26.929 | 26.95 | 26.9 | 26.95 | 7064731.0 |
| 2004-11-19 11:00:00 | MSFT | Stock | 26.94 | 26.9502 | 26.86 | 26.9 | 5902825.0 |
| 2004-11-19 11:30:00 | MSFT | Stock | 26.9 | 26.99 | 26.88 | 26.97 | 3824768.0 |
| 2004-11-19 12:00:00 | MSFT | Stock | 26.97 | 26.99 | 26.91 | 26.939 | 4794761.0 |
| 2004-11-19 12:30:00 | MSFT | Stock | 26.94 | 26.99 | 26.93 | 26.94 | 3206106.0 |
| 2004-11-19 13:00:00 | MSFT | Stock | 26.94 | 27.0 | 26.93 | 26.93 | 3292399.0 |
| 2004-11-19 13:30:00 | MSFT | Stock | 26.93 | 26.96 | 26.91 | 26.92 | 2902307.0 |
| 2004-11-19 14:00:00 | MSFT | Stock | 26.92 | 26.94 | 26.88 | 26.91 | 4849208.0 |
| 2004-11-19 14:30:00 | MSFT | Stock | 26.91 | 26.97 | 26.909 | 26.95 | 6479040.0 |
| 2004-11-19 15:00:00 | MSFT | Stock | 26.95 | 26.98 | 26.9199 | 26.92 | 4285214.0 |
| 2004-11-19 15:30:00 | MSFT | Stock | 26.92 | 26.961 | 26.84 | 26.85 | 12097819.0 |
| 2004-11-19 16:00:00 | MSFT | Stock | 26.85 | 26.93 | 26.84 | 26.89 | 2418749.0 |
| 2004-11-19 16:30:00 | MSFT | Stock | 26.9 | 26.9 | 26.85 | 26.89 | 17873.0 |
| 2004-11-19 17:00:00 | MSFT | Stock | 26.89 | 26.9 | 26.83 | 26.8848 | 32413.0 |
| 2004-11-19 17:30:00 | MSFT | Stock | 26.9022 | 26.9022 | 26.83 | 26.85 | 42828.0 |
| 2004-11-19 18:00:00 | MSFT | Stock | 26.87 | 26.87 | 26.86 | 26.86 | 2900.0 |
| 2004-11-19 08:30:00 | NVDA | Stock | 0.1607 | 0.1625 | 0.1572 | 0.1587 | 6178800.0 |
| 2004-11-19 09:00:00 | NVDA | Stock | 0.1587 | 0.1752 | 0.1587 | 0.1694 | 77009760.0 |
| 2004-11-19 09:30:00 | NVDA | Stock | 0.1692 | 0.1703 | 0.1647 | 0.1702 | 465999600.0 |
| 2004-11-19 10:00:00 | NVDA | Stock | 0.1702 | 0.1711 | 0.1672 | 0.1683 | 271359480.0 |
| 2004-11-19 10:30:00 | NVDA | Stock | 0.1683 | 0.169 | 0.1666 | 0.1667 | 141413160.0 |
| 2004-11-19 11:00:00 | NVDA | Stock | 0.1667 | 0.1668 | 0.1646 | 0.1658 | 151233120.0 |
| 2004-11-19 11:30:00 | NVDA | Stock | 0.1657 | 0.1658 | 0.1604 | 0.1621 | 146698080.0 |
| 2004-11-19 12:00:00 | NVDA | Stock | 0.1619 | 0.1619 | 0.1596 | 0.1608 | 126282840.0 |
> showing 50 of 42,658 rows — these rows as CSV