PREVIEW / stock_30min / 2006-04-11
file: by_date/stock_30min/2006/2006-04-11.parquet size: 904 KB rows: 48,755 symbols: 2,226
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-11 07:30:00 | AAPL | Stock | 2.4421 | 2.4421 | 2.4421 | 2.4421 | 19600.0 |
| 2006-04-11 08:00:00 | AAPL | Stock | 2.4421 | 2.4457 | 2.4393 | 2.4446 | 817404.0 |
| 2006-04-11 08:30:00 | AAPL | Stock | 2.4446 | 2.4707 | 2.4446 | 2.4693 | 4789876.0 |
| 2006-04-11 09:00:00 | AAPL | Stock | 2.4689 | 2.4696 | 2.4607 | 2.4654 | 2128056.0 |
| 2006-04-11 09:30:00 | AAPL | Stock | 2.4639 | 2.475 | 2.425 | 2.4314 | 164051020.0 |
| 2006-04-11 10:00:00 | AAPL | Stock | 2.4311 | 2.4354 | 2.3954 | 2.4061 | 158366796.0 |
| 2006-04-11 10:30:00 | AAPL | Stock | 2.4057 | 2.425 | 2.3993 | 2.425 | 100744420.0 |
| 2006-04-11 11:00:00 | AAPL | Stock | 2.4254 | 2.4361 | 2.4154 | 2.4196 | 79681420.0 |
| 2006-04-11 11:30:00 | AAPL | Stock | 2.42 | 2.4296 | 2.4129 | 2.4164 | 37419060.0 |
| 2006-04-11 12:00:00 | AAPL | Stock | 2.4168 | 2.4743 | 2.4082 | 2.4179 | 35752724.0 |
| 2006-04-11 12:30:00 | AAPL | Stock | 2.4179 | 2.4304 | 2.4179 | 2.4239 | 24670464.0 |
| 2006-04-11 13:00:00 | AAPL | Stock | 2.4236 | 2.4557 | 2.4232 | 2.4464 | 75511828.0 |
| 2006-04-11 13:30:00 | AAPL | Stock | 2.4461 | 2.4496 | 2.4261 | 2.4311 | 54223120.0 |
| 2006-04-11 14:00:00 | AAPL | Stock | 2.4311 | 2.4443 | 2.4293 | 2.4368 | 34025768.0 |
| 2006-04-11 14:30:00 | AAPL | Stock | 2.4361 | 2.4411 | 2.4311 | 2.4336 | 32398324.0 |
| 2006-04-11 15:00:00 | AAPL | Stock | 2.4332 | 2.4332 | 2.4118 | 2.4146 | 57306004.0 |
| 2006-04-11 15:30:00 | AAPL | Stock | 2.4146 | 2.4318 | 2.4125 | 2.4314 | 65085440.0 |
| 2006-04-11 16:00:00 | AAPL | Stock | 2.4311 | 2.4336 | 2.4282 | 2.43 | 1606108.0 |
| 2006-04-11 16:30:00 | AAPL | Stock | 2.43 | 2.4318 | 2.4296 | 2.4311 | 412020.0 |
| 2006-04-11 17:00:00 | AAPL | Stock | 2.4311 | 2.4493 | 2.43 | 2.4311 | 347004.0 |
| 2006-04-11 17:30:00 | AAPL | Stock | 2.4311 | 2.4314 | 2.43 | 2.4304 | 154224.0 |
| 2006-04-11 18:00:00 | AAPL | Stock | 2.4321 | 2.4321 | 2.4286 | 2.43 | 169680.0 |
| 2006-04-11 06:30:00 | MSFT | Stock | 27.22 | 27.22 | 27.22 | 27.22 | 700.0 |
| 2006-04-11 07:00:00 | MSFT | Stock | 27.24 | 27.25 | 27.24 | 27.25 | 2250.0 |
| 2006-04-11 07:30:00 | MSFT | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 200.0 |
| 2006-04-11 08:00:00 | MSFT | Stock | 27.28 | 27.28 | 27.25 | 27.25 | 12629.0 |
| 2006-04-11 08:30:00 | MSFT | Stock | 27.26 | 27.26 | 27.25 | 27.25 | 1500.0 |
| 2006-04-11 09:00:00 | MSFT | Stock | 27.25 | 27.3 | 27.17 | 27.3 | 28871.0 |
| 2006-04-11 09:30:00 | MSFT | Stock | 27.29 | 27.3 | 27.23 | 27.26 | 3045602.0 |
| 2006-04-11 10:00:00 | MSFT | Stock | 27.26 | 27.32 | 27.18 | 27.22 | 2930934.0 |
| 2006-04-11 10:30:00 | MSFT | Stock | 27.221 | 27.26 | 27.13 | 27.24 | 4481119.0 |
| 2006-04-11 11:00:00 | MSFT | Stock | 27.24 | 27.26 | 27.21 | 27.25 | 1681794.0 |
| 2006-04-11 11:30:00 | MSFT | Stock | 27.25 | 27.26 | 27.17 | 27.192 | 1549783.0 |
| 2006-04-11 12:00:00 | MSFT | Stock | 27.19 | 27.2 | 27.1 | 27.13 | 3110593.0 |
| 2006-04-11 12:30:00 | MSFT | Stock | 27.14 | 27.17 | 27.131 | 27.16 | 1352269.0 |
| 2006-04-11 13:00:00 | MSFT | Stock | 27.16 | 27.24 | 27.16 | 27.19 | 2518286.0 |
| 2006-04-11 13:30:00 | MSFT | Stock | 27.19 | 27.2 | 27.12 | 27.138 | 2024235.0 |
| 2006-04-11 14:00:00 | MSFT | Stock | 27.14 | 27.23 | 27.1 | 27.14 | 2820828.0 |
| 2006-04-11 14:30:00 | MSFT | Stock | 27.13 | 27.16 | 27.12 | 27.13 | 1882805.0 |
| 2006-04-11 15:00:00 | MSFT | Stock | 27.12 | 27.15 | 27.0 | 27.07 | 5125173.0 |
| 2006-04-11 15:30:00 | MSFT | Stock | 27.062 | 27.17 | 27.06 | 27.12 | 8046523.0 |
| 2006-04-11 16:00:00 | MSFT | Stock | 27.12 | 27.15 | 27.1 | 27.11 | 300594.0 |
| 2006-04-11 16:30:00 | MSFT | Stock | 27.14 | 27.14 | 27.13 | 27.13 | 24600.0 |
| 2006-04-11 17:00:00 | MSFT | Stock | 27.11 | 27.11 | 27.11 | 27.11 | 500.0 |
| 2006-04-11 17:30:00 | MSFT | Stock | 27.11 | 27.11 | 27.11 | 27.11 | 717.0 |
| 2006-04-11 08:00:00 | NVDA | Stock | 0.5 | 0.5008 | 0.5 | 0.5008 | 132000.0 |
| 2006-04-11 08:30:00 | NVDA | Stock | 0.501 | 0.5022 | 0.5008 | 0.5022 | 72000.0 |
| 2006-04-11 09:00:00 | NVDA | Stock | 0.5025 | 0.5025 | 0.5002 | 0.5017 | 102000.0 |
| 2006-04-11 09:30:00 | NVDA | Stock | 0.5017 | 0.5017 | 0.4895 | 0.4895 | 104048280.0 |
| 2006-04-11 10:00:00 | NVDA | Stock | 0.4895 | 0.4923 | 0.4848 | 0.4877 | 115608420.0 |
> showing 50 of 48,755 rows — these rows as CSV