PREVIEW / stock_30min / 2009-07-21
file: by_date/stock_30min/2009/2009-07-21.parquet size: 1.3 MB rows: 70,069 symbols: 3,331
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-07-21 04:00:00 | AAPL | Stock | 5.5175 | 5.5175 | 5.5175 | 5.5175 | 8400.0 |
| 2009-07-21 05:30:00 | AAPL | Stock | 5.5175 | 5.5175 | 5.5175 | 5.5175 | 33600.0 |
| 2009-07-21 06:00:00 | AAPL | Stock | 5.495 | 5.495 | 5.495 | 5.495 | 14000.0 |
| 2009-07-21 07:00:00 | AAPL | Stock | 5.4843 | 5.4911 | 5.4821 | 5.4911 | 74984.0 |
| 2009-07-21 07:30:00 | AAPL | Stock | 5.4911 | 5.5207 | 5.4911 | 5.5171 | 555520.0 |
| 2009-07-21 08:00:00 | AAPL | Stock | 5.5193 | 5.5286 | 5.485 | 5.5021 | 1903076.0 |
| 2009-07-21 08:30:00 | AAPL | Stock | 5.5021 | 5.5021 | 5.4857 | 5.4918 | 826868.0 |
| 2009-07-21 09:00:00 | AAPL | Stock | 5.4929 | 5.4954 | 5.4561 | 5.4743 | 3725512.0 |
| 2009-07-21 09:30:00 | AAPL | Stock | 5.4743 | 5.4796 | 5.4157 | 5.4285 | 105001008.0 |
| 2009-07-21 10:00:00 | AAPL | Stock | 5.4282 | 5.4411 | 5.4075 | 5.4311 | 50661632.0 |
| 2009-07-21 10:30:00 | AAPL | Stock | 5.4314 | 5.4396 | 5.4096 | 5.4125 | 45291064.0 |
| 2009-07-21 11:00:00 | AAPL | Stock | 5.4136 | 5.4218 | 5.4018 | 5.406 | 34498380.0 |
| 2009-07-21 11:30:00 | AAPL | Stock | 5.4064 | 5.4071 | 5.3482 | 5.3536 | 50606304.0 |
| 2009-07-21 12:00:00 | AAPL | Stock | 5.3532 | 5.3679 | 5.3507 | 5.3657 | 29264620.0 |
| 2009-07-21 12:30:00 | AAPL | Stock | 5.3661 | 5.3832 | 5.3593 | 5.3693 | 28432208.0 |
| 2009-07-21 13:00:00 | AAPL | Stock | 5.3693 | 5.3764 | 5.3571 | 5.3764 | 22196020.0 |
| 2009-07-21 13:30:00 | AAPL | Stock | 5.3764 | 5.3914 | 5.3696 | 5.3746 | 30736916.0 |
| 2009-07-21 14:00:00 | AAPL | Stock | 5.375 | 5.3807 | 5.3596 | 5.3707 | 28162008.0 |
| 2009-07-21 14:30:00 | AAPL | Stock | 5.3711 | 5.3918 | 5.3629 | 5.3907 | 37294712.0 |
| 2009-07-21 15:00:00 | AAPL | Stock | 5.3911 | 5.4179 | 5.3882 | 5.4132 | 53784332.0 |
| 2009-07-21 15:30:00 | AAPL | Stock | 5.4132 | 5.4171 | 5.3875 | 5.4143 | 95256224.0 |
| 2009-07-21 16:00:00 | AAPL | Stock | 5.4139 | 5.4361 | 5.3926 | 5.4218 | 20723640.0 |
| 2009-07-21 16:30:00 | AAPL | Stock | 5.4186 | 5.6161 | 5.2139 | 5.6125 | 150147788.0 |
| 2009-07-21 17:00:00 | AAPL | Stock | 5.6129 | 5.6732 | 5.5893 | 5.6686 | 45390884.0 |
| 2009-07-21 17:30:00 | AAPL | Stock | 5.4207 | 5.6696 | 5.4207 | 5.6536 | 15447068.0 |
| 2009-07-21 18:00:00 | AAPL | Stock | 5.6536 | 5.6643 | 5.4111 | 5.6575 | 5567268.0 |
| 2009-07-21 18:30:00 | AAPL | Stock | 5.6575 | 5.6586 | 5.6386 | 5.6525 | 2271640.0 |
| 2009-07-21 19:00:00 | AAPL | Stock | 5.6504 | 5.6564 | 5.6468 | 5.655 | 1227604.0 |
| 2009-07-21 19:30:00 | AAPL | Stock | 5.6536 | 5.6571 | 5.6475 | 5.6571 | 1792028.0 |
| 2009-07-21 07:30:00 | MSFT | Stock | 24.57 | 24.57 | 24.57 | 24.57 | 100.0 |
| 2009-07-21 08:00:00 | MSFT | Stock | 24.54 | 24.66 | 24.54 | 24.66 | 9370.0 |
| 2009-07-21 08:30:00 | MSFT | Stock | 24.67 | 24.71 | 24.63 | 24.7 | 9994.0 |
| 2009-07-21 09:00:00 | MSFT | Stock | 24.68 | 24.74 | 24.64 | 24.74 | 16705.0 |
| 2009-07-21 09:30:00 | MSFT | Stock | 24.69 | 24.77 | 24.54 | 24.6 | 5518866.0 |
| 2009-07-21 10:00:00 | MSFT | Stock | 24.61 | 24.65 | 24.37 | 24.59 | 4780452.0 |
| 2009-07-21 10:30:00 | MSFT | Stock | 24.59 | 24.74 | 24.58 | 24.71 | 3987699.0 |
| 2009-07-21 11:00:00 | MSFT | Stock | 24.72 | 24.8 | 24.7 | 24.76 | 3191552.0 |
| 2009-07-21 11:30:00 | MSFT | Stock | 24.76 | 24.77 | 24.6 | 24.643 | 3418754.0 |
| 2009-07-21 12:00:00 | MSFT | Stock | 24.65 | 24.75 | 24.64 | 24.71 | 2270269.0 |
| 2009-07-21 12:30:00 | MSFT | Stock | 24.71 | 24.74 | 24.63 | 24.69 | 2130326.0 |
| 2009-07-21 13:00:00 | MSFT | Stock | 24.68 | 24.71 | 24.63 | 24.68 | 2727544.0 |
| 2009-07-21 13:30:00 | MSFT | Stock | 24.671 | 24.69 | 24.6 | 24.64 | 2039569.0 |
| 2009-07-21 14:00:00 | MSFT | Stock | 24.65 | 24.74 | 24.63 | 24.7 | 2603770.0 |
| 2009-07-21 14:30:00 | MSFT | Stock | 24.7 | 24.75 | 24.64 | 24.745 | 2586182.0 |
| 2009-07-21 15:00:00 | MSFT | Stock | 24.75 | 24.77 | 24.69 | 24.719 | 3581341.0 |
| 2009-07-21 15:30:00 | MSFT | Stock | 24.71 | 24.83 | 24.7 | 24.83 | 8691083.0 |
| 2009-07-21 16:00:00 | MSFT | Stock | 24.82 | 24.86 | 24.684 | 24.69 | 2177890.0 |
| 2009-07-21 16:30:00 | MSFT | Stock | 24.78 | 24.86 | 24.686 | 24.8 | 93432.0 |
| 2009-07-21 17:00:00 | MSFT | Stock | 24.86 | 24.98 | 24.86 | 24.98 | 18700.0 |
| 2009-07-21 17:30:00 | MSFT | Stock | 24.84 | 24.98 | 24.84 | 24.95 | 12535.0 |
> showing 50 of 70,069 rows — these rows as CSV