PREVIEW / stock_5min / 2006-05-24
file: by_date/stock_5min/2006/2006-05-24.parquet size: 3.2 MB rows: 232,287 symbols: 2,272
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-24 06:40:00 | AAPL | Stock | 2.25 | 2.25 | 2.25 | 2.25 | 2800.0 |
| 2006-05-24 06:55:00 | AAPL | Stock | 2.25 | 2.25 | 2.25 | 2.25 | 53200.0 |
| 2006-05-24 07:30:00 | AAPL | Stock | 2.25 | 2.25 | 2.25 | 2.25 | 2800.0 |
| 2006-05-24 07:40:00 | AAPL | Stock | 2.2464 | 2.2464 | 2.2464 | 2.2464 | 11200.0 |
| 2006-05-24 08:00:00 | AAPL | Stock | 2.2504 | 2.26 | 2.2504 | 2.26 | 111216.0 |
| 2006-05-24 08:05:00 | AAPL | Stock | 2.2589 | 2.2643 | 2.2589 | 2.2639 | 117600.0 |
| 2006-05-24 08:10:00 | AAPL | Stock | 2.2607 | 2.2607 | 2.2607 | 2.2607 | 69720.0 |
| 2006-05-24 08:15:00 | AAPL | Stock | 2.2614 | 2.2639 | 2.2607 | 2.2618 | 81704.0 |
| 2006-05-24 08:20:00 | AAPL | Stock | 2.2618 | 2.2636 | 2.2607 | 2.2636 | 201320.0 |
| 2006-05-24 08:25:00 | AAPL | Stock | 2.2632 | 2.2636 | 2.2607 | 2.2607 | 67200.0 |
| 2006-05-24 08:30:00 | AAPL | Stock | 2.2607 | 2.2657 | 2.2607 | 2.2657 | 435400.0 |
| 2006-05-24 08:35:00 | AAPL | Stock | 2.2643 | 2.2643 | 2.2536 | 2.2536 | 151620.0 |
| 2006-05-24 08:40:00 | AAPL | Stock | 2.2539 | 2.2607 | 2.2536 | 2.2604 | 124096.0 |
| 2006-05-24 08:45:00 | AAPL | Stock | 2.2589 | 2.2621 | 2.2589 | 2.2621 | 135800.0 |
| 2006-05-24 08:50:00 | AAPL | Stock | 2.2625 | 2.2625 | 2.2607 | 2.2621 | 50400.0 |
| 2006-05-24 08:55:00 | AAPL | Stock | 2.2621 | 2.2643 | 2.2621 | 2.2643 | 326200.0 |
| 2006-05-24 09:00:00 | AAPL | Stock | 2.2636 | 2.2643 | 2.2593 | 2.2593 | 164052.0 |
| 2006-05-24 09:05:00 | AAPL | Stock | 2.2593 | 2.2625 | 2.2593 | 2.2625 | 86800.0 |
| 2006-05-24 09:10:00 | AAPL | Stock | 2.2639 | 2.2643 | 2.2539 | 2.2579 | 220612.0 |
| 2006-05-24 09:15:00 | AAPL | Stock | 2.2568 | 2.2589 | 2.2539 | 2.2539 | 49140.0 |
| 2006-05-24 09:20:00 | AAPL | Stock | 2.2539 | 2.2575 | 2.2539 | 2.2554 | 627200.0 |
| 2006-05-24 09:25:00 | AAPL | Stock | 2.2554 | 2.2571 | 2.2389 | 2.2446 | 3767624.0 |
| 2006-05-24 09:30:00 | AAPL | Stock | 2.2496 | 2.2543 | 2.2143 | 2.22 | 35059024.0 |
| 2006-05-24 09:35:00 | AAPL | Stock | 2.22 | 2.2511 | 2.2196 | 2.2439 | 31548916.0 |
| 2006-05-24 09:40:00 | AAPL | Stock | 2.2436 | 2.2568 | 2.2404 | 2.2546 | 19104960.0 |
| 2006-05-24 09:45:00 | AAPL | Stock | 2.2539 | 2.2554 | 2.245 | 2.2511 | 20895420.0 |
| 2006-05-24 09:50:00 | AAPL | Stock | 2.2511 | 2.2614 | 2.2475 | 2.2482 | 20634516.0 |
| 2006-05-24 09:55:00 | AAPL | Stock | 2.2482 | 2.2636 | 2.2482 | 2.2611 | 13137236.0 |
| 2006-05-24 10:00:00 | AAPL | Stock | 2.2607 | 2.2671 | 2.2554 | 2.2665 | 18461296.0 |
| 2006-05-24 10:05:00 | AAPL | Stock | 2.2657 | 2.2711 | 2.2604 | 2.2629 | 14187796.0 |
| 2006-05-24 10:10:00 | AAPL | Stock | 2.2629 | 2.2649 | 2.2504 | 2.255 | 12963692.0 |
| 2006-05-24 10:15:00 | AAPL | Stock | 2.2543 | 2.2579 | 2.2504 | 2.2568 | 10804976.0 |
| 2006-05-24 10:20:00 | AAPL | Stock | 2.2564 | 2.2621 | 2.2539 | 2.26 | 7303100.0 |
| 2006-05-24 10:25:00 | AAPL | Stock | 2.2596 | 2.2654 | 2.2536 | 2.2611 | 9982280.0 |
| 2006-05-24 10:30:00 | AAPL | Stock | 2.2607 | 2.2657 | 2.255 | 2.2618 | 9678844.0 |
| 2006-05-24 10:35:00 | AAPL | Stock | 2.2618 | 2.2732 | 2.2614 | 2.2671 | 16968252.0 |
| 2006-05-24 10:40:00 | AAPL | Stock | 2.2675 | 2.2721 | 2.2607 | 2.2625 | 8226148.0 |
| 2006-05-24 10:45:00 | AAPL | Stock | 2.2625 | 2.2643 | 2.2586 | 2.2596 | 7229432.0 |
| 2006-05-24 10:50:00 | AAPL | Stock | 2.2593 | 2.2675 | 2.2582 | 2.2611 | 8086876.0 |
| 2006-05-24 10:55:00 | AAPL | Stock | 2.2611 | 2.2611 | 2.2546 | 2.2596 | 8267924.0 |
| 2006-05-24 11:00:00 | AAPL | Stock | 2.2593 | 2.2596 | 2.2518 | 2.2532 | 10393656.0 |
| 2006-05-24 11:05:00 | AAPL | Stock | 2.2532 | 2.2536 | 2.2432 | 2.2478 | 11197564.0 |
| 2006-05-24 11:10:00 | AAPL | Stock | 2.2471 | 2.2539 | 2.2461 | 2.2514 | 9541084.0 |
| 2006-05-24 11:15:00 | AAPL | Stock | 2.2514 | 2.2514 | 2.2432 | 2.2436 | 10043684.0 |
| 2006-05-24 11:20:00 | AAPL | Stock | 2.2436 | 2.2521 | 2.2396 | 2.2518 | 10148544.0 |
| 2006-05-24 11:25:00 | AAPL | Stock | 2.2514 | 2.2536 | 2.2443 | 2.2493 | 8773660.0 |
| 2006-05-24 11:30:00 | AAPL | Stock | 2.2493 | 2.2493 | 2.2375 | 2.2479 | 9545256.0 |
| 2006-05-24 11:35:00 | AAPL | Stock | 2.2475 | 2.2479 | 2.2429 | 2.2454 | 4140332.0 |
| 2006-05-24 11:40:00 | AAPL | Stock | 2.2454 | 2.2521 | 2.2404 | 2.25 | 6437088.0 |
| 2006-05-24 11:45:00 | AAPL | Stock | 2.25 | 2.2518 | 2.2443 | 2.245 | 4261432.0 |
> showing 50 of 232,287 rows — these rows as CSV