PREVIEW / stock_1min / 2002-07-22
file: by_date/stock_1min/2002/2002-07-22.parquet size: 4.9 MB rows: 376,602 symbols: 1,191
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-22 09:30:00 | AAPL | Stock | 0.2634 | 0.267 | 0.2634 | 0.267 | 1643208.0 |
| 2002-07-22 09:31:00 | AAPL | Stock | 0.267 | 0.2684 | 0.2634 | 0.2684 | 3990000.0 |
| 2002-07-22 09:32:00 | AAPL | Stock | 0.2682 | 0.2688 | 0.2634 | 0.2682 | 901600.0 |
| 2002-07-22 09:33:00 | AAPL | Stock | 0.267 | 0.2689 | 0.2654 | 0.2689 | 2850400.0 |
| 2002-07-22 09:34:00 | AAPL | Stock | 0.268 | 0.2682 | 0.2655 | 0.2655 | 1640800.0 |
| 2002-07-22 09:35:00 | AAPL | Stock | 0.2659 | 0.2661 | 0.265 | 0.2654 | 655200.0 |
| 2002-07-22 09:36:00 | AAPL | Stock | 0.265 | 0.267 | 0.265 | 0.267 | 498400.0 |
| 2002-07-22 09:37:00 | AAPL | Stock | 0.267 | 0.267 | 0.2661 | 0.2664 | 761600.0 |
| 2002-07-22 09:38:00 | AAPL | Stock | 0.2668 | 0.2673 | 0.2663 | 0.2673 | 758800.0 |
| 2002-07-22 09:39:00 | AAPL | Stock | 0.2673 | 0.2689 | 0.2673 | 0.2684 | 1003240.0 |
| 2002-07-22 09:40:00 | AAPL | Stock | 0.2688 | 0.2691 | 0.2682 | 0.2689 | 1624000.0 |
| 2002-07-22 09:41:00 | AAPL | Stock | 0.2691 | 0.2693 | 0.2682 | 0.2693 | 3334016.0 |
| 2002-07-22 09:42:00 | AAPL | Stock | 0.2696 | 0.2696 | 0.2688 | 0.269 | 2167200.0 |
| 2002-07-22 09:43:00 | AAPL | Stock | 0.2688 | 0.2705 | 0.2688 | 0.2696 | 3785600.0 |
| 2002-07-22 09:44:00 | AAPL | Stock | 0.2702 | 0.2705 | 0.2696 | 0.2705 | 2671200.0 |
| 2002-07-22 09:45:00 | AAPL | Stock | 0.27 | 0.2709 | 0.27 | 0.2709 | 1357664.0 |
| 2002-07-22 09:46:00 | AAPL | Stock | 0.2709 | 0.2713 | 0.2705 | 0.2711 | 2376752.0 |
| 2002-07-22 09:47:00 | AAPL | Stock | 0.2711 | 0.2711 | 0.2702 | 0.2702 | 1570128.0 |
| 2002-07-22 09:48:00 | AAPL | Stock | 0.2702 | 0.2703 | 0.2688 | 0.2695 | 1335152.0 |
| 2002-07-22 09:49:00 | AAPL | Stock | 0.2704 | 0.2704 | 0.2663 | 0.2663 | 4211200.0 |
| 2002-07-22 09:50:00 | AAPL | Stock | 0.2663 | 0.267 | 0.2661 | 0.2664 | 812000.0 |
| 2002-07-22 09:51:00 | AAPL | Stock | 0.2664 | 0.267 | 0.2664 | 0.2666 | 386400.0 |
| 2002-07-22 09:52:00 | AAPL | Stock | 0.2668 | 0.2682 | 0.2664 | 0.2669 | 504000.0 |
| 2002-07-22 09:53:00 | AAPL | Stock | 0.2668 | 0.2671 | 0.2663 | 0.2663 | 1122800.0 |
| 2002-07-22 09:54:00 | AAPL | Stock | 0.2663 | 0.2663 | 0.2652 | 0.2654 | 840000.0 |
| 2002-07-22 09:55:00 | AAPL | Stock | 0.2652 | 0.2654 | 0.2634 | 0.2634 | 1575056.0 |
| 2002-07-22 09:56:00 | AAPL | Stock | 0.2634 | 0.2652 | 0.2634 | 0.2648 | 757456.0 |
| 2002-07-22 09:57:00 | AAPL | Stock | 0.2643 | 0.2646 | 0.2636 | 0.2646 | 562800.0 |
| 2002-07-22 09:58:00 | AAPL | Stock | 0.2643 | 0.2648 | 0.2639 | 0.2648 | 716800.0 |
| 2002-07-22 09:59:00 | AAPL | Stock | 0.2646 | 0.2646 | 0.2643 | 0.2646 | 915432.0 |
| 2002-07-22 10:00:00 | AAPL | Stock | 0.2643 | 0.2661 | 0.2643 | 0.2655 | 1560384.0 |
| 2002-07-22 10:01:00 | AAPL | Stock | 0.2654 | 0.2655 | 0.2643 | 0.2646 | 2298184.0 |
| 2002-07-22 10:02:00 | AAPL | Stock | 0.265 | 0.2659 | 0.2647 | 0.2654 | 787360.0 |
| 2002-07-22 10:03:00 | AAPL | Stock | 0.265 | 0.2655 | 0.265 | 0.2655 | 800800.0 |
| 2002-07-22 10:04:00 | AAPL | Stock | 0.2655 | 0.2659 | 0.2646 | 0.2654 | 1271200.0 |
| 2002-07-22 10:05:00 | AAPL | Stock | 0.2653 | 0.2661 | 0.265 | 0.2657 | 266280.0 |
| 2002-07-22 10:06:00 | AAPL | Stock | 0.2654 | 0.2661 | 0.2654 | 0.2661 | 1117480.0 |
| 2002-07-22 10:07:00 | AAPL | Stock | 0.2661 | 0.2663 | 0.2641 | 0.2645 | 1483664.0 |
| 2002-07-22 10:08:00 | AAPL | Stock | 0.2645 | 0.265 | 0.2638 | 0.2643 | 1344000.0 |
| 2002-07-22 10:09:00 | AAPL | Stock | 0.2639 | 0.2648 | 0.2639 | 0.2645 | 487200.0 |
| 2002-07-22 10:10:00 | AAPL | Stock | 0.2645 | 0.2646 | 0.2636 | 0.2636 | 611184.0 |
| 2002-07-22 10:11:00 | AAPL | Stock | 0.2636 | 0.2638 | 0.2629 | 0.2629 | 1002960.0 |
| 2002-07-22 10:12:00 | AAPL | Stock | 0.2629 | 0.2634 | 0.2616 | 0.263 | 2546768.0 |
| 2002-07-22 10:13:00 | AAPL | Stock | 0.263 | 0.2655 | 0.262 | 0.2654 | 1497552.0 |
| 2002-07-22 10:14:00 | AAPL | Stock | 0.2654 | 0.2664 | 0.2652 | 0.2664 | 830368.0 |
| 2002-07-22 10:15:00 | AAPL | Stock | 0.2657 | 0.2668 | 0.2652 | 0.2652 | 963200.0 |
| 2002-07-22 10:16:00 | AAPL | Stock | 0.2652 | 0.2654 | 0.2638 | 0.2638 | 898128.0 |
| 2002-07-22 10:17:00 | AAPL | Stock | 0.2643 | 0.2643 | 0.263 | 0.2634 | 487200.0 |
| 2002-07-22 10:18:00 | AAPL | Stock | 0.2638 | 0.2661 | 0.2638 | 0.2661 | 424480.0 |
| 2002-07-22 10:19:00 | AAPL | Stock | 0.2659 | 0.268 | 0.2659 | 0.2673 | 1066072.0 |
> showing 50 of 376,602 rows — these rows as CSV