PREVIEW / stock_30min / 2010-08-04
file: by_date/stock_30min/2010/2010-08-04.parquet size: 1.4 MB rows: 73,600 symbols: 3,491
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-04 05:30:00 | AAPL | Stock | 9.3214 | 9.3214 | 9.3214 | 9.3214 | 3948.0 |
| 2010-08-04 07:00:00 | AAPL | Stock | 9.3632 | 9.3632 | 9.3564 | 9.3614 | 50400.0 |
| 2010-08-04 07:30:00 | AAPL | Stock | 9.3486 | 9.3554 | 9.3343 | 9.3393 | 35980.0 |
| 2010-08-04 08:00:00 | AAPL | Stock | 9.335 | 9.3786 | 9.3214 | 9.3786 | 1036952.0 |
| 2010-08-04 08:30:00 | AAPL | Stock | 9.3786 | 9.3814 | 9.3568 | 9.3625 | 974932.0 |
| 2010-08-04 09:00:00 | AAPL | Stock | 9.3625 | 9.3996 | 9.3625 | 9.3861 | 1443624.0 |
| 2010-08-04 09:30:00 | AAPL | Stock | 9.3871 | 9.4321 | 9.3682 | 9.4146 | 60550336.0 |
| 2010-08-04 10:00:00 | AAPL | Stock | 9.4146 | 9.4386 | 9.2968 | 9.3533 | 105392084.0 |
| 2010-08-04 10:30:00 | AAPL | Stock | 9.3554 | 9.36 | 9.3196 | 9.3354 | 24163132.0 |
| 2010-08-04 11:00:00 | AAPL | Stock | 9.3357 | 9.3918 | 9.3339 | 9.3859 | 28280756.0 |
| 2010-08-04 11:30:00 | AAPL | Stock | 9.3857 | 9.3889 | 9.3471 | 9.3479 | 21548520.0 |
| 2010-08-04 12:00:00 | AAPL | Stock | 9.3482 | 9.3921 | 9.3482 | 9.3864 | 19857292.0 |
| 2010-08-04 12:30:00 | AAPL | Stock | 9.3871 | 9.3929 | 9.3726 | 9.3796 | 13767656.0 |
| 2010-08-04 13:00:00 | AAPL | Stock | 9.3796 | 9.3857 | 9.3464 | 9.3564 | 18724356.0 |
| 2010-08-04 13:30:00 | AAPL | Stock | 9.3575 | 9.3739 | 9.3504 | 9.3618 | 14483420.0 |
| 2010-08-04 14:00:00 | AAPL | Stock | 9.3621 | 9.3886 | 9.3608 | 9.3821 | 16217852.0 |
| 2010-08-04 14:30:00 | AAPL | Stock | 9.3814 | 9.3993 | 9.3725 | 9.3822 | 21211876.0 |
| 2010-08-04 15:00:00 | AAPL | Stock | 9.3832 | 9.3929 | 9.37 | 9.3846 | 21221760.0 |
| 2010-08-04 15:30:00 | AAPL | Stock | 9.3871 | 9.3949 | 9.3732 | 9.3907 | 41807696.0 |
| 2010-08-04 16:00:00 | AAPL | Stock | 9.3911 | 9.3946 | 9.3564 | 9.3921 | 7188552.0 |
| 2010-08-04 16:30:00 | AAPL | Stock | 9.3929 | 9.3936 | 9.3718 | 9.3936 | 264740.0 |
| 2010-08-04 17:00:00 | AAPL | Stock | 9.3546 | 9.3929 | 9.3546 | 9.3918 | 69580.0 |
| 2010-08-04 17:30:00 | AAPL | Stock | 9.3893 | 9.3893 | 9.3882 | 9.3882 | 15064.0 |
| 2010-08-04 18:00:00 | AAPL | Stock | 9.3893 | 9.3921 | 9.3882 | 9.39 | 152684.0 |
| 2010-08-04 18:30:00 | AAPL | Stock | 9.3882 | 9.3882 | 9.3804 | 9.3854 | 104972.0 |
| 2010-08-04 19:00:00 | AAPL | Stock | 9.3854 | 9.3861 | 9.3854 | 9.3857 | 14980.0 |
| 2010-08-04 19:30:00 | AAPL | Stock | 9.3886 | 9.3911 | 9.3839 | 9.3911 | 49924.0 |
| 2010-08-04 08:00:00 | MSFT | Stock | 26.11 | 26.19 | 26.09 | 26.18 | 9741.0 |
| 2010-08-04 08:30:00 | MSFT | Stock | 26.2 | 26.26 | 26.2 | 26.23 | 4530.0 |
| 2010-08-04 09:00:00 | MSFT | Stock | 26.24 | 26.25 | 26.13 | 26.14 | 21677.0 |
| 2010-08-04 09:30:00 | MSFT | Stock | 26.15 | 26.24 | 25.71 | 25.71 | 10118528.0 |
| 2010-08-04 10:00:00 | MSFT | Stock | 25.72 | 25.81 | 25.44 | 25.47 | 13813619.0 |
| 2010-08-04 10:30:00 | MSFT | Stock | 25.47 | 25.72 | 25.45 | 25.675 | 6783775.0 |
| 2010-08-04 11:00:00 | MSFT | Stock | 25.68 | 25.78 | 25.64 | 25.74 | 5016827.0 |
| 2010-08-04 11:30:00 | MSFT | Stock | 25.74 | 25.76 | 25.61 | 25.67 | 4209569.0 |
| 2010-08-04 12:00:00 | MSFT | Stock | 25.67 | 25.7 | 25.61 | 25.64 | 4055486.0 |
| 2010-08-04 12:30:00 | MSFT | Stock | 25.65 | 25.71 | 25.64 | 25.689 | 2898823.0 |
| 2010-08-04 13:00:00 | MSFT | Stock | 25.685 | 25.71 | 25.54 | 25.555 | 3212626.0 |
| 2010-08-04 13:30:00 | MSFT | Stock | 25.56 | 25.66 | 25.54 | 25.565 | 3688309.0 |
| 2010-08-04 14:00:00 | MSFT | Stock | 25.56 | 25.59 | 25.54 | 25.572 | 3523492.0 |
| 2010-08-04 14:30:00 | MSFT | Stock | 25.578 | 25.68 | 25.55 | 25.66 | 3868723.0 |
| 2010-08-04 15:00:00 | MSFT | Stock | 25.66 | 25.75 | 25.63 | 25.71 | 4135633.0 |
| 2010-08-04 15:30:00 | MSFT | Stock | 25.705 | 25.8 | 25.68 | 25.73 | 10433553.0 |
| 2010-08-04 16:00:00 | MSFT | Stock | 25.73 | 25.78 | 25.58 | 25.73 | 2040977.0 |
| 2010-08-04 16:30:00 | MSFT | Stock | 25.73 | 25.75 | 25.662 | 25.75 | 12630.0 |
| 2010-08-04 17:00:00 | MSFT | Stock | 26.16 | 26.16 | 25.74 | 25.74 | 600.0 |
| 2010-08-04 17:30:00 | MSFT | Stock | 25.74 | 25.77 | 25.74 | 25.75 | 1900.0 |
| 2010-08-04 18:00:00 | MSFT | Stock | 25.75 | 25.75 | 25.73 | 25.75 | 24542.0 |
| 2010-08-04 18:30:00 | MSFT | Stock | 25.74 | 25.75 | 25.74 | 25.74 | 2500.0 |
| 2010-08-04 19:00:00 | MSFT | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 1900.0 |
> showing 50 of 73,600 rows — these rows as CSV