PREVIEW / stock_30min / 2006-01-25
file: by_date/stock_30min/2006/2006-01-25.parquet size: 897 KB rows: 47,988 symbols: 2,179
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-01-25 04:30:00 | AAPL | Stock | 2.7554 | 2.7554 | 2.7554 | 2.7554 | 8400.0 |
| 2006-01-25 05:30:00 | AAPL | Stock | 2.7571 | 2.7571 | 2.7571 | 2.7571 | 11200.0 |
| 2006-01-25 07:00:00 | AAPL | Stock | 2.7711 | 2.78 | 2.7607 | 2.7607 | 36400.0 |
| 2006-01-25 07:30:00 | AAPL | Stock | 2.7643 | 2.7725 | 2.7643 | 2.7696 | 131600.0 |
| 2006-01-25 08:00:00 | AAPL | Stock | 2.7729 | 2.785 | 2.7646 | 2.7746 | 3301564.0 |
| 2006-01-25 08:30:00 | AAPL | Stock | 2.7757 | 2.7757 | 2.7625 | 2.7625 | 1845312.0 |
| 2006-01-25 09:00:00 | AAPL | Stock | 2.7625 | 2.7796 | 2.7596 | 2.7639 | 3619896.0 |
| 2006-01-25 09:30:00 | AAPL | Stock | 2.7639 | 2.7679 | 2.6875 | 2.6936 | 161172844.0 |
| 2006-01-25 10:00:00 | AAPL | Stock | 2.6936 | 2.7032 | 2.6161 | 2.6504 | 282732212.0 |
| 2006-01-25 10:30:00 | AAPL | Stock | 2.65 | 2.69 | 2.6332 | 2.6832 | 145049492.0 |
| 2006-01-25 11:00:00 | AAPL | Stock | 2.6829 | 2.7 | 2.6786 | 2.6879 | 117154492.0 |
| 2006-01-25 11:30:00 | AAPL | Stock | 2.6875 | 2.6895 | 2.6461 | 2.6636 | 94305400.0 |
| 2006-01-25 12:00:00 | AAPL | Stock | 2.6632 | 2.6661 | 2.6432 | 2.6479 | 44466744.0 |
| 2006-01-25 12:30:00 | AAPL | Stock | 2.6482 | 2.6693 | 2.6471 | 2.6661 | 49281904.0 |
| 2006-01-25 13:00:00 | AAPL | Stock | 2.6671 | 2.6825 | 2.6596 | 2.6739 | 48021064.0 |
| 2006-01-25 13:30:00 | AAPL | Stock | 2.674 | 2.6775 | 2.6611 | 2.6696 | 30716000.0 |
| 2006-01-25 14:00:00 | AAPL | Stock | 2.6693 | 2.6804 | 2.6596 | 2.6714 | 41323184.0 |
| 2006-01-25 14:30:00 | AAPL | Stock | 2.6714 | 2.6761 | 2.63 | 2.6371 | 83713448.0 |
| 2006-01-25 15:00:00 | AAPL | Stock | 2.6371 | 2.6568 | 2.6318 | 2.6514 | 74364864.0 |
| 2006-01-25 15:30:00 | AAPL | Stock | 2.6518 | 2.6543 | 2.6436 | 2.6493 | 68288528.0 |
| 2006-01-25 16:00:00 | AAPL | Stock | 2.6493 | 2.6687 | 2.6468 | 2.6486 | 3094196.0 |
| 2006-01-25 16:30:00 | AAPL | Stock | 2.6482 | 2.655 | 2.6482 | 2.65 | 325808.0 |
| 2006-01-25 17:00:00 | AAPL | Stock | 2.65 | 2.6518 | 2.6482 | 2.6518 | 7649824.0 |
| 2006-01-25 17:30:00 | AAPL | Stock | 2.65 | 2.6529 | 2.6482 | 2.6511 | 358120.0 |
| 2006-01-25 18:00:00 | AAPL | Stock | 2.6511 | 2.6511 | 2.6443 | 2.6468 | 295484.0 |
| 2006-01-25 06:30:00 | MSFT | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 200.0 |
| 2006-01-25 07:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 900.0 |
| 2006-01-25 07:30:00 | MSFT | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 100.0 |
| 2006-01-25 08:00:00 | MSFT | Stock | 26.35 | 26.41 | 26.35 | 26.4 | 25333.0 |
| 2006-01-25 08:30:00 | MSFT | Stock | 26.4 | 26.44 | 26.4 | 26.42 | 19950.0 |
| 2006-01-25 09:00:00 | MSFT | Stock | 26.43 | 26.44 | 26.4 | 26.41 | 212745.0 |
| 2006-01-25 09:30:00 | MSFT | Stock | 26.41 | 26.52 | 26.28 | 26.51 | 8251648.0 |
| 2006-01-25 10:00:00 | MSFT | Stock | 26.51 | 26.57 | 26.37 | 26.39 | 7114728.0 |
| 2006-01-25 10:30:00 | MSFT | Stock | 26.4 | 26.51 | 26.34 | 26.51 | 4933412.0 |
| 2006-01-25 11:00:00 | MSFT | Stock | 26.5 | 26.56 | 26.46 | 26.542 | 3634033.0 |
| 2006-01-25 11:30:00 | MSFT | Stock | 26.55 | 26.55 | 26.45 | 26.522 | 3243831.0 |
| 2006-01-25 12:00:00 | MSFT | Stock | 26.52 | 26.55 | 26.41 | 26.44 | 3117640.0 |
| 2006-01-25 12:30:00 | MSFT | Stock | 26.441 | 26.5 | 26.44 | 26.45 | 3257037.0 |
| 2006-01-25 13:00:00 | MSFT | Stock | 26.44 | 26.49 | 26.4 | 26.45 | 2777033.0 |
| 2006-01-25 13:30:00 | MSFT | Stock | 26.45 | 26.45 | 26.3 | 26.322 | 4465511.0 |
| 2006-01-25 14:00:00 | MSFT | Stock | 26.32 | 26.44 | 26.28 | 26.3 | 2785797.0 |
| 2006-01-25 14:30:00 | MSFT | Stock | 26.3 | 26.34 | 26.23 | 26.28 | 3627710.0 |
| 2006-01-25 15:00:00 | MSFT | Stock | 26.29 | 26.38 | 26.27 | 26.36 | 4322041.0 |
| 2006-01-25 15:30:00 | MSFT | Stock | 26.36 | 26.43 | 26.32 | 26.39 | 5613817.0 |
| 2006-01-25 16:00:00 | MSFT | Stock | 26.39 | 26.45 | 26.35 | 26.41 | 383765.0 |
| 2006-01-25 16:30:00 | MSFT | Stock | 26.41 | 26.42 | 26.4 | 26.4 | 149351.0 |
| 2006-01-25 17:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 8284.0 |
| 2006-01-25 17:30:00 | MSFT | Stock | 26.42 | 26.42 | 26.42 | 26.42 | 1500.0 |
| 2006-01-25 18:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 700.0 |
| 2006-01-25 08:30:00 | NVDA | Stock | 0.3709 | 0.3709 | 0.3709 | 0.3709 | 108000.0 |
> showing 50 of 47,988 rows — these rows as CSV