PREVIEW / stock_30min / 2004-11-23
file: by_date/stock_30min/2004/2004-11-23.parquet size: 798 KB rows: 43,257 symbols: 1,879
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-23 08:00:00 | AAPL | Stock | 1.1 | 1.1148 | 1.1 | 1.1121 | 4043984.0 |
| 2004-11-23 08:30:00 | AAPL | Stock | 1.1118 | 1.1118 | 1.1036 | 1.1071 | 5956608.0 |
| 2004-11-23 09:00:00 | AAPL | Stock | 1.1073 | 1.1138 | 1.1023 | 1.1125 | 13335616.0 |
| 2004-11-23 09:30:00 | AAPL | Stock | 1.1123 | 1.1141 | 1.0914 | 1.0934 | 201380984.0 |
| 2004-11-23 10:00:00 | AAPL | Stock | 1.0931 | 1.1079 | 1.092 | 1.0977 | 134023568.0 |
| 2004-11-23 10:30:00 | AAPL | Stock | 1.0979 | 1.1036 | 1.0902 | 1.0964 | 63827512.0 |
| 2004-11-23 11:00:00 | AAPL | Stock | 1.0961 | 1.1 | 1.0938 | 1.0986 | 55758080.0 |
| 2004-11-23 11:30:00 | AAPL | Stock | 1.0986 | 1.1045 | 1.0982 | 1.1014 | 37762704.0 |
| 2004-11-23 12:00:00 | AAPL | Stock | 1.102 | 1.1027 | 1.0963 | 1.0979 | 46686360.0 |
| 2004-11-23 12:30:00 | AAPL | Stock | 1.0979 | 1.1021 | 1.0975 | 1.1 | 24773504.0 |
| 2004-11-23 13:00:00 | AAPL | Stock | 1.1 | 1.1002 | 1.092 | 1.0968 | 46073552.0 |
| 2004-11-23 13:30:00 | AAPL | Stock | 1.0966 | 1.1005 | 1.0959 | 1.0968 | 31250408.0 |
| 2004-11-23 14:00:00 | AAPL | Stock | 1.0966 | 1.1018 | 1.0961 | 1.1004 | 49647472.0 |
| 2004-11-23 14:30:00 | AAPL | Stock | 1.1002 | 1.1014 | 1.0975 | 1.0995 | 25594800.0 |
| 2004-11-23 15:00:00 | AAPL | Stock | 1.0995 | 1.1011 | 1.0952 | 1.0971 | 47550496.0 |
| 2004-11-23 15:30:00 | AAPL | Stock | 1.0971 | 1.0977 | 1.0938 | 1.0939 | 67403504.0 |
| 2004-11-23 16:00:00 | AAPL | Stock | 1.0943 | 1.098 | 1.0938 | 1.0971 | 7722120.0 |
| 2004-11-23 16:30:00 | AAPL | Stock | 1.0941 | 1.0968 | 1.0941 | 1.0968 | 4523680.0 |
| 2004-11-23 17:00:00 | AAPL | Stock | 1.0964 | 1.0968 | 1.0941 | 1.0954 | 338576.0 |
| 2004-11-23 17:30:00 | AAPL | Stock | 1.0951 | 1.0968 | 1.0941 | 1.0955 | 855120.0 |
| 2004-11-23 18:00:00 | AAPL | Stock | 1.0946 | 1.0971 | 1.0946 | 1.0964 | 257600.0 |
| 2004-11-23 08:00:00 | MSFT | Stock | 26.6 | 26.64 | 26.53 | 26.53 | 5576.0 |
| 2004-11-23 08:30:00 | MSFT | Stock | 26.59 | 26.65 | 26.56 | 26.56 | 85939.0 |
| 2004-11-23 09:00:00 | MSFT | Stock | 26.6 | 26.64 | 26.51 | 26.52 | 121833.0 |
| 2004-11-23 09:30:00 | MSFT | Stock | 26.52 | 26.56 | 26.45 | 26.47 | 6376706.0 |
| 2004-11-23 10:00:00 | MSFT | Stock | 26.47 | 26.7 | 26.44 | 26.61 | 7935987.0 |
| 2004-11-23 10:30:00 | MSFT | Stock | 26.6 | 26.661 | 26.5 | 26.53 | 5366412.0 |
| 2004-11-23 11:00:00 | MSFT | Stock | 26.53 | 26.551 | 26.45 | 26.49 | 3848211.0 |
| 2004-11-23 11:30:00 | MSFT | Stock | 26.49 | 26.53 | 26.47 | 26.48 | 1592737.0 |
| 2004-11-23 12:00:00 | MSFT | Stock | 26.48 | 26.49 | 26.45 | 26.47 | 1763582.0 |
| 2004-11-23 12:30:00 | MSFT | Stock | 26.47 | 26.48 | 26.43 | 26.45 | 2826168.0 |
| 2004-11-23 13:00:00 | MSFT | Stock | 26.45 | 26.52 | 26.4 | 26.46 | 3609818.0 |
| 2004-11-23 13:30:00 | MSFT | Stock | 26.46 | 26.49 | 26.42 | 26.48 | 2315810.0 |
| 2004-11-23 14:00:00 | MSFT | Stock | 26.47 | 26.6 | 26.47 | 26.54 | 5277238.0 |
| 2004-11-23 14:30:00 | MSFT | Stock | 26.54 | 26.56 | 26.49 | 26.53 | 3771882.0 |
| 2004-11-23 15:00:00 | MSFT | Stock | 26.54 | 26.62 | 26.52 | 26.5784 | 6745591.0 |
| 2004-11-23 15:30:00 | MSFT | Stock | 26.58 | 26.59 | 26.5 | 26.52 | 6707033.0 |
| 2004-11-23 16:00:00 | MSFT | Stock | 26.52 | 26.6 | 26.475 | 26.57 | 5098684.0 |
| 2004-11-23 16:30:00 | MSFT | Stock | 26.52 | 26.57 | 26.52 | 26.52 | 2100420.0 |
| 2004-11-23 17:00:00 | MSFT | Stock | 26.52 | 26.57 | 26.52 | 26.52 | 55594.0 |
| 2004-11-23 17:30:00 | MSFT | Stock | 26.53 | 26.5746 | 26.52 | 26.52 | 2122010.0 |
| 2004-11-23 18:00:00 | MSFT | Stock | 26.56 | 26.6 | 26.55 | 26.59 | 17011.0 |
| 2004-11-23 08:00:00 | NVDA | Stock | 0.1602 | 0.1608 | 0.1602 | 0.1608 | 156000.0 |
| 2004-11-23 08:30:00 | NVDA | Stock | 0.1613 | 0.1613 | 0.1604 | 0.1604 | 204000.0 |
| 2004-11-23 09:00:00 | NVDA | Stock | 0.1604 | 0.1613 | 0.1604 | 0.1612 | 1186560.0 |
| 2004-11-23 09:30:00 | NVDA | Stock | 0.1612 | 0.1632 | 0.1598 | 0.1625 | 91499760.0 |
| 2004-11-23 10:00:00 | NVDA | Stock | 0.1624 | 0.1649 | 0.1621 | 0.1638 | 74131560.0 |
| 2004-11-23 10:30:00 | NVDA | Stock | 0.1641 | 0.1641 | 0.1617 | 0.1624 | 71739720.0 |
| 2004-11-23 11:00:00 | NVDA | Stock | 0.1624 | 0.163 | 0.1616 | 0.1618 | 45555120.0 |
| 2004-11-23 11:30:00 | NVDA | Stock | 0.1618 | 0.1626 | 0.1617 | 0.1623 | 22390320.0 |
> showing 50 of 43,257 rows — these rows as CSV