PREVIEW / stock_30min / 2008-11-17
file: by_date/stock_30min/2008/2008-11-17.parquet size: 1.2 MB rows: 68,637 symbols: 3,310
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-17 07:00:00 | AAPL | Stock | 3.225 | 3.225 | 3.1961 | 3.1964 | 82600.0 |
| 2008-11-17 07:30:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 112000.0 |
| 2008-11-17 08:00:00 | AAPL | Stock | 3.1786 | 3.1921 | 3.1639 | 3.1786 | 1270556.0 |
| 2008-11-17 08:30:00 | AAPL | Stock | 3.1818 | 3.1843 | 3.1304 | 3.1393 | 2976148.0 |
| 2008-11-17 09:00:00 | AAPL | Stock | 3.1393 | 3.1675 | 3.135 | 3.1589 | 2604196.0 |
| 2008-11-17 09:30:00 | AAPL | Stock | 3.16 | 3.2082 | 3.1379 | 3.1482 | 147713076.0 |
| 2008-11-17 10:00:00 | AAPL | Stock | 3.1489 | 3.1546 | 3.1179 | 3.1307 | 127718472.0 |
| 2008-11-17 10:30:00 | AAPL | Stock | 3.1314 | 3.1518 | 3.1164 | 3.1382 | 81371472.0 |
| 2008-11-17 11:00:00 | AAPL | Stock | 3.1375 | 3.1736 | 3.1361 | 3.1543 | 69349616.0 |
| 2008-11-17 11:30:00 | AAPL | Stock | 3.1546 | 3.2093 | 3.1532 | 3.1914 | 72218916.0 |
| 2008-11-17 12:00:00 | AAPL | Stock | 3.1904 | 3.2032 | 3.1804 | 3.1964 | 66899084.0 |
| 2008-11-17 12:30:00 | AAPL | Stock | 3.1968 | 3.2339 | 3.1732 | 3.2218 | 86997540.0 |
| 2008-11-17 13:00:00 | AAPL | Stock | 3.2221 | 3.2254 | 3.1971 | 3.205 | 63150192.0 |
| 2008-11-17 13:30:00 | AAPL | Stock | 3.205 | 3.2114 | 3.1729 | 3.1943 | 60389756.0 |
| 2008-11-17 14:00:00 | AAPL | Stock | 3.1943 | 3.21 | 3.1725 | 3.1861 | 61733980.0 |
| 2008-11-17 14:30:00 | AAPL | Stock | 3.1864 | 3.2211 | 3.1754 | 3.2025 | 79766176.0 |
| 2008-11-17 15:00:00 | AAPL | Stock | 3.2018 | 3.2311 | 3.1864 | 3.2007 | 88983804.0 |
| 2008-11-17 15:30:00 | AAPL | Stock | 3.2009 | 3.2132 | 3.1329 | 3.1511 | 117723480.0 |
| 2008-11-17 16:00:00 | AAPL | Stock | 3.1505 | 3.1841 | 3.1443 | 3.1607 | 24439884.0 |
| 2008-11-17 16:30:00 | AAPL | Stock | 3.1479 | 3.1661 | 3.1479 | 3.16 | 640164.0 |
| 2008-11-17 17:00:00 | AAPL | Stock | 3.1618 | 3.1625 | 3.1518 | 3.1568 | 210952.0 |
| 2008-11-17 17:30:00 | AAPL | Stock | 3.1571 | 3.1596 | 3.1479 | 3.1596 | 128716.0 |
| 2008-11-17 18:00:00 | AAPL | Stock | 3.1561 | 3.1593 | 3.1536 | 3.1593 | 85540.0 |
| 2008-11-17 18:30:00 | AAPL | Stock | 3.1589 | 3.1593 | 3.1571 | 3.1571 | 106120.0 |
| 2008-11-17 19:00:00 | AAPL | Stock | 3.1579 | 3.1625 | 3.1571 | 3.1621 | 171724.0 |
| 2008-11-17 19:30:00 | AAPL | Stock | 3.1625 | 3.1639 | 3.1596 | 3.1636 | 49476.0 |
| 2008-11-17 08:00:00 | MSFT | Stock | 19.94 | 19.96 | 19.75 | 19.75 | 18425.0 |
| 2008-11-17 08:30:00 | MSFT | Stock | 19.7 | 19.73 | 19.61 | 19.65 | 34661.0 |
| 2008-11-17 09:00:00 | MSFT | Stock | 19.65 | 19.85 | 19.65 | 19.7 | 21538.0 |
| 2008-11-17 09:30:00 | MSFT | Stock | 19.7 | 19.79 | 19.16 | 19.47 | 10483052.0 |
| 2008-11-17 10:00:00 | MSFT | Stock | 19.48 | 19.49 | 19.15 | 19.2 | 9060643.0 |
| 2008-11-17 10:30:00 | MSFT | Stock | 19.2 | 19.29 | 19.15 | 19.15 | 5280047.0 |
| 2008-11-17 11:00:00 | MSFT | Stock | 19.16 | 19.57 | 19.15 | 19.54 | 5012358.0 |
| 2008-11-17 11:30:00 | MSFT | Stock | 19.55 | 19.97 | 19.51 | 19.92 | 6173635.0 |
| 2008-11-17 12:00:00 | MSFT | Stock | 19.92 | 20.13 | 19.86 | 20.11 | 5312885.0 |
| 2008-11-17 12:30:00 | MSFT | Stock | 20.11 | 20.24 | 19.93 | 20.015 | 5656743.0 |
| 2008-11-17 13:00:00 | MSFT | Stock | 20.02 | 20.06 | 19.88 | 19.99 | 5174686.0 |
| 2008-11-17 13:30:00 | MSFT | Stock | 19.99 | 20.015 | 19.87 | 19.93 | 5330835.0 |
| 2008-11-17 14:00:00 | MSFT | Stock | 19.93 | 19.96 | 19.74 | 19.77 | 4744254.0 |
| 2008-11-17 14:30:00 | MSFT | Stock | 19.78 | 19.97 | 19.69 | 19.79 | 5063268.0 |
| 2008-11-17 15:00:00 | MSFT | Stock | 19.79 | 19.955 | 19.67 | 19.822 | 5954180.0 |
| 2008-11-17 15:30:00 | MSFT | Stock | 19.82 | 19.91 | 19.31 | 19.32 | 11095022.0 |
| 2008-11-17 16:00:00 | MSFT | Stock | 19.33 | 19.75 | 19.25 | 19.46 | 11569382.0 |
| 2008-11-17 16:30:00 | MSFT | Stock | 19.32 | 19.46 | 19.32 | 19.4 | 729159.0 |
| 2008-11-17 17:00:00 | MSFT | Stock | 19.42 | 19.48 | 19.42 | 19.42 | 6581.0 |
| 2008-11-17 17:30:00 | MSFT | Stock | 19.32 | 19.48 | 19.32 | 19.45 | 9729.0 |
| 2008-11-17 18:00:00 | MSFT | Stock | 19.43 | 19.43 | 19.41 | 19.41 | 4437.0 |
| 2008-11-17 18:30:00 | MSFT | Stock | 19.38 | 19.43 | 19.38 | 19.4 | 1021.0 |
| 2008-11-17 19:30:00 | MSFT | Stock | 19.44 | 19.45 | 19.38 | 19.42 | 6810.0 |
| 2008-11-17 08:00:00 | NVDA | Stock | 0.1793 | 0.1793 | 0.1793 | 0.1793 | 110000.0 |
> showing 50 of 68,637 rows — these rows as CSV