PREVIEW / stock_30min / 2010-11-12
file: by_date/stock_30min/2010/2010-11-12.parquet size: 1.4 MB rows: 76,248 symbols: 3,480
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-11-12 04:00:00 | AAPL | Stock | 11.2679 | 11.2679 | 11.2143 | 11.2143 | 39200.0 |
| 2010-11-12 04:30:00 | AAPL | Stock | 11.1971 | 11.1971 | 11.1839 | 11.1839 | 5600.0 |
| 2010-11-12 05:00:00 | AAPL | Stock | 11.2071 | 11.2071 | 11.2071 | 11.2071 | 72800.0 |
| 2010-11-12 05:30:00 | AAPL | Stock | 11.2071 | 11.2321 | 11.2071 | 11.2321 | 57820.0 |
| 2010-11-12 06:00:00 | AAPL | Stock | 11.2325 | 11.2329 | 11.2143 | 11.2214 | 21364.0 |
| 2010-11-12 06:30:00 | AAPL | Stock | 11.2389 | 11.2393 | 11.2214 | 11.2393 | 39900.0 |
| 2010-11-12 07:00:00 | AAPL | Stock | 11.2625 | 11.2786 | 11.2246 | 11.2768 | 108640.0 |
| 2010-11-12 07:30:00 | AAPL | Stock | 11.275 | 11.2771 | 11.2625 | 11.2664 | 193508.0 |
| 2010-11-12 08:00:00 | AAPL | Stock | 11.2696 | 11.2843 | 11.2368 | 11.2614 | 2284464.0 |
| 2010-11-12 08:30:00 | AAPL | Stock | 11.2643 | 11.2957 | 11.2614 | 11.2889 | 801052.0 |
| 2010-11-12 09:00:00 | AAPL | Stock | 11.2893 | 11.3321 | 11.2857 | 11.2857 | 2641884.0 |
| 2010-11-12 09:30:00 | AAPL | Stock | 11.2882 | 11.3036 | 11.2486 | 11.2832 | 56395668.0 |
| 2010-11-12 10:00:00 | AAPL | Stock | 11.2836 | 11.2918 | 11.2346 | 11.2452 | 38119928.0 |
| 2010-11-12 10:30:00 | AAPL | Stock | 11.2454 | 11.2511 | 11.13 | 11.1414 | 65794960.0 |
| 2010-11-12 11:00:00 | AAPL | Stock | 11.145 | 11.1786 | 11.125 | 11.1636 | 49010724.0 |
| 2010-11-12 11:30:00 | AAPL | Stock | 11.1632 | 11.1664 | 11.0932 | 11.1232 | 38464188.0 |
| 2010-11-12 12:00:00 | AAPL | Stock | 11.1221 | 11.1411 | 10.9189 | 10.9196 | 77669060.0 |
| 2010-11-12 12:30:00 | AAPL | Stock | 10.9196 | 10.9882 | 10.8439 | 10.9529 | 110910912.0 |
| 2010-11-12 13:00:00 | AAPL | Stock | 10.9525 | 11.0671 | 10.9286 | 11.0479 | 64420412.0 |
| 2010-11-12 13:30:00 | AAPL | Stock | 11.0482 | 11.0586 | 10.9893 | 11.0036 | 41577368.0 |
| 2010-11-12 14:00:00 | AAPL | Stock | 11.0036 | 11.0446 | 10.9754 | 11.0143 | 41825084.0 |
| 2010-11-12 14:30:00 | AAPL | Stock | 11.0136 | 11.0971 | 11.0104 | 11.0736 | 54800956.0 |
| 2010-11-12 15:00:00 | AAPL | Stock | 11.0729 | 11.1039 | 11.0436 | 11.0606 | 52280396.0 |
| 2010-11-12 15:30:00 | AAPL | Stock | 11.0606 | 11.0671 | 10.995 | 11.0039 | 84079212.0 |
| 2010-11-12 16:00:00 | AAPL | Stock | 10.9971 | 11.3039 | 10.9929 | 11.0032 | 8939756.0 |
| 2010-11-12 16:30:00 | AAPL | Stock | 11.0068 | 11.0421 | 10.9971 | 11.0029 | 450604.0 |
| 2010-11-12 17:00:00 | AAPL | Stock | 11.0007 | 11.2589 | 10.9825 | 10.9825 | 969360.0 |
| 2010-11-12 17:30:00 | AAPL | Stock | 10.9839 | 10.9875 | 10.9786 | 10.9821 | 241276.0 |
| 2010-11-12 18:00:00 | AAPL | Stock | 10.9807 | 11.0011 | 10.9786 | 10.9786 | 218652.0 |
| 2010-11-12 18:30:00 | AAPL | Stock | 10.9814 | 10.9814 | 10.9696 | 10.9714 | 194992.0 |
| 2010-11-12 19:00:00 | AAPL | Stock | 10.9714 | 10.9804 | 10.9682 | 10.9721 | 195272.0 |
| 2010-11-12 19:30:00 | AAPL | Stock | 10.9714 | 10.9857 | 10.9714 | 10.9804 | 137732.0 |
| 2010-11-12 07:00:00 | MSFT | Stock | 26.57 | 26.57 | 26.57 | 26.57 | 500.0 |
| 2010-11-12 07:30:00 | MSFT | Stock | 26.6 | 26.6 | 26.55 | 26.55 | 2200.0 |
| 2010-11-12 08:00:00 | MSFT | Stock | 26.51 | 26.51 | 26.48 | 26.5 | 14533.0 |
| 2010-11-12 08:30:00 | MSFT | Stock | 26.5 | 26.55 | 26.5 | 26.55 | 14205.0 |
| 2010-11-12 09:00:00 | MSFT | Stock | 26.55 | 26.62 | 26.46 | 26.46 | 77792.0 |
| 2010-11-12 09:30:00 | MSFT | Stock | 26.47 | 26.52 | 26.36 | 26.42 | 7168707.0 |
| 2010-11-12 10:00:00 | MSFT | Stock | 26.41 | 26.45 | 26.38 | 26.42 | 5728361.0 |
| 2010-11-12 10:30:00 | MSFT | Stock | 26.42 | 26.425 | 26.29 | 26.3 | 5430575.0 |
| 2010-11-12 11:00:00 | MSFT | Stock | 26.295 | 26.31 | 26.2 | 26.25 | 4845861.0 |
| 2010-11-12 11:30:00 | MSFT | Stock | 26.25 | 26.32 | 26.23 | 26.24 | 3474355.0 |
| 2010-11-12 12:00:00 | MSFT | Stock | 26.24 | 26.27 | 26.14 | 26.16 | 4396897.0 |
| 2010-11-12 12:30:00 | MSFT | Stock | 26.16 | 26.21 | 26.1 | 26.14 | 4297229.0 |
| 2010-11-12 13:00:00 | MSFT | Stock | 26.15 | 26.23 | 26.13 | 26.205 | 2679543.0 |
| 2010-11-12 13:30:00 | MSFT | Stock | 26.2 | 26.28 | 26.18 | 26.235 | 2687785.0 |
| 2010-11-12 14:00:00 | MSFT | Stock | 26.232 | 26.3 | 26.19 | 26.26 | 2013907.0 |
| 2010-11-12 14:30:00 | MSFT | Stock | 26.265 | 26.35 | 26.24 | 26.32 | 2699231.0 |
| 2010-11-12 15:00:00 | MSFT | Stock | 26.31 | 26.36 | 26.27 | 26.31 | 4154189.0 |
| 2010-11-12 15:30:00 | MSFT | Stock | 26.3 | 26.33 | 26.2 | 26.27 | 11116645.0 |
> showing 50 of 76,248 rows — these rows as CSV