PREVIEW / stock_30min / 2006-11-17
file: by_date/stock_30min/2006/2006-11-17.parquet size: 959 KB rows: 52,043 symbols: 2,435
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-11-17 05:30:00 | AAPL | Stock | 3.0554 | 3.0554 | 3.0554 | 3.0554 | 14000.0 |
| 2006-11-17 07:30:00 | AAPL | Stock | 3.0511 | 3.0511 | 3.0475 | 3.0475 | 11200.0 |
| 2006-11-17 08:00:00 | AAPL | Stock | 3.0554 | 3.0586 | 3.0425 | 3.0482 | 688156.0 |
| 2006-11-17 08:30:00 | AAPL | Stock | 3.05 | 3.05 | 3.0354 | 3.0375 | 1194648.0 |
| 2006-11-17 09:00:00 | AAPL | Stock | 3.0375 | 3.0432 | 3.0375 | 3.0421 | 649600.0 |
| 2006-11-17 09:30:00 | AAPL | Stock | 3.0409 | 3.0643 | 3.0357 | 3.0607 | 98642236.0 |
| 2006-11-17 10:00:00 | AAPL | Stock | 3.0607 | 3.0621 | 3.0432 | 3.0499 | 38554628.0 |
| 2006-11-17 10:30:00 | AAPL | Stock | 3.0496 | 3.0532 | 3.0404 | 3.0404 | 30886464.0 |
| 2006-11-17 11:00:00 | AAPL | Stock | 3.0404 | 3.0471 | 3.0361 | 3.0439 | 30757580.0 |
| 2006-11-17 11:30:00 | AAPL | Stock | 3.0439 | 3.0518 | 3.0379 | 3.05 | 20110020.0 |
| 2006-11-17 12:00:00 | AAPL | Stock | 3.05 | 3.0575 | 3.0482 | 3.0536 | 22610952.0 |
| 2006-11-17 12:30:00 | AAPL | Stock | 3.0536 | 3.0693 | 3.0489 | 3.065 | 37834076.0 |
| 2006-11-17 13:00:00 | AAPL | Stock | 3.0646 | 3.0661 | 3.0396 | 3.0582 | 21968548.0 |
| 2006-11-17 13:30:00 | AAPL | Stock | 3.0586 | 3.0682 | 3.0546 | 3.0564 | 27039544.0 |
| 2006-11-17 14:00:00 | AAPL | Stock | 3.0561 | 3.0607 | 3.0482 | 3.0546 | 28367052.0 |
| 2006-11-17 14:30:00 | AAPL | Stock | 3.0539 | 3.0643 | 3.0536 | 3.0643 | 17610936.0 |
| 2006-11-17 15:00:00 | AAPL | Stock | 3.0639 | 3.0668 | 3.0554 | 3.0621 | 27856780.0 |
| 2006-11-17 15:30:00 | AAPL | Stock | 3.0621 | 3.0675 | 3.0571 | 3.0671 | 47042464.0 |
| 2006-11-17 16:00:00 | AAPL | Stock | 3.0675 | 3.0682 | 3.065 | 3.0671 | 1008168.0 |
| 2006-11-17 16:30:00 | AAPL | Stock | 3.0668 | 3.0679 | 3.0661 | 3.0671 | 778764.0 |
| 2006-11-17 17:00:00 | AAPL | Stock | 3.0671 | 3.0671 | 3.0664 | 3.0671 | 70000.0 |
| 2006-11-17 17:30:00 | AAPL | Stock | 3.0671 | 3.0711 | 3.0661 | 3.0711 | 332220.0 |
| 2006-11-17 18:00:00 | AAPL | Stock | 3.0711 | 3.0711 | 3.0693 | 3.0693 | 39396.0 |
| 2006-11-17 18:30:00 | AAPL | Stock | 3.0671 | 3.0671 | 3.0671 | 3.0671 | 2800.0 |
| 2006-11-17 19:00:00 | AAPL | Stock | 3.0711 | 3.0711 | 3.0661 | 3.0671 | 50344.0 |
| 2006-11-17 19:30:00 | AAPL | Stock | 3.0657 | 3.0664 | 3.065 | 3.065 | 144060.0 |
| 2006-11-17 07:30:00 | MSFT | Stock | 29.37 | 29.37 | 29.37 | 29.37 | 400.0 |
| 2006-11-17 08:00:00 | MSFT | Stock | 29.38 | 29.43 | 29.37 | 29.4 | 5842.0 |
| 2006-11-17 08:30:00 | MSFT | Stock | 29.37 | 29.4 | 29.31 | 29.35 | 17773.0 |
| 2006-11-17 09:00:00 | MSFT | Stock | 29.33 | 29.35 | 29.26 | 29.3 | 125259.0 |
| 2006-11-17 09:30:00 | MSFT | Stock | 29.31 | 29.48 | 29.28 | 29.48 | 9712550.0 |
| 2006-11-17 10:00:00 | MSFT | Stock | 29.48 | 29.54 | 29.43 | 29.44 | 4603167.0 |
| 2006-11-17 10:30:00 | MSFT | Stock | 29.43 | 29.44 | 29.39 | 29.4 | 2522277.0 |
| 2006-11-17 11:00:00 | MSFT | Stock | 29.4 | 29.44 | 29.37 | 29.43 | 2185399.0 |
| 2006-11-17 11:30:00 | MSFT | Stock | 29.43 | 29.44 | 29.39 | 29.4 | 1089373.0 |
| 2006-11-17 12:00:00 | MSFT | Stock | 29.4 | 29.45 | 29.4 | 29.43 | 1133826.0 |
| 2006-11-17 12:30:00 | MSFT | Stock | 29.43 | 29.52 | 29.42 | 29.46 | 1921100.0 |
| 2006-11-17 13:00:00 | MSFT | Stock | 29.46 | 29.5 | 29.38 | 29.38 | 2190622.0 |
| 2006-11-17 13:30:00 | MSFT | Stock | 29.38 | 29.41 | 29.38 | 29.4 | 1073849.0 |
| 2006-11-17 14:00:00 | MSFT | Stock | 29.4 | 29.4 | 29.38 | 29.4 | 1813289.0 |
| 2006-11-17 14:30:00 | MSFT | Stock | 29.4 | 29.41 | 29.38 | 29.4 | 2106809.0 |
| 2006-11-17 15:00:00 | MSFT | Stock | 29.4 | 29.43 | 29.38 | 29.39 | 1987628.0 |
| 2006-11-17 15:30:00 | MSFT | Stock | 29.39 | 29.45 | 29.32 | 29.39 | 7800921.0 |
| 2006-11-17 16:00:00 | MSFT | Stock | 29.4 | 29.44 | 29.39 | 29.4 | 216771.0 |
| 2006-11-17 16:30:00 | MSFT | Stock | 29.4 | 29.45 | 29.39 | 29.39 | 133955.0 |
| 2006-11-17 17:30:00 | MSFT | Stock | 29.4 | 29.4 | 29.4 | 29.4 | 300.0 |
| 2006-11-17 18:00:00 | MSFT | Stock | 29.4 | 29.4 | 29.4 | 29.4 | 1000.0 |
| 2006-11-17 18:30:00 | MSFT | Stock | 29.4 | 29.4 | 29.4 | 29.4 | 116.0 |
| 2006-11-17 19:30:00 | MSFT | Stock | 29.42 | 29.42 | 29.42 | 29.42 | 100.0 |
| 2006-11-17 08:00:00 | NVDA | Stock | 0.6038 | 0.6038 | 0.6038 | 0.6038 | 12000.0 |
> showing 50 of 52,043 rows — these rows as CSV