PREVIEW / stock_30min / 2009-03-05
file: by_date/stock_30min/2009/2009-03-05.parquet size: 1.3 MB rows: 70,483 symbols: 3,351
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-03-05 04:30:00 | AAPL | Stock | 3.2414 | 3.2414 | 3.2414 | 3.2414 | 16800.0 |
| 2009-03-05 06:00:00 | AAPL | Stock | 3.2336 | 3.2336 | 3.2157 | 3.2157 | 22400.0 |
| 2009-03-05 06:30:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2107 | 3.2107 | 5600.0 |
| 2009-03-05 07:00:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2107 | 3.2107 | 5600.0 |
| 2009-03-05 07:30:00 | AAPL | Stock | 3.2107 | 3.2143 | 3.2107 | 3.2107 | 36400.0 |
| 2009-03-05 08:00:00 | AAPL | Stock | 3.2125 | 3.2336 | 3.2125 | 3.2221 | 486668.0 |
| 2009-03-05 08:30:00 | AAPL | Stock | 3.2314 | 3.2357 | 3.2189 | 3.225 | 963032.0 |
| 2009-03-05 09:00:00 | AAPL | Stock | 3.225 | 3.2375 | 3.2232 | 3.2354 | 841708.0 |
| 2009-03-05 09:30:00 | AAPL | Stock | 3.2318 | 3.2811 | 3.2204 | 3.2568 | 76015044.0 |
| 2009-03-05 10:00:00 | AAPL | Stock | 3.2564 | 3.2786 | 3.2004 | 3.205 | 72228772.0 |
| 2009-03-05 10:30:00 | AAPL | Stock | 3.205 | 3.2179 | 3.1875 | 3.1911 | 50758876.0 |
| 2009-03-05 11:00:00 | AAPL | Stock | 3.1911 | 3.2179 | 3.175 | 3.1779 | 49614040.0 |
| 2009-03-05 11:30:00 | AAPL | Stock | 3.1779 | 3.205 | 3.1761 | 3.1875 | 40435220.0 |
| 2009-03-05 12:00:00 | AAPL | Stock | 3.1868 | 3.1911 | 3.1589 | 3.1911 | 34704012.0 |
| 2009-03-05 12:30:00 | AAPL | Stock | 3.1909 | 3.2007 | 3.1725 | 3.1789 | 30901444.0 |
| 2009-03-05 13:00:00 | AAPL | Stock | 3.1782 | 3.2125 | 3.1768 | 3.1993 | 38274628.0 |
| 2009-03-05 13:30:00 | AAPL | Stock | 3.1993 | 3.2021 | 3.1761 | 3.1957 | 34105176.0 |
| 2009-03-05 14:00:00 | AAPL | Stock | 3.1968 | 3.1986 | 3.1736 | 3.1761 | 36247288.0 |
| 2009-03-05 14:30:00 | AAPL | Stock | 3.1757 | 3.1871 | 3.16 | 3.1682 | 45566388.0 |
| 2009-03-05 15:00:00 | AAPL | Stock | 3.1686 | 3.2179 | 3.1664 | 3.1889 | 64488844.0 |
| 2009-03-05 15:30:00 | AAPL | Stock | 3.1889 | 3.1943 | 3.1589 | 3.1775 | 95903780.0 |
| 2009-03-05 16:00:00 | AAPL | Stock | 3.1761 | 3.2013 | 3.1729 | 3.1729 | 22051988.0 |
| 2009-03-05 16:30:00 | AAPL | Stock | 3.1861 | 3.1861 | 3.1729 | 3.1814 | 135352.0 |
| 2009-03-05 17:00:00 | AAPL | Stock | 3.1796 | 3.1804 | 3.1729 | 3.1779 | 4938556.0 |
| 2009-03-05 17:30:00 | AAPL | Stock | 3.1786 | 3.1854 | 3.1729 | 3.1854 | 148568.0 |
| 2009-03-05 18:00:00 | AAPL | Stock | 3.1676 | 3.2045 | 3.1676 | 3.1786 | 944076.0 |
| 2009-03-05 18:30:00 | AAPL | Stock | 3.1732 | 3.1732 | 3.17 | 3.1714 | 143780.0 |
| 2009-03-05 19:00:00 | AAPL | Stock | 3.1718 | 3.1718 | 3.1696 | 3.1707 | 46116.0 |
| 2009-03-05 19:30:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.1696 | 3.1696 | 71120.0 |
| 2009-03-05 20:00:00 | AAPL | Stock | 3.2289 | 3.2289 | 3.2289 | 3.2289 | 453600.0 |
| 2009-03-05 06:30:00 | MSFT | Stock | 15.94 | 15.94 | 15.8 | 15.8 | 2500.0 |
| 2009-03-05 07:00:00 | MSFT | Stock | 15.88 | 15.9 | 15.81 | 15.81 | 2800.0 |
| 2009-03-05 07:30:00 | MSFT | Stock | 15.85 | 15.95 | 15.82 | 15.91 | 5200.0 |
| 2009-03-05 08:00:00 | MSFT | Stock | 15.94 | 15.99 | 15.88 | 15.95 | 27356.0 |
| 2009-03-05 08:30:00 | MSFT | Stock | 15.98 | 15.98 | 15.87 | 15.9 | 81133.0 |
| 2009-03-05 09:00:00 | MSFT | Stock | 15.94 | 15.99 | 15.81 | 15.86 | 99934.0 |
| 2009-03-05 09:30:00 | MSFT | Stock | 15.86 | 15.88 | 15.74 | 15.79 | 6313678.0 |
| 2009-03-05 10:00:00 | MSFT | Stock | 15.8 | 15.86 | 15.68 | 15.68 | 4769683.0 |
| 2009-03-05 10:30:00 | MSFT | Stock | 15.68 | 15.696 | 15.57 | 15.58 | 5990178.0 |
| 2009-03-05 11:00:00 | MSFT | Stock | 15.58 | 15.71 | 15.52 | 15.54 | 4513017.0 |
| 2009-03-05 11:30:00 | MSFT | Stock | 15.54 | 15.62 | 15.52 | 15.56 | 2819340.0 |
| 2009-03-05 12:00:00 | MSFT | Stock | 15.552 | 15.57 | 15.43 | 15.57 | 4299999.0 |
| 2009-03-05 12:30:00 | MSFT | Stock | 15.56 | 15.58 | 15.41 | 15.46 | 2773475.0 |
| 2009-03-05 13:00:00 | MSFT | Stock | 15.45 | 15.63 | 15.44 | 15.62 | 3738401.0 |
| 2009-03-05 13:30:00 | MSFT | Stock | 15.62 | 15.63 | 15.44 | 15.51 | 4128287.0 |
| 2009-03-05 14:00:00 | MSFT | Stock | 15.51 | 15.52 | 15.4 | 15.43 | 4660008.0 |
| 2009-03-05 14:30:00 | MSFT | Stock | 15.44 | 15.49 | 15.33 | 15.42 | 7563940.0 |
| 2009-03-05 15:00:00 | MSFT | Stock | 15.42 | 15.6 | 15.37 | 15.49 | 8464742.0 |
| 2009-03-05 15:30:00 | MSFT | Stock | 15.48 | 15.5 | 15.28 | 15.29 | 16247852.0 |
| 2009-03-05 16:00:00 | MSFT | Stock | 15.3 | 15.75 | 15.27 | 15.31 | 6987170.0 |
> showing 50 of 70,483 rows — these rows as CSV