PREVIEW / stock_30min / 2006-08-04
file: by_date/stock_30min/2006/2006-08-04.parquet size: 915 KB rows: 49,591 symbols: 2,311
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-04 04:00:00 | AAPL | Stock | 2.3018 | 2.3214 | 2.2968 | 2.3107 | 505484.0 |
| 2006-08-04 04:30:00 | AAPL | Stock | 2.3036 | 2.3104 | 2.2964 | 2.2964 | 197456.0 |
| 2006-08-04 05:00:00 | AAPL | Stock | 2.2929 | 2.2964 | 2.2882 | 2.2964 | 110572.0 |
| 2006-08-04 05:30:00 | AAPL | Stock | 2.2982 | 2.3143 | 2.2982 | 2.3125 | 93632.0 |
| 2006-08-04 06:30:00 | AAPL | Stock | 2.3089 | 2.3161 | 2.3036 | 2.3036 | 116144.0 |
| 2006-08-04 07:00:00 | AAPL | Stock | 2.3036 | 2.3857 | 2.3036 | 2.3764 | 2894332.0 |
| 2006-08-04 07:30:00 | AAPL | Stock | 2.3764 | 2.4071 | 2.375 | 2.3964 | 3711680.0 |
| 2006-08-04 08:00:00 | AAPL | Stock | 2.3982 | 2.4071 | 2.3804 | 2.4004 | 34366668.0 |
| 2006-08-04 08:30:00 | AAPL | Stock | 2.4004 | 2.4136 | 2.3911 | 2.4107 | 35712208.0 |
| 2006-08-04 09:00:00 | AAPL | Stock | 2.4107 | 2.4107 | 2.3893 | 2.3943 | 46037544.0 |
| 2006-08-04 09:30:00 | AAPL | Stock | 2.3946 | 2.4504 | 2.3804 | 2.4132 | 313937512.0 |
| 2006-08-04 10:00:00 | AAPL | Stock | 2.4136 | 2.4168 | 2.3782 | 2.3914 | 178384472.0 |
| 2006-08-04 10:30:00 | AAPL | Stock | 2.3918 | 2.4125 | 2.3843 | 2.3875 | 99639204.0 |
| 2006-08-04 11:00:00 | AAPL | Stock | 2.3875 | 2.3939 | 2.3682 | 2.3696 | 107246328.0 |
| 2006-08-04 11:30:00 | AAPL | Stock | 2.37 | 2.3932 | 2.3225 | 2.3296 | 177433032.0 |
| 2006-08-04 12:00:00 | AAPL | Stock | 2.3293 | 2.3514 | 2.32 | 2.3332 | 155877988.0 |
| 2006-08-04 12:30:00 | AAPL | Stock | 2.3339 | 2.3482 | 2.3246 | 2.3338 | 82124840.0 |
| 2006-08-04 13:00:00 | AAPL | Stock | 2.3332 | 2.3475 | 2.3332 | 2.3432 | 75360348.0 |
| 2006-08-04 13:30:00 | AAPL | Stock | 2.3429 | 2.3754 | 2.3371 | 2.3654 | 107498076.0 |
| 2006-08-04 14:00:00 | AAPL | Stock | 2.3654 | 2.3811 | 2.3579 | 2.3582 | 71377992.0 |
| 2006-08-04 14:30:00 | AAPL | Stock | 2.3587 | 2.3732 | 2.3586 | 2.3654 | 53377800.0 |
| 2006-08-04 15:00:00 | AAPL | Stock | 2.3657 | 2.3989 | 2.3611 | 2.3986 | 108830344.0 |
| 2006-08-04 15:30:00 | AAPL | Stock | 2.3985 | 2.4414 | 2.3882 | 2.4411 | 179983552.0 |
| 2006-08-04 16:00:00 | AAPL | Stock | 2.4414 | 2.4446 | 2.4368 | 2.4393 | 3466540.0 |
| 2006-08-04 16:30:00 | AAPL | Stock | 2.4411 | 2.4411 | 2.4339 | 2.4361 | 933520.0 |
| 2006-08-04 17:00:00 | AAPL | Stock | 2.4361 | 2.44 | 2.4357 | 2.4364 | 249788.0 |
| 2006-08-04 17:30:00 | AAPL | Stock | 2.4393 | 2.4411 | 2.4364 | 2.4396 | 240772.0 |
| 2006-08-04 18:00:00 | AAPL | Stock | 2.4393 | 2.4404 | 2.4375 | 2.4404 | 228900.0 |
| 2006-08-04 07:00:00 | MSFT | Stock | 24.27 | 24.27 | 24.27 | 24.27 | 900.0 |
| 2006-08-04 07:30:00 | MSFT | Stock | 24.27 | 24.27 | 24.27 | 24.27 | 600.0 |
| 2006-08-04 08:00:00 | MSFT | Stock | 24.24 | 24.27 | 24.24 | 24.24 | 14600.0 |
| 2006-08-04 08:30:00 | MSFT | Stock | 24.25 | 24.38 | 24.25 | 24.38 | 91832.0 |
| 2006-08-04 09:00:00 | MSFT | Stock | 24.37 | 24.45 | 24.34 | 24.4 | 165598.0 |
| 2006-08-04 09:30:00 | MSFT | Stock | 24.4 | 24.44 | 24.32 | 24.367 | 4311895.0 |
| 2006-08-04 10:00:00 | MSFT | Stock | 24.37 | 24.43 | 24.33 | 24.381 | 2822079.0 |
| 2006-08-04 10:30:00 | MSFT | Stock | 24.39 | 24.47 | 24.38 | 24.45 | 3521953.0 |
| 2006-08-04 11:00:00 | MSFT | Stock | 24.46 | 24.49 | 24.43 | 24.48 | 2739529.0 |
| 2006-08-04 11:30:00 | MSFT | Stock | 24.481 | 24.49 | 24.45 | 24.45 | 2016965.0 |
| 2006-08-04 12:00:00 | MSFT | Stock | 24.453 | 24.46 | 24.36 | 24.39 | 3383632.0 |
| 2006-08-04 12:30:00 | MSFT | Stock | 24.39 | 24.4 | 24.32 | 24.35 | 1828495.0 |
| 2006-08-04 13:00:00 | MSFT | Stock | 24.35 | 24.39 | 24.24 | 24.32 | 2494131.0 |
| 2006-08-04 13:30:00 | MSFT | Stock | 24.32 | 24.33 | 24.24 | 24.27 | 2585327.0 |
| 2006-08-04 14:00:00 | MSFT | Stock | 24.27 | 24.32 | 24.16 | 24.2 | 2565836.0 |
| 2006-08-04 14:30:00 | MSFT | Stock | 24.2 | 24.28 | 24.19 | 24.22 | 1913067.0 |
| 2006-08-04 15:00:00 | MSFT | Stock | 24.22 | 24.28 | 24.15 | 24.26 | 3047223.0 |
| 2006-08-04 15:30:00 | MSFT | Stock | 24.26 | 24.3 | 24.2 | 24.3 | 4396874.0 |
| 2006-08-04 16:00:00 | MSFT | Stock | 24.3 | 24.31 | 24.14 | 24.22 | 179328.0 |
| 2006-08-04 16:30:00 | MSFT | Stock | 24.29 | 24.29 | 24.21 | 24.29 | 3268171.0 |
| 2006-08-04 17:00:00 | MSFT | Stock | 24.21 | 24.24 | 24.2 | 24.2 | 3780.0 |
| 2006-08-04 17:30:00 | MSFT | Stock | 24.24 | 24.24 | 24.19 | 24.22 | 2292.0 |
> showing 50 of 49,591 rows — these rows as CSV