PREVIEW / stock_5min / 2007-03-12
file: by_date/stock_5min/2007/2007-03-12.parquet size: 3.4 MB rows: 247,743 symbols: 2,528
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-12 05:05:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 8400.0 |
| 2007-03-12 07:05:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 56000.0 |
| 2007-03-12 07:45:00 | AAPL | Stock | 3.1625 | 3.1696 | 3.1625 | 3.1696 | 285600.0 |
| 2007-03-12 07:50:00 | AAPL | Stock | 3.1679 | 3.1693 | 3.1643 | 3.1686 | 134400.0 |
| 2007-03-12 07:55:00 | AAPL | Stock | 3.1679 | 3.1679 | 3.1643 | 3.1643 | 75600.0 |
| 2007-03-12 08:00:00 | AAPL | Stock | 3.1589 | 3.1607 | 3.1575 | 3.1589 | 362348.0 |
| 2007-03-12 08:05:00 | AAPL | Stock | 3.1564 | 3.1564 | 3.1518 | 3.1518 | 170800.0 |
| 2007-03-12 08:10:00 | AAPL | Stock | 3.1529 | 3.1532 | 3.15 | 3.15 | 168000.0 |
| 2007-03-12 08:15:00 | AAPL | Stock | 3.1489 | 3.1489 | 3.1489 | 3.1489 | 14000.0 |
| 2007-03-12 08:25:00 | AAPL | Stock | 3.15 | 3.15 | 3.1482 | 3.1482 | 75600.0 |
| 2007-03-12 08:30:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1432 | 3.1432 | 128660.0 |
| 2007-03-12 08:45:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 78400.0 |
| 2007-03-12 08:50:00 | AAPL | Stock | 3.1432 | 3.1432 | 3.1414 | 3.1429 | 28700.0 |
| 2007-03-12 08:55:00 | AAPL | Stock | 3.1457 | 3.1479 | 3.1457 | 3.1475 | 106232.0 |
| 2007-03-12 09:05:00 | AAPL | Stock | 3.145 | 3.145 | 3.1429 | 3.1429 | 134820.0 |
| 2007-03-12 09:10:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1429 | 3.1429 | 74200.0 |
| 2007-03-12 09:15:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.14 | 3.14 | 47740.0 |
| 2007-03-12 09:20:00 | AAPL | Stock | 3.1407 | 3.1414 | 3.1407 | 3.1411 | 100800.0 |
| 2007-03-12 09:25:00 | AAPL | Stock | 3.1429 | 3.1446 | 3.1429 | 3.1429 | 69160.0 |
| 2007-03-12 09:30:00 | AAPL | Stock | 3.1429 | 3.1632 | 3.1425 | 3.1632 | 13477072.0 |
| 2007-03-12 09:35:00 | AAPL | Stock | 3.1629 | 3.1696 | 3.1579 | 3.1621 | 15211112.0 |
| 2007-03-12 09:40:00 | AAPL | Stock | 3.1625 | 3.1639 | 3.1518 | 3.1543 | 12029052.0 |
| 2007-03-12 09:45:00 | AAPL | Stock | 3.1543 | 3.1568 | 3.1454 | 3.146 | 12989956.0 |
| 2007-03-12 09:50:00 | AAPL | Stock | 3.1457 | 3.1582 | 3.1446 | 3.1557 | 8978284.0 |
| 2007-03-12 09:55:00 | AAPL | Stock | 3.1561 | 3.1625 | 3.1518 | 3.1596 | 12137132.0 |
| 2007-03-12 10:00:00 | AAPL | Stock | 3.16 | 3.1654 | 3.1571 | 3.1632 | 10647560.0 |
| 2007-03-12 10:05:00 | AAPL | Stock | 3.1632 | 3.1657 | 3.1575 | 3.1582 | 9799188.0 |
| 2007-03-12 10:10:00 | AAPL | Stock | 3.1579 | 3.1668 | 3.1575 | 3.1639 | 10403960.0 |
| 2007-03-12 10:15:00 | AAPL | Stock | 3.1639 | 3.1696 | 3.1625 | 3.1692 | 11930184.0 |
| 2007-03-12 10:20:00 | AAPL | Stock | 3.1693 | 3.1868 | 3.1689 | 3.1843 | 34386100.0 |
| 2007-03-12 10:25:00 | AAPL | Stock | 3.1843 | 3.1954 | 3.1839 | 3.1882 | 26079032.0 |
| 2007-03-12 10:30:00 | AAPL | Stock | 3.1882 | 3.1925 | 3.1854 | 3.1896 | 13262284.0 |
| 2007-03-12 10:35:00 | AAPL | Stock | 3.19 | 3.19 | 3.1864 | 3.1875 | 10073196.0 |
| 2007-03-12 10:40:00 | AAPL | Stock | 3.1875 | 3.1875 | 3.1789 | 3.1811 | 13720196.0 |
| 2007-03-12 10:45:00 | AAPL | Stock | 3.1811 | 3.1871 | 3.1807 | 3.1864 | 10519740.0 |
| 2007-03-12 10:50:00 | AAPL | Stock | 3.1868 | 3.1982 | 3.1836 | 3.1932 | 23849448.0 |
| 2007-03-12 10:55:00 | AAPL | Stock | 3.1932 | 3.1936 | 3.1893 | 3.1932 | 11067252.0 |
| 2007-03-12 11:00:00 | AAPL | Stock | 3.1932 | 3.1964 | 3.1929 | 3.1939 | 9184644.0 |
| 2007-03-12 11:05:00 | AAPL | Stock | 3.1939 | 3.1989 | 3.1918 | 3.1939 | 12297824.0 |
| 2007-03-12 11:10:00 | AAPL | Stock | 3.1943 | 3.2021 | 3.1936 | 3.2007 | 16330832.0 |
| 2007-03-12 11:15:00 | AAPL | Stock | 3.2007 | 3.205 | 3.1982 | 3.2043 | 14711508.0 |
| 2007-03-12 11:20:00 | AAPL | Stock | 3.2043 | 3.21 | 3.2018 | 3.2079 | 19590844.0 |
| 2007-03-12 11:25:00 | AAPL | Stock | 3.2075 | 3.2078 | 3.1989 | 3.2025 | 17953712.0 |
| 2007-03-12 11:30:00 | AAPL | Stock | 3.2025 | 3.2068 | 3.1979 | 3.2032 | 9711940.0 |
| 2007-03-12 11:35:00 | AAPL | Stock | 3.2032 | 3.2094 | 3.2018 | 3.2079 | 8540588.0 |
| 2007-03-12 11:40:00 | AAPL | Stock | 3.2079 | 3.2089 | 3.2007 | 3.2036 | 8862980.0 |
| 2007-03-12 11:45:00 | AAPL | Stock | 3.2036 | 3.2043 | 3.1989 | 3.2032 | 7041552.0 |
| 2007-03-12 11:50:00 | AAPL | Stock | 3.2036 | 3.21 | 3.2029 | 3.2046 | 9256268.0 |
| 2007-03-12 11:55:00 | AAPL | Stock | 3.2046 | 3.2061 | 3.2018 | 3.2036 | 4390764.0 |
| 2007-03-12 12:00:00 | AAPL | Stock | 3.2039 | 3.2064 | 3.2011 | 3.2029 | 5998244.0 |
> showing 50 of 247,743 rows — these rows as CSV