PREVIEW / stock_30min / 2008-08-13
file: by_date/stock_30min/2008/2008-08-13.parquet size: 1.2 MB rows: 68,175 symbols: 3,327
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-13 04:30:00 | AAPL | Stock | 6.2996 | 6.2996 | 6.2996 | 6.2996 | 2800.0 |
| 2008-08-13 06:00:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 5936.0 |
| 2008-08-13 06:30:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 21000.0 |
| 2008-08-13 07:00:00 | AAPL | Stock | 6.2979 | 6.3318 | 6.2979 | 6.3043 | 51800.0 |
| 2008-08-13 07:30:00 | AAPL | Stock | 6.3043 | 6.3786 | 6.2939 | 6.3482 | 761460.0 |
| 2008-08-13 08:00:00 | AAPL | Stock | 6.3536 | 6.3732 | 6.3286 | 6.3504 | 2173080.0 |
| 2008-08-13 08:30:00 | AAPL | Stock | 6.3504 | 6.3643 | 6.3304 | 6.3318 | 1344952.0 |
| 2008-08-13 09:00:00 | AAPL | Stock | 6.3371 | 6.3632 | 6.3318 | 6.3564 | 2128756.0 |
| 2008-08-13 09:30:00 | AAPL | Stock | 6.3539 | 6.4214 | 6.3239 | 6.3886 | 132406148.0 |
| 2008-08-13 10:00:00 | AAPL | Stock | 6.3882 | 6.4268 | 6.3704 | 6.3996 | 84947492.0 |
| 2008-08-13 10:30:00 | AAPL | Stock | 6.3996 | 6.4089 | 6.3546 | 6.4025 | 67425820.0 |
| 2008-08-13 11:00:00 | AAPL | Stock | 6.4025 | 6.4032 | 6.3396 | 6.3611 | 49087780.0 |
| 2008-08-13 11:30:00 | AAPL | Stock | 6.3607 | 6.3689 | 6.2904 | 6.2936 | 69294120.0 |
| 2008-08-13 12:00:00 | AAPL | Stock | 6.2936 | 6.3461 | 6.2821 | 6.3364 | 44022832.0 |
| 2008-08-13 12:30:00 | AAPL | Stock | 6.3364 | 6.3475 | 6.3121 | 6.3375 | 30356592.0 |
| 2008-08-13 13:00:00 | AAPL | Stock | 6.3371 | 6.37 | 6.3314 | 6.3618 | 38093608.0 |
| 2008-08-13 13:30:00 | AAPL | Stock | 6.3618 | 6.3929 | 6.35 | 6.3907 | 53965968.0 |
| 2008-08-13 14:00:00 | AAPL | Stock | 6.3896 | 6.3957 | 6.3722 | 6.3889 | 40034568.0 |
| 2008-08-13 14:30:00 | AAPL | Stock | 6.3889 | 6.4286 | 6.3793 | 6.4264 | 70045332.0 |
| 2008-08-13 15:00:00 | AAPL | Stock | 6.4264 | 6.4286 | 6.39 | 6.4006 | 66241504.0 |
| 2008-08-13 15:30:00 | AAPL | Stock | 6.4004 | 6.4071 | 6.3729 | 6.4043 | 71961736.0 |
| 2008-08-13 16:00:00 | AAPL | Stock | 6.4043 | 6.4086 | 6.3767 | 6.3946 | 7523880.0 |
| 2008-08-13 16:30:00 | AAPL | Stock | 6.3932 | 6.4036 | 6.3932 | 6.4014 | 1022840.0 |
| 2008-08-13 17:00:00 | AAPL | Stock | 6.4 | 6.4 | 6.3929 | 6.3946 | 47600.0 |
| 2008-08-13 17:30:00 | AAPL | Stock | 6.3607 | 6.3964 | 6.3607 | 6.3964 | 73192.0 |
| 2008-08-13 18:00:00 | AAPL | Stock | 6.3961 | 6.3964 | 6.3957 | 6.3964 | 46564.0 |
| 2008-08-13 18:30:00 | AAPL | Stock | 6.3968 | 6.4054 | 6.3946 | 6.4043 | 258748.0 |
| 2008-08-13 19:00:00 | AAPL | Stock | 6.4043 | 6.4054 | 6.4043 | 6.4054 | 160356.0 |
| 2008-08-13 19:30:00 | AAPL | Stock | 6.4068 | 6.4071 | 6.3993 | 6.3993 | 58520.0 |
| 2008-08-13 07:00:00 | MSFT | Stock | 28.2 | 28.25 | 28.2 | 28.25 | 800.0 |
| 2008-08-13 07:30:00 | MSFT | Stock | 28.21 | 28.28 | 28.21 | 28.28 | 2200.0 |
| 2008-08-13 08:00:00 | MSFT | Stock | 28.21 | 28.21 | 28.21 | 28.21 | 4400.0 |
| 2008-08-13 08:30:00 | MSFT | Stock | 28.21 | 28.21 | 28.01 | 28.05 | 9254.0 |
| 2008-08-13 09:00:00 | MSFT | Stock | 28.08 | 28.11 | 28.01 | 28.07 | 46600.0 |
| 2008-08-13 09:30:00 | MSFT | Stock | 28.07 | 28.5 | 28.06 | 28.28 | 4635689.0 |
| 2008-08-13 10:00:00 | MSFT | Stock | 28.28 | 28.44 | 28.0 | 28.04 | 4267699.0 |
| 2008-08-13 10:30:00 | MSFT | Stock | 28.04 | 28.12 | 28.0 | 28.11 | 3678247.0 |
| 2008-08-13 11:00:00 | MSFT | Stock | 28.12 | 28.12 | 27.995 | 28.04 | 2213078.0 |
| 2008-08-13 11:30:00 | MSFT | Stock | 28.05 | 28.05 | 27.98 | 28.0 | 3150499.0 |
| 2008-08-13 12:00:00 | MSFT | Stock | 28.0 | 28.09 | 27.97 | 28.03 | 2732600.0 |
| 2008-08-13 12:30:00 | MSFT | Stock | 28.02 | 28.07 | 27.99 | 28.01 | 2496927.0 |
| 2008-08-13 13:00:00 | MSFT | Stock | 28.01 | 28.025 | 27.89 | 27.96 | 3354938.0 |
| 2008-08-13 13:30:00 | MSFT | Stock | 27.96 | 28.1 | 27.94 | 28.061 | 3378696.0 |
| 2008-08-13 14:00:00 | MSFT | Stock | 28.06 | 28.1 | 27.95 | 28.0 | 3061096.0 |
| 2008-08-13 14:30:00 | MSFT | Stock | 28.002 | 28.14 | 27.95 | 28.11 | 3214072.0 |
| 2008-08-13 15:00:00 | MSFT | Stock | 28.11 | 28.16 | 27.9 | 27.9 | 4653181.0 |
| 2008-08-13 15:30:00 | MSFT | Stock | 27.9 | 27.94 | 27.76 | 27.91 | 5799197.0 |
| 2008-08-13 16:00:00 | MSFT | Stock | 27.91 | 28.043 | 27.84 | 27.91 | 1311018.0 |
| 2008-08-13 16:30:00 | MSFT | Stock | 27.91 | 27.91 | 27.896 | 27.896 | 1285700.0 |
| 2008-08-13 17:30:00 | MSFT | Stock | 27.9 | 27.9 | 27.9 | 27.9 | 1000.0 |
> showing 50 of 68,175 rows — these rows as CSV