PREVIEW / stock_30min / 2005-09-15
file: by_date/stock_30min/2005/2005-09-15.parquet size: 854 KB rows: 46,452 symbols: 2,072
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-15 08:00:00 | AAPL | Stock | 1.7789 | 1.7875 | 1.7779 | 1.7857 | 99120.0 |
| 2005-09-15 08:30:00 | AAPL | Stock | 1.7839 | 1.7943 | 1.7839 | 1.7914 | 696696.0 |
| 2005-09-15 09:00:00 | AAPL | Stock | 1.7914 | 1.7914 | 1.7821 | 1.7821 | 1686972.0 |
| 2005-09-15 09:30:00 | AAPL | Stock | 1.7857 | 1.7921 | 1.7679 | 1.7729 | 69317864.0 |
| 2005-09-15 10:00:00 | AAPL | Stock | 1.7729 | 1.7793 | 1.7618 | 1.7668 | 48545196.0 |
| 2005-09-15 10:30:00 | AAPL | Stock | 1.7668 | 1.7804 | 1.7664 | 1.7789 | 47143712.0 |
| 2005-09-15 11:00:00 | AAPL | Stock | 1.7786 | 1.7839 | 1.7764 | 1.7814 | 18862564.0 |
| 2005-09-15 11:30:00 | AAPL | Stock | 1.7814 | 1.7893 | 1.7779 | 1.7786 | 19507068.0 |
| 2005-09-15 12:00:00 | AAPL | Stock | 1.7786 | 1.7793 | 1.77 | 1.7743 | 25419688.0 |
| 2005-09-15 12:30:00 | AAPL | Stock | 1.7743 | 1.7775 | 1.7732 | 1.7754 | 12115684.0 |
| 2005-09-15 13:00:00 | AAPL | Stock | 1.775 | 1.7846 | 1.7746 | 1.7775 | 21870604.0 |
| 2005-09-15 13:30:00 | AAPL | Stock | 1.7775 | 1.7818 | 1.7764 | 1.7775 | 15608908.0 |
| 2005-09-15 14:00:00 | AAPL | Stock | 1.7775 | 1.7793 | 1.7736 | 1.775 | 21889308.0 |
| 2005-09-15 14:30:00 | AAPL | Stock | 1.7746 | 1.7807 | 1.7743 | 1.7789 | 27456688.0 |
| 2005-09-15 15:00:00 | AAPL | Stock | 1.7789 | 1.7818 | 1.7768 | 1.7818 | 19243616.0 |
| 2005-09-15 15:30:00 | AAPL | Stock | 1.7818 | 1.785 | 1.7771 | 1.7829 | 43901900.0 |
| 2005-09-15 16:00:00 | AAPL | Stock | 1.7811 | 1.7839 | 1.7732 | 1.775 | 3204852.0 |
| 2005-09-15 16:30:00 | AAPL | Stock | 1.7786 | 1.7786 | 1.7786 | 1.7786 | 5600.0 |
| 2005-09-15 17:00:00 | AAPL | Stock | 1.7786 | 1.7813 | 1.7779 | 1.7813 | 297416.0 |
| 2005-09-15 17:30:00 | AAPL | Stock | 1.7793 | 1.7793 | 1.7767 | 1.7793 | 10414600.0 |
| 2005-09-15 18:00:00 | AAPL | Stock | 1.78 | 1.78 | 1.78 | 1.78 | 21000.0 |
| 2005-09-15 07:30:00 | MSFT | Stock | 26.25 | 26.25 | 26.25 | 26.25 | 1000.0 |
| 2005-09-15 08:00:00 | MSFT | Stock | 26.31 | 26.4 | 26.3 | 26.37 | 247260.0 |
| 2005-09-15 08:30:00 | MSFT | Stock | 26.37 | 26.4 | 26.37 | 26.37 | 44079.0 |
| 2005-09-15 09:00:00 | MSFT | Stock | 26.38 | 26.39 | 26.36 | 26.39 | 36872.0 |
| 2005-09-15 09:30:00 | MSFT | Stock | 26.37 | 26.43 | 26.3 | 26.322 | 6109774.0 |
| 2005-09-15 10:00:00 | MSFT | Stock | 26.33 | 26.35 | 26.26 | 26.29 | 4001217.0 |
| 2005-09-15 10:30:00 | MSFT | Stock | 26.29 | 26.32 | 26.22 | 26.31 | 5032192.0 |
| 2005-09-15 11:00:00 | MSFT | Stock | 26.31 | 26.37 | 26.24 | 26.28 | 3316374.0 |
| 2005-09-15 11:30:00 | MSFT | Stock | 26.29 | 26.35 | 26.26 | 26.35 | 5654003.0 |
| 2005-09-15 12:00:00 | MSFT | Stock | 26.35 | 26.38 | 26.28 | 26.36 | 3475866.0 |
| 2005-09-15 12:30:00 | MSFT | Stock | 26.36 | 26.37 | 26.31 | 26.33 | 1467720.0 |
| 2005-09-15 13:00:00 | MSFT | Stock | 26.33 | 26.43 | 26.32 | 26.34 | 3266138.0 |
| 2005-09-15 13:30:00 | MSFT | Stock | 26.35 | 26.39 | 26.31 | 26.34 | 2623203.0 |
| 2005-09-15 14:00:00 | MSFT | Stock | 26.34 | 26.35 | 26.27 | 26.281 | 3467332.0 |
| 2005-09-15 14:30:00 | MSFT | Stock | 26.29 | 26.35 | 26.28 | 26.28 | 3934374.0 |
| 2005-09-15 15:00:00 | MSFT | Stock | 26.28 | 26.31 | 26.23 | 26.27 | 4072954.0 |
| 2005-09-15 15:30:00 | MSFT | Stock | 26.27 | 26.31 | 26.24 | 26.27 | 7222616.0 |
| 2005-09-15 16:00:00 | MSFT | Stock | 26.27 | 26.32 | 26.25 | 26.28 | 2220120.0 |
| 2005-09-15 16:30:00 | MSFT | Stock | 26.3 | 26.31 | 26.28 | 26.28 | 9030.0 |
| 2005-09-15 17:00:00 | MSFT | Stock | 26.31 | 26.31 | 26.27 | 26.31 | 11043.0 |
| 2005-09-15 17:30:00 | MSFT | Stock | 26.31 | 26.31 | 26.27 | 26.29 | 3712.0 |
| 2005-09-15 18:00:00 | MSFT | Stock | 26.31 | 26.32 | 26.31 | 26.32 | 5325.0 |
| 2005-09-15 08:00:00 | NVDA | Stock | 0.2729 | 0.2729 | 0.2729 | 0.2729 | 204000.0 |
| 2005-09-15 08:30:00 | NVDA | Stock | 0.2729 | 0.2764 | 0.2729 | 0.2764 | 649680.0 |
| 2005-09-15 09:00:00 | NVDA | Stock | 0.2767 | 0.2771 | 0.275 | 0.2762 | 2467200.0 |
| 2005-09-15 09:30:00 | NVDA | Stock | 0.2762 | 0.2791 | 0.2747 | 0.2757 | 120082920.0 |
| 2005-09-15 10:00:00 | NVDA | Stock | 0.2757 | 0.2764 | 0.2746 | 0.2761 | 62969280.0 |
| 2005-09-15 10:30:00 | NVDA | Stock | 0.2761 | 0.2789 | 0.2757 | 0.2785 | 83266080.0 |
| 2005-09-15 11:00:00 | NVDA | Stock | 0.2785 | 0.2787 | 0.2764 | 0.2767 | 67169280.0 |
> showing 50 of 46,452 rows — these rows as CSV