PREVIEW / stock_30min / 2010-10-08
file: by_date/stock_30min/2010/2010-10-08.parquet size: 1.4 MB rows: 74,077 symbols: 3,484
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-10-08 06:00:00 | AAPL | Stock | 10.3071 | 10.3071 | 10.3071 | 10.3071 | 14000.0 |
| 2010-10-08 07:00:00 | AAPL | Stock | 10.3054 | 10.3282 | 10.2961 | 10.3146 | 35000.0 |
| 2010-10-08 07:30:00 | AAPL | Stock | 10.3125 | 10.3196 | 10.3125 | 10.3157 | 48160.0 |
| 2010-10-08 08:00:00 | AAPL | Stock | 10.3111 | 10.3336 | 10.3039 | 10.3196 | 1776040.0 |
| 2010-10-08 08:30:00 | AAPL | Stock | 10.3179 | 10.3768 | 10.25 | 10.3429 | 7975604.0 |
| 2010-10-08 09:00:00 | AAPL | Stock | 10.3446 | 10.4321 | 10.3336 | 10.4189 | 7981652.0 |
| 2010-10-08 09:30:00 | AAPL | Stock | 10.4225 | 10.4536 | 10.3789 | 10.4268 | 99051708.0 |
| 2010-10-08 10:00:00 | AAPL | Stock | 10.4275 | 10.4382 | 10.3571 | 10.3646 | 64542436.0 |
| 2010-10-08 10:30:00 | AAPL | Stock | 10.3636 | 10.4225 | 10.3571 | 10.4168 | 39468492.0 |
| 2010-10-08 11:00:00 | AAPL | Stock | 10.4171 | 10.4793 | 10.4107 | 10.4764 | 63232148.0 |
| 2010-10-08 11:30:00 | AAPL | Stock | 10.4773 | 10.5157 | 10.4725 | 10.4975 | 70833308.0 |
| 2010-10-08 12:00:00 | AAPL | Stock | 10.4971 | 10.5054 | 10.4546 | 10.4736 | 41681416.0 |
| 2010-10-08 12:30:00 | AAPL | Stock | 10.4732 | 10.5139 | 10.4643 | 10.4875 | 26455800.0 |
| 2010-10-08 13:00:00 | AAPL | Stock | 10.4889 | 10.5 | 10.4796 | 10.4929 | 21248164.0 |
| 2010-10-08 13:30:00 | AAPL | Stock | 10.4936 | 10.495 | 10.4643 | 10.4768 | 21542388.0 |
| 2010-10-08 14:00:00 | AAPL | Stock | 10.4775 | 10.4975 | 10.4564 | 10.4902 | 20670748.0 |
| 2010-10-08 14:30:00 | AAPL | Stock | 10.4902 | 10.5029 | 10.4821 | 10.4933 | 25408124.0 |
| 2010-10-08 15:00:00 | AAPL | Stock | 10.4921 | 10.5104 | 10.4886 | 10.5021 | 33732468.0 |
| 2010-10-08 15:30:00 | AAPL | Stock | 10.5014 | 10.5179 | 10.4921 | 10.5039 | 73930108.0 |
| 2010-10-08 16:00:00 | AAPL | Stock | 10.5043 | 10.5055 | 10.3293 | 10.5018 | 33185124.0 |
| 2010-10-08 16:30:00 | AAPL | Stock | 10.5021 | 10.5118 | 10.4858 | 10.5071 | 1239448.0 |
| 2010-10-08 17:00:00 | AAPL | Stock | 10.5075 | 10.5075 | 10.5025 | 10.5036 | 167748.0 |
| 2010-10-08 17:30:00 | AAPL | Stock | 10.5036 | 10.5071 | 10.5 | 10.5 | 396676.0 |
| 2010-10-08 18:00:00 | AAPL | Stock | 10.5 | 10.5025 | 10.4893 | 10.4943 | 677768.0 |
| 2010-10-08 18:30:00 | AAPL | Stock | 10.4925 | 10.4943 | 10.4893 | 10.4929 | 167216.0 |
| 2010-10-08 19:00:00 | AAPL | Stock | 10.4911 | 10.4936 | 10.4911 | 10.4936 | 86660.0 |
| 2010-10-08 19:30:00 | AAPL | Stock | 10.4946 | 10.4968 | 10.4893 | 10.4939 | 320152.0 |
| 2010-10-08 04:00:00 | MSFT | Stock | 24.52 | 24.52 | 24.52 | 24.52 | 1000.0 |
| 2010-10-08 07:00:00 | MSFT | Stock | 24.6 | 24.6 | 24.6 | 24.6 | 200.0 |
| 2010-10-08 08:00:00 | MSFT | Stock | 24.48 | 24.52 | 24.4 | 24.51 | 8432.0 |
| 2010-10-08 08:30:00 | MSFT | Stock | 24.5 | 24.57 | 24.4 | 24.47 | 10913.0 |
| 2010-10-08 09:00:00 | MSFT | Stock | 24.51 | 24.61 | 24.49 | 24.6 | 70400.0 |
| 2010-10-08 09:30:00 | MSFT | Stock | 24.6 | 24.65 | 24.47 | 24.545 | 4723569.0 |
| 2010-10-08 10:00:00 | MSFT | Stock | 24.54 | 24.55 | 24.37 | 24.39 | 2905657.0 |
| 2010-10-08 10:30:00 | MSFT | Stock | 24.399 | 24.45 | 24.38 | 24.44 | 1685372.0 |
| 2010-10-08 11:00:00 | MSFT | Stock | 24.45 | 24.6 | 24.44 | 24.58 | 3458868.0 |
| 2010-10-08 11:30:00 | MSFT | Stock | 24.588 | 24.64 | 24.585 | 24.6 | 2031900.0 |
| 2010-10-08 12:00:00 | MSFT | Stock | 24.6 | 24.621 | 24.53 | 24.53 | 1406832.0 |
| 2010-10-08 12:30:00 | MSFT | Stock | 24.53 | 24.65 | 24.52 | 24.601 | 2775864.0 |
| 2010-10-08 13:00:00 | MSFT | Stock | 24.602 | 24.62 | 24.56 | 24.575 | 898280.0 |
| 2010-10-08 13:30:00 | MSFT | Stock | 24.571 | 24.58 | 24.49 | 24.545 | 1432080.0 |
| 2010-10-08 14:00:00 | MSFT | Stock | 24.55 | 24.57 | 24.5 | 24.556 | 1402838.0 |
| 2010-10-08 14:30:00 | MSFT | Stock | 24.56 | 24.59 | 24.53 | 24.55 | 3086242.0 |
| 2010-10-08 15:00:00 | MSFT | Stock | 24.55 | 24.62 | 24.54 | 24.57 | 3388414.0 |
| 2010-10-08 15:30:00 | MSFT | Stock | 24.575 | 24.63 | 24.54 | 24.55 | 6362140.0 |
| 2010-10-08 16:00:00 | MSFT | Stock | 24.55 | 24.58 | 24.5 | 24.58 | 4750389.0 |
| 2010-10-08 16:30:00 | MSFT | Stock | 24.58 | 24.612 | 24.555 | 24.58 | 90884.0 |
| 2010-10-08 17:00:00 | MSFT | Stock | 24.58 | 24.58 | 24.58 | 24.58 | 17038.0 |
| 2010-10-08 17:30:00 | MSFT | Stock | 24.59 | 24.6 | 24.58 | 24.58 | 6629.0 |
| 2010-10-08 18:00:00 | MSFT | Stock | 24.57 | 24.57 | 24.57 | 24.57 | 600.0 |
> showing 50 of 74,077 rows — these rows as CSV