PREVIEW / stock_30min / 2006-09-29
file: by_date/stock_30min/2006/2006-09-29.parquet size: 938 KB rows: 50,768 symbols: 2,387
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-09-29 07:30:00 | AAPL | Stock | 2.7607 | 2.7632 | 2.7604 | 2.7632 | 33600.0 |
| 2006-09-29 08:00:00 | AAPL | Stock | 2.7625 | 2.7679 | 2.76 | 2.7643 | 977368.0 |
| 2006-09-29 08:30:00 | AAPL | Stock | 2.7621 | 2.7679 | 2.7607 | 2.7639 | 844900.0 |
| 2006-09-29 09:00:00 | AAPL | Stock | 2.7643 | 2.7664 | 2.7532 | 2.7539 | 697172.0 |
| 2006-09-29 09:30:00 | AAPL | Stock | 2.7539 | 2.7686 | 2.7386 | 2.7486 | 84629188.0 |
| 2006-09-29 10:00:00 | AAPL | Stock | 2.7493 | 2.7589 | 2.7454 | 2.7525 | 47893328.0 |
| 2006-09-29 10:30:00 | AAPL | Stock | 2.7525 | 2.755 | 2.7489 | 2.7525 | 42342496.0 |
| 2006-09-29 11:00:00 | AAPL | Stock | 2.7518 | 2.755 | 2.7461 | 2.7482 | 27441792.0 |
| 2006-09-29 11:30:00 | AAPL | Stock | 2.7479 | 2.7546 | 2.7471 | 2.7511 | 18900476.0 |
| 2006-09-29 12:00:00 | AAPL | Stock | 2.7514 | 2.7529 | 2.7482 | 2.7525 | 12325180.0 |
| 2006-09-29 12:30:00 | AAPL | Stock | 2.7525 | 2.7536 | 2.7475 | 2.7536 | 11408544.0 |
| 2006-09-29 13:00:00 | AAPL | Stock | 2.7536 | 2.7575 | 2.75 | 2.7536 | 24615612.0 |
| 2006-09-29 13:30:00 | AAPL | Stock | 2.7536 | 2.7579 | 2.7511 | 2.7564 | 17394552.0 |
| 2006-09-29 14:00:00 | AAPL | Stock | 2.7564 | 2.7589 | 2.7536 | 2.7568 | 15518944.0 |
| 2006-09-29 14:30:00 | AAPL | Stock | 2.7571 | 2.7589 | 2.75 | 2.7536 | 17701264.0 |
| 2006-09-29 15:00:00 | AAPL | Stock | 2.7536 | 2.7546 | 2.7464 | 2.7518 | 22797264.0 |
| 2006-09-29 15:30:00 | AAPL | Stock | 2.7516 | 2.7543 | 2.7479 | 2.7482 | 40971448.0 |
| 2006-09-29 16:00:00 | AAPL | Stock | 2.7479 | 2.7529 | 2.745 | 2.745 | 1676276.0 |
| 2006-09-29 16:30:00 | AAPL | Stock | 2.745 | 2.7464 | 2.745 | 2.745 | 26600.0 |
| 2006-09-29 17:00:00 | AAPL | Stock | 2.7464 | 2.7511 | 2.7429 | 2.7439 | 1061620.0 |
| 2006-09-29 17:30:00 | AAPL | Stock | 2.7446 | 2.7446 | 2.7439 | 2.7446 | 70000.0 |
| 2006-09-29 18:00:00 | AAPL | Stock | 2.7464 | 2.7464 | 2.7454 | 2.7454 | 36120.0 |
| 2006-09-29 18:30:00 | AAPL | Stock | 2.7457 | 2.7457 | 2.7457 | 2.7457 | 22400.0 |
| 2006-09-29 19:00:00 | AAPL | Stock | 2.7457 | 2.7457 | 2.7457 | 2.7457 | 19600.0 |
| 2006-09-29 08:00:00 | MSFT | Stock | 27.4 | 27.43 | 27.4 | 27.43 | 8485.0 |
| 2006-09-29 08:30:00 | MSFT | Stock | 27.42 | 27.44 | 27.41 | 27.44 | 3415.0 |
| 2006-09-29 09:00:00 | MSFT | Stock | 27.41 | 27.41 | 27.31 | 27.35 | 177534.0 |
| 2006-09-29 09:30:00 | MSFT | Stock | 27.35 | 27.39 | 27.21 | 27.24 | 5079561.0 |
| 2006-09-29 10:00:00 | MSFT | Stock | 27.24 | 27.4 | 27.24 | 27.39 | 3967622.0 |
| 2006-09-29 10:30:00 | MSFT | Stock | 27.39 | 27.39 | 27.32 | 27.32 | 2314449.0 |
| 2006-09-29 11:00:00 | MSFT | Stock | 27.29 | 27.38 | 27.29 | 27.32 | 1615878.0 |
| 2006-09-29 11:30:00 | MSFT | Stock | 27.32 | 27.41 | 27.3 | 27.41 | 1978196.0 |
| 2006-09-29 12:00:00 | MSFT | Stock | 27.41 | 27.42 | 27.37 | 27.39 | 1369748.0 |
| 2006-09-29 12:30:00 | MSFT | Stock | 27.39 | 27.4 | 27.33 | 27.36 | 1365533.0 |
| 2006-09-29 13:00:00 | MSFT | Stock | 27.37 | 27.4 | 27.33 | 27.333 | 1070689.0 |
| 2006-09-29 13:30:00 | MSFT | Stock | 27.33 | 27.4 | 27.33 | 27.37 | 1920357.0 |
| 2006-09-29 14:00:00 | MSFT | Stock | 27.37 | 27.38 | 27.33 | 27.36 | 1190843.0 |
| 2006-09-29 14:30:00 | MSFT | Stock | 27.36 | 27.36 | 27.31 | 27.35 | 1420526.0 |
| 2006-09-29 15:00:00 | MSFT | Stock | 27.34 | 27.34 | 27.29 | 27.323 | 1862385.0 |
| 2006-09-29 15:30:00 | MSFT | Stock | 27.34 | 27.39 | 27.31 | 27.33 | 4453587.0 |
| 2006-09-29 16:00:00 | MSFT | Stock | 27.32 | 27.38 | 27.29 | 27.33 | 775589.0 |
| 2006-09-29 16:30:00 | MSFT | Stock | 27.3 | 27.33 | 27.3 | 27.33 | 450.0 |
| 2006-09-29 17:00:00 | MSFT | Stock | 27.3 | 27.33 | 27.3 | 27.33 | 85700.0 |
| 2006-09-29 17:30:00 | MSFT | Stock | 27.32 | 27.32 | 27.32 | 27.32 | 100.0 |
| 2006-09-29 18:00:00 | MSFT | Stock | 27.3 | 27.33 | 27.3 | 27.33 | 716.0 |
| 2006-09-29 18:30:00 | MSFT | Stock | 27.33 | 27.33 | 27.33 | 27.33 | 834.0 |
| 2006-09-29 08:00:00 | NVDA | Stock | 0.4958 | 0.5 | 0.4958 | 0.4987 | 252000.0 |
| 2006-09-29 08:30:00 | NVDA | Stock | 0.4983 | 0.4983 | 0.4983 | 0.4983 | 66000.0 |
| 2006-09-29 09:00:00 | NVDA | Stock | 0.4982 | 0.4983 | 0.4942 | 0.4965 | 1752000.0 |
| 2006-09-29 09:30:00 | NVDA | Stock | 0.4962 | 0.4975 | 0.4905 | 0.493 | 52912980.0 |
> showing 50 of 50,768 rows — these rows as CSV