PREVIEW / stock_30min / 2006-08-29
file: by_date/stock_30min/2006/2006-08-29.parquet size: 920 KB rows: 50,262 symbols: 2,348
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-29 07:00:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.4036 | 2.4036 | 28000.0 |
| 2006-08-29 07:30:00 | AAPL | Stock | 2.3964 | 2.3964 | 2.3964 | 2.3964 | 14000.0 |
| 2006-08-29 08:00:00 | AAPL | Stock | 2.3979 | 2.4014 | 2.3929 | 2.3964 | 849800.0 |
| 2006-08-29 08:30:00 | AAPL | Stock | 2.3946 | 2.3946 | 2.3868 | 2.3882 | 786156.0 |
| 2006-08-29 09:00:00 | AAPL | Stock | 2.3886 | 2.3971 | 2.3871 | 2.3929 | 2355472.0 |
| 2006-08-29 09:30:00 | AAPL | Stock | 2.3925 | 2.4021 | 2.3475 | 2.3686 | 156960272.0 |
| 2006-08-29 10:00:00 | AAPL | Stock | 2.3682 | 2.3754 | 2.3421 | 2.3446 | 128174284.0 |
| 2006-08-29 10:30:00 | AAPL | Stock | 2.3447 | 2.3921 | 2.3375 | 2.3425 | 92937656.0 |
| 2006-08-29 11:00:00 | AAPL | Stock | 2.3425 | 2.3486 | 2.3357 | 2.3382 | 63273084.0 |
| 2006-08-29 11:30:00 | AAPL | Stock | 2.3379 | 2.3411 | 2.3257 | 2.3321 | 57659532.0 |
| 2006-08-29 12:00:00 | AAPL | Stock | 2.3318 | 2.3414 | 2.3271 | 2.3385 | 41026384.0 |
| 2006-08-29 12:30:00 | AAPL | Stock | 2.3382 | 2.3421 | 2.3364 | 2.3379 | 25210528.0 |
| 2006-08-29 13:00:00 | AAPL | Stock | 2.3379 | 2.3443 | 2.3375 | 2.34 | 27364736.0 |
| 2006-08-29 13:30:00 | AAPL | Stock | 2.34 | 2.3436 | 2.3357 | 2.3421 | 23844156.0 |
| 2006-08-29 14:00:00 | AAPL | Stock | 2.3425 | 2.3643 | 2.3369 | 2.3525 | 100433032.0 |
| 2006-08-29 14:30:00 | AAPL | Stock | 2.3529 | 2.3636 | 2.3525 | 2.3593 | 65427124.0 |
| 2006-08-29 15:00:00 | AAPL | Stock | 2.3596 | 2.3661 | 2.3561 | 2.3639 | 53205488.0 |
| 2006-08-29 15:30:00 | AAPL | Stock | 2.3636 | 2.3771 | 2.3636 | 2.3739 | 86266012.0 |
| 2006-08-29 16:00:00 | AAPL | Stock | 2.3736 | 2.375 | 2.3732 | 2.375 | 1462188.0 |
| 2006-08-29 16:30:00 | AAPL | Stock | 2.375 | 2.3929 | 2.375 | 2.3864 | 3678724.0 |
| 2006-08-29 17:00:00 | AAPL | Stock | 2.3875 | 2.3925 | 2.3875 | 2.3879 | 852544.0 |
| 2006-08-29 17:30:00 | AAPL | Stock | 2.3879 | 2.3907 | 2.3861 | 2.3893 | 119700.0 |
| 2006-08-29 18:00:00 | AAPL | Stock | 2.3879 | 2.3879 | 2.3843 | 2.3857 | 129696.0 |
| 2006-08-29 08:00:00 | MSFT | Stock | 25.93 | 25.99 | 25.92 | 25.99 | 2000.0 |
| 2006-08-29 08:30:00 | MSFT | Stock | 25.99 | 25.99 | 25.9 | 25.9 | 7050.0 |
| 2006-08-29 09:00:00 | MSFT | Stock | 25.96 | 25.96 | 25.87 | 25.92 | 46598.0 |
| 2006-08-29 09:30:00 | MSFT | Stock | 25.92 | 25.98 | 25.87 | 25.93 | 4369440.0 |
| 2006-08-29 10:00:00 | MSFT | Stock | 25.92 | 25.94 | 25.71 | 25.71 | 5098727.0 |
| 2006-08-29 10:30:00 | MSFT | Stock | 25.7 | 25.87 | 25.65 | 25.75 | 4294250.0 |
| 2006-08-29 11:00:00 | MSFT | Stock | 25.75 | 25.81 | 25.72 | 25.78 | 1735800.0 |
| 2006-08-29 11:30:00 | MSFT | Stock | 25.78 | 25.79 | 25.68 | 25.69 | 1659961.0 |
| 2006-08-29 12:00:00 | MSFT | Stock | 25.68 | 25.72 | 25.64 | 25.66 | 2363039.0 |
| 2006-08-29 12:30:00 | MSFT | Stock | 25.66 | 25.76 | 25.63 | 25.67 | 1245068.0 |
| 2006-08-29 13:00:00 | MSFT | Stock | 25.66 | 25.75 | 25.66 | 25.732 | 1497483.0 |
| 2006-08-29 13:30:00 | MSFT | Stock | 25.73 | 25.75 | 25.7 | 25.73 | 1517389.0 |
| 2006-08-29 14:00:00 | MSFT | Stock | 25.738 | 25.88 | 25.66 | 25.76 | 4819835.0 |
| 2006-08-29 14:30:00 | MSFT | Stock | 25.76 | 25.85 | 25.74 | 25.82 | 2053432.0 |
| 2006-08-29 15:00:00 | MSFT | Stock | 25.83 | 25.85 | 25.77 | 25.79 | 3890042.0 |
| 2006-08-29 15:30:00 | MSFT | Stock | 25.78 | 25.91 | 25.78 | 25.81 | 5870379.0 |
| 2006-08-29 16:00:00 | MSFT | Stock | 25.82 | 25.84 | 25.8 | 25.82 | 201162.0 |
| 2006-08-29 16:30:00 | MSFT | Stock | 25.82 | 25.82 | 25.82 | 25.82 | 2300.0 |
| 2006-08-29 17:00:00 | MSFT | Stock | 25.81 | 25.81 | 25.78 | 25.78 | 7929.0 |
| 2006-08-29 17:30:00 | MSFT | Stock | 25.81 | 25.83 | 25.81 | 25.83 | 10000.0 |
| 2006-08-29 08:00:00 | NVDA | Stock | 0.4575 | 0.4622 | 0.4575 | 0.4615 | 189000.0 |
| 2006-08-29 08:30:00 | NVDA | Stock | 0.4603 | 0.4608 | 0.4603 | 0.4603 | 213000.0 |
| 2006-08-29 09:00:00 | NVDA | Stock | 0.4603 | 0.4612 | 0.4587 | 0.4603 | 1266000.0 |
| 2006-08-29 09:30:00 | NVDA | Stock | 0.4608 | 0.4665 | 0.4575 | 0.4662 | 82574340.0 |
| 2006-08-29 10:00:00 | NVDA | Stock | 0.4663 | 0.4667 | 0.4608 | 0.4617 | 64592580.0 |
| 2006-08-29 10:30:00 | NVDA | Stock | 0.4617 | 0.4642 | 0.4612 | 0.4632 | 31717980.0 |
| 2006-08-29 11:00:00 | NVDA | Stock | 0.463 | 0.4632 | 0.4595 | 0.4621 | 28762560.0 |
> showing 50 of 50,262 rows — these rows as CSV