PREVIEW / stock_5min / 2008-11-13
file: by_date/stock_5min/2008/2008-11-13.parquet size: 4.6 MB rows: 319,615 symbols: 3,327
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-11-13 05:15:00 | AAPL | Stock | 3.1746 | 3.1814 | 3.1746 | 3.1814 | 14000.0 |
| 2008-11-13 05:35:00 | AAPL | Stock | 3.1629 | 3.1629 | 3.1607 | 3.1607 | 14000.0 |
| 2008-11-13 05:45:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 16912.0 |
| 2008-11-13 05:50:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 5600.0 |
| 2008-11-13 06:05:00 | AAPL | Stock | 3.1429 | 3.1607 | 3.1429 | 3.1607 | 6888.0 |
| 2008-11-13 06:45:00 | AAPL | Stock | 3.16 | 3.1604 | 3.16 | 3.1604 | 11200.0 |
| 2008-11-13 06:55:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 28000.0 |
| 2008-11-13 07:00:00 | AAPL | Stock | 3.1807 | 3.1807 | 3.1807 | 3.1807 | 14000.0 |
| 2008-11-13 07:05:00 | AAPL | Stock | 3.1857 | 3.1857 | 3.1854 | 3.1854 | 5600.0 |
| 2008-11-13 07:10:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1875 | 3.1875 | 5600.0 |
| 2008-11-13 07:20:00 | AAPL | Stock | 3.2039 | 3.2039 | 3.1964 | 3.1964 | 29848.0 |
| 2008-11-13 07:25:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2 | 3.2 | 38724.0 |
| 2008-11-13 07:30:00 | AAPL | Stock | 3.2143 | 3.2179 | 3.2143 | 3.2143 | 75600.0 |
| 2008-11-13 07:35:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 188216.0 |
| 2008-11-13 07:40:00 | AAPL | Stock | 3.2054 | 3.2054 | 3.2054 | 3.2054 | 56000.0 |
| 2008-11-13 07:45:00 | AAPL | Stock | 3.2054 | 3.21 | 3.2054 | 3.21 | 37016.0 |
| 2008-11-13 07:50:00 | AAPL | Stock | 3.2054 | 3.2679 | 3.2054 | 3.215 | 130396.0 |
| 2008-11-13 07:55:00 | AAPL | Stock | 3.2054 | 3.2054 | 3.1968 | 3.2 | 47040.0 |
| 2008-11-13 08:00:00 | AAPL | Stock | 3.2 | 3.2064 | 3.1786 | 3.1925 | 537236.0 |
| 2008-11-13 08:05:00 | AAPL | Stock | 3.1943 | 3.1943 | 3.1814 | 3.1825 | 197876.0 |
| 2008-11-13 08:10:00 | AAPL | Stock | 3.1814 | 3.1843 | 3.1786 | 3.1811 | 118272.0 |
| 2008-11-13 08:15:00 | AAPL | Stock | 3.1821 | 3.1871 | 3.1821 | 3.1829 | 56840.0 |
| 2008-11-13 08:20:00 | AAPL | Stock | 3.1836 | 3.1946 | 3.1836 | 3.1889 | 183092.0 |
| 2008-11-13 08:25:00 | AAPL | Stock | 3.1893 | 3.1939 | 3.1857 | 3.1857 | 116900.0 |
| 2008-11-13 08:30:00 | AAPL | Stock | 3.1857 | 3.1871 | 3.1786 | 3.185 | 496692.0 |
| 2008-11-13 08:35:00 | AAPL | Stock | 3.1857 | 3.1964 | 3.1789 | 3.1929 | 667604.0 |
| 2008-11-13 08:40:00 | AAPL | Stock | 3.1896 | 3.1911 | 3.1857 | 3.1857 | 77140.0 |
| 2008-11-13 08:45:00 | AAPL | Stock | 3.1861 | 3.1875 | 3.1807 | 3.1839 | 290388.0 |
| 2008-11-13 08:50:00 | AAPL | Stock | 3.1839 | 3.1843 | 3.1754 | 3.1771 | 307944.0 |
| 2008-11-13 08:55:00 | AAPL | Stock | 3.1782 | 3.1786 | 3.1596 | 3.1611 | 657076.0 |
| 2008-11-13 09:00:00 | AAPL | Stock | 3.1621 | 3.175 | 3.1621 | 3.175 | 867552.0 |
| 2008-11-13 09:05:00 | AAPL | Stock | 3.175 | 3.1857 | 3.175 | 3.1804 | 276304.0 |
| 2008-11-13 09:10:00 | AAPL | Stock | 3.1786 | 3.1925 | 3.1779 | 3.1896 | 571648.0 |
| 2008-11-13 09:15:00 | AAPL | Stock | 3.1889 | 3.1946 | 3.1882 | 3.1889 | 345940.0 |
| 2008-11-13 09:20:00 | AAPL | Stock | 3.1864 | 3.1911 | 3.1857 | 3.1904 | 189028.0 |
| 2008-11-13 09:25:00 | AAPL | Stock | 3.1904 | 3.2143 | 3.1893 | 3.2071 | 1966468.0 |
| 2008-11-13 09:30:00 | AAPL | Stock | 3.2075 | 3.2621 | 3.1986 | 3.2364 | 39843328.0 |
| 2008-11-13 09:35:00 | AAPL | Stock | 3.2368 | 3.2732 | 3.2337 | 3.2464 | 32778508.0 |
| 2008-11-13 09:40:00 | AAPL | Stock | 3.2464 | 3.2679 | 3.2318 | 3.2346 | 26399800.0 |
| 2008-11-13 09:45:00 | AAPL | Stock | 3.235 | 3.2386 | 3.2018 | 3.2154 | 37588740.0 |
| 2008-11-13 09:50:00 | AAPL | Stock | 3.2161 | 3.2246 | 3.1879 | 3.1964 | 28663964.0 |
| 2008-11-13 09:55:00 | AAPL | Stock | 3.1964 | 3.2021 | 3.1721 | 3.1782 | 28749056.0 |
| 2008-11-13 10:00:00 | AAPL | Stock | 3.1775 | 3.2061 | 3.1736 | 3.1914 | 30399824.0 |
| 2008-11-13 10:05:00 | AAPL | Stock | 3.1918 | 3.1946 | 3.1436 | 3.1446 | 28935312.0 |
| 2008-11-13 10:10:00 | AAPL | Stock | 3.1454 | 3.1875 | 3.1447 | 3.1771 | 32735696.0 |
| 2008-11-13 10:15:00 | AAPL | Stock | 3.1771 | 3.2289 | 3.1771 | 3.2068 | 36364636.0 |
| 2008-11-13 10:20:00 | AAPL | Stock | 3.2068 | 3.2479 | 3.2029 | 3.2425 | 28083692.0 |
| 2008-11-13 10:25:00 | AAPL | Stock | 3.2425 | 3.2589 | 3.2364 | 3.2468 | 29561476.0 |
| 2008-11-13 10:30:00 | AAPL | Stock | 3.2475 | 3.2539 | 3.2221 | 3.2279 | 23018968.0 |
| 2008-11-13 10:35:00 | AAPL | Stock | 3.2271 | 3.2368 | 3.2157 | 3.2254 | 16114252.0 |
> showing 50 of 319,615 rows — these rows as CSV