PREVIEW / stock_30min / 2009-02-27
file: by_date/stock_30min/2009/2009-02-27.parquet size: 1.3 MB rows: 71,084 symbols: 3,333
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-27 07:00:00 | AAPL | Stock | 3.1518 | 3.1518 | 3.1429 | 3.1429 | 16800.0 |
| 2009-02-27 07:30:00 | AAPL | Stock | 3.1418 | 3.1418 | 3.1418 | 3.1418 | 26600.0 |
| 2009-02-27 08:00:00 | AAPL | Stock | 3.1493 | 3.1493 | 3.125 | 3.1268 | 302512.0 |
| 2009-02-27 08:30:00 | AAPL | Stock | 3.1279 | 3.15 | 3.1268 | 3.1482 | 757428.0 |
| 2009-02-27 09:00:00 | AAPL | Stock | 3.1471 | 3.1482 | 3.1304 | 3.1361 | 659232.0 |
| 2009-02-27 09:30:00 | AAPL | Stock | 3.1357 | 3.2357 | 3.1311 | 3.2204 | 99676472.0 |
| 2009-02-27 10:00:00 | AAPL | Stock | 3.22 | 3.2607 | 3.1964 | 3.2464 | 63256620.0 |
| 2009-02-27 10:30:00 | AAPL | Stock | 3.2471 | 3.2482 | 3.2043 | 3.2111 | 46392668.0 |
| 2009-02-27 11:00:00 | AAPL | Stock | 3.2107 | 3.2136 | 3.1821 | 3.1993 | 43019928.0 |
| 2009-02-27 11:30:00 | AAPL | Stock | 3.1993 | 3.235 | 3.1921 | 3.2243 | 40983684.0 |
| 2009-02-27 12:00:00 | AAPL | Stock | 3.2239 | 3.2379 | 3.2143 | 3.2179 | 31747212.0 |
| 2009-02-27 12:30:00 | AAPL | Stock | 3.2193 | 3.2232 | 3.1807 | 3.1968 | 32383092.0 |
| 2009-02-27 13:00:00 | AAPL | Stock | 3.1971 | 3.21 | 3.1793 | 3.1929 | 30530640.0 |
| 2009-02-27 13:30:00 | AAPL | Stock | 3.1943 | 3.2121 | 3.1696 | 3.2047 | 40856508.0 |
| 2009-02-27 14:00:00 | AAPL | Stock | 3.2043 | 3.225 | 3.1979 | 3.2018 | 47701276.0 |
| 2009-02-27 14:30:00 | AAPL | Stock | 3.2018 | 3.2211 | 3.1846 | 3.22 | 36345512.0 |
| 2009-02-27 15:00:00 | AAPL | Stock | 3.22 | 3.2243 | 3.1889 | 3.2107 | 50417696.0 |
| 2009-02-27 15:30:00 | AAPL | Stock | 3.2104 | 3.2346 | 3.1896 | 3.19 | 92086736.0 |
| 2009-02-27 16:00:00 | AAPL | Stock | 3.1896 | 3.2123 | 3.1825 | 3.1898 | 26406520.0 |
| 2009-02-27 16:30:00 | AAPL | Stock | 3.1893 | 3.1896 | 3.1843 | 3.1875 | 9382184.0 |
| 2009-02-27 17:00:00 | AAPL | Stock | 3.1875 | 3.1911 | 3.1875 | 3.1886 | 1417304.0 |
| 2009-02-27 17:30:00 | AAPL | Stock | 3.1896 | 3.1912 | 3.1875 | 3.1912 | 19600.0 |
| 2009-02-27 18:00:00 | AAPL | Stock | 3.1896 | 3.1896 | 3.1893 | 3.1893 | 3071740.0 |
| 2009-02-27 18:30:00 | AAPL | Stock | 3.1879 | 3.1907 | 3.1879 | 3.1907 | 37800.0 |
| 2009-02-27 19:00:00 | AAPL | Stock | 3.1886 | 3.1886 | 3.1886 | 3.1886 | 11200.0 |
| 2009-02-27 19:30:00 | AAPL | Stock | 3.1889 | 3.1946 | 3.1889 | 3.1946 | 30940.0 |
| 2009-02-27 07:30:00 | MSFT | Stock | 16.45 | 16.45 | 16.45 | 16.45 | 700.0 |
| 2009-02-27 08:00:00 | MSFT | Stock | 16.42 | 16.44 | 16.23 | 16.25 | 46341.0 |
| 2009-02-27 08:30:00 | MSFT | Stock | 16.3 | 16.3 | 16.23 | 16.27 | 31540.0 |
| 2009-02-27 09:00:00 | MSFT | Stock | 16.27 | 16.3 | 16.23 | 16.29 | 44077.0 |
| 2009-02-27 09:30:00 | MSFT | Stock | 16.26 | 16.37 | 16.1 | 16.32 | 13391685.0 |
| 2009-02-27 10:00:00 | MSFT | Stock | 16.31 | 16.5 | 16.27 | 16.43 | 6288920.0 |
| 2009-02-27 10:30:00 | MSFT | Stock | 16.428 | 16.51 | 16.33 | 16.39 | 4395219.0 |
| 2009-02-27 11:00:00 | MSFT | Stock | 16.39 | 16.42 | 16.28 | 16.32 | 4691383.0 |
| 2009-02-27 11:30:00 | MSFT | Stock | 16.32 | 16.44 | 16.25 | 16.431 | 4978288.0 |
| 2009-02-27 12:00:00 | MSFT | Stock | 16.43 | 16.46 | 16.31 | 16.42 | 5015774.0 |
| 2009-02-27 12:30:00 | MSFT | Stock | 16.41 | 16.47 | 16.32 | 16.4 | 2554161.0 |
| 2009-02-27 13:00:00 | MSFT | Stock | 16.398 | 16.47 | 16.35 | 16.415 | 3123440.0 |
| 2009-02-27 13:30:00 | MSFT | Stock | 16.412 | 16.51 | 16.32 | 16.5 | 4707245.0 |
| 2009-02-27 14:00:00 | MSFT | Stock | 16.5 | 16.52 | 16.35 | 16.355 | 4280666.0 |
| 2009-02-27 14:30:00 | MSFT | Stock | 16.355 | 16.45 | 16.31 | 16.42 | 4485982.0 |
| 2009-02-27 15:00:00 | MSFT | Stock | 16.41 | 16.43 | 16.22 | 16.27 | 8149052.0 |
| 2009-02-27 15:30:00 | MSFT | Stock | 16.27 | 16.45 | 16.14 | 16.15 | 12990078.0 |
| 2009-02-27 16:00:00 | MSFT | Stock | 16.14 | 16.5 | 16.12 | 16.15 | 8785491.0 |
| 2009-02-27 16:30:00 | MSFT | Stock | 16.149 | 16.19 | 16.13 | 16.19 | 2100987.0 |
| 2009-02-27 17:00:00 | MSFT | Stock | 16.157 | 16.22 | 16.146 | 16.22 | 456157.0 |
| 2009-02-27 17:30:00 | MSFT | Stock | 16.18 | 16.406 | 16.147 | 16.2 | 19638.0 |
| 2009-02-27 18:00:00 | MSFT | Stock | 16.2 | 16.2 | 16.17 | 16.17 | 720.0 |
| 2009-02-27 19:00:00 | MSFT | Stock | 16.2 | 16.22 | 16.2 | 16.22 | 4069.0 |
| 2009-02-27 19:30:00 | MSFT | Stock | 16.22 | 16.22 | 16.2 | 16.22 | 1635.0 |
> showing 50 of 71,084 rows — these rows as CSV