PREVIEW / stock_30min / 2008-03-11
file: by_date/stock_30min/2008/2008-03-11.parquet size: 1.2 MB rows: 70,579 symbols: 3,288
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-03-11 04:00:00 | AAPL | Stock | 4.2768 | 4.2925 | 4.2768 | 4.2925 | 5600.0 |
| 2008-03-11 06:00:00 | AAPL | Stock | 4.3125 | 4.3125 | 4.3125 | 4.3125 | 11480.0 |
| 2008-03-11 06:30:00 | AAPL | Stock | 4.3125 | 4.3125 | 4.3125 | 4.3125 | 15120.0 |
| 2008-03-11 07:00:00 | AAPL | Stock | 4.3125 | 4.3232 | 4.3125 | 4.3161 | 98000.0 |
| 2008-03-11 07:30:00 | AAPL | Stock | 4.315 | 4.3171 | 4.3036 | 4.3036 | 61348.0 |
| 2008-03-11 08:00:00 | AAPL | Stock | 4.3018 | 4.3246 | 4.2879 | 4.3143 | 2204608.0 |
| 2008-03-11 08:30:00 | AAPL | Stock | 4.3107 | 4.4143 | 4.3107 | 4.3879 | 12632396.0 |
| 2008-03-11 09:00:00 | AAPL | Stock | 4.3886 | 4.4332 | 4.3846 | 4.4329 | 8283352.0 |
| 2008-03-11 09:30:00 | AAPL | Stock | 4.4321 | 4.4643 | 4.3796 | 4.3814 | 186213272.0 |
| 2008-03-11 10:00:00 | AAPL | Stock | 4.3797 | 4.4239 | 4.3689 | 4.4164 | 100738176.0 |
| 2008-03-11 10:30:00 | AAPL | Stock | 4.4168 | 4.4225 | 4.3943 | 4.4214 | 67989404.0 |
| 2008-03-11 11:00:00 | AAPL | Stock | 4.4218 | 4.4464 | 4.3843 | 4.4086 | 70390908.0 |
| 2008-03-11 11:30:00 | AAPL | Stock | 4.4086 | 4.4214 | 4.3571 | 4.3875 | 67730460.0 |
| 2008-03-11 12:00:00 | AAPL | Stock | 4.3875 | 4.4179 | 4.3839 | 4.4029 | 57955352.0 |
| 2008-03-11 12:30:00 | AAPL | Stock | 4.4029 | 4.4107 | 4.3636 | 4.3992 | 55170304.0 |
| 2008-03-11 13:00:00 | AAPL | Stock | 4.3996 | 4.4282 | 4.3911 | 4.4264 | 61998188.0 |
| 2008-03-11 13:30:00 | AAPL | Stock | 4.4257 | 4.4518 | 4.4054 | 4.4432 | 56014588.0 |
| 2008-03-11 14:00:00 | AAPL | Stock | 4.4432 | 4.4511 | 4.43 | 4.4443 | 55844292.0 |
| 2008-03-11 14:30:00 | AAPL | Stock | 4.4454 | 4.4957 | 4.4361 | 4.4736 | 100348556.0 |
| 2008-03-11 15:00:00 | AAPL | Stock | 4.4736 | 4.5039 | 4.4675 | 4.4907 | 87913700.0 |
| 2008-03-11 15:30:00 | AAPL | Stock | 4.4913 | 4.5529 | 4.4696 | 4.5482 | 137156320.0 |
| 2008-03-11 16:00:00 | AAPL | Stock | 4.5482 | 4.5661 | 4.4071 | 4.5625 | 28660044.0 |
| 2008-03-11 16:30:00 | AAPL | Stock | 4.5643 | 4.5657 | 4.5482 | 4.5607 | 1442588.0 |
| 2008-03-11 17:00:00 | AAPL | Stock | 4.5607 | 4.5625 | 4.5482 | 4.5571 | 682304.0 |
| 2008-03-11 17:30:00 | AAPL | Stock | 4.5589 | 4.5804 | 4.5482 | 4.5689 | 4864552.0 |
| 2008-03-11 18:00:00 | AAPL | Stock | 4.5714 | 4.5775 | 4.5661 | 4.5775 | 477316.0 |
| 2008-03-11 18:30:00 | AAPL | Stock | 4.5775 | 4.5775 | 4.5671 | 4.5689 | 203028.0 |
| 2008-03-11 19:00:00 | AAPL | Stock | 4.5682 | 4.5682 | 4.5596 | 4.5614 | 171052.0 |
| 2008-03-11 19:30:00 | AAPL | Stock | 4.5671 | 4.5679 | 4.5611 | 4.5679 | 148148.0 |
| 2008-03-11 08:00:00 | MSFT | Stock | 28.15 | 28.2 | 28.05 | 28.16 | 314422.0 |
| 2008-03-11 08:30:00 | MSFT | Stock | 28.16 | 28.38 | 28.16 | 28.35 | 151047.0 |
| 2008-03-11 09:00:00 | MSFT | Stock | 28.35 | 28.42 | 28.34 | 28.4 | 245216.0 |
| 2008-03-11 09:30:00 | MSFT | Stock | 28.4 | 28.81 | 28.38 | 28.56 | 11660571.0 |
| 2008-03-11 10:00:00 | MSFT | Stock | 28.56 | 28.79 | 28.54 | 28.7 | 6390159.0 |
| 2008-03-11 10:30:00 | MSFT | Stock | 28.7 | 28.83 | 28.58 | 28.81 | 7376814.0 |
| 2008-03-11 11:00:00 | MSFT | Stock | 28.8 | 28.85 | 28.76 | 28.8 | 6599736.0 |
| 2008-03-11 11:30:00 | MSFT | Stock | 28.8 | 28.8 | 28.6 | 28.69 | 5370362.0 |
| 2008-03-11 12:00:00 | MSFT | Stock | 28.69 | 28.8 | 28.68 | 28.73 | 4106462.0 |
| 2008-03-11 12:30:00 | MSFT | Stock | 28.72 | 28.73 | 28.55 | 28.69 | 6619265.0 |
| 2008-03-11 13:00:00 | MSFT | Stock | 28.7 | 28.86 | 28.67 | 28.86 | 6205232.0 |
| 2008-03-11 13:30:00 | MSFT | Stock | 28.86 | 28.89 | 28.77 | 28.88 | 3981523.0 |
| 2008-03-11 14:00:00 | MSFT | Stock | 28.88 | 29.0 | 28.87 | 28.94 | 3915161.0 |
| 2008-03-11 14:30:00 | MSFT | Stock | 28.94 | 29.03 | 28.92 | 28.96 | 5271857.0 |
| 2008-03-11 15:00:00 | MSFT | Stock | 28.96 | 29.1 | 28.91 | 29.08 | 8502983.0 |
| 2008-03-11 15:30:00 | MSFT | Stock | 29.08 | 29.34 | 29.0 | 29.28 | 13570375.0 |
| 2008-03-11 16:00:00 | MSFT | Stock | 29.28 | 29.39 | 28.805 | 29.35 | 4542995.0 |
| 2008-03-11 16:30:00 | MSFT | Stock | 29.36 | 29.37 | 28.947 | 29.35 | 148929.0 |
| 2008-03-11 17:00:00 | MSFT | Stock | 29.28 | 29.42 | 28.96 | 29.42 | 44943.0 |
| 2008-03-11 17:30:00 | MSFT | Stock | 29.3 | 29.42 | 29.28 | 29.42 | 3719557.0 |
| 2008-03-11 18:00:00 | MSFT | Stock | 29.4 | 29.42 | 29.37 | 29.42 | 6455.0 |
> showing 50 of 70,579 rows — these rows as CSV