PREVIEW / stock_30min / 2006-08-10
file: by_date/stock_30min/2006/2006-08-10.parquet size: 913 KB rows: 49,835 symbols: 2,312
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-08-10 04:00:00 | AAPL | Stock | 2.2618 | 2.2618 | 2.2614 | 2.2614 | 56000.0 |
| 2006-08-10 07:30:00 | AAPL | Stock | 2.2536 | 2.2536 | 2.2536 | 2.2536 | 2800.0 |
| 2006-08-10 08:00:00 | AAPL | Stock | 2.2571 | 2.2589 | 2.2511 | 2.2571 | 459144.0 |
| 2006-08-10 08:30:00 | AAPL | Stock | 2.2571 | 2.2625 | 2.2561 | 2.2589 | 385280.0 |
| 2006-08-10 09:00:00 | AAPL | Stock | 2.2607 | 2.2639 | 2.2504 | 2.2579 | 2011520.0 |
| 2006-08-10 09:30:00 | AAPL | Stock | 2.2589 | 2.2921 | 2.2393 | 2.2807 | 112403592.0 |
| 2006-08-10 10:00:00 | AAPL | Stock | 2.2807 | 2.2839 | 2.2621 | 2.2782 | 72783256.0 |
| 2006-08-10 10:30:00 | AAPL | Stock | 2.2782 | 2.3007 | 2.2775 | 2.2986 | 74100124.0 |
| 2006-08-10 11:00:00 | AAPL | Stock | 2.2989 | 2.3146 | 2.2929 | 2.3032 | 75822628.0 |
| 2006-08-10 11:30:00 | AAPL | Stock | 2.3036 | 2.3129 | 2.2946 | 2.3036 | 42467712.0 |
| 2006-08-10 12:00:00 | AAPL | Stock | 2.3036 | 2.3043 | 2.2839 | 2.2882 | 47191004.0 |
| 2006-08-10 12:30:00 | AAPL | Stock | 2.2882 | 2.2911 | 2.2782 | 2.2854 | 32874688.0 |
| 2006-08-10 13:00:00 | AAPL | Stock | 2.2854 | 2.2864 | 2.2775 | 2.2811 | 19608484.0 |
| 2006-08-10 13:30:00 | AAPL | Stock | 2.2811 | 2.2961 | 2.2793 | 2.2893 | 30968392.0 |
| 2006-08-10 14:00:00 | AAPL | Stock | 2.2893 | 2.3029 | 2.2893 | 2.2946 | 37032324.0 |
| 2006-08-10 14:30:00 | AAPL | Stock | 2.2946 | 2.2964 | 2.2779 | 2.2814 | 38591364.0 |
| 2006-08-10 15:00:00 | AAPL | Stock | 2.2814 | 2.2821 | 2.2718 | 2.2754 | 49403116.0 |
| 2006-08-10 15:30:00 | AAPL | Stock | 2.2754 | 2.2911 | 2.275 | 2.2875 | 57492036.0 |
| 2006-08-10 16:00:00 | AAPL | Stock | 2.2871 | 2.2882 | 2.2854 | 2.2879 | 353612.0 |
| 2006-08-10 16:30:00 | AAPL | Stock | 2.2861 | 2.2861 | 2.2843 | 2.2843 | 81200.0 |
| 2006-08-10 17:00:00 | AAPL | Stock | 2.2857 | 2.2868 | 2.2857 | 2.2868 | 51940.0 |
| 2006-08-10 17:30:00 | AAPL | Stock | 2.2877 | 2.2877 | 2.2857 | 2.2857 | 120540.0 |
| 2006-08-10 18:00:00 | AAPL | Stock | 2.2864 | 2.2864 | 2.2857 | 2.2857 | 71484.0 |
| 2006-08-10 06:30:00 | MSFT | Stock | 24.27 | 24.27 | 24.27 | 24.27 | 1000.0 |
| 2006-08-10 07:30:00 | MSFT | Stock | 24.34 | 24.34 | 24.34 | 24.34 | 200.0 |
| 2006-08-10 08:00:00 | MSFT | Stock | 24.25 | 24.34 | 24.25 | 24.29 | 20229.0 |
| 2006-08-10 08:30:00 | MSFT | Stock | 24.31 | 24.36 | 24.3 | 24.32 | 15761.0 |
| 2006-08-10 09:00:00 | MSFT | Stock | 24.44 | 24.44 | 24.33 | 24.38 | 888181.0 |
| 2006-08-10 09:30:00 | MSFT | Stock | 24.37 | 24.6 | 24.35 | 24.43 | 4136131.0 |
| 2006-08-10 10:00:00 | MSFT | Stock | 24.43 | 24.5 | 24.37 | 24.5 | 1989034.0 |
| 2006-08-10 10:30:00 | MSFT | Stock | 24.5 | 24.53 | 24.36 | 24.41 | 2309909.0 |
| 2006-08-10 11:00:00 | MSFT | Stock | 24.41 | 24.49 | 24.39 | 24.46 | 1343908.0 |
| 2006-08-10 11:30:00 | MSFT | Stock | 24.46 | 24.47 | 24.39 | 24.46 | 1238116.0 |
| 2006-08-10 12:00:00 | MSFT | Stock | 24.47 | 24.49 | 24.39 | 24.44 | 1735068.0 |
| 2006-08-10 12:30:00 | MSFT | Stock | 24.44 | 24.45 | 24.389 | 24.41 | 1191534.0 |
| 2006-08-10 13:00:00 | MSFT | Stock | 24.4 | 24.41 | 24.34 | 24.36 | 1528347.0 |
| 2006-08-10 13:30:00 | MSFT | Stock | 24.36 | 24.44 | 24.34 | 24.39 | 2163370.0 |
| 2006-08-10 14:00:00 | MSFT | Stock | 24.392 | 24.49 | 24.39 | 24.46 | 2075797.0 |
| 2006-08-10 14:30:00 | MSFT | Stock | 24.45 | 24.47 | 24.36 | 24.38 | 1706026.0 |
| 2006-08-10 15:00:00 | MSFT | Stock | 24.39 | 24.43 | 24.36 | 24.38 | 2413554.0 |
| 2006-08-10 15:30:00 | MSFT | Stock | 24.37 | 24.47 | 24.37 | 24.45 | 3381069.0 |
| 2006-08-10 16:00:00 | MSFT | Stock | 24.44 | 24.47 | 24.43 | 24.46 | 1119729.0 |
| 2006-08-10 16:30:00 | MSFT | Stock | 24.44 | 24.46 | 24.44 | 24.46 | 232540.0 |
| 2006-08-10 17:30:00 | MSFT | Stock | 24.455 | 24.455 | 24.455 | 24.455 | 3101.0 |
| 2006-08-10 18:00:00 | MSFT | Stock | 24.43 | 24.43 | 24.41 | 24.41 | 15269.0 |
| 2006-08-10 18:30:00 | MSFT | Stock | 24.4 | 24.4 | 24.4 | 24.4 | 100.0 |
| 2006-08-10 08:00:00 | NVDA | Stock | 0.4003 | 0.4005 | 0.4003 | 0.4003 | 42000.0 |
| 2006-08-10 08:30:00 | NVDA | Stock | 0.4043 | 0.4043 | 0.4037 | 0.4037 | 102000.0 |
| 2006-08-10 09:00:00 | NVDA | Stock | 0.402 | 0.4037 | 0.4007 | 0.4007 | 158820.0 |
| 2006-08-10 09:30:00 | NVDA | Stock | 0.401 | 0.4033 | 0.3942 | 0.3993 | 81334020.0 |
> showing 50 of 49,835 rows — these rows as CSV