PREVIEW / stock_30min / 2008-12-23
file: by_date/stock_30min/2008/2008-12-23.parquet size: 1.2 MB rows: 70,342 symbols: 3,372
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-12-23 06:00:00 | AAPL | Stock | 3.0754 | 3.0754 | 3.0754 | 3.0754 | 36820.0 |
| 2008-12-23 08:00:00 | AAPL | Stock | 3.0768 | 3.0814 | 3.0643 | 3.0757 | 222152.0 |
| 2008-12-23 08:30:00 | AAPL | Stock | 3.0729 | 3.0832 | 3.0693 | 3.0814 | 692944.0 |
| 2008-12-23 09:00:00 | AAPL | Stock | 3.0836 | 3.1061 | 3.0771 | 3.1046 | 1708476.0 |
| 2008-12-23 09:30:00 | AAPL | Stock | 3.1025 | 3.1182 | 3.0714 | 3.1174 | 80750012.0 |
| 2008-12-23 10:00:00 | AAPL | Stock | 3.1164 | 3.1232 | 3.0896 | 3.1054 | 59667160.0 |
| 2008-12-23 10:30:00 | AAPL | Stock | 3.105 | 3.1382 | 3.1036 | 3.1236 | 64367268.0 |
| 2008-12-23 11:00:00 | AAPL | Stock | 3.1232 | 3.1311 | 3.1 | 3.1043 | 49442904.0 |
| 2008-12-23 11:30:00 | AAPL | Stock | 3.1046 | 3.1182 | 3.0861 | 3.0889 | 42966896.0 |
| 2008-12-23 12:00:00 | AAPL | Stock | 3.0889 | 3.0925 | 3.0736 | 3.0807 | 35685580.0 |
| 2008-12-23 12:30:00 | AAPL | Stock | 3.0807 | 3.0886 | 3.0693 | 3.085 | 33395740.0 |
| 2008-12-23 13:00:00 | AAPL | Stock | 3.0854 | 3.0886 | 3.0761 | 3.0821 | 23804704.0 |
| 2008-12-23 13:30:00 | AAPL | Stock | 3.0814 | 3.0982 | 3.0804 | 3.0979 | 29379644.0 |
| 2008-12-23 14:00:00 | AAPL | Stock | 3.0971 | 3.0986 | 3.08 | 3.0846 | 31028004.0 |
| 2008-12-23 14:30:00 | AAPL | Stock | 3.0843 | 3.0875 | 3.0679 | 3.0768 | 48803748.0 |
| 2008-12-23 15:00:00 | AAPL | Stock | 3.0768 | 3.1 | 3.0729 | 3.0884 | 54828676.0 |
| 2008-12-23 15:30:00 | AAPL | Stock | 3.0886 | 3.1025 | 3.0768 | 3.0861 | 63168252.0 |
| 2008-12-23 16:00:00 | AAPL | Stock | 3.0861 | 3.096 | 3.0754 | 3.096 | 9099748.0 |
| 2008-12-23 16:30:00 | AAPL | Stock | 3.0796 | 3.085 | 3.0743 | 3.0771 | 189224.0 |
| 2008-12-23 17:00:00 | AAPL | Stock | 3.0771 | 3.0804 | 3.0736 | 3.0779 | 274400.0 |
| 2008-12-23 17:30:00 | AAPL | Stock | 3.0786 | 3.0818 | 3.0768 | 3.0768 | 120540.0 |
| 2008-12-23 18:00:00 | AAPL | Stock | 3.0804 | 3.085 | 3.0786 | 3.0818 | 6462988.0 |
| 2008-12-23 18:30:00 | AAPL | Stock | 3.0814 | 3.085 | 3.0814 | 3.085 | 63896.0 |
| 2008-12-23 19:00:00 | AAPL | Stock | 3.0811 | 3.0811 | 3.0811 | 3.0811 | 8876.0 |
| 2008-12-23 19:30:00 | AAPL | Stock | 3.0793 | 3.0846 | 3.0793 | 3.0846 | 98644.0 |
| 2008-12-23 08:00:00 | MSFT | Stock | 19.29 | 19.29 | 19.21 | 19.29 | 3670.0 |
| 2008-12-23 08:30:00 | MSFT | Stock | 19.28 | 19.3 | 19.24 | 19.3 | 3943.0 |
| 2008-12-23 09:00:00 | MSFT | Stock | 19.3 | 19.34 | 19.25 | 19.33 | 12413.0 |
| 2008-12-23 09:30:00 | MSFT | Stock | 19.27 | 19.48 | 19.19 | 19.46 | 4328125.0 |
| 2008-12-23 10:00:00 | MSFT | Stock | 19.45 | 19.57 | 19.3 | 19.39 | 4641376.0 |
| 2008-12-23 10:30:00 | MSFT | Stock | 19.38 | 19.52 | 19.333 | 19.34 | 3027884.0 |
| 2008-12-23 11:00:00 | MSFT | Stock | 19.35 | 19.39 | 19.27 | 19.28 | 2753938.0 |
| 2008-12-23 11:30:00 | MSFT | Stock | 19.27 | 19.4 | 19.17 | 19.19 | 2732742.0 |
| 2008-12-23 12:00:00 | MSFT | Stock | 19.188 | 19.298 | 19.068 | 19.13 | 2674628.0 |
| 2008-12-23 12:30:00 | MSFT | Stock | 19.12 | 19.19 | 19.06 | 19.17 | 2313036.0 |
| 2008-12-23 13:00:00 | MSFT | Stock | 19.16 | 19.2 | 19.11 | 19.193 | 1617358.0 |
| 2008-12-23 13:30:00 | MSFT | Stock | 19.198 | 19.21 | 19.08 | 19.19 | 2239947.0 |
| 2008-12-23 14:00:00 | MSFT | Stock | 19.18 | 19.19 | 19.07 | 19.08 | 2545535.0 |
| 2008-12-23 14:30:00 | MSFT | Stock | 19.078 | 19.15 | 19.01 | 19.13 | 5362669.0 |
| 2008-12-23 15:00:00 | MSFT | Stock | 19.13 | 19.296 | 19.1 | 19.25 | 4842283.0 |
| 2008-12-23 15:30:00 | MSFT | Stock | 19.25 | 19.33 | 19.19 | 19.29 | 5952293.0 |
| 2008-12-23 16:00:00 | MSFT | Stock | 19.28 | 19.33 | 19.166 | 19.166 | 2033444.0 |
| 2008-12-23 16:30:00 | MSFT | Stock | 19.3 | 19.3 | 19.28 | 19.3 | 2694.0 |
| 2008-12-23 17:00:00 | MSFT | Stock | 19.3 | 19.3 | 19.25 | 19.29 | 2700.0 |
| 2008-12-23 17:30:00 | MSFT | Stock | 19.3 | 19.3 | 19.24 | 19.29 | 5701.0 |
| 2008-12-23 18:00:00 | MSFT | Stock | 19.29 | 19.29 | 19.28 | 19.28 | 18481.0 |
| 2008-12-23 19:00:00 | MSFT | Stock | 19.3 | 19.3 | 19.3 | 19.3 | 850.0 |
| 2008-12-23 19:30:00 | MSFT | Stock | 19.31 | 19.31 | 19.3 | 19.3 | 3800.0 |
| 2008-12-23 08:30:00 | NVDA | Stock | 0.2 | 0.2 | 0.2 | 0.2 | 4000.0 |
| 2008-12-23 09:00:00 | NVDA | Stock | 0.2025 | 0.203 | 0.2025 | 0.203 | 24000.0 |
> showing 50 of 70,342 rows — these rows as CSV