PREVIEW / stock_30min / 2006-07-13
file: by_date/stock_30min/2006/2006-07-13.parquet size: 923 KB rows: 50,104 symbols: 2,313
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-07-13 07:00:00 | AAPL | Stock | 1.8821 | 1.8821 | 1.8818 | 1.8818 | 5600.0 |
| 2006-07-13 07:30:00 | AAPL | Stock | 1.8821 | 1.8821 | 1.8696 | 1.8696 | 53200.0 |
| 2006-07-13 08:00:00 | AAPL | Stock | 1.8696 | 1.8786 | 1.8686 | 1.8696 | 1897616.0 |
| 2006-07-13 08:30:00 | AAPL | Stock | 1.8696 | 1.8782 | 1.8671 | 1.8729 | 1728160.0 |
| 2006-07-13 09:00:00 | AAPL | Stock | 1.8732 | 1.8743 | 1.8582 | 1.86 | 4158980.0 |
| 2006-07-13 09:30:00 | AAPL | Stock | 1.8582 | 1.8711 | 1.8421 | 1.8525 | 177590616.0 |
| 2006-07-13 10:00:00 | AAPL | Stock | 1.8525 | 1.8704 | 1.8361 | 1.8682 | 159782420.0 |
| 2006-07-13 10:30:00 | AAPL | Stock | 1.8679 | 1.8993 | 1.8679 | 1.8829 | 151657184.0 |
| 2006-07-13 11:00:00 | AAPL | Stock | 1.8825 | 1.8896 | 1.87 | 1.8886 | 84327152.0 |
| 2006-07-13 11:30:00 | AAPL | Stock | 1.8886 | 1.9064 | 1.8839 | 1.9046 | 91648088.0 |
| 2006-07-13 12:00:00 | AAPL | Stock | 1.9046 | 1.9329 | 1.9046 | 1.92 | 130958632.0 |
| 2006-07-13 12:30:00 | AAPL | Stock | 1.9204 | 1.9304 | 1.9146 | 1.9154 | 55059312.0 |
| 2006-07-13 13:00:00 | AAPL | Stock | 1.9161 | 1.9211 | 1.8971 | 1.9004 | 61180084.0 |
| 2006-07-13 13:30:00 | AAPL | Stock | 1.9004 | 1.9232 | 1.8843 | 1.8843 | 65582384.0 |
| 2006-07-13 14:00:00 | AAPL | Stock | 1.8843 | 1.8982 | 1.8839 | 1.8904 | 51672712.0 |
| 2006-07-13 14:30:00 | AAPL | Stock | 1.8907 | 1.8921 | 1.8754 | 1.8807 | 49173628.0 |
| 2006-07-13 15:00:00 | AAPL | Stock | 1.8811 | 1.8818 | 1.8675 | 1.8814 | 59166688.0 |
| 2006-07-13 15:30:00 | AAPL | Stock | 1.8818 | 1.8854 | 1.8643 | 1.8657 | 89488308.0 |
| 2006-07-13 16:00:00 | AAPL | Stock | 1.8661 | 1.8804 | 1.8625 | 1.8675 | 2455600.0 |
| 2006-07-13 16:30:00 | AAPL | Stock | 1.8671 | 1.8804 | 1.8661 | 1.8668 | 239400.0 |
| 2006-07-13 17:00:00 | AAPL | Stock | 1.8671 | 1.9071 | 1.8671 | 1.8682 | 2083592.0 |
| 2006-07-13 17:30:00 | AAPL | Stock | 1.8643 | 1.8661 | 1.8625 | 1.8625 | 125944.0 |
| 2006-07-13 18:00:00 | AAPL | Stock | 1.8643 | 1.8655 | 1.8629 | 1.8655 | 91952.0 |
| 2006-07-13 07:30:00 | MSFT | Stock | 22.61 | 22.61 | 22.54 | 22.54 | 2800.0 |
| 2006-07-13 08:00:00 | MSFT | Stock | 22.57 | 22.57 | 22.43 | 22.45 | 178447.0 |
| 2006-07-13 08:30:00 | MSFT | Stock | 22.45 | 22.47 | 22.41 | 22.41 | 359948.0 |
| 2006-07-13 09:00:00 | MSFT | Stock | 22.4 | 22.43 | 22.31 | 22.38 | 475037.0 |
| 2006-07-13 09:30:00 | MSFT | Stock | 22.37 | 22.61 | 22.32 | 22.41 | 15225573.0 |
| 2006-07-13 10:00:00 | MSFT | Stock | 22.408 | 22.51 | 22.37 | 22.49 | 7990107.0 |
| 2006-07-13 10:30:00 | MSFT | Stock | 22.49 | 22.55 | 22.44 | 22.485 | 5756548.0 |
| 2006-07-13 11:00:00 | MSFT | Stock | 22.48 | 22.54 | 22.45 | 22.53 | 4316894.0 |
| 2006-07-13 11:30:00 | MSFT | Stock | 22.53 | 22.55 | 22.44 | 22.49 | 4060763.0 |
| 2006-07-13 12:00:00 | MSFT | Stock | 22.49 | 22.58 | 22.49 | 22.53 | 2516679.0 |
| 2006-07-13 12:30:00 | MSFT | Stock | 22.53 | 22.567 | 22.5 | 22.525 | 1564346.0 |
| 2006-07-13 13:00:00 | MSFT | Stock | 22.523 | 22.54 | 22.43 | 22.49 | 2421994.0 |
| 2006-07-13 13:30:00 | MSFT | Stock | 22.49 | 22.5 | 22.4 | 22.41 | 3431561.0 |
| 2006-07-13 14:00:00 | MSFT | Stock | 22.41 | 22.48 | 22.41 | 22.45 | 3139494.0 |
| 2006-07-13 14:30:00 | MSFT | Stock | 22.45 | 22.46 | 22.38 | 22.39 | 4410313.0 |
| 2006-07-13 15:00:00 | MSFT | Stock | 22.39 | 22.43 | 22.35 | 22.41 | 5416055.0 |
| 2006-07-13 15:30:00 | MSFT | Stock | 22.42 | 22.47 | 22.25 | 22.25 | 8827859.0 |
| 2006-07-13 16:00:00 | MSFT | Stock | 22.25 | 22.26 | 22.04 | 22.25 | 257933.0 |
| 2006-07-13 16:30:00 | MSFT | Stock | 22.24 | 22.25 | 22.22 | 22.23 | 35673.0 |
| 2006-07-13 17:00:00 | MSFT | Stock | 22.23 | 22.24 | 22.21 | 22.21 | 7880.0 |
| 2006-07-13 17:30:00 | MSFT | Stock | 22.23 | 22.23 | 22.21 | 22.21 | 2721.0 |
| 2006-07-13 18:00:00 | MSFT | Stock | 22.21 | 22.26 | 22.21 | 22.26 | 3615.0 |
| 2006-07-13 08:00:00 | NVDA | Stock | 0.3058 | 0.3058 | 0.3018 | 0.3025 | 313800.0 |
| 2006-07-13 08:30:00 | NVDA | Stock | 0.3037 | 0.3037 | 0.2983 | 0.2985 | 216360.0 |
| 2006-07-13 09:00:00 | NVDA | Stock | 0.2992 | 0.3 | 0.2985 | 0.2998 | 542760.0 |
| 2006-07-13 09:30:00 | NVDA | Stock | 0.2992 | 0.3005 | 0.2945 | 0.2983 | 58666200.0 |
| 2006-07-13 10:00:00 | NVDA | Stock | 0.2982 | 0.2987 | 0.2957 | 0.2987 | 48507240.0 |
> showing 50 of 50,104 rows — these rows as CSV