PREVIEW / stock_30min / 2004-06-18
file: by_date/stock_30min/2004/2004-06-18.parquet size: 788 KB rows: 42,538 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-18 08:00:00 | AAPL | Stock | 0.5839 | 0.5839 | 0.5839 | 0.5839 | 95200.0 |
| 2004-06-18 08:30:00 | AAPL | Stock | 0.5813 | 0.5821 | 0.5813 | 0.5821 | 336000.0 |
| 2004-06-18 09:00:00 | AAPL | Stock | 0.5839 | 0.5856 | 0.5809 | 0.5821 | 1161440.0 |
| 2004-06-18 09:30:00 | AAPL | Stock | 0.5818 | 0.5839 | 0.5791 | 0.5805 | 35878864.0 |
| 2004-06-18 10:00:00 | AAPL | Stock | 0.5807 | 0.5888 | 0.5805 | 0.587 | 30661400.0 |
| 2004-06-18 10:30:00 | AAPL | Stock | 0.587 | 0.5904 | 0.587 | 0.5882 | 22833440.0 |
| 2004-06-18 11:00:00 | AAPL | Stock | 0.588 | 0.5911 | 0.5879 | 0.5889 | 22237264.0 |
| 2004-06-18 11:30:00 | AAPL | Stock | 0.5889 | 0.5913 | 0.5886 | 0.5886 | 24443328.0 |
| 2004-06-18 12:00:00 | AAPL | Stock | 0.5888 | 0.5896 | 0.5884 | 0.5893 | 14317408.0 |
| 2004-06-18 12:30:00 | AAPL | Stock | 0.5891 | 0.5896 | 0.5886 | 0.5886 | 15149792.0 |
| 2004-06-18 13:00:00 | AAPL | Stock | 0.5886 | 0.5911 | 0.5875 | 0.5907 | 14899920.0 |
| 2004-06-18 13:30:00 | AAPL | Stock | 0.5909 | 0.5938 | 0.5902 | 0.5911 | 20288072.0 |
| 2004-06-18 14:00:00 | AAPL | Stock | 0.5913 | 0.5952 | 0.5911 | 0.5952 | 16583112.0 |
| 2004-06-18 14:30:00 | AAPL | Stock | 0.5952 | 0.5966 | 0.5871 | 0.5886 | 23110808.0 |
| 2004-06-18 15:00:00 | AAPL | Stock | 0.5886 | 0.5898 | 0.5879 | 0.5882 | 28581112.0 |
| 2004-06-18 15:30:00 | AAPL | Stock | 0.588 | 0.5895 | 0.5859 | 0.5879 | 52542728.0 |
| 2004-06-18 16:00:00 | AAPL | Stock | 0.5879 | 0.5893 | 0.5875 | 0.5877 | 29118376.0 |
| 2004-06-18 16:30:00 | AAPL | Stock | 0.5875 | 0.5893 | 0.5873 | 0.5877 | 7290696.0 |
| 2004-06-18 17:00:00 | AAPL | Stock | 0.5875 | 0.5879 | 0.5875 | 0.5875 | 1946336.0 |
| 2004-06-18 17:30:00 | AAPL | Stock | 0.5902 | 0.5902 | 0.5875 | 0.5875 | 1909992.0 |
| 2004-06-18 18:00:00 | AAPL | Stock | 0.5877 | 0.592 | 0.5877 | 0.592 | 128128.0 |
| 2004-06-18 08:00:00 | MSFT | Stock | 27.83 | 27.84 | 27.73 | 27.76 | 16920.0 |
| 2004-06-18 08:30:00 | MSFT | Stock | 27.76 | 27.8 | 27.72 | 27.73 | 44860.0 |
| 2004-06-18 09:00:00 | MSFT | Stock | 27.74 | 27.77 | 27.7 | 27.7 | 654669.0 |
| 2004-06-18 09:30:00 | MSFT | Stock | 27.74 | 27.98 | 27.7 | 27.89 | 15989636.0 |
| 2004-06-18 10:00:00 | MSFT | Stock | 27.9 | 28.01 | 27.86 | 28.0 | 9997161.0 |
| 2004-06-18 10:30:00 | MSFT | Stock | 28.0 | 28.06 | 27.91 | 27.97 | 8797294.0 |
| 2004-06-18 11:00:00 | MSFT | Stock | 27.96 | 28.03 | 27.95 | 27.989 | 7581696.0 |
| 2004-06-18 11:30:00 | MSFT | Stock | 27.99 | 28.0 | 27.94 | 27.98 | 4745699.0 |
| 2004-06-18 12:00:00 | MSFT | Stock | 27.98 | 28.04 | 27.95 | 28.0216 | 4250886.0 |
| 2004-06-18 12:30:00 | MSFT | Stock | 28.03 | 28.07 | 28.0 | 28.06 | 6015756.0 |
| 2004-06-18 13:00:00 | MSFT | Stock | 28.06 | 28.1 | 28.03 | 28.059 | 4328447.0 |
| 2004-06-18 13:30:00 | MSFT | Stock | 28.0581 | 28.11 | 28.01 | 28.09 | 5266455.0 |
| 2004-06-18 14:00:00 | MSFT | Stock | 28.1 | 28.22 | 28.06 | 28.21 | 6913102.0 |
| 2004-06-18 14:30:00 | MSFT | Stock | 28.219 | 28.39 | 28.19 | 28.31 | 16286569.0 |
| 2004-06-18 15:00:00 | MSFT | Stock | 28.31 | 28.4 | 28.26 | 28.38 | 12196895.0 |
| 2004-06-18 15:30:00 | MSFT | Stock | 28.39 | 28.5 | 28.21 | 28.24 | 18219179.0 |
| 2004-06-18 16:00:00 | MSFT | Stock | 28.23 | 28.4 | 28.0871 | 28.3 | 3097959.0 |
| 2004-06-18 16:30:00 | MSFT | Stock | 28.29 | 28.36 | 28.27 | 28.35 | 868467.0 |
| 2004-06-18 17:00:00 | MSFT | Stock | 28.3 | 28.36 | 28.3 | 28.36 | 209054.0 |
| 2004-06-18 17:30:00 | MSFT | Stock | 28.3 | 28.36 | 28.29 | 28.3 | 69518.0 |
| 2004-06-18 18:00:00 | MSFT | Stock | 28.28 | 28.35 | 28.27 | 28.3 | 2932.0 |
| 2004-06-18 08:00:00 | NVDA | Stock | 0.1644 | 0.1644 | 0.1639 | 0.1643 | 1607040.0 |
| 2004-06-18 08:30:00 | NVDA | Stock | 0.1646 | 0.1648 | 0.1646 | 0.1648 | 341520.0 |
| 2004-06-18 09:00:00 | NVDA | Stock | 0.1653 | 0.1656 | 0.1646 | 0.1651 | 1909200.0 |
| 2004-06-18 09:30:00 | NVDA | Stock | 0.1651 | 0.1662 | 0.1625 | 0.1657 | 83874960.0 |
| 2004-06-18 10:00:00 | NVDA | Stock | 0.1657 | 0.1686 | 0.1657 | 0.1683 | 63958680.0 |
| 2004-06-18 10:30:00 | NVDA | Stock | 0.1683 | 0.1692 | 0.1667 | 0.1672 | 54420480.0 |
| 2004-06-18 11:00:00 | NVDA | Stock | 0.1672 | 0.1675 | 0.1666 | 0.1667 | 17012040.0 |
| 2004-06-18 11:30:00 | NVDA | Stock | 0.1667 | 0.1668 | 0.1657 | 0.1662 | 17105640.0 |
> showing 50 of 42,538 rows — these rows as CSV