PREVIEW / stock_30min / 2009-12-22
file: by_date/stock_30min/2009/2009-12-22.parquet size: 1.3 MB rows: 72,600 symbols: 3,444
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-12-22 04:30:00 | AAPL | Stock | 7.0836 | 7.0836 | 7.0836 | 7.0836 | 5600.0 |
| 2009-12-22 05:30:00 | AAPL | Stock | 7.0914 | 7.0914 | 7.0914 | 7.0914 | 8400.0 |
| 2009-12-22 06:00:00 | AAPL | Stock | 7.0882 | 7.0882 | 7.0882 | 7.0882 | 14000.0 |
| 2009-12-22 06:30:00 | AAPL | Stock | 7.0961 | 7.0961 | 7.0811 | 7.0811 | 23800.0 |
| 2009-12-22 07:00:00 | AAPL | Stock | 7.0893 | 7.1175 | 7.0714 | 7.1175 | 56532.0 |
| 2009-12-22 07:30:00 | AAPL | Stock | 7.1161 | 7.1171 | 7.1093 | 7.1132 | 313236.0 |
| 2009-12-22 08:00:00 | AAPL | Stock | 7.1143 | 7.1193 | 7.0796 | 7.1118 | 1447264.0 |
| 2009-12-22 08:30:00 | AAPL | Stock | 7.1114 | 7.1161 | 7.0932 | 7.1132 | 1769180.0 |
| 2009-12-22 09:00:00 | AAPL | Stock | 7.1112 | 7.1232 | 7.1039 | 7.1232 | 1007832.0 |
| 2009-12-22 09:30:00 | AAPL | Stock | 7.1229 | 7.1732 | 7.1036 | 7.135 | 81005792.0 |
| 2009-12-22 10:00:00 | AAPL | Stock | 7.1357 | 7.1432 | 7.1111 | 7.1393 | 41173272.0 |
| 2009-12-22 10:30:00 | AAPL | Stock | 7.1386 | 7.14 | 7.1176 | 7.1254 | 18921000.0 |
| 2009-12-22 11:00:00 | AAPL | Stock | 7.125 | 7.1264 | 7.1089 | 7.1091 | 21062468.0 |
| 2009-12-22 11:30:00 | AAPL | Stock | 7.1089 | 7.125 | 7.095 | 7.1214 | 20777316.0 |
| 2009-12-22 12:00:00 | AAPL | Stock | 7.1212 | 7.1214 | 7.1118 | 7.1186 | 9113468.0 |
| 2009-12-22 12:30:00 | AAPL | Stock | 7.1175 | 7.1414 | 7.1146 | 7.1386 | 16523444.0 |
| 2009-12-22 13:00:00 | AAPL | Stock | 7.1382 | 7.1582 | 7.1371 | 7.1507 | 24062360.0 |
| 2009-12-22 13:30:00 | AAPL | Stock | 7.1507 | 7.1521 | 7.1325 | 7.1407 | 12717320.0 |
| 2009-12-22 14:00:00 | AAPL | Stock | 7.1404 | 7.1454 | 7.1271 | 7.1368 | 14228508.0 |
| 2009-12-22 14:30:00 | AAPL | Stock | 7.1361 | 7.1496 | 7.1329 | 7.1347 | 12968480.0 |
| 2009-12-22 15:00:00 | AAPL | Stock | 7.1336 | 7.1496 | 7.1286 | 7.1457 | 17810772.0 |
| 2009-12-22 15:30:00 | AAPL | Stock | 7.145 | 7.1643 | 7.1393 | 7.1604 | 43228920.0 |
| 2009-12-22 16:00:00 | AAPL | Stock | 7.1589 | 7.1671 | 7.1354 | 7.1646 | 5091380.0 |
| 2009-12-22 16:30:00 | AAPL | Stock | 7.1087 | 7.1696 | 7.1087 | 7.1639 | 350448.0 |
| 2009-12-22 17:00:00 | AAPL | Stock | 7.165 | 7.1689 | 7.1639 | 7.1679 | 148764.0 |
| 2009-12-22 17:30:00 | AAPL | Stock | 7.1696 | 7.1696 | 7.165 | 7.1696 | 144592.0 |
| 2009-12-22 18:00:00 | AAPL | Stock | 7.1654 | 7.1696 | 7.1557 | 7.1696 | 260540.0 |
| 2009-12-22 18:30:00 | AAPL | Stock | 7.1714 | 7.1714 | 7.1607 | 7.1646 | 246652.0 |
| 2009-12-22 19:00:00 | AAPL | Stock | 7.1661 | 7.1714 | 7.1643 | 7.1643 | 43400.0 |
| 2009-12-22 19:30:00 | AAPL | Stock | 7.1614 | 7.1696 | 7.1614 | 7.1693 | 169176.0 |
| 2009-12-22 05:30:00 | MSFT | Stock | 30.52 | 30.52 | 30.52 | 30.52 | 600.0 |
| 2009-12-22 06:30:00 | MSFT | Stock | 30.55 | 30.55 | 30.55 | 30.55 | 1000.0 |
| 2009-12-22 07:00:00 | MSFT | Stock | 30.64 | 30.65 | 30.64 | 30.65 | 2000.0 |
| 2009-12-22 07:30:00 | MSFT | Stock | 30.65 | 30.65 | 30.6 | 30.6 | 1430.0 |
| 2009-12-22 08:00:00 | MSFT | Stock | 30.64 | 30.64 | 30.52 | 30.56 | 48150.0 |
| 2009-12-22 08:30:00 | MSFT | Stock | 30.56 | 30.65 | 30.56 | 30.65 | 15041.0 |
| 2009-12-22 09:00:00 | MSFT | Stock | 30.62 | 30.7 | 30.57 | 30.6 | 132105.0 |
| 2009-12-22 09:30:00 | MSFT | Stock | 30.6 | 30.68 | 30.54 | 30.67 | 3357319.0 |
| 2009-12-22 10:00:00 | MSFT | Stock | 30.68 | 30.9 | 30.63 | 30.88 | 3719054.0 |
| 2009-12-22 10:30:00 | MSFT | Stock | 30.885 | 30.9 | 30.8 | 30.873 | 1982737.0 |
| 2009-12-22 11:00:00 | MSFT | Stock | 30.87 | 30.89 | 30.7 | 30.71 | 2534942.0 |
| 2009-12-22 11:30:00 | MSFT | Stock | 30.71 | 30.85 | 30.67 | 30.85 | 1801462.0 |
| 2009-12-22 12:00:00 | MSFT | Stock | 30.85 | 30.85 | 30.76 | 30.82 | 1370793.0 |
| 2009-12-22 12:30:00 | MSFT | Stock | 30.82 | 30.87 | 30.81 | 30.86 | 1871763.0 |
| 2009-12-22 13:00:00 | MSFT | Stock | 30.865 | 30.93 | 30.84 | 30.892 | 2128900.0 |
| 2009-12-22 13:30:00 | MSFT | Stock | 30.88 | 30.9 | 30.83 | 30.83 | 1868858.0 |
| 2009-12-22 14:00:00 | MSFT | Stock | 30.833 | 30.84 | 30.72 | 30.72 | 1795202.0 |
| 2009-12-22 14:30:00 | MSFT | Stock | 30.72 | 30.82 | 30.71 | 30.795 | 1504075.0 |
| 2009-12-22 15:00:00 | MSFT | Stock | 30.795 | 30.84 | 30.77 | 30.827 | 2258720.0 |
| 2009-12-22 15:30:00 | MSFT | Stock | 30.825 | 30.88 | 30.77 | 30.82 | 6166478.0 |
> showing 50 of 72,600 rows — these rows as CSV