PREVIEW / stock_30min / 2002-07-18
file: by_date/stock_30min/2002/2002-07-18.parquet size: 584 KB rows: 30,596 symbols: 1,437
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-18 08:00:00 | AAPL | Stock | 0.2813 | 0.2841 | 0.275 | 0.2829 | 78400.0 |
| 2002-07-18 08:30:00 | AAPL | Stock | 0.2798 | 0.2798 | 0.2786 | 0.2786 | 246400.0 |
| 2002-07-18 09:00:00 | AAPL | Stock | 0.2795 | 0.2795 | 0.2764 | 0.277 | 896000.0 |
| 2002-07-18 09:30:00 | AAPL | Stock | 0.2768 | 0.2779 | 0.2721 | 0.2757 | 56711200.0 |
| 2002-07-18 10:00:00 | AAPL | Stock | 0.2755 | 0.2759 | 0.2695 | 0.2702 | 60334400.0 |
| 2002-07-18 10:30:00 | AAPL | Stock | 0.2698 | 0.272 | 0.268 | 0.2681 | 51240000.0 |
| 2002-07-18 11:00:00 | AAPL | Stock | 0.268 | 0.2716 | 0.2675 | 0.2709 | 49526400.0 |
| 2002-07-18 11:30:00 | AAPL | Stock | 0.2709 | 0.2714 | 0.2686 | 0.2702 | 22629600.0 |
| 2002-07-18 12:00:00 | AAPL | Stock | 0.2702 | 0.2713 | 0.2689 | 0.2696 | 14224000.0 |
| 2002-07-18 12:30:00 | AAPL | Stock | 0.2695 | 0.2707 | 0.2689 | 0.2696 | 23049600.0 |
| 2002-07-18 13:00:00 | AAPL | Stock | 0.2695 | 0.2707 | 0.2689 | 0.2698 | 17533600.0 |
| 2002-07-18 13:30:00 | AAPL | Stock | 0.2698 | 0.2705 | 0.268 | 0.268 | 20288800.0 |
| 2002-07-18 14:00:00 | AAPL | Stock | 0.2684 | 0.2686 | 0.2648 | 0.2655 | 37615200.0 |
| 2002-07-18 14:30:00 | AAPL | Stock | 0.2652 | 0.2675 | 0.2648 | 0.2655 | 24992800.0 |
| 2002-07-18 15:00:00 | AAPL | Stock | 0.2654 | 0.2679 | 0.2652 | 0.2657 | 33678400.0 |
| 2002-07-18 15:30:00 | AAPL | Stock | 0.2655 | 0.2688 | 0.2634 | 0.2675 | 73376800.0 |
| 2002-07-18 16:00:00 | AAPL | Stock | 0.2677 | 0.2684 | 0.267 | 0.2677 | 10130400.0 |
| 2002-07-18 16:30:00 | AAPL | Stock | 0.2677 | 0.2677 | 0.2671 | 0.2677 | 2111200.0 |
| 2002-07-18 17:00:00 | AAPL | Stock | 0.2677 | 0.2677 | 0.2677 | 0.2677 | 162400.0 |
| 2002-07-18 08:00:00 | MSFT | Stock | 25.985 | 26.04 | 25.875 | 26.04 | 28600.0 |
| 2002-07-18 08:30:00 | MSFT | Stock | 26.099 | 26.165 | 26.005 | 26.075 | 32800.0 |
| 2002-07-18 09:00:00 | MSFT | Stock | 26.075 | 26.125 | 25.8565 | 26.025 | 175200.0 |
| 2002-07-18 09:30:00 | MSFT | Stock | 26.03 | 26.15 | 25.68 | 25.785 | 9579200.0 |
| 2002-07-18 10:00:00 | MSFT | Stock | 25.78 | 25.945 | 25.615 | 25.79 | 8322400.0 |
| 2002-07-18 10:30:00 | MSFT | Stock | 25.795 | 25.9 | 25.7735 | 25.825 | 4647800.0 |
| 2002-07-18 11:00:00 | MSFT | Stock | 25.825 | 26.027 | 25.805 | 25.915 | 4261400.0 |
| 2002-07-18 11:30:00 | MSFT | Stock | 25.925 | 26.11 | 25.87 | 26.0865 | 4487200.0 |
| 2002-07-18 12:00:00 | MSFT | Stock | 26.06 | 26.37 | 26.035 | 26.245 | 3177800.0 |
| 2002-07-18 12:30:00 | MSFT | Stock | 26.25 | 26.2615 | 25.98 | 26.018 | 2414400.0 |
| 2002-07-18 13:00:00 | MSFT | Stock | 26.015 | 26.21 | 25.995 | 26.06 | 2046000.0 |
| 2002-07-18 13:30:00 | MSFT | Stock | 26.06 | 26.0605 | 25.875 | 25.99 | 4121200.0 |
| 2002-07-18 14:00:00 | MSFT | Stock | 25.99 | 26.015 | 25.735 | 25.835 | 4209000.0 |
| 2002-07-18 14:30:00 | MSFT | Stock | 25.835 | 25.835 | 25.48 | 25.56 | 6151200.0 |
| 2002-07-18 15:00:00 | MSFT | Stock | 25.59 | 25.665 | 25.365 | 25.4725 | 6597600.0 |
| 2002-07-18 15:30:00 | MSFT | Stock | 25.475 | 25.58 | 25.33 | 25.555 | 11068200.0 |
| 2002-07-18 16:00:00 | MSFT | Stock | 25.56 | 26.0 | 25.35 | 25.435 | 2793400.0 |
| 2002-07-18 16:30:00 | MSFT | Stock | 25.455 | 26.0 | 24.9 | 25.425 | 4383600.0 |
| 2002-07-18 17:00:00 | MSFT | Stock | 25.4 | 26.0798 | 25.25 | 25.3 | 766600.0 |
| 2002-07-18 17:30:00 | MSFT | Stock | 25.295 | 25.54 | 25.26 | 25.365 | 452000.0 |
| 2002-07-18 18:00:00 | MSFT | Stock | 25.37 | 25.44 | 25.27 | 25.3 | 207600.0 |
| 2002-07-18 08:00:00 | NVDA | Stock | 0.1592 | 0.1592 | 0.1583 | 0.1583 | 528000.0 |
| 2002-07-18 08:30:00 | NVDA | Stock | 0.1608 | 0.1628 | 0.1608 | 0.1617 | 1788000.0 |
| 2002-07-18 09:00:00 | NVDA | Stock | 0.1596 | 0.1608 | 0.1593 | 0.1597 | 5100000.0 |
| 2002-07-18 09:30:00 | NVDA | Stock | 0.1597 | 0.1621 | 0.1581 | 0.1599 | 169416000.0 |
| 2002-07-18 10:00:00 | NVDA | Stock | 0.1603 | 0.1647 | 0.1593 | 0.1627 | 130968000.0 |
| 2002-07-18 10:30:00 | NVDA | Stock | 0.1628 | 0.1656 | 0.1627 | 0.1646 | 88044000.0 |
| 2002-07-18 11:00:00 | NVDA | Stock | 0.1646 | 0.1665 | 0.1635 | 0.1653 | 77268000.0 |
| 2002-07-18 11:30:00 | NVDA | Stock | 0.165 | 0.1683 | 0.1634 | 0.1677 | 69276000.0 |
| 2002-07-18 12:00:00 | NVDA | Stock | 0.1677 | 0.1692 | 0.1658 | 0.1665 | 28356000.0 |
| 2002-07-18 12:30:00 | NVDA | Stock | 0.1664 | 0.1665 | 0.1635 | 0.1637 | 36456000.0 |
> showing 50 of 30,596 rows — these rows as CSV