PREVIEW / stock_30min / 2007-05-21
file: by_date/stock_30min/2007/2007-05-21.parquet size: 1.1 MB rows: 63,015 symbols: 3,019
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-21 09:30:00 | AAPL | Stock | 3.9396 | 3.9614 | 3.9304 | 3.9584 | 69205220.0 |
| 2007-05-21 10:00:00 | AAPL | Stock | 3.9571 | 3.9679 | 3.9536 | 3.9629 | 65262008.0 |
| 2007-05-21 10:30:00 | AAPL | Stock | 3.9632 | 4.0061 | 3.96 | 4.005 | 71083600.0 |
| 2007-05-21 11:00:00 | AAPL | Stock | 4.005 | 4.0079 | 3.9929 | 3.9961 | 47196268.0 |
| 2007-05-21 11:30:00 | AAPL | Stock | 3.9964 | 4.0018 | 3.9929 | 4.0011 | 23784404.0 |
| 2007-05-21 12:00:00 | AAPL | Stock | 4.0011 | 4.0161 | 3.9996 | 4.0054 | 46241888.0 |
| 2007-05-21 12:30:00 | AAPL | Stock | 4.005 | 4.0079 | 3.8768 | 3.9929 | 45641288.0 |
| 2007-05-21 13:00:00 | AAPL | Stock | 3.9929 | 4.0007 | 3.99 | 3.9968 | 20442128.0 |
| 2007-05-21 13:30:00 | AAPL | Stock | 3.9964 | 4.0 | 3.9861 | 3.9943 | 27554940.0 |
| 2007-05-21 14:00:00 | AAPL | Stock | 3.9943 | 3.9986 | 3.9921 | 3.9932 | 21966532.0 |
| 2007-05-21 14:30:00 | AAPL | Stock | 3.9932 | 4.0125 | 3.993 | 4.0082 | 43836240.0 |
| 2007-05-21 15:00:00 | AAPL | Stock | 4.0079 | 4.0125 | 3.9871 | 3.9896 | 77090272.0 |
| 2007-05-21 15:30:00 | AAPL | Stock | 3.9889 | 3.9996 | 3.9786 | 3.9996 | 61860820.0 |
| 2007-05-21 16:00:00 | AAPL | Stock | 3.9993 | 4.0 | 3.9989 | 3.9993 | 4070696.0 |
| 2007-05-21 09:30:00 | MSFT | Stock | 30.73 | 31.0 | 30.73 | 30.97 | 3292257.0 |
| 2007-05-21 10:00:00 | MSFT | Stock | 30.97 | 31.09 | 30.96 | 31.052 | 3674703.0 |
| 2007-05-21 10:30:00 | MSFT | Stock | 31.05 | 31.15 | 31.05 | 31.14 | 3356148.0 |
| 2007-05-21 11:00:00 | MSFT | Stock | 31.13 | 31.15 | 31.12 | 31.121 | 2307322.0 |
| 2007-05-21 11:30:00 | MSFT | Stock | 31.12 | 31.14 | 31.1 | 31.12 | 2196504.0 |
| 2007-05-21 12:00:00 | MSFT | Stock | 31.12 | 31.16 | 31.1 | 31.13 | 2891921.0 |
| 2007-05-21 12:30:00 | MSFT | Stock | 31.121 | 31.14 | 31.12 | 31.135 | 1225377.0 |
| 2007-05-21 13:00:00 | MSFT | Stock | 31.14 | 31.16 | 31.11 | 31.159 | 1465392.0 |
| 2007-05-21 13:30:00 | MSFT | Stock | 31.155 | 31.16 | 31.06 | 31.08 | 2405583.0 |
| 2007-05-21 14:00:00 | MSFT | Stock | 31.08 | 31.1 | 31.07 | 31.1 | 1754798.0 |
| 2007-05-21 14:30:00 | MSFT | Stock | 31.1 | 31.11 | 30.99 | 31.02 | 2965853.0 |
| 2007-05-21 15:00:00 | MSFT | Stock | 31.01 | 31.04 | 30.91 | 30.91 | 5160581.0 |
| 2007-05-21 15:30:00 | MSFT | Stock | 30.92 | 31.07 | 30.892 | 31.07 | 5349052.0 |
| 2007-05-21 16:00:00 | MSFT | Stock | 31.06 | 31.07 | 31.05 | 31.05 | 769700.0 |
| 2007-05-21 04:00:00 | NVDA | Stock | 0.5837 | 0.5837 | 0.5837 | 0.5837 | 30000.0 |
| 2007-05-21 07:30:00 | NVDA | Stock | 0.584 | 0.584 | 0.584 | 0.584 | 30000.0 |
| 2007-05-21 08:30:00 | NVDA | Stock | 0.5837 | 0.5837 | 0.5837 | 0.5837 | 108000.0 |
| 2007-05-21 09:00:00 | NVDA | Stock | 0.5848 | 0.585 | 0.582 | 0.582 | 375300.0 |
| 2007-05-21 09:30:00 | NVDA | Stock | 0.582 | 0.5833 | 0.58 | 0.5808 | 31045020.0 |
| 2007-05-21 10:00:00 | NVDA | Stock | 0.5808 | 0.5827 | 0.5792 | 0.5802 | 20077800.0 |
| 2007-05-21 10:30:00 | NVDA | Stock | 0.5803 | 0.5883 | 0.5802 | 0.5877 | 41553540.0 |
| 2007-05-21 11:00:00 | NVDA | Stock | 0.5877 | 0.5892 | 0.5852 | 0.5858 | 26500860.0 |
| 2007-05-21 11:30:00 | NVDA | Stock | 0.5858 | 0.588 | 0.5847 | 0.587 | 15701580.0 |
| 2007-05-21 12:00:00 | NVDA | Stock | 0.5872 | 0.5892 | 0.5865 | 0.5872 | 19526580.0 |
| 2007-05-21 12:30:00 | NVDA | Stock | 0.587 | 0.5872 | 0.586 | 0.5863 | 14245380.0 |
| 2007-05-21 13:00:00 | NVDA | Stock | 0.5862 | 0.6 | 0.586 | 0.6 | 205704900.0 |
| 2007-05-21 13:30:00 | NVDA | Stock | 0.6 | 0.6 | 0.5938 | 0.5945 | 78007560.0 |
| 2007-05-21 14:00:00 | NVDA | Stock | 0.5945 | 0.5967 | 0.5925 | 0.5927 | 32791740.0 |
| 2007-05-21 14:30:00 | NVDA | Stock | 0.5927 | 0.5937 | 0.5887 | 0.5905 | 40983540.0 |
| 2007-05-21 15:00:00 | NVDA | Stock | 0.5903 | 0.5907 | 0.5833 | 0.5843 | 65778720.0 |
| 2007-05-21 15:30:00 | NVDA | Stock | 0.5842 | 0.5858 | 0.5833 | 0.5855 | 45887040.0 |
| 2007-05-21 16:00:00 | NVDA | Stock | 0.5855 | 0.5875 | 0.5855 | 0.5875 | 3961860.0 |
| 2007-05-21 16:30:00 | NVDA | Stock | 0.5872 | 0.5875 | 0.5855 | 0.5875 | 526440.0 |
| 2007-05-21 17:00:00 | NVDA | Stock | 0.5873 | 0.5873 | 0.5867 | 0.5867 | 63000.0 |
| 2007-05-21 17:30:00 | NVDA | Stock | 0.5867 | 0.5867 | 0.5867 | 0.5867 | 17700.0 |
| 2007-05-21 19:00:00 | NVDA | Stock | 0.5873 | 0.5873 | 0.5873 | 0.5873 | 10200.0 |
> showing 50 of 63,015 rows — these rows as CSV