PREVIEW / stock_30min / 2004-04-19
file: by_date/stock_30min/2004/2004-04-19.parquet size: 755 KB rows: 40,570 symbols: 1,759
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-04-19 08:00:00 | AAPL | Stock | 0.5213 | 0.5213 | 0.5207 | 0.5207 | 56000.0 |
| 2004-04-19 08:30:00 | AAPL | Stock | 0.5207 | 0.5207 | 0.5207 | 0.5207 | 28000.0 |
| 2004-04-19 09:00:00 | AAPL | Stock | 0.5179 | 0.5179 | 0.5 | 0.5046 | 13326600.0 |
| 2004-04-19 09:30:00 | AAPL | Stock | 0.5021 | 0.5134 | 0.4998 | 0.5089 | 127028608.0 |
| 2004-04-19 10:00:00 | AAPL | Stock | 0.5089 | 0.5089 | 0.502 | 0.5057 | 65406768.0 |
| 2004-04-19 10:30:00 | AAPL | Stock | 0.5057 | 0.5064 | 0.5025 | 0.5057 | 35168616.0 |
| 2004-04-19 11:00:00 | AAPL | Stock | 0.5059 | 0.5079 | 0.5055 | 0.5064 | 30062200.0 |
| 2004-04-19 11:30:00 | AAPL | Stock | 0.5066 | 0.5071 | 0.5036 | 0.5057 | 34435240.0 |
| 2004-04-19 12:00:00 | AAPL | Stock | 0.5059 | 0.5079 | 0.5027 | 0.5048 | 38450160.0 |
| 2004-04-19 12:30:00 | AAPL | Stock | 0.5046 | 0.505 | 0.4996 | 0.5 | 57142008.0 |
| 2004-04-19 13:00:00 | AAPL | Stock | 0.5004 | 0.5016 | 0.497 | 0.5013 | 32989152.0 |
| 2004-04-19 13:30:00 | AAPL | Stock | 0.5013 | 0.5021 | 0.4977 | 0.5007 | 39873120.0 |
| 2004-04-19 14:00:00 | AAPL | Stock | 0.5007 | 0.5014 | 0.4986 | 0.4998 | 24416448.0 |
| 2004-04-19 14:30:00 | AAPL | Stock | 0.4996 | 0.5016 | 0.4995 | 0.5009 | 41693120.0 |
| 2004-04-19 15:00:00 | AAPL | Stock | 0.5009 | 0.505 | 0.5005 | 0.505 | 43647744.0 |
| 2004-04-19 15:30:00 | AAPL | Stock | 0.505 | 0.5063 | 0.5036 | 0.5057 | 78844080.0 |
| 2004-04-19 16:00:00 | AAPL | Stock | 0.5057 | 0.5077 | 0.5055 | 0.5062 | 11575536.0 |
| 2004-04-19 16:30:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.506 | 0.506 | 586320.0 |
| 2004-04-19 17:00:00 | AAPL | Stock | 0.5063 | 0.5071 | 0.5061 | 0.5071 | 3924144.0 |
| 2004-04-19 08:00:00 | MSFT | Stock | 25.16 | 25.29 | 25.1 | 25.14 | 16850.0 |
| 2004-04-19 08:30:00 | MSFT | Stock | 25.14 | 25.14 | 25.11 | 25.13 | 58890.0 |
| 2004-04-19 09:00:00 | MSFT | Stock | 25.13 | 25.14 | 24.5 | 25.09 | 91643.0 |
| 2004-04-19 09:30:00 | MSFT | Stock | 25.08 | 25.19 | 25.06 | 25.16 | 4186217.0 |
| 2004-04-19 10:00:00 | MSFT | Stock | 25.16 | 25.35 | 25.14 | 25.32 | 4108598.0 |
| 2004-04-19 10:30:00 | MSFT | Stock | 25.311 | 25.36 | 25.24 | 25.28 | 2543208.0 |
| 2004-04-19 11:00:00 | MSFT | Stock | 25.28 | 25.46 | 25.26 | 25.46 | 4931368.0 |
| 2004-04-19 11:30:00 | MSFT | Stock | 25.46 | 25.49 | 25.36 | 25.48 | 2963339.0 |
| 2004-04-19 12:00:00 | MSFT | Stock | 25.48 | 25.56 | 25.38 | 25.41 | 4335246.0 |
| 2004-04-19 12:30:00 | MSFT | Stock | 25.401 | 25.42 | 25.38 | 25.41 | 2016000.0 |
| 2004-04-19 13:00:00 | MSFT | Stock | 25.4 | 25.45 | 25.32 | 25.33 | 2286639.0 |
| 2004-04-19 13:30:00 | MSFT | Stock | 25.33 | 25.42 | 25.32 | 25.4 | 1941189.0 |
| 2004-04-19 14:00:00 | MSFT | Stock | 25.4 | 25.46 | 25.34 | 25.41 | 1914879.0 |
| 2004-04-19 14:30:00 | MSFT | Stock | 25.41 | 25.49 | 25.39 | 25.47 | 2078346.0 |
| 2004-04-19 15:00:00 | MSFT | Stock | 25.47 | 25.52 | 25.44 | 25.47 | 3092116.0 |
| 2004-04-19 15:30:00 | MSFT | Stock | 25.47 | 25.56 | 25.42 | 25.53 | 5670340.0 |
| 2004-04-19 16:00:00 | MSFT | Stock | 25.54 | 25.6 | 25.42 | 25.55 | 695980.0 |
| 2004-04-19 16:30:00 | MSFT | Stock | 25.58 | 25.58 | 25.518 | 25.57 | 77585.0 |
| 2004-04-19 17:00:00 | MSFT | Stock | 25.58 | 25.58 | 25.52 | 25.55 | 499960.0 |
| 2004-04-19 17:30:00 | MSFT | Stock | 25.53 | 25.53 | 25.53 | 25.53 | 4300.0 |
| 2004-04-19 18:00:00 | MSFT | Stock | 25.55 | 25.55 | 25.55 | 25.55 | 200.0 |
| 2004-04-19 08:00:00 | NVDA | Stock | 0.1967 | 0.1967 | 0.1967 | 0.1967 | 12000.0 |
| 2004-04-19 09:00:00 | NVDA | Stock | 0.1975 | 0.1983 | 0.1971 | 0.1977 | 456000.0 |
| 2004-04-19 09:30:00 | NVDA | Stock | 0.1968 | 0.1978 | 0.193 | 0.1948 | 70351680.0 |
| 2004-04-19 10:00:00 | NVDA | Stock | 0.1948 | 0.196 | 0.1942 | 0.1952 | 35630760.0 |
| 2004-04-19 10:30:00 | NVDA | Stock | 0.1952 | 0.1964 | 0.195 | 0.1962 | 23977560.0 |
| 2004-04-19 11:00:00 | NVDA | Stock | 0.1962 | 0.1979 | 0.1962 | 0.1975 | 29700960.0 |
| 2004-04-19 11:30:00 | NVDA | Stock | 0.1975 | 0.1976 | 0.1962 | 0.1971 | 36551880.0 |
| 2004-04-19 12:00:00 | NVDA | Stock | 0.1971 | 0.1972 | 0.1963 | 0.1965 | 19725960.0 |
| 2004-04-19 12:30:00 | NVDA | Stock | 0.1965 | 0.1967 | 0.1962 | 0.1963 | 18659400.0 |
| 2004-04-19 13:00:00 | NVDA | Stock | 0.1963 | 0.1971 | 0.1954 | 0.1955 | 14240520.0 |
> showing 50 of 40,570 rows — these rows as CSV