PREVIEW / stock_30min / 2006-08-01
file: by_date/stock_30min/2006/2006-08-01.parquet size: 904 KB rows: 50,034 symbols: 2,307
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-01 04:00:00 | AAPL | Stock | 2.4268 | 2.4268 | 2.4214 | 2.4214 | 75600.0 |
| 2006-08-01 04:30:00 | AAPL | Stock | 2.4286 | 2.4286 | 2.4214 | 2.425 | 50400.0 |
| 2006-08-01 08:00:00 | AAPL | Stock | 2.4268 | 2.4286 | 2.4161 | 2.4271 | 526876.0 |
| 2006-08-01 08:30:00 | AAPL | Stock | 2.4196 | 2.4271 | 2.4107 | 2.4125 | 773360.0 |
| 2006-08-01 09:00:00 | AAPL | Stock | 2.4125 | 2.4125 | 2.4 | 2.4 | 1756468.0 |
| 2006-08-01 09:30:00 | AAPL | Stock | 2.4007 | 2.4261 | 2.3989 | 2.4225 | 89481084.0 |
| 2006-08-01 10:00:00 | AAPL | Stock | 2.4225 | 2.4243 | 2.4054 | 2.4075 | 66942344.0 |
| 2006-08-01 10:30:00 | AAPL | Stock | 2.4079 | 2.4118 | 2.3836 | 2.3839 | 67174548.0 |
| 2006-08-01 11:00:00 | AAPL | Stock | 2.3839 | 2.3954 | 2.3793 | 2.3954 | 53152008.0 |
| 2006-08-01 11:30:00 | AAPL | Stock | 2.3954 | 2.4011 | 2.3925 | 2.3971 | 32169172.0 |
| 2006-08-01 12:00:00 | AAPL | Stock | 2.3971 | 2.3971 | 2.3839 | 2.3846 | 30854684.0 |
| 2006-08-01 12:30:00 | AAPL | Stock | 2.3843 | 2.3896 | 2.3729 | 2.3782 | 46230940.0 |
| 2006-08-01 13:00:00 | AAPL | Stock | 2.3779 | 2.3782 | 2.355 | 2.365 | 67545156.0 |
| 2006-08-01 13:30:00 | AAPL | Stock | 2.3646 | 2.3711 | 2.3614 | 2.3707 | 27580756.0 |
| 2006-08-01 14:00:00 | AAPL | Stock | 2.3704 | 2.3796 | 2.3704 | 2.3793 | 37962708.0 |
| 2006-08-01 14:30:00 | AAPL | Stock | 2.3796 | 2.3886 | 2.3693 | 2.3771 | 66651592.0 |
| 2006-08-01 15:00:00 | AAPL | Stock | 2.3771 | 2.3836 | 2.3686 | 2.381 | 39004700.0 |
| 2006-08-01 15:30:00 | AAPL | Stock | 2.3814 | 2.4046 | 2.3814 | 2.4014 | 69486452.0 |
| 2006-08-01 16:00:00 | AAPL | Stock | 2.4018 | 2.4079 | 2.3986 | 2.3986 | 1670676.0 |
| 2006-08-01 16:30:00 | AAPL | Stock | 2.3993 | 2.4018 | 2.3993 | 2.4014 | 113036.0 |
| 2006-08-01 17:00:00 | AAPL | Stock | 2.4014 | 2.4014 | 2.4 | 2.4 | 69300.0 |
| 2006-08-01 17:30:00 | AAPL | Stock | 2.4014 | 2.4014 | 2.3993 | 2.4014 | 120400.0 |
| 2006-08-01 18:00:00 | AAPL | Stock | 2.4 | 2.4018 | 2.3996 | 2.4018 | 99064.0 |
| 2006-08-01 07:30:00 | MSFT | Stock | 24.08 | 24.08 | 24.08 | 24.08 | 200.0 |
| 2006-08-01 08:00:00 | MSFT | Stock | 24.06 | 24.06 | 24.06 | 24.06 | 26030.0 |
| 2006-08-01 08:30:00 | MSFT | Stock | 24.18 | 24.18 | 24.06 | 24.1 | 32570.0 |
| 2006-08-01 09:00:00 | MSFT | Stock | 24.1 | 24.13 | 24.02 | 24.02 | 83682.0 |
| 2006-08-01 09:30:00 | MSFT | Stock | 24.02 | 24.1 | 24.01 | 24.06 | 3694061.0 |
| 2006-08-01 10:00:00 | MSFT | Stock | 24.06 | 24.08 | 23.85 | 23.89 | 5231381.0 |
| 2006-08-01 10:30:00 | MSFT | Stock | 23.9 | 24.2 | 23.87 | 24.1 | 9429004.0 |
| 2006-08-01 11:00:00 | MSFT | Stock | 24.1 | 24.13 | 24.02 | 24.09 | 3416465.0 |
| 2006-08-01 11:30:00 | MSFT | Stock | 24.08 | 24.11 | 24.02 | 24.08 | 3469907.0 |
| 2006-08-01 12:00:00 | MSFT | Stock | 24.08 | 24.09 | 24.03 | 24.04 | 1859832.0 |
| 2006-08-01 12:30:00 | MSFT | Stock | 24.04 | 24.05 | 24.0 | 24.03 | 1853372.0 |
| 2006-08-01 13:00:00 | MSFT | Stock | 24.02 | 24.03 | 23.94 | 23.99 | 1879821.0 |
| 2006-08-01 13:30:00 | MSFT | Stock | 24.0 | 24.04 | 23.94 | 23.97 | 2719310.0 |
| 2006-08-01 14:00:00 | MSFT | Stock | 23.97 | 24.06 | 23.94 | 23.98 | 2595070.0 |
| 2006-08-01 14:30:00 | MSFT | Stock | 23.99 | 23.99 | 23.9 | 23.96 | 1989775.0 |
| 2006-08-01 15:00:00 | MSFT | Stock | 23.96 | 24.0 | 23.9 | 23.98 | 2563731.0 |
| 2006-08-01 15:30:00 | MSFT | Stock | 23.98 | 24.1 | 23.97 | 23.99 | 5576393.0 |
| 2006-08-01 16:00:00 | MSFT | Stock | 23.99 | 24.04 | 23.98 | 24.04 | 55480.0 |
| 2006-08-01 16:30:00 | MSFT | Stock | 24.05 | 24.05 | 23.99 | 24.02 | 587586.0 |
| 2006-08-01 17:00:00 | MSFT | Stock | 23.99 | 24.02 | 23.99 | 24.02 | 809.0 |
| 2006-08-01 18:00:00 | MSFT | Stock | 24.01 | 24.06 | 23.99 | 23.99 | 1986.0 |
| 2006-08-01 08:00:00 | NVDA | Stock | 0.3705 | 0.3742 | 0.3705 | 0.3707 | 36000.0 |
| 2006-08-01 08:30:00 | NVDA | Stock | 0.3717 | 0.3717 | 0.365 | 0.365 | 429600.0 |
| 2006-08-01 09:00:00 | NVDA | Stock | 0.365 | 0.3665 | 0.3632 | 0.3635 | 281160.0 |
| 2006-08-01 09:30:00 | NVDA | Stock | 0.3645 | 0.3652 | 0.3552 | 0.3562 | 71965260.0 |
| 2006-08-01 10:00:00 | NVDA | Stock | 0.3563 | 0.3573 | 0.353 | 0.3565 | 60578820.0 |
| 2006-08-01 10:30:00 | NVDA | Stock | 0.3563 | 0.3608 | 0.3563 | 0.3588 | 49118340.0 |
> showing 50 of 50,034 rows — these rows as CSV