PREVIEW / stock_30min / 2006-06-29
file: by_date/stock_30min/2006/2006-06-29.parquet size: 948 KB rows: 51,362 symbols: 2,285
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-06-29 08:00:00 | AAPL | Stock | 2.0082 | 2.0089 | 2.005 | 2.0082 | 358204.0 |
| 2006-06-29 08:30:00 | AAPL | Stock | 2.0086 | 2.0129 | 2.0036 | 2.0129 | 688100.0 |
| 2006-06-29 09:00:00 | AAPL | Stock | 2.0129 | 2.0371 | 2.0111 | 2.0296 | 5756184.0 |
| 2006-06-29 09:30:00 | AAPL | Stock | 2.0271 | 2.03 | 2.0139 | 2.02 | 74418120.0 |
| 2006-06-29 10:00:00 | AAPL | Stock | 2.0204 | 2.03 | 2.0186 | 2.0232 | 43961372.0 |
| 2006-06-29 10:30:00 | AAPL | Stock | 2.0236 | 2.0343 | 2.0225 | 2.03 | 43014160.0 |
| 2006-06-29 11:00:00 | AAPL | Stock | 2.03 | 2.0379 | 2.0296 | 2.0371 | 47334392.0 |
| 2006-06-29 11:30:00 | AAPL | Stock | 2.0368 | 2.0432 | 2.035 | 2.0386 | 38076192.0 |
| 2006-06-29 12:00:00 | AAPL | Stock | 2.0386 | 2.0389 | 2.03 | 2.0311 | 25929176.0 |
| 2006-06-29 12:30:00 | AAPL | Stock | 2.0318 | 2.0335 | 2.0257 | 2.0279 | 19828704.0 |
| 2006-06-29 13:00:00 | AAPL | Stock | 2.0279 | 2.0314 | 2.0239 | 2.0306 | 19581184.0 |
| 2006-06-29 13:30:00 | AAPL | Stock | 2.0307 | 2.0329 | 2.0264 | 2.0293 | 15217916.0 |
| 2006-06-29 14:00:00 | AAPL | Stock | 2.0293 | 2.0693 | 2.0293 | 2.0589 | 98410620.0 |
| 2006-06-29 14:30:00 | AAPL | Stock | 2.0596 | 2.0679 | 2.0439 | 2.0639 | 111582856.0 |
| 2006-06-29 15:00:00 | AAPL | Stock | 2.0636 | 2.0993 | 2.0636 | 2.0993 | 127069040.0 |
| 2006-06-29 15:30:00 | AAPL | Stock | 2.0989 | 2.1104 | 2.0939 | 2.1071 | 139110328.0 |
| 2006-06-29 16:00:00 | AAPL | Stock | 2.1082 | 2.1132 | 2.1061 | 2.1075 | 4666144.0 |
| 2006-06-29 16:30:00 | AAPL | Stock | 2.1075 | 2.1079 | 2.0318 | 2.0443 | 30567404.0 |
| 2006-06-29 17:00:00 | AAPL | Stock | 2.0443 | 2.1061 | 2.0339 | 2.05 | 12310200.0 |
| 2006-06-29 17:30:00 | AAPL | Stock | 2.0486 | 2.0643 | 2.0464 | 2.0536 | 4123700.0 |
| 2006-06-29 18:00:00 | AAPL | Stock | 2.0536 | 2.11 | 2.045 | 2.0464 | 1235696.0 |
| 2006-06-29 08:00:00 | MSFT | Stock | 23.22 | 23.25 | 23.2 | 23.2 | 2660.0 |
| 2006-06-29 08:30:00 | MSFT | Stock | 23.25 | 23.28 | 23.24 | 23.28 | 19380.0 |
| 2006-06-29 09:00:00 | MSFT | Stock | 23.28 | 23.32 | 23.23 | 23.31 | 167597.0 |
| 2006-06-29 09:30:00 | MSFT | Stock | 23.32 | 23.49 | 23.28 | 23.47 | 10394184.0 |
| 2006-06-29 10:00:00 | MSFT | Stock | 23.46 | 23.55 | 23.46 | 23.49 | 7820914.0 |
| 2006-06-29 10:30:00 | MSFT | Stock | 23.49 | 23.51 | 23.45 | 23.48 | 5145118.0 |
| 2006-06-29 11:00:00 | MSFT | Stock | 23.49 | 23.56 | 23.418 | 23.52 | 7467979.0 |
| 2006-06-29 11:30:00 | MSFT | Stock | 23.52 | 23.53 | 23.45 | 23.46 | 3848389.0 |
| 2006-06-29 12:00:00 | MSFT | Stock | 23.45 | 23.5 | 23.39 | 23.39 | 2775566.0 |
| 2006-06-29 12:30:00 | MSFT | Stock | 23.4 | 23.49 | 23.35 | 23.35 | 3267899.0 |
| 2006-06-29 13:00:00 | MSFT | Stock | 23.36 | 23.41 | 23.31 | 23.35 | 3107862.0 |
| 2006-06-29 13:30:00 | MSFT | Stock | 23.358 | 23.49 | 23.22 | 23.24 | 3157048.0 |
| 2006-06-29 14:00:00 | MSFT | Stock | 23.24 | 23.54 | 23.23 | 23.49 | 10073236.0 |
| 2006-06-29 14:30:00 | MSFT | Stock | 23.48 | 23.63 | 23.35 | 23.57 | 13825505.0 |
| 2006-06-29 15:00:00 | MSFT | Stock | 23.55 | 23.6 | 23.34 | 23.5 | 20163213.0 |
| 2006-06-29 15:30:00 | MSFT | Stock | 23.493 | 23.55 | 23.37 | 23.54 | 15815636.0 |
| 2006-06-29 16:00:00 | MSFT | Stock | 23.54 | 23.56 | 23.429 | 23.47 | 323057.0 |
| 2006-06-29 16:30:00 | MSFT | Stock | 23.49 | 23.54 | 23.46 | 23.46 | 65736.0 |
| 2006-06-29 17:00:00 | MSFT | Stock | 23.47 | 23.47 | 23.41 | 23.47 | 181721.0 |
| 2006-06-29 17:30:00 | MSFT | Stock | 23.45 | 23.48 | 23.41 | 23.42 | 42993.0 |
| 2006-06-29 18:00:00 | MSFT | Stock | 23.42 | 23.54 | 23.42 | 23.42 | 9660.0 |
| 2006-06-29 05:00:00 | NVDA | Stock | 0.354 | 0.354 | 0.354 | 0.354 | 30000.0 |
| 2006-06-29 06:30:00 | NVDA | Stock | 0.3427 | 0.3427 | 0.3427 | 0.3427 | 30000.0 |
| 2006-06-29 07:30:00 | NVDA | Stock | 0.3368 | 0.3368 | 0.3367 | 0.3367 | 66000.0 |
| 2006-06-29 08:00:00 | NVDA | Stock | 0.3407 | 0.3407 | 0.33 | 0.33 | 2536260.0 |
| 2006-06-29 08:30:00 | NVDA | Stock | 0.33 | 0.3357 | 0.33 | 0.333 | 2140140.0 |
| 2006-06-29 09:00:00 | NVDA | Stock | 0.333 | 0.3357 | 0.3317 | 0.3333 | 2814060.0 |
| 2006-06-29 09:30:00 | NVDA | Stock | 0.3333 | 0.339 | 0.3322 | 0.3373 | 100696380.0 |
| 2006-06-29 10:00:00 | NVDA | Stock | 0.3373 | 0.3378 | 0.3348 | 0.3377 | 56565000.0 |
> showing 50 of 51,362 rows — these rows as CSV