PREVIEW / stock_30min / 2008-12-05
file: by_date/stock_30min/2008/2008-12-05.parquet size: 1.2 MB rows: 67,225 symbols: 3,319
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-12-05 04:00:00 | AAPL | Stock | 3.2786 | 3.2786 | 3.2786 | 3.2786 | 2800.0 |
| 2008-12-05 04:30:00 | AAPL | Stock | 3.2714 | 3.2714 | 3.2714 | 3.2714 | 2800.0 |
| 2008-12-05 05:30:00 | AAPL | Stock | 3.2786 | 3.2786 | 3.2786 | 3.2786 | 2800.0 |
| 2008-12-05 07:00:00 | AAPL | Stock | 3.2429 | 3.2429 | 3.2429 | 3.2429 | 2800.0 |
| 2008-12-05 07:30:00 | AAPL | Stock | 3.2143 | 3.2411 | 3.2143 | 3.2411 | 19600.0 |
| 2008-12-05 08:00:00 | AAPL | Stock | 3.2321 | 3.2411 | 3.2179 | 3.2404 | 1104712.0 |
| 2008-12-05 08:30:00 | AAPL | Stock | 3.2404 | 3.2404 | 3.1961 | 3.2218 | 4901764.0 |
| 2008-12-05 09:00:00 | AAPL | Stock | 3.2232 | 3.2371 | 3.215 | 3.2282 | 1461964.0 |
| 2008-12-05 09:30:00 | AAPL | Stock | 3.2268 | 3.2729 | 3.1789 | 3.1911 | 114162748.0 |
| 2008-12-05 10:00:00 | AAPL | Stock | 3.1914 | 3.2107 | 3.1764 | 3.1996 | 80063760.0 |
| 2008-12-05 10:30:00 | AAPL | Stock | 3.1996 | 3.2286 | 3.1736 | 3.2096 | 70984620.0 |
| 2008-12-05 11:00:00 | AAPL | Stock | 3.2099 | 3.2275 | 3.1979 | 3.2025 | 46100516.0 |
| 2008-12-05 11:30:00 | AAPL | Stock | 3.2029 | 3.2471 | 3.1964 | 3.2389 | 48217736.0 |
| 2008-12-05 12:00:00 | AAPL | Stock | 3.2392 | 3.2529 | 3.2211 | 3.2318 | 38732792.0 |
| 2008-12-05 12:30:00 | AAPL | Stock | 3.2314 | 3.2339 | 3.2057 | 3.2271 | 43322048.0 |
| 2008-12-05 13:00:00 | AAPL | Stock | 3.2279 | 3.25 | 3.2261 | 3.2304 | 39119444.0 |
| 2008-12-05 13:30:00 | AAPL | Stock | 3.2304 | 3.3204 | 3.2304 | 3.3071 | 91931364.0 |
| 2008-12-05 14:00:00 | AAPL | Stock | 3.3071 | 3.3146 | 3.2811 | 3.2982 | 73487316.0 |
| 2008-12-05 14:30:00 | AAPL | Stock | 3.2971 | 3.3625 | 3.2857 | 3.3532 | 113923600.0 |
| 2008-12-05 15:00:00 | AAPL | Stock | 3.3525 | 3.3704 | 3.3261 | 3.3468 | 102447352.0 |
| 2008-12-05 15:30:00 | AAPL | Stock | 3.3457 | 3.3746 | 3.33 | 3.3568 | 132821220.0 |
| 2008-12-05 16:00:00 | AAPL | Stock | 3.3575 | 3.3582 | 3.2746 | 3.3536 | 28865228.0 |
| 2008-12-05 16:30:00 | AAPL | Stock | 3.3518 | 3.3571 | 3.3518 | 3.3571 | 463288.0 |
| 2008-12-05 17:00:00 | AAPL | Stock | 3.3536 | 3.3646 | 3.3536 | 3.3568 | 142408.0 |
| 2008-12-05 17:30:00 | AAPL | Stock | 3.3554 | 3.3554 | 3.3529 | 3.3554 | 102340.0 |
| 2008-12-05 18:00:00 | AAPL | Stock | 3.3557 | 3.3571 | 3.3536 | 3.3536 | 548996.0 |
| 2008-12-05 18:30:00 | AAPL | Stock | 3.3518 | 3.3532 | 3.3518 | 3.3529 | 32200.0 |
| 2008-12-05 19:00:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3504 | 3.3536 | 52220.0 |
| 2008-12-05 19:30:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.35 | 3.35 | 80444.0 |
| 2008-12-05 07:00:00 | MSFT | Stock | 18.77 | 18.97 | 18.77 | 18.97 | 1000.0 |
| 2008-12-05 07:30:00 | MSFT | Stock | 19.09 | 19.09 | 18.86 | 18.86 | 200.0 |
| 2008-12-05 08:00:00 | MSFT | Stock | 19.11 | 19.11 | 18.97 | 18.97 | 31925.0 |
| 2008-12-05 08:30:00 | MSFT | Stock | 18.97 | 19.0 | 18.81 | 18.94 | 93527.0 |
| 2008-12-05 09:00:00 | MSFT | Stock | 18.94 | 18.98 | 18.9 | 18.95 | 23339.0 |
| 2008-12-05 09:30:00 | MSFT | Stock | 18.9 | 18.99 | 18.67 | 18.68 | 6652184.0 |
| 2008-12-05 10:00:00 | MSFT | Stock | 18.67 | 18.74 | 18.53 | 18.58 | 6041455.0 |
| 2008-12-05 10:30:00 | MSFT | Stock | 18.58 | 18.71 | 18.47 | 18.65 | 5278000.0 |
| 2008-12-05 11:00:00 | MSFT | Stock | 18.65 | 18.75 | 18.6 | 18.67 | 3457623.0 |
| 2008-12-05 11:30:00 | MSFT | Stock | 18.67 | 18.78 | 18.61 | 18.702 | 4854035.0 |
| 2008-12-05 12:00:00 | MSFT | Stock | 18.7 | 18.8 | 18.65 | 18.792 | 2705047.0 |
| 2008-12-05 12:30:00 | MSFT | Stock | 18.792 | 18.8 | 18.6 | 18.68 | 2963808.0 |
| 2008-12-05 13:00:00 | MSFT | Stock | 18.68 | 18.88 | 18.67 | 18.72 | 3806226.0 |
| 2008-12-05 13:30:00 | MSFT | Stock | 18.71 | 19.22 | 18.71 | 19.13 | 5626154.0 |
| 2008-12-05 14:00:00 | MSFT | Stock | 19.13 | 19.21 | 19.0 | 19.135 | 5146799.0 |
| 2008-12-05 14:30:00 | MSFT | Stock | 19.14 | 19.71 | 19.09 | 19.53 | 8217326.0 |
| 2008-12-05 15:00:00 | MSFT | Stock | 19.53 | 19.74 | 19.37 | 19.71 | 9578308.0 |
| 2008-12-05 15:30:00 | MSFT | Stock | 19.71 | 19.98 | 19.65 | 19.83 | 18311149.0 |
| 2008-12-05 16:00:00 | MSFT | Stock | 19.83 | 19.88 | 19.166 | 19.87 | 7356905.0 |
| 2008-12-05 16:30:00 | MSFT | Stock | 19.87 | 19.87 | 19.73 | 19.87 | 129604.0 |
| 2008-12-05 17:00:00 | MSFT | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 700.0 |
> showing 50 of 67,225 rows — these rows as CSV