PREVIEW / stock_30min / 2008-10-15
file: by_date/stock_30min/2008/2008-10-15.parquet size: 1.3 MB rows: 71,855 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-10-15 05:00:00 | AAPL | Stock | 3.7393 | 3.7904 | 3.7393 | 3.7904 | 22596.0 |
| 2008-10-15 05:30:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 2800.0 |
| 2008-10-15 06:00:00 | AAPL | Stock | 3.8018 | 3.8018 | 3.8018 | 3.8018 | 2800.0 |
| 2008-10-15 06:30:00 | AAPL | Stock | 3.7929 | 3.7929 | 3.7929 | 3.7929 | 14000.0 |
| 2008-10-15 07:00:00 | AAPL | Stock | 3.7929 | 3.8014 | 3.7679 | 3.7961 | 127400.0 |
| 2008-10-15 07:30:00 | AAPL | Stock | 3.7929 | 3.7946 | 3.7732 | 3.7768 | 459200.0 |
| 2008-10-15 08:00:00 | AAPL | Stock | 3.7732 | 3.7979 | 3.7386 | 3.7439 | 2347968.0 |
| 2008-10-15 08:30:00 | AAPL | Stock | 3.7461 | 3.7482 | 3.6521 | 3.6964 | 4336500.0 |
| 2008-10-15 09:00:00 | AAPL | Stock | 3.6964 | 3.7361 | 3.6961 | 3.7086 | 3346140.0 |
| 2008-10-15 09:30:00 | AAPL | Stock | 3.7082 | 3.8039 | 3.6557 | 3.7929 | 205479736.0 |
| 2008-10-15 10:00:00 | AAPL | Stock | 3.7914 | 3.8214 | 3.7411 | 3.7725 | 139634516.0 |
| 2008-10-15 10:30:00 | AAPL | Stock | 3.7725 | 3.8036 | 3.7032 | 3.7207 | 117524904.0 |
| 2008-10-15 11:00:00 | AAPL | Stock | 3.7207 | 3.75 | 3.7089 | 3.7286 | 69329176.0 |
| 2008-10-15 11:30:00 | AAPL | Stock | 3.7286 | 3.7679 | 3.72 | 3.7418 | 67048156.0 |
| 2008-10-15 12:00:00 | AAPL | Stock | 3.7418 | 3.7679 | 3.6786 | 3.7014 | 83330604.0 |
| 2008-10-15 12:30:00 | AAPL | Stock | 3.7014 | 3.7268 | 3.6989 | 3.7027 | 63919996.0 |
| 2008-10-15 13:00:00 | AAPL | Stock | 3.7025 | 3.7061 | 3.6607 | 3.6725 | 74563832.0 |
| 2008-10-15 13:30:00 | AAPL | Stock | 3.6736 | 3.6771 | 3.5757 | 3.59 | 114901360.0 |
| 2008-10-15 14:00:00 | AAPL | Stock | 3.5911 | 3.625 | 3.5536 | 3.6179 | 133978684.0 |
| 2008-10-15 14:30:00 | AAPL | Stock | 3.6182 | 3.6884 | 3.6004 | 3.6321 | 135947532.0 |
| 2008-10-15 15:00:00 | AAPL | Stock | 3.6321 | 3.6704 | 3.5911 | 3.6107 | 128495388.0 |
| 2008-10-15 15:30:00 | AAPL | Stock | 3.61 | 3.6196 | 3.4961 | 3.4982 | 163645076.0 |
| 2008-10-15 16:00:00 | AAPL | Stock | 3.4982 | 3.6775 | 3.4964 | 3.5143 | 37990568.0 |
| 2008-10-15 16:30:00 | AAPL | Stock | 3.5 | 3.7171 | 3.5 | 3.5 | 11738972.0 |
| 2008-10-15 17:00:00 | AAPL | Stock | 3.5036 | 3.5036 | 3.4696 | 3.4818 | 674576.0 |
| 2008-10-15 17:30:00 | AAPL | Stock | 3.4811 | 3.4811 | 3.4561 | 3.4646 | 451052.0 |
| 2008-10-15 18:00:00 | AAPL | Stock | 3.4629 | 3.4704 | 3.4286 | 3.4357 | 892948.0 |
| 2008-10-15 18:30:00 | AAPL | Stock | 3.4368 | 3.4554 | 3.4339 | 3.4536 | 277508.0 |
| 2008-10-15 19:00:00 | AAPL | Stock | 3.4486 | 3.4554 | 3.4464 | 3.4554 | 180712.0 |
| 2008-10-15 19:30:00 | AAPL | Stock | 3.4482 | 3.455 | 3.4379 | 3.4379 | 357644.0 |
| 2008-10-15 07:00:00 | MSFT | Stock | 24.1 | 24.1 | 24.1 | 24.1 | 350.0 |
| 2008-10-15 07:30:00 | MSFT | Stock | 24.14 | 24.14 | 24.11 | 24.12 | 600.0 |
| 2008-10-15 08:00:00 | MSFT | Stock | 24.01 | 24.02 | 23.81 | 23.99 | 5609.0 |
| 2008-10-15 08:30:00 | MSFT | Stock | 23.89 | 23.89 | 23.67 | 23.67 | 52723.0 |
| 2008-10-15 09:00:00 | MSFT | Stock | 23.67 | 23.8 | 23.67 | 23.77 | 70867.0 |
| 2008-10-15 09:30:00 | MSFT | Stock | 23.77 | 23.9 | 23.41 | 23.75 | 10171406.0 |
| 2008-10-15 10:00:00 | MSFT | Stock | 23.75 | 24.08 | 23.618 | 24.015 | 9515240.0 |
| 2008-10-15 10:30:00 | MSFT | Stock | 24.01 | 24.25 | 23.65 | 23.68 | 9585070.0 |
| 2008-10-15 11:00:00 | MSFT | Stock | 23.68 | 23.78 | 23.51 | 23.58 | 5144283.0 |
| 2008-10-15 11:30:00 | MSFT | Stock | 23.59 | 23.71 | 23.54 | 23.6 | 4384529.0 |
| 2008-10-15 12:00:00 | MSFT | Stock | 23.608 | 23.72 | 23.38 | 23.49 | 5707749.0 |
| 2008-10-15 12:30:00 | MSFT | Stock | 23.5 | 23.74 | 23.49 | 23.59 | 4681041.0 |
| 2008-10-15 13:00:00 | MSFT | Stock | 23.595 | 23.6 | 23.22 | 23.29 | 4545044.0 |
| 2008-10-15 13:30:00 | MSFT | Stock | 23.29 | 23.36 | 23.11 | 23.19 | 6845697.0 |
| 2008-10-15 14:00:00 | MSFT | Stock | 23.2 | 23.3 | 23.0 | 23.25 | 7903198.0 |
| 2008-10-15 14:30:00 | MSFT | Stock | 23.26 | 23.7 | 23.05 | 23.26 | 6567071.0 |
| 2008-10-15 15:00:00 | MSFT | Stock | 23.26 | 23.57 | 23.09 | 23.25 | 8785263.0 |
| 2008-10-15 15:30:00 | MSFT | Stock | 23.26 | 23.29 | 22.48 | 22.63 | 17657748.0 |
| 2008-10-15 16:00:00 | MSFT | Stock | 22.63 | 23.62 | 22.49 | 22.66 | 8709240.0 |
| 2008-10-15 16:30:00 | MSFT | Stock | 22.66 | 24.1 | 22.6 | 22.74 | 843319.0 |
> showing 50 of 71,855 rows — these rows as CSV