PREVIEW / stock_30min / 2010-07-30
file: by_date/stock_30min/2010/2010-07-30.parquet size: 1.3 MB rows: 72,254 symbols: 3,471
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-30 05:30:00 | AAPL | Stock | 9.1982 | 9.1982 | 9.1982 | 9.1982 | 2800.0 |
| 2010-07-30 06:30:00 | AAPL | Stock | 9.185 | 9.185 | 9.185 | 9.185 | 52920.0 |
| 2010-07-30 07:00:00 | AAPL | Stock | 9.1846 | 9.2075 | 9.1846 | 9.2075 | 12600.0 |
| 2010-07-30 07:30:00 | AAPL | Stock | 9.1786 | 9.1904 | 9.1782 | 9.185 | 39200.0 |
| 2010-07-30 08:00:00 | AAPL | Stock | 9.1846 | 9.1893 | 9.1625 | 9.175 | 734608.0 |
| 2010-07-30 08:30:00 | AAPL | Stock | 9.17 | 9.1789 | 9.1439 | 9.1514 | 2489564.0 |
| 2010-07-30 09:00:00 | AAPL | Stock | 9.1514 | 9.1621 | 9.1321 | 9.1468 | 1151584.0 |
| 2010-07-30 09:30:00 | AAPL | Stock | 9.1421 | 9.1643 | 9.1036 | 9.1318 | 78939924.0 |
| 2010-07-30 10:00:00 | AAPL | Stock | 9.1354 | 9.2061 | 9.1304 | 9.1843 | 47151580.0 |
| 2010-07-30 10:30:00 | AAPL | Stock | 9.1821 | 9.2582 | 9.1807 | 9.2286 | 53075932.0 |
| 2010-07-30 11:00:00 | AAPL | Stock | 9.2271 | 9.2425 | 9.1982 | 9.2039 | 21118580.0 |
| 2010-07-30 11:30:00 | AAPL | Stock | 9.2039 | 9.225 | 9.1839 | 9.2205 | 22381296.0 |
| 2010-07-30 12:00:00 | AAPL | Stock | 9.2207 | 9.2318 | 9.1929 | 9.2138 | 17125136.0 |
| 2010-07-30 12:30:00 | AAPL | Stock | 9.2121 | 9.245 | 9.2068 | 9.2379 | 13380248.0 |
| 2010-07-30 13:00:00 | AAPL | Stock | 9.2371 | 9.2446 | 9.1914 | 9.2104 | 18849880.0 |
| 2010-07-30 13:30:00 | AAPL | Stock | 9.2093 | 9.21 | 9.1536 | 9.1581 | 18294136.0 |
| 2010-07-30 14:00:00 | AAPL | Stock | 9.1579 | 9.2114 | 9.1504 | 9.205 | 25920188.0 |
| 2010-07-30 14:30:00 | AAPL | Stock | 9.2054 | 9.2161 | 9.1836 | 9.1932 | 16021376.0 |
| 2010-07-30 15:00:00 | AAPL | Stock | 9.1925 | 9.275 | 9.1821 | 9.2493 | 43069936.0 |
| 2010-07-30 15:30:00 | AAPL | Stock | 9.2496 | 9.2543 | 9.1804 | 9.1889 | 45475388.0 |
| 2010-07-30 16:00:00 | AAPL | Stock | 9.1857 | 9.2153 | 9.1525 | 9.1729 | 22110256.0 |
| 2010-07-30 16:30:00 | AAPL | Stock | 9.1786 | 9.2533 | 9.1782 | 9.1857 | 171500.0 |
| 2010-07-30 17:00:00 | AAPL | Stock | 9.1843 | 9.2054 | 9.1821 | 9.1879 | 169344.0 |
| 2010-07-30 17:30:00 | AAPL | Stock | 9.1843 | 9.1871 | 9.1789 | 9.1821 | 104580.0 |
| 2010-07-30 18:00:00 | AAPL | Stock | 9.1793 | 9.1793 | 9.1786 | 9.1786 | 54068.0 |
| 2010-07-30 18:30:00 | AAPL | Stock | 9.1732 | 9.1875 | 9.1714 | 9.1714 | 107772.0 |
| 2010-07-30 19:00:00 | AAPL | Stock | 9.1714 | 9.1786 | 9.1714 | 9.1786 | 31164.0 |
| 2010-07-30 19:30:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1714 | 9.1786 | 39172.0 |
| 2010-07-30 07:00:00 | MSFT | Stock | 26.0 | 26.0 | 26.0 | 26.0 | 2000.0 |
| 2010-07-30 07:30:00 | MSFT | Stock | 25.95 | 25.95 | 25.95 | 25.95 | 300.0 |
| 2010-07-30 08:00:00 | MSFT | Stock | 25.9 | 26.03 | 25.8 | 25.9 | 96413.0 |
| 2010-07-30 08:30:00 | MSFT | Stock | 25.82 | 25.87 | 25.72 | 25.84 | 37770.0 |
| 2010-07-30 09:00:00 | MSFT | Stock | 25.83 | 25.84 | 25.7 | 25.73 | 137712.0 |
| 2010-07-30 09:30:00 | MSFT | Stock | 25.75 | 25.84 | 25.35 | 25.46 | 15047468.0 |
| 2010-07-30 10:00:00 | MSFT | Stock | 25.46 | 25.61 | 25.43 | 25.452 | 7071649.0 |
| 2010-07-30 10:30:00 | MSFT | Stock | 25.46 | 25.62 | 25.44 | 25.51 | 5163084.0 |
| 2010-07-30 11:00:00 | MSFT | Stock | 25.505 | 25.72 | 25.5 | 25.65 | 6163730.0 |
| 2010-07-30 11:30:00 | MSFT | Stock | 25.65 | 25.715 | 25.6 | 25.69 | 3134098.0 |
| 2010-07-30 12:00:00 | MSFT | Stock | 25.69 | 25.739 | 25.61 | 25.68 | 2216840.0 |
| 2010-07-30 12:30:00 | MSFT | Stock | 25.68 | 25.68 | 25.54 | 25.55 | 4016858.0 |
| 2010-07-30 13:00:00 | MSFT | Stock | 25.55 | 25.57 | 25.49 | 25.54 | 4454242.0 |
| 2010-07-30 13:30:00 | MSFT | Stock | 25.53 | 25.59 | 25.51 | 25.55 | 2871283.0 |
| 2010-07-30 14:00:00 | MSFT | Stock | 25.55 | 25.7 | 25.53 | 25.67 | 3219769.0 |
| 2010-07-30 14:30:00 | MSFT | Stock | 25.67 | 25.72 | 25.64 | 25.67 | 2884668.0 |
| 2010-07-30 15:00:00 | MSFT | Stock | 25.67 | 25.84 | 25.65 | 25.785 | 5381743.0 |
| 2010-07-30 15:30:00 | MSFT | Stock | 25.79 | 25.84 | 25.7 | 25.8 | 12941303.0 |
| 2010-07-30 16:00:00 | MSFT | Stock | 25.8 | 25.84 | 25.612 | 25.812 | 7477791.0 |
| 2010-07-30 16:30:00 | MSFT | Stock | 25.78 | 25.81 | 25.73 | 25.77 | 33993.0 |
| 2010-07-30 17:00:00 | MSFT | Stock | 25.77 | 25.77 | 25.77 | 25.77 | 1250.0 |
| 2010-07-30 17:30:00 | MSFT | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 1100.0 |
> showing 50 of 72,254 rows — these rows as CSV