PREVIEW / stock_30min / 2010-09-14
file: by_date/stock_30min/2010/2010-09-14.parquet size: 1.3 MB rows: 72,784 symbols: 3,468
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-14 07:00:00 | AAPL | Stock | 9.5021 | 9.5196 | 9.5 | 9.51 | 88200.0 |
| 2010-09-14 07:30:00 | AAPL | Stock | 9.5007 | 9.5089 | 9.4911 | 9.5089 | 51996.0 |
| 2010-09-14 08:00:00 | AAPL | Stock | 9.5107 | 9.5411 | 9.5018 | 9.5411 | 614180.0 |
| 2010-09-14 08:30:00 | AAPL | Stock | 9.5411 | 9.5571 | 9.5175 | 9.5175 | 1210552.0 |
| 2010-09-14 09:00:00 | AAPL | Stock | 9.515 | 9.5211 | 9.5039 | 9.5071 | 842044.0 |
| 2010-09-14 09:30:00 | AAPL | Stock | 9.5068 | 9.5596 | 9.4829 | 9.5561 | 70950096.0 |
| 2010-09-14 10:00:00 | AAPL | Stock | 9.5568 | 9.5604 | 9.5179 | 9.5504 | 39253144.0 |
| 2010-09-14 10:30:00 | AAPL | Stock | 9.5482 | 9.5761 | 9.54 | 9.5689 | 33030732.0 |
| 2010-09-14 11:00:00 | AAPL | Stock | 9.5696 | 9.5911 | 9.5671 | 9.5793 | 30606240.0 |
| 2010-09-14 11:30:00 | AAPL | Stock | 9.5781 | 9.5911 | 9.5746 | 9.5879 | 23171372.0 |
| 2010-09-14 12:00:00 | AAPL | Stock | 9.5875 | 9.6132 | 9.5821 | 9.6044 | 28458024.0 |
| 2010-09-14 12:30:00 | AAPL | Stock | 9.605 | 9.6054 | 9.5757 | 9.5825 | 23040948.0 |
| 2010-09-14 13:00:00 | AAPL | Stock | 9.5836 | 9.5937 | 9.565 | 9.5714 | 14929208.0 |
| 2010-09-14 13:30:00 | AAPL | Stock | 9.5709 | 9.5893 | 9.5568 | 9.5889 | 18760644.0 |
| 2010-09-14 14:00:00 | AAPL | Stock | 9.5879 | 9.5929 | 9.5739 | 9.58 | 20446524.0 |
| 2010-09-14 14:30:00 | AAPL | Stock | 9.58 | 9.6071 | 9.575 | 9.5981 | 22640212.0 |
| 2010-09-14 15:00:00 | AAPL | Stock | 9.5979 | 9.6021 | 9.5804 | 9.5939 | 20710788.0 |
| 2010-09-14 15:30:00 | AAPL | Stock | 9.5929 | 9.6004 | 9.5643 | 9.5729 | 44849588.0 |
| 2010-09-14 16:00:00 | AAPL | Stock | 9.5729 | 9.584 | 9.5589 | 9.5679 | 8470252.0 |
| 2010-09-14 16:30:00 | AAPL | Stock | 9.5671 | 9.5933 | 9.5643 | 9.5646 | 554764.0 |
| 2010-09-14 17:00:00 | AAPL | Stock | 9.565 | 9.5714 | 9.5639 | 9.5696 | 160860.0 |
| 2010-09-14 17:30:00 | AAPL | Stock | 9.5668 | 9.5675 | 9.5625 | 9.5654 | 199724.0 |
| 2010-09-14 18:00:00 | AAPL | Stock | 9.5686 | 9.6121 | 9.5682 | 9.5893 | 2046156.0 |
| 2010-09-14 18:30:00 | AAPL | Stock | 9.5914 | 9.5954 | 9.5893 | 9.5943 | 218148.0 |
| 2010-09-14 19:00:00 | AAPL | Stock | 9.5939 | 9.5939 | 9.5893 | 9.5925 | 71120.0 |
| 2010-09-14 19:30:00 | AAPL | Stock | 9.5914 | 9.5914 | 9.5736 | 9.5864 | 437416.0 |
| 2010-09-14 05:30:00 | MSFT | Stock | 25.05 | 25.05 | 24.95 | 24.95 | 500.0 |
| 2010-09-14 06:00:00 | MSFT | Stock | 25.05 | 25.05 | 25.05 | 25.05 | 700.0 |
| 2010-09-14 07:00:00 | MSFT | Stock | 25.03 | 25.17 | 24.96 | 24.96 | 20700.0 |
| 2010-09-14 07:30:00 | MSFT | Stock | 24.95 | 25.01 | 24.93 | 25.0 | 17700.0 |
| 2010-09-14 08:00:00 | MSFT | Stock | 25.0 | 25.1 | 25.0 | 25.08 | 25043.0 |
| 2010-09-14 08:30:00 | MSFT | Stock | 25.08 | 25.09 | 24.97 | 24.99 | 109467.0 |
| 2010-09-14 09:00:00 | MSFT | Stock | 24.98 | 25.09 | 24.97 | 25.09 | 175551.0 |
| 2010-09-14 09:30:00 | MSFT | Stock | 25.04 | 25.1 | 24.93 | 25.008 | 14588578.0 |
| 2010-09-14 10:00:00 | MSFT | Stock | 25.0 | 25.01 | 24.89 | 24.978 | 7870139.0 |
| 2010-09-14 10:30:00 | MSFT | Stock | 24.973 | 25.14 | 24.952 | 25.11 | 5871633.0 |
| 2010-09-14 11:00:00 | MSFT | Stock | 25.1 | 25.19 | 25.09 | 25.152 | 4234040.0 |
| 2010-09-14 11:30:00 | MSFT | Stock | 25.157 | 25.23 | 25.15 | 25.23 | 4671851.0 |
| 2010-09-14 12:00:00 | MSFT | Stock | 25.23 | 25.32 | 25.22 | 25.3 | 4612724.0 |
| 2010-09-14 12:30:00 | MSFT | Stock | 25.31 | 25.35 | 25.24 | 25.28 | 4536113.0 |
| 2010-09-14 13:00:00 | MSFT | Stock | 25.28 | 25.29 | 25.14 | 25.2 | 3917582.0 |
| 2010-09-14 13:30:00 | MSFT | Stock | 25.21 | 25.22 | 25.02 | 25.06 | 7018866.0 |
| 2010-09-14 14:00:00 | MSFT | Stock | 25.06 | 25.08 | 24.99 | 25.0 | 4046702.0 |
| 2010-09-14 14:30:00 | MSFT | Stock | 25.0 | 25.12 | 24.98 | 25.08 | 3764499.0 |
| 2010-09-14 15:00:00 | MSFT | Stock | 25.085 | 25.17 | 25.08 | 25.15 | 4291590.0 |
| 2010-09-14 15:30:00 | MSFT | Stock | 25.145 | 25.24 | 25.0 | 25.03 | 13292450.0 |
| 2010-09-14 16:00:00 | MSFT | Stock | 25.03 | 25.125 | 24.993 | 25.05 | 2449213.0 |
| 2010-09-14 16:30:00 | MSFT | Stock | 25.05 | 25.14 | 25.0 | 25.02 | 44500.0 |
| 2010-09-14 17:00:00 | MSFT | Stock | 25.03 | 25.05 | 25.03 | 25.03 | 951.0 |
| 2010-09-14 17:30:00 | MSFT | Stock | 25.04 | 25.05 | 25.0 | 25.0 | 6051.0 |
> showing 50 of 72,784 rows — these rows as CSV