PREVIEW / stock_30min / 2007-05-04
file: by_date/stock_30min/2007/2007-05-04.parquet size: 1.0 MB rows: 58,199 symbols: 2,702
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-05-04 09:30:00 | AAPL | Stock | 3.6 | 3.6111 | 3.5893 | 3.5986 | 52992828.0 |
| 2007-05-04 10:00:00 | AAPL | Stock | 3.5989 | 3.6214 | 3.5954 | 3.6157 | 50224580.0 |
| 2007-05-04 10:30:00 | AAPL | Stock | 3.6157 | 3.6286 | 3.6054 | 3.6054 | 34867504.0 |
| 2007-05-04 11:00:00 | AAPL | Stock | 3.6057 | 3.61 | 3.6007 | 3.6082 | 22630664.0 |
| 2007-05-04 11:30:00 | AAPL | Stock | 3.6082 | 3.6104 | 3.6004 | 3.6057 | 21771372.0 |
| 2007-05-04 12:00:00 | AAPL | Stock | 3.6061 | 3.6096 | 3.5918 | 3.5921 | 36205540.0 |
| 2007-05-04 12:30:00 | AAPL | Stock | 3.5916 | 3.5979 | 3.5914 | 3.5936 | 25524576.0 |
| 2007-05-04 13:00:00 | AAPL | Stock | 3.5939 | 3.6014 | 3.5932 | 3.5986 | 22409856.0 |
| 2007-05-04 13:30:00 | AAPL | Stock | 3.5986 | 3.6018 | 3.5921 | 3.5968 | 19054868.0 |
| 2007-05-04 14:00:00 | AAPL | Stock | 3.5964 | 3.5982 | 3.5925 | 3.5979 | 14442932.0 |
| 2007-05-04 14:30:00 | AAPL | Stock | 3.5982 | 3.5982 | 3.5921 | 3.5961 | 14009212.0 |
| 2007-05-04 15:00:00 | AAPL | Stock | 3.5957 | 3.6 | 3.5957 | 3.5993 | 13879544.0 |
| 2007-05-04 15:30:00 | AAPL | Stock | 3.5996 | 3.6021 | 3.595 | 3.6 | 33300120.0 |
| 2007-05-04 16:00:00 | AAPL | Stock | 3.6 | 3.6004 | 3.5993 | 3.6004 | 2830912.0 |
| 2007-05-04 09:30:00 | MSFT | Stock | 30.68 | 30.7 | 30.29 | 30.43 | 15395646.0 |
| 2007-05-04 10:00:00 | MSFT | Stock | 30.43 | 30.55 | 30.35 | 30.55 | 6624096.0 |
| 2007-05-04 10:30:00 | MSFT | Stock | 30.55 | 30.65 | 30.5 | 30.61 | 6268725.0 |
| 2007-05-04 11:00:00 | MSFT | Stock | 30.608 | 30.65 | 30.46 | 30.5 | 5223723.0 |
| 2007-05-04 11:30:00 | MSFT | Stock | 30.495 | 30.53 | 30.45 | 30.51 | 5002403.0 |
| 2007-05-04 12:00:00 | MSFT | Stock | 30.5 | 30.51 | 30.36 | 30.42 | 11724230.0 |
| 2007-05-04 12:30:00 | MSFT | Stock | 30.41 | 30.46 | 30.37 | 30.46 | 4269777.0 |
| 2007-05-04 13:00:00 | MSFT | Stock | 30.46 | 30.56 | 30.45 | 30.53 | 6221704.0 |
| 2007-05-04 13:30:00 | MSFT | Stock | 30.53 | 30.59 | 30.43 | 30.44 | 3548551.0 |
| 2007-05-04 14:00:00 | MSFT | Stock | 30.44 | 30.52 | 30.42 | 30.48 | 4139869.0 |
| 2007-05-04 14:30:00 | MSFT | Stock | 30.48 | 30.58 | 30.41 | 30.57 | 7191424.0 |
| 2007-05-04 15:00:00 | MSFT | Stock | 30.56 | 30.65 | 30.51 | 30.601 | 10575548.0 |
| 2007-05-04 15:30:00 | MSFT | Stock | 30.6 | 30.61 | 30.46 | 30.56 | 9750527.0 |
| 2007-05-04 16:00:00 | MSFT | Stock | 30.56 | 30.56 | 30.53 | 30.56 | 964082.0 |
| 2007-05-04 09:00:00 | NVDA | Stock | 0.56 | 0.563 | 0.56 | 0.5625 | 174000.0 |
| 2007-05-04 09:30:00 | NVDA | Stock | 0.5608 | 0.562 | 0.5567 | 0.5585 | 30018720.0 |
| 2007-05-04 10:00:00 | NVDA | Stock | 0.5583 | 0.5607 | 0.5577 | 0.558 | 41072940.0 |
| 2007-05-04 10:30:00 | NVDA | Stock | 0.5578 | 0.5597 | 0.5555 | 0.5593 | 44603700.0 |
| 2007-05-04 11:00:00 | NVDA | Stock | 0.5595 | 0.563 | 0.559 | 0.5628 | 24746040.0 |
| 2007-05-04 11:30:00 | NVDA | Stock | 0.5628 | 0.5647 | 0.5628 | 0.5637 | 28130700.0 |
| 2007-05-04 12:00:00 | NVDA | Stock | 0.5635 | 0.5642 | 0.5592 | 0.56 | 41094840.0 |
| 2007-05-04 12:30:00 | NVDA | Stock | 0.56 | 0.564 | 0.5592 | 0.5637 | 25449660.0 |
| 2007-05-04 13:00:00 | NVDA | Stock | 0.5637 | 0.5637 | 0.5608 | 0.5625 | 15482100.0 |
| 2007-05-04 13:30:00 | NVDA | Stock | 0.5625 | 0.563 | 0.5583 | 0.5587 | 23242920.0 |
| 2007-05-04 14:00:00 | NVDA | Stock | 0.5587 | 0.5608 | 0.5578 | 0.5588 | 25184580.0 |
| 2007-05-04 14:30:00 | NVDA | Stock | 0.5588 | 0.5598 | 0.5568 | 0.5593 | 21604440.0 |
| 2007-05-04 15:00:00 | NVDA | Stock | 0.5592 | 0.5613 | 0.5592 | 0.561 | 18490140.0 |
| 2007-05-04 15:30:00 | NVDA | Stock | 0.561 | 0.563 | 0.5598 | 0.5618 | 50365980.0 |
| 2007-05-04 16:00:00 | NVDA | Stock | 0.5623 | 0.5625 | 0.562 | 0.5623 | 99600.0 |
| 2007-05-04 16:30:00 | NVDA | Stock | 0.5617 | 0.5617 | 0.5617 | 0.5617 | 18000.0 |
| 2007-05-04 17:00:00 | NVDA | Stock | 0.5623 | 0.5623 | 0.5623 | 0.5623 | 30000.0 |
| 2007-05-04 17:30:00 | NVDA | Stock | 0.5623 | 0.5623 | 0.5623 | 0.5623 | 6000.0 |
| 2007-05-04 18:30:00 | NVDA | Stock | 0.5623 | 0.5623 | 0.5623 | 0.5623 | 24000.0 |
| 2007-05-04 19:30:00 | NVDA | Stock | 0.5623 | 0.5633 | 0.5623 | 0.5633 | 90900.0 |
| 2007-05-04 04:00:00 | AMZN | Stock | 3.1125 | 3.1125 | 3.1125 | 3.1125 | 2000.0 |
| 2007-05-04 05:30:00 | AMZN | Stock | 3.1125 | 3.1125 | 3.1125 | 3.1125 | 2000.0 |
> showing 50 of 58,199 rows — these rows as CSV