PREVIEW / stock_30min / 2009-08-13
file: by_date/stock_30min/2009/2009-08-13.parquet size: 1.3 MB rows: 70,985 symbols: 3,362
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-08-13 05:00:00 | AAPL | Stock | 5.9446 | 5.9446 | 5.9446 | 5.9446 | 5880.0 |
| 2009-08-13 05:30:00 | AAPL | Stock | 5.9429 | 5.9607 | 5.9429 | 5.9464 | 19880.0 |
| 2009-08-13 06:00:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9464 | 5.9464 | 42000.0 |
| 2009-08-13 07:00:00 | AAPL | Stock | 5.9643 | 5.9718 | 5.9643 | 5.9679 | 144200.0 |
| 2009-08-13 07:30:00 | AAPL | Stock | 5.9646 | 5.9679 | 5.9589 | 5.9639 | 174328.0 |
| 2009-08-13 08:00:00 | AAPL | Stock | 5.9539 | 5.9736 | 5.9536 | 5.9661 | 1365896.0 |
| 2009-08-13 08:30:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9296 | 5.9521 | 2057328.0 |
| 2009-08-13 09:00:00 | AAPL | Stock | 5.9489 | 5.9643 | 5.9468 | 5.9496 | 1760444.0 |
| 2009-08-13 09:30:00 | AAPL | Stock | 5.9514 | 5.9975 | 5.9464 | 5.9754 | 98009744.0 |
| 2009-08-13 10:00:00 | AAPL | Stock | 5.9754 | 5.9907 | 5.9621 | 5.983 | 44503956.0 |
| 2009-08-13 10:30:00 | AAPL | Stock | 5.9829 | 6.0239 | 5.9754 | 6.01 | 43414084.0 |
| 2009-08-13 11:00:00 | AAPL | Stock | 6.01 | 6.0175 | 5.9996 | 6.0114 | 29747928.0 |
| 2009-08-13 11:30:00 | AAPL | Stock | 6.0118 | 6.0168 | 6.0011 | 6.0168 | 14498932.0 |
| 2009-08-13 12:00:00 | AAPL | Stock | 6.0168 | 6.0179 | 5.9946 | 6.0005 | 21055748.0 |
| 2009-08-13 12:30:00 | AAPL | Stock | 6.0007 | 6.0075 | 5.9971 | 5.9982 | 13999216.0 |
| 2009-08-13 13:00:00 | AAPL | Stock | 5.9989 | 6.0125 | 5.9893 | 5.9918 | 22491056.0 |
| 2009-08-13 13:30:00 | AAPL | Stock | 5.9921 | 6.0054 | 5.9757 | 5.9836 | 17513356.0 |
| 2009-08-13 14:00:00 | AAPL | Stock | 5.9832 | 5.985 | 5.9493 | 5.9771 | 38478692.0 |
| 2009-08-13 14:30:00 | AAPL | Stock | 5.9771 | 5.9957 | 5.9771 | 5.9779 | 18799452.0 |
| 2009-08-13 15:00:00 | AAPL | Stock | 5.9782 | 6.0 | 5.9771 | 5.9975 | 20488160.0 |
| 2009-08-13 15:30:00 | AAPL | Stock | 5.9975 | 6.0157 | 5.9954 | 6.015 | 37894724.0 |
| 2009-08-13 16:00:00 | AAPL | Stock | 6.015 | 6.0196 | 5.9895 | 6.0179 | 10935148.0 |
| 2009-08-13 16:30:00 | AAPL | Stock | 6.0186 | 6.0193 | 6.0129 | 6.0179 | 353220.0 |
| 2009-08-13 17:00:00 | AAPL | Stock | 6.015 | 6.0182 | 6.0125 | 6.015 | 132636.0 |
| 2009-08-13 17:30:00 | AAPL | Stock | 6.0143 | 6.0143 | 6.0107 | 6.0125 | 76188.0 |
| 2009-08-13 18:00:00 | AAPL | Stock | 6.015 | 6.015 | 6.0125 | 6.0125 | 261828.0 |
| 2009-08-13 18:30:00 | AAPL | Stock | 6.0143 | 6.0143 | 6.0111 | 6.0136 | 65800.0 |
| 2009-08-13 19:00:00 | AAPL | Stock | 6.0139 | 6.0143 | 6.0114 | 6.0114 | 29400.0 |
| 2009-08-13 19:30:00 | AAPL | Stock | 6.0146 | 6.0164 | 6.0146 | 6.0161 | 61432.0 |
| 2009-08-13 07:30:00 | MSFT | Stock | 23.81 | 23.84 | 23.8 | 23.8 | 6100.0 |
| 2009-08-13 08:00:00 | MSFT | Stock | 23.8 | 23.95 | 23.79 | 23.94 | 46456.0 |
| 2009-08-13 08:30:00 | MSFT | Stock | 23.91 | 23.91 | 23.65 | 23.85 | 52366.0 |
| 2009-08-13 09:00:00 | MSFT | Stock | 23.82 | 23.87 | 23.55 | 23.62 | 63567.0 |
| 2009-08-13 09:30:00 | MSFT | Stock | 23.63 | 23.69 | 23.4 | 23.466 | 5537328.0 |
| 2009-08-13 10:00:00 | MSFT | Stock | 23.46 | 23.66 | 23.43 | 23.552 | 4478755.0 |
| 2009-08-13 10:30:00 | MSFT | Stock | 23.56 | 23.81 | 23.5 | 23.71 | 3355914.0 |
| 2009-08-13 11:00:00 | MSFT | Stock | 23.718 | 23.785 | 23.68 | 23.75 | 2660418.0 |
| 2009-08-13 11:30:00 | MSFT | Stock | 23.74 | 23.85 | 23.74 | 23.81 | 1901969.0 |
| 2009-08-13 12:00:00 | MSFT | Stock | 23.82 | 23.83 | 23.7 | 23.71 | 1496282.0 |
| 2009-08-13 12:30:00 | MSFT | Stock | 23.71 | 23.72 | 23.66 | 23.67 | 1331494.0 |
| 2009-08-13 13:00:00 | MSFT | Stock | 23.671 | 23.77 | 23.64 | 23.67 | 1949703.0 |
| 2009-08-13 13:30:00 | MSFT | Stock | 23.67 | 23.7 | 23.59 | 23.593 | 1066576.0 |
| 2009-08-13 14:00:00 | MSFT | Stock | 23.599 | 23.6 | 23.5 | 23.53 | 2169583.0 |
| 2009-08-13 14:30:00 | MSFT | Stock | 23.531 | 23.6 | 23.52 | 23.525 | 1569745.0 |
| 2009-08-13 15:00:00 | MSFT | Stock | 23.528 | 23.6 | 23.51 | 23.54 | 2819748.0 |
| 2009-08-13 15:30:00 | MSFT | Stock | 23.549 | 23.66 | 23.53 | 23.63 | 5280372.0 |
| 2009-08-13 16:00:00 | MSFT | Stock | 23.63 | 23.68 | 23.605 | 23.62 | 2189371.0 |
| 2009-08-13 16:30:00 | MSFT | Stock | 23.64 | 23.65 | 23.63 | 23.64 | 7877.0 |
| 2009-08-13 17:00:00 | MSFT | Stock | 23.65 | 23.65 | 23.65 | 23.65 | 400.0 |
| 2009-08-13 17:30:00 | MSFT | Stock | 23.64 | 23.68 | 23.63 | 23.68 | 2413.0 |
> showing 50 of 70,985 rows — these rows as CSV