PREVIEW / stock_30min / 2006-05-22
file: by_date/stock_30min/2006/2006-05-22.parquet size: 945 KB rows: 50,518 symbols: 2,271
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-22 07:30:00 | AAPL | Stock | 2.2732 | 2.2821 | 2.2732 | 2.2732 | 21000.0 |
| 2006-05-22 08:00:00 | AAPL | Stock | 2.2821 | 2.2889 | 2.2804 | 2.2857 | 653660.0 |
| 2006-05-22 08:30:00 | AAPL | Stock | 2.2854 | 2.2886 | 2.2821 | 2.2846 | 1080212.0 |
| 2006-05-22 09:00:00 | AAPL | Stock | 2.2857 | 2.2857 | 2.2775 | 2.2825 | 3222576.0 |
| 2006-05-22 09:30:00 | AAPL | Stock | 2.2811 | 2.2854 | 2.2639 | 2.2675 | 90384168.0 |
| 2006-05-22 10:00:00 | AAPL | Stock | 2.2675 | 2.2764 | 2.2518 | 2.2571 | 69962424.0 |
| 2006-05-22 10:30:00 | AAPL | Stock | 2.2568 | 2.2661 | 2.2486 | 2.2625 | 58187836.0 |
| 2006-05-22 11:00:00 | AAPL | Stock | 2.2625 | 2.265 | 2.245 | 2.2579 | 58438996.0 |
| 2006-05-22 11:30:00 | AAPL | Stock | 2.2579 | 2.2809 | 2.2496 | 2.2525 | 58172240.0 |
| 2006-05-22 12:00:00 | AAPL | Stock | 2.2532 | 2.2768 | 2.2518 | 2.2721 | 66999380.0 |
| 2006-05-22 12:30:00 | AAPL | Stock | 2.2721 | 2.2771 | 2.2529 | 2.2582 | 42873880.0 |
| 2006-05-22 13:00:00 | AAPL | Stock | 2.2582 | 2.2646 | 2.25 | 2.2596 | 46604264.0 |
| 2006-05-22 13:30:00 | AAPL | Stock | 2.2596 | 2.2596 | 2.25 | 2.255 | 25628568.0 |
| 2006-05-22 14:00:00 | AAPL | Stock | 2.2557 | 2.2604 | 2.2418 | 2.2589 | 51849392.0 |
| 2006-05-22 14:30:00 | AAPL | Stock | 2.259 | 2.2618 | 2.25 | 2.2536 | 24700452.0 |
| 2006-05-22 15:00:00 | AAPL | Stock | 2.2536 | 2.2764 | 2.2521 | 2.2743 | 46853604.0 |
| 2006-05-22 15:30:00 | AAPL | Stock | 2.2743 | 2.2814 | 2.2589 | 2.2632 | 62129424.0 |
| 2006-05-22 16:00:00 | AAPL | Stock | 2.2632 | 2.2643 | 2.2604 | 2.2643 | 1021104.0 |
| 2006-05-22 16:30:00 | AAPL | Stock | 2.2636 | 2.2643 | 2.2625 | 2.2636 | 113708.0 |
| 2006-05-22 17:00:00 | AAPL | Stock | 2.2625 | 2.2636 | 2.2618 | 2.2632 | 3245452.0 |
| 2006-05-22 17:30:00 | AAPL | Stock | 2.2621 | 2.2621 | 2.2579 | 2.2579 | 127176.0 |
| 2006-05-22 18:00:00 | AAPL | Stock | 2.2589 | 2.2618 | 2.2589 | 2.2589 | 61600.0 |
| 2006-05-22 04:00:00 | MSFT | Stock | 22.51 | 22.51 | 22.51 | 22.51 | 200.0 |
| 2006-05-22 05:30:00 | MSFT | Stock | 22.37 | 22.37 | 22.37 | 22.37 | 300.0 |
| 2006-05-22 06:30:00 | MSFT | Stock | 22.34 | 22.39 | 22.34 | 22.39 | 800.0 |
| 2006-05-22 07:00:00 | MSFT | Stock | 22.39 | 22.45 | 22.39 | 22.4 | 12621.0 |
| 2006-05-22 07:30:00 | MSFT | Stock | 22.45 | 22.45 | 22.4 | 22.44 | 3679.0 |
| 2006-05-22 08:00:00 | MSFT | Stock | 22.46 | 22.51 | 22.43 | 22.44 | 75989.0 |
| 2006-05-22 08:30:00 | MSFT | Stock | 22.45 | 22.49 | 22.44 | 22.47 | 36592.0 |
| 2006-05-22 09:00:00 | MSFT | Stock | 22.46 | 22.51 | 22.45 | 22.49 | 117548.0 |
| 2006-05-22 09:30:00 | MSFT | Stock | 22.48 | 22.76 | 22.45 | 22.63 | 10450327.0 |
| 2006-05-22 10:00:00 | MSFT | Stock | 22.64 | 22.69 | 22.52 | 22.66 | 6807299.0 |
| 2006-05-22 10:30:00 | MSFT | Stock | 22.65 | 22.79 | 22.63 | 22.68 | 6035477.0 |
| 2006-05-22 11:00:00 | MSFT | Stock | 22.69 | 22.72 | 22.6 | 22.69 | 5054892.0 |
| 2006-05-22 11:30:00 | MSFT | Stock | 22.7 | 22.77 | 22.63 | 22.752 | 6895548.0 |
| 2006-05-22 12:00:00 | MSFT | Stock | 22.75 | 22.96 | 22.73 | 22.82 | 8664200.0 |
| 2006-05-22 12:30:00 | MSFT | Stock | 22.822 | 22.91 | 22.76 | 22.81 | 4729733.0 |
| 2006-05-22 13:00:00 | MSFT | Stock | 22.813 | 22.89 | 22.78 | 22.89 | 3740347.0 |
| 2006-05-22 13:30:00 | MSFT | Stock | 22.89 | 22.92 | 22.83 | 22.85 | 4281807.0 |
| 2006-05-22 14:00:00 | MSFT | Stock | 22.85 | 22.95 | 22.75 | 22.94 | 5800127.0 |
| 2006-05-22 14:30:00 | MSFT | Stock | 22.94 | 22.95 | 22.79 | 22.85 | 4131182.0 |
| 2006-05-22 15:00:00 | MSFT | Stock | 22.84 | 22.99 | 22.82 | 22.968 | 5905845.0 |
| 2006-05-22 15:30:00 | MSFT | Stock | 22.96 | 23.02 | 22.84 | 22.86 | 9425713.0 |
| 2006-05-22 16:00:00 | MSFT | Stock | 22.87 | 22.91 | 22.8 | 22.87 | 551947.0 |
| 2006-05-22 16:30:00 | MSFT | Stock | 22.88 | 22.88 | 22.85 | 22.87 | 91499.0 |
| 2006-05-22 17:00:00 | MSFT | Stock | 22.88 | 22.88 | 22.86 | 22.88 | 211704.0 |
| 2006-05-22 17:30:00 | MSFT | Stock | 22.88 | 22.88 | 22.86 | 22.88 | 610.0 |
| 2006-05-22 18:00:00 | MSFT | Stock | 22.88 | 22.88 | 22.88 | 22.88 | 3233.0 |
| 2006-05-22 08:00:00 | NVDA | Stock | 0.4042 | 0.4055 | 0.3992 | 0.3992 | 87000.0 |
| 2006-05-22 09:00:00 | NVDA | Stock | 0.3992 | 0.4047 | 0.3992 | 0.4043 | 802200.0 |
> showing 50 of 50,518 rows — these rows as CSV