PREVIEW / stock_30min / 2005-04-08
file: by_date/stock_30min/2005/2005-04-08.parquet size: 786 KB rows: 42,788 symbols: 1,942
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-08 08:00:00 | AAPL | Stock | 1.5643 | 1.5714 | 1.5571 | 1.5614 | 291060.0 |
| 2005-04-08 08:30:00 | AAPL | Stock | 1.5643 | 1.5654 | 1.5579 | 1.56 | 588000.0 |
| 2005-04-08 09:00:00 | AAPL | Stock | 1.56 | 1.5621 | 1.5575 | 1.5607 | 1186920.0 |
| 2005-04-08 09:30:00 | AAPL | Stock | 1.5607 | 1.5875 | 1.5579 | 1.575 | 136351152.0 |
| 2005-04-08 10:00:00 | AAPL | Stock | 1.5754 | 1.5768 | 1.5632 | 1.5711 | 67828768.0 |
| 2005-04-08 10:30:00 | AAPL | Stock | 1.5711 | 1.5729 | 1.5657 | 1.5704 | 42705516.0 |
| 2005-04-08 11:00:00 | AAPL | Stock | 1.5707 | 1.5732 | 1.5679 | 1.5704 | 33246640.0 |
| 2005-04-08 11:30:00 | AAPL | Stock | 1.5704 | 1.5721 | 1.5668 | 1.5693 | 44964752.0 |
| 2005-04-08 12:00:00 | AAPL | Stock | 1.5689 | 1.5714 | 1.5686 | 1.5696 | 26452188.0 |
| 2005-04-08 12:30:00 | AAPL | Stock | 1.5693 | 1.5711 | 1.5661 | 1.569 | 32215428.0 |
| 2005-04-08 13:00:00 | AAPL | Stock | 1.5689 | 1.5714 | 1.5675 | 1.57 | 22329720.0 |
| 2005-04-08 13:30:00 | AAPL | Stock | 1.57 | 1.5786 | 1.5696 | 1.5757 | 40992056.0 |
| 2005-04-08 14:00:00 | AAPL | Stock | 1.5754 | 1.5757 | 1.5654 | 1.5664 | 31714788.0 |
| 2005-04-08 14:30:00 | AAPL | Stock | 1.5664 | 1.5739 | 1.5643 | 1.5729 | 29359792.0 |
| 2005-04-08 15:00:00 | AAPL | Stock | 1.5725 | 1.5729 | 1.555 | 1.56 | 64958152.0 |
| 2005-04-08 15:30:00 | AAPL | Stock | 1.56 | 1.565 | 1.5575 | 1.5625 | 63428736.0 |
| 2005-04-08 16:00:00 | AAPL | Stock | 1.5636 | 1.5661 | 1.5614 | 1.5636 | 2514596.0 |
| 2005-04-08 16:30:00 | AAPL | Stock | 1.5632 | 1.5659 | 1.5607 | 1.5607 | 851116.0 |
| 2005-04-08 17:00:00 | AAPL | Stock | 1.5614 | 1.5614 | 1.5593 | 1.5607 | 91140.0 |
| 2005-04-08 17:30:00 | AAPL | Stock | 1.5607 | 1.5607 | 1.5589 | 1.5589 | 95200.0 |
| 2005-04-08 18:00:00 | AAPL | Stock | 1.5607 | 1.5636 | 1.5607 | 1.5621 | 338800.0 |
| 2005-04-08 08:00:00 | MSFT | Stock | 25.05 | 25.07 | 25.05 | 25.07 | 8800.0 |
| 2005-04-08 08:30:00 | MSFT | Stock | 25.09 | 25.09 | 25.09 | 25.09 | 13084.0 |
| 2005-04-08 09:00:00 | MSFT | Stock | 25.09 | 25.1 | 25.06 | 25.07 | 42377.0 |
| 2005-04-08 09:30:00 | MSFT | Stock | 25.07 | 25.23 | 24.99 | 25.181 | 7671330.0 |
| 2005-04-08 10:00:00 | MSFT | Stock | 25.182 | 25.25 | 25.13 | 25.172 | 3992192.0 |
| 2005-04-08 10:30:00 | MSFT | Stock | 25.17 | 25.19 | 25.11 | 25.15 | 3978504.0 |
| 2005-04-08 11:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.06 | 25.06 | 3132279.0 |
| 2005-04-08 11:30:00 | MSFT | Stock | 25.06 | 25.12 | 25.02 | 25.07 | 3741453.0 |
| 2005-04-08 12:00:00 | MSFT | Stock | 25.06 | 25.11 | 25.03 | 25.1 | 1853602.0 |
| 2005-04-08 12:30:00 | MSFT | Stock | 25.1 | 25.11 | 25.05 | 25.06 | 1143633.0 |
| 2005-04-08 13:00:00 | MSFT | Stock | 25.052 | 25.07 | 25.01 | 25.02 | 2477326.0 |
| 2005-04-08 13:30:00 | MSFT | Stock | 25.03 | 25.05 | 25.0 | 25.01 | 1358470.0 |
| 2005-04-08 14:00:00 | MSFT | Stock | 25.01 | 25.03 | 24.91 | 24.91 | 3360675.0 |
| 2005-04-08 14:30:00 | MSFT | Stock | 24.91 | 24.98 | 24.91 | 24.98 | 2104919.0 |
| 2005-04-08 15:00:00 | MSFT | Stock | 24.98 | 25.0 | 24.91 | 24.93 | 3541859.0 |
| 2005-04-08 15:30:00 | MSFT | Stock | 24.93 | 25.0 | 24.91 | 24.94 | 6431908.0 |
| 2005-04-08 16:00:00 | MSFT | Stock | 24.93 | 24.98 | 24.91 | 24.93 | 1101400.0 |
| 2005-04-08 16:30:00 | MSFT | Stock | 24.94 | 24.94 | 24.91 | 24.93 | 19214.0 |
| 2005-04-08 17:30:00 | MSFT | Stock | 24.94 | 24.94 | 24.94 | 24.94 | 100.0 |
| 2005-04-08 18:00:00 | MSFT | Stock | 24.94 | 24.97 | 24.94 | 24.97 | 2400.0 |
| 2005-04-08 08:30:00 | NVDA | Stock | 0.1983 | 0.1983 | 0.1983 | 0.1983 | 12000.0 |
| 2005-04-08 09:00:00 | NVDA | Stock | 0.1987 | 0.1992 | 0.1977 | 0.1989 | 482760.0 |
| 2005-04-08 09:30:00 | NVDA | Stock | 0.1988 | 0.202 | 0.1975 | 0.2017 | 59387040.0 |
| 2005-04-08 10:00:00 | NVDA | Stock | 0.2017 | 0.2032 | 0.2016 | 0.202 | 91926840.0 |
| 2005-04-08 10:30:00 | NVDA | Stock | 0.202 | 0.2021 | 0.2008 | 0.2019 | 36607320.0 |
| 2005-04-08 11:00:00 | NVDA | Stock | 0.2019 | 0.2021 | 0.201 | 0.2013 | 24923640.0 |
| 2005-04-08 11:30:00 | NVDA | Stock | 0.2012 | 0.2014 | 0.1992 | 0.1997 | 20722200.0 |
| 2005-04-08 12:00:00 | NVDA | Stock | 0.1998 | 0.1998 | 0.1988 | 0.1994 | 19676760.0 |
| 2005-04-08 12:30:00 | NVDA | Stock | 0.1994 | 0.1996 | 0.1981 | 0.1982 | 16635360.0 |
> showing 50 of 42,788 rows — these rows as CSV