PREVIEW / stock_30min / 2005-09-08
file: by_date/stock_30min/2005/2005-09-08.parquet size: 834 KB rows: 45,606 symbols: 2,062
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-08 07:00:00 | AAPL | Stock | 1.7768 | 1.7768 | 1.7536 | 1.7675 | 506100.0 |
| 2005-09-08 07:30:00 | AAPL | Stock | 1.7643 | 1.7643 | 1.7607 | 1.7643 | 157080.0 |
| 2005-09-08 08:00:00 | AAPL | Stock | 1.7679 | 1.7679 | 1.7532 | 1.7554 | 4194456.0 |
| 2005-09-08 08:30:00 | AAPL | Stock | 1.7561 | 1.7639 | 1.7529 | 1.7632 | 2080176.0 |
| 2005-09-08 09:00:00 | AAPL | Stock | 1.7632 | 1.7693 | 1.7593 | 1.7625 | 5609856.0 |
| 2005-09-08 09:30:00 | AAPL | Stock | 1.7625 | 1.79 | 1.755 | 1.7818 | 186293240.0 |
| 2005-09-08 10:00:00 | AAPL | Stock | 1.7818 | 1.7836 | 1.7682 | 1.7761 | 85464960.0 |
| 2005-09-08 10:30:00 | AAPL | Stock | 1.7757 | 1.7854 | 1.7754 | 1.7814 | 53560388.0 |
| 2005-09-08 11:00:00 | AAPL | Stock | 1.7814 | 1.7818 | 1.7696 | 1.7761 | 37250444.0 |
| 2005-09-08 11:30:00 | AAPL | Stock | 1.7761 | 1.7779 | 1.7739 | 1.7768 | 22898400.0 |
| 2005-09-08 12:00:00 | AAPL | Stock | 1.7768 | 1.7836 | 1.7757 | 1.7818 | 26341784.0 |
| 2005-09-08 12:30:00 | AAPL | Stock | 1.7814 | 1.7818 | 1.775 | 1.7803 | 23970576.0 |
| 2005-09-08 13:00:00 | AAPL | Stock | 1.7804 | 1.7846 | 1.7796 | 1.7839 | 31120096.0 |
| 2005-09-08 13:30:00 | AAPL | Stock | 1.7839 | 1.7889 | 1.7779 | 1.7882 | 55530944.0 |
| 2005-09-08 14:00:00 | AAPL | Stock | 1.7886 | 1.7886 | 1.7804 | 1.7825 | 35997360.0 |
| 2005-09-08 14:30:00 | AAPL | Stock | 1.7825 | 1.7843 | 1.7768 | 1.7786 | 27216840.0 |
| 2005-09-08 15:00:00 | AAPL | Stock | 1.7779 | 1.78 | 1.7739 | 1.7775 | 38063732.0 |
| 2005-09-08 15:30:00 | AAPL | Stock | 1.7775 | 1.7818 | 1.7754 | 1.7768 | 47330024.0 |
| 2005-09-08 16:00:00 | AAPL | Stock | 1.7771 | 1.7796 | 1.7757 | 1.7764 | 1582112.0 |
| 2005-09-08 16:30:00 | AAPL | Stock | 1.7779 | 1.7796 | 1.7768 | 1.7775 | 724836.0 |
| 2005-09-08 17:00:00 | AAPL | Stock | 1.7775 | 1.7786 | 1.7768 | 1.7786 | 196364.0 |
| 2005-09-08 17:30:00 | AAPL | Stock | 1.7793 | 1.7793 | 1.7779 | 1.7779 | 124572.0 |
| 2005-09-08 18:00:00 | AAPL | Stock | 1.78 | 1.7807 | 1.7782 | 1.7786 | 75292.0 |
| 2005-09-08 08:00:00 | MSFT | Stock | 26.85 | 26.88 | 26.8 | 26.83 | 2535.0 |
| 2005-09-08 08:30:00 | MSFT | Stock | 26.82 | 26.83 | 26.81 | 26.82 | 2800.0 |
| 2005-09-08 09:00:00 | MSFT | Stock | 26.86 | 26.86 | 26.8 | 26.8 | 61049.0 |
| 2005-09-08 09:30:00 | MSFT | Stock | 26.8 | 26.87 | 26.71 | 26.8 | 6256834.0 |
| 2005-09-08 10:00:00 | MSFT | Stock | 26.8 | 26.84 | 26.76 | 26.79 | 2489339.0 |
| 2005-09-08 10:30:00 | MSFT | Stock | 26.78 | 26.88 | 26.77 | 26.831 | 4751449.0 |
| 2005-09-08 11:00:00 | MSFT | Stock | 26.83 | 26.87 | 26.81 | 26.83 | 2236622.0 |
| 2005-09-08 11:30:00 | MSFT | Stock | 26.83 | 26.88 | 26.8 | 26.81 | 2551794.0 |
| 2005-09-08 12:00:00 | MSFT | Stock | 26.85 | 26.85 | 26.74 | 26.81 | 2934909.0 |
| 2005-09-08 12:30:00 | MSFT | Stock | 26.801 | 26.81 | 26.7 | 26.72 | 2558514.0 |
| 2005-09-08 13:00:00 | MSFT | Stock | 26.71 | 26.85 | 26.69 | 26.701 | 1850583.0 |
| 2005-09-08 13:30:00 | MSFT | Stock | 26.71 | 26.74 | 26.69 | 26.69 | 2956067.0 |
| 2005-09-08 14:00:00 | MSFT | Stock | 26.69 | 26.7 | 26.55 | 26.56 | 5243273.0 |
| 2005-09-08 14:30:00 | MSFT | Stock | 26.57 | 26.6 | 26.52 | 26.57 | 5074217.0 |
| 2005-09-08 15:00:00 | MSFT | Stock | 26.57 | 26.58 | 26.52 | 26.57 | 4704912.0 |
| 2005-09-08 15:30:00 | MSFT | Stock | 26.57 | 26.63 | 26.56 | 26.59 | 5336275.0 |
| 2005-09-08 16:00:00 | MSFT | Stock | 26.59 | 26.64 | 26.55 | 26.6 | 142479.0 |
| 2005-09-08 16:30:00 | MSFT | Stock | 26.6 | 26.64 | 26.59 | 26.62 | 62166.0 |
| 2005-09-08 17:00:00 | MSFT | Stock | 26.63 | 26.63 | 26.61 | 26.61 | 2260.0 |
| 2005-09-08 17:30:00 | MSFT | Stock | 26.61 | 26.64 | 26.61 | 26.61 | 37868.0 |
| 2005-09-08 18:00:00 | MSFT | Stock | 26.63 | 26.65 | 26.63 | 26.65 | 3164.0 |
| 2005-09-08 08:00:00 | NVDA | Stock | 0.2596 | 0.2596 | 0.2596 | 0.2596 | 18000.0 |
| 2005-09-08 09:00:00 | NVDA | Stock | 0.2602 | 0.2612 | 0.2597 | 0.2602 | 1052400.0 |
| 2005-09-08 09:30:00 | NVDA | Stock | 0.2602 | 0.2665 | 0.2602 | 0.2649 | 97391880.0 |
| 2005-09-08 10:00:00 | NVDA | Stock | 0.2649 | 0.2667 | 0.2648 | 0.2661 | 94781040.0 |
| 2005-09-08 10:30:00 | NVDA | Stock | 0.266 | 0.2681 | 0.2651 | 0.2654 | 87078480.0 |
| 2005-09-08 11:00:00 | NVDA | Stock | 0.2653 | 0.2668 | 0.2641 | 0.2661 | 47835600.0 |
> showing 50 of 45,606 rows — these rows as CSV