PREVIEW / stock_5min / 2006-05-19
file: by_date/stock_5min/2006/2006-05-19.parquet size: 3.2 MB rows: 227,271 symbols: 2,269
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-19 07:55:00 | AAPL | Stock | 2.2714 | 2.2714 | 2.2714 | 2.2714 | 26600.0 |
| 2006-05-19 08:00:00 | AAPL | Stock | 2.2732 | 2.2775 | 2.2689 | 2.2732 | 281820.0 |
| 2006-05-19 08:05:00 | AAPL | Stock | 2.2764 | 2.2764 | 2.2721 | 2.2736 | 235060.0 |
| 2006-05-19 08:10:00 | AAPL | Stock | 2.2757 | 2.2761 | 2.2743 | 2.2743 | 170744.0 |
| 2006-05-19 08:15:00 | AAPL | Stock | 2.275 | 2.275 | 2.2725 | 2.2732 | 95900.0 |
| 2006-05-19 08:20:00 | AAPL | Stock | 2.2729 | 2.2729 | 2.2714 | 2.2714 | 73500.0 |
| 2006-05-19 08:25:00 | AAPL | Stock | 2.2707 | 2.2743 | 2.2707 | 2.2739 | 175672.0 |
| 2006-05-19 08:30:00 | AAPL | Stock | 2.2736 | 2.2746 | 2.2725 | 2.2732 | 94388.0 |
| 2006-05-19 08:35:00 | AAPL | Stock | 2.2732 | 2.2732 | 2.2707 | 2.2721 | 112112.0 |
| 2006-05-19 08:40:00 | AAPL | Stock | 2.2714 | 2.2725 | 2.2714 | 2.2725 | 72968.0 |
| 2006-05-19 08:45:00 | AAPL | Stock | 2.2732 | 2.2746 | 2.2732 | 2.2746 | 131600.0 |
| 2006-05-19 08:50:00 | AAPL | Stock | 2.2743 | 2.2757 | 2.2743 | 2.2754 | 186200.0 |
| 2006-05-19 08:55:00 | AAPL | Stock | 2.2754 | 2.2764 | 2.275 | 2.2757 | 86996.0 |
| 2006-05-19 09:00:00 | AAPL | Stock | 2.2757 | 2.2768 | 2.275 | 2.2768 | 174356.0 |
| 2006-05-19 09:05:00 | AAPL | Stock | 2.2768 | 2.2796 | 2.2768 | 2.2796 | 381080.0 |
| 2006-05-19 09:10:00 | AAPL | Stock | 2.2796 | 2.2804 | 2.2782 | 2.2796 | 215600.0 |
| 2006-05-19 09:15:00 | AAPL | Stock | 2.2786 | 2.2789 | 2.2786 | 2.2786 | 1012900.0 |
| 2006-05-19 09:20:00 | AAPL | Stock | 2.2786 | 2.2786 | 2.2775 | 2.2786 | 326200.0 |
| 2006-05-19 09:25:00 | AAPL | Stock | 2.2768 | 2.2804 | 2.2539 | 2.2593 | 6455372.0 |
| 2006-05-19 09:30:00 | AAPL | Stock | 2.2593 | 2.2754 | 2.2564 | 2.2742 | 90170472.0 |
| 2006-05-19 09:35:00 | AAPL | Stock | 2.2746 | 2.2804 | 2.2704 | 2.2761 | 22305024.0 |
| 2006-05-19 09:40:00 | AAPL | Stock | 2.2761 | 2.2818 | 2.2646 | 2.2661 | 16791880.0 |
| 2006-05-19 09:45:00 | AAPL | Stock | 2.2661 | 2.2704 | 2.2621 | 2.2668 | 14907144.0 |
| 2006-05-19 09:50:00 | AAPL | Stock | 2.2671 | 2.2718 | 2.2661 | 2.2675 | 8462972.0 |
| 2006-05-19 09:55:00 | AAPL | Stock | 2.2679 | 2.2679 | 2.2436 | 2.255 | 38455760.0 |
| 2006-05-19 10:00:00 | AAPL | Stock | 2.255 | 2.2589 | 2.2489 | 2.2557 | 24620960.0 |
| 2006-05-19 10:05:00 | AAPL | Stock | 2.2561 | 2.2632 | 2.255 | 2.2579 | 13606040.0 |
| 2006-05-19 10:10:00 | AAPL | Stock | 2.2582 | 2.2593 | 2.2464 | 2.2536 | 17308984.0 |
| 2006-05-19 10:15:00 | AAPL | Stock | 2.2532 | 2.2661 | 2.2529 | 2.2589 | 24774540.0 |
| 2006-05-19 10:20:00 | AAPL | Stock | 2.2589 | 2.2607 | 2.2518 | 2.26 | 12331760.0 |
| 2006-05-19 10:25:00 | AAPL | Stock | 2.2593 | 2.2682 | 2.2586 | 2.2671 | 14642712.0 |
| 2006-05-19 10:30:00 | AAPL | Stock | 2.2671 | 2.2786 | 2.267 | 2.2768 | 19290656.0 |
| 2006-05-19 10:35:00 | AAPL | Stock | 2.2771 | 2.2825 | 2.2714 | 2.2782 | 15758848.0 |
| 2006-05-19 10:40:00 | AAPL | Stock | 2.2782 | 2.2868 | 2.2725 | 2.2825 | 14812784.0 |
| 2006-05-19 10:45:00 | AAPL | Stock | 2.2825 | 2.2886 | 2.2779 | 2.2779 | 10999828.0 |
| 2006-05-19 10:50:00 | AAPL | Stock | 2.2779 | 2.28 | 2.2664 | 2.2664 | 10931256.0 |
| 2006-05-19 10:55:00 | AAPL | Stock | 2.2664 | 2.2696 | 2.2618 | 2.2675 | 11165896.0 |
| 2006-05-19 11:00:00 | AAPL | Stock | 2.2671 | 2.2686 | 2.2621 | 2.2654 | 7190372.0 |
| 2006-05-19 11:05:00 | AAPL | Stock | 2.2657 | 2.2682 | 2.2536 | 2.2582 | 8851388.0 |
| 2006-05-19 11:10:00 | AAPL | Stock | 2.2586 | 2.2596 | 2.2471 | 2.2543 | 15273524.0 |
| 2006-05-19 11:15:00 | AAPL | Stock | 2.2546 | 2.2589 | 2.2471 | 2.2529 | 15087800.0 |
| 2006-05-19 11:20:00 | AAPL | Stock | 2.2532 | 2.2636 | 2.2511 | 2.2593 | 15001420.0 |
| 2006-05-19 11:25:00 | AAPL | Stock | 2.2593 | 2.2657 | 2.2568 | 2.2621 | 8551816.0 |
| 2006-05-19 11:30:00 | AAPL | Stock | 2.2621 | 2.2657 | 2.256 | 2.2582 | 7252784.0 |
| 2006-05-19 11:35:00 | AAPL | Stock | 2.2568 | 2.2611 | 2.2514 | 2.26 | 10573948.0 |
| 2006-05-19 11:40:00 | AAPL | Stock | 2.2604 | 2.2611 | 2.2536 | 2.2572 | 5838224.0 |
| 2006-05-19 11:45:00 | AAPL | Stock | 2.2576 | 2.2636 | 2.2561 | 2.2596 | 4941916.0 |
| 2006-05-19 11:50:00 | AAPL | Stock | 2.2607 | 2.2625 | 2.2568 | 2.259 | 6548304.0 |
| 2006-05-19 11:55:00 | AAPL | Stock | 2.2589 | 2.2618 | 2.2564 | 2.2618 | 5596444.0 |
| 2006-05-19 12:00:00 | AAPL | Stock | 2.2614 | 2.2636 | 2.2589 | 2.2636 | 3421880.0 |
> showing 50 of 227,271 rows — these rows as CSV