PREVIEW / stock_30min / 2007-03-12
file: by_date/stock_30min/2007/2007-03-12.parquet size: 1.0 MB rows: 55,813 symbols: 2,528
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-03-12 05:00:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 8400.0 |
| 2007-03-12 07:00:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 56000.0 |
| 2007-03-12 07:30:00 | AAPL | Stock | 3.1625 | 3.1696 | 3.1625 | 3.1643 | 495600.0 |
| 2007-03-12 08:00:00 | AAPL | Stock | 3.1589 | 3.1607 | 3.1482 | 3.1482 | 790748.0 |
| 2007-03-12 08:30:00 | AAPL | Stock | 3.1446 | 3.1479 | 3.1414 | 3.1475 | 341992.0 |
| 2007-03-12 09:00:00 | AAPL | Stock | 3.145 | 3.145 | 3.14 | 3.1429 | 426720.0 |
| 2007-03-12 09:30:00 | AAPL | Stock | 3.1429 | 3.1696 | 3.1425 | 3.1596 | 74822608.0 |
| 2007-03-12 10:00:00 | AAPL | Stock | 3.16 | 3.1954 | 3.1571 | 3.1882 | 103246024.0 |
| 2007-03-12 10:30:00 | AAPL | Stock | 3.1882 | 3.1982 | 3.1789 | 3.1932 | 82492116.0 |
| 2007-03-12 11:00:00 | AAPL | Stock | 3.1932 | 3.21 | 3.1918 | 3.2025 | 90069364.0 |
| 2007-03-12 11:30:00 | AAPL | Stock | 3.2025 | 3.21 | 3.1979 | 3.2036 | 47804092.0 |
| 2007-03-12 12:00:00 | AAPL | Stock | 3.2039 | 3.2121 | 3.2011 | 3.2079 | 41503476.0 |
| 2007-03-12 12:30:00 | AAPL | Stock | 3.2082 | 3.2125 | 3.2057 | 3.2096 | 29328544.0 |
| 2007-03-12 13:00:00 | AAPL | Stock | 3.2093 | 3.2139 | 3.1932 | 3.1943 | 49740432.0 |
| 2007-03-12 13:30:00 | AAPL | Stock | 3.1943 | 3.2071 | 3.1932 | 3.2025 | 29349936.0 |
| 2007-03-12 14:00:00 | AAPL | Stock | 3.2025 | 3.2104 | 3.1936 | 3.2061 | 39407564.0 |
| 2007-03-12 14:30:00 | AAPL | Stock | 3.2061 | 3.2118 | 3.2054 | 3.2061 | 37035040.0 |
| 2007-03-12 15:00:00 | AAPL | Stock | 3.2061 | 3.2104 | 3.1993 | 3.2046 | 26364968.0 |
| 2007-03-12 15:30:00 | AAPL | Stock | 3.205 | 3.21 | 3.195 | 3.21 | 67104156.0 |
| 2007-03-12 16:00:00 | AAPL | Stock | 3.2104 | 3.2204 | 3.2104 | 3.2107 | 3921288.0 |
| 2007-03-12 16:30:00 | AAPL | Stock | 3.2107 | 3.2132 | 3.1495 | 3.2107 | 564564.0 |
| 2007-03-12 17:00:00 | AAPL | Stock | 3.2121 | 3.2132 | 3.2107 | 3.2132 | 144032.0 |
| 2007-03-12 17:30:00 | AAPL | Stock | 3.2132 | 3.2143 | 3.2129 | 3.2143 | 82180.0 |
| 2007-03-12 18:00:00 | AAPL | Stock | 3.2129 | 3.2175 | 3.2125 | 3.2161 | 277760.0 |
| 2007-03-12 18:30:00 | AAPL | Stock | 3.2171 | 3.2171 | 3.2161 | 3.2161 | 15400.0 |
| 2007-03-12 19:00:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2125 | 3.2125 | 112672.0 |
| 2007-03-12 19:30:00 | AAPL | Stock | 3.2143 | 3.2161 | 3.2143 | 3.2161 | 62860.0 |
| 2007-03-12 08:00:00 | MSFT | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 56120.0 |
| 2007-03-12 08:30:00 | MSFT | Stock | 27.26 | 27.3 | 27.25 | 27.29 | 4000.0 |
| 2007-03-12 09:00:00 | MSFT | Stock | 27.28 | 27.3 | 27.15 | 27.15 | 67780.0 |
| 2007-03-12 09:30:00 | MSFT | Stock | 27.18 | 27.37 | 27.13 | 27.24 | 4893603.0 |
| 2007-03-12 10:00:00 | MSFT | Stock | 27.24 | 27.34 | 27.21 | 27.25 | 2352224.0 |
| 2007-03-12 10:30:00 | MSFT | Stock | 27.26 | 27.31 | 27.24 | 27.28 | 2389098.0 |
| 2007-03-12 11:00:00 | MSFT | Stock | 27.28 | 27.29 | 27.22 | 27.24 | 2227607.0 |
| 2007-03-12 11:30:00 | MSFT | Stock | 27.24 | 27.27 | 27.19 | 27.2 | 2110783.0 |
| 2007-03-12 12:00:00 | MSFT | Stock | 27.21 | 27.34 | 27.19 | 27.32 | 2534974.0 |
| 2007-03-12 12:30:00 | MSFT | Stock | 27.31 | 27.45 | 27.3 | 27.44 | 2675346.0 |
| 2007-03-12 13:00:00 | MSFT | Stock | 27.45 | 27.45 | 27.36 | 27.39 | 1811384.0 |
| 2007-03-12 13:30:00 | MSFT | Stock | 27.38 | 27.4 | 27.32 | 27.37 | 1789419.0 |
| 2007-03-12 14:00:00 | MSFT | Stock | 27.37 | 27.45 | 27.35 | 27.42 | 1481001.0 |
| 2007-03-12 14:30:00 | MSFT | Stock | 27.43 | 27.45 | 27.4 | 27.42 | 1854791.0 |
| 2007-03-12 15:00:00 | MSFT | Stock | 27.42 | 27.48 | 27.42 | 27.43 | 2559764.0 |
| 2007-03-12 15:30:00 | MSFT | Stock | 27.43 | 27.46 | 27.35 | 27.46 | 5687990.0 |
| 2007-03-12 16:00:00 | MSFT | Stock | 27.44 | 27.47 | 27.42 | 27.47 | 151139.0 |
| 2007-03-12 16:30:00 | MSFT | Stock | 27.42 | 27.448 | 27.195 | 27.448 | 53038.0 |
| 2007-03-12 17:00:00 | MSFT | Stock | 27.44 | 27.44 | 27.4 | 27.4 | 557859.0 |
| 2007-03-12 17:30:00 | MSFT | Stock | 27.4 | 27.4 | 27.4 | 27.4 | 7141.0 |
| 2007-03-12 19:30:00 | MSFT | Stock | 27.4 | 27.44 | 27.4 | 27.44 | 1500.0 |
| 2007-03-12 08:30:00 | NVDA | Stock | 0.5067 | 0.5082 | 0.5067 | 0.5082 | 14400.0 |
| 2007-03-12 09:00:00 | NVDA | Stock | 0.5067 | 0.5067 | 0.5 | 0.5018 | 595620.0 |
> showing 50 of 55,813 rows — these rows as CSV