PREVIEW / stock_30min / 2005-08-19
file: by_date/stock_30min/2005/2005-08-19.parquet size: 802 KB rows: 43,989 symbols: 2,064
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-08-19 08:00:00 | AAPL | Stock | 1.6646 | 1.665 | 1.6643 | 1.665 | 109200.0 |
| 2005-08-19 08:30:00 | AAPL | Stock | 1.6639 | 1.6639 | 1.6607 | 1.6607 | 218400.0 |
| 2005-08-19 09:00:00 | AAPL | Stock | 1.6621 | 1.6639 | 1.6511 | 1.6543 | 2984100.0 |
| 2005-08-19 09:30:00 | AAPL | Stock | 1.6529 | 1.6671 | 1.65 | 1.665 | 78342880.0 |
| 2005-08-19 10:00:00 | AAPL | Stock | 1.6654 | 1.6679 | 1.6361 | 1.6471 | 88152708.0 |
| 2005-08-19 10:30:00 | AAPL | Stock | 1.6461 | 1.6486 | 1.6379 | 1.6439 | 30324756.0 |
| 2005-08-19 11:00:00 | AAPL | Stock | 1.6439 | 1.6454 | 1.635 | 1.6382 | 32589144.0 |
| 2005-08-19 11:30:00 | AAPL | Stock | 1.6386 | 1.6457 | 1.6379 | 1.6379 | 18776940.0 |
| 2005-08-19 12:00:00 | AAPL | Stock | 1.6379 | 1.6436 | 1.6368 | 1.6386 | 11237128.0 |
| 2005-08-19 12:30:00 | AAPL | Stock | 1.6389 | 1.64 | 1.635 | 1.6382 | 13424460.0 |
| 2005-08-19 13:00:00 | AAPL | Stock | 1.6382 | 1.6407 | 1.6346 | 1.6379 | 12513564.0 |
| 2005-08-19 13:30:00 | AAPL | Stock | 1.6379 | 1.6389 | 1.6361 | 1.6375 | 7725396.0 |
| 2005-08-19 14:00:00 | AAPL | Stock | 1.6379 | 1.6404 | 1.6375 | 1.6396 | 11535048.0 |
| 2005-08-19 14:30:00 | AAPL | Stock | 1.6396 | 1.6404 | 1.6371 | 1.6379 | 15483720.0 |
| 2005-08-19 15:00:00 | AAPL | Stock | 1.6379 | 1.64 | 1.6368 | 1.6393 | 9815344.0 |
| 2005-08-19 15:30:00 | AAPL | Stock | 1.6393 | 1.6539 | 1.635 | 1.6368 | 35330820.0 |
| 2005-08-19 16:00:00 | AAPL | Stock | 1.6361 | 1.6387 | 1.6357 | 1.6379 | 1445108.0 |
| 2005-08-19 16:30:00 | AAPL | Stock | 1.6379 | 1.6379 | 1.6368 | 1.6375 | 100800.0 |
| 2005-08-19 17:00:00 | AAPL | Stock | 1.6379 | 1.6379 | 1.6364 | 1.6364 | 60200.0 |
| 2005-08-19 17:30:00 | AAPL | Stock | 1.6364 | 1.6375 | 1.6364 | 1.6364 | 54880.0 |
| 2005-08-19 18:00:00 | AAPL | Stock | 1.6375 | 1.6375 | 1.6375 | 1.6375 | 56140.0 |
| 2005-08-19 08:00:00 | MSFT | Stock | 26.9 | 26.91 | 26.82 | 26.86 | 56822.0 |
| 2005-08-19 08:30:00 | MSFT | Stock | 26.86 | 26.88 | 26.86 | 26.87 | 6800.0 |
| 2005-08-19 09:00:00 | MSFT | Stock | 26.87 | 26.95 | 26.85 | 26.85 | 136550.0 |
| 2005-08-19 09:30:00 | MSFT | Stock | 26.85 | 26.89 | 26.7 | 26.8 | 8164677.0 |
| 2005-08-19 10:00:00 | MSFT | Stock | 26.8 | 26.851 | 26.77 | 26.83 | 2788344.0 |
| 2005-08-19 10:30:00 | MSFT | Stock | 26.83 | 26.841 | 26.73 | 26.78 | 1828287.0 |
| 2005-08-19 11:00:00 | MSFT | Stock | 26.78 | 26.86 | 26.75 | 26.838 | 2744298.0 |
| 2005-08-19 11:30:00 | MSFT | Stock | 26.84 | 26.91 | 26.8 | 26.86 | 2147722.0 |
| 2005-08-19 12:00:00 | MSFT | Stock | 26.87 | 26.9 | 26.81 | 26.81 | 1755205.0 |
| 2005-08-19 12:30:00 | MSFT | Stock | 26.81 | 26.83 | 26.79 | 26.81 | 3017947.0 |
| 2005-08-19 13:00:00 | MSFT | Stock | 26.81 | 26.9 | 26.77 | 26.78 | 1793111.0 |
| 2005-08-19 13:30:00 | MSFT | Stock | 26.78 | 26.8 | 26.75 | 26.8 | 996276.0 |
| 2005-08-19 14:00:00 | MSFT | Stock | 26.79 | 26.8 | 26.77 | 26.77 | 799157.0 |
| 2005-08-19 14:30:00 | MSFT | Stock | 26.77 | 26.8 | 26.73 | 26.78 | 2525436.0 |
| 2005-08-19 15:00:00 | MSFT | Stock | 26.77 | 26.84 | 26.77 | 26.84 | 2077334.0 |
| 2005-08-19 15:30:00 | MSFT | Stock | 26.84 | 26.868 | 26.72 | 26.72 | 3194796.0 |
| 2005-08-19 16:00:00 | MSFT | Stock | 26.73 | 26.752 | 26.7 | 26.73 | 282998.0 |
| 2005-08-19 16:30:00 | MSFT | Stock | 26.72 | 26.73 | 26.71 | 26.73 | 17800.0 |
| 2005-08-19 17:00:00 | MSFT | Stock | 26.73 | 26.73 | 26.7 | 26.7 | 13004.0 |
| 2005-08-19 17:30:00 | MSFT | Stock | 26.73 | 26.73 | 26.73 | 26.73 | 863.0 |
| 2005-08-19 18:00:00 | MSFT | Stock | 26.73 | 26.76 | 26.71 | 26.73 | 3708.0 |
| 2005-08-19 09:00:00 | NVDA | Stock | 0.2454 | 0.2462 | 0.2454 | 0.2455 | 208680.0 |
| 2005-08-19 09:30:00 | NVDA | Stock | 0.2455 | 0.2462 | 0.2426 | 0.2445 | 84397680.0 |
| 2005-08-19 10:00:00 | NVDA | Stock | 0.2445 | 0.2455 | 0.244 | 0.2445 | 60771480.0 |
| 2005-08-19 10:30:00 | NVDA | Stock | 0.2444 | 0.2452 | 0.2439 | 0.2451 | 26515680.0 |
| 2005-08-19 11:00:00 | NVDA | Stock | 0.2451 | 0.2452 | 0.2439 | 0.2445 | 13056600.0 |
| 2005-08-19 11:30:00 | NVDA | Stock | 0.2443 | 0.245 | 0.244 | 0.2446 | 34463280.0 |
| 2005-08-19 12:00:00 | NVDA | Stock | 0.2445 | 0.2447 | 0.2442 | 0.2442 | 6244560.0 |
| 2005-08-19 12:30:00 | NVDA | Stock | 0.2442 | 0.2442 | 0.2429 | 0.2432 | 27815160.0 |
> showing 50 of 43,989 rows — these rows as CSV