PREVIEW / stock_30min / 2004-01-15
file: by_date/stock_30min/2004/2004-01-15.parquet size: 743 KB rows: 39,346 symbols: 1,708
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-15 08:00:00 | AAPL | Stock | 0.4107 | 0.413 | 0.4089 | 0.4107 | 2955680.0 |
| 2004-01-15 08:30:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.408 | 0.4089 | 4263000.0 |
| 2004-01-15 09:00:00 | AAPL | Stock | 0.4088 | 0.4107 | 0.4071 | 0.4089 | 6351632.0 |
| 2004-01-15 09:30:00 | AAPL | Stock | 0.4091 | 0.4127 | 0.4046 | 0.4048 | 199566528.0 |
| 2004-01-15 10:00:00 | AAPL | Stock | 0.4048 | 0.4061 | 0.4018 | 0.4046 | 103021632.0 |
| 2004-01-15 10:30:00 | AAPL | Stock | 0.4046 | 0.4134 | 0.4041 | 0.4107 | 132302800.0 |
| 2004-01-15 11:00:00 | AAPL | Stock | 0.4105 | 0.4109 | 0.4071 | 0.4088 | 55305320.0 |
| 2004-01-15 11:30:00 | AAPL | Stock | 0.4089 | 0.4134 | 0.4086 | 0.4127 | 79946720.0 |
| 2004-01-15 12:00:00 | AAPL | Stock | 0.4127 | 0.4141 | 0.41 | 0.412 | 65623992.0 |
| 2004-01-15 12:30:00 | AAPL | Stock | 0.4118 | 0.4179 | 0.41 | 0.4165 | 65005248.0 |
| 2004-01-15 13:00:00 | AAPL | Stock | 0.4166 | 0.4171 | 0.4134 | 0.4141 | 31023888.0 |
| 2004-01-15 13:30:00 | AAPL | Stock | 0.4145 | 0.4152 | 0.4137 | 0.4139 | 29527400.0 |
| 2004-01-15 14:00:00 | AAPL | Stock | 0.4139 | 0.4143 | 0.4107 | 0.413 | 36560944.0 |
| 2004-01-15 14:30:00 | AAPL | Stock | 0.4129 | 0.4134 | 0.4089 | 0.4098 | 40244680.0 |
| 2004-01-15 15:00:00 | AAPL | Stock | 0.4098 | 0.4114 | 0.408 | 0.4104 | 50883392.0 |
| 2004-01-15 15:30:00 | AAPL | Stock | 0.4104 | 0.4107 | 0.4071 | 0.4077 | 74014416.0 |
| 2004-01-15 16:00:00 | AAPL | Stock | 0.4077 | 0.4088 | 0.4071 | 0.408 | 7341488.0 |
| 2004-01-15 16:30:00 | AAPL | Stock | 0.408 | 0.408 | 0.4073 | 0.408 | 307720.0 |
| 2004-01-15 17:00:00 | AAPL | Stock | 0.408 | 0.4086 | 0.408 | 0.408 | 294000.0 |
| 2004-01-15 17:30:00 | AAPL | Stock | 0.408 | 0.408 | 0.408 | 0.408 | 84000.0 |
| 2004-01-15 18:00:00 | AAPL | Stock | 0.4086 | 0.4093 | 0.408 | 0.4082 | 140000.0 |
| 2004-01-15 08:00:00 | MSFT | Stock | 27.7 | 27.7 | 27.53 | 27.6 | 58700.0 |
| 2004-01-15 08:30:00 | MSFT | Stock | 27.6 | 27.66 | 27.6 | 27.63 | 102800.0 |
| 2004-01-15 09:00:00 | MSFT | Stock | 27.62 | 27.67 | 27.55 | 27.55 | 231227.0 |
| 2004-01-15 09:30:00 | MSFT | Stock | 27.55 | 27.67 | 27.54 | 27.58 | 7083273.0 |
| 2004-01-15 10:00:00 | MSFT | Stock | 27.57 | 27.64 | 27.5 | 27.5 | 4783052.0 |
| 2004-01-15 10:30:00 | MSFT | Stock | 27.52 | 27.55 | 27.42 | 27.46 | 4328090.0 |
| 2004-01-15 11:00:00 | MSFT | Stock | 27.46 | 27.51 | 27.43 | 27.44 | 2396845.0 |
| 2004-01-15 11:30:00 | MSFT | Stock | 27.449 | 27.62 | 27.44 | 27.55 | 3401224.0 |
| 2004-01-15 12:00:00 | MSFT | Stock | 27.55 | 27.67 | 27.5 | 27.58 | 4264862.0 |
| 2004-01-15 12:30:00 | MSFT | Stock | 27.59 | 27.65 | 27.55 | 27.58 | 4260571.0 |
| 2004-01-15 13:00:00 | MSFT | Stock | 27.58 | 27.67 | 27.56 | 27.65 | 2912098.0 |
| 2004-01-15 13:30:00 | MSFT | Stock | 27.64 | 27.71 | 27.62 | 27.68 | 2986622.0 |
| 2004-01-15 14:00:00 | MSFT | Stock | 27.68 | 27.7 | 27.61 | 27.68 | 3095108.0 |
| 2004-01-15 14:30:00 | MSFT | Stock | 27.67 | 27.7 | 27.57 | 27.64 | 4391738.0 |
| 2004-01-15 15:00:00 | MSFT | Stock | 27.65 | 27.66 | 27.54 | 27.63 | 4566472.0 |
| 2004-01-15 15:30:00 | MSFT | Stock | 27.63 | 27.64 | 27.54 | 27.55 | 5263544.0 |
| 2004-01-15 16:00:00 | MSFT | Stock | 27.54 | 27.61 | 27.5 | 27.56 | 969529.0 |
| 2004-01-15 16:30:00 | MSFT | Stock | 27.55 | 27.56 | 27.53 | 27.55 | 173230.0 |
| 2004-01-15 17:00:00 | MSFT | Stock | 27.57 | 27.58 | 27.55 | 27.58 | 8067.0 |
| 2004-01-15 17:30:00 | MSFT | Stock | 27.58 | 27.59 | 27.55 | 27.58 | 6100.0 |
| 2004-01-15 18:00:00 | MSFT | Stock | 27.58 | 27.6 | 27.55 | 27.55 | 20500.0 |
| 2004-01-15 08:00:00 | NVDA | Stock | 0.1995 | 0.1995 | 0.1995 | 0.1995 | 36000.0 |
| 2004-01-15 08:30:00 | NVDA | Stock | 0.2001 | 0.2007 | 0.2 | 0.2007 | 318000.0 |
| 2004-01-15 09:00:00 | NVDA | Stock | 0.2007 | 0.2014 | 0.2004 | 0.2004 | 384000.0 |
| 2004-01-15 09:30:00 | NVDA | Stock | 0.2004 | 0.2022 | 0.197 | 0.1992 | 124902720.0 |
| 2004-01-15 10:00:00 | NVDA | Stock | 0.1992 | 0.2017 | 0.1987 | 0.1987 | 76579440.0 |
| 2004-01-15 10:30:00 | NVDA | Stock | 0.1987 | 0.2002 | 0.1983 | 0.1997 | 44553720.0 |
| 2004-01-15 11:00:00 | NVDA | Stock | 0.1997 | 0.2017 | 0.1996 | 0.2003 | 28319640.0 |
| 2004-01-15 11:30:00 | NVDA | Stock | 0.2004 | 0.2041 | 0.2003 | 0.2018 | 46363080.0 |
> showing 50 of 39,346 rows — these rows as CSV