PREVIEW / stock_30min / 2006-09-18
file: by_date/stock_30min/2006/2006-09-18.parquet size: 906 KB rows: 49,496 symbols: 2,361
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-18 07:30:00 | AAPL | Stock | 2.6475 | 2.6475 | 2.6446 | 2.6446 | 5600.0 |
| 2006-09-18 08:00:00 | AAPL | Stock | 2.6432 | 2.6464 | 2.6354 | 2.6375 | 681800.0 |
| 2006-09-18 08:30:00 | AAPL | Stock | 2.6393 | 2.6393 | 2.625 | 2.6321 | 1088108.0 |
| 2006-09-18 09:00:00 | AAPL | Stock | 2.6321 | 2.6389 | 2.63 | 2.6357 | 1099980.0 |
| 2006-09-18 09:30:00 | AAPL | Stock | 2.6357 | 2.6464 | 2.6264 | 2.6361 | 87745112.0 |
| 2006-09-18 10:00:00 | AAPL | Stock | 2.6361 | 2.6368 | 2.6179 | 2.6261 | 72429140.0 |
| 2006-09-18 10:30:00 | AAPL | Stock | 2.6264 | 2.6386 | 2.6229 | 2.6268 | 52292212.0 |
| 2006-09-18 11:00:00 | AAPL | Stock | 2.6268 | 2.6332 | 2.6218 | 2.6307 | 33053104.0 |
| 2006-09-18 11:30:00 | AAPL | Stock | 2.6304 | 2.6543 | 2.6279 | 2.6507 | 63237300.0 |
| 2006-09-18 12:00:00 | AAPL | Stock | 2.65 | 2.655 | 2.6439 | 2.645 | 37418444.0 |
| 2006-09-18 12:30:00 | AAPL | Stock | 2.6446 | 2.6614 | 2.6393 | 2.6607 | 44442832.0 |
| 2006-09-18 13:00:00 | AAPL | Stock | 2.6607 | 2.6736 | 2.6543 | 2.6657 | 54598908.0 |
| 2006-09-18 13:30:00 | AAPL | Stock | 2.6657 | 2.6668 | 2.6446 | 2.6479 | 48847596.0 |
| 2006-09-18 14:00:00 | AAPL | Stock | 2.6475 | 2.6507 | 2.6375 | 2.64 | 51885092.0 |
| 2006-09-18 14:30:00 | AAPL | Stock | 2.64 | 2.6425 | 2.6257 | 2.6389 | 51504152.0 |
| 2006-09-18 15:00:00 | AAPL | Stock | 2.6389 | 2.6493 | 2.6329 | 2.6432 | 41644624.0 |
| 2006-09-18 15:30:00 | AAPL | Stock | 2.6432 | 2.6493 | 2.635 | 2.6386 | 52312372.0 |
| 2006-09-18 16:00:00 | AAPL | Stock | 2.6375 | 2.6407 | 2.6332 | 2.6389 | 1518636.0 |
| 2006-09-18 16:30:00 | AAPL | Stock | 2.6382 | 2.6382 | 2.6375 | 2.6375 | 28700.0 |
| 2006-09-18 17:00:00 | AAPL | Stock | 2.6361 | 2.6361 | 2.6361 | 2.6361 | 14364.0 |
| 2006-09-18 17:30:00 | AAPL | Stock | 2.6368 | 2.6382 | 2.6368 | 2.6382 | 60200.0 |
| 2006-09-18 18:00:00 | AAPL | Stock | 2.6389 | 2.6404 | 2.6389 | 2.6404 | 51016.0 |
| 2006-09-18 05:00:00 | MSFT | Stock | 26.8 | 26.8 | 26.8 | 26.8 | 100.0 |
| 2006-09-18 05:30:00 | MSFT | Stock | 26.8 | 26.8 | 26.8 | 26.8 | 400.0 |
| 2006-09-18 07:00:00 | MSFT | Stock | 26.77 | 26.77 | 26.77 | 26.77 | 1000.0 |
| 2006-09-18 08:00:00 | MSFT | Stock | 26.77 | 26.79 | 26.74 | 26.79 | 12375.0 |
| 2006-09-18 08:30:00 | MSFT | Stock | 26.77 | 26.8 | 26.76 | 26.78 | 63330.0 |
| 2006-09-18 09:00:00 | MSFT | Stock | 26.76 | 26.8 | 26.69 | 26.74 | 118890.0 |
| 2006-09-18 09:30:00 | MSFT | Stock | 26.74 | 26.89 | 26.67 | 26.86 | 6215947.0 |
| 2006-09-18 10:00:00 | MSFT | Stock | 26.85 | 26.99 | 26.83 | 26.98 | 5056715.0 |
| 2006-09-18 10:30:00 | MSFT | Stock | 26.98 | 27.04 | 26.93 | 26.96 | 8387993.0 |
| 2006-09-18 11:00:00 | MSFT | Stock | 26.96 | 26.96 | 26.83 | 26.93 | 4433257.0 |
| 2006-09-18 11:30:00 | MSFT | Stock | 26.93 | 26.98 | 26.92 | 26.93 | 2738085.0 |
| 2006-09-18 12:00:00 | MSFT | Stock | 26.94 | 26.94 | 26.87 | 26.883 | 2223858.0 |
| 2006-09-18 12:30:00 | MSFT | Stock | 26.89 | 26.92 | 26.87 | 26.912 | 1549201.0 |
| 2006-09-18 13:00:00 | MSFT | Stock | 26.91 | 26.92 | 26.88 | 26.89 | 1627076.0 |
| 2006-09-18 13:30:00 | MSFT | Stock | 26.89 | 26.9 | 26.76 | 26.79 | 2266229.0 |
| 2006-09-18 14:00:00 | MSFT | Stock | 26.79 | 26.86 | 26.78 | 26.85 | 1916765.0 |
| 2006-09-18 14:30:00 | MSFT | Stock | 26.85 | 26.851 | 26.73 | 26.79 | 2845739.0 |
| 2006-09-18 15:00:00 | MSFT | Stock | 26.79 | 26.8 | 26.72 | 26.762 | 2436321.0 |
| 2006-09-18 15:30:00 | MSFT | Stock | 26.76 | 26.83 | 26.712 | 26.8 | 5971669.0 |
| 2006-09-18 16:00:00 | MSFT | Stock | 26.79 | 26.84 | 26.77 | 26.77 | 194428.0 |
| 2006-09-18 16:30:00 | MSFT | Stock | 26.79 | 26.8 | 26.76 | 26.8 | 5240.0 |
| 2006-09-18 17:00:00 | MSFT | Stock | 26.82 | 26.82 | 26.79 | 26.79 | 277.0 |
| 2006-09-18 17:30:00 | MSFT | Stock | 26.82 | 26.82 | 26.78 | 26.78 | 2310.0 |
| 2006-09-18 08:00:00 | NVDA | Stock | 0.4955 | 0.4958 | 0.495 | 0.4958 | 96000.0 |
| 2006-09-18 08:30:00 | NVDA | Stock | 0.4958 | 0.4958 | 0.4947 | 0.4948 | 577200.0 |
| 2006-09-18 09:00:00 | NVDA | Stock | 0.4948 | 0.4962 | 0.4945 | 0.4958 | 100800.0 |
| 2006-09-18 09:30:00 | NVDA | Stock | 0.494 | 0.5 | 0.4925 | 0.4987 | 66605280.0 |
| 2006-09-18 10:00:00 | NVDA | Stock | 0.4987 | 0.5002 | 0.4973 | 0.5 | 46240620.0 |
> showing 50 of 49,496 rows — these rows as CSV