PREVIEW / stock_30min / 2009-03-10
file: by_date/stock_30min/2009/2009-03-10.parquet size: 1.3 MB rows: 71,314 symbols: 3,361
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-10 04:00:00 | AAPL | Stock | 3.0046 | 3.0046 | 3.0046 | 3.0046 | 19600.0 |
| 2009-03-10 04:30:00 | AAPL | Stock | 3.0046 | 3.0046 | 3.0046 | 3.0046 | 8400.0 |
| 2009-03-10 06:30:00 | AAPL | Stock | 3.0136 | 3.0136 | 3.0136 | 3.0136 | 2800.0 |
| 2009-03-10 07:00:00 | AAPL | Stock | 3.0146 | 3.0161 | 3.0146 | 3.0161 | 5600.0 |
| 2009-03-10 07:30:00 | AAPL | Stock | 3.0161 | 3.0264 | 3.0161 | 3.0179 | 140000.0 |
| 2009-03-10 08:00:00 | AAPL | Stock | 3.0179 | 3.0357 | 3.0179 | 3.0264 | 795452.0 |
| 2009-03-10 08:30:00 | AAPL | Stock | 3.0268 | 3.0489 | 3.0268 | 3.0411 | 1258628.0 |
| 2009-03-10 09:00:00 | AAPL | Stock | 3.0386 | 3.04 | 3.0232 | 3.0311 | 1243984.0 |
| 2009-03-10 09:30:00 | AAPL | Stock | 3.0311 | 3.0946 | 3.0129 | 3.0496 | 110385240.0 |
| 2009-03-10 10:00:00 | AAPL | Stock | 3.0497 | 3.1196 | 3.0482 | 3.1071 | 79308628.0 |
| 2009-03-10 10:30:00 | AAPL | Stock | 3.1075 | 3.1371 | 3.0982 | 3.1239 | 70040376.0 |
| 2009-03-10 11:00:00 | AAPL | Stock | 3.1239 | 3.1286 | 3.0986 | 3.1236 | 54033644.0 |
| 2009-03-10 11:30:00 | AAPL | Stock | 3.1232 | 3.1471 | 3.1136 | 3.1461 | 31728760.0 |
| 2009-03-10 12:00:00 | AAPL | Stock | 3.1464 | 3.1663 | 3.1429 | 3.1518 | 44232692.0 |
| 2009-03-10 12:30:00 | AAPL | Stock | 3.1525 | 3.1582 | 3.1396 | 3.1446 | 35993524.0 |
| 2009-03-10 13:00:00 | AAPL | Stock | 3.1454 | 3.1689 | 3.1443 | 3.1596 | 35315784.0 |
| 2009-03-10 13:30:00 | AAPL | Stock | 3.1593 | 3.1846 | 3.1561 | 3.1629 | 42831852.0 |
| 2009-03-10 14:00:00 | AAPL | Stock | 3.1632 | 3.1746 | 3.1468 | 3.1543 | 49163156.0 |
| 2009-03-10 14:30:00 | AAPL | Stock | 3.1539 | 3.1679 | 3.1254 | 3.155 | 66458000.0 |
| 2009-03-10 15:00:00 | AAPL | Stock | 3.155 | 3.1696 | 3.14 | 3.1611 | 55836900.0 |
| 2009-03-10 15:30:00 | AAPL | Stock | 3.1604 | 3.1782 | 3.129 | 3.1586 | 103599328.0 |
| 2009-03-10 16:00:00 | AAPL | Stock | 3.1621 | 3.1696 | 3.1278 | 3.1639 | 33362728.0 |
| 2009-03-10 16:30:00 | AAPL | Stock | 3.1671 | 3.1671 | 3.1294 | 3.1661 | 17870020.0 |
| 2009-03-10 17:00:00 | AAPL | Stock | 3.1671 | 3.1704 | 3.1664 | 3.1696 | 67284.0 |
| 2009-03-10 17:30:00 | AAPL | Stock | 3.1682 | 3.1693 | 3.1294 | 3.1686 | 300720.0 |
| 2009-03-10 18:00:00 | AAPL | Stock | 3.1682 | 3.1768 | 3.1654 | 3.1768 | 1549492.0 |
| 2009-03-10 18:30:00 | AAPL | Stock | 3.1768 | 3.1768 | 3.1743 | 3.1754 | 32200.0 |
| 2009-03-10 19:00:00 | AAPL | Stock | 3.1754 | 3.1768 | 3.1714 | 3.1768 | 30240.0 |
| 2009-03-10 19:30:00 | AAPL | Stock | 3.1775 | 3.1818 | 3.1761 | 3.1789 | 133224.0 |
| 2009-03-10 06:30:00 | MSFT | Stock | 15.32 | 15.4 | 15.32 | 15.4 | 690.0 |
| 2009-03-10 07:00:00 | MSFT | Stock | 15.4 | 15.5 | 15.36 | 15.36 | 1276.0 |
| 2009-03-10 07:30:00 | MSFT | Stock | 15.37 | 15.37 | 15.36 | 15.36 | 2100.0 |
| 2009-03-10 08:00:00 | MSFT | Stock | 15.39 | 15.4 | 15.3 | 15.35 | 42842.0 |
| 2009-03-10 08:30:00 | MSFT | Stock | 15.37 | 15.39 | 15.36 | 15.36 | 19450.0 |
| 2009-03-10 09:00:00 | MSFT | Stock | 15.39 | 15.45 | 15.35 | 15.36 | 86207.0 |
| 2009-03-10 09:30:00 | MSFT | Stock | 15.4 | 15.73 | 15.25 | 15.61 | 10616359.0 |
| 2009-03-10 10:00:00 | MSFT | Stock | 15.6 | 15.85 | 15.59 | 15.844 | 6060633.0 |
| 2009-03-10 10:30:00 | MSFT | Stock | 15.84 | 16.09 | 15.84 | 16.03 | 6762269.0 |
| 2009-03-10 11:00:00 | MSFT | Stock | 16.02 | 16.15 | 15.945 | 16.14 | 6582719.0 |
| 2009-03-10 11:30:00 | MSFT | Stock | 16.14 | 16.37 | 16.1 | 16.36 | 5928624.0 |
| 2009-03-10 12:00:00 | MSFT | Stock | 16.36 | 16.42 | 16.28 | 16.295 | 6522847.0 |
| 2009-03-10 12:30:00 | MSFT | Stock | 16.295 | 16.32 | 16.15 | 16.184 | 3179011.0 |
| 2009-03-10 13:00:00 | MSFT | Stock | 16.18 | 16.31 | 16.15 | 16.29 | 3080716.0 |
| 2009-03-10 13:30:00 | MSFT | Stock | 16.29 | 16.42 | 16.24 | 16.26 | 3706514.0 |
| 2009-03-10 14:00:00 | MSFT | Stock | 16.26 | 16.32 | 16.2 | 16.26 | 4121748.0 |
| 2009-03-10 14:30:00 | MSFT | Stock | 16.26 | 16.34 | 16.13 | 16.31 | 4452577.0 |
| 2009-03-10 15:00:00 | MSFT | Stock | 16.31 | 16.42 | 16.28 | 16.36 | 4894590.0 |
| 2009-03-10 15:30:00 | MSFT | Stock | 16.37 | 16.62 | 16.3 | 16.62 | 14437521.0 |
| 2009-03-10 16:00:00 | MSFT | Stock | 16.62 | 16.62 | 15.729 | 16.49 | 10512909.0 |
| 2009-03-10 16:30:00 | MSFT | Stock | 16.62 | 16.62 | 16.315 | 16.5 | 3092473.0 |
> showing 50 of 71,314 rows — these rows as CSV