PREVIEW / stock_30min / 2002-07-19
file: by_date/stock_30min/2002/2002-07-19.parquet size: 607 KB rows: 31,808 symbols: 1,452
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-19 08:00:00 | AAPL | Stock | 0.2675 | 0.2675 | 0.2634 | 0.2634 | 123200.0 |
| 2002-07-19 08:30:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2632 | 0.2632 | 50400.0 |
| 2002-07-19 09:00:00 | AAPL | Stock | 0.2629 | 0.2632 | 0.2625 | 0.2627 | 907200.0 |
| 2002-07-19 09:30:00 | AAPL | Stock | 0.2625 | 0.2663 | 0.2595 | 0.2643 | 63336000.0 |
| 2002-07-19 10:00:00 | AAPL | Stock | 0.2643 | 0.2709 | 0.2634 | 0.2654 | 43954400.0 |
| 2002-07-19 10:30:00 | AAPL | Stock | 0.2656 | 0.2695 | 0.2643 | 0.2666 | 19678400.0 |
| 2002-07-19 11:00:00 | AAPL | Stock | 0.2661 | 0.2693 | 0.2652 | 0.2686 | 17477600.0 |
| 2002-07-19 11:30:00 | AAPL | Stock | 0.2686 | 0.2686 | 0.2668 | 0.2677 | 9856000.0 |
| 2002-07-19 12:00:00 | AAPL | Stock | 0.2677 | 0.2695 | 0.267 | 0.2671 | 19202400.0 |
| 2002-07-19 12:30:00 | AAPL | Stock | 0.2671 | 0.268 | 0.2663 | 0.2673 | 23396800.0 |
| 2002-07-19 13:00:00 | AAPL | Stock | 0.2671 | 0.2684 | 0.266 | 0.2673 | 23508800.0 |
| 2002-07-19 13:30:00 | AAPL | Stock | 0.2675 | 0.2695 | 0.2671 | 0.2673 | 17483200.0 |
| 2002-07-19 14:00:00 | AAPL | Stock | 0.2675 | 0.2684 | 0.2664 | 0.268 | 16032800.0 |
| 2002-07-19 14:30:00 | AAPL | Stock | 0.2682 | 0.2686 | 0.2673 | 0.2675 | 36058400.0 |
| 2002-07-19 15:00:00 | AAPL | Stock | 0.2675 | 0.2684 | 0.267 | 0.2672 | 21632800.0 |
| 2002-07-19 15:30:00 | AAPL | Stock | 0.2673 | 0.2673 | 0.2654 | 0.2671 | 43971200.0 |
| 2002-07-19 16:00:00 | AAPL | Stock | 0.2671 | 0.2675 | 0.2661 | 0.2671 | 7571200.0 |
| 2002-07-19 16:30:00 | AAPL | Stock | 0.2671 | 0.2671 | 0.267 | 0.2671 | 588000.0 |
| 2002-07-19 17:00:00 | AAPL | Stock | 0.2687 | 0.2688 | 0.2664 | 0.2664 | 100800.0 |
| 2002-07-19 17:30:00 | AAPL | Stock | 0.2664 | 0.2664 | 0.2664 | 0.2664 | 11200.0 |
| 2002-07-19 08:00:00 | MSFT | Stock | 25.25 | 25.385 | 25.026 | 25.1055 | 324200.0 |
| 2002-07-19 08:30:00 | MSFT | Stock | 25.105 | 25.555 | 25.015 | 25.275 | 1066800.0 |
| 2002-07-19 09:00:00 | MSFT | Stock | 25.25 | 25.515 | 24.9 | 24.925 | 1941000.0 |
| 2002-07-19 09:30:00 | MSFT | Stock | 24.935 | 25.2 | 24.875 | 25.1385 | 18943200.0 |
| 2002-07-19 10:00:00 | MSFT | Stock | 25.148 | 25.445 | 25.0525 | 25.225 | 12303800.0 |
| 2002-07-19 10:30:00 | MSFT | Stock | 25.22 | 25.4 | 25.135 | 25.235 | 5488400.0 |
| 2002-07-19 11:00:00 | MSFT | Stock | 25.235 | 25.28 | 25.075 | 25.1405 | 5469000.0 |
| 2002-07-19 11:30:00 | MSFT | Stock | 25.145 | 25.17 | 24.9 | 24.985 | 5658400.0 |
| 2002-07-19 12:00:00 | MSFT | Stock | 24.975 | 25.095 | 24.965 | 25.035 | 3651400.0 |
| 2002-07-19 12:30:00 | MSFT | Stock | 25.03 | 25.09 | 24.935 | 24.95 | 4520400.0 |
| 2002-07-19 13:00:00 | MSFT | Stock | 24.95 | 25.04 | 24.825 | 24.895 | 4470200.0 |
| 2002-07-19 13:30:00 | MSFT | Stock | 24.89 | 25.145 | 24.885 | 24.985 | 4489600.0 |
| 2002-07-19 14:00:00 | MSFT | Stock | 24.98 | 25.121 | 24.925 | 24.995 | 3726400.0 |
| 2002-07-19 14:30:00 | MSFT | Stock | 24.9955 | 25.1 | 24.93 | 25.085 | 4917200.0 |
| 2002-07-19 15:00:00 | MSFT | Stock | 25.085 | 25.085 | 24.94 | 25.0 | 5955400.0 |
| 2002-07-19 15:30:00 | MSFT | Stock | 25.0 | 25.02 | 24.406 | 24.7775 | 18699400.0 |
| 2002-07-19 16:00:00 | MSFT | Stock | 24.79 | 25.0 | 24.675 | 24.78 | 4530600.0 |
| 2002-07-19 16:30:00 | MSFT | Stock | 24.7 | 24.9516 | 24.65 | 24.9516 | 879600.0 |
| 2002-07-19 17:00:00 | MSFT | Stock | 24.65 | 24.79 | 24.605 | 24.61 | 541400.0 |
| 2002-07-19 17:30:00 | MSFT | Stock | 24.61 | 24.675 | 24.61 | 24.645 | 6400.0 |
| 2002-07-19 18:00:00 | MSFT | Stock | 24.65 | 24.78 | 24.605 | 24.78 | 29000.0 |
| 2002-07-19 08:00:00 | NVDA | Stock | 0.1567 | 0.1567 | 0.1543 | 0.1543 | 1044000.0 |
| 2002-07-19 08:30:00 | NVDA | Stock | 0.1543 | 0.1548 | 0.1542 | 0.1548 | 1032000.0 |
| 2002-07-19 09:00:00 | NVDA | Stock | 0.1582 | 0.1582 | 0.1532 | 0.1533 | 2304000.0 |
| 2002-07-19 09:30:00 | NVDA | Stock | 0.1534 | 0.1572 | 0.1517 | 0.1562 | 128400000.0 |
| 2002-07-19 10:00:00 | NVDA | Stock | 0.1562 | 0.1595 | 0.1552 | 0.1558 | 112812000.0 |
| 2002-07-19 10:30:00 | NVDA | Stock | 0.1558 | 0.1586 | 0.1543 | 0.1559 | 72156000.0 |
| 2002-07-19 11:00:00 | NVDA | Stock | 0.1559 | 0.1567 | 0.1543 | 0.1554 | 33816000.0 |
| 2002-07-19 11:30:00 | NVDA | Stock | 0.1556 | 0.1561 | 0.1542 | 0.1554 | 35052000.0 |
| 2002-07-19 12:00:00 | NVDA | Stock | 0.1554 | 0.1567 | 0.1547 | 0.1551 | 28128000.0 |
> showing 50 of 31,808 rows — these rows as CSV