PREVIEW / stock_1min / 2002-08-07
file: by_date/stock_1min/2002/2002-08-07.parquet size: 4.3 MB rows: 335,838 symbols: 1,196
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-08-07 08:01:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 5600.0 |
| 2002-08-07 08:29:00 | AAPL | Stock | 0.2632 | 0.2632 | 0.2632 | 0.2632 | 616000.0 |
| 2002-08-07 09:10:00 | AAPL | Stock | 0.2681 | 0.2681 | 0.2681 | 0.2681 | 5600.0 |
| 2002-08-07 09:15:00 | AAPL | Stock | 0.2681 | 0.2681 | 0.268 | 0.268 | 28000.0 |
| 2002-08-07 09:16:00 | AAPL | Stock | 0.267 | 0.267 | 0.267 | 0.267 | 56000.0 |
| 2002-08-07 09:18:00 | AAPL | Stock | 0.2677 | 0.2677 | 0.2677 | 0.2677 | 22400.0 |
| 2002-08-07 09:22:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 84000.0 |
| 2002-08-07 09:23:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 56000.0 |
| 2002-08-07 09:24:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 112000.0 |
| 2002-08-07 09:25:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 184800.0 |
| 2002-08-07 09:26:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 565600.0 |
| 2002-08-07 09:29:00 | AAPL | Stock | 0.2671 | 0.2671 | 0.2671 | 0.2671 | 54880.0 |
| 2002-08-07 09:30:00 | AAPL | Stock | 0.2695 | 0.2696 | 0.268 | 0.268 | 1176000.0 |
| 2002-08-07 09:31:00 | AAPL | Stock | 0.2679 | 0.2689 | 0.2679 | 0.2689 | 574000.0 |
| 2002-08-07 09:32:00 | AAPL | Stock | 0.2689 | 0.2702 | 0.2688 | 0.2702 | 408800.0 |
| 2002-08-07 09:33:00 | AAPL | Stock | 0.2696 | 0.2714 | 0.2696 | 0.2712 | 403200.0 |
| 2002-08-07 09:34:00 | AAPL | Stock | 0.2714 | 0.2718 | 0.27 | 0.2709 | 1064000.0 |
| 2002-08-07 09:35:00 | AAPL | Stock | 0.2714 | 0.2721 | 0.2702 | 0.2713 | 1120000.0 |
| 2002-08-07 09:36:00 | AAPL | Stock | 0.2704 | 0.2714 | 0.2696 | 0.2696 | 1394400.0 |
| 2002-08-07 09:37:00 | AAPL | Stock | 0.2696 | 0.2698 | 0.2691 | 0.2696 | 358400.0 |
| 2002-08-07 09:38:00 | AAPL | Stock | 0.2695 | 0.2698 | 0.2691 | 0.2691 | 313600.0 |
| 2002-08-07 09:39:00 | AAPL | Stock | 0.2691 | 0.2695 | 0.268 | 0.2684 | 660800.0 |
| 2002-08-07 09:40:00 | AAPL | Stock | 0.2683 | 0.2683 | 0.2673 | 0.2679 | 705600.0 |
| 2002-08-07 09:41:00 | AAPL | Stock | 0.268 | 0.268 | 0.2674 | 0.2677 | 672000.0 |
| 2002-08-07 09:42:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.267 | 0.2679 | 1524320.0 |
| 2002-08-07 09:43:00 | AAPL | Stock | 0.2679 | 0.2686 | 0.2677 | 0.2679 | 2094400.0 |
| 2002-08-07 09:44:00 | AAPL | Stock | 0.2679 | 0.2688 | 0.2679 | 0.2686 | 1288000.0 |
| 2002-08-07 09:45:00 | AAPL | Stock | 0.268 | 0.2688 | 0.2673 | 0.2673 | 2598400.0 |
| 2002-08-07 09:46:00 | AAPL | Stock | 0.2671 | 0.2679 | 0.267 | 0.267 | 2452800.0 |
| 2002-08-07 09:47:00 | AAPL | Stock | 0.267 | 0.267 | 0.2663 | 0.2668 | 1657600.0 |
| 2002-08-07 09:48:00 | AAPL | Stock | 0.2673 | 0.2673 | 0.2665 | 0.267 | 510440.0 |
| 2002-08-07 09:49:00 | AAPL | Stock | 0.2664 | 0.2668 | 0.2661 | 0.2663 | 548800.0 |
| 2002-08-07 09:50:00 | AAPL | Stock | 0.2659 | 0.2663 | 0.2652 | 0.2652 | 397600.0 |
| 2002-08-07 09:51:00 | AAPL | Stock | 0.2654 | 0.2661 | 0.2654 | 0.2661 | 1859200.0 |
| 2002-08-07 09:52:00 | AAPL | Stock | 0.2661 | 0.2668 | 0.2655 | 0.2664 | 2033528.0 |
| 2002-08-07 09:53:00 | AAPL | Stock | 0.2661 | 0.2663 | 0.2654 | 0.2655 | 932960.0 |
| 2002-08-07 09:54:00 | AAPL | Stock | 0.2661 | 0.2661 | 0.2636 | 0.2639 | 1406160.0 |
| 2002-08-07 09:55:00 | AAPL | Stock | 0.2639 | 0.2639 | 0.2632 | 0.2632 | 3158400.0 |
| 2002-08-07 09:56:00 | AAPL | Stock | 0.2632 | 0.2636 | 0.2625 | 0.2636 | 1472800.0 |
| 2002-08-07 09:57:00 | AAPL | Stock | 0.2634 | 0.2636 | 0.2609 | 0.2609 | 2055200.0 |
| 2002-08-07 09:58:00 | AAPL | Stock | 0.2611 | 0.2623 | 0.2607 | 0.2623 | 1264032.0 |
| 2002-08-07 09:59:00 | AAPL | Stock | 0.262 | 0.2641 | 0.262 | 0.2639 | 672000.0 |
| 2002-08-07 10:00:00 | AAPL | Stock | 0.2641 | 0.2643 | 0.2634 | 0.2643 | 697032.0 |
| 2002-08-07 10:01:00 | AAPL | Stock | 0.2643 | 0.265 | 0.2643 | 0.2646 | 352800.0 |
| 2002-08-07 10:02:00 | AAPL | Stock | 0.2646 | 0.265 | 0.2646 | 0.2646 | 296800.0 |
| 2002-08-07 10:03:00 | AAPL | Stock | 0.265 | 0.265 | 0.2641 | 0.2641 | 190400.0 |
| 2002-08-07 10:04:00 | AAPL | Stock | 0.2641 | 0.2643 | 0.2641 | 0.2643 | 285600.0 |
| 2002-08-07 10:05:00 | AAPL | Stock | 0.2641 | 0.265 | 0.2638 | 0.2647 | 526400.0 |
| 2002-08-07 10:06:00 | AAPL | Stock | 0.2641 | 0.2648 | 0.2641 | 0.2645 | 582400.0 |
| 2002-08-07 10:07:00 | AAPL | Stock | 0.2645 | 0.2646 | 0.2632 | 0.2634 | 644000.0 |
> showing 50 of 335,838 rows — these rows as CSV