PREVIEW / stock_5min / 2002-07-23
file: by_date/stock_5min/2002/2002-07-23.parquet size: 2.0 MB rows: 134,322 symbols: 1,462
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-23 09:30:00 | AAPL | Stock | 0.2661 | 0.2675 | 0.2641 | 0.2641 | 7691152.0 |
| 2002-07-23 09:35:00 | AAPL | Stock | 0.2655 | 0.2659 | 0.2634 | 0.265 | 5118400.0 |
| 2002-07-23 09:40:00 | AAPL | Stock | 0.265 | 0.2675 | 0.2639 | 0.2671 | 3404800.0 |
| 2002-07-23 09:45:00 | AAPL | Stock | 0.2673 | 0.2702 | 0.267 | 0.268 | 6983760.0 |
| 2002-07-23 09:50:00 | AAPL | Stock | 0.2677 | 0.2698 | 0.2677 | 0.2684 | 9125200.0 |
| 2002-07-23 09:55:00 | AAPL | Stock | 0.2682 | 0.2691 | 0.2679 | 0.2691 | 5817392.0 |
| 2002-07-23 10:00:00 | AAPL | Stock | 0.2691 | 0.2693 | 0.2661 | 0.2661 | 14318528.0 |
| 2002-07-23 10:05:00 | AAPL | Stock | 0.2661 | 0.2675 | 0.2648 | 0.2673 | 4321856.0 |
| 2002-07-23 10:10:00 | AAPL | Stock | 0.2673 | 0.2673 | 0.2638 | 0.2643 | 4819920.0 |
| 2002-07-23 10:15:00 | AAPL | Stock | 0.2646 | 0.2673 | 0.2643 | 0.267 | 3503752.0 |
| 2002-07-23 10:20:00 | AAPL | Stock | 0.267 | 0.2675 | 0.2663 | 0.2669 | 8391768.0 |
| 2002-07-23 10:25:00 | AAPL | Stock | 0.2671 | 0.2688 | 0.267 | 0.2686 | 4243960.0 |
| 2002-07-23 10:30:00 | AAPL | Stock | 0.2686 | 0.2691 | 0.2677 | 0.2684 | 3405192.0 |
| 2002-07-23 10:35:00 | AAPL | Stock | 0.2686 | 0.2691 | 0.2677 | 0.2682 | 2440648.0 |
| 2002-07-23 10:40:00 | AAPL | Stock | 0.2684 | 0.2691 | 0.2679 | 0.2691 | 2632280.0 |
| 2002-07-23 10:45:00 | AAPL | Stock | 0.2691 | 0.2691 | 0.2677 | 0.268 | 3077760.0 |
| 2002-07-23 10:50:00 | AAPL | Stock | 0.2684 | 0.2686 | 0.2661 | 0.2664 | 3086328.0 |
| 2002-07-23 10:55:00 | AAPL | Stock | 0.2664 | 0.2679 | 0.2663 | 0.267 | 1832936.0 |
| 2002-07-23 11:00:00 | AAPL | Stock | 0.267 | 0.2671 | 0.2657 | 0.2659 | 1956304.0 |
| 2002-07-23 11:05:00 | AAPL | Stock | 0.2666 | 0.2671 | 0.2652 | 0.2661 | 1904112.0 |
| 2002-07-23 11:10:00 | AAPL | Stock | 0.2656 | 0.2664 | 0.2654 | 0.2661 | 900592.0 |
| 2002-07-23 11:15:00 | AAPL | Stock | 0.2661 | 0.2686 | 0.2654 | 0.2677 | 3032008.0 |
| 2002-07-23 11:20:00 | AAPL | Stock | 0.2677 | 0.268 | 0.2671 | 0.2673 | 5790400.0 |
| 2002-07-23 11:25:00 | AAPL | Stock | 0.2679 | 0.2682 | 0.2675 | 0.2679 | 4920496.0 |
| 2002-07-23 11:30:00 | AAPL | Stock | 0.2677 | 0.2682 | 0.2659 | 0.2674 | 2865968.0 |
| 2002-07-23 11:35:00 | AAPL | Stock | 0.2677 | 0.2677 | 0.2659 | 0.2673 | 1064000.0 |
| 2002-07-23 11:40:00 | AAPL | Stock | 0.2672 | 0.2677 | 0.2664 | 0.2664 | 571200.0 |
| 2002-07-23 11:45:00 | AAPL | Stock | 0.2664 | 0.2677 | 0.2661 | 0.2675 | 1155840.0 |
| 2002-07-23 11:50:00 | AAPL | Stock | 0.2677 | 0.268 | 0.2671 | 0.2679 | 3202752.0 |
| 2002-07-23 11:55:00 | AAPL | Stock | 0.2675 | 0.2679 | 0.267 | 0.2671 | 1333136.0 |
| 2002-07-23 12:00:00 | AAPL | Stock | 0.2671 | 0.2677 | 0.2669 | 0.2671 | 1677312.0 |
| 2002-07-23 12:05:00 | AAPL | Stock | 0.267 | 0.2673 | 0.2661 | 0.2664 | 1528800.0 |
| 2002-07-23 12:10:00 | AAPL | Stock | 0.2668 | 0.2668 | 0.2661 | 0.2661 | 2215136.0 |
| 2002-07-23 12:15:00 | AAPL | Stock | 0.2662 | 0.2663 | 0.2652 | 0.2654 | 2469600.0 |
| 2002-07-23 12:20:00 | AAPL | Stock | 0.2657 | 0.2657 | 0.263 | 0.2643 | 4689552.0 |
| 2002-07-23 12:25:00 | AAPL | Stock | 0.2643 | 0.2643 | 0.2634 | 0.2638 | 2040248.0 |
| 2002-07-23 12:30:00 | AAPL | Stock | 0.2636 | 0.2654 | 0.2634 | 0.2645 | 10213336.0 |
| 2002-07-23 12:35:00 | AAPL | Stock | 0.265 | 0.265 | 0.2634 | 0.264 | 5188960.0 |
| 2002-07-23 12:40:00 | AAPL | Stock | 0.2639 | 0.2652 | 0.2638 | 0.265 | 2209536.0 |
| 2002-07-23 12:45:00 | AAPL | Stock | 0.265 | 0.2652 | 0.2632 | 0.2638 | 1920800.0 |
| 2002-07-23 12:50:00 | AAPL | Stock | 0.2645 | 0.2652 | 0.2643 | 0.2643 | 7716800.0 |
| 2002-07-23 12:55:00 | AAPL | Stock | 0.2643 | 0.2645 | 0.2639 | 0.2645 | 952000.0 |
| 2002-07-23 13:00:00 | AAPL | Stock | 0.265 | 0.265 | 0.2634 | 0.2638 | 1741600.0 |
| 2002-07-23 13:05:00 | AAPL | Stock | 0.2639 | 0.2645 | 0.263 | 0.2632 | 8347640.0 |
| 2002-07-23 13:10:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2618 | 0.2628 | 3668056.0 |
| 2002-07-23 13:15:00 | AAPL | Stock | 0.2629 | 0.2632 | 0.262 | 0.263 | 3988152.0 |
| 2002-07-23 13:20:00 | AAPL | Stock | 0.263 | 0.2638 | 0.2622 | 0.2632 | 3766000.0 |
| 2002-07-23 13:25:00 | AAPL | Stock | 0.2632 | 0.2632 | 0.2625 | 0.2629 | 13664000.0 |
| 2002-07-23 13:30:00 | AAPL | Stock | 0.2627 | 0.2638 | 0.2627 | 0.2636 | 3310440.0 |
| 2002-07-23 13:35:00 | AAPL | Stock | 0.2636 | 0.2638 | 0.263 | 0.2631 | 1518720.0 |
> showing 50 of 134,322 rows — these rows as CSV