PREVIEW / stock_30min / 2006-10-13
file: by_date/stock_30min/2006/2006-10-13.parquet size: 926 KB rows: 50,573 symbols: 2,392
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-13 07:30:00 | AAPL | Stock | 2.6843 | 2.6914 | 2.6843 | 2.6896 | 40040.0 |
| 2006-10-13 08:00:00 | AAPL | Stock | 2.6914 | 2.7025 | 2.6864 | 2.7 | 1253784.0 |
| 2006-10-13 08:30:00 | AAPL | Stock | 2.6982 | 2.7011 | 2.6925 | 2.7 | 1333080.0 |
| 2006-10-13 09:00:00 | AAPL | Stock | 2.6982 | 2.7036 | 2.6932 | 2.6979 | 2176048.0 |
| 2006-10-13 09:30:00 | AAPL | Stock | 2.7011 | 2.7232 | 2.6996 | 2.7211 | 103739636.0 |
| 2006-10-13 10:00:00 | AAPL | Stock | 2.7204 | 2.7457 | 2.7204 | 2.7329 | 87325112.0 |
| 2006-10-13 10:30:00 | AAPL | Stock | 2.7327 | 2.7411 | 2.7225 | 2.7282 | 55679848.0 |
| 2006-10-13 11:00:00 | AAPL | Stock | 2.73 | 2.73 | 2.7064 | 2.7139 | 54189408.0 |
| 2006-10-13 11:30:00 | AAPL | Stock | 2.7136 | 2.7186 | 2.7089 | 2.7114 | 27486788.0 |
| 2006-10-13 12:00:00 | AAPL | Stock | 2.7111 | 2.7143 | 2.7032 | 2.7061 | 28433496.0 |
| 2006-10-13 12:30:00 | AAPL | Stock | 2.7057 | 2.7096 | 2.7004 | 2.705 | 26732580.0 |
| 2006-10-13 13:00:00 | AAPL | Stock | 2.7046 | 2.7071 | 2.6964 | 2.7021 | 35641200.0 |
| 2006-10-13 13:30:00 | AAPL | Stock | 2.7018 | 2.7071 | 2.6804 | 2.6854 | 59095736.0 |
| 2006-10-13 14:00:00 | AAPL | Stock | 2.6854 | 2.69 | 2.6786 | 2.6821 | 41899228.0 |
| 2006-10-13 14:30:00 | AAPL | Stock | 2.6811 | 2.6836 | 2.6693 | 2.6707 | 52443104.0 |
| 2006-10-13 15:00:00 | AAPL | Stock | 2.6704 | 2.6846 | 2.6696 | 2.6814 | 41237952.0 |
| 2006-10-13 15:30:00 | AAPL | Stock | 2.6814 | 2.6854 | 2.6746 | 2.6786 | 51179492.0 |
| 2006-10-13 16:00:00 | AAPL | Stock | 2.6786 | 2.6821 | 2.6714 | 2.6743 | 2725884.0 |
| 2006-10-13 16:30:00 | AAPL | Stock | 2.6743 | 2.6821 | 2.6739 | 2.6739 | 389200.0 |
| 2006-10-13 17:00:00 | AAPL | Stock | 2.675 | 2.6821 | 2.6718 | 2.675 | 393792.0 |
| 2006-10-13 17:30:00 | AAPL | Stock | 2.675 | 2.6761 | 2.6714 | 2.6739 | 122556.0 |
| 2006-10-13 18:00:00 | AAPL | Stock | 2.6768 | 2.6768 | 2.6739 | 2.6746 | 38920.0 |
| 2006-10-13 05:30:00 | MSFT | Stock | 28.16 | 28.16 | 28.16 | 28.16 | 100.0 |
| 2006-10-13 06:30:00 | MSFT | Stock | 28.2 | 28.2 | 28.2 | 28.2 | 700.0 |
| 2006-10-13 07:00:00 | MSFT | Stock | 28.14 | 28.22 | 28.14 | 28.22 | 6333.0 |
| 2006-10-13 07:30:00 | MSFT | Stock | 28.2 | 28.33 | 28.2 | 28.33 | 17000.0 |
| 2006-10-13 08:00:00 | MSFT | Stock | 28.35 | 28.4 | 28.29 | 28.36 | 82458.0 |
| 2006-10-13 08:30:00 | MSFT | Stock | 28.36 | 28.38 | 27.91 | 28.33 | 118562.0 |
| 2006-10-13 09:00:00 | MSFT | Stock | 28.35 | 28.4 | 28.29 | 28.35 | 754874.0 |
| 2006-10-13 09:30:00 | MSFT | Stock | 28.34 | 28.5 | 28.34 | 28.46 | 17739318.0 |
| 2006-10-13 10:00:00 | MSFT | Stock | 28.45 | 28.6 | 28.45 | 28.56 | 16473240.0 |
| 2006-10-13 10:30:00 | MSFT | Stock | 28.561 | 28.69 | 28.47 | 28.64 | 20956413.0 |
| 2006-10-13 11:00:00 | MSFT | Stock | 28.65 | 28.67 | 28.56 | 28.57 | 9587409.0 |
| 2006-10-13 11:30:00 | MSFT | Stock | 28.57 | 28.62 | 28.53 | 28.61 | 8946545.0 |
| 2006-10-13 12:00:00 | MSFT | Stock | 28.61 | 28.62 | 28.57 | 28.59 | 6322906.0 |
| 2006-10-13 12:30:00 | MSFT | Stock | 28.59 | 28.64 | 28.57 | 28.62 | 4520426.0 |
| 2006-10-13 13:00:00 | MSFT | Stock | 28.62 | 28.66 | 28.58 | 28.6 | 13063139.0 |
| 2006-10-13 13:30:00 | MSFT | Stock | 28.59 | 28.6 | 28.56 | 28.58 | 3714259.0 |
| 2006-10-13 14:00:00 | MSFT | Stock | 28.57 | 28.59 | 28.41 | 28.44 | 6937926.0 |
| 2006-10-13 14:30:00 | MSFT | Stock | 28.437 | 28.51 | 28.4 | 28.42 | 5329790.0 |
| 2006-10-13 15:00:00 | MSFT | Stock | 28.42 | 28.47 | 28.35 | 28.411 | 3599868.0 |
| 2006-10-13 15:30:00 | MSFT | Stock | 28.41 | 28.42 | 28.31 | 28.38 | 8538242.0 |
| 2006-10-13 16:00:00 | MSFT | Stock | 28.37 | 28.38 | 28.34 | 28.37 | 130741.0 |
| 2006-10-13 16:30:00 | MSFT | Stock | 28.38 | 28.38 | 28.36 | 28.36 | 26135.0 |
| 2006-10-13 17:00:00 | MSFT | Stock | 28.38 | 28.38 | 28.36 | 28.38 | 7360.0 |
| 2006-10-13 17:30:00 | MSFT | Stock | 28.38 | 28.38 | 28.37 | 28.37 | 5686.0 |
| 2006-10-13 18:00:00 | MSFT | Stock | 28.37 | 28.37 | 28.37 | 28.37 | 2150.0 |
| 2006-10-13 19:30:00 | MSFT | Stock | 28.39 | 28.39 | 28.39 | 28.39 | 100.0 |
| 2006-10-13 08:00:00 | NVDA | Stock | 0.5408 | 0.5408 | 0.5408 | 0.5408 | 6000.0 |
| 2006-10-13 08:30:00 | NVDA | Stock | 0.5408 | 0.542 | 0.54 | 0.5408 | 696000.0 |
> showing 50 of 50,573 rows — these rows as CSV