PREVIEW / stock_30min / 2009-09-14
file: by_date/stock_30min/2009/2009-09-14.parquet size: 1.3 MB rows: 72,087 symbols: 3,356
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-09-14 07:00:00 | AAPL | Stock | 6.1036 | 6.1143 | 6.1036 | 6.1071 | 40880.0 |
| 2009-09-14 07:30:00 | AAPL | Stock | 6.0993 | 6.1054 | 6.0982 | 6.1054 | 14000.0 |
| 2009-09-14 08:00:00 | AAPL | Stock | 6.1054 | 6.1154 | 6.1007 | 6.1154 | 189952.0 |
| 2009-09-14 08:30:00 | AAPL | Stock | 6.1107 | 6.1136 | 6.1079 | 6.1136 | 158872.0 |
| 2009-09-14 09:00:00 | AAPL | Stock | 6.1143 | 6.1154 | 6.0982 | 6.1021 | 597324.0 |
| 2009-09-14 09:30:00 | AAPL | Stock | 6.105 | 6.1307 | 6.0804 | 6.1243 | 47838196.0 |
| 2009-09-14 10:00:00 | AAPL | Stock | 6.1232 | 6.1639 | 6.1171 | 6.1614 | 32097884.0 |
| 2009-09-14 10:30:00 | AAPL | Stock | 6.1614 | 6.1768 | 6.1582 | 6.1704 | 24735116.0 |
| 2009-09-14 11:00:00 | AAPL | Stock | 6.1704 | 6.1786 | 6.1607 | 6.175 | 17160976.0 |
| 2009-09-14 11:30:00 | AAPL | Stock | 6.175 | 6.1779 | 6.1532 | 6.1604 | 13426728.0 |
| 2009-09-14 12:00:00 | AAPL | Stock | 6.1593 | 6.17 | 6.1525 | 6.1686 | 7476420.0 |
| 2009-09-14 12:30:00 | AAPL | Stock | 6.1686 | 6.1786 | 6.1654 | 6.1718 | 22867488.0 |
| 2009-09-14 13:00:00 | AAPL | Stock | 6.1718 | 6.1768 | 6.165 | 6.175 | 9830268.0 |
| 2009-09-14 13:30:00 | AAPL | Stock | 6.1746 | 6.1839 | 6.1643 | 6.1656 | 22255772.0 |
| 2009-09-14 14:00:00 | AAPL | Stock | 6.1657 | 6.1875 | 6.1618 | 6.1871 | 16947308.0 |
| 2009-09-14 14:30:00 | AAPL | Stock | 6.1875 | 6.1925 | 6.1782 | 6.1854 | 24550960.0 |
| 2009-09-14 15:00:00 | AAPL | Stock | 6.1854 | 6.1907 | 6.1732 | 6.1736 | 16755060.0 |
| 2009-09-14 15:30:00 | AAPL | Stock | 6.1737 | 6.2107 | 6.1732 | 6.2036 | 41579384.0 |
| 2009-09-14 16:00:00 | AAPL | Stock | 6.2036 | 6.2089 | 6.1612 | 6.1615 | 14182112.0 |
| 2009-09-14 16:30:00 | AAPL | Stock | 6.2064 | 6.2082 | 6.2021 | 6.2036 | 1821092.0 |
| 2009-09-14 17:00:00 | AAPL | Stock | 6.2036 | 6.2089 | 6.2018 | 6.2075 | 231140.0 |
| 2009-09-14 17:30:00 | AAPL | Stock | 6.2061 | 6.2086 | 6.2061 | 6.2071 | 39088.0 |
| 2009-09-14 18:00:00 | AAPL | Stock | 6.2043 | 6.2082 | 6.2043 | 6.2082 | 98504.0 |
| 2009-09-14 18:30:00 | AAPL | Stock | 6.2082 | 6.2086 | 6.2043 | 6.2064 | 145824.0 |
| 2009-09-14 19:00:00 | AAPL | Stock | 6.2068 | 6.2071 | 6.2004 | 6.2071 | 77616.0 |
| 2009-09-14 19:30:00 | AAPL | Stock | 6.2057 | 6.2089 | 6.2046 | 6.2089 | 113036.0 |
| 2009-09-14 05:30:00 | MSFT | Stock | 24.62 | 24.62 | 24.62 | 24.62 | 300.0 |
| 2009-09-14 07:00:00 | MSFT | Stock | 24.67 | 24.76 | 24.67 | 24.75 | 2300.0 |
| 2009-09-14 07:30:00 | MSFT | Stock | 24.75 | 24.75 | 24.75 | 24.75 | 2930.0 |
| 2009-09-14 08:00:00 | MSFT | Stock | 24.75 | 24.81 | 24.7 | 24.77 | 17526.0 |
| 2009-09-14 08:30:00 | MSFT | Stock | 24.73 | 24.73 | 24.72 | 24.72 | 300.0 |
| 2009-09-14 09:00:00 | MSFT | Stock | 24.76 | 24.79 | 24.65 | 24.66 | 37518.0 |
| 2009-09-14 09:30:00 | MSFT | Stock | 24.65 | 24.98 | 24.64 | 24.96 | 5513359.0 |
| 2009-09-14 10:00:00 | MSFT | Stock | 24.96 | 25.0 | 24.9 | 24.99 | 3245440.0 |
| 2009-09-14 10:30:00 | MSFT | Stock | 24.99 | 25.09 | 24.95 | 25.03 | 3519492.0 |
| 2009-09-14 11:00:00 | MSFT | Stock | 25.04 | 25.06 | 25.0 | 25.01 | 2363011.0 |
| 2009-09-14 11:30:00 | MSFT | Stock | 25.015 | 25.02 | 24.94 | 24.97 | 1688022.0 |
| 2009-09-14 12:00:00 | MSFT | Stock | 24.978 | 25.0 | 24.95 | 24.99 | 1047406.0 |
| 2009-09-14 12:30:00 | MSFT | Stock | 24.99 | 25.0 | 24.95 | 24.98 | 1208542.0 |
| 2009-09-14 13:00:00 | MSFT | Stock | 24.982 | 24.99 | 24.95 | 24.98 | 696344.0 |
| 2009-09-14 13:30:00 | MSFT | Stock | 24.97 | 25.03 | 24.97 | 25.01 | 2077983.0 |
| 2009-09-14 14:00:00 | MSFT | Stock | 25.01 | 25.05 | 24.97 | 25.03 | 1349333.0 |
| 2009-09-14 14:30:00 | MSFT | Stock | 25.03 | 25.08 | 25.01 | 25.05 | 2751833.0 |
| 2009-09-14 15:00:00 | MSFT | Stock | 25.05 | 25.055 | 25.0 | 25.02 | 2445275.0 |
| 2009-09-14 15:30:00 | MSFT | Stock | 25.01 | 25.06 | 24.99 | 24.99 | 6484092.0 |
| 2009-09-14 16:00:00 | MSFT | Stock | 24.99 | 25.065 | 24.95 | 24.994 | 5157569.0 |
| 2009-09-14 16:30:00 | MSFT | Stock | 24.96 | 25.016 | 24.95 | 25.016 | 129021.0 |
| 2009-09-14 17:00:00 | MSFT | Stock | 24.96 | 24.96 | 24.96 | 24.96 | 1100.0 |
| 2009-09-14 17:30:00 | MSFT | Stock | 24.96 | 24.96 | 24.96 | 24.96 | 800.0 |
| 2009-09-14 18:00:00 | MSFT | Stock | 25.0 | 25.0 | 24.96 | 24.96 | 17161.0 |
> showing 50 of 72,087 rows — these rows as CSV