PREVIEW / stock_30min / 2005-10-18
file: by_date/stock_30min/2005/2005-10-18.parquet size: 851 KB rows: 46,164 symbols: 2,088
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-10-18 08:00:00 | AAPL | Stock | 1.9107 | 1.9107 | 1.8707 | 1.9054 | 602532.0 |
| 2005-10-18 08:30:00 | AAPL | Stock | 1.9054 | 1.9086 | 1.8971 | 1.9061 | 714224.0 |
| 2005-10-18 09:00:00 | AAPL | Stock | 1.9032 | 1.9061 | 1.8957 | 1.9014 | 837900.0 |
| 2005-10-18 09:30:00 | AAPL | Stock | 1.9018 | 1.9211 | 1.8957 | 1.9154 | 79060604.0 |
| 2005-10-18 10:00:00 | AAPL | Stock | 1.9146 | 1.9268 | 1.9071 | 1.9132 | 83030752.0 |
| 2005-10-18 10:30:00 | AAPL | Stock | 1.9132 | 1.9164 | 1.9007 | 1.9054 | 49281008.0 |
| 2005-10-18 11:00:00 | AAPL | Stock | 1.9057 | 1.9121 | 1.8968 | 1.8982 | 38718848.0 |
| 2005-10-18 11:30:00 | AAPL | Stock | 1.8982 | 1.9014 | 1.8907 | 1.8946 | 34134604.0 |
| 2005-10-18 12:00:00 | AAPL | Stock | 1.895 | 1.8971 | 1.8896 | 1.8954 | 24087616.0 |
| 2005-10-18 12:30:00 | AAPL | Stock | 1.8954 | 1.8961 | 1.8896 | 1.8896 | 17951164.0 |
| 2005-10-18 13:00:00 | AAPL | Stock | 1.8896 | 1.8907 | 1.8757 | 1.8793 | 43315160.0 |
| 2005-10-18 13:30:00 | AAPL | Stock | 1.8793 | 1.8846 | 1.8693 | 1.8843 | 44136204.0 |
| 2005-10-18 14:00:00 | AAPL | Stock | 1.8843 | 1.8911 | 1.8807 | 1.8821 | 26559148.0 |
| 2005-10-18 14:30:00 | AAPL | Stock | 1.8821 | 1.8889 | 1.87 | 1.8746 | 41767824.0 |
| 2005-10-18 15:00:00 | AAPL | Stock | 1.8743 | 1.9168 | 1.8643 | 1.8796 | 48203652.0 |
| 2005-10-18 15:30:00 | AAPL | Stock | 1.88 | 1.8836 | 1.865 | 1.8654 | 58220316.0 |
| 2005-10-18 16:00:00 | AAPL | Stock | 1.865 | 1.8766 | 1.8636 | 1.8675 | 5910856.0 |
| 2005-10-18 16:30:00 | AAPL | Stock | 1.8693 | 1.8696 | 1.8614 | 1.8639 | 970396.0 |
| 2005-10-18 17:00:00 | AAPL | Stock | 1.8675 | 1.8952 | 1.8589 | 1.8629 | 753704.0 |
| 2005-10-18 17:30:00 | AAPL | Stock | 1.8661 | 1.8696 | 1.8661 | 1.8696 | 40880.0 |
| 2005-10-18 18:00:00 | AAPL | Stock | 1.8661 | 1.8661 | 1.8661 | 1.8661 | 16800.0 |
| 2005-10-18 08:00:00 | MSFT | Stock | 24.56 | 24.56 | 24.53 | 24.56 | 24524.0 |
| 2005-10-18 08:30:00 | MSFT | Stock | 24.53 | 24.54 | 24.5 | 24.54 | 12322.0 |
| 2005-10-18 09:00:00 | MSFT | Stock | 24.55 | 24.63 | 24.46 | 24.46 | 89864.0 |
| 2005-10-18 09:30:00 | MSFT | Stock | 24.49 | 24.59 | 24.45 | 24.58 | 6768933.0 |
| 2005-10-18 10:00:00 | MSFT | Stock | 24.59 | 24.681 | 24.56 | 24.66 | 7650897.0 |
| 2005-10-18 10:30:00 | MSFT | Stock | 24.66 | 24.69 | 24.58 | 24.68 | 5300983.0 |
| 2005-10-18 11:00:00 | MSFT | Stock | 24.68 | 24.83 | 24.64 | 24.77 | 7894016.0 |
| 2005-10-18 11:30:00 | MSFT | Stock | 24.76 | 24.78 | 24.67 | 24.68 | 3323541.0 |
| 2005-10-18 12:00:00 | MSFT | Stock | 24.672 | 24.74 | 24.67 | 24.7 | 2055133.0 |
| 2005-10-18 12:30:00 | MSFT | Stock | 24.69 | 24.73 | 24.68 | 24.7 | 1554923.0 |
| 2005-10-18 13:00:00 | MSFT | Stock | 24.7 | 24.72 | 24.65 | 24.72 | 4182784.0 |
| 2005-10-18 13:30:00 | MSFT | Stock | 24.72 | 24.72 | 24.64 | 24.69 | 3419200.0 |
| 2005-10-18 14:00:00 | MSFT | Stock | 24.69 | 24.73 | 24.67 | 24.72 | 2182070.0 |
| 2005-10-18 14:30:00 | MSFT | Stock | 24.71 | 24.77 | 24.65 | 24.65 | 4474743.0 |
| 2005-10-18 15:00:00 | MSFT | Stock | 24.66 | 24.66 | 24.59 | 24.65 | 11864589.0 |
| 2005-10-18 15:30:00 | MSFT | Stock | 24.65 | 24.69 | 24.56 | 24.57 | 6654040.0 |
| 2005-10-18 16:00:00 | MSFT | Stock | 24.57 | 24.63 | 24.5 | 24.6 | 263772.0 |
| 2005-10-18 16:30:00 | MSFT | Stock | 24.53 | 24.58 | 24.45 | 24.46 | 100166.0 |
| 2005-10-18 17:00:00 | MSFT | Stock | 24.45 | 24.5 | 24.45 | 24.47 | 3190.0 |
| 2005-10-18 17:30:00 | MSFT | Stock | 24.49 | 24.52 | 24.49 | 24.52 | 600.0 |
| 2005-10-18 18:00:00 | MSFT | Stock | 24.56 | 24.56 | 24.5 | 24.5 | 316400.0 |
| 2005-10-18 09:00:00 | NVDA | Stock | 0.2698 | 0.2704 | 0.2694 | 0.2704 | 115800.0 |
| 2005-10-18 09:30:00 | NVDA | Stock | 0.2705 | 0.271 | 0.2647 | 0.2648 | 27956160.0 |
| 2005-10-18 10:00:00 | NVDA | Stock | 0.2648 | 0.2678 | 0.2647 | 0.2667 | 35833320.0 |
| 2005-10-18 10:30:00 | NVDA | Stock | 0.2667 | 0.2667 | 0.2657 | 0.2664 | 29365080.0 |
| 2005-10-18 11:00:00 | NVDA | Stock | 0.2666 | 0.2675 | 0.2656 | 0.2656 | 22087320.0 |
| 2005-10-18 11:30:00 | NVDA | Stock | 0.2655 | 0.266 | 0.2652 | 0.2654 | 7949880.0 |
| 2005-10-18 12:00:00 | NVDA | Stock | 0.2654 | 0.2667 | 0.2654 | 0.2663 | 9298680.0 |
| 2005-10-18 12:30:00 | NVDA | Stock | 0.2663 | 0.2669 | 0.2663 | 0.2666 | 7254720.0 |
> showing 50 of 46,164 rows — these rows as CSV