PREVIEW / stock_30min / 2007-06-13
file: by_date/stock_30min/2007/2007-06-13.parquet size: 1.1 MB rows: 63,371 symbols: 3,023
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-13 09:30:00 | AAPL | Stock | 4.3268 | 4.3282 | 4.2632 | 4.2875 | 135999836.0 |
| 2007-06-13 10:00:00 | AAPL | Stock | 4.2871 | 4.2993 | 4.2732 | 4.2757 | 97260576.0 |
| 2007-06-13 10:30:00 | AAPL | Stock | 4.2757 | 4.2846 | 4.2475 | 4.2536 | 100766848.0 |
| 2007-06-13 11:00:00 | AAPL | Stock | 4.2536 | 4.2675 | 4.1879 | 4.2071 | 182994140.0 |
| 2007-06-13 11:30:00 | AAPL | Stock | 4.2068 | 4.2143 | 4.1696 | 4.1825 | 186281788.0 |
| 2007-06-13 12:00:00 | AAPL | Stock | 4.1825 | 4.1868 | 4.1364 | 4.1468 | 151898684.0 |
| 2007-06-13 12:30:00 | AAPL | Stock | 4.1468 | 4.1729 | 4.1214 | 4.1421 | 143811640.0 |
| 2007-06-13 13:00:00 | AAPL | Stock | 4.1421 | 4.1614 | 4.1386 | 4.1493 | 79227848.0 |
| 2007-06-13 13:30:00 | AAPL | Stock | 4.1496 | 4.1704 | 4.1268 | 4.165 | 84569688.0 |
| 2007-06-13 14:00:00 | AAPL | Stock | 4.165 | 4.2129 | 4.1614 | 4.1732 | 138559568.0 |
| 2007-06-13 14:30:00 | AAPL | Stock | 4.1732 | 4.1768 | 4.1354 | 4.1471 | 108985016.0 |
| 2007-06-13 15:00:00 | AAPL | Stock | 4.1468 | 4.1696 | 4.1404 | 4.1643 | 108259984.0 |
| 2007-06-13 15:30:00 | AAPL | Stock | 4.1643 | 4.1968 | 4.1643 | 4.1961 | 157367980.0 |
| 2007-06-13 16:00:00 | AAPL | Stock | 4.1964 | 4.1968 | 4.195 | 4.1964 | 8638700.0 |
| 2007-06-13 09:30:00 | MSFT | Stock | 29.97 | 30.13 | 29.85 | 30.09 | 4216600.0 |
| 2007-06-13 10:00:00 | MSFT | Stock | 30.092 | 30.13 | 29.99 | 30.01 | 8453853.0 |
| 2007-06-13 10:30:00 | MSFT | Stock | 30.015 | 30.08 | 30.0 | 30.04 | 3936306.0 |
| 2007-06-13 11:00:00 | MSFT | Stock | 30.04 | 30.07 | 29.97 | 30.02 | 2763023.0 |
| 2007-06-13 11:30:00 | MSFT | Stock | 30.012 | 30.1 | 30.01 | 30.058 | 2130097.0 |
| 2007-06-13 12:00:00 | MSFT | Stock | 30.055 | 30.08 | 30.01 | 30.04 | 1627303.0 |
| 2007-06-13 12:30:00 | MSFT | Stock | 30.03 | 30.13 | 30.02 | 30.05 | 3717041.0 |
| 2007-06-13 13:00:00 | MSFT | Stock | 30.05 | 30.05 | 29.96 | 30.02 | 2790812.0 |
| 2007-06-13 13:30:00 | MSFT | Stock | 30.03 | 30.12 | 30.01 | 30.1 | 3117677.0 |
| 2007-06-13 14:00:00 | MSFT | Stock | 30.092 | 30.2 | 30.09 | 30.16 | 5467333.0 |
| 2007-06-13 14:30:00 | MSFT | Stock | 30.17 | 30.25 | 30.12 | 30.24 | 4241118.0 |
| 2007-06-13 15:00:00 | MSFT | Stock | 30.24 | 30.27 | 30.16 | 30.21 | 4833038.0 |
| 2007-06-13 15:30:00 | MSFT | Stock | 30.21 | 30.41 | 30.103 | 30.39 | 14507549.0 |
| 2007-06-13 16:00:00 | MSFT | Stock | 30.39 | 30.39 | 30.39 | 30.39 | 1305955.0 |
| 2007-06-13 08:00:00 | NVDA | Stock | 0.6083 | 0.611 | 0.6083 | 0.611 | 96000.0 |
| 2007-06-13 08:30:00 | NVDA | Stock | 0.611 | 0.6117 | 0.6102 | 0.611 | 239100.0 |
| 2007-06-13 09:00:00 | NVDA | Stock | 0.6108 | 0.6133 | 0.6093 | 0.6093 | 864600.0 |
| 2007-06-13 09:30:00 | NVDA | Stock | 0.6117 | 0.6117 | 0.605 | 0.6082 | 35173260.0 |
| 2007-06-13 10:00:00 | NVDA | Stock | 0.6082 | 0.6105 | 0.6038 | 0.6097 | 52644060.0 |
| 2007-06-13 10:30:00 | NVDA | Stock | 0.6098 | 0.6153 | 0.6088 | 0.613 | 56793900.0 |
| 2007-06-13 11:00:00 | NVDA | Stock | 0.6128 | 0.6133 | 0.6115 | 0.6125 | 29521980.0 |
| 2007-06-13 11:30:00 | NVDA | Stock | 0.6125 | 0.6132 | 0.6113 | 0.6117 | 21191760.0 |
| 2007-06-13 12:00:00 | NVDA | Stock | 0.6117 | 0.6128 | 0.6105 | 0.6113 | 26504460.0 |
| 2007-06-13 12:30:00 | NVDA | Stock | 0.6113 | 0.6127 | 0.611 | 0.6113 | 26472960.0 |
| 2007-06-13 13:00:00 | NVDA | Stock | 0.6113 | 0.612 | 0.6103 | 0.6117 | 30567600.0 |
| 2007-06-13 13:30:00 | NVDA | Stock | 0.6117 | 0.6123 | 0.6103 | 0.611 | 29091720.0 |
| 2007-06-13 14:00:00 | NVDA | Stock | 0.611 | 0.6167 | 0.6108 | 0.6158 | 68299320.0 |
| 2007-06-13 14:30:00 | NVDA | Stock | 0.6158 | 0.6167 | 0.615 | 0.6162 | 39570420.0 |
| 2007-06-13 15:00:00 | NVDA | Stock | 0.6162 | 0.6167 | 0.6153 | 0.616 | 39628860.0 |
| 2007-06-13 15:30:00 | NVDA | Stock | 0.6162 | 0.6197 | 0.6162 | 0.6195 | 98823600.0 |
| 2007-06-13 16:00:00 | NVDA | Stock | 0.6195 | 0.6195 | 0.6167 | 0.6188 | 9613500.0 |
| 2007-06-13 16:30:00 | NVDA | Stock | 0.6173 | 0.6175 | 0.6158 | 0.6158 | 76500.0 |
| 2007-06-13 18:30:00 | NVDA | Stock | 0.617 | 0.617 | 0.616 | 0.616 | 143220.0 |
| 2007-06-13 19:30:00 | NVDA | Stock | 0.6173 | 0.6173 | 0.6173 | 0.6173 | 66000.0 |
| 2007-06-13 07:00:00 | AMZN | Stock | 3.51 | 3.51 | 3.51 | 3.51 | 4000.0 |
| 2007-06-13 08:00:00 | AMZN | Stock | 3.5235 | 3.5235 | 3.5025 | 3.515 | 33380.0 |
> showing 50 of 63,371 rows — these rows as CSV