PREVIEW / stock_30min / 2007-09-06
file: by_date/stock_30min/2007/2007-09-06.parquet size: 1.1 MB rows: 63,667 symbols: 3,108
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-06 09:30:00 | AAPL | Stock | 4.8414 | 4.8707 | 4.75 | 4.7561 | 317490796.0 |
| 2007-09-06 10:00:00 | AAPL | Stock | 4.7568 | 4.79 | 4.7396 | 4.7729 | 184963072.0 |
| 2007-09-06 10:30:00 | AAPL | Stock | 4.7732 | 4.8229 | 4.7643 | 4.8096 | 145990572.0 |
| 2007-09-06 11:00:00 | AAPL | Stock | 4.81 | 4.8104 | 4.7768 | 4.8021 | 99739668.0 |
| 2007-09-06 11:30:00 | AAPL | Stock | 4.8018 | 4.81 | 4.79 | 4.8032 | 81089540.0 |
| 2007-09-06 12:00:00 | AAPL | Stock | 4.8032 | 4.8571 | 4.7946 | 4.8311 | 125618192.0 |
| 2007-09-06 12:30:00 | AAPL | Stock | 4.8314 | 4.8321 | 4.7993 | 4.8179 | 74176144.0 |
| 2007-09-06 13:00:00 | AAPL | Stock | 4.8182 | 4.8304 | 4.8014 | 4.8068 | 50896608.0 |
| 2007-09-06 13:30:00 | AAPL | Stock | 4.8064 | 4.8382 | 4.8004 | 4.8268 | 54776456.0 |
| 2007-09-06 14:00:00 | AAPL | Stock | 4.8264 | 4.8375 | 4.81 | 4.8286 | 52680796.0 |
| 2007-09-06 14:30:00 | AAPL | Stock | 4.8279 | 4.8686 | 4.8214 | 4.8657 | 87799012.0 |
| 2007-09-06 15:00:00 | AAPL | Stock | 4.8657 | 4.9132 | 4.7857 | 4.8268 | 287677292.0 |
| 2007-09-06 15:30:00 | AAPL | Stock | 4.8264 | 4.8436 | 4.8043 | 4.8214 | 154390880.0 |
| 2007-09-06 16:00:00 | AAPL | Stock | 4.8214 | 4.8218 | 4.8214 | 4.8218 | 6182988.0 |
| 2007-09-06 09:30:00 | MSFT | Stock | 28.56 | 28.725 | 28.55 | 28.72 | 3140202.0 |
| 2007-09-06 10:00:00 | MSFT | Stock | 28.72 | 28.8 | 28.68 | 28.71 | 5133148.0 |
| 2007-09-06 10:30:00 | MSFT | Stock | 28.71 | 28.81 | 28.7 | 28.79 | 2194104.0 |
| 2007-09-06 11:00:00 | MSFT | Stock | 28.8 | 28.91 | 28.77 | 28.91 | 1645314.0 |
| 2007-09-06 11:30:00 | MSFT | Stock | 28.91 | 28.93 | 28.87 | 28.901 | 3110482.0 |
| 2007-09-06 12:00:00 | MSFT | Stock | 28.91 | 28.94 | 28.83 | 28.94 | 1825178.0 |
| 2007-09-06 12:30:00 | MSFT | Stock | 28.94 | 28.95 | 28.89 | 28.92 | 1856052.0 |
| 2007-09-06 13:00:00 | MSFT | Stock | 28.92 | 28.96 | 28.89 | 28.96 | 2458754.0 |
| 2007-09-06 13:30:00 | MSFT | Stock | 28.96 | 28.96 | 28.92 | 28.95 | 1758669.0 |
| 2007-09-06 14:00:00 | MSFT | Stock | 28.95 | 29.01 | 28.91 | 28.94 | 3405099.0 |
| 2007-09-06 14:30:00 | MSFT | Stock | 28.945 | 28.99 | 28.93 | 28.96 | 1889413.0 |
| 2007-09-06 15:00:00 | MSFT | Stock | 28.96 | 28.99 | 28.9 | 28.941 | 2251168.0 |
| 2007-09-06 15:30:00 | MSFT | Stock | 28.94 | 28.98 | 28.86 | 28.91 | 6415632.0 |
| 2007-09-06 16:00:00 | MSFT | Stock | 28.93 | 28.93 | 28.91 | 28.91 | 1409801.0 |
| 2007-09-06 08:00:00 | NVDA | Stock | 0.8763 | 0.8763 | 0.8763 | 0.8763 | 17400.0 |
| 2007-09-06 08:30:00 | NVDA | Stock | 0.8832 | 0.885 | 0.8832 | 0.8833 | 164400.0 |
| 2007-09-06 09:00:00 | NVDA | Stock | 0.8817 | 0.8858 | 0.8808 | 0.8832 | 625500.0 |
| 2007-09-06 09:30:00 | NVDA | Stock | 0.8832 | 0.8912 | 0.8807 | 0.8842 | 49008180.0 |
| 2007-09-06 10:00:00 | NVDA | Stock | 0.8843 | 0.885 | 0.8777 | 0.8795 | 46195320.0 |
| 2007-09-06 10:30:00 | NVDA | Stock | 0.8795 | 0.8833 | 0.8767 | 0.8813 | 37090800.0 |
| 2007-09-06 11:00:00 | NVDA | Stock | 0.8813 | 0.8817 | 0.8747 | 0.8786 | 37022460.0 |
| 2007-09-06 11:30:00 | NVDA | Stock | 0.8784 | 0.8848 | 0.8784 | 0.8825 | 28458300.0 |
| 2007-09-06 12:00:00 | NVDA | Stock | 0.8825 | 0.8853 | 0.8802 | 0.8847 | 19199160.0 |
| 2007-09-06 12:30:00 | NVDA | Stock | 0.8845 | 0.8853 | 0.8808 | 0.8835 | 16244640.0 |
| 2007-09-06 13:00:00 | NVDA | Stock | 0.8835 | 0.8843 | 0.877 | 0.8803 | 16659540.0 |
| 2007-09-06 13:30:00 | NVDA | Stock | 0.8805 | 0.884 | 0.8772 | 0.8828 | 22199220.0 |
| 2007-09-06 14:00:00 | NVDA | Stock | 0.883 | 0.8832 | 0.8767 | 0.8777 | 17526720.0 |
| 2007-09-06 14:30:00 | NVDA | Stock | 0.8777 | 0.8793 | 0.8728 | 0.8734 | 27674640.0 |
| 2007-09-06 15:00:00 | NVDA | Stock | 0.8735 | 0.877 | 0.8728 | 0.8738 | 28430400.0 |
| 2007-09-06 15:30:00 | NVDA | Stock | 0.8738 | 0.8772 | 0.8725 | 0.8758 | 38364960.0 |
| 2007-09-06 16:00:00 | NVDA | Stock | 0.8758 | 0.8854 | 0.8742 | 0.8854 | 7719720.0 |
| 2007-09-06 17:00:00 | NVDA | Stock | 0.875 | 0.8762 | 0.8728 | 0.8762 | 26220.0 |
| 2007-09-06 19:00:00 | NVDA | Stock | 0.8763 | 0.8763 | 0.8763 | 0.8763 | 6000.0 |
| 2007-09-06 19:30:00 | NVDA | Stock | 0.8742 | 0.8765 | 0.8742 | 0.8765 | 52200.0 |
| 2007-09-06 06:30:00 | AMZN | Stock | 4.15 | 4.155 | 4.15 | 4.155 | 10000.0 |
| 2007-09-06 08:00:00 | AMZN | Stock | 4.1625 | 4.1875 | 4.1625 | 4.1875 | 67620.0 |
> showing 50 of 63,667 rows — these rows as CSV