PREVIEW / stock_30min / 2009-08-06
file: by_date/stock_30min/2009/2009-08-06.parquet size: 1.3 MB rows: 71,564 symbols: 3,341
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-06 06:30:00 | AAPL | Stock | 5.8693 | 5.8693 | 5.8693 | 5.8693 | 19656.0 |
| 2009-08-06 07:00:00 | AAPL | Stock | 5.8696 | 5.8821 | 5.8693 | 5.8821 | 14028.0 |
| 2009-08-06 07:30:00 | AAPL | Stock | 5.8821 | 5.8857 | 5.8793 | 5.8857 | 60200.0 |
| 2009-08-06 08:00:00 | AAPL | Stock | 5.8968 | 5.8968 | 5.8696 | 5.8929 | 352716.0 |
| 2009-08-06 08:30:00 | AAPL | Stock | 5.8886 | 5.9196 | 5.8886 | 5.9161 | 817824.0 |
| 2009-08-06 09:00:00 | AAPL | Stock | 5.9157 | 5.9218 | 5.9021 | 5.9125 | 1418956.0 |
| 2009-08-06 09:30:00 | AAPL | Stock | 5.9136 | 5.9468 | 5.8839 | 5.8954 | 60772208.0 |
| 2009-08-06 10:00:00 | AAPL | Stock | 5.8957 | 5.9018 | 5.8668 | 5.8725 | 34030640.0 |
| 2009-08-06 10:30:00 | AAPL | Stock | 5.8721 | 5.8882 | 5.8543 | 5.8604 | 24667160.0 |
| 2009-08-06 11:00:00 | AAPL | Stock | 5.8603 | 5.8914 | 5.8596 | 5.8821 | 20687184.0 |
| 2009-08-06 11:30:00 | AAPL | Stock | 5.8821 | 5.8839 | 5.8696 | 5.8725 | 11592504.0 |
| 2009-08-06 12:00:00 | AAPL | Stock | 5.8729 | 5.8743 | 5.8571 | 5.865 | 14668640.0 |
| 2009-08-06 12:30:00 | AAPL | Stock | 5.865 | 5.8804 | 5.8618 | 5.8657 | 12129348.0 |
| 2009-08-06 13:00:00 | AAPL | Stock | 5.8668 | 5.8871 | 5.8596 | 5.8811 | 12229224.0 |
| 2009-08-06 13:30:00 | AAPL | Stock | 5.8821 | 5.8911 | 5.8571 | 5.8679 | 16572248.0 |
| 2009-08-06 14:00:00 | AAPL | Stock | 5.8675 | 5.87 | 5.8507 | 5.8657 | 26791744.0 |
| 2009-08-06 14:30:00 | AAPL | Stock | 5.8664 | 5.8668 | 5.8486 | 5.8596 | 17426388.0 |
| 2009-08-06 15:00:00 | AAPL | Stock | 5.8589 | 5.8746 | 5.8514 | 5.87 | 21352632.0 |
| 2009-08-06 15:30:00 | AAPL | Stock | 5.87 | 5.8714 | 5.8246 | 5.8539 | 42754628.0 |
| 2009-08-06 16:00:00 | AAPL | Stock | 5.8539 | 5.8782 | 5.8511 | 5.8636 | 11025952.0 |
| 2009-08-06 16:30:00 | AAPL | Stock | 5.8564 | 5.86 | 5.8564 | 5.8571 | 61544.0 |
| 2009-08-06 17:00:00 | AAPL | Stock | 5.8546 | 5.8568 | 5.8536 | 5.8539 | 360248.0 |
| 2009-08-06 17:30:00 | AAPL | Stock | 5.8564 | 5.8571 | 5.8536 | 5.8539 | 54600.0 |
| 2009-08-06 18:00:00 | AAPL | Stock | 5.8539 | 5.8571 | 5.8539 | 5.8543 | 226828.0 |
| 2009-08-06 18:30:00 | AAPL | Stock | 5.8543 | 5.8571 | 5.8543 | 5.8543 | 16800.0 |
| 2009-08-06 19:00:00 | AAPL | Stock | 5.8564 | 5.8571 | 5.8539 | 5.8571 | 73416.0 |
| 2009-08-06 19:30:00 | AAPL | Stock | 5.8568 | 5.8568 | 5.8539 | 5.8554 | 54740.0 |
| 2009-08-06 08:00:00 | MSFT | Stock | 23.81 | 23.97 | 23.81 | 23.93 | 103848.0 |
| 2009-08-06 08:30:00 | MSFT | Stock | 23.95 | 23.97 | 23.93 | 23.95 | 22295.0 |
| 2009-08-06 09:00:00 | MSFT | Stock | 23.93 | 23.96 | 23.91 | 23.94 | 51352.0 |
| 2009-08-06 09:30:00 | MSFT | Stock | 23.93 | 23.98 | 23.66 | 23.67 | 5548671.0 |
| 2009-08-06 10:00:00 | MSFT | Stock | 23.67 | 23.77 | 23.66 | 23.71 | 5298101.0 |
| 2009-08-06 10:30:00 | MSFT | Stock | 23.695 | 23.75 | 23.64 | 23.68 | 3577511.0 |
| 2009-08-06 11:00:00 | MSFT | Stock | 23.672 | 23.76 | 23.67 | 23.68 | 2052479.0 |
| 2009-08-06 11:30:00 | MSFT | Stock | 23.68 | 23.69 | 23.62 | 23.62 | 3044881.0 |
| 2009-08-06 12:00:00 | MSFT | Stock | 23.621 | 23.64 | 23.55 | 23.56 | 2586031.0 |
| 2009-08-06 12:30:00 | MSFT | Stock | 23.56 | 23.66 | 23.52 | 23.6 | 3812994.0 |
| 2009-08-06 13:00:00 | MSFT | Stock | 23.6 | 23.63 | 23.53 | 23.53 | 3643042.0 |
| 2009-08-06 13:30:00 | MSFT | Stock | 23.539 | 23.6 | 23.48 | 23.49 | 2766616.0 |
| 2009-08-06 14:00:00 | MSFT | Stock | 23.48 | 23.49 | 23.38 | 23.39 | 4924957.0 |
| 2009-08-06 14:30:00 | MSFT | Stock | 23.39 | 23.41 | 23.27 | 23.37 | 4923957.0 |
| 2009-08-06 15:00:00 | MSFT | Stock | 23.37 | 23.49 | 23.33 | 23.48 | 4002776.0 |
| 2009-08-06 15:30:00 | MSFT | Stock | 23.47 | 23.55 | 23.4 | 23.45 | 9463939.0 |
| 2009-08-06 16:00:00 | MSFT | Stock | 23.45 | 23.74 | 23.43 | 23.46 | 2786506.0 |
| 2009-08-06 16:30:00 | MSFT | Stock | 23.44 | 23.44 | 23.39 | 23.42 | 69268.0 |
| 2009-08-06 17:00:00 | MSFT | Stock | 23.42 | 23.46 | 23.42 | 23.46 | 23967.0 |
| 2009-08-06 17:30:00 | MSFT | Stock | 23.41 | 23.45 | 23.41 | 23.45 | 5261.0 |
| 2009-08-06 18:00:00 | MSFT | Stock | 23.46 | 23.46 | 23.4 | 23.4 | 1600.0 |
| 2009-08-06 18:30:00 | MSFT | Stock | 23.4 | 23.4 | 23.4 | 23.4 | 1085.0 |
| 2009-08-06 19:00:00 | MSFT | Stock | 23.43 | 23.44 | 23.43 | 23.43 | 1500.0 |
> showing 50 of 71,564 rows — these rows as CSV