PREVIEW / stock_30min / 2006-07-25
file: by_date/stock_30min/2006/2006-07-25.parquet size: 913 KB rows: 50,652 symbols: 2,325
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-25 08:00:00 | AAPL | Stock | 2.2018 | 2.2089 | 2.2018 | 2.2061 | 1166368.0 |
| 2006-07-25 08:30:00 | AAPL | Stock | 2.2054 | 2.2071 | 2.2 | 2.2018 | 1854300.0 |
| 2006-07-25 09:00:00 | AAPL | Stock | 2.2018 | 2.2089 | 2.2018 | 2.2061 | 3675924.0 |
| 2006-07-25 09:30:00 | AAPL | Stock | 2.2064 | 2.2143 | 2.1886 | 2.1893 | 79213204.0 |
| 2006-07-25 10:00:00 | AAPL | Stock | 2.1893 | 2.2029 | 2.1889 | 2.1918 | 56203756.0 |
| 2006-07-25 10:30:00 | AAPL | Stock | 2.1918 | 2.1925 | 2.1707 | 2.1768 | 65849000.0 |
| 2006-07-25 11:00:00 | AAPL | Stock | 2.1757 | 2.1871 | 2.1746 | 2.1839 | 35463624.0 |
| 2006-07-25 11:30:00 | AAPL | Stock | 2.1839 | 2.1843 | 2.1743 | 2.1829 | 29781836.0 |
| 2006-07-25 12:00:00 | AAPL | Stock | 2.1832 | 2.1857 | 2.1757 | 2.1843 | 23230844.0 |
| 2006-07-25 12:30:00 | AAPL | Stock | 2.1843 | 2.2014 | 2.1829 | 2.1989 | 44962036.0 |
| 2006-07-25 13:00:00 | AAPL | Stock | 2.1993 | 2.2039 | 2.1925 | 2.1989 | 35034748.0 |
| 2006-07-25 13:30:00 | AAPL | Stock | 2.1986 | 2.1993 | 2.1893 | 2.1929 | 21383628.0 |
| 2006-07-25 14:00:00 | AAPL | Stock | 2.1925 | 2.195 | 2.1871 | 2.1904 | 16501548.0 |
| 2006-07-25 14:30:00 | AAPL | Stock | 2.19 | 2.2068 | 2.1875 | 2.2039 | 36747144.0 |
| 2006-07-25 15:00:00 | AAPL | Stock | 2.2039 | 2.2121 | 2.2032 | 2.2071 | 49414036.0 |
| 2006-07-25 15:30:00 | AAPL | Stock | 2.2075 | 2.2175 | 2.2064 | 2.2118 | 79389716.0 |
| 2006-07-25 16:00:00 | AAPL | Stock | 2.2118 | 2.2139 | 2.2036 | 2.2086 | 1309784.0 |
| 2006-07-25 16:30:00 | AAPL | Stock | 2.2082 | 2.2125 | 2.2046 | 2.2086 | 379484.0 |
| 2006-07-25 17:00:00 | AAPL | Stock | 2.2086 | 2.2107 | 2.2086 | 2.2086 | 223160.0 |
| 2006-07-25 17:30:00 | AAPL | Stock | 2.2086 | 2.2089 | 2.2086 | 2.2086 | 98000.0 |
| 2006-07-25 18:00:00 | AAPL | Stock | 2.2086 | 2.2089 | 2.2046 | 2.2089 | 162400.0 |
| 2006-07-25 08:00:00 | MSFT | Stock | 24.05 | 24.07 | 24.0 | 24.0 | 11425.0 |
| 2006-07-25 08:30:00 | MSFT | Stock | 24.01 | 24.01 | 24.0 | 24.0 | 1575.0 |
| 2006-07-25 09:00:00 | MSFT | Stock | 24.0 | 24.0 | 23.81 | 24.0 | 63258.0 |
| 2006-07-25 09:30:00 | MSFT | Stock | 24.0 | 24.17 | 23.94 | 24.16 | 4918134.0 |
| 2006-07-25 10:00:00 | MSFT | Stock | 24.16 | 24.27 | 24.04 | 24.04 | 6899294.0 |
| 2006-07-25 10:30:00 | MSFT | Stock | 24.042 | 24.1 | 23.9 | 24.02 | 5641847.0 |
| 2006-07-25 11:00:00 | MSFT | Stock | 24.02 | 24.06 | 23.99 | 24.03 | 2753934.0 |
| 2006-07-25 11:30:00 | MSFT | Stock | 24.033 | 24.04 | 23.95 | 23.97 | 2974878.0 |
| 2006-07-25 12:00:00 | MSFT | Stock | 23.96 | 24.0 | 23.94 | 23.947 | 1845830.0 |
| 2006-07-25 12:30:00 | MSFT | Stock | 23.95 | 24.05 | 23.94 | 23.98 | 3804622.0 |
| 2006-07-25 13:00:00 | MSFT | Stock | 23.98 | 24.09 | 23.97 | 24.07 | 2570230.0 |
| 2006-07-25 13:30:00 | MSFT | Stock | 24.07 | 24.09 | 24.0 | 24.08 | 2608958.0 |
| 2006-07-25 14:00:00 | MSFT | Stock | 24.08 | 24.09 | 24.02 | 24.09 | 2332996.0 |
| 2006-07-25 14:30:00 | MSFT | Stock | 24.09 | 24.22 | 24.05 | 24.2 | 4894852.0 |
| 2006-07-25 15:00:00 | MSFT | Stock | 24.2 | 24.29 | 24.2 | 24.26 | 10052374.0 |
| 2006-07-25 15:30:00 | MSFT | Stock | 24.26 | 24.29 | 24.14 | 24.22 | 5814422.0 |
| 2006-07-25 16:00:00 | MSFT | Stock | 24.21 | 24.3 | 24.18 | 24.18 | 91819.0 |
| 2006-07-25 16:30:00 | MSFT | Stock | 24.2 | 24.22 | 24.11 | 24.15 | 802227.0 |
| 2006-07-25 17:00:00 | MSFT | Stock | 24.13 | 24.15 | 24.1 | 24.11 | 45877.0 |
| 2006-07-25 17:30:00 | MSFT | Stock | 24.11 | 24.11 | 24.1 | 24.11 | 2700.0 |
| 2006-07-25 18:00:00 | MSFT | Stock | 24.11 | 24.11 | 24.11 | 24.11 | 2100.0 |
| 2006-07-25 07:00:00 | NVDA | Stock | 0.3177 | 0.3177 | 0.3177 | 0.3177 | 60000.0 |
| 2006-07-25 08:00:00 | NVDA | Stock | 0.3333 | 0.3358 | 0.3317 | 0.3335 | 1889160.0 |
| 2006-07-25 08:30:00 | NVDA | Stock | 0.3333 | 0.3333 | 0.3317 | 0.3317 | 1275000.0 |
| 2006-07-25 09:00:00 | NVDA | Stock | 0.3317 | 0.3333 | 0.3287 | 0.33 | 989040.0 |
| 2006-07-25 09:30:00 | NVDA | Stock | 0.33 | 0.3333 | 0.3252 | 0.3328 | 58215360.0 |
| 2006-07-25 10:00:00 | NVDA | Stock | 0.3328 | 0.341 | 0.3327 | 0.337 | 75913500.0 |
| 2006-07-25 10:30:00 | NVDA | Stock | 0.3368 | 0.337 | 0.3314 | 0.3355 | 51603600.0 |
| 2006-07-25 11:00:00 | NVDA | Stock | 0.3355 | 0.3387 | 0.3327 | 0.335 | 43739460.0 |
> showing 50 of 50,652 rows — these rows as CSV