PREVIEW / stock_30min / 2005-09-21
file: by_date/stock_30min/2005/2005-09-21.parquet size: 867 KB rows: 46,602 symbols: 2,071
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-09-21 08:00:00 | AAPL | Stock | 1.9 | 1.9004 | 1.8929 | 1.8929 | 471800.0 |
| 2005-09-21 08:30:00 | AAPL | Stock | 1.8975 | 1.8975 | 1.8871 | 1.8911 | 257544.0 |
| 2005-09-21 09:00:00 | AAPL | Stock | 1.8893 | 1.8943 | 1.8879 | 1.8925 | 444584.0 |
| 2005-09-21 09:30:00 | AAPL | Stock | 1.8914 | 1.8946 | 1.8707 | 1.8879 | 73577196.0 |
| 2005-09-21 10:00:00 | AAPL | Stock | 1.8875 | 1.8893 | 1.88 | 1.8846 | 34722828.0 |
| 2005-09-21 10:30:00 | AAPL | Stock | 1.8846 | 1.8939 | 1.8825 | 1.8886 | 34252540.0 |
| 2005-09-21 11:00:00 | AAPL | Stock | 1.8886 | 1.8893 | 1.8714 | 1.8729 | 32434080.0 |
| 2005-09-21 11:30:00 | AAPL | Stock | 1.8729 | 1.875 | 1.8546 | 1.8557 | 42247772.0 |
| 2005-09-21 12:00:00 | AAPL | Stock | 1.856 | 1.8671 | 1.8521 | 1.8632 | 30015608.0 |
| 2005-09-21 12:30:00 | AAPL | Stock | 1.8632 | 1.8718 | 1.8607 | 1.8718 | 15870512.0 |
| 2005-09-21 13:00:00 | AAPL | Stock | 1.8717 | 1.875 | 1.8661 | 1.8689 | 21435400.0 |
| 2005-09-21 13:30:00 | AAPL | Stock | 1.8693 | 1.8707 | 1.8571 | 1.8629 | 25887428.0 |
| 2005-09-21 14:00:00 | AAPL | Stock | 1.8625 | 1.8886 | 1.8586 | 1.8689 | 29549352.0 |
| 2005-09-21 14:30:00 | AAPL | Stock | 1.8679 | 1.8693 | 1.8621 | 1.8668 | 23489536.0 |
| 2005-09-21 15:00:00 | AAPL | Stock | 1.8671 | 1.8875 | 1.8571 | 1.8596 | 24333708.0 |
| 2005-09-21 15:30:00 | AAPL | Stock | 1.8593 | 1.8636 | 1.8571 | 1.8607 | 36351644.0 |
| 2005-09-21 16:00:00 | AAPL | Stock | 1.8611 | 1.8625 | 1.86 | 1.86 | 2122008.0 |
| 2005-09-21 16:30:00 | AAPL | Stock | 1.86 | 1.8921 | 1.86 | 1.8625 | 382424.0 |
| 2005-09-21 17:00:00 | AAPL | Stock | 1.8705 | 1.8705 | 1.8654 | 1.8654 | 1338400.0 |
| 2005-09-21 17:30:00 | AAPL | Stock | 1.8621 | 1.8717 | 1.8621 | 1.8636 | 949396.0 |
| 2005-09-21 18:00:00 | AAPL | Stock | 1.8639 | 1.8639 | 1.8614 | 1.8614 | 19936.0 |
| 2005-09-21 08:00:00 | MSFT | Stock | 25.82 | 25.82 | 25.79 | 25.81 | 7000.0 |
| 2005-09-21 08:30:00 | MSFT | Stock | 25.81 | 25.81 | 25.77 | 25.79 | 6686.0 |
| 2005-09-21 09:00:00 | MSFT | Stock | 25.78 | 25.8 | 25.74 | 25.8 | 128829.0 |
| 2005-09-21 09:30:00 | MSFT | Stock | 25.8 | 25.81 | 25.56 | 25.63 | 12433458.0 |
| 2005-09-21 10:00:00 | MSFT | Stock | 25.63 | 25.67 | 25.55 | 25.58 | 6522024.0 |
| 2005-09-21 10:30:00 | MSFT | Stock | 25.58 | 25.65 | 25.58 | 25.62 | 4481171.0 |
| 2005-09-21 11:00:00 | MSFT | Stock | 25.61 | 25.64 | 25.519 | 25.53 | 4860687.0 |
| 2005-09-21 11:30:00 | MSFT | Stock | 25.53 | 25.561 | 25.519 | 25.532 | 4340955.0 |
| 2005-09-21 12:00:00 | MSFT | Stock | 25.54 | 25.58 | 25.51 | 25.559 | 2621211.0 |
| 2005-09-21 12:30:00 | MSFT | Stock | 25.55 | 25.61 | 25.54 | 25.57 | 2098162.0 |
| 2005-09-21 13:00:00 | MSFT | Stock | 25.58 | 25.6 | 25.54 | 25.54 | 1778487.0 |
| 2005-09-21 13:30:00 | MSFT | Stock | 25.55 | 25.66 | 25.499 | 25.52 | 4495743.0 |
| 2005-09-21 14:00:00 | MSFT | Stock | 25.51 | 25.62 | 25.499 | 25.591 | 4613501.0 |
| 2005-09-21 14:30:00 | MSFT | Stock | 25.6 | 25.9 | 25.549 | 25.61 | 3450077.0 |
| 2005-09-21 15:00:00 | MSFT | Stock | 25.61 | 25.67 | 25.49 | 25.5 | 3981190.0 |
| 2005-09-21 15:30:00 | MSFT | Stock | 25.5 | 25.56 | 25.43 | 25.48 | 10330518.0 |
| 2005-09-21 16:00:00 | MSFT | Stock | 25.49 | 25.54 | 25.48 | 25.51 | 593913.0 |
| 2005-09-21 16:30:00 | MSFT | Stock | 25.52 | 25.53 | 25.52 | 25.53 | 14000.0 |
| 2005-09-21 17:00:00 | MSFT | Stock | 25.53 | 25.557 | 25.52 | 25.52 | 31890.0 |
| 2005-09-21 17:30:00 | MSFT | Stock | 25.49 | 25.572 | 25.49 | 25.52 | 161408.0 |
| 2005-09-21 18:00:00 | MSFT | Stock | 25.52 | 25.53 | 25.51 | 25.53 | 3410.0 |
| 2005-09-21 09:00:00 | NVDA | Stock | 0.2758 | 0.2786 | 0.2735 | 0.2771 | 1050000.0 |
| 2005-09-21 09:30:00 | NVDA | Stock | 0.2774 | 0.278 | 0.2742 | 0.2771 | 53165640.0 |
| 2005-09-21 10:00:00 | NVDA | Stock | 0.2771 | 0.2787 | 0.2767 | 0.2785 | 44702880.0 |
| 2005-09-21 10:30:00 | NVDA | Stock | 0.2784 | 0.2829 | 0.2778 | 0.2825 | 79509720.0 |
| 2005-09-21 11:00:00 | NVDA | Stock | 0.2826 | 0.2829 | 0.2813 | 0.2817 | 50354520.0 |
| 2005-09-21 11:30:00 | NVDA | Stock | 0.2817 | 0.2818 | 0.2756 | 0.2767 | 70777680.0 |
| 2005-09-21 12:00:00 | NVDA | Stock | 0.2767 | 0.2767 | 0.2738 | 0.2747 | 59602920.0 |
| 2005-09-21 12:30:00 | NVDA | Stock | 0.2747 | 0.2762 | 0.2737 | 0.2755 | 44165160.0 |
> showing 50 of 46,602 rows — these rows as CSV