PREVIEW / stock_30min / 2005-01-04
file: by_date/stock_30min/2005/2005-01-04.parquet size: 833 KB rows: 44,441 symbols: 1,916
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-04 08:00:00 | AAPL | Stock | 1.1348 | 1.1446 | 1.1348 | 1.1375 | 3031336.0 |
| 2005-01-04 08:30:00 | AAPL | Stock | 1.1375 | 1.1436 | 1.1375 | 1.1393 | 1542016.0 |
| 2005-01-04 09:00:00 | AAPL | Stock | 1.1311 | 1.1411 | 1.1311 | 1.1393 | 3360112.0 |
| 2005-01-04 09:30:00 | AAPL | Stock | 1.1393 | 1.1518 | 1.1309 | 1.1473 | 139397160.0 |
| 2005-01-04 10:00:00 | AAPL | Stock | 1.1475 | 1.1691 | 1.1339 | 1.1634 | 209097112.0 |
| 2005-01-04 10:30:00 | AAPL | Stock | 1.1636 | 1.1679 | 1.1545 | 1.1666 | 106876112.0 |
| 2005-01-04 11:00:00 | AAPL | Stock | 1.1666 | 1.168 | 1.1563 | 1.1596 | 91973000.0 |
| 2005-01-04 11:30:00 | AAPL | Stock | 1.16 | 1.1623 | 1.1586 | 1.1589 | 39418960.0 |
| 2005-01-04 12:00:00 | AAPL | Stock | 1.1589 | 1.1598 | 1.1473 | 1.1507 | 81549272.0 |
| 2005-01-04 12:30:00 | AAPL | Stock | 1.1509 | 1.157 | 1.1504 | 1.1536 | 31542280.0 |
| 2005-01-04 13:00:00 | AAPL | Stock | 1.1534 | 1.1545 | 1.1475 | 1.1491 | 39618824.0 |
| 2005-01-04 13:30:00 | AAPL | Stock | 1.1493 | 1.1518 | 1.1443 | 1.1469 | 32648000.0 |
| 2005-01-04 14:00:00 | AAPL | Stock | 1.147 | 1.147 | 1.133 | 1.1363 | 84133896.0 |
| 2005-01-04 14:30:00 | AAPL | Stock | 1.1364 | 1.1379 | 1.1245 | 1.1377 | 87486840.0 |
| 2005-01-04 15:00:00 | AAPL | Stock | 1.1377 | 1.1421 | 1.1268 | 1.1409 | 57954064.0 |
| 2005-01-04 15:30:00 | AAPL | Stock | 1.1409 | 1.147 | 1.1393 | 1.1418 | 69442240.0 |
| 2005-01-04 16:00:00 | AAPL | Stock | 1.142 | 1.1432 | 1.1393 | 1.1418 | 2009336.0 |
| 2005-01-04 16:30:00 | AAPL | Stock | 1.1429 | 1.1438 | 1.1418 | 1.1438 | 1242976.0 |
| 2005-01-04 17:00:00 | AAPL | Stock | 1.1445 | 1.1473 | 1.1417 | 1.1438 | 1379000.0 |
| 2005-01-04 17:30:00 | AAPL | Stock | 1.1438 | 1.1454 | 1.1438 | 1.1454 | 109200.0 |
| 2005-01-04 18:00:00 | AAPL | Stock | 1.1446 | 1.1473 | 1.1446 | 1.1473 | 126000.0 |
| 2005-01-04 08:00:00 | MSFT | Stock | 26.84 | 26.84 | 26.79 | 26.82 | 16529.0 |
| 2005-01-04 08:30:00 | MSFT | Stock | 26.81 | 26.89 | 26.81 | 26.88 | 154685.0 |
| 2005-01-04 09:00:00 | MSFT | Stock | 26.87 | 26.88 | 26.8 | 26.84 | 133070.0 |
| 2005-01-04 09:30:00 | MSFT | Stock | 26.86 | 27.03 | 26.84 | 26.95 | 17295181.0 |
| 2005-01-04 10:00:00 | MSFT | Stock | 26.95 | 27.1 | 26.93 | 27.03 | 11586867.0 |
| 2005-01-04 10:30:00 | MSFT | Stock | 27.03 | 27.06 | 26.88 | 26.9 | 6896235.0 |
| 2005-01-04 11:00:00 | MSFT | Stock | 26.89 | 27.01 | 26.87 | 26.98 | 7137072.0 |
| 2005-01-04 11:30:00 | MSFT | Stock | 26.98 | 27.08 | 26.98 | 26.98 | 6115565.0 |
| 2005-01-04 12:00:00 | MSFT | Stock | 26.98 | 26.98 | 26.91 | 26.94 | 4329037.0 |
| 2005-01-04 12:30:00 | MSFT | Stock | 26.94 | 26.98 | 26.89 | 26.95 | 5019132.0 |
| 2005-01-04 13:00:00 | MSFT | Stock | 26.95 | 26.98 | 26.92 | 26.93 | 2961320.0 |
| 2005-01-04 13:30:00 | MSFT | Stock | 26.93 | 26.98 | 26.9 | 26.91 | 3062634.0 |
| 2005-01-04 14:00:00 | MSFT | Stock | 26.91 | 26.92 | 26.76 | 26.78 | 6174623.0 |
| 2005-01-04 14:30:00 | MSFT | Stock | 26.79 | 26.81 | 26.66 | 26.81 | 7227824.0 |
| 2005-01-04 15:00:00 | MSFT | Stock | 26.81 | 26.99 | 26.68 | 26.83 | 11327915.0 |
| 2005-01-04 15:30:00 | MSFT | Stock | 26.84 | 26.94 | 26.78 | 26.84 | 14704565.0 |
| 2005-01-04 16:00:00 | MSFT | Stock | 26.83 | 26.93 | 26.8 | 26.86 | 2407341.0 |
| 2005-01-04 16:30:00 | MSFT | Stock | 26.86 | 26.88 | 26.84 | 26.84 | 24266.0 |
| 2005-01-04 17:00:00 | MSFT | Stock | 26.86 | 26.86 | 26.71 | 26.8 | 298979.0 |
| 2005-01-04 17:30:00 | MSFT | Stock | 26.76 | 26.84 | 26.76 | 26.84 | 11400.0 |
| 2005-01-04 18:00:00 | MSFT | Stock | 26.8 | 26.8 | 26.8 | 26.8 | 500.0 |
| 2005-01-04 08:00:00 | NVDA | Stock | 0.1965 | 0.1965 | 0.1965 | 0.1965 | 12000.0 |
| 2005-01-04 08:30:00 | NVDA | Stock | 0.1969 | 0.1988 | 0.1967 | 0.1988 | 456240.0 |
| 2005-01-04 09:00:00 | NVDA | Stock | 0.1967 | 0.1982 | 0.1967 | 0.1979 | 15690480.0 |
| 2005-01-04 09:30:00 | NVDA | Stock | 0.1979 | 0.1982 | 0.193 | 0.1933 | 78116880.0 |
| 2005-01-04 10:00:00 | NVDA | Stock | 0.1933 | 0.1949 | 0.1912 | 0.1917 | 74602920.0 |
| 2005-01-04 10:30:00 | NVDA | Stock | 0.1917 | 0.1925 | 0.1907 | 0.1909 | 72368880.0 |
| 2005-01-04 11:00:00 | NVDA | Stock | 0.1908 | 0.1914 | 0.1899 | 0.1911 | 41709360.0 |
| 2005-01-04 11:30:00 | NVDA | Stock | 0.1911 | 0.1913 | 0.1907 | 0.1911 | 24162120.0 |
> showing 50 of 44,441 rows — these rows as CSV