PREVIEW / stock_30min / 2007-03-16
file: by_date/stock_30min/2007/2007-03-16.parquet size: 1.0 MB rows: 55,473 symbols: 2,534
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-16 08:00:00 | AAPL | Stock | 3.2025 | 3.2029 | 3.1875 | 3.1964 | 687484.0 |
| 2007-03-16 08:30:00 | AAPL | Stock | 3.1971 | 3.2014 | 3.1918 | 3.2014 | 916664.0 |
| 2007-03-16 09:00:00 | AAPL | Stock | 3.2 | 3.2068 | 3.1954 | 3.1957 | 797384.0 |
| 2007-03-16 09:30:00 | AAPL | Stock | 3.1978 | 3.2114 | 3.195 | 3.2057 | 151133696.0 |
| 2007-03-16 10:00:00 | AAPL | Stock | 3.2061 | 3.2136 | 3.2054 | 3.2118 | 38807272.0 |
| 2007-03-16 10:30:00 | AAPL | Stock | 3.2114 | 3.2139 | 3.2079 | 3.2125 | 35616280.0 |
| 2007-03-16 11:00:00 | AAPL | Stock | 3.2121 | 3.2121 | 3.1993 | 3.2018 | 34508320.0 |
| 2007-03-16 11:30:00 | AAPL | Stock | 3.2018 | 3.2032 | 3.1968 | 3.2004 | 29743840.0 |
| 2007-03-16 12:00:00 | AAPL | Stock | 3.2004 | 3.2071 | 3.1982 | 3.2039 | 24946992.0 |
| 2007-03-16 12:30:00 | AAPL | Stock | 3.2039 | 3.21 | 3.2007 | 3.2071 | 18686920.0 |
| 2007-03-16 13:00:00 | AAPL | Stock | 3.2071 | 3.2107 | 3.2061 | 3.2061 | 19559344.0 |
| 2007-03-16 13:30:00 | AAPL | Stock | 3.2068 | 3.21 | 3.1993 | 3.2015 | 24839948.0 |
| 2007-03-16 14:00:00 | AAPL | Stock | 3.2018 | 3.2032 | 3.19 | 3.1957 | 32224248.0 |
| 2007-03-16 14:30:00 | AAPL | Stock | 3.1957 | 3.1982 | 3.1911 | 3.1964 | 23188480.0 |
| 2007-03-16 15:00:00 | AAPL | Stock | 3.1961 | 3.1996 | 3.1939 | 3.1986 | 21894936.0 |
| 2007-03-16 15:30:00 | AAPL | Stock | 3.1989 | 3.2018 | 3.1939 | 3.1989 | 44290288.0 |
| 2007-03-16 16:00:00 | AAPL | Stock | 3.1996 | 3.2021 | 3.1986 | 3.1996 | 10732372.0 |
| 2007-03-16 16:30:00 | AAPL | Stock | 3.1996 | 3.2004 | 3.1964 | 3.1982 | 16164260.0 |
| 2007-03-16 17:00:00 | AAPL | Stock | 3.1979 | 3.1982 | 3.1979 | 3.1982 | 72800.0 |
| 2007-03-16 17:30:00 | AAPL | Stock | 3.1982 | 3.1982 | 3.1932 | 3.1964 | 130088.0 |
| 2007-03-16 18:00:00 | AAPL | Stock | 3.1964 | 3.2004 | 3.1914 | 3.1964 | 146888.0 |
| 2007-03-16 18:30:00 | AAPL | Stock | 3.1993 | 3.1993 | 3.1993 | 3.1993 | 8400.0 |
| 2007-03-16 19:00:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1964 | 3.1964 | 2800.0 |
| 2007-03-16 19:30:00 | AAPL | Stock | 3.1968 | 3.1989 | 3.1968 | 3.1989 | 47852.0 |
| 2007-03-16 08:00:00 | MSFT | Stock | 27.3 | 27.3 | 27.28 | 27.28 | 200.0 |
| 2007-03-16 08:30:00 | MSFT | Stock | 27.3 | 27.3 | 27.18 | 27.18 | 4062.0 |
| 2007-03-16 09:00:00 | MSFT | Stock | 27.23 | 27.5 | 27.22 | 27.36 | 835085.0 |
| 2007-03-16 09:30:00 | MSFT | Stock | 27.35 | 27.39 | 27.25 | 27.34 | 24304823.0 |
| 2007-03-16 10:00:00 | MSFT | Stock | 27.34 | 27.48 | 27.33 | 27.41 | 4014773.0 |
| 2007-03-16 10:30:00 | MSFT | Stock | 27.41 | 27.42 | 27.35 | 27.38 | 3291183.0 |
| 2007-03-16 11:00:00 | MSFT | Stock | 27.39 | 27.39 | 27.23 | 27.25 | 3814902.0 |
| 2007-03-16 11:30:00 | MSFT | Stock | 27.25 | 27.32 | 27.2 | 27.32 | 2717057.0 |
| 2007-03-16 12:00:00 | MSFT | Stock | 27.32 | 27.34 | 27.27 | 27.31 | 1746202.0 |
| 2007-03-16 12:30:00 | MSFT | Stock | 27.3 | 27.36 | 27.27 | 27.339 | 1865342.0 |
| 2007-03-16 13:00:00 | MSFT | Stock | 27.34 | 27.39 | 27.3 | 27.37 | 1693664.0 |
| 2007-03-16 13:30:00 | MSFT | Stock | 27.38 | 27.42 | 27.36 | 27.39 | 2238352.0 |
| 2007-03-16 14:00:00 | MSFT | Stock | 27.4 | 27.4 | 27.31 | 27.36 | 2153210.0 |
| 2007-03-16 14:30:00 | MSFT | Stock | 27.37 | 27.48 | 27.33 | 27.4 | 2160943.0 |
| 2007-03-16 15:00:00 | MSFT | Stock | 27.4 | 27.42 | 27.33 | 27.35 | 3422147.0 |
| 2007-03-16 15:30:00 | MSFT | Stock | 27.35 | 27.37 | 27.31 | 27.31 | 6858693.0 |
| 2007-03-16 16:00:00 | MSFT | Stock | 27.31 | 27.34 | 27.31 | 27.325 | 627563.0 |
| 2007-03-16 16:30:00 | MSFT | Stock | 27.332 | 27.332 | 27.328 | 27.33 | 25643.0 |
| 2007-03-16 17:00:00 | MSFT | Stock | 27.34 | 27.34 | 27.33 | 27.33 | 1700.0 |
| 2007-03-16 17:30:00 | MSFT | Stock | 27.32 | 27.35 | 27.32 | 27.32 | 1600.0 |
| 2007-03-16 18:30:00 | MSFT | Stock | 27.291 | 27.31 | 27.29 | 27.29 | 18217.0 |
| 2007-03-16 19:00:00 | MSFT | Stock | 27.33 | 27.33 | 27.33 | 27.33 | 1358.0 |
| 2007-03-16 19:30:00 | MSFT | Stock | 27.28 | 27.28 | 27.28 | 27.28 | 1281.0 |
| 2007-03-16 08:00:00 | NVDA | Stock | 0.477 | 0.477 | 0.4752 | 0.4752 | 39000.0 |
| 2007-03-16 08:30:00 | NVDA | Stock | 0.475 | 0.475 | 0.475 | 0.475 | 1251000.0 |
| 2007-03-16 09:00:00 | NVDA | Stock | 0.475 | 0.4778 | 0.475 | 0.4767 | 3078000.0 |
> showing 50 of 55,473 rows — these rows as CSV