PREVIEW / stock_30min / 2006-07-26
file: by_date/stock_30min/2006/2006-07-26.parquet size: 932 KB rows: 50,251 symbols: 2,320
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-26 05:00:00 | AAPL | Stock | 2.2118 | 2.2118 | 2.2118 | 2.2118 | 8400.0 |
| 2006-07-26 08:00:00 | AAPL | Stock | 2.2164 | 2.2164 | 2.2014 | 2.2036 | 78680.0 |
| 2006-07-26 08:30:00 | AAPL | Stock | 2.2036 | 2.2143 | 2.2036 | 2.2125 | 456036.0 |
| 2006-07-26 09:00:00 | AAPL | Stock | 2.2121 | 2.2171 | 2.2071 | 2.2143 | 770924.0 |
| 2006-07-26 09:30:00 | AAPL | Stock | 2.2143 | 2.2264 | 2.2029 | 2.225 | 83940920.0 |
| 2006-07-26 10:00:00 | AAPL | Stock | 2.2254 | 2.2339 | 2.22 | 2.2257 | 73194940.0 |
| 2006-07-26 10:30:00 | AAPL | Stock | 2.2257 | 2.2268 | 2.2129 | 2.2179 | 47118484.0 |
| 2006-07-26 11:00:00 | AAPL | Stock | 2.2179 | 2.2329 | 2.2139 | 2.2314 | 52037412.0 |
| 2006-07-26 11:30:00 | AAPL | Stock | 2.2318 | 2.2514 | 2.2311 | 2.2475 | 70567112.0 |
| 2006-07-26 12:00:00 | AAPL | Stock | 2.2475 | 2.2779 | 2.2439 | 2.2746 | 80816232.0 |
| 2006-07-26 12:30:00 | AAPL | Stock | 2.2746 | 2.2761 | 2.2607 | 2.2621 | 48413988.0 |
| 2006-07-26 13:00:00 | AAPL | Stock | 2.2621 | 2.2839 | 2.2621 | 2.2804 | 46762884.0 |
| 2006-07-26 13:30:00 | AAPL | Stock | 2.2804 | 2.2925 | 2.2761 | 2.2893 | 65283904.0 |
| 2006-07-26 14:00:00 | AAPL | Stock | 2.29 | 2.3011 | 2.2854 | 2.2954 | 71761172.0 |
| 2006-07-26 14:30:00 | AAPL | Stock | 2.2954 | 2.3054 | 2.2936 | 2.3007 | 68339824.0 |
| 2006-07-26 15:00:00 | AAPL | Stock | 2.3011 | 2.3018 | 2.2793 | 2.2943 | 72218104.0 |
| 2006-07-26 15:30:00 | AAPL | Stock | 2.2943 | 2.3086 | 2.2807 | 2.2814 | 100780008.0 |
| 2006-07-26 16:00:00 | AAPL | Stock | 2.2814 | 2.2857 | 2.2811 | 2.2857 | 650300.0 |
| 2006-07-26 16:30:00 | AAPL | Stock | 2.2839 | 2.2857 | 2.2821 | 2.2857 | 134736.0 |
| 2006-07-26 17:00:00 | AAPL | Stock | 2.2811 | 2.2857 | 2.2811 | 2.2821 | 4948552.0 |
| 2006-07-26 17:30:00 | AAPL | Stock | 2.2821 | 2.2836 | 2.2804 | 2.2811 | 168868.0 |
| 2006-07-26 18:00:00 | AAPL | Stock | 2.2811 | 2.2811 | 2.2786 | 2.2807 | 200480.0 |
| 2006-07-26 07:00:00 | MSFT | Stock | 24.19 | 24.19 | 24.19 | 24.19 | 200.0 |
| 2006-07-26 07:30:00 | MSFT | Stock | 24.18 | 24.18 | 24.18 | 24.18 | 100.0 |
| 2006-07-26 08:00:00 | MSFT | Stock | 24.22 | 24.22 | 24.04 | 24.11 | 7875.0 |
| 2006-07-26 08:30:00 | MSFT | Stock | 24.09 | 24.15 | 24.09 | 24.15 | 17860.0 |
| 2006-07-26 09:00:00 | MSFT | Stock | 24.18 | 24.18 | 24.11 | 24.11 | 9500.0 |
| 2006-07-26 09:30:00 | MSFT | Stock | 24.12 | 24.28 | 24.11 | 24.25 | 4404151.0 |
| 2006-07-26 10:00:00 | MSFT | Stock | 24.25 | 24.27 | 24.14 | 24.18 | 3710499.0 |
| 2006-07-26 10:30:00 | MSFT | Stock | 24.18 | 24.25 | 24.16 | 24.21 | 2918012.0 |
| 2006-07-26 11:00:00 | MSFT | Stock | 24.21 | 24.24 | 24.14 | 24.22 | 2693886.0 |
| 2006-07-26 11:30:00 | MSFT | Stock | 24.22 | 24.28 | 24.2 | 24.23 | 3831886.0 |
| 2006-07-26 12:00:00 | MSFT | Stock | 24.23 | 24.28 | 24.1 | 24.25 | 1943675.0 |
| 2006-07-26 12:30:00 | MSFT | Stock | 24.25 | 24.26 | 24.2 | 24.21 | 1461582.0 |
| 2006-07-26 13:00:00 | MSFT | Stock | 24.21 | 24.28 | 24.21 | 24.268 | 4443504.0 |
| 2006-07-26 13:30:00 | MSFT | Stock | 24.26 | 24.35 | 24.25 | 24.33 | 3274605.0 |
| 2006-07-26 14:00:00 | MSFT | Stock | 24.32 | 24.43 | 24.27 | 24.38 | 4375987.0 |
| 2006-07-26 14:30:00 | MSFT | Stock | 24.38 | 24.5 | 24.25 | 24.473 | 4974875.0 |
| 2006-07-26 15:00:00 | MSFT | Stock | 24.47 | 24.53 | 24.43 | 24.51 | 8018083.0 |
| 2006-07-26 15:30:00 | MSFT | Stock | 24.51 | 24.53 | 24.34 | 24.38 | 6831531.0 |
| 2006-07-26 16:00:00 | MSFT | Stock | 24.36 | 24.5 | 24.3 | 24.38 | 256076.0 |
| 2006-07-26 16:30:00 | MSFT | Stock | 24.309 | 24.38 | 24.309 | 24.38 | 731542.0 |
| 2006-07-26 17:00:00 | MSFT | Stock | 24.38 | 24.38 | 24.38 | 24.38 | 958.0 |
| 2006-07-26 17:30:00 | MSFT | Stock | 24.38 | 24.39 | 24.38 | 24.39 | 1700.0 |
| 2006-07-26 18:00:00 | MSFT | Stock | 24.38 | 24.38 | 24.366 | 24.37 | 5961.0 |
| 2006-07-26 08:00:00 | NVDA | Stock | 0.3425 | 0.3425 | 0.3425 | 0.3425 | 11280.0 |
| 2006-07-26 09:00:00 | NVDA | Stock | 0.335 | 0.3365 | 0.335 | 0.3358 | 153000.0 |
| 2006-07-26 09:30:00 | NVDA | Stock | 0.3375 | 0.3392 | 0.3295 | 0.3352 | 48720360.0 |
| 2006-07-26 10:00:00 | NVDA | Stock | 0.3352 | 0.3352 | 0.3287 | 0.3315 | 41508660.0 |
| 2006-07-26 10:30:00 | NVDA | Stock | 0.3313 | 0.3313 | 0.3275 | 0.328 | 36233100.0 |
> showing 50 of 50,251 rows — these rows as CSV