PREVIEW / stock_5min / 2002-07-18
file: by_date/stock_5min/2002/2002-07-18.parquet size: 1.8 MB rows: 123,392 symbols: 1,437
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-18 08:00:00 | AAPL | Stock | 0.2813 | 0.2813 | 0.2813 | 0.2813 | 16800.0 |
| 2002-07-18 08:05:00 | AAPL | Stock | 0.277 | 0.2841 | 0.275 | 0.2829 | 61600.0 |
| 2002-07-18 08:35:00 | AAPL | Stock | 0.2798 | 0.2798 | 0.2795 | 0.2795 | 184800.0 |
| 2002-07-18 08:40:00 | AAPL | Stock | 0.2795 | 0.2795 | 0.2795 | 0.2795 | 33600.0 |
| 2002-07-18 08:45:00 | AAPL | Stock | 0.2786 | 0.2786 | 0.2786 | 0.2786 | 28000.0 |
| 2002-07-18 09:00:00 | AAPL | Stock | 0.2795 | 0.2795 | 0.2795 | 0.2795 | 39200.0 |
| 2002-07-18 09:05:00 | AAPL | Stock | 0.2795 | 0.2795 | 0.2795 | 0.2795 | 28000.0 |
| 2002-07-18 09:10:00 | AAPL | Stock | 0.2795 | 0.2795 | 0.2795 | 0.2795 | 84000.0 |
| 2002-07-18 09:25:00 | AAPL | Stock | 0.2779 | 0.2788 | 0.2764 | 0.277 | 744800.0 |
| 2002-07-18 09:30:00 | AAPL | Stock | 0.2768 | 0.2779 | 0.275 | 0.2766 | 13204800.0 |
| 2002-07-18 09:35:00 | AAPL | Stock | 0.2766 | 0.2771 | 0.2754 | 0.2755 | 6490400.0 |
| 2002-07-18 09:40:00 | AAPL | Stock | 0.2755 | 0.2768 | 0.273 | 0.2742 | 14184800.0 |
| 2002-07-18 09:45:00 | AAPL | Stock | 0.2741 | 0.2748 | 0.2725 | 0.2732 | 5801600.0 |
| 2002-07-18 09:50:00 | AAPL | Stock | 0.2732 | 0.2743 | 0.2721 | 0.2741 | 12885600.0 |
| 2002-07-18 09:55:00 | AAPL | Stock | 0.2741 | 0.2759 | 0.2741 | 0.2757 | 4144000.0 |
| 2002-07-18 10:00:00 | AAPL | Stock | 0.2755 | 0.2759 | 0.2736 | 0.2741 | 5236000.0 |
| 2002-07-18 10:05:00 | AAPL | Stock | 0.2741 | 0.275 | 0.2707 | 0.2709 | 16105600.0 |
| 2002-07-18 10:10:00 | AAPL | Stock | 0.2713 | 0.2732 | 0.2709 | 0.273 | 10746400.0 |
| 2002-07-18 10:15:00 | AAPL | Stock | 0.273 | 0.2738 | 0.2727 | 0.2732 | 6731200.0 |
| 2002-07-18 10:20:00 | AAPL | Stock | 0.273 | 0.2732 | 0.2705 | 0.2709 | 11250400.0 |
| 2002-07-18 10:25:00 | AAPL | Stock | 0.2711 | 0.2716 | 0.2695 | 0.2702 | 10264800.0 |
| 2002-07-18 10:30:00 | AAPL | Stock | 0.2698 | 0.2716 | 0.2698 | 0.2714 | 7274400.0 |
| 2002-07-18 10:35:00 | AAPL | Stock | 0.2714 | 0.272 | 0.2705 | 0.2709 | 5202400.0 |
| 2002-07-18 10:40:00 | AAPL | Stock | 0.2709 | 0.2713 | 0.2696 | 0.2696 | 9223200.0 |
| 2002-07-18 10:45:00 | AAPL | Stock | 0.2698 | 0.27 | 0.2689 | 0.2698 | 14683200.0 |
| 2002-07-18 10:50:00 | AAPL | Stock | 0.2696 | 0.2705 | 0.2688 | 0.2688 | 7492800.0 |
| 2002-07-18 10:55:00 | AAPL | Stock | 0.2689 | 0.2689 | 0.268 | 0.2681 | 7364000.0 |
| 2002-07-18 11:00:00 | AAPL | Stock | 0.268 | 0.2689 | 0.268 | 0.2689 | 5504800.0 |
| 2002-07-18 11:05:00 | AAPL | Stock | 0.2689 | 0.2689 | 0.268 | 0.2689 | 6042400.0 |
| 2002-07-18 11:10:00 | AAPL | Stock | 0.2684 | 0.2693 | 0.2675 | 0.2686 | 21207200.0 |
| 2002-07-18 11:15:00 | AAPL | Stock | 0.2686 | 0.2688 | 0.268 | 0.2682 | 2744000.0 |
| 2002-07-18 11:20:00 | AAPL | Stock | 0.2682 | 0.27 | 0.268 | 0.27 | 7235200.0 |
| 2002-07-18 11:25:00 | AAPL | Stock | 0.2699 | 0.2716 | 0.2696 | 0.2709 | 6792800.0 |
| 2002-07-18 11:30:00 | AAPL | Stock | 0.2709 | 0.2714 | 0.2702 | 0.2711 | 3964800.0 |
| 2002-07-18 11:35:00 | AAPL | Stock | 0.2711 | 0.2711 | 0.27 | 0.27 | 2665600.0 |
| 2002-07-18 11:40:00 | AAPL | Stock | 0.2701 | 0.2705 | 0.2686 | 0.2691 | 3348800.0 |
| 2002-07-18 11:45:00 | AAPL | Stock | 0.2689 | 0.2704 | 0.2688 | 0.27 | 3740800.0 |
| 2002-07-18 11:50:00 | AAPL | Stock | 0.27 | 0.2707 | 0.2693 | 0.27 | 6322400.0 |
| 2002-07-18 11:55:00 | AAPL | Stock | 0.27 | 0.2707 | 0.2698 | 0.2702 | 2587200.0 |
| 2002-07-18 12:00:00 | AAPL | Stock | 0.2702 | 0.2705 | 0.2689 | 0.2689 | 694400.0 |
| 2002-07-18 12:05:00 | AAPL | Stock | 0.2689 | 0.2702 | 0.2689 | 0.2702 | 2156000.0 |
| 2002-07-18 12:10:00 | AAPL | Stock | 0.2702 | 0.2704 | 0.2696 | 0.2702 | 2917600.0 |
| 2002-07-18 12:15:00 | AAPL | Stock | 0.2702 | 0.2705 | 0.27 | 0.2705 | 1204000.0 |
| 2002-07-18 12:20:00 | AAPL | Stock | 0.2705 | 0.2713 | 0.2704 | 0.2713 | 6260800.0 |
| 2002-07-18 12:25:00 | AAPL | Stock | 0.2711 | 0.2711 | 0.2696 | 0.2696 | 991200.0 |
| 2002-07-18 12:30:00 | AAPL | Stock | 0.2695 | 0.2702 | 0.2695 | 0.2696 | 884800.0 |
| 2002-07-18 12:35:00 | AAPL | Stock | 0.2696 | 0.27 | 0.2689 | 0.2693 | 5398400.0 |
| 2002-07-18 12:40:00 | AAPL | Stock | 0.2693 | 0.2705 | 0.2691 | 0.2696 | 3046400.0 |
| 2002-07-18 12:45:00 | AAPL | Stock | 0.2689 | 0.2705 | 0.2689 | 0.2705 | 2021600.0 |
| 2002-07-18 12:50:00 | AAPL | Stock | 0.2705 | 0.2707 | 0.2696 | 0.2696 | 3332000.0 |
> showing 50 of 123,392 rows — these rows as CSV