PREVIEW / stock_30min / 2008-02-12
file: by_date/stock_30min/2008/2008-02-12.parquet size: 1.2 MB rows: 69,618 symbols: 3,284
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-02-12 05:00:00 | AAPL | Stock | 4.6418 | 4.6418 | 4.6418 | 4.6418 | 2800.0 |
| 2008-02-12 05:30:00 | AAPL | Stock | 4.6418 | 4.6429 | 4.6418 | 4.6429 | 8400.0 |
| 2008-02-12 06:00:00 | AAPL | Stock | 4.6439 | 4.6729 | 4.6439 | 4.6529 | 63560.0 |
| 2008-02-12 06:30:00 | AAPL | Stock | 4.6539 | 4.6782 | 4.6539 | 4.6714 | 56000.0 |
| 2008-02-12 07:00:00 | AAPL | Stock | 4.6643 | 4.6786 | 4.6643 | 4.6714 | 225820.0 |
| 2008-02-12 07:30:00 | AAPL | Stock | 4.6511 | 4.6679 | 4.6482 | 4.6589 | 222460.0 |
| 2008-02-12 08:00:00 | AAPL | Stock | 4.6529 | 4.675 | 4.6429 | 4.6729 | 4281676.0 |
| 2008-02-12 08:30:00 | AAPL | Stock | 4.6736 | 4.6754 | 4.6643 | 4.6704 | 1402352.0 |
| 2008-02-12 09:00:00 | AAPL | Stock | 4.6704 | 4.675 | 4.6525 | 4.6679 | 4028164.0 |
| 2008-02-12 09:30:00 | AAPL | Stock | 4.6682 | 4.6786 | 4.6071 | 4.6071 | 172840612.0 |
| 2008-02-12 10:00:00 | AAPL | Stock | 4.6071 | 4.6332 | 4.5811 | 4.6118 | 156284744.0 |
| 2008-02-12 10:30:00 | AAPL | Stock | 4.6125 | 4.6525 | 4.6004 | 4.6519 | 96345004.0 |
| 2008-02-12 11:00:00 | AAPL | Stock | 4.6518 | 4.6529 | 4.6171 | 4.6207 | 54440540.0 |
| 2008-02-12 11:30:00 | AAPL | Stock | 4.6207 | 4.6279 | 4.5968 | 4.5989 | 47262040.0 |
| 2008-02-12 12:00:00 | AAPL | Stock | 4.5989 | 4.6043 | 4.5539 | 4.5671 | 60441108.0 |
| 2008-02-12 12:30:00 | AAPL | Stock | 4.5671 | 4.5675 | 4.5364 | 4.5611 | 67747624.0 |
| 2008-02-12 13:00:00 | AAPL | Stock | 4.5611 | 4.5625 | 4.5257 | 4.5496 | 57799728.0 |
| 2008-02-12 13:30:00 | AAPL | Stock | 4.5493 | 4.5496 | 4.5089 | 4.544 | 56614012.0 |
| 2008-02-12 14:00:00 | AAPL | Stock | 4.5439 | 4.5443 | 4.5086 | 4.5168 | 46455948.0 |
| 2008-02-12 14:30:00 | AAPL | Stock | 4.5178 | 4.5214 | 4.4857 | 4.5182 | 78621452.0 |
| 2008-02-12 15:00:00 | AAPL | Stock | 4.5186 | 4.5193 | 4.4571 | 4.4639 | 107281608.0 |
| 2008-02-12 15:30:00 | AAPL | Stock | 4.4629 | 4.4696 | 4.415 | 4.46 | 194995864.0 |
| 2008-02-12 16:00:00 | AAPL | Stock | 4.4611 | 4.5569 | 4.4536 | 4.4571 | 15579144.0 |
| 2008-02-12 16:30:00 | AAPL | Stock | 4.4575 | 4.4707 | 4.4575 | 4.4707 | 1521800.0 |
| 2008-02-12 17:00:00 | AAPL | Stock | 4.4714 | 4.475 | 4.4643 | 4.4714 | 304360.0 |
| 2008-02-12 17:30:00 | AAPL | Stock | 4.6061 | 4.6061 | 4.4661 | 4.4664 | 199500.0 |
| 2008-02-12 18:00:00 | AAPL | Stock | 4.4732 | 4.4732 | 4.4679 | 4.4714 | 63168.0 |
| 2008-02-12 18:30:00 | AAPL | Stock | 4.4714 | 4.4721 | 4.4679 | 4.4714 | 60200.0 |
| 2008-02-12 19:00:00 | AAPL | Stock | 4.4714 | 4.4714 | 4.4611 | 4.4611 | 447776.0 |
| 2008-02-12 19:30:00 | AAPL | Stock | 4.4632 | 4.4632 | 4.4554 | 4.4557 | 394940.0 |
| 2008-02-12 06:00:00 | MSFT | Stock | 28.23 | 28.23 | 28.23 | 28.23 | 200.0 |
| 2008-02-12 07:00:00 | MSFT | Stock | 28.3 | 28.45 | 28.3 | 28.39 | 2200.0 |
| 2008-02-12 07:30:00 | MSFT | Stock | 28.35 | 28.35 | 28.28 | 28.28 | 27120.0 |
| 2008-02-12 08:00:00 | MSFT | Stock | 28.3 | 28.44 | 28.3 | 28.38 | 57006.0 |
| 2008-02-12 08:30:00 | MSFT | Stock | 28.38 | 28.4 | 28.32 | 28.4 | 36355.0 |
| 2008-02-12 09:00:00 | MSFT | Stock | 28.4 | 28.43 | 28.35 | 28.4 | 488852.0 |
| 2008-02-12 09:30:00 | MSFT | Stock | 28.4 | 28.62 | 28.319 | 28.41 | 14164283.0 |
| 2008-02-12 10:00:00 | MSFT | Stock | 28.41 | 28.604 | 28.4 | 28.48 | 6416323.0 |
| 2008-02-12 10:30:00 | MSFT | Stock | 28.49 | 28.53 | 28.41 | 28.5 | 5513459.0 |
| 2008-02-12 11:00:00 | MSFT | Stock | 28.5 | 28.5 | 28.35 | 28.36 | 4808526.0 |
| 2008-02-12 11:30:00 | MSFT | Stock | 28.37 | 28.4 | 28.26 | 28.27 | 3779018.0 |
| 2008-02-12 12:00:00 | MSFT | Stock | 28.28 | 28.33 | 28.17 | 28.18 | 3830134.0 |
| 2008-02-12 12:30:00 | MSFT | Stock | 28.17 | 28.22 | 28.11 | 28.22 | 4487270.0 |
| 2008-02-12 13:00:00 | MSFT | Stock | 28.23 | 28.325 | 28.22 | 28.29 | 4304340.0 |
| 2008-02-12 13:30:00 | MSFT | Stock | 28.28 | 28.38 | 28.28 | 28.36 | 3172816.0 |
| 2008-02-12 14:00:00 | MSFT | Stock | 28.35 | 28.38 | 28.28 | 28.35 | 3276549.0 |
| 2008-02-12 14:30:00 | MSFT | Stock | 28.347 | 28.41 | 28.28 | 28.4 | 5602008.0 |
| 2008-02-12 15:00:00 | MSFT | Stock | 28.41 | 28.41 | 28.21 | 28.28 | 8785878.0 |
| 2008-02-12 15:30:00 | MSFT | Stock | 28.278 | 28.34 | 28.14 | 28.34 | 11959624.0 |
| 2008-02-12 16:00:00 | MSFT | Stock | 28.33 | 28.425 | 28.28 | 28.34 | 3444740.0 |
> showing 50 of 69,618 rows — these rows as CSV