PREVIEW / stock_30min / 2007-03-07
file: by_date/stock_30min/2007/2007-03-07.parquet size: 1.0 MB rows: 56,184 symbols: 2,532
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-03-07 09:00:00 | AAPL | Stock | 3.1429 | 3.1464 | 3.1429 | 3.1429 | 607460.0 |
| 2007-03-07 09:30:00 | AAPL | Stock | 3.1446 | 3.1775 | 3.1393 | 3.1589 | 108292688.0 |
| 2007-03-07 10:00:00 | AAPL | Stock | 3.1589 | 3.1664 | 3.155 | 3.16 | 52348912.0 |
| 2007-03-07 10:30:00 | AAPL | Stock | 3.1604 | 3.1768 | 3.1511 | 3.1571 | 51841720.0 |
| 2007-03-07 11:00:00 | AAPL | Stock | 3.1571 | 3.1586 | 3.1454 | 3.1543 | 53617256.0 |
| 2007-03-07 11:30:00 | AAPL | Stock | 3.1546 | 3.156 | 3.1457 | 3.1521 | 34786556.0 |
| 2007-03-07 12:00:00 | AAPL | Stock | 3.1525 | 3.1668 | 3.1486 | 3.1575 | 30181032.0 |
| 2007-03-07 12:30:00 | AAPL | Stock | 3.1575 | 3.1668 | 3.1564 | 3.1579 | 43397732.0 |
| 2007-03-07 13:00:00 | AAPL | Stock | 3.1579 | 3.1661 | 3.1543 | 3.1604 | 21376376.0 |
| 2007-03-07 13:30:00 | AAPL | Stock | 3.1596 | 3.1671 | 3.1579 | 3.1647 | 28345996.0 |
| 2007-03-07 14:00:00 | AAPL | Stock | 3.165 | 3.1661 | 3.15 | 3.1543 | 32551848.0 |
| 2007-03-07 14:30:00 | AAPL | Stock | 3.1546 | 3.1589 | 3.1464 | 3.1496 | 25817820.0 |
| 2007-03-07 15:00:00 | AAPL | Stock | 3.1493 | 3.1554 | 3.1361 | 3.1364 | 46781868.0 |
| 2007-03-07 15:30:00 | AAPL | Stock | 3.1361 | 3.1389 | 3.1232 | 3.1332 | 72024204.0 |
| 2007-03-07 16:00:00 | AAPL | Stock | 3.1325 | 3.1357 | 3.1304 | 3.1329 | 2722412.0 |
| 2007-03-07 16:30:00 | AAPL | Stock | 3.1325 | 3.1354 | 3.1325 | 3.1343 | 298480.0 |
| 2007-03-07 17:00:00 | AAPL | Stock | 3.1343 | 3.1357 | 3.1339 | 3.1339 | 205240.0 |
| 2007-03-07 17:30:00 | AAPL | Stock | 3.1339 | 3.1375 | 3.1339 | 3.135 | 139916.0 |
| 2007-03-07 18:00:00 | AAPL | Stock | 3.135 | 3.135 | 3.1332 | 3.1332 | 32760.0 |
| 2007-03-07 18:30:00 | AAPL | Stock | 3.135 | 3.135 | 3.1329 | 3.1339 | 48636.0 |
| 2007-03-07 19:00:00 | AAPL | Stock | 3.1325 | 3.1364 | 3.1325 | 3.1364 | 36540.0 |
| 2007-03-07 19:30:00 | AAPL | Stock | 3.1357 | 3.1382 | 3.1357 | 3.1382 | 26600.0 |
| 2007-03-07 09:00:00 | MSFT | Stock | 27.81 | 27.81 | 27.76 | 27.76 | 33300.0 |
| 2007-03-07 09:30:00 | MSFT | Stock | 27.82 | 27.9 | 27.7 | 27.742 | 3877327.0 |
| 2007-03-07 10:00:00 | MSFT | Stock | 27.742 | 27.77 | 27.69 | 27.71 | 3307372.0 |
| 2007-03-07 10:30:00 | MSFT | Stock | 27.72 | 27.77 | 27.65 | 27.66 | 3803582.0 |
| 2007-03-07 11:00:00 | MSFT | Stock | 27.66 | 27.68 | 27.63 | 27.66 | 3617808.0 |
| 2007-03-07 11:30:00 | MSFT | Stock | 27.66 | 27.67 | 27.59 | 27.62 | 4465646.0 |
| 2007-03-07 12:00:00 | MSFT | Stock | 27.627 | 27.75 | 27.62 | 27.64 | 3546471.0 |
| 2007-03-07 12:30:00 | MSFT | Stock | 27.65 | 27.75 | 27.64 | 27.65 | 3915302.0 |
| 2007-03-07 13:00:00 | MSFT | Stock | 27.65 | 27.7 | 27.64 | 27.65 | 2392292.0 |
| 2007-03-07 13:30:00 | MSFT | Stock | 27.65 | 27.75 | 27.63 | 27.66 | 2648762.0 |
| 2007-03-07 14:00:00 | MSFT | Stock | 27.66 | 27.68 | 27.61 | 27.64 | 2653690.0 |
| 2007-03-07 14:30:00 | MSFT | Stock | 27.64 | 27.72 | 27.64 | 27.69 | 2589749.0 |
| 2007-03-07 15:00:00 | MSFT | Stock | 27.68 | 27.69 | 27.65 | 27.66 | 4145154.0 |
| 2007-03-07 15:30:00 | MSFT | Stock | 27.66 | 27.68 | 27.55 | 27.6 | 7706998.0 |
| 2007-03-07 16:00:00 | MSFT | Stock | 27.6 | 27.68 | 27.58 | 27.6 | 138063.0 |
| 2007-03-07 16:30:00 | MSFT | Stock | 27.6 | 27.61 | 27.6 | 27.61 | 1119366.0 |
| 2007-03-07 17:00:00 | MSFT | Stock | 27.61 | 27.61 | 27.61 | 27.61 | 1198.0 |
| 2007-03-07 18:00:00 | MSFT | Stock | 27.61 | 27.61 | 27.61 | 27.61 | 1000.0 |
| 2007-03-07 18:30:00 | MSFT | Stock | 27.61 | 27.61 | 27.61 | 27.61 | 500.0 |
| 2007-03-07 19:00:00 | MSFT | Stock | 27.65 | 27.65 | 27.65 | 27.65 | 180.0 |
| 2007-03-07 09:00:00 | NVDA | Stock | 0.5067 | 0.5077 | 0.5052 | 0.5052 | 177000.0 |
| 2007-03-07 09:30:00 | NVDA | Stock | 0.5052 | 0.5075 | 0.5 | 0.5037 | 74550180.0 |
| 2007-03-07 10:00:00 | NVDA | Stock | 0.5037 | 0.5062 | 0.5017 | 0.5053 | 51880980.0 |
| 2007-03-07 10:30:00 | NVDA | Stock | 0.5055 | 0.5068 | 0.4992 | 0.4992 | 48700740.0 |
| 2007-03-07 11:00:00 | NVDA | Stock | 0.4993 | 0.5002 | 0.4968 | 0.4972 | 54723420.0 |
| 2007-03-07 11:30:00 | NVDA | Stock | 0.4972 | 0.5007 | 0.4963 | 0.4983 | 67077120.0 |
| 2007-03-07 12:00:00 | NVDA | Stock | 0.4985 | 0.5062 | 0.4963 | 0.4965 | 59516400.0 |
| 2007-03-07 12:30:00 | NVDA | Stock | 0.4967 | 0.5062 | 0.4952 | 0.4958 | 85377180.0 |
> showing 50 of 56,184 rows — these rows as CSV