PREVIEW / stock_30min / 2000-04-20
file: by_date/stock_30min/2000/2000-04-20.parquet size: 400 KB rows: 23,004 symbols: 1,160
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 |
|---|---|---|---|---|---|---|---|
| 2000-04-20 09:30:00 | AAPL | Stock | 1.1044 | 1.1138 | 1.0647 | 1.0692 | 201409600.0 |
| 2000-04-20 10:00:00 | AAPL | Stock | 1.0692 | 1.0826 | 1.0513 | 1.0569 | 99612800.0 |
| 2000-04-20 10:30:00 | AAPL | Stock | 1.0569 | 1.0753 | 1.0569 | 1.0703 | 40734400.0 |
| 2000-04-20 11:00:00 | AAPL | Stock | 1.0703 | 1.0709 | 1.058 | 1.0647 | 34910400.0 |
| 2000-04-20 11:30:00 | AAPL | Stock | 1.0647 | 1.0692 | 1.0474 | 1.048 | 46905600.0 |
| 2000-04-20 12:00:00 | AAPL | Stock | 1.0469 | 1.0564 | 1.0463 | 1.0497 | 28929600.0 |
| 2000-04-20 12:30:00 | AAPL | Stock | 1.0502 | 1.0647 | 1.0485 | 1.0564 | 31964800.0 |
| 2000-04-20 13:00:00 | AAPL | Stock | 1.058 | 1.067 | 1.0541 | 1.0569 | 21280000.0 |
| 2000-04-20 13:30:00 | AAPL | Stock | 1.0569 | 1.0636 | 1.0564 | 1.0625 | 16654400.0 |
| 2000-04-20 14:00:00 | AAPL | Stock | 1.0625 | 1.0636 | 1.0513 | 1.0592 | 12084800.0 |
| 2000-04-20 14:30:00 | AAPL | Stock | 1.0592 | 1.0714 | 1.058 | 1.0647 | 21246400.0 |
| 2000-04-20 15:00:00 | AAPL | Stock | 1.0647 | 1.0675 | 1.0558 | 1.0614 | 25132800.0 |
| 2000-04-20 15:30:00 | AAPL | Stock | 1.0625 | 1.0636 | 1.0536 | 1.0619 | 47096000.0 |
| 2000-04-20 16:00:00 | AAPL | Stock | 1.0619 | 1.0619 | 1.0603 | 1.0614 | 1176000.0 |
| 2000-04-20 09:30:00 | MSFT | Stock | 39.3125 | 39.9375 | 39.1562 | 39.3438 | 8474600.0 |
| 2000-04-20 10:00:00 | MSFT | Stock | 39.3438 | 39.5938 | 39.0938 | 39.5312 | 4221400.0 |
| 2000-04-20 10:30:00 | MSFT | Stock | 39.5625 | 39.625 | 39.2812 | 39.4062 | 3803600.0 |
| 2000-04-20 11:00:00 | MSFT | Stock | 39.4062 | 39.6562 | 39.375 | 39.5312 | 1764600.0 |
| 2000-04-20 11:30:00 | MSFT | Stock | 39.5 | 39.5312 | 39.125 | 39.125 | 2285400.0 |
| 2000-04-20 12:00:00 | MSFT | Stock | 39.125 | 39.25 | 38.75 | 38.875 | 4121000.0 |
| 2000-04-20 12:30:00 | MSFT | Stock | 38.8438 | 39.1875 | 38.7812 | 38.9375 | 3045200.0 |
| 2000-04-20 13:00:00 | MSFT | Stock | 38.9688 | 39.375 | 38.9375 | 39.375 | 1818000.0 |
| 2000-04-20 13:30:00 | MSFT | Stock | 39.375 | 39.4375 | 39.2188 | 39.375 | 1669200.0 |
| 2000-04-20 14:00:00 | MSFT | Stock | 39.3906 | 39.5625 | 39.0 | 39.1562 | 1919000.0 |
| 2000-04-20 14:30:00 | MSFT | Stock | 39.1562 | 39.4062 | 39.125 | 39.3438 | 2132200.0 |
| 2000-04-20 15:00:00 | MSFT | Stock | 39.3438 | 39.5938 | 39.2188 | 39.5 | 2881200.0 |
| 2000-04-20 15:30:00 | MSFT | Stock | 39.5312 | 39.5938 | 39.25 | 39.5 | 4888800.0 |
| 2000-04-20 16:00:00 | MSFT | Stock | 39.5 | 39.5 | 39.4688 | 39.4688 | 208600.0 |
| 2000-04-20 09:30:00 | NVDA | Stock | 0.1734 | 0.1767 | 0.1719 | 0.1719 | 17712000.0 |
| 2000-04-20 10:00:00 | NVDA | Stock | 0.1719 | 0.1719 | 0.1667 | 0.1706 | 16320000.0 |
| 2000-04-20 10:30:00 | NVDA | Stock | 0.1707 | 0.1719 | 0.1689 | 0.1698 | 13680000.0 |
| 2000-04-20 11:00:00 | NVDA | Stock | 0.1693 | 0.1704 | 0.1687 | 0.1687 | 9024000.0 |
| 2000-04-20 11:30:00 | NVDA | Stock | 0.168 | 0.1698 | 0.1677 | 0.1687 | 4176000.0 |
| 2000-04-20 12:00:00 | NVDA | Stock | 0.1677 | 0.1686 | 0.1677 | 0.1681 | 7584000.0 |
| 2000-04-20 12:30:00 | NVDA | Stock | 0.1677 | 0.1687 | 0.1674 | 0.1677 | 10176000.0 |
| 2000-04-20 13:00:00 | NVDA | Stock | 0.1676 | 0.1677 | 0.1667 | 0.1668 | 12528000.0 |
| 2000-04-20 13:30:00 | NVDA | Stock | 0.1667 | 0.1672 | 0.1656 | 0.1661 | 13056000.0 |
| 2000-04-20 14:00:00 | NVDA | Stock | 0.1667 | 0.1672 | 0.1658 | 0.1661 | 8736000.0 |
| 2000-04-20 14:30:00 | NVDA | Stock | 0.1661 | 0.1674 | 0.1656 | 0.1674 | 14256000.0 |
| 2000-04-20 15:00:00 | NVDA | Stock | 0.1667 | 0.1719 | 0.1661 | 0.1698 | 8160000.0 |
| 2000-04-20 15:30:00 | NVDA | Stock | 0.1694 | 0.1708 | 0.166 | 0.168 | 11424000.0 |
| 2000-04-20 16:00:00 | NVDA | Stock | 0.1668 | 0.168 | 0.1668 | 0.168 | 2352000.0 |
| 2000-04-20 09:30:00 | AMZN | Stock | 2.6688 | 2.6844 | 2.6094 | 2.6297 | 11346000.0 |
| 2000-04-20 10:00:00 | AMZN | Stock | 2.6312 | 2.6375 | 2.5594 | 2.5719 | 8932000.0 |
| 2000-04-20 10:30:00 | AMZN | Stock | 2.5719 | 2.6031 | 2.5563 | 2.5625 | 3820000.0 |
| 2000-04-20 11:00:00 | AMZN | Stock | 2.5625 | 2.5875 | 2.55 | 2.5781 | 3980000.0 |
| 2000-04-20 11:30:00 | AMZN | Stock | 2.5781 | 2.6094 | 2.5625 | 2.5656 | 4756000.0 |
| 2000-04-20 12:00:00 | AMZN | Stock | 2.5656 | 2.5844 | 2.5031 | 2.5062 | 7544000.0 |
| 2000-04-20 12:30:00 | AMZN | Stock | 2.5031 | 2.625 | 2.5031 | 2.575 | 6286000.0 |
| 2000-04-20 13:00:00 | AMZN | Stock | 2.5656 | 2.6 | 2.5656 | 2.5781 | 4648000.0 |
> showing 50 of 23,004 rows — these rows as CSV