PREVIEW / stock_30min / 2005-04-04
file: by_date/stock_30min/2005/2005-04-04.parquet size: 816 KB rows: 43,970 symbols: 1,957
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-04-04 08:00:00 | AAPL | Stock | 1.4607 | 1.4607 | 1.4129 | 1.4464 | 1076936.0 |
| 2005-04-04 08:30:00 | AAPL | Stock | 1.4482 | 1.4604 | 1.4461 | 1.4593 | 1333416.0 |
| 2005-04-04 09:00:00 | AAPL | Stock | 1.4589 | 1.4643 | 1.4496 | 1.4639 | 1124508.0 |
| 2005-04-04 09:30:00 | AAPL | Stock | 1.4639 | 1.475 | 1.4343 | 1.4589 | 121454312.0 |
| 2005-04-04 10:00:00 | AAPL | Stock | 1.4586 | 1.4636 | 1.4482 | 1.4532 | 54406996.0 |
| 2005-04-04 10:30:00 | AAPL | Stock | 1.4529 | 1.4664 | 1.4518 | 1.4607 | 50817424.0 |
| 2005-04-04 11:00:00 | AAPL | Stock | 1.4604 | 1.465 | 1.45 | 1.4518 | 51768164.0 |
| 2005-04-04 11:30:00 | AAPL | Stock | 1.4514 | 1.4571 | 1.4432 | 1.4543 | 35105868.0 |
| 2005-04-04 12:00:00 | AAPL | Stock | 1.4536 | 1.4579 | 1.4525 | 1.4554 | 31913812.0 |
| 2005-04-04 12:30:00 | AAPL | Stock | 1.4554 | 1.4625 | 1.4525 | 1.4589 | 31048248.0 |
| 2005-04-04 13:00:00 | AAPL | Stock | 1.4589 | 1.4614 | 1.4539 | 1.4568 | 22409296.0 |
| 2005-04-04 13:30:00 | AAPL | Stock | 1.4568 | 1.4671 | 1.4561 | 1.4671 | 23991436.0 |
| 2005-04-04 14:00:00 | AAPL | Stock | 1.4671 | 1.4754 | 1.4611 | 1.4704 | 40138420.0 |
| 2005-04-04 14:30:00 | AAPL | Stock | 1.47 | 1.4732 | 1.4671 | 1.4682 | 25046252.0 |
| 2005-04-04 15:00:00 | AAPL | Stock | 1.4682 | 1.47 | 1.4604 | 1.4661 | 25784248.0 |
| 2005-04-04 15:30:00 | AAPL | Stock | 1.4664 | 1.4711 | 1.4614 | 1.4671 | 40719448.0 |
| 2005-04-04 16:00:00 | AAPL | Stock | 1.4675 | 1.4682 | 1.4554 | 1.4679 | 3887800.0 |
| 2005-04-04 16:30:00 | AAPL | Stock | 1.4682 | 1.4682 | 1.4614 | 1.4675 | 440664.0 |
| 2005-04-04 17:00:00 | AAPL | Stock | 1.4675 | 1.4679 | 1.4675 | 1.4675 | 79856.0 |
| 2005-04-04 17:30:00 | AAPL | Stock | 1.4679 | 1.4679 | 1.4671 | 1.4671 | 36400.0 |
| 2005-04-04 18:00:00 | AAPL | Stock | 1.4679 | 1.4689 | 1.4679 | 1.4689 | 46200.0 |
| 2005-04-04 08:00:00 | MSFT | Stock | 24.09 | 24.1 | 24.09 | 24.09 | 4300.0 |
| 2005-04-04 08:30:00 | MSFT | Stock | 24.1 | 24.12 | 24.09 | 24.09 | 23560.0 |
| 2005-04-04 09:00:00 | MSFT | Stock | 24.11 | 24.12 | 24.08 | 24.1 | 103668.0 |
| 2005-04-04 09:30:00 | MSFT | Stock | 24.11 | 24.16 | 24.03 | 24.04 | 6644161.0 |
| 2005-04-04 10:00:00 | MSFT | Stock | 24.03 | 24.07 | 23.96 | 23.98 | 6846476.0 |
| 2005-04-04 10:30:00 | MSFT | Stock | 23.97 | 24.08 | 23.94 | 24.08 | 5958696.0 |
| 2005-04-04 11:00:00 | MSFT | Stock | 24.07 | 24.13 | 24.04 | 24.05 | 3546470.0 |
| 2005-04-04 11:30:00 | MSFT | Stock | 24.05 | 24.06 | 24.01 | 24.052 | 3393982.0 |
| 2005-04-04 12:00:00 | MSFT | Stock | 24.06 | 24.07 | 24.04 | 24.06 | 3640510.0 |
| 2005-04-04 12:30:00 | MSFT | Stock | 24.051 | 24.11 | 24.05 | 24.05 | 3347400.0 |
| 2005-04-04 13:00:00 | MSFT | Stock | 24.05 | 24.06 | 24.0 | 24.011 | 3045893.0 |
| 2005-04-04 13:30:00 | MSFT | Stock | 24.01 | 24.12 | 24.01 | 24.12 | 2658420.0 |
| 2005-04-04 14:00:00 | MSFT | Stock | 24.12 | 24.22 | 24.11 | 24.21 | 4841421.0 |
| 2005-04-04 14:30:00 | MSFT | Stock | 24.2 | 24.26 | 24.2 | 24.22 | 5616002.0 |
| 2005-04-04 15:00:00 | MSFT | Stock | 24.22 | 24.241 | 24.2 | 24.22 | 3159739.0 |
| 2005-04-04 15:30:00 | MSFT | Stock | 24.23 | 24.26 | 24.22 | 24.22 | 5670333.0 |
| 2005-04-04 16:00:00 | MSFT | Stock | 24.24 | 24.24 | 24.18 | 24.2 | 1511963.0 |
| 2005-04-04 16:30:00 | MSFT | Stock | 24.22 | 24.22 | 24.21 | 24.21 | 600.0 |
| 2005-04-04 17:00:00 | MSFT | Stock | 24.22 | 24.22 | 24.21 | 24.22 | 6850.0 |
| 2005-04-04 17:30:00 | MSFT | Stock | 24.22 | 24.25 | 24.21 | 24.21 | 6815.0 |
| 2005-04-04 18:00:00 | MSFT | Stock | 24.21 | 24.21 | 24.2 | 24.2 | 2718.0 |
| 2005-04-04 08:00:00 | NVDA | Stock | 0.1958 | 0.1958 | 0.1958 | 0.1958 | 24000.0 |
| 2005-04-04 08:30:00 | NVDA | Stock | 0.1958 | 0.1958 | 0.1958 | 0.1958 | 12000.0 |
| 2005-04-04 09:00:00 | NVDA | Stock | 0.1961 | 0.1974 | 0.1946 | 0.195 | 1694640.0 |
| 2005-04-04 09:30:00 | NVDA | Stock | 0.195 | 0.1956 | 0.1924 | 0.1937 | 47158800.0 |
| 2005-04-04 10:00:00 | NVDA | Stock | 0.1937 | 0.194 | 0.1906 | 0.191 | 74021640.0 |
| 2005-04-04 10:30:00 | NVDA | Stock | 0.191 | 0.1929 | 0.1908 | 0.1928 | 64368000.0 |
| 2005-04-04 11:00:00 | NVDA | Stock | 0.1927 | 0.1942 | 0.1922 | 0.1923 | 45057960.0 |
| 2005-04-04 11:30:00 | NVDA | Stock | 0.1924 | 0.1927 | 0.1922 | 0.1927 | 11490840.0 |
> showing 50 of 43,970 rows — these rows as CSV