PREVIEW / stock_5min / 2010-11-24
file: by_date/stock_5min/2010/2010-11-24.parquet size: 4.7 MB rows: 328,277 symbols: 3,510
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-24 04:00:00 | AAPL | Stock | 11.025 | 11.0357 | 10.9475 | 10.9475 | 42000.0 |
| 2010-11-24 04:20:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 2800.0 |
| 2010-11-24 04:25:00 | AAPL | Stock | 10.9854 | 10.9854 | 10.9714 | 10.9714 | 5600.0 |
| 2010-11-24 04:45:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 2800.0 |
| 2010-11-24 04:55:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 2800.0 |
| 2010-11-24 05:05:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 2800.0 |
| 2010-11-24 05:25:00 | AAPL | Stock | 10.975 | 10.975 | 10.975 | 10.975 | 5600.0 |
| 2010-11-24 05:35:00 | AAPL | Stock | 10.9882 | 10.9893 | 10.9882 | 10.9893 | 5600.0 |
| 2010-11-24 05:40:00 | AAPL | Stock | 10.9811 | 10.9811 | 10.9807 | 10.9807 | 5600.0 |
| 2010-11-24 05:45:00 | AAPL | Stock | 10.9807 | 10.9807 | 10.9807 | 10.9807 | 2800.0 |
| 2010-11-24 05:50:00 | AAPL | Stock | 10.9893 | 10.9893 | 10.9893 | 10.9893 | 8400.0 |
| 2010-11-24 06:00:00 | AAPL | Stock | 11.0036 | 11.0036 | 11.0036 | 11.0036 | 8400.0 |
| 2010-11-24 06:05:00 | AAPL | Stock | 11.0111 | 11.0111 | 11.0111 | 11.0111 | 5600.0 |
| 2010-11-24 06:15:00 | AAPL | Stock | 11.0179 | 11.0271 | 11.0179 | 11.0271 | 5600.0 |
| 2010-11-24 06:25:00 | AAPL | Stock | 11.0286 | 11.0286 | 11.0286 | 11.0286 | 2800.0 |
| 2010-11-24 06:35:00 | AAPL | Stock | 11.0429 | 11.0461 | 11.0414 | 11.0461 | 36400.0 |
| 2010-11-24 06:40:00 | AAPL | Stock | 11.0321 | 11.0321 | 11.0321 | 11.0321 | 2800.0 |
| 2010-11-24 06:45:00 | AAPL | Stock | 11.0321 | 11.0393 | 11.0321 | 11.0321 | 19600.0 |
| 2010-11-24 06:50:00 | AAPL | Stock | 11.0321 | 11.0321 | 11.0321 | 11.0321 | 5600.0 |
| 2010-11-24 06:55:00 | AAPL | Stock | 11.0261 | 11.0261 | 11.0261 | 11.0261 | 2800.0 |
| 2010-11-24 07:00:00 | AAPL | Stock | 11.025 | 11.0393 | 11.025 | 11.0393 | 36400.0 |
| 2010-11-24 07:05:00 | AAPL | Stock | 11.0425 | 11.0429 | 11.025 | 11.025 | 147000.0 |
| 2010-11-24 07:15:00 | AAPL | Stock | 11.0254 | 11.0368 | 11.0254 | 11.0368 | 5600.0 |
| 2010-11-24 07:20:00 | AAPL | Stock | 11.0254 | 11.0479 | 11.0254 | 11.0479 | 27748.0 |
| 2010-11-24 07:25:00 | AAPL | Stock | 11.0482 | 11.05 | 11.0475 | 11.0496 | 16800.0 |
| 2010-11-24 07:30:00 | AAPL | Stock | 11.0479 | 11.0511 | 11.0479 | 11.0511 | 8400.0 |
| 2010-11-24 07:35:00 | AAPL | Stock | 11.0514 | 11.0568 | 11.0514 | 11.0543 | 61600.0 |
| 2010-11-24 07:40:00 | AAPL | Stock | 11.0539 | 11.0607 | 11.0479 | 11.0607 | 26320.0 |
| 2010-11-24 07:45:00 | AAPL | Stock | 11.0625 | 11.0643 | 11.0625 | 11.0643 | 112000.0 |
| 2010-11-24 07:50:00 | AAPL | Stock | 11.0646 | 11.07 | 11.0646 | 11.07 | 28000.0 |
| 2010-11-24 07:55:00 | AAPL | Stock | 11.0689 | 11.075 | 11.0689 | 11.0718 | 86380.0 |
| 2010-11-24 08:00:00 | AAPL | Stock | 11.0746 | 11.0871 | 11.0671 | 11.0857 | 891520.0 |
| 2010-11-24 08:05:00 | AAPL | Stock | 11.0854 | 11.0864 | 11.0811 | 11.0861 | 139720.0 |
| 2010-11-24 08:10:00 | AAPL | Stock | 11.0857 | 11.0936 | 11.085 | 11.085 | 383684.0 |
| 2010-11-24 08:15:00 | AAPL | Stock | 11.0871 | 11.0911 | 11.0871 | 11.0875 | 50820.0 |
| 2010-11-24 08:20:00 | AAPL | Stock | 11.0875 | 11.1029 | 11.0857 | 11.1 | 254744.0 |
| 2010-11-24 08:25:00 | AAPL | Stock | 11.1004 | 11.1214 | 11.1 | 11.1196 | 766360.0 |
| 2010-11-24 08:30:00 | AAPL | Stock | 11.1196 | 11.1589 | 11.1014 | 11.1589 | 1117312.0 |
| 2010-11-24 08:35:00 | AAPL | Stock | 11.1564 | 11.1804 | 11.1482 | 11.1668 | 1260588.0 |
| 2010-11-24 08:40:00 | AAPL | Stock | 11.1661 | 11.1761 | 11.1589 | 11.1696 | 653240.0 |
| 2010-11-24 08:45:00 | AAPL | Stock | 11.1639 | 11.1696 | 11.1454 | 11.1493 | 792316.0 |
| 2010-11-24 08:50:00 | AAPL | Stock | 11.1493 | 11.1607 | 11.1493 | 11.1561 | 309568.0 |
| 2010-11-24 08:55:00 | AAPL | Stock | 11.1561 | 11.16 | 11.1504 | 11.1504 | 292544.0 |
| 2010-11-24 09:00:00 | AAPL | Stock | 11.1521 | 11.1579 | 11.1504 | 11.1579 | 212660.0 |
| 2010-11-24 09:05:00 | AAPL | Stock | 11.1554 | 11.1568 | 11.1504 | 11.1507 | 170464.0 |
| 2010-11-24 09:10:00 | AAPL | Stock | 11.1511 | 11.1554 | 11.1429 | 11.1429 | 628068.0 |
| 2010-11-24 09:15:00 | AAPL | Stock | 11.1425 | 11.1482 | 11.1346 | 11.1482 | 312760.0 |
| 2010-11-24 09:20:00 | AAPL | Stock | 11.1482 | 11.1482 | 11.1368 | 11.1429 | 73276.0 |
| 2010-11-24 09:25:00 | AAPL | Stock | 11.1493 | 11.1554 | 11.1371 | 11.1468 | 203112.0 |
| 2010-11-24 09:30:00 | AAPL | Stock | 11.1461 | 11.1696 | 11.1364 | 11.1646 | 21085988.0 |
> showing 50 of 328,277 rows — these rows as CSV