PREVIEW / stock_30min / 2010-07-21
file: by_date/stock_30min/2010/2010-07-21.parquet size: 1.3 MB rows: 74,366 symbols: 3,459
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-21 04:00:00 | AAPL | Stock | 9.25 | 9.2679 | 9.25 | 9.2636 | 75488.0 |
| 2010-07-21 05:00:00 | AAPL | Stock | 9.2914 | 9.3018 | 9.2914 | 9.3018 | 5600.0 |
| 2010-07-21 05:30:00 | AAPL | Stock | 9.3029 | 9.3211 | 9.3029 | 9.3029 | 32200.0 |
| 2010-07-21 06:00:00 | AAPL | Stock | 9.3029 | 9.3029 | 9.2911 | 9.2911 | 26656.0 |
| 2010-07-21 06:30:00 | AAPL | Stock | 9.2918 | 9.2918 | 9.2739 | 9.2857 | 38556.0 |
| 2010-07-21 07:00:00 | AAPL | Stock | 9.2907 | 9.35 | 9.2907 | 9.3296 | 971516.0 |
| 2010-07-21 07:30:00 | AAPL | Stock | 9.3379 | 9.3714 | 9.3214 | 9.3482 | 3703392.0 |
| 2010-07-21 08:00:00 | AAPL | Stock | 9.3482 | 9.3796 | 9.2857 | 9.3682 | 8658272.0 |
| 2010-07-21 08:30:00 | AAPL | Stock | 9.3664 | 9.4143 | 9.3482 | 9.4086 | 12694500.0 |
| 2010-07-21 09:00:00 | AAPL | Stock | 9.4093 | 9.5168 | 9.3989 | 9.4693 | 31439240.0 |
| 2010-07-21 09:30:00 | AAPL | Stock | 9.4686 | 9.4696 | 9.195 | 9.2682 | 352080540.0 |
| 2010-07-21 10:00:00 | AAPL | Stock | 9.2682 | 9.2879 | 9.2179 | 9.2571 | 117924408.0 |
| 2010-07-21 10:30:00 | AAPL | Stock | 9.2557 | 9.2782 | 9.1611 | 9.1707 | 93813832.0 |
| 2010-07-21 11:00:00 | AAPL | Stock | 9.1682 | 9.2014 | 9.1479 | 9.1921 | 65912448.0 |
| 2010-07-21 11:30:00 | AAPL | Stock | 9.1918 | 9.23 | 9.1611 | 9.23 | 38575852.0 |
| 2010-07-21 12:00:00 | AAPL | Stock | 9.2293 | 9.2657 | 9.2271 | 9.2618 | 41715436.0 |
| 2010-07-21 12:30:00 | AAPL | Stock | 9.2607 | 9.2636 | 9.2261 | 9.2325 | 32015256.0 |
| 2010-07-21 13:00:00 | AAPL | Stock | 9.2329 | 9.2464 | 9.2146 | 9.2357 | 24098368.0 |
| 2010-07-21 13:30:00 | AAPL | Stock | 9.2346 | 9.2579 | 9.2086 | 9.2107 | 30603384.0 |
| 2010-07-21 14:00:00 | AAPL | Stock | 9.2106 | 9.2164 | 9.1107 | 9.1589 | 102927496.0 |
| 2010-07-21 14:30:00 | AAPL | Stock | 9.1571 | 9.175 | 9.1107 | 9.1193 | 59637816.0 |
| 2010-07-21 15:00:00 | AAPL | Stock | 9.1186 | 9.1604 | 9.0714 | 9.1086 | 71613052.0 |
| 2010-07-21 15:30:00 | AAPL | Stock | 9.1082 | 9.1346 | 9.0804 | 9.0804 | 79229864.0 |
| 2010-07-21 16:00:00 | AAPL | Stock | 9.0804 | 9.2634 | 9.0732 | 9.0818 | 10230220.0 |
| 2010-07-21 16:30:00 | AAPL | Stock | 9.0832 | 9.1075 | 9.0768 | 9.0771 | 2806916.0 |
| 2010-07-21 17:00:00 | AAPL | Stock | 9.0768 | 9.0804 | 9.0714 | 9.0786 | 125580.0 |
| 2010-07-21 17:30:00 | AAPL | Stock | 9.0768 | 9.0771 | 9.0643 | 9.0661 | 256060.0 |
| 2010-07-21 18:00:00 | AAPL | Stock | 9.065 | 9.0893 | 9.0636 | 9.0857 | 412636.0 |
| 2010-07-21 18:30:00 | AAPL | Stock | 9.0857 | 9.0911 | 9.0821 | 9.0829 | 191828.0 |
| 2010-07-21 19:00:00 | AAPL | Stock | 9.0821 | 9.0896 | 9.0786 | 9.0861 | 190232.0 |
| 2010-07-21 19:30:00 | AAPL | Stock | 9.0864 | 9.0907 | 9.0832 | 9.0875 | 164528.0 |
| 2010-07-21 06:30:00 | MSFT | Stock | 25.42 | 25.42 | 25.42 | 25.42 | 300.0 |
| 2010-07-21 07:00:00 | MSFT | Stock | 25.7 | 25.7 | 25.69 | 25.69 | 600.0 |
| 2010-07-21 08:00:00 | MSFT | Stock | 25.58 | 25.74 | 25.58 | 25.71 | 23418.0 |
| 2010-07-21 08:30:00 | MSFT | Stock | 25.72 | 25.87 | 25.71 | 25.79 | 68519.0 |
| 2010-07-21 09:00:00 | MSFT | Stock | 25.79 | 25.81 | 25.6 | 25.6 | 316376.0 |
| 2010-07-21 09:30:00 | MSFT | Stock | 25.6 | 25.65 | 25.12 | 25.21 | 7687111.0 |
| 2010-07-21 10:00:00 | MSFT | Stock | 25.21 | 25.37 | 25.13 | 25.34 | 4618677.0 |
| 2010-07-21 10:30:00 | MSFT | Stock | 25.33 | 25.51 | 25.31 | 25.46 | 5282370.0 |
| 2010-07-21 11:00:00 | MSFT | Stock | 25.47 | 25.49 | 25.35 | 25.43 | 4761064.0 |
| 2010-07-21 11:30:00 | MSFT | Stock | 25.42 | 25.5 | 25.4 | 25.45 | 4028384.0 |
| 2010-07-21 12:00:00 | MSFT | Stock | 25.44 | 25.5 | 25.4 | 25.45 | 3739312.0 |
| 2010-07-21 12:30:00 | MSFT | Stock | 25.46 | 25.58 | 25.44 | 25.48 | 3476448.0 |
| 2010-07-21 13:00:00 | MSFT | Stock | 25.484 | 25.54 | 25.46 | 25.5 | 1811760.0 |
| 2010-07-21 13:30:00 | MSFT | Stock | 25.5 | 25.58 | 25.49 | 25.54 | 3367582.0 |
| 2010-07-21 14:00:00 | MSFT | Stock | 25.54 | 25.57 | 25.2 | 25.22 | 6242872.0 |
| 2010-07-21 14:30:00 | MSFT | Stock | 25.21 | 25.26 | 25.0 | 25.03 | 5737384.0 |
| 2010-07-21 15:00:00 | MSFT | Stock | 25.03 | 25.125 | 24.99 | 25.03 | 5121464.0 |
| 2010-07-21 15:30:00 | MSFT | Stock | 25.02 | 25.11 | 24.975 | 25.11 | 10153519.0 |
| 2010-07-21 16:00:00 | MSFT | Stock | 25.11 | 25.292 | 25.05 | 25.16 | 4735156.0 |
> showing 50 of 74,366 rows — these rows as CSV