PREVIEW / stock_30min / 2009-10-23
file: by_date/stock_30min/2009/2009-10-23.parquet size: 1.3 MB rows: 70,058 symbols: 3,369
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-10-23 04:00:00 | AAPL | Stock | 7.3214 | 7.3214 | 7.3214 | 7.3214 | 2800.0 |
| 2009-10-23 05:00:00 | AAPL | Stock | 7.3057 | 7.325 | 7.3057 | 7.325 | 11200.0 |
| 2009-10-23 06:00:00 | AAPL | Stock | 7.3375 | 7.3375 | 7.3375 | 7.3375 | 14000.0 |
| 2009-10-23 06:30:00 | AAPL | Stock | 7.3357 | 7.3357 | 7.3321 | 7.3321 | 10164.0 |
| 2009-10-23 07:00:00 | AAPL | Stock | 7.3286 | 7.3571 | 7.3286 | 7.3511 | 102704.0 |
| 2009-10-23 07:30:00 | AAPL | Stock | 7.3546 | 7.3568 | 7.3479 | 7.3536 | 113400.0 |
| 2009-10-23 08:00:00 | AAPL | Stock | 7.3564 | 7.3568 | 7.3246 | 7.3304 | 860888.0 |
| 2009-10-23 08:30:00 | AAPL | Stock | 7.3321 | 7.3811 | 7.3321 | 7.3675 | 2685004.0 |
| 2009-10-23 09:00:00 | AAPL | Stock | 7.3661 | 7.3696 | 7.3318 | 7.3439 | 2548308.0 |
| 2009-10-23 09:30:00 | AAPL | Stock | 7.3514 | 7.3536 | 7.2957 | 7.3178 | 81546612.0 |
| 2009-10-23 10:00:00 | AAPL | Stock | 7.3175 | 7.3421 | 7.2857 | 7.3296 | 55134772.0 |
| 2009-10-23 10:30:00 | AAPL | Stock | 7.3304 | 7.3332 | 7.2864 | 7.2879 | 29789900.0 |
| 2009-10-23 11:00:00 | AAPL | Stock | 7.2868 | 7.3075 | 7.2686 | 7.2711 | 36205120.0 |
| 2009-10-23 11:30:00 | AAPL | Stock | 7.271 | 7.3071 | 7.2679 | 7.2975 | 20511484.0 |
| 2009-10-23 12:00:00 | AAPL | Stock | 7.2954 | 7.3014 | 7.2786 | 7.2906 | 14577052.0 |
| 2009-10-23 12:30:00 | AAPL | Stock | 7.2911 | 7.3093 | 7.2861 | 7.2969 | 15416688.0 |
| 2009-10-23 13:00:00 | AAPL | Stock | 7.2971 | 7.3071 | 7.2868 | 7.2911 | 17201380.0 |
| 2009-10-23 13:30:00 | AAPL | Stock | 7.2907 | 7.2943 | 7.2707 | 7.2843 | 22143240.0 |
| 2009-10-23 14:00:00 | AAPL | Stock | 7.2843 | 7.3157 | 7.2757 | 7.3106 | 29142736.0 |
| 2009-10-23 14:30:00 | AAPL | Stock | 7.3104 | 7.3139 | 7.2814 | 7.2904 | 20737892.0 |
| 2009-10-23 15:00:00 | AAPL | Stock | 7.2904 | 7.3061 | 7.2725 | 7.2832 | 24334604.0 |
| 2009-10-23 15:30:00 | AAPL | Stock | 7.2825 | 7.2911 | 7.2582 | 7.2814 | 41163836.0 |
| 2009-10-23 16:00:00 | AAPL | Stock | 7.2818 | 7.2836 | 7.2721 | 7.28 | 4954628.0 |
| 2009-10-23 16:30:00 | AAPL | Stock | 7.28 | 7.2829 | 7.2754 | 7.2786 | 182140.0 |
| 2009-10-23 17:00:00 | AAPL | Stock | 7.2818 | 7.2818 | 7.2714 | 7.2768 | 96572.0 |
| 2009-10-23 17:30:00 | AAPL | Stock | 7.2768 | 7.2804 | 7.2732 | 7.2804 | 94864.0 |
| 2009-10-23 18:00:00 | AAPL | Stock | 7.2821 | 7.2843 | 7.2786 | 7.2786 | 511084.0 |
| 2009-10-23 18:30:00 | AAPL | Stock | 7.2786 | 7.2971 | 7.2786 | 7.2811 | 76664.0 |
| 2009-10-23 19:00:00 | AAPL | Stock | 7.2811 | 7.2811 | 7.2786 | 7.2811 | 57876.0 |
| 2009-10-23 19:30:00 | AAPL | Stock | 7.2804 | 7.2829 | 7.2786 | 7.2786 | 43428.0 |
| 2009-10-23 05:30:00 | MSFT | Stock | 26.72 | 26.72 | 26.72 | 26.72 | 300.0 |
| 2009-10-23 06:00:00 | MSFT | Stock | 26.79 | 26.8 | 26.77 | 26.8 | 800.0 |
| 2009-10-23 06:30:00 | MSFT | Stock | 27.0 | 27.0 | 26.75 | 26.75 | 1250.0 |
| 2009-10-23 07:00:00 | MSFT | Stock | 26.89 | 27.05 | 26.75 | 26.91 | 53128.0 |
| 2009-10-23 07:30:00 | MSFT | Stock | 26.91 | 27.0 | 26.75 | 26.9 | 31163.0 |
| 2009-10-23 08:00:00 | MSFT | Stock | 26.9 | 27.0 | 26.76 | 26.93 | 571823.0 |
| 2009-10-23 08:30:00 | MSFT | Stock | 26.93 | 29.22 | 26.92 | 29.12 | 13554650.0 |
| 2009-10-23 09:00:00 | MSFT | Stock | 29.12 | 29.68 | 29.11 | 29.2 | 14305949.0 |
| 2009-10-23 09:30:00 | MSFT | Stock | 29.2 | 29.35 | 28.63 | 28.851 | 63442079.0 |
| 2009-10-23 10:00:00 | MSFT | Stock | 28.86 | 28.9 | 28.51 | 28.69 | 29451342.0 |
| 2009-10-23 10:30:00 | MSFT | Stock | 28.69 | 28.71 | 28.23 | 28.252 | 30918291.0 |
| 2009-10-23 11:00:00 | MSFT | Stock | 28.26 | 28.59 | 28.23 | 28.37 | 26611678.0 |
| 2009-10-23 11:30:00 | MSFT | Stock | 28.37 | 28.5 | 28.31 | 28.41 | 12138972.0 |
| 2009-10-23 12:00:00 | MSFT | Stock | 28.405 | 28.55 | 28.36 | 28.4 | 8878514.0 |
| 2009-10-23 12:30:00 | MSFT | Stock | 28.4 | 28.42 | 28.13 | 28.147 | 16466825.0 |
| 2009-10-23 13:00:00 | MSFT | Stock | 28.15 | 28.35 | 28.04 | 28.13 | 9512180.0 |
| 2009-10-23 13:30:00 | MSFT | Stock | 28.133 | 28.16 | 28.0 | 28.072 | 9751031.0 |
| 2009-10-23 14:00:00 | MSFT | Stock | 28.07 | 28.14 | 27.88 | 28.03 | 14487345.0 |
| 2009-10-23 14:30:00 | MSFT | Stock | 28.023 | 28.09 | 27.93 | 27.97 | 6338681.0 |
| 2009-10-23 15:00:00 | MSFT | Stock | 27.97 | 28.08 | 27.9 | 28.02 | 6713286.0 |
> showing 50 of 70,058 rows — these rows as CSV