PREVIEW / stock_30min / 2007-06-05
file: by_date/stock_30min/2007/2007-06-05.parquet size: 1.1 MB rows: 63,556 symbols: 3,001
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-05 09:30:00 | AAPL | Stock | 4.3361 | 4.3679 | 4.3036 | 4.3475 | 172325748.0 |
| 2007-06-05 10:00:00 | AAPL | Stock | 4.3471 | 4.3639 | 4.3339 | 4.3607 | 89584264.0 |
| 2007-06-05 10:30:00 | AAPL | Stock | 4.3607 | 4.3732 | 4.3414 | 4.3636 | 85914836.0 |
| 2007-06-05 11:00:00 | AAPL | Stock | 4.3639 | 4.3736 | 4.3514 | 4.37 | 59166884.0 |
| 2007-06-05 11:30:00 | AAPL | Stock | 4.37 | 4.3814 | 4.3543 | 4.3618 | 76939660.0 |
| 2007-06-05 12:00:00 | AAPL | Stock | 4.3614 | 4.3736 | 4.3482 | 4.3618 | 82487944.0 |
| 2007-06-05 12:30:00 | AAPL | Stock | 4.3618 | 4.375 | 4.3589 | 4.3714 | 36515500.0 |
| 2007-06-05 13:00:00 | AAPL | Stock | 4.3718 | 4.38 | 4.3646 | 4.3675 | 43713852.0 |
| 2007-06-05 13:30:00 | AAPL | Stock | 4.3675 | 4.375 | 4.3636 | 4.3693 | 32750396.0 |
| 2007-06-05 14:00:00 | AAPL | Stock | 4.3693 | 4.3789 | 4.3661 | 4.3718 | 33374348.0 |
| 2007-06-05 14:30:00 | AAPL | Stock | 4.3714 | 4.3743 | 4.3607 | 4.3624 | 39523232.0 |
| 2007-06-05 15:00:00 | AAPL | Stock | 4.3622 | 4.4411 | 4.35 | 4.3692 | 45773840.0 |
| 2007-06-05 15:30:00 | AAPL | Stock | 4.3689 | 4.3818 | 4.3679 | 4.3814 | 84085400.0 |
| 2007-06-05 16:00:00 | AAPL | Stock | 4.3814 | 4.3818 | 4.3804 | 4.3811 | 5985896.0 |
| 2007-06-05 09:30:00 | MSFT | Stock | 30.62 | 30.63 | 30.4 | 30.44 | 5443682.0 |
| 2007-06-05 10:00:00 | MSFT | Stock | 30.44 | 30.48 | 30.33 | 30.47 | 3999936.0 |
| 2007-06-05 10:30:00 | MSFT | Stock | 30.46 | 30.55 | 30.34 | 30.51 | 2624155.0 |
| 2007-06-05 11:00:00 | MSFT | Stock | 30.51 | 30.52 | 30.41 | 30.46 | 2846549.0 |
| 2007-06-05 11:30:00 | MSFT | Stock | 30.46 | 30.47 | 30.38 | 30.42 | 2919535.0 |
| 2007-06-05 12:00:00 | MSFT | Stock | 30.41 | 30.51 | 30.33 | 30.38 | 3090529.0 |
| 2007-06-05 12:30:00 | MSFT | Stock | 30.39 | 30.48 | 30.38 | 30.47 | 1455702.0 |
| 2007-06-05 13:00:00 | MSFT | Stock | 30.47 | 30.54 | 30.43 | 30.52 | 1911444.0 |
| 2007-06-05 13:30:00 | MSFT | Stock | 30.52 | 30.53 | 30.45 | 30.45 | 1221054.0 |
| 2007-06-05 14:00:00 | MSFT | Stock | 30.45 | 30.5 | 30.42 | 30.46 | 1277636.0 |
| 2007-06-05 14:30:00 | MSFT | Stock | 30.47 | 30.49 | 30.39 | 30.47 | 2164841.0 |
| 2007-06-05 15:00:00 | MSFT | Stock | 30.48 | 30.58 | 30.47 | 30.57 | 3076621.0 |
| 2007-06-05 15:30:00 | MSFT | Stock | 30.57 | 30.61 | 30.55 | 30.58 | 3473766.0 |
| 2007-06-05 16:00:00 | MSFT | Stock | 30.59 | 30.59 | 30.58 | 30.58 | 1162812.0 |
| 2007-06-05 08:30:00 | NVDA | Stock | 0.5845 | 0.5845 | 0.5845 | 0.5845 | 6000.0 |
| 2007-06-05 09:00:00 | NVDA | Stock | 0.5875 | 0.5875 | 0.5852 | 0.5867 | 282000.0 |
| 2007-06-05 09:30:00 | NVDA | Stock | 0.5862 | 0.5952 | 0.5852 | 0.5925 | 67283760.0 |
| 2007-06-05 10:00:00 | NVDA | Stock | 0.5927 | 0.5937 | 0.5893 | 0.5932 | 55003740.0 |
| 2007-06-05 10:30:00 | NVDA | Stock | 0.5932 | 0.5987 | 0.5917 | 0.597 | 64532220.0 |
| 2007-06-05 11:00:00 | NVDA | Stock | 0.597 | 0.5972 | 0.592 | 0.5933 | 30405360.0 |
| 2007-06-05 11:30:00 | NVDA | Stock | 0.5933 | 0.5957 | 0.5897 | 0.5902 | 35203440.0 |
| 2007-06-05 12:00:00 | NVDA | Stock | 0.5902 | 0.5932 | 0.5892 | 0.59 | 49290600.0 |
| 2007-06-05 12:30:00 | NVDA | Stock | 0.59 | 0.5928 | 0.5898 | 0.5925 | 29801880.0 |
| 2007-06-05 13:00:00 | NVDA | Stock | 0.5923 | 0.5965 | 0.5922 | 0.5948 | 41841120.0 |
| 2007-06-05 13:30:00 | NVDA | Stock | 0.5948 | 0.5962 | 0.5938 | 0.5957 | 21921000.0 |
| 2007-06-05 14:00:00 | NVDA | Stock | 0.5957 | 0.5978 | 0.5947 | 0.597 | 27344760.0 |
| 2007-06-05 14:30:00 | NVDA | Stock | 0.597 | 0.599 | 0.5967 | 0.5977 | 62853720.0 |
| 2007-06-05 15:00:00 | NVDA | Stock | 0.5977 | 0.6 | 0.5973 | 0.5995 | 56838360.0 |
| 2007-06-05 15:30:00 | NVDA | Stock | 0.5995 | 0.6028 | 0.5995 | 0.6027 | 98490060.0 |
| 2007-06-05 16:00:00 | NVDA | Stock | 0.6018 | 0.6042 | 0.5954 | 0.6042 | 10984800.0 |
| 2007-06-05 16:30:00 | NVDA | Stock | 0.604 | 0.6042 | 0.6033 | 0.6033 | 126000.0 |
| 2007-06-05 17:00:00 | NVDA | Stock | 0.6033 | 0.6033 | 0.6018 | 0.6018 | 5246760.0 |
| 2007-06-05 19:00:00 | NVDA | Stock | 0.6033 | 0.6033 | 0.6033 | 0.6033 | 30000.0 |
| 2007-06-05 19:30:00 | NVDA | Stock | 0.6025 | 0.6025 | 0.6018 | 0.602 | 72000.0 |
| 2007-06-05 07:00:00 | AMZN | Stock | 3.525 | 3.525 | 3.525 | 3.525 | 2000.0 |
| 2007-06-05 07:30:00 | AMZN | Stock | 3.525 | 3.554 | 3.525 | 3.5445 | 62000.0 |
> showing 50 of 63,556 rows — these rows as CSV