PREVIEW / stock_30min / 2008-10-03
file: by_date/stock_30min/2008/2008-10-03.parquet size: 1.2 MB rows: 69,479 symbols: 3,325
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-10-03 07:00:00 | AAPL | Stock | 3.6679 | 3.6786 | 3.6607 | 3.6786 | 56952.0 |
| 2008-10-03 07:30:00 | AAPL | Stock | 3.6711 | 3.6711 | 3.6293 | 3.6293 | 28000.0 |
| 2008-10-03 08:00:00 | AAPL | Stock | 3.6311 | 3.6611 | 3.6293 | 3.6314 | 1692096.0 |
| 2008-10-03 08:30:00 | AAPL | Stock | 3.6314 | 3.6911 | 3.6107 | 3.6561 | 6063848.0 |
| 2008-10-03 09:00:00 | AAPL | Stock | 3.6561 | 3.74 | 3.6479 | 3.7129 | 7855568.0 |
| 2008-10-03 09:30:00 | AAPL | Stock | 3.7136 | 3.8036 | 3.3804 | 3.6436 | 634827900.0 |
| 2008-10-03 10:00:00 | AAPL | Stock | 3.6432 | 3.7143 | 3.6071 | 3.6983 | 209792828.0 |
| 2008-10-03 10:30:00 | AAPL | Stock | 3.7021 | 3.75 | 3.6964 | 3.7261 | 109801748.0 |
| 2008-10-03 11:00:00 | AAPL | Stock | 3.7271 | 3.7464 | 3.6968 | 3.7021 | 72607416.0 |
| 2008-10-03 11:30:00 | AAPL | Stock | 3.7021 | 3.7371 | 3.6964 | 3.7314 | 59604468.0 |
| 2008-10-03 12:00:00 | AAPL | Stock | 3.7311 | 3.7361 | 3.6964 | 3.7132 | 49660576.0 |
| 2008-10-03 12:30:00 | AAPL | Stock | 3.7129 | 3.75 | 3.7 | 3.7475 | 56163380.0 |
| 2008-10-03 13:00:00 | AAPL | Stock | 3.7471 | 3.8 | 3.6504 | 3.6861 | 131978084.0 |
| 2008-10-03 13:30:00 | AAPL | Stock | 3.685 | 3.6932 | 3.5071 | 3.6129 | 222214272.0 |
| 2008-10-03 14:00:00 | AAPL | Stock | 3.6125 | 3.6546 | 3.4796 | 3.4982 | 156855412.0 |
| 2008-10-03 14:30:00 | AAPL | Stock | 3.4989 | 3.6057 | 3.4036 | 3.6021 | 203398328.0 |
| 2008-10-03 15:00:00 | AAPL | Stock | 3.6021 | 3.6154 | 3.5 | 3.5136 | 137161976.0 |
| 2008-10-03 15:30:00 | AAPL | Stock | 3.515 | 3.56 | 3.4082 | 3.4686 | 185175928.0 |
| 2008-10-03 16:00:00 | AAPL | Stock | 3.4689 | 3.7267 | 3.4475 | 3.4779 | 20234480.0 |
| 2008-10-03 16:30:00 | AAPL | Stock | 3.4768 | 3.4821 | 3.4732 | 3.4732 | 727776.0 |
| 2008-10-03 17:00:00 | AAPL | Stock | 3.4761 | 3.4764 | 3.4646 | 3.475 | 935648.0 |
| 2008-10-03 17:30:00 | AAPL | Stock | 3.4732 | 3.4929 | 3.4714 | 3.4929 | 929712.0 |
| 2008-10-03 18:00:00 | AAPL | Stock | 3.4861 | 3.4889 | 3.4821 | 3.4839 | 190512.0 |
| 2008-10-03 18:30:00 | AAPL | Stock | 3.4839 | 3.6125 | 3.4786 | 3.4882 | 5039468.0 |
| 2008-10-03 19:00:00 | AAPL | Stock | 3.4893 | 3.4911 | 3.4857 | 3.4907 | 44100.0 |
| 2008-10-03 19:30:00 | AAPL | Stock | 3.4907 | 3.4982 | 3.4907 | 3.4982 | 291536.0 |
| 2008-10-03 07:00:00 | MSFT | Stock | 26.3 | 26.48 | 26.3 | 26.48 | 1200.0 |
| 2008-10-03 07:30:00 | MSFT | Stock | 26.47 | 26.47 | 26.47 | 26.47 | 200.0 |
| 2008-10-03 08:00:00 | MSFT | Stock | 26.25 | 26.3 | 26.05 | 26.25 | 96450.0 |
| 2008-10-03 08:30:00 | MSFT | Stock | 26.25 | 26.5 | 26.25 | 26.49 | 38921.0 |
| 2008-10-03 09:00:00 | MSFT | Stock | 26.48 | 26.48 | 26.35 | 26.38 | 60788.0 |
| 2008-10-03 09:30:00 | MSFT | Stock | 26.38 | 27.0 | 26.34 | 26.85 | 10607206.0 |
| 2008-10-03 10:00:00 | MSFT | Stock | 26.85 | 26.98 | 26.77 | 26.9 | 6383608.0 |
| 2008-10-03 10:30:00 | MSFT | Stock | 26.9 | 26.98 | 26.84 | 26.93 | 5665042.0 |
| 2008-10-03 11:00:00 | MSFT | Stock | 26.93 | 27.15 | 26.93 | 27.03 | 6551603.0 |
| 2008-10-03 11:30:00 | MSFT | Stock | 27.035 | 27.21 | 27.031 | 27.08 | 4147430.0 |
| 2008-10-03 12:00:00 | MSFT | Stock | 27.08 | 27.22 | 27.05 | 27.17 | 5758293.0 |
| 2008-10-03 12:30:00 | MSFT | Stock | 27.17 | 27.42 | 27.14 | 27.335 | 7106204.0 |
| 2008-10-03 13:00:00 | MSFT | Stock | 27.34 | 27.47 | 27.11 | 27.14 | 9836918.0 |
| 2008-10-03 13:30:00 | MSFT | Stock | 27.14 | 27.17 | 26.36 | 26.77 | 15193103.0 |
| 2008-10-03 14:00:00 | MSFT | Stock | 26.79 | 27.15 | 26.52 | 26.61 | 8161114.0 |
| 2008-10-03 14:30:00 | MSFT | Stock | 26.6 | 26.94 | 26.37 | 26.91 | 7573618.0 |
| 2008-10-03 15:00:00 | MSFT | Stock | 26.901 | 26.91 | 26.5 | 26.67 | 7243877.0 |
| 2008-10-03 15:30:00 | MSFT | Stock | 26.67 | 26.83 | 26.24 | 26.29 | 13185768.0 |
| 2008-10-03 16:00:00 | MSFT | Stock | 26.31 | 26.892 | 26.25 | 26.34 | 5777915.0 |
| 2008-10-03 16:30:00 | MSFT | Stock | 26.32 | 26.6 | 26.32 | 26.35 | 15942.0 |
| 2008-10-03 17:00:00 | MSFT | Stock | 26.32 | 26.45 | 26.32 | 26.45 | 120700.0 |
| 2008-10-03 17:30:00 | MSFT | Stock | 26.47 | 26.47 | 26.33 | 26.33 | 1950.0 |
| 2008-10-03 18:00:00 | MSFT | Stock | 26.36 | 26.4 | 26.35 | 26.4 | 4510.0 |
| 2008-10-03 18:30:00 | MSFT | Stock | 26.44 | 26.9 | 26.44 | 26.9 | 1776600.0 |
> showing 50 of 69,479 rows — these rows as CSV