PREVIEW / stock_30min / 2008-07-14
file: by_date/stock_30min/2008/2008-07-14.parquet size: 1.2 MB rows: 69,386 symbols: 3,354
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-07-14 06:00:00 | AAPL | Stock | 6.225 | 6.225 | 6.225 | 6.225 | 2800.0 |
| 2008-07-14 06:30:00 | AAPL | Stock | 6.2246 | 6.225 | 6.2246 | 6.225 | 25200.0 |
| 2008-07-14 07:00:00 | AAPL | Stock | 6.2636 | 6.2964 | 6.2443 | 6.2964 | 469000.0 |
| 2008-07-14 07:30:00 | AAPL | Stock | 6.2961 | 6.3014 | 6.2718 | 6.2718 | 316400.0 |
| 2008-07-14 08:00:00 | AAPL | Stock | 6.275 | 6.2786 | 6.25 | 6.2557 | 1297044.0 |
| 2008-07-14 08:30:00 | AAPL | Stock | 6.2543 | 6.4414 | 6.2529 | 6.4357 | 19285056.0 |
| 2008-07-14 09:00:00 | AAPL | Stock | 6.4286 | 6.4546 | 6.3954 | 6.4029 | 8224244.0 |
| 2008-07-14 09:30:00 | AAPL | Stock | 6.4032 | 6.4036 | 6.2896 | 6.3036 | 145678764.0 |
| 2008-07-14 10:00:00 | AAPL | Stock | 6.3036 | 6.3536 | 6.2554 | 6.2693 | 105677124.0 |
| 2008-07-14 10:30:00 | AAPL | Stock | 6.2693 | 6.3482 | 6.2679 | 6.3307 | 69008436.0 |
| 2008-07-14 11:00:00 | AAPL | Stock | 6.3314 | 6.3393 | 6.2718 | 6.2979 | 48338752.0 |
| 2008-07-14 11:30:00 | AAPL | Stock | 6.2979 | 6.3054 | 6.2029 | 6.2257 | 57722336.0 |
| 2008-07-14 12:00:00 | AAPL | Stock | 6.2257 | 6.265 | 6.2114 | 6.2368 | 58083284.0 |
| 2008-07-14 12:30:00 | AAPL | Stock | 6.2354 | 6.2589 | 6.23 | 6.2482 | 36738100.0 |
| 2008-07-14 13:00:00 | AAPL | Stock | 6.2486 | 6.2536 | 6.2229 | 6.2382 | 34183996.0 |
| 2008-07-14 13:30:00 | AAPL | Stock | 6.2396 | 6.2814 | 6.2318 | 6.2575 | 46261404.0 |
| 2008-07-14 14:00:00 | AAPL | Stock | 6.2577 | 6.2896 | 6.2504 | 6.275 | 33612684.0 |
| 2008-07-14 14:30:00 | AAPL | Stock | 6.2761 | 6.2943 | 6.2118 | 6.2261 | 52302208.0 |
| 2008-07-14 15:00:00 | AAPL | Stock | 6.2257 | 6.25 | 6.1814 | 6.2343 | 62327608.0 |
| 2008-07-14 15:30:00 | AAPL | Stock | 6.2339 | 6.2775 | 6.2075 | 6.21 | 89495140.0 |
| 2008-07-14 16:00:00 | AAPL | Stock | 6.2164 | 6.2772 | 6.1839 | 6.1932 | 10470180.0 |
| 2008-07-14 16:30:00 | AAPL | Stock | 6.1911 | 6.21 | 6.1893 | 6.1925 | 693028.0 |
| 2008-07-14 17:00:00 | AAPL | Stock | 6.1929 | 6.1929 | 6.1839 | 6.1839 | 201712.0 |
| 2008-07-14 17:30:00 | AAPL | Stock | 6.1825 | 6.1907 | 6.1786 | 6.1839 | 128044.0 |
| 2008-07-14 18:00:00 | AAPL | Stock | 6.1839 | 6.1921 | 6.1839 | 6.1921 | 232120.0 |
| 2008-07-14 18:30:00 | AAPL | Stock | 6.1929 | 6.1929 | 6.1879 | 6.1893 | 67760.0 |
| 2008-07-14 19:00:00 | AAPL | Stock | 6.1893 | 6.1946 | 6.1886 | 6.1911 | 156800.0 |
| 2008-07-14 19:30:00 | AAPL | Stock | 6.1925 | 6.1925 | 6.1889 | 6.1914 | 130564.0 |
| 2008-07-14 07:30:00 | MSFT | Stock | 25.6 | 25.79 | 25.55 | 25.79 | 3600.0 |
| 2008-07-14 08:00:00 | MSFT | Stock | 25.62 | 25.7 | 25.51 | 25.65 | 26374.0 |
| 2008-07-14 08:30:00 | MSFT | Stock | 25.6 | 25.65 | 25.52 | 25.65 | 20821.0 |
| 2008-07-14 09:00:00 | MSFT | Stock | 25.6 | 25.6 | 25.43 | 25.43 | 17528.0 |
| 2008-07-14 09:30:00 | MSFT | Stock | 25.44 | 25.78 | 25.42 | 25.74 | 7032180.0 |
| 2008-07-14 10:00:00 | MSFT | Stock | 25.75 | 25.81 | 25.6 | 25.662 | 5834716.0 |
| 2008-07-14 10:30:00 | MSFT | Stock | 25.66 | 25.73 | 25.47 | 25.66 | 3074728.0 |
| 2008-07-14 11:00:00 | MSFT | Stock | 25.66 | 25.69 | 25.4 | 25.47 | 2230296.0 |
| 2008-07-14 11:30:00 | MSFT | Stock | 25.46 | 25.51 | 25.24 | 25.35 | 2564088.0 |
| 2008-07-14 12:00:00 | MSFT | Stock | 25.35 | 25.37 | 25.22 | 25.3 | 2109550.0 |
| 2008-07-14 12:30:00 | MSFT | Stock | 25.303 | 25.35 | 25.2 | 25.27 | 1805665.0 |
| 2008-07-14 13:00:00 | MSFT | Stock | 25.27 | 25.29 | 25.07 | 25.14 | 4245769.0 |
| 2008-07-14 13:30:00 | MSFT | Stock | 25.14 | 25.29 | 25.08 | 25.27 | 2323136.0 |
| 2008-07-14 14:00:00 | MSFT | Stock | 25.26 | 25.45 | 25.26 | 25.395 | 3097442.0 |
| 2008-07-14 14:30:00 | MSFT | Stock | 25.395 | 25.43 | 25.18 | 25.22 | 3333900.0 |
| 2008-07-14 15:00:00 | MSFT | Stock | 25.21 | 25.28 | 25.07 | 25.24 | 5279756.0 |
| 2008-07-14 15:30:00 | MSFT | Stock | 25.24 | 25.375 | 25.11 | 25.11 | 5658882.0 |
| 2008-07-14 16:00:00 | MSFT | Stock | 25.14 | 25.398 | 25.1 | 25.13 | 1896510.0 |
| 2008-07-14 16:30:00 | MSFT | Stock | 25.13 | 25.15 | 25.07 | 25.1 | 88693.0 |
| 2008-07-14 17:00:00 | MSFT | Stock | 25.1 | 25.21 | 25.1 | 25.21 | 5903.0 |
| 2008-07-14 17:30:00 | MSFT | Stock | 25.11 | 25.11 | 25.08 | 25.1 | 2384.0 |
| 2008-07-14 18:00:00 | MSFT | Stock | 25.08 | 25.15 | 25.08 | 25.15 | 3428.0 |
> showing 50 of 69,386 rows — these rows as CSV