PREVIEW / stock_30min / 2007-06-12
file: by_date/stock_30min/2007/2007-06-12.parquet size: 1.1 MB rows: 63,626 symbols: 3,026
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-06-12 09:30:00 | AAPL | Stock | 4.2625 | 4.3121 | 4.2254 | 4.2829 | 272237224.0 |
| 2007-06-12 10:00:00 | AAPL | Stock | 4.2832 | 4.3314 | 4.2796 | 4.3054 | 174837908.0 |
| 2007-06-12 10:30:00 | AAPL | Stock | 4.3054 | 4.3118 | 4.2836 | 4.2886 | 105678664.0 |
| 2007-06-12 11:00:00 | AAPL | Stock | 4.2886 | 4.3007 | 4.2629 | 4.2925 | 100018548.0 |
| 2007-06-12 11:30:00 | AAPL | Stock | 4.2921 | 4.3214 | 4.2918 | 4.3207 | 73878728.0 |
| 2007-06-12 12:00:00 | AAPL | Stock | 4.3211 | 4.3407 | 4.3082 | 4.3246 | 100530808.0 |
| 2007-06-12 12:30:00 | AAPL | Stock | 4.3246 | 4.3254 | 4.3057 | 4.3121 | 53477816.0 |
| 2007-06-12 13:00:00 | AAPL | Stock | 4.3118 | 4.3246 | 4.2971 | 4.315 | 56883960.0 |
| 2007-06-12 13:30:00 | AAPL | Stock | 4.3154 | 4.3439 | 4.305 | 4.3393 | 63132804.0 |
| 2007-06-12 14:00:00 | AAPL | Stock | 4.3396 | 4.3468 | 4.32 | 4.3271 | 70712992.0 |
| 2007-06-12 14:30:00 | AAPL | Stock | 4.3271 | 4.3343 | 4.3096 | 4.3207 | 68845728.0 |
| 2007-06-12 15:00:00 | AAPL | Stock | 4.32 | 4.3275 | 4.285 | 4.295 | 109119948.0 |
| 2007-06-12 15:30:00 | AAPL | Stock | 4.2954 | 4.305 | 4.29 | 4.3014 | 106419320.0 |
| 2007-06-12 16:00:00 | AAPL | Stock | 4.2993 | 4.3011 | 4.2993 | 4.2993 | 5456948.0 |
| 2007-06-12 09:30:00 | MSFT | Stock | 29.96 | 29.96 | 29.87 | 29.89 | 5265069.0 |
| 2007-06-12 10:00:00 | MSFT | Stock | 29.89 | 29.94 | 29.79 | 29.82 | 4290067.0 |
| 2007-06-12 10:30:00 | MSFT | Stock | 29.83 | 29.86 | 29.79 | 29.83 | 3836052.0 |
| 2007-06-12 11:00:00 | MSFT | Stock | 29.83 | 29.855 | 29.77 | 29.8 | 2900611.0 |
| 2007-06-12 11:30:00 | MSFT | Stock | 29.8 | 29.91 | 29.8 | 29.9 | 2829686.0 |
| 2007-06-12 12:00:00 | MSFT | Stock | 29.9 | 29.95 | 29.8 | 29.94 | 2608355.0 |
| 2007-06-12 12:30:00 | MSFT | Stock | 29.94 | 29.98 | 29.93 | 29.965 | 1954812.0 |
| 2007-06-12 13:00:00 | MSFT | Stock | 29.96 | 30.07 | 29.96 | 30.06 | 3885015.0 |
| 2007-06-12 13:30:00 | MSFT | Stock | 30.06 | 30.15 | 30.03 | 30.13 | 4215110.0 |
| 2007-06-12 14:00:00 | MSFT | Stock | 30.13 | 30.24 | 30.12 | 30.17 | 4379293.0 |
| 2007-06-12 14:30:00 | MSFT | Stock | 30.17 | 30.21 | 30.04 | 30.11 | 3875277.0 |
| 2007-06-12 15:00:00 | MSFT | Stock | 30.1 | 30.15 | 29.9 | 29.96 | 4761790.0 |
| 2007-06-12 15:30:00 | MSFT | Stock | 29.95 | 29.99 | 29.73 | 29.85 | 6607991.0 |
| 2007-06-12 16:00:00 | MSFT | Stock | 29.85 | 29.85 | 29.85 | 29.85 | 1084591.0 |
| 2007-06-12 08:00:00 | NVDA | Stock | 0.6083 | 0.6083 | 0.6083 | 0.6083 | 18000.0 |
| 2007-06-12 09:00:00 | NVDA | Stock | 0.6083 | 0.6093 | 0.5967 | 0.6067 | 1263420.0 |
| 2007-06-12 09:30:00 | NVDA | Stock | 0.6082 | 0.6142 | 0.6053 | 0.6113 | 65156340.0 |
| 2007-06-12 10:00:00 | NVDA | Stock | 0.6113 | 0.615 | 0.6113 | 0.6148 | 41068440.0 |
| 2007-06-12 10:30:00 | NVDA | Stock | 0.615 | 0.615 | 0.6103 | 0.6132 | 50902800.0 |
| 2007-06-12 11:00:00 | NVDA | Stock | 0.6132 | 0.6143 | 0.6112 | 0.612 | 38066220.0 |
| 2007-06-12 11:30:00 | NVDA | Stock | 0.6122 | 0.6167 | 0.611 | 0.6155 | 45054120.0 |
| 2007-06-12 12:00:00 | NVDA | Stock | 0.6155 | 0.6155 | 0.6115 | 0.6118 | 33340320.0 |
| 2007-06-12 12:30:00 | NVDA | Stock | 0.6118 | 0.6137 | 0.6108 | 0.6113 | 20305620.0 |
| 2007-06-12 13:00:00 | NVDA | Stock | 0.6113 | 0.6133 | 0.6102 | 0.612 | 21663600.0 |
| 2007-06-12 13:30:00 | NVDA | Stock | 0.6118 | 0.6142 | 0.6107 | 0.6138 | 27689940.0 |
| 2007-06-12 14:00:00 | NVDA | Stock | 0.614 | 0.6152 | 0.611 | 0.612 | 23137320.0 |
| 2007-06-12 14:30:00 | NVDA | Stock | 0.612 | 0.6127 | 0.6102 | 0.6123 | 27827460.0 |
| 2007-06-12 15:00:00 | NVDA | Stock | 0.6123 | 0.613 | 0.607 | 0.608 | 53617620.0 |
| 2007-06-12 15:30:00 | NVDA | Stock | 0.608 | 0.6093 | 0.6047 | 0.6057 | 56612700.0 |
| 2007-06-12 16:00:00 | NVDA | Stock | 0.6053 | 0.6075 | 0.605 | 0.6067 | 10235700.0 |
| 2007-06-12 16:30:00 | NVDA | Stock | 0.6065 | 0.6065 | 0.6065 | 0.6065 | 124680.0 |
| 2007-06-12 17:00:00 | NVDA | Stock | 0.6078 | 0.6083 | 0.605 | 0.605 | 893220.0 |
| 2007-06-12 17:30:00 | NVDA | Stock | 0.6083 | 0.6083 | 0.6083 | 0.6083 | 7800.0 |
| 2007-06-12 19:00:00 | NVDA | Stock | 0.606 | 0.606 | 0.606 | 0.606 | 6000.0 |
| 2007-06-12 19:30:00 | NVDA | Stock | 0.606 | 0.606 | 0.606 | 0.606 | 54000.0 |
| 2007-06-12 07:00:00 | AMZN | Stock | 3.55 | 3.55 | 3.55 | 3.55 | 3600.0 |
> showing 50 of 63,626 rows — these rows as CSV