PREVIEW / stock_30min / 2006-05-23
file: by_date/stock_30min/2006/2006-05-23.parquet size: 927 KB rows: 49,705 symbols: 2,268
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-23 05:30:00 | AAPL | Stock | 2.2696 | 2.2696 | 2.2696 | 2.2696 | 2800.0 |
| 2006-05-23 07:00:00 | AAPL | Stock | 2.2696 | 2.2768 | 2.2696 | 2.2768 | 53200.0 |
| 2006-05-23 07:30:00 | AAPL | Stock | 2.2782 | 2.2818 | 2.2782 | 2.2786 | 72184.0 |
| 2006-05-23 08:00:00 | AAPL | Stock | 2.2821 | 2.2896 | 2.2768 | 2.2857 | 1107148.0 |
| 2006-05-23 08:30:00 | AAPL | Stock | 2.2857 | 2.2871 | 2.2854 | 2.2857 | 279104.0 |
| 2006-05-23 09:00:00 | AAPL | Stock | 2.2857 | 2.3225 | 2.2854 | 2.3164 | 8597120.0 |
| 2006-05-23 09:30:00 | AAPL | Stock | 2.3164 | 2.3282 | 2.2868 | 2.2971 | 132141968.0 |
| 2006-05-23 10:00:00 | AAPL | Stock | 2.2971 | 2.2993 | 2.2718 | 2.2749 | 82195092.0 |
| 2006-05-23 10:30:00 | AAPL | Stock | 2.2739 | 2.3164 | 2.2718 | 2.2979 | 83447252.0 |
| 2006-05-23 11:00:00 | AAPL | Stock | 2.2979 | 2.2989 | 2.2821 | 2.2854 | 50545992.0 |
| 2006-05-23 11:30:00 | AAPL | Stock | 2.2861 | 2.3161 | 2.2832 | 2.2899 | 28279468.0 |
| 2006-05-23 12:00:00 | AAPL | Stock | 2.2896 | 2.2964 | 2.2864 | 2.2921 | 24963288.0 |
| 2006-05-23 12:30:00 | AAPL | Stock | 2.2921 | 2.2921 | 2.2832 | 2.2875 | 17669708.0 |
| 2006-05-23 13:00:00 | AAPL | Stock | 2.2879 | 2.295 | 2.2868 | 2.2946 | 17041808.0 |
| 2006-05-23 13:30:00 | AAPL | Stock | 2.2946 | 2.3046 | 2.29 | 2.2932 | 30144072.0 |
| 2006-05-23 14:00:00 | AAPL | Stock | 2.2939 | 2.2946 | 2.2875 | 2.2886 | 24769864.0 |
| 2006-05-23 14:30:00 | AAPL | Stock | 2.2886 | 2.2925 | 2.2796 | 2.2832 | 40719840.0 |
| 2006-05-23 15:00:00 | AAPL | Stock | 2.2836 | 2.29 | 2.2754 | 2.2761 | 48335476.0 |
| 2006-05-23 15:30:00 | AAPL | Stock | 2.2764 | 2.2786 | 2.25 | 2.2504 | 90936580.0 |
| 2006-05-23 16:00:00 | AAPL | Stock | 2.2504 | 2.2521 | 2.2293 | 2.2436 | 4355624.0 |
| 2006-05-23 16:30:00 | AAPL | Stock | 2.2439 | 2.2446 | 2.2411 | 2.2432 | 1317764.0 |
| 2006-05-23 17:00:00 | AAPL | Stock | 2.2432 | 2.2432 | 2.2411 | 2.2414 | 848120.0 |
| 2006-05-23 17:30:00 | AAPL | Stock | 2.2414 | 2.2443 | 2.2414 | 2.2429 | 182224.0 |
| 2006-05-23 18:00:00 | AAPL | Stock | 2.2421 | 2.25 | 2.2393 | 2.2411 | 333816.0 |
| 2006-05-23 07:30:00 | MSFT | Stock | 22.92 | 22.92 | 22.89 | 22.89 | 2000.0 |
| 2006-05-23 08:00:00 | MSFT | Stock | 22.92 | 23.06 | 22.92 | 23.03 | 53376.0 |
| 2006-05-23 08:30:00 | MSFT | Stock | 23.05 | 23.1 | 23.03 | 23.06 | 72258.0 |
| 2006-05-23 09:00:00 | MSFT | Stock | 23.06 | 23.16 | 23.05 | 23.11 | 236466.0 |
| 2006-05-23 09:30:00 | MSFT | Stock | 23.1 | 23.38 | 23.09 | 23.26 | 16666868.0 |
| 2006-05-23 10:00:00 | MSFT | Stock | 23.26 | 23.29 | 23.24 | 23.26 | 6247491.0 |
| 2006-05-23 10:30:00 | MSFT | Stock | 23.25 | 23.29 | 23.22 | 23.26 | 5215702.0 |
| 2006-05-23 11:00:00 | MSFT | Stock | 23.26 | 23.26 | 23.14 | 23.16 | 5610107.0 |
| 2006-05-23 11:30:00 | MSFT | Stock | 23.17 | 23.2 | 23.14 | 23.18 | 4373728.0 |
| 2006-05-23 12:00:00 | MSFT | Stock | 23.17 | 23.18 | 23.1 | 23.16 | 3785098.0 |
| 2006-05-23 12:30:00 | MSFT | Stock | 23.16 | 23.24 | 23.12 | 23.15 | 3337135.0 |
| 2006-05-23 13:00:00 | MSFT | Stock | 23.14 | 23.167 | 23.11 | 23.16 | 2676095.0 |
| 2006-05-23 13:30:00 | MSFT | Stock | 23.16 | 23.18 | 23.14 | 23.14 | 2329650.0 |
| 2006-05-23 14:00:00 | MSFT | Stock | 23.14 | 23.2 | 23.13 | 23.16 | 3836829.0 |
| 2006-05-23 14:30:00 | MSFT | Stock | 23.16 | 23.27 | 23.06 | 23.12 | 8365724.0 |
| 2006-05-23 15:00:00 | MSFT | Stock | 23.12 | 23.15 | 23.04 | 23.09 | 4757323.0 |
| 2006-05-23 15:30:00 | MSFT | Stock | 23.1 | 23.18 | 22.77 | 22.77 | 10141601.0 |
| 2006-05-23 16:00:00 | MSFT | Stock | 22.77 | 23.05 | 22.7 | 22.79 | 511687.0 |
| 2006-05-23 16:30:00 | MSFT | Stock | 22.79 | 22.79 | 22.67 | 22.67 | 57345.0 |
| 2006-05-23 17:00:00 | MSFT | Stock | 22.67 | 22.73 | 22.67 | 22.71 | 26025.0 |
| 2006-05-23 17:30:00 | MSFT | Stock | 22.7 | 22.76 | 22.69 | 22.7 | 21824.0 |
| 2006-05-23 18:00:00 | MSFT | Stock | 22.73 | 22.77 | 22.7 | 22.76 | 15231.0 |
| 2006-05-23 08:00:00 | NVDA | Stock | 0.405 | 0.405 | 0.405 | 0.405 | 36000.0 |
| 2006-05-23 08:30:00 | NVDA | Stock | 0.4072 | 0.4092 | 0.4072 | 0.409 | 114000.0 |
| 2006-05-23 09:00:00 | NVDA | Stock | 0.409 | 0.409 | 0.4075 | 0.4083 | 888000.0 |
| 2006-05-23 09:30:00 | NVDA | Stock | 0.4083 | 0.4178 | 0.4075 | 0.4108 | 139831920.0 |
> showing 50 of 49,705 rows — these rows as CSV