PREVIEW / stock_30min / 2007-03-21
file: by_date/stock_30min/2007/2007-03-21.parquet size: 1.0 MB rows: 55,241 symbols: 2,558
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-21 07:30:00 | AAPL | Stock | 3.2793 | 3.2793 | 3.275 | 3.2786 | 58800.0 |
| 2007-03-21 08:00:00 | AAPL | Stock | 3.2786 | 3.2786 | 3.2718 | 3.2782 | 800800.0 |
| 2007-03-21 08:30:00 | AAPL | Stock | 3.2768 | 3.2929 | 3.2764 | 3.2893 | 2703736.0 |
| 2007-03-21 09:00:00 | AAPL | Stock | 3.2893 | 3.2918 | 3.2671 | 3.2857 | 2902816.0 |
| 2007-03-21 09:30:00 | AAPL | Stock | 3.2854 | 3.2929 | 3.2768 | 3.2839 | 73610208.0 |
| 2007-03-21 10:00:00 | AAPL | Stock | 3.2843 | 3.2871 | 3.275 | 3.2793 | 44471868.0 |
| 2007-03-21 10:30:00 | AAPL | Stock | 3.2789 | 3.2818 | 3.2732 | 3.2793 | 30943948.0 |
| 2007-03-21 11:00:00 | AAPL | Stock | 3.2793 | 3.2889 | 3.2793 | 3.2886 | 32030068.0 |
| 2007-03-21 11:30:00 | AAPL | Stock | 3.2886 | 3.2889 | 3.2825 | 3.2843 | 22561224.0 |
| 2007-03-21 12:00:00 | AAPL | Stock | 3.2843 | 3.2864 | 3.2818 | 3.2839 | 13486760.0 |
| 2007-03-21 12:30:00 | AAPL | Stock | 3.2843 | 3.2879 | 3.2832 | 3.2879 | 10854620.0 |
| 2007-03-21 13:00:00 | AAPL | Stock | 3.2879 | 3.2893 | 3.2857 | 3.2889 | 12684168.0 |
| 2007-03-21 13:30:00 | AAPL | Stock | 3.2889 | 3.2943 | 3.2864 | 3.2896 | 27994092.0 |
| 2007-03-21 14:00:00 | AAPL | Stock | 3.29 | 3.3089 | 3.2839 | 3.3025 | 80382456.0 |
| 2007-03-21 14:30:00 | AAPL | Stock | 3.3025 | 3.3439 | 3.2975 | 3.3396 | 81532304.0 |
| 2007-03-21 15:00:00 | AAPL | Stock | 3.34 | 3.3571 | 3.3225 | 3.3311 | 117297404.0 |
| 2007-03-21 15:30:00 | AAPL | Stock | 3.3304 | 3.3525 | 3.3286 | 3.3525 | 111199816.0 |
| 2007-03-21 16:00:00 | AAPL | Stock | 3.3525 | 3.3546 | 3.3479 | 3.3525 | 5590900.0 |
| 2007-03-21 16:30:00 | AAPL | Stock | 3.3518 | 3.3525 | 3.345 | 3.35 | 417844.0 |
| 2007-03-21 17:00:00 | AAPL | Stock | 3.3511 | 3.3511 | 3.3443 | 3.3482 | 3146332.0 |
| 2007-03-21 17:30:00 | AAPL | Stock | 3.345 | 3.3464 | 3.3446 | 3.3464 | 121240.0 |
| 2007-03-21 18:00:00 | AAPL | Stock | 3.3457 | 3.3496 | 3.345 | 3.3496 | 163856.0 |
| 2007-03-21 18:30:00 | AAPL | Stock | 3.3482 | 3.3482 | 3.3457 | 3.3464 | 132832.0 |
| 2007-03-21 19:00:00 | AAPL | Stock | 3.3489 | 3.3489 | 3.3464 | 3.3475 | 49616.0 |
| 2007-03-21 19:30:00 | AAPL | Stock | 3.3468 | 3.3493 | 3.3457 | 3.3489 | 85624.0 |
| 2007-03-21 08:00:00 | MSFT | Stock | 27.88 | 27.9 | 27.88 | 27.9 | 11700.0 |
| 2007-03-21 08:30:00 | MSFT | Stock | 27.88 | 27.93 | 27.88 | 27.93 | 25775.0 |
| 2007-03-21 09:00:00 | MSFT | Stock | 27.93 | 27.99 | 27.84 | 27.85 | 62470.0 |
| 2007-03-21 09:30:00 | MSFT | Stock | 27.895 | 28.0 | 27.57 | 27.61 | 5802705.0 |
| 2007-03-21 10:00:00 | MSFT | Stock | 27.6 | 27.75 | 27.57 | 27.72 | 3756423.0 |
| 2007-03-21 10:30:00 | MSFT | Stock | 27.721 | 27.73 | 27.63 | 27.63 | 2139817.0 |
| 2007-03-21 11:00:00 | MSFT | Stock | 27.63 | 27.65 | 27.56 | 27.63 | 2767856.0 |
| 2007-03-21 11:30:00 | MSFT | Stock | 27.63 | 27.64 | 27.58 | 27.64 | 2037144.0 |
| 2007-03-21 12:00:00 | MSFT | Stock | 27.63 | 27.76 | 27.63 | 27.748 | 1934865.0 |
| 2007-03-21 12:30:00 | MSFT | Stock | 27.748 | 27.91 | 27.74 | 27.9 | 2581153.0 |
| 2007-03-21 13:00:00 | MSFT | Stock | 27.9 | 27.97 | 27.83 | 27.93 | 2078450.0 |
| 2007-03-21 13:30:00 | MSFT | Stock | 27.94 | 27.95 | 27.83 | 27.83 | 2357235.0 |
| 2007-03-21 14:00:00 | MSFT | Stock | 27.84 | 28.08 | 27.68 | 28.02 | 8394510.0 |
| 2007-03-21 14:30:00 | MSFT | Stock | 28.02 | 28.46 | 28.0 | 28.45 | 5523605.0 |
| 2007-03-21 15:00:00 | MSFT | Stock | 28.45 | 28.49 | 28.22 | 28.3 | 7564997.0 |
| 2007-03-21 15:30:00 | MSFT | Stock | 28.3 | 28.52 | 27.972 | 28.52 | 13718179.0 |
| 2007-03-21 16:00:00 | MSFT | Stock | 28.51 | 28.54 | 28.46 | 28.48 | 289795.0 |
| 2007-03-21 16:30:00 | MSFT | Stock | 28.48 | 28.55 | 28.47 | 28.47 | 38816.0 |
| 2007-03-21 17:00:00 | MSFT | Stock | 28.47 | 28.52 | 28.46 | 28.48 | 2802400.0 |
| 2007-03-21 17:30:00 | MSFT | Stock | 28.48 | 28.52 | 28.47 | 28.52 | 14315.0 |
| 2007-03-21 18:00:00 | MSFT | Stock | 28.52 | 28.59 | 28.5 | 28.5 | 11896.0 |
| 2007-03-21 18:30:00 | MSFT | Stock | 28.51 | 28.51 | 28.5 | 28.5 | 900.0 |
| 2007-03-21 19:30:00 | MSFT | Stock | 28.52 | 28.52 | 28.49 | 28.49 | 373.0 |
| 2007-03-21 06:30:00 | NVDA | Stock | 0.4793 | 0.4833 | 0.4793 | 0.4833 | 264000.0 |
| 2007-03-21 07:00:00 | NVDA | Stock | 0.4883 | 0.4883 | 0.4837 | 0.4837 | 192000.0 |
> showing 50 of 55,241 rows — these rows as CSV