PREVIEW / stock_30min / 2004-01-27
file: by_date/stock_30min/2004/2004-01-27.parquet size: 773 KB rows: 40,667 symbols: 1,718
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-01-27 08:00:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4107 | 0.4107 | 28000.0 |
| 2004-01-27 08:30:00 | AAPL | Stock | 0.4105 | 0.4105 | 0.4105 | 0.4105 | 22400.0 |
| 2004-01-27 09:00:00 | AAPL | Stock | 0.4107 | 0.412 | 0.4107 | 0.412 | 28000.0 |
| 2004-01-27 09:30:00 | AAPL | Stock | 0.4113 | 0.4126 | 0.4095 | 0.4109 | 15732080.0 |
| 2004-01-27 10:00:00 | AAPL | Stock | 0.4109 | 0.4136 | 0.4071 | 0.4125 | 24914960.0 |
| 2004-01-27 10:30:00 | AAPL | Stock | 0.4129 | 0.4129 | 0.4098 | 0.41 | 18359600.0 |
| 2004-01-27 11:00:00 | AAPL | Stock | 0.41 | 0.4107 | 0.4086 | 0.4086 | 13321392.0 |
| 2004-01-27 11:30:00 | AAPL | Stock | 0.4088 | 0.4114 | 0.4086 | 0.4111 | 20468224.0 |
| 2004-01-27 12:00:00 | AAPL | Stock | 0.4111 | 0.4111 | 0.4091 | 0.4091 | 19566568.0 |
| 2004-01-27 12:30:00 | AAPL | Stock | 0.4091 | 0.4116 | 0.4086 | 0.4116 | 17526096.0 |
| 2004-01-27 13:00:00 | AAPL | Stock | 0.4114 | 0.412 | 0.4107 | 0.4114 | 20797000.0 |
| 2004-01-27 13:30:00 | AAPL | Stock | 0.4114 | 0.4136 | 0.4111 | 0.4136 | 25990272.0 |
| 2004-01-27 14:00:00 | AAPL | Stock | 0.4134 | 0.4141 | 0.4116 | 0.4136 | 26593224.0 |
| 2004-01-27 14:30:00 | AAPL | Stock | 0.4136 | 0.4152 | 0.412 | 0.4132 | 18968936.0 |
| 2004-01-27 15:00:00 | AAPL | Stock | 0.4134 | 0.4138 | 0.4113 | 0.412 | 18779992.0 |
| 2004-01-27 15:30:00 | AAPL | Stock | 0.4118 | 0.4125 | 0.4089 | 0.4116 | 31172680.0 |
| 2004-01-27 16:00:00 | AAPL | Stock | 0.4116 | 0.4129 | 0.4096 | 0.4127 | 2594760.0 |
| 2004-01-27 17:30:00 | AAPL | Stock | 0.4096 | 0.4096 | 0.4096 | 0.4096 | 56000.0 |
| 2004-01-27 18:00:00 | AAPL | Stock | 0.4089 | 0.4089 | 0.4089 | 0.4089 | 112000.0 |
| 2004-01-27 08:00:00 | MSFT | Stock | 28.7 | 28.74 | 28.65 | 28.65 | 24700.0 |
| 2004-01-27 08:30:00 | MSFT | Stock | 28.66 | 28.72 | 28.65 | 28.67 | 36500.0 |
| 2004-01-27 09:00:00 | MSFT | Stock | 28.68 | 28.73 | 28.6 | 28.65 | 590633.0 |
| 2004-01-27 09:30:00 | MSFT | Stock | 28.6 | 28.7 | 28.5 | 28.65 | 4627066.0 |
| 2004-01-27 10:00:00 | MSFT | Stock | 28.65 | 28.72 | 28.58 | 28.64 | 4114733.0 |
| 2004-01-27 10:30:00 | MSFT | Stock | 28.64 | 28.65 | 28.59 | 28.6 | 2728558.0 |
| 2004-01-27 11:00:00 | MSFT | Stock | 28.61 | 28.63 | 28.5 | 28.52 | 3494491.0 |
| 2004-01-27 11:30:00 | MSFT | Stock | 28.52 | 28.58 | 28.37 | 28.4 | 4983404.0 |
| 2004-01-27 12:00:00 | MSFT | Stock | 28.41 | 28.43 | 28.29 | 28.35 | 6460764.0 |
| 2004-01-27 12:30:00 | MSFT | Stock | 28.36 | 28.44 | 28.35 | 28.43 | 2546881.0 |
| 2004-01-27 13:00:00 | MSFT | Stock | 28.429 | 28.44 | 28.3199 | 28.38 | 3194886.0 |
| 2004-01-27 13:30:00 | MSFT | Stock | 28.38 | 28.5 | 28.34 | 28.48 | 3029753.0 |
| 2004-01-27 14:00:00 | MSFT | Stock | 28.48 | 28.53 | 28.36 | 28.45 | 4190755.0 |
| 2004-01-27 14:30:00 | MSFT | Stock | 28.45 | 28.5185 | 28.42 | 28.42 | 3532894.0 |
| 2004-01-27 15:00:00 | MSFT | Stock | 28.42 | 28.46 | 28.35 | 28.38 | 3839338.0 |
| 2004-01-27 15:30:00 | MSFT | Stock | 28.37 | 28.38 | 28.22 | 28.25 | 8649971.0 |
| 2004-01-27 16:00:00 | MSFT | Stock | 28.25 | 28.4437 | 28.21 | 28.4437 | 864161.0 |
| 2004-01-27 16:30:00 | MSFT | Stock | 28.24 | 28.25 | 28.22 | 28.24 | 111167.0 |
| 2004-01-27 17:00:00 | MSFT | Stock | 28.25 | 28.29 | 28.24 | 28.29 | 36900.0 |
| 2004-01-27 17:30:00 | MSFT | Stock | 28.28 | 28.3 | 28.28 | 28.3 | 6200.0 |
| 2004-01-27 18:00:00 | MSFT | Stock | 28.3 | 28.31 | 28.3 | 28.31 | 5300.0 |
| 2004-01-27 08:00:00 | NVDA | Stock | 0.1988 | 0.1988 | 0.1968 | 0.1975 | 876000.0 |
| 2004-01-27 08:30:00 | NVDA | Stock | 0.1972 | 0.1975 | 0.1954 | 0.1967 | 1878000.0 |
| 2004-01-27 09:00:00 | NVDA | Stock | 0.1967 | 0.1989 | 0.196 | 0.1971 | 1236000.0 |
| 2004-01-27 09:30:00 | NVDA | Stock | 0.196 | 0.1992 | 0.1959 | 0.1978 | 41328360.0 |
| 2004-01-27 10:00:00 | NVDA | Stock | 0.1977 | 0.1978 | 0.1943 | 0.1943 | 52142880.0 |
| 2004-01-27 10:30:00 | NVDA | Stock | 0.1943 | 0.1946 | 0.1927 | 0.1927 | 85319520.0 |
| 2004-01-27 11:00:00 | NVDA | Stock | 0.1927 | 0.1927 | 0.19 | 0.1912 | 106316760.0 |
| 2004-01-27 11:30:00 | NVDA | Stock | 0.1911 | 0.1925 | 0.1906 | 0.1907 | 62500080.0 |
| 2004-01-27 12:00:00 | NVDA | Stock | 0.1908 | 0.1918 | 0.1902 | 0.1911 | 72918360.0 |
| 2004-01-27 12:30:00 | NVDA | Stock | 0.191 | 0.1917 | 0.1909 | 0.1914 | 19827360.0 |
> showing 50 of 40,667 rows — these rows as CSV