PREVIEW / stock_30min / 2000-01-20
file: by_date/stock_30min/2000/2000-01-20.parquet size: 411 KB rows: 24,284 symbols: 1,130
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 |
|---|---|---|---|---|---|---|---|
| 2000-01-20 09:30:00 | AAPL | Stock | 1.0313 | 1.0491 | 1.0268 | 1.0368 | 368659200.0 |
| 2000-01-20 10:00:00 | AAPL | Stock | 1.0379 | 1.0513 | 1.0377 | 1.0452 | 212900800.0 |
| 2000-01-20 10:30:00 | AAPL | Stock | 1.0458 | 1.058 | 1.0446 | 1.0552 | 171707200.0 |
| 2000-01-20 11:00:00 | AAPL | Stock | 1.0558 | 1.0748 | 1.0536 | 1.0703 | 307406400.0 |
| 2000-01-20 11:30:00 | AAPL | Stock | 1.0703 | 1.0848 | 1.0631 | 1.0792 | 182750400.0 |
| 2000-01-20 12:00:00 | AAPL | Stock | 1.0792 | 1.0798 | 1.0647 | 1.0753 | 114072000.0 |
| 2000-01-20 12:30:00 | AAPL | Stock | 1.0748 | 1.0759 | 1.0569 | 1.0653 | 60849600.0 |
| 2000-01-20 13:00:00 | AAPL | Stock | 1.0653 | 1.0653 | 1.0474 | 1.0575 | 54241600.0 |
| 2000-01-20 13:30:00 | AAPL | Stock | 1.058 | 1.058 | 1.0519 | 1.053 | 24483200.0 |
| 2000-01-20 14:00:00 | AAPL | Stock | 1.0525 | 1.0619 | 1.0485 | 1.0583 | 35324800.0 |
| 2000-01-20 14:30:00 | AAPL | Stock | 1.058 | 1.0625 | 1.0536 | 1.0541 | 45987200.0 |
| 2000-01-20 15:00:00 | AAPL | Stock | 1.0539 | 1.0552 | 1.0402 | 1.048 | 57803200.0 |
| 2000-01-20 15:30:00 | AAPL | Stock | 1.048 | 1.0491 | 1.0134 | 1.0134 | 96902400.0 |
| 2000-01-20 16:00:00 | AAPL | Stock | 1.014 | 1.0156 | 1.0134 | 1.0134 | 1456000.0 |
| 2000-01-20 09:30:00 | MSFT | Stock | 53.5312 | 54.5 | 53.0 | 54.2812 | 8681200.0 |
| 2000-01-20 10:00:00 | MSFT | Stock | 54.25 | 54.6875 | 54.2188 | 54.5625 | 6563800.0 |
| 2000-01-20 10:30:00 | MSFT | Stock | 54.5625 | 54.8438 | 54.4062 | 54.5469 | 4333000.0 |
| 2000-01-20 11:00:00 | MSFT | Stock | 54.5312 | 54.5938 | 54.125 | 54.4688 | 3215600.0 |
| 2000-01-20 11:30:00 | MSFT | Stock | 54.4375 | 54.4688 | 53.7812 | 53.875 | 4453400.0 |
| 2000-01-20 12:00:00 | MSFT | Stock | 53.9062 | 53.9688 | 53.5625 | 53.6562 | 2663600.0 |
| 2000-01-20 12:30:00 | MSFT | Stock | 53.6562 | 53.7188 | 53.125 | 53.5625 | 3395200.0 |
| 2000-01-20 13:00:00 | MSFT | Stock | 53.5312 | 53.75 | 53.3125 | 53.7188 | 3092600.0 |
| 2000-01-20 13:30:00 | MSFT | Stock | 53.6875 | 53.8125 | 53.3438 | 53.375 | 2391200.0 |
| 2000-01-20 14:00:00 | MSFT | Stock | 53.3438 | 53.8438 | 53.25 | 53.4375 | 2588000.0 |
| 2000-01-20 14:30:00 | MSFT | Stock | 53.4375 | 53.875 | 53.0312 | 53.125 | 3550800.0 |
| 2000-01-20 15:00:00 | MSFT | Stock | 53.125 | 53.5 | 52.9688 | 53.25 | 4055800.0 |
| 2000-01-20 15:30:00 | MSFT | Stock | 53.25 | 53.4375 | 52.9375 | 52.9688 | 4108000.0 |
| 2000-01-20 16:00:00 | MSFT | Stock | 53.0312 | 53.0312 | 52.9688 | 53.0 | 110600.0 |
| 2000-01-20 09:30:00 | NVDA | Stock | 0.0953 | 0.0992 | 0.0948 | 0.099 | 26256000.0 |
| 2000-01-20 10:00:00 | NVDA | Stock | 0.0992 | 0.1005 | 0.098 | 0.1003 | 16944000.0 |
| 2000-01-20 10:30:00 | NVDA | Stock | 0.1 | 0.1005 | 0.099 | 0.0995 | 8016000.0 |
| 2000-01-20 11:00:00 | NVDA | Stock | 0.0999 | 0.1005 | 0.0993 | 0.1005 | 9744000.0 |
| 2000-01-20 11:30:00 | NVDA | Stock | 0.1005 | 0.1005 | 0.0993 | 0.0995 | 10176000.0 |
| 2000-01-20 12:00:00 | NVDA | Stock | 0.0997 | 0.0997 | 0.099 | 0.0995 | 31680000.0 |
| 2000-01-20 12:30:00 | NVDA | Stock | 0.0995 | 0.0997 | 0.0948 | 0.0958 | 25056000.0 |
| 2000-01-20 13:00:00 | NVDA | Stock | 0.0958 | 0.0958 | 0.0948 | 0.0956 | 8880000.0 |
| 2000-01-20 13:30:00 | NVDA | Stock | 0.0956 | 0.0956 | 0.0949 | 0.0956 | 3600000.0 |
| 2000-01-20 14:00:00 | NVDA | Stock | 0.0956 | 0.0958 | 0.0952 | 0.0957 | 15984000.0 |
| 2000-01-20 14:30:00 | NVDA | Stock | 0.0957 | 0.0958 | 0.0954 | 0.0956 | 1488000.0 |
| 2000-01-20 15:00:00 | NVDA | Stock | 0.0956 | 0.0958 | 0.0956 | 0.0958 | 8016000.0 |
| 2000-01-20 15:30:00 | NVDA | Stock | 0.0958 | 0.0958 | 0.0935 | 0.0943 | 8448000.0 |
| 2000-01-20 09:30:00 | AMZN | Stock | 3.3469 | 3.35 | 3.2562 | 3.2688 | 16870000.0 |
| 2000-01-20 10:00:00 | AMZN | Stock | 3.2688 | 3.2906 | 3.25 | 3.2594 | 10692000.0 |
| 2000-01-20 10:30:00 | AMZN | Stock | 3.2562 | 3.2844 | 3.25 | 3.275 | 7198000.0 |
| 2000-01-20 11:00:00 | AMZN | Stock | 3.275 | 3.2844 | 3.2562 | 3.2625 | 7300000.0 |
| 2000-01-20 11:30:00 | AMZN | Stock | 3.2625 | 3.2656 | 3.25 | 3.2531 | 13624000.0 |
| 2000-01-20 12:00:00 | AMZN | Stock | 3.2531 | 3.2625 | 3.25 | 3.25 | 9274000.0 |
| 2000-01-20 12:30:00 | AMZN | Stock | 3.25 | 3.2531 | 3.1969 | 3.2 | 13746000.0 |
| 2000-01-20 13:00:00 | AMZN | Stock | 3.2063 | 3.2188 | 3.2 | 3.2156 | 3840000.0 |
| 2000-01-20 13:30:00 | AMZN | Stock | 3.2156 | 3.2469 | 3.2031 | 3.2375 | 4356000.0 |
> showing 50 of 24,284 rows — these rows as CSV