PREVIEW / stock_30min / 2011-12-29
file: by_date/stock_30min/2011/2011-12-29.parquet size: 1.4 MB rows: 74,006 symbols: 3,564
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-29 06:30:00 | AAPL | Stock | 14.3707 | 14.375 | 14.3696 | 14.375 | 35000.0 |
| 2011-12-29 07:00:00 | AAPL | Stock | 14.3821 | 14.4039 | 14.3821 | 14.4039 | 116592.0 |
| 2011-12-29 07:30:00 | AAPL | Stock | 14.4107 | 14.4346 | 14.4107 | 14.4282 | 81620.0 |
| 2011-12-29 08:00:00 | AAPL | Stock | 14.4125 | 14.4464 | 14.4125 | 14.4429 | 568988.0 |
| 2011-12-29 08:30:00 | AAPL | Stock | 14.4289 | 14.4289 | 14.3943 | 14.4175 | 317016.0 |
| 2011-12-29 09:00:00 | AAPL | Stock | 14.4111 | 14.4214 | 14.4054 | 14.4071 | 637980.0 |
| 2011-12-29 09:30:00 | AAPL | Stock | 14.4071 | 14.4393 | 14.3471 | 14.3607 | 31772440.0 |
| 2011-12-29 10:00:00 | AAPL | Stock | 14.3646 | 14.3961 | 14.3039 | 14.3849 | 31538024.0 |
| 2011-12-29 10:30:00 | AAPL | Stock | 14.3823 | 14.3993 | 14.3643 | 14.3904 | 13549732.0 |
| 2011-12-29 11:00:00 | AAPL | Stock | 14.39 | 14.4071 | 14.3807 | 14.4004 | 11691372.0 |
| 2011-12-29 11:30:00 | AAPL | Stock | 14.4004 | 14.4529 | 14.3957 | 14.4446 | 15468656.0 |
| 2011-12-29 12:00:00 | AAPL | Stock | 14.4446 | 14.4496 | 14.4297 | 14.4407 | 7976192.0 |
| 2011-12-29 12:30:00 | AAPL | Stock | 14.4396 | 14.4589 | 14.4304 | 14.4557 | 6854232.0 |
| 2011-12-29 13:00:00 | AAPL | Stock | 14.4554 | 14.4643 | 14.4404 | 14.4461 | 11872308.0 |
| 2011-12-29 13:30:00 | AAPL | Stock | 14.445 | 14.4643 | 14.4429 | 14.4604 | 7114884.0 |
| 2011-12-29 14:00:00 | AAPL | Stock | 14.4604 | 14.4746 | 14.4518 | 14.4593 | 9580144.0 |
| 2011-12-29 14:30:00 | AAPL | Stock | 14.4589 | 14.4646 | 14.4404 | 14.4593 | 7025956.0 |
| 2011-12-29 15:00:00 | AAPL | Stock | 14.4589 | 14.4875 | 14.4579 | 14.4658 | 12831504.0 |
| 2011-12-29 15:30:00 | AAPL | Stock | 14.4679 | 14.4811 | 14.4554 | 14.4679 | 27670384.0 |
| 2011-12-29 16:00:00 | AAPL | Stock | 14.4629 | 14.4707 | 14.3571 | 14.42 | 6252204.0 |
| 2011-12-29 16:30:00 | AAPL | Stock | 14.465 | 14.4679 | 14.4646 | 14.4679 | 186900.0 |
| 2011-12-29 17:00:00 | AAPL | Stock | 14.4654 | 14.4679 | 14.4643 | 14.4657 | 68992.0 |
| 2011-12-29 17:30:00 | AAPL | Stock | 14.465 | 14.47 | 14.465 | 14.47 | 68516.0 |
| 2011-12-29 18:00:00 | AAPL | Stock | 14.4668 | 14.4707 | 14.4664 | 14.4679 | 203392.0 |
| 2011-12-29 18:30:00 | AAPL | Stock | 14.4671 | 14.4671 | 14.4664 | 14.4664 | 33600.0 |
| 2011-12-29 19:00:00 | AAPL | Stock | 14.4675 | 14.4679 | 14.4664 | 14.4664 | 33040.0 |
| 2011-12-29 19:30:00 | AAPL | Stock | 14.465 | 14.4661 | 14.4629 | 14.4643 | 147728.0 |
| 2011-12-29 07:00:00 | MSFT | Stock | 25.85 | 25.85 | 25.85 | 25.85 | 200.0 |
| 2011-12-29 08:00:00 | MSFT | Stock | 25.9 | 25.9 | 25.85 | 25.85 | 10240.0 |
| 2011-12-29 08:30:00 | MSFT | Stock | 25.85 | 25.86 | 25.85 | 25.86 | 1800.0 |
| 2011-12-29 09:00:00 | MSFT | Stock | 25.9 | 25.96 | 25.89 | 25.94 | 68919.0 |
| 2011-12-29 09:30:00 | MSFT | Stock | 25.95 | 26.03 | 25.89 | 25.9 | 2641611.0 |
| 2011-12-29 10:00:00 | MSFT | Stock | 25.9 | 25.99 | 25.89 | 25.94 | 2230849.0 |
| 2011-12-29 10:30:00 | MSFT | Stock | 25.94 | 26.01 | 25.94 | 25.96 | 1934587.0 |
| 2011-12-29 11:00:00 | MSFT | Stock | 25.96 | 25.96 | 25.86 | 25.91 | 1240492.0 |
| 2011-12-29 11:30:00 | MSFT | Stock | 25.91 | 25.985 | 25.91 | 25.98 | 832941.0 |
| 2011-12-29 12:00:00 | MSFT | Stock | 25.99 | 26.0 | 25.96 | 25.985 | 738394.0 |
| 2011-12-29 12:30:00 | MSFT | Stock | 25.99 | 26.0 | 25.98 | 25.996 | 632338.0 |
| 2011-12-29 13:00:00 | MSFT | Stock | 25.995 | 26.05 | 25.99 | 26.0 | 1323528.0 |
| 2011-12-29 13:30:00 | MSFT | Stock | 25.995 | 26.03 | 25.96 | 25.982 | 842949.0 |
| 2011-12-29 14:00:00 | MSFT | Stock | 25.98 | 26.0 | 25.96 | 25.965 | 675974.0 |
| 2011-12-29 14:30:00 | MSFT | Stock | 25.97 | 25.98 | 25.95 | 25.96 | 735040.0 |
| 2011-12-29 15:00:00 | MSFT | Stock | 25.96 | 26.05 | 25.96 | 26.03 | 2221025.0 |
| 2011-12-29 15:30:00 | MSFT | Stock | 26.02 | 26.03 | 25.97 | 26.01 | 4425113.0 |
| 2011-12-29 16:00:00 | MSFT | Stock | 26.01 | 26.03 | 25.979 | 25.982 | 1802620.0 |
| 2011-12-29 16:30:00 | MSFT | Stock | 25.98 | 25.98 | 25.97 | 25.97 | 2124.0 |
| 2011-12-29 17:00:00 | MSFT | Stock | 25.82 | 26.0 | 25.82 | 25.98 | 1368.0 |
| 2011-12-29 17:30:00 | MSFT | Stock | 25.99 | 25.99 | 25.99 | 25.99 | 200.0 |
| 2011-12-29 18:00:00 | MSFT | Stock | 26.02 | 26.02 | 26.0 | 26.0 | 23174.0 |
| 2011-12-29 18:30:00 | MSFT | Stock | 26.02 | 26.02 | 26.02 | 26.02 | 2000.0 |
> showing 50 of 74,006 rows — these rows as CSV