PREVIEW / stock_30min / 2009-11-19
file: by_date/stock_30min/2009/2009-11-19.parquet size: 1.3 MB rows: 70,788 symbols: 3,403
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-11-19 05:30:00 | AAPL | Stock | 7.3232 | 7.3232 | 7.3232 | 7.3232 | 13888.0 |
| 2009-11-19 06:30:00 | AAPL | Stock | 7.3171 | 7.3171 | 7.3089 | 7.3089 | 27468.0 |
| 2009-11-19 07:00:00 | AAPL | Stock | 7.3089 | 7.3089 | 7.2857 | 7.2857 | 115388.0 |
| 2009-11-19 07:30:00 | AAPL | Stock | 7.2893 | 7.2954 | 7.2714 | 7.285 | 329644.0 |
| 2009-11-19 08:00:00 | AAPL | Stock | 7.285 | 7.2982 | 7.2719 | 7.2982 | 851704.0 |
| 2009-11-19 08:30:00 | AAPL | Stock | 7.2946 | 7.3214 | 7.2932 | 7.3086 | 965104.0 |
| 2009-11-19 09:00:00 | AAPL | Stock | 7.3104 | 7.3186 | 7.3071 | 7.3104 | 377720.0 |
| 2009-11-19 09:30:00 | AAPL | Stock | 7.3107 | 7.3129 | 7.165 | 7.18 | 118028596.0 |
| 2009-11-19 10:00:00 | AAPL | Stock | 7.1789 | 7.2204 | 7.1771 | 7.2082 | 56094416.0 |
| 2009-11-19 10:30:00 | AAPL | Stock | 7.2079 | 7.2175 | 7.1829 | 7.1911 | 40313308.0 |
| 2009-11-19 11:00:00 | AAPL | Stock | 7.1904 | 7.1993 | 7.1786 | 7.1982 | 23439696.0 |
| 2009-11-19 11:30:00 | AAPL | Stock | 7.1975 | 7.2121 | 7.1889 | 7.2121 | 17530380.0 |
| 2009-11-19 12:00:00 | AAPL | Stock | 7.2118 | 7.2196 | 7.19 | 7.2079 | 19438160.0 |
| 2009-11-19 12:30:00 | AAPL | Stock | 7.2079 | 7.2143 | 7.1686 | 7.1786 | 30310980.0 |
| 2009-11-19 13:00:00 | AAPL | Stock | 7.1786 | 7.1893 | 7.1546 | 7.1618 | 27251784.0 |
| 2009-11-19 13:30:00 | AAPL | Stock | 7.16 | 7.1804 | 7.16 | 7.1757 | 21399728.0 |
| 2009-11-19 14:00:00 | AAPL | Stock | 7.1761 | 7.1771 | 7.1357 | 7.1557 | 51395988.0 |
| 2009-11-19 14:30:00 | AAPL | Stock | 7.1557 | 7.1836 | 7.1518 | 7.1643 | 28507248.0 |
| 2009-11-19 15:00:00 | AAPL | Stock | 7.1643 | 7.1739 | 7.1518 | 7.1561 | 25472216.0 |
| 2009-11-19 15:30:00 | AAPL | Stock | 7.1564 | 7.1836 | 7.1493 | 7.1579 | 62402312.0 |
| 2009-11-19 16:00:00 | AAPL | Stock | 7.1607 | 7.1896 | 7.145 | 7.1486 | 10392284.0 |
| 2009-11-19 16:30:00 | AAPL | Stock | 7.1554 | 7.1568 | 7.1482 | 7.155 | 157948.0 |
| 2009-11-19 17:00:00 | AAPL | Stock | 7.1521 | 7.1521 | 7.145 | 7.1482 | 122024.0 |
| 2009-11-19 17:30:00 | AAPL | Stock | 7.145 | 7.3557 | 7.1429 | 7.1464 | 677404.0 |
| 2009-11-19 18:00:00 | AAPL | Stock | 7.1429 | 7.1582 | 7.1393 | 7.1411 | 1426068.0 |
| 2009-11-19 18:30:00 | AAPL | Stock | 7.14 | 7.1429 | 7.1393 | 7.1411 | 111412.0 |
| 2009-11-19 19:00:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1396 | 7.1421 | 57988.0 |
| 2009-11-19 19:30:00 | AAPL | Stock | 7.1396 | 7.1436 | 7.1339 | 7.1357 | 405608.0 |
| 2009-11-19 05:00:00 | MSFT | Stock | 29.85 | 29.85 | 29.8 | 29.8 | 2600.0 |
| 2009-11-19 06:00:00 | MSFT | Stock | 29.81 | 29.81 | 29.81 | 29.81 | 500.0 |
| 2009-11-19 07:30:00 | MSFT | Stock | 29.98 | 29.98 | 29.96 | 29.96 | 11900.0 |
| 2009-11-19 08:00:00 | MSFT | Stock | 29.97 | 30.05 | 29.95 | 29.95 | 59048.0 |
| 2009-11-19 08:30:00 | MSFT | Stock | 29.98 | 30.05 | 29.98 | 30.02 | 91166.0 |
| 2009-11-19 09:00:00 | MSFT | Stock | 30.02 | 30.05 | 29.96 | 30.0 | 165624.0 |
| 2009-11-19 09:30:00 | MSFT | Stock | 30.0 | 30.0 | 29.75 | 29.82 | 7742773.0 |
| 2009-11-19 10:00:00 | MSFT | Stock | 29.82 | 29.9 | 29.79 | 29.84 | 4026717.0 |
| 2009-11-19 10:30:00 | MSFT | Stock | 29.845 | 29.85 | 29.75 | 29.755 | 5875469.0 |
| 2009-11-19 11:00:00 | MSFT | Stock | 29.75 | 29.82 | 29.7 | 29.76 | 3489933.0 |
| 2009-11-19 11:30:00 | MSFT | Stock | 29.758 | 29.78 | 29.7 | 29.76 | 3899333.0 |
| 2009-11-19 12:00:00 | MSFT | Stock | 29.765 | 29.94 | 29.73 | 29.93 | 4325132.0 |
| 2009-11-19 12:30:00 | MSFT | Stock | 29.93 | 29.97 | 29.85 | 29.87 | 2057646.0 |
| 2009-11-19 13:00:00 | MSFT | Stock | 29.87 | 29.9 | 29.81 | 29.831 | 1616618.0 |
| 2009-11-19 13:30:00 | MSFT | Stock | 29.84 | 29.9 | 29.83 | 29.87 | 1666151.0 |
| 2009-11-19 14:00:00 | MSFT | Stock | 29.87 | 29.9 | 29.8 | 29.87 | 2498288.0 |
| 2009-11-19 14:30:00 | MSFT | Stock | 29.875 | 29.89 | 29.82 | 29.82 | 1946901.0 |
| 2009-11-19 15:00:00 | MSFT | Stock | 29.82 | 29.87 | 29.8 | 29.82 | 2811402.0 |
| 2009-11-19 15:30:00 | MSFT | Stock | 29.82 | 29.88 | 29.77 | 29.77 | 6059369.0 |
| 2009-11-19 16:00:00 | MSFT | Stock | 29.77 | 30.11 | 29.7 | 29.75 | 2152718.0 |
| 2009-11-19 16:30:00 | MSFT | Stock | 29.79 | 29.83 | 29.75 | 29.76 | 25800.0 |
| 2009-11-19 17:00:00 | MSFT | Stock | 29.76 | 29.76 | 29.72 | 29.72 | 5316.0 |
> showing 50 of 70,788 rows — these rows as CSV