PREVIEW / stock_30min / 2005-07-07
file: by_date/stock_30min/2005/2005-07-07.parquet size: 842 KB rows: 45,656 symbols: 2,014
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-07 08:00:00 | AAPL | Stock | 1.3018 | 1.3289 | 1.2964 | 1.3 | 3354820.0 |
| 2005-07-07 08:30:00 | AAPL | Stock | 1.3 | 1.3107 | 1.3 | 1.3068 | 1293600.0 |
| 2005-07-07 09:00:00 | AAPL | Stock | 1.3071 | 1.3189 | 1.3057 | 1.315 | 1653988.0 |
| 2005-07-07 09:30:00 | AAPL | Stock | 1.3146 | 1.3364 | 1.3143 | 1.3189 | 81435424.0 |
| 2005-07-07 10:00:00 | AAPL | Stock | 1.3182 | 1.3286 | 1.3161 | 1.32 | 44933504.0 |
| 2005-07-07 10:30:00 | AAPL | Stock | 1.32 | 1.3246 | 1.3157 | 1.3182 | 34225408.0 |
| 2005-07-07 11:00:00 | AAPL | Stock | 1.3189 | 1.325 | 1.3157 | 1.3232 | 23011240.0 |
| 2005-07-07 11:30:00 | AAPL | Stock | 1.3236 | 1.3286 | 1.3211 | 1.3282 | 24334856.0 |
| 2005-07-07 12:00:00 | AAPL | Stock | 1.3282 | 1.3332 | 1.3261 | 1.3282 | 24780896.0 |
| 2005-07-07 12:30:00 | AAPL | Stock | 1.3282 | 1.3293 | 1.3264 | 1.3282 | 7102200.0 |
| 2005-07-07 13:00:00 | AAPL | Stock | 1.3279 | 1.3307 | 1.3268 | 1.3307 | 6659044.0 |
| 2005-07-07 13:30:00 | AAPL | Stock | 1.3307 | 1.3375 | 1.3296 | 1.3325 | 21368788.0 |
| 2005-07-07 14:00:00 | AAPL | Stock | 1.3329 | 1.3329 | 1.3286 | 1.3311 | 15684032.0 |
| 2005-07-07 14:30:00 | AAPL | Stock | 1.3311 | 1.3346 | 1.3304 | 1.3339 | 14449540.0 |
| 2005-07-07 15:00:00 | AAPL | Stock | 1.3339 | 1.3411 | 1.3336 | 1.3393 | 22433068.0 |
| 2005-07-07 15:30:00 | AAPL | Stock | 1.3393 | 1.3486 | 1.3389 | 1.345 | 51492980.0 |
| 2005-07-07 16:00:00 | AAPL | Stock | 1.3446 | 1.3482 | 1.34 | 1.3482 | 1033760.0 |
| 2005-07-07 16:30:00 | AAPL | Stock | 1.3489 | 1.35 | 1.3446 | 1.3464 | 86800.0 |
| 2005-07-07 17:00:00 | AAPL | Stock | 1.3482 | 1.3482 | 1.3475 | 1.3475 | 33600.0 |
| 2005-07-07 17:30:00 | AAPL | Stock | 1.3479 | 1.3479 | 1.3479 | 1.3479 | 16240.0 |
| 2005-07-07 18:00:00 | AAPL | Stock | 1.3461 | 1.3475 | 1.3454 | 1.3475 | 77000.0 |
| 2005-07-07 07:00:00 | MSFT | Stock | 24.24 | 24.24 | 24.22 | 24.22 | 5630.0 |
| 2005-07-07 07:30:00 | MSFT | Stock | 24.33 | 24.5 | 24.29 | 24.45 | 36400.0 |
| 2005-07-07 08:00:00 | MSFT | Stock | 24.45 | 24.7 | 24.41 | 24.53 | 254161.0 |
| 2005-07-07 08:30:00 | MSFT | Stock | 24.53 | 24.57 | 24.49 | 24.55 | 142241.0 |
| 2005-07-07 09:00:00 | MSFT | Stock | 24.55 | 24.61 | 24.53 | 24.57 | 158139.0 |
| 2005-07-07 09:30:00 | MSFT | Stock | 24.58 | 24.66 | 24.5 | 24.51 | 10613407.0 |
| 2005-07-07 10:00:00 | MSFT | Stock | 24.51 | 24.63 | 24.51 | 24.55 | 7662892.0 |
| 2005-07-07 10:30:00 | MSFT | Stock | 24.55 | 24.582 | 24.51 | 24.53 | 8812445.0 |
| 2005-07-07 11:00:00 | MSFT | Stock | 24.54 | 24.6 | 24.51 | 24.58 | 5428971.0 |
| 2005-07-07 11:30:00 | MSFT | Stock | 24.57 | 24.63 | 24.53 | 24.61 | 3797139.0 |
| 2005-07-07 12:00:00 | MSFT | Stock | 24.62 | 24.71 | 24.58 | 24.63 | 3949692.0 |
| 2005-07-07 12:30:00 | MSFT | Stock | 24.63 | 24.63 | 24.56 | 24.57 | 5291212.0 |
| 2005-07-07 13:00:00 | MSFT | Stock | 24.57 | 24.61 | 24.54 | 24.56 | 2519819.0 |
| 2005-07-07 13:30:00 | MSFT | Stock | 24.56 | 24.67 | 24.56 | 24.59 | 3879869.0 |
| 2005-07-07 14:00:00 | MSFT | Stock | 24.58 | 24.621 | 24.56 | 24.57 | 3940248.0 |
| 2005-07-07 14:30:00 | MSFT | Stock | 24.57 | 24.59 | 24.54 | 24.59 | 3935360.0 |
| 2005-07-07 15:00:00 | MSFT | Stock | 24.59 | 24.68 | 24.57 | 24.59 | 6740452.0 |
| 2005-07-07 15:30:00 | MSFT | Stock | 24.59 | 24.69 | 24.578 | 24.62 | 9550131.0 |
| 2005-07-07 16:00:00 | MSFT | Stock | 24.63 | 24.7 | 24.63 | 24.7 | 1078142.0 |
| 2005-07-07 16:30:00 | MSFT | Stock | 24.66 | 24.69 | 24.66 | 24.69 | 4579.0 |
| 2005-07-07 17:00:00 | MSFT | Stock | 24.69 | 24.69 | 24.69 | 24.69 | 4200.0 |
| 2005-07-07 17:30:00 | MSFT | Stock | 24.68 | 24.68 | 24.67 | 24.67 | 1700.0 |
| 2005-07-07 18:00:00 | MSFT | Stock | 24.66 | 24.68 | 24.65 | 24.67 | 3796.0 |
| 2005-07-07 08:00:00 | NVDA | Stock | 0.2281 | 0.2285 | 0.2258 | 0.2258 | 1306800.0 |
| 2005-07-07 08:30:00 | NVDA | Stock | 0.2282 | 0.2282 | 0.228 | 0.2282 | 144000.0 |
| 2005-07-07 09:00:00 | NVDA | Stock | 0.2283 | 0.2304 | 0.2279 | 0.2297 | 1842240.0 |
| 2005-07-07 09:30:00 | NVDA | Stock | 0.2296 | 0.2333 | 0.2295 | 0.2297 | 84792480.0 |
| 2005-07-07 10:00:00 | NVDA | Stock | 0.2296 | 0.2312 | 0.2296 | 0.2304 | 34440480.0 |
| 2005-07-07 10:30:00 | NVDA | Stock | 0.2304 | 0.2307 | 0.2289 | 0.2295 | 32583840.0 |
> showing 50 of 45,656 rows — these rows as CSV