PREVIEW / stock_30min / 2007-08-02
file: by_date/stock_30min/2007/2007-08-02.parquet size: 1.2 MB rows: 66,791 symbols: 3,074
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-08-02 09:30:00 | AAPL | Stock | 4.8804 | 4.8914 | 4.8221 | 4.8607 | 161892444.0 |
| 2007-08-02 10:00:00 | AAPL | Stock | 4.8607 | 4.8607 | 4.7911 | 4.8032 | 113390676.0 |
| 2007-08-02 10:30:00 | AAPL | Stock | 4.8036 | 4.8421 | 4.7936 | 4.8175 | 75932668.0 |
| 2007-08-02 11:00:00 | AAPL | Stock | 4.8175 | 4.8325 | 4.7982 | 4.8311 | 49108080.0 |
| 2007-08-02 11:30:00 | AAPL | Stock | 4.8311 | 4.8639 | 4.8139 | 4.8621 | 46273892.0 |
| 2007-08-02 12:00:00 | AAPL | Stock | 4.8607 | 4.8621 | 4.835 | 4.8389 | 37781268.0 |
| 2007-08-02 12:30:00 | AAPL | Stock | 4.8387 | 4.8504 | 4.8257 | 4.8289 | 28603876.0 |
| 2007-08-02 13:00:00 | AAPL | Stock | 4.8296 | 4.8389 | 4.8129 | 4.8261 | 43994916.0 |
| 2007-08-02 13:30:00 | AAPL | Stock | 4.8261 | 4.8464 | 4.8243 | 4.8304 | 29077188.0 |
| 2007-08-02 14:00:00 | AAPL | Stock | 4.8311 | 4.8518 | 4.8289 | 4.8393 | 29520484.0 |
| 2007-08-02 14:30:00 | AAPL | Stock | 4.8393 | 4.8554 | 4.8225 | 4.855 | 44385180.0 |
| 2007-08-02 15:00:00 | AAPL | Stock | 4.8543 | 4.875 | 4.8486 | 4.87 | 70913108.0 |
| 2007-08-02 15:30:00 | AAPL | Stock | 4.8696 | 4.8743 | 4.8525 | 4.8732 | 72632336.0 |
| 2007-08-02 16:00:00 | AAPL | Stock | 4.8732 | 4.8746 | 4.8732 | 4.8746 | 13417964.0 |
| 2007-08-02 09:30:00 | MSFT | Stock | 29.19 | 29.37 | 29.02 | 29.28 | 4043283.0 |
| 2007-08-02 10:00:00 | MSFT | Stock | 29.28 | 29.45 | 29.19 | 29.441 | 3184942.0 |
| 2007-08-02 10:30:00 | MSFT | Stock | 29.44 | 29.6 | 29.38 | 29.51 | 5797613.0 |
| 2007-08-02 11:00:00 | MSFT | Stock | 29.51 | 29.58 | 29.47 | 29.55 | 3250983.0 |
| 2007-08-02 11:30:00 | MSFT | Stock | 29.555 | 29.75 | 29.55 | 29.75 | 2916842.0 |
| 2007-08-02 12:00:00 | MSFT | Stock | 29.75 | 29.79 | 29.52 | 29.65 | 3184638.0 |
| 2007-08-02 12:30:00 | MSFT | Stock | 29.651 | 29.7 | 29.6 | 29.6 | 2033242.0 |
| 2007-08-02 13:00:00 | MSFT | Stock | 29.61 | 29.62 | 29.41 | 29.47 | 2404362.0 |
| 2007-08-02 13:30:00 | MSFT | Stock | 29.47 | 29.66 | 29.46 | 29.532 | 2453818.0 |
| 2007-08-02 14:00:00 | MSFT | Stock | 29.53 | 29.62 | 29.5 | 29.53 | 2139687.0 |
| 2007-08-02 14:30:00 | MSFT | Stock | 29.52 | 29.59 | 29.42 | 29.45 | 2727070.0 |
| 2007-08-02 15:00:00 | MSFT | Stock | 29.46 | 29.7 | 29.45 | 29.68 | 3459950.0 |
| 2007-08-02 15:30:00 | MSFT | Stock | 29.69 | 29.69 | 29.46 | 29.52 | 6722349.0 |
| 2007-08-02 16:00:00 | MSFT | Stock | 29.5 | 29.52 | 29.5 | 29.52 | 2040454.0 |
| 2007-08-02 08:00:00 | NVDA | Stock | 0.7625 | 0.7632 | 0.7625 | 0.7625 | 55800.0 |
| 2007-08-02 08:30:00 | NVDA | Stock | 0.7592 | 0.7612 | 0.7592 | 0.7602 | 114000.0 |
| 2007-08-02 09:00:00 | NVDA | Stock | 0.7623 | 0.7652 | 0.7602 | 0.7652 | 841920.0 |
| 2007-08-02 09:30:00 | NVDA | Stock | 0.7657 | 0.7663 | 0.7525 | 0.7608 | 48858720.0 |
| 2007-08-02 10:00:00 | NVDA | Stock | 0.7608 | 0.761 | 0.748 | 0.751 | 28275960.0 |
| 2007-08-02 10:30:00 | NVDA | Stock | 0.7508 | 0.7567 | 0.7493 | 0.7517 | 21882540.0 |
| 2007-08-02 11:00:00 | NVDA | Stock | 0.7518 | 0.7525 | 0.746 | 0.7498 | 21870120.0 |
| 2007-08-02 11:30:00 | NVDA | Stock | 0.7497 | 0.7577 | 0.7492 | 0.7575 | 31559400.0 |
| 2007-08-02 12:00:00 | NVDA | Stock | 0.7575 | 0.759 | 0.7548 | 0.7585 | 34347360.0 |
| 2007-08-02 12:30:00 | NVDA | Stock | 0.7583 | 0.7587 | 0.7547 | 0.755 | 30506460.0 |
| 2007-08-02 13:00:00 | NVDA | Stock | 0.755 | 0.7558 | 0.7493 | 0.7505 | 27524040.0 |
| 2007-08-02 13:30:00 | NVDA | Stock | 0.7505 | 0.7542 | 0.748 | 0.75 | 33291240.0 |
| 2007-08-02 14:00:00 | NVDA | Stock | 0.75 | 0.7526 | 0.748 | 0.7495 | 25879080.0 |
| 2007-08-02 14:30:00 | NVDA | Stock | 0.7495 | 0.7556 | 0.7447 | 0.7452 | 32120820.0 |
| 2007-08-02 15:00:00 | NVDA | Stock | 0.7453 | 0.756 | 0.7435 | 0.755 | 53327460.0 |
| 2007-08-02 15:30:00 | NVDA | Stock | 0.755 | 0.755 | 0.7493 | 0.7533 | 61836240.0 |
| 2007-08-02 16:00:00 | NVDA | Stock | 0.7527 | 0.7568 | 0.7503 | 0.7568 | 379800.0 |
| 2007-08-02 16:30:00 | NVDA | Stock | 0.7537 | 0.7537 | 0.7537 | 0.7537 | 18360.0 |
| 2007-08-02 17:30:00 | NVDA | Stock | 0.7537 | 0.7537 | 0.7537 | 0.7537 | 66660.0 |
| 2007-08-02 18:30:00 | NVDA | Stock | 0.7563 | 0.7567 | 0.7508 | 0.7567 | 72000.0 |
| 2007-08-02 08:00:00 | AMZN | Stock | 3.88 | 3.8995 | 3.88 | 3.885 | 125960.0 |
| 2007-08-02 08:30:00 | AMZN | Stock | 3.8855 | 3.8995 | 3.8655 | 3.8935 | 269760.0 |
> showing 50 of 66,791 rows — these rows as CSV