PREVIEW / stock_30min / 2004-06-23
file: by_date/stock_30min/2004/2004-06-23.parquet size: 770 KB rows: 40,980 symbols: 1,794
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-23 08:00:00 | AAPL | Stock | 0.5875 | 0.5893 | 0.5875 | 0.5893 | 151200.0 |
| 2004-06-23 08:30:00 | AAPL | Stock | 0.5893 | 0.5893 | 0.5893 | 0.5893 | 5600.0 |
| 2004-06-23 09:00:00 | AAPL | Stock | 0.5848 | 0.5898 | 0.5848 | 0.5893 | 578368.0 |
| 2004-06-23 09:30:00 | AAPL | Stock | 0.5893 | 0.5898 | 0.5873 | 0.5882 | 44838024.0 |
| 2004-06-23 10:00:00 | AAPL | Stock | 0.5884 | 0.5893 | 0.5877 | 0.5889 | 11339384.0 |
| 2004-06-23 10:30:00 | AAPL | Stock | 0.5888 | 0.5905 | 0.5882 | 0.5891 | 21531384.0 |
| 2004-06-23 11:00:00 | AAPL | Stock | 0.5889 | 0.5914 | 0.5889 | 0.5898 | 27871648.0 |
| 2004-06-23 11:30:00 | AAPL | Stock | 0.59 | 0.5911 | 0.5891 | 0.5902 | 46137224.0 |
| 2004-06-23 12:00:00 | AAPL | Stock | 0.59 | 0.5938 | 0.5896 | 0.5936 | 18280584.0 |
| 2004-06-23 12:30:00 | AAPL | Stock | 0.5938 | 0.5973 | 0.5938 | 0.5964 | 26495672.0 |
| 2004-06-23 13:00:00 | AAPL | Stock | 0.5964 | 0.598 | 0.5961 | 0.5977 | 19045936.0 |
| 2004-06-23 13:30:00 | AAPL | Stock | 0.5977 | 0.5996 | 0.5961 | 0.5993 | 21499128.0 |
| 2004-06-23 14:00:00 | AAPL | Stock | 0.5993 | 0.6009 | 0.5977 | 0.5984 | 27310136.0 |
| 2004-06-23 14:30:00 | AAPL | Stock | 0.5984 | 0.6 | 0.5968 | 0.5991 | 23519720.0 |
| 2004-06-23 15:00:00 | AAPL | Stock | 0.5991 | 0.602 | 0.5986 | 0.5989 | 36605184.0 |
| 2004-06-23 15:30:00 | AAPL | Stock | 0.5986 | 0.6041 | 0.5986 | 0.6009 | 53975936.0 |
| 2004-06-23 16:00:00 | AAPL | Stock | 0.6009 | 0.6021 | 0.5971 | 0.5984 | 3420144.0 |
| 2004-06-23 16:30:00 | AAPL | Stock | 0.6 | 0.6018 | 0.5979 | 0.6018 | 717752.0 |
| 2004-06-23 17:00:00 | AAPL | Stock | 0.6 | 0.6 | 0.598 | 0.5982 | 78400.0 |
| 2004-06-23 18:00:00 | AAPL | Stock | 0.598 | 0.598 | 0.5979 | 0.5979 | 53200.0 |
| 2004-06-23 08:00:00 | MSFT | Stock | 28.23 | 28.27 | 28.23 | 28.25 | 14900.0 |
| 2004-06-23 08:30:00 | MSFT | Stock | 28.25 | 28.25 | 28.23 | 28.25 | 12800.0 |
| 2004-06-23 09:00:00 | MSFT | Stock | 28.23 | 28.24 | 28.18 | 28.19 | 64570.0 |
| 2004-06-23 09:30:00 | MSFT | Stock | 28.18 | 28.28 | 28.12 | 28.2 | 6604767.0 |
| 2004-06-23 10:00:00 | MSFT | Stock | 28.201 | 28.27 | 28.17 | 28.191 | 4396080.0 |
| 2004-06-23 10:30:00 | MSFT | Stock | 28.19 | 28.21 | 28.06 | 28.09 | 4038568.0 |
| 2004-06-23 11:00:00 | MSFT | Stock | 28.09 | 28.15 | 28.0 | 28.05 | 5311420.0 |
| 2004-06-23 11:30:00 | MSFT | Stock | 28.05 | 28.14 | 28.04 | 28.11 | 3823544.0 |
| 2004-06-23 12:00:00 | MSFT | Stock | 28.11 | 28.2 | 28.1 | 28.15 | 3756907.0 |
| 2004-06-23 12:30:00 | MSFT | Stock | 28.16 | 28.22 | 28.14 | 28.19 | 2878421.0 |
| 2004-06-23 13:00:00 | MSFT | Stock | 28.19 | 28.21 | 28.15 | 28.15 | 1685049.0 |
| 2004-06-23 13:30:00 | MSFT | Stock | 28.15 | 28.17 | 28.09 | 28.111 | 2650782.0 |
| 2004-06-23 14:00:00 | MSFT | Stock | 28.12 | 28.21 | 28.07 | 28.18 | 3582148.0 |
| 2004-06-23 14:30:00 | MSFT | Stock | 28.18 | 28.22 | 28.11 | 28.198 | 3467768.0 |
| 2004-06-23 15:00:00 | MSFT | Stock | 28.2 | 28.3 | 28.19 | 28.27 | 5129989.0 |
| 2004-06-23 15:30:00 | MSFT | Stock | 28.27 | 28.38 | 28.26 | 28.32 | 8308317.0 |
| 2004-06-23 16:00:00 | MSFT | Stock | 28.31 | 28.35 | 28.28 | 28.31 | 1028232.0 |
| 2004-06-23 16:30:00 | MSFT | Stock | 28.32 | 28.34 | 28.3 | 28.34 | 46918.0 |
| 2004-06-23 17:00:00 | MSFT | Stock | 28.34 | 28.35 | 28.33 | 28.33 | 2500.0 |
| 2004-06-23 17:30:00 | MSFT | Stock | 28.33 | 28.33 | 28.1829 | 28.3 | 79600.0 |
| 2004-06-23 08:00:00 | NVDA | Stock | 0.1667 | 0.1667 | 0.1667 | 0.1667 | 60000.0 |
| 2004-06-23 09:00:00 | NVDA | Stock | 0.1667 | 0.1667 | 0.1661 | 0.1667 | 299640.0 |
| 2004-06-23 09:30:00 | NVDA | Stock | 0.1658 | 0.1675 | 0.1654 | 0.1664 | 37589040.0 |
| 2004-06-23 10:00:00 | NVDA | Stock | 0.1664 | 0.1673 | 0.1662 | 0.1673 | 22760160.0 |
| 2004-06-23 10:30:00 | NVDA | Stock | 0.1673 | 0.1675 | 0.1664 | 0.167 | 17030880.0 |
| 2004-06-23 11:00:00 | NVDA | Stock | 0.167 | 0.1674 | 0.1667 | 0.1672 | 15417480.0 |
| 2004-06-23 11:30:00 | NVDA | Stock | 0.1672 | 0.1693 | 0.1672 | 0.1692 | 29854560.0 |
| 2004-06-23 12:00:00 | NVDA | Stock | 0.1692 | 0.1698 | 0.1687 | 0.1691 | 13669200.0 |
| 2004-06-23 12:30:00 | NVDA | Stock | 0.1692 | 0.1692 | 0.1686 | 0.1689 | 12274080.0 |
| 2004-06-23 13:00:00 | NVDA | Stock | 0.1688 | 0.1692 | 0.1684 | 0.1688 | 13291440.0 |
> showing 50 of 40,980 rows — these rows as CSV