PREVIEW / stock_30min / 2005-02-09
file: by_date/stock_30min/2005/2005-02-09.parquet size: 818 KB rows: 43,701 symbols: 1,932
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-09 08:00:00 | AAPL | Stock | 1.4464 | 1.4516 | 1.4455 | 1.4482 | 700000.0 |
| 2005-02-09 08:30:00 | AAPL | Stock | 1.4482 | 1.4548 | 1.4473 | 1.4536 | 811216.0 |
| 2005-02-09 09:00:00 | AAPL | Stock | 1.4548 | 1.4554 | 1.4464 | 1.448 | 3581256.0 |
| 2005-02-09 09:30:00 | AAPL | Stock | 1.4471 | 1.4598 | 1.4439 | 1.4571 | 110850712.0 |
| 2005-02-09 10:00:00 | AAPL | Stock | 1.4573 | 1.4641 | 1.4488 | 1.4525 | 104887216.0 |
| 2005-02-09 10:30:00 | AAPL | Stock | 1.4523 | 1.4552 | 1.4486 | 1.4534 | 84647640.0 |
| 2005-02-09 11:00:00 | AAPL | Stock | 1.4532 | 1.4598 | 1.4513 | 1.4527 | 45032736.0 |
| 2005-02-09 11:30:00 | AAPL | Stock | 1.4527 | 1.455 | 1.4495 | 1.4516 | 33887448.0 |
| 2005-02-09 12:00:00 | AAPL | Stock | 1.452 | 1.4541 | 1.4502 | 1.4507 | 22349656.0 |
| 2005-02-09 12:30:00 | AAPL | Stock | 1.4507 | 1.4555 | 1.4502 | 1.4518 | 23495696.0 |
| 2005-02-09 13:00:00 | AAPL | Stock | 1.4518 | 1.4532 | 1.4493 | 1.4509 | 23963184.0 |
| 2005-02-09 13:30:00 | AAPL | Stock | 1.4509 | 1.4539 | 1.4491 | 1.4495 | 26798800.0 |
| 2005-02-09 14:00:00 | AAPL | Stock | 1.4495 | 1.4496 | 1.3946 | 1.418 | 344197616.0 |
| 2005-02-09 14:30:00 | AAPL | Stock | 1.4184 | 1.4321 | 1.4032 | 1.4098 | 144659928.0 |
| 2005-02-09 15:00:00 | AAPL | Stock | 1.4098 | 1.4125 | 1.4021 | 1.4102 | 97198752.0 |
| 2005-02-09 15:30:00 | AAPL | Stock | 1.41 | 1.4173 | 1.4027 | 1.4071 | 110281584.0 |
| 2005-02-09 16:00:00 | AAPL | Stock | 1.4068 | 1.408 | 1.4038 | 1.405 | 2821896.0 |
| 2005-02-09 16:30:00 | AAPL | Stock | 1.4043 | 1.408 | 1.4036 | 1.4071 | 852600.0 |
| 2005-02-09 17:00:00 | AAPL | Stock | 1.4077 | 1.4125 | 1.4059 | 1.4107 | 1699040.0 |
| 2005-02-09 17:30:00 | AAPL | Stock | 1.4134 | 1.437 | 1.4093 | 1.4093 | 262360.0 |
| 2005-02-09 18:00:00 | AAPL | Stock | 1.4093 | 1.4125 | 1.4039 | 1.4107 | 351680.0 |
| 2005-02-09 08:00:00 | MSFT | Stock | 26.28 | 26.29 | 26.28 | 26.29 | 6103.0 |
| 2005-02-09 08:30:00 | MSFT | Stock | 26.28 | 26.28 | 26.24 | 26.27 | 56547.0 |
| 2005-02-09 09:00:00 | MSFT | Stock | 26.26 | 26.3 | 26.24 | 26.24 | 159264.0 |
| 2005-02-09 09:30:00 | MSFT | Stock | 26.25 | 26.26 | 26.18 | 26.21 | 7645689.0 |
| 2005-02-09 10:00:00 | MSFT | Stock | 26.21 | 26.31 | 26.18 | 26.22 | 10793918.0 |
| 2005-02-09 10:30:00 | MSFT | Stock | 26.22 | 26.25 | 26.13 | 26.18 | 10315907.0 |
| 2005-02-09 11:00:00 | MSFT | Stock | 26.18 | 26.19 | 26.15 | 26.16 | 3782346.0 |
| 2005-02-09 11:30:00 | MSFT | Stock | 26.16 | 26.17 | 26.12 | 26.14 | 3556915.0 |
| 2005-02-09 12:00:00 | MSFT | Stock | 26.13 | 26.19 | 26.12 | 26.16 | 2918593.0 |
| 2005-02-09 12:30:00 | MSFT | Stock | 26.151 | 26.16 | 26.13 | 26.13 | 1518265.0 |
| 2005-02-09 13:00:00 | MSFT | Stock | 26.13 | 26.16 | 26.12 | 26.16 | 2494258.0 |
| 2005-02-09 13:30:00 | MSFT | Stock | 26.16 | 26.17 | 26.13 | 26.13 | 2430886.0 |
| 2005-02-09 14:00:00 | MSFT | Stock | 26.13 | 26.15 | 26.08 | 26.15 | 6113543.0 |
| 2005-02-09 14:30:00 | MSFT | Stock | 26.15 | 26.2 | 26.08 | 26.09 | 4876550.0 |
| 2005-02-09 15:00:00 | MSFT | Stock | 26.09 | 26.14 | 26.04 | 26.14 | 9238245.0 |
| 2005-02-09 15:30:00 | MSFT | Stock | 26.13 | 26.24 | 26.05 | 26.09 | 8218442.0 |
| 2005-02-09 16:00:00 | MSFT | Stock | 26.08 | 26.11 | 26.05 | 26.06 | 421727.0 |
| 2005-02-09 16:30:00 | MSFT | Stock | 26.06 | 26.1 | 26.05 | 26.06 | 12644.0 |
| 2005-02-09 17:00:00 | MSFT | Stock | 26.06 | 26.1 | 26.06 | 26.07 | 1570140.0 |
| 2005-02-09 17:30:00 | MSFT | Stock | 26.142 | 26.142 | 26.07 | 26.1 | 122591.0 |
| 2005-02-09 18:00:00 | MSFT | Stock | 26.06 | 26.11 | 26.06 | 26.11 | 725.0 |
| 2005-02-09 09:00:00 | NVDA | Stock | 0.2148 | 0.2162 | 0.2142 | 0.215 | 1962000.0 |
| 2005-02-09 09:30:00 | NVDA | Stock | 0.215 | 0.2157 | 0.2127 | 0.2134 | 117243120.0 |
| 2005-02-09 10:00:00 | NVDA | Stock | 0.2136 | 0.2142 | 0.2097 | 0.2104 | 123692880.0 |
| 2005-02-09 10:30:00 | NVDA | Stock | 0.2103 | 0.2108 | 0.2092 | 0.2098 | 54244200.0 |
| 2005-02-09 11:00:00 | NVDA | Stock | 0.2099 | 0.2105 | 0.2094 | 0.2098 | 36601320.0 |
| 2005-02-09 11:30:00 | NVDA | Stock | 0.2098 | 0.2112 | 0.2097 | 0.2112 | 37055160.0 |
| 2005-02-09 12:00:00 | NVDA | Stock | 0.2112 | 0.2124 | 0.2111 | 0.2116 | 38510640.0 |
| 2005-02-09 12:30:00 | NVDA | Stock | 0.2114 | 0.2119 | 0.2114 | 0.2119 | 10638120.0 |
> showing 50 of 43,701 rows — these rows as CSV