PREVIEW / stock_30min / 2007-03-13
file: by_date/stock_30min/2007/2007-03-13.parquet size: 1.0 MB rows: 56,326 symbols: 2,552
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-13 07:00:00 | AAPL | Stock | 3.2046 | 3.2125 | 3.2046 | 3.2089 | 19600.0 |
| 2007-03-13 07:30:00 | AAPL | Stock | 3.2011 | 3.2018 | 3.2 | 3.2018 | 56000.0 |
| 2007-03-13 08:00:00 | AAPL | Stock | 3.1982 | 3.2068 | 3.1946 | 3.1986 | 931812.0 |
| 2007-03-13 08:30:00 | AAPL | Stock | 3.1989 | 3.2018 | 3.1939 | 3.1964 | 643888.0 |
| 2007-03-13 09:00:00 | AAPL | Stock | 3.1964 | 3.1982 | 3.1929 | 3.1929 | 1146096.0 |
| 2007-03-13 09:30:00 | AAPL | Stock | 3.1932 | 3.2086 | 3.1893 | 3.2057 | 91361536.0 |
| 2007-03-13 10:00:00 | AAPL | Stock | 3.2057 | 3.2286 | 3.2014 | 3.2286 | 104725264.0 |
| 2007-03-13 10:30:00 | AAPL | Stock | 3.2289 | 3.2357 | 3.2218 | 3.2239 | 75996900.0 |
| 2007-03-13 11:00:00 | AAPL | Stock | 3.2239 | 3.2282 | 3.2096 | 3.2111 | 49103292.0 |
| 2007-03-13 11:30:00 | AAPL | Stock | 3.2107 | 3.2161 | 3.2029 | 3.2071 | 42386596.0 |
| 2007-03-13 12:00:00 | AAPL | Stock | 3.2071 | 3.2139 | 3.1886 | 3.1886 | 64795164.0 |
| 2007-03-13 12:30:00 | AAPL | Stock | 3.1882 | 3.1989 | 3.1807 | 3.1875 | 75102776.0 |
| 2007-03-13 13:00:00 | AAPL | Stock | 3.1875 | 3.1957 | 3.1857 | 3.1868 | 35640444.0 |
| 2007-03-13 13:30:00 | AAPL | Stock | 3.1864 | 3.1925 | 3.1804 | 3.1868 | 54133520.0 |
| 2007-03-13 14:00:00 | AAPL | Stock | 3.1868 | 3.1893 | 3.1718 | 3.1778 | 63162204.0 |
| 2007-03-13 14:30:00 | AAPL | Stock | 3.1771 | 3.1864 | 3.175 | 3.1761 | 41683068.0 |
| 2007-03-13 15:00:00 | AAPL | Stock | 3.1761 | 3.1836 | 3.1686 | 3.1811 | 56931840.0 |
| 2007-03-13 15:30:00 | AAPL | Stock | 3.1814 | 3.1832 | 3.1571 | 3.1571 | 95214364.0 |
| 2007-03-13 16:00:00 | AAPL | Stock | 3.1571 | 3.1625 | 3.1536 | 3.1589 | 1923516.0 |
| 2007-03-13 16:30:00 | AAPL | Stock | 3.1593 | 3.1625 | 3.1571 | 3.1571 | 1471596.0 |
| 2007-03-13 17:00:00 | AAPL | Stock | 3.1571 | 3.1604 | 3.1571 | 3.1604 | 94164.0 |
| 2007-03-13 17:30:00 | AAPL | Stock | 3.1586 | 3.1604 | 3.1571 | 3.1604 | 219548.0 |
| 2007-03-13 18:00:00 | AAPL | Stock | 3.1589 | 3.1607 | 3.1571 | 3.1589 | 88256.0 |
| 2007-03-13 18:30:00 | AAPL | Stock | 3.1589 | 3.1607 | 3.1589 | 3.1604 | 66024.0 |
| 2007-03-13 19:00:00 | AAPL | Stock | 3.1604 | 3.1604 | 3.1571 | 3.1604 | 25760.0 |
| 2007-03-13 19:30:00 | AAPL | Stock | 3.1571 | 3.1571 | 3.1571 | 3.1571 | 137480.0 |
| 2007-03-13 08:00:00 | MSFT | Stock | 27.36 | 27.36 | 27.34 | 27.34 | 4180.0 |
| 2007-03-13 08:30:00 | MSFT | Stock | 27.3 | 27.33 | 27.29 | 27.3 | 3681.0 |
| 2007-03-13 09:00:00 | MSFT | Stock | 27.29 | 27.32 | 27.24 | 27.25 | 153863.0 |
| 2007-03-13 09:30:00 | MSFT | Stock | 27.25 | 27.4 | 27.07 | 27.3 | 5920814.0 |
| 2007-03-13 10:00:00 | MSFT | Stock | 27.298 | 27.31 | 27.17 | 27.25 | 3409658.0 |
| 2007-03-13 10:30:00 | MSFT | Stock | 27.26 | 27.27 | 27.19 | 27.25 | 5740806.0 |
| 2007-03-13 11:00:00 | MSFT | Stock | 27.25 | 27.29 | 27.15 | 27.15 | 3418103.0 |
| 2007-03-13 11:30:00 | MSFT | Stock | 27.16 | 27.22 | 27.12 | 27.17 | 3654152.0 |
| 2007-03-13 12:00:00 | MSFT | Stock | 27.18 | 27.18 | 26.95 | 27.01 | 5806985.0 |
| 2007-03-13 12:30:00 | MSFT | Stock | 27.01 | 27.11 | 26.95 | 27.058 | 4822947.0 |
| 2007-03-13 13:00:00 | MSFT | Stock | 27.06 | 27.13 | 27.04 | 27.06 | 3301743.0 |
| 2007-03-13 13:30:00 | MSFT | Stock | 27.06 | 27.13 | 26.99 | 27.1 | 4761198.0 |
| 2007-03-13 14:00:00 | MSFT | Stock | 27.11 | 27.13 | 26.93 | 26.98 | 4975167.0 |
| 2007-03-13 14:30:00 | MSFT | Stock | 26.98 | 27.03 | 26.93 | 26.95 | 4948404.0 |
| 2007-03-13 15:00:00 | MSFT | Stock | 26.95 | 26.99 | 26.88 | 26.93 | 5885556.0 |
| 2007-03-13 15:30:00 | MSFT | Stock | 26.94 | 26.98 | 26.71 | 26.71 | 14017865.0 |
| 2007-03-13 16:00:00 | MSFT | Stock | 26.71 | 26.75 | 26.65 | 26.74 | 1428997.0 |
| 2007-03-13 16:30:00 | MSFT | Stock | 27.13 | 27.13 | 26.72 | 26.72 | 658356.0 |
| 2007-03-13 17:00:00 | MSFT | Stock | 26.73 | 26.73 | 26.72 | 26.73 | 12262.0 |
| 2007-03-13 17:30:00 | MSFT | Stock | 26.72 | 26.74 | 26.71 | 26.74 | 4271.0 |
| 2007-03-13 18:00:00 | MSFT | Stock | 26.74 | 26.74 | 26.72 | 26.72 | 166750.0 |
| 2007-03-13 18:30:00 | MSFT | Stock | 26.74 | 26.78 | 26.72 | 26.75 | 10409.0 |
| 2007-03-13 19:00:00 | MSFT | Stock | 26.76 | 26.77 | 26.74 | 26.74 | 5600.0 |
| 2007-03-13 19:30:00 | MSFT | Stock | 26.75 | 26.76 | 26.74 | 26.76 | 6400.0 |
> showing 50 of 56,326 rows — these rows as CSV