PREVIEW / stock_30min / 2003-09-18
file: by_date/stock_30min/2003/2003-09-18.parquet size: 696 KB rows: 37,690 symbols: 1,608
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 |
|---|---|---|---|---|---|---|---|
| 2003-09-18 09:00:00 | AAPL | Stock | 0.3946 | 0.395 | 0.3939 | 0.3939 | 210000.0 |
| 2003-09-18 09:30:00 | AAPL | Stock | 0.3946 | 0.397 | 0.392 | 0.3964 | 21222264.0 |
| 2003-09-18 10:00:00 | AAPL | Stock | 0.3963 | 0.4 | 0.3954 | 0.4 | 13335616.0 |
| 2003-09-18 10:30:00 | AAPL | Stock | 0.4 | 0.4039 | 0.3993 | 0.4039 | 24064544.0 |
| 2003-09-18 11:00:00 | AAPL | Stock | 0.4039 | 0.4068 | 0.403 | 0.4055 | 21409024.0 |
| 2003-09-18 11:30:00 | AAPL | Stock | 0.4057 | 0.4089 | 0.4057 | 0.407 | 18020240.0 |
| 2003-09-18 12:00:00 | AAPL | Stock | 0.4071 | 0.4098 | 0.405 | 0.4096 | 21874720.0 |
| 2003-09-18 12:30:00 | AAPL | Stock | 0.4096 | 0.4105 | 0.4088 | 0.4105 | 11542776.0 |
| 2003-09-18 13:00:00 | AAPL | Stock | 0.4104 | 0.4105 | 0.4071 | 0.4079 | 10417960.0 |
| 2003-09-18 13:30:00 | AAPL | Stock | 0.408 | 0.4102 | 0.4077 | 0.4091 | 16101792.0 |
| 2003-09-18 14:00:00 | AAPL | Stock | 0.4089 | 0.4099 | 0.4084 | 0.4086 | 9889096.0 |
| 2003-09-18 14:30:00 | AAPL | Stock | 0.4084 | 0.4093 | 0.4064 | 0.4071 | 12109496.0 |
| 2003-09-18 15:00:00 | AAPL | Stock | 0.4071 | 0.4082 | 0.4066 | 0.407 | 17493112.0 |
| 2003-09-18 15:30:00 | AAPL | Stock | 0.4068 | 0.4102 | 0.4064 | 0.4086 | 25792424.0 |
| 2003-09-18 16:00:00 | AAPL | Stock | 0.4088 | 0.4095 | 0.4073 | 0.4086 | 744800.0 |
| 2003-09-18 16:30:00 | AAPL | Stock | 0.4086 | 0.4086 | 0.4086 | 0.4086 | 16800.0 |
| 2003-09-18 08:00:00 | MSFT | Stock | 28.45 | 28.9 | 28.354 | 28.5 | 18889.0 |
| 2003-09-18 08:30:00 | MSFT | Stock | 28.5 | 28.601 | 28.5 | 28.511 | 66600.0 |
| 2003-09-18 09:00:00 | MSFT | Stock | 28.588 | 28.588 | 28.499 | 28.51 | 176966.0 |
| 2003-09-18 09:30:00 | MSFT | Stock | 28.49 | 28.64 | 28.43 | 28.62 | 4363408.0 |
| 2003-09-18 10:00:00 | MSFT | Stock | 28.62 | 28.801 | 28.589 | 28.73 | 4363065.0 |
| 2003-09-18 10:30:00 | MSFT | Stock | 28.729 | 28.81 | 28.69 | 28.78 | 3589306.0 |
| 2003-09-18 11:00:00 | MSFT | Stock | 28.79 | 28.99 | 28.76 | 28.98 | 5276433.0 |
| 2003-09-18 11:30:00 | MSFT | Stock | 28.97 | 29.1 | 28.95 | 29.04 | 7118563.0 |
| 2003-09-18 12:00:00 | MSFT | Stock | 29.06 | 29.181 | 28.94 | 29.18 | 4804619.0 |
| 2003-09-18 12:30:00 | MSFT | Stock | 29.18 | 29.2 | 29.13 | 29.15 | 2296245.0 |
| 2003-09-18 13:00:00 | MSFT | Stock | 29.16 | 29.19 | 29.09 | 29.16 | 2525412.0 |
| 2003-09-18 13:30:00 | MSFT | Stock | 29.16 | 29.28 | 29.15 | 29.2 | 3313306.0 |
| 2003-09-18 14:00:00 | MSFT | Stock | 29.21 | 29.38 | 29.19 | 29.32 | 4374100.0 |
| 2003-09-18 14:30:00 | MSFT | Stock | 29.31 | 29.43 | 29.29 | 29.38 | 3652151.0 |
| 2003-09-18 15:00:00 | MSFT | Stock | 29.38 | 29.46 | 29.35 | 29.4 | 4959614.0 |
| 2003-09-18 15:30:00 | MSFT | Stock | 29.4 | 29.51 | 29.37 | 29.48 | 7674587.0 |
| 2003-09-18 16:00:00 | MSFT | Stock | 29.49 | 29.5 | 29.44 | 29.49 | 684124.0 |
| 2003-09-18 16:30:00 | MSFT | Stock | 29.45 | 29.5 | 29.45 | 29.46 | 459100.0 |
| 2003-09-18 17:00:00 | MSFT | Stock | 29.49 | 29.49 | 29.0911 | 29.0911 | 13155.0 |
| 2003-09-18 17:30:00 | MSFT | Stock | 29.49 | 29.49 | 28.9454 | 29.43 | 14200.0 |
| 2003-09-18 18:00:00 | MSFT | Stock | 29.45 | 29.47 | 29.45 | 29.47 | 700.0 |
| 2003-09-18 08:00:00 | NVDA | Stock | 0.1635 | 0.1635 | 0.1635 | 0.1635 | 816000.0 |
| 2003-09-18 08:30:00 | NVDA | Stock | 0.165 | 0.165 | 0.1648 | 0.1648 | 132000.0 |
| 2003-09-18 09:00:00 | NVDA | Stock | 0.1647 | 0.1649 | 0.1644 | 0.1647 | 516000.0 |
| 2003-09-18 09:30:00 | NVDA | Stock | 0.1645 | 0.1654 | 0.1627 | 0.1652 | 70294920.0 |
| 2003-09-18 10:00:00 | NVDA | Stock | 0.1652 | 0.166 | 0.1648 | 0.1658 | 63411120.0 |
| 2003-09-18 10:30:00 | NVDA | Stock | 0.1657 | 0.1657 | 0.1634 | 0.1642 | 62319720.0 |
| 2003-09-18 11:00:00 | NVDA | Stock | 0.1642 | 0.1645 | 0.1634 | 0.1642 | 20319360.0 |
| 2003-09-18 11:30:00 | NVDA | Stock | 0.1643 | 0.1652 | 0.1642 | 0.165 | 28806840.0 |
| 2003-09-18 12:00:00 | NVDA | Stock | 0.165 | 0.165 | 0.1641 | 0.1649 | 24930480.0 |
| 2003-09-18 12:30:00 | NVDA | Stock | 0.1649 | 0.1653 | 0.1646 | 0.1649 | 15519600.0 |
| 2003-09-18 13:00:00 | NVDA | Stock | 0.165 | 0.1652 | 0.1646 | 0.1652 | 10722480.0 |
| 2003-09-18 13:30:00 | NVDA | Stock | 0.1652 | 0.1653 | 0.1646 | 0.165 | 15210840.0 |
| 2003-09-18 14:00:00 | NVDA | Stock | 0.1649 | 0.1651 | 0.1646 | 0.165 | 37707360.0 |
> showing 50 of 37,690 rows — these rows as CSV