PREVIEW / stock_30min / 2008-08-26
file: by_date/stock_30min/2008/2008-08-26.parquet size: 1.2 MB rows: 66,937 symbols: 3,303
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-26 05:00:00 | AAPL | Stock | 6.1361 | 6.1361 | 6.1361 | 6.1361 | 2800.0 |
| 2008-08-26 05:30:00 | AAPL | Stock | 6.1868 | 6.1868 | 6.1868 | 6.1868 | 2800.0 |
| 2008-08-26 07:00:00 | AAPL | Stock | 6.1868 | 6.2036 | 6.1696 | 6.2036 | 22400.0 |
| 2008-08-26 07:30:00 | AAPL | Stock | 6.1943 | 6.1943 | 6.1786 | 6.1786 | 47096.0 |
| 2008-08-26 08:00:00 | AAPL | Stock | 6.1782 | 6.1854 | 6.1589 | 6.1661 | 797664.0 |
| 2008-08-26 08:30:00 | AAPL | Stock | 6.1625 | 6.1943 | 6.1589 | 6.1786 | 546588.0 |
| 2008-08-26 09:00:00 | AAPL | Stock | 6.175 | 6.1786 | 6.1571 | 6.1643 | 583156.0 |
| 2008-08-26 09:30:00 | AAPL | Stock | 6.1661 | 6.2354 | 6.1646 | 6.2279 | 71351896.0 |
| 2008-08-26 10:00:00 | AAPL | Stock | 6.2286 | 6.2457 | 6.1946 | 6.2204 | 55887076.0 |
| 2008-08-26 10:30:00 | AAPL | Stock | 6.22 | 6.2414 | 6.2164 | 6.235 | 33389720.0 |
| 2008-08-26 11:00:00 | AAPL | Stock | 6.235 | 6.2389 | 6.2043 | 6.2114 | 19190612.0 |
| 2008-08-26 11:30:00 | AAPL | Stock | 6.2118 | 6.2157 | 6.1829 | 6.2075 | 29144220.0 |
| 2008-08-26 12:00:00 | AAPL | Stock | 6.2079 | 6.2286 | 6.2025 | 6.2089 | 15386784.0 |
| 2008-08-26 12:30:00 | AAPL | Stock | 6.2086 | 6.23 | 6.1939 | 6.2014 | 21963480.0 |
| 2008-08-26 13:00:00 | AAPL | Stock | 6.2004 | 6.2161 | 6.1971 | 6.2096 | 12783904.0 |
| 2008-08-26 13:30:00 | AAPL | Stock | 6.2096 | 6.2107 | 6.1761 | 6.1837 | 22604820.0 |
| 2008-08-26 14:00:00 | AAPL | Stock | 6.1839 | 6.2089 | 6.1682 | 6.1718 | 29509452.0 |
| 2008-08-26 14:30:00 | AAPL | Stock | 6.1729 | 6.1875 | 6.1679 | 6.1721 | 21370748.0 |
| 2008-08-26 15:00:00 | AAPL | Stock | 6.1718 | 6.2079 | 6.1718 | 6.1957 | 27551048.0 |
| 2008-08-26 15:30:00 | AAPL | Stock | 6.196 | 6.2214 | 6.195 | 6.2021 | 41620852.0 |
| 2008-08-26 16:00:00 | AAPL | Stock | 6.2092 | 6.2092 | 6.1967 | 6.2032 | 25523288.0 |
| 2008-08-26 16:30:00 | AAPL | Stock | 6.2032 | 6.2068 | 6.1965 | 6.2011 | 10192336.0 |
| 2008-08-26 17:00:00 | AAPL | Stock | 6.2036 | 6.2036 | 6.1961 | 6.2036 | 57960.0 |
| 2008-08-26 17:30:00 | AAPL | Stock | 6.2032 | 6.2036 | 6.2007 | 6.2036 | 157220.0 |
| 2008-08-26 18:00:00 | AAPL | Stock | 6.2036 | 6.2036 | 6.2036 | 6.2036 | 7000.0 |
| 2008-08-26 18:30:00 | AAPL | Stock | 6.205 | 6.205 | 6.2036 | 6.2036 | 21364.0 |
| 2008-08-26 19:00:00 | AAPL | Stock | 6.2029 | 6.2032 | 6.2011 | 6.2011 | 76356.0 |
| 2008-08-26 19:30:00 | AAPL | Stock | 6.2007 | 6.2018 | 6.1982 | 6.2018 | 123760.0 |
| 2008-08-26 07:00:00 | MSFT | Stock | 27.61 | 27.61 | 27.61 | 27.61 | 100.0 |
| 2008-08-26 09:00:00 | MSFT | Stock | 27.63 | 27.64 | 27.56 | 27.58 | 6485.0 |
| 2008-08-26 09:30:00 | MSFT | Stock | 27.58 | 27.71 | 27.43 | 27.54 | 4640867.0 |
| 2008-08-26 10:00:00 | MSFT | Stock | 27.54 | 27.68 | 27.52 | 27.56 | 2685625.0 |
| 2008-08-26 10:30:00 | MSFT | Stock | 27.55 | 27.72 | 27.55 | 27.69 | 2283668.0 |
| 2008-08-26 11:00:00 | MSFT | Stock | 27.68 | 27.705 | 27.52 | 27.52 | 2350991.0 |
| 2008-08-26 11:30:00 | MSFT | Stock | 27.52 | 27.55 | 27.48 | 27.48 | 3084550.0 |
| 2008-08-26 12:00:00 | MSFT | Stock | 27.48 | 27.54 | 27.45 | 27.46 | 1585398.0 |
| 2008-08-26 12:30:00 | MSFT | Stock | 27.469 | 27.5 | 27.36 | 27.403 | 1635178.0 |
| 2008-08-26 13:00:00 | MSFT | Stock | 27.41 | 27.43 | 27.27 | 27.29 | 2624065.0 |
| 2008-08-26 13:30:00 | MSFT | Stock | 27.28 | 27.31 | 27.18 | 27.241 | 2350657.0 |
| 2008-08-26 14:00:00 | MSFT | Stock | 27.24 | 27.36 | 27.21 | 27.233 | 2481141.0 |
| 2008-08-26 14:30:00 | MSFT | Stock | 27.239 | 27.28 | 27.17 | 27.19 | 2703687.0 |
| 2008-08-26 15:00:00 | MSFT | Stock | 27.199 | 27.33 | 27.17 | 27.25 | 3109292.0 |
| 2008-08-26 15:30:00 | MSFT | Stock | 27.25 | 27.32 | 27.23 | 27.29 | 4108826.0 |
| 2008-08-26 16:00:00 | MSFT | Stock | 27.29 | 27.419 | 27.22 | 27.25 | 6362962.0 |
| 2008-08-26 16:30:00 | MSFT | Stock | 27.248 | 27.3 | 27.248 | 27.27 | 1962459.0 |
| 2008-08-26 17:00:00 | MSFT | Stock | 27.28 | 27.52 | 27.28 | 27.52 | 152900.0 |
| 2008-08-26 17:30:00 | MSFT | Stock | 27.27 | 27.29 | 27.26 | 27.29 | 1300.0 |
| 2008-08-26 18:00:00 | MSFT | Stock | 27.3 | 27.3 | 27.29 | 27.3 | 550.0 |
| 2008-08-26 18:30:00 | MSFT | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 610.0 |
| 2008-08-26 08:00:00 | NVDA | Stock | 0.3378 | 0.3378 | 0.3368 | 0.3378 | 272000.0 |
> showing 50 of 66,937 rows — these rows as CSV