PREVIEW / stock_1min / 2008-07-02
file: by_date/stock_1min/2008/2008-07-02.parquet size: 13.6 MB rows: 1,075,113 symbols: 2,711
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-02 07:09:00 | AAPL | Stock | 6.2768 | 6.2768 | 6.2768 | 6.2768 | 7616.0 |
| 2008-07-02 07:23:00 | AAPL | Stock | 6.275 | 6.275 | 6.275 | 6.275 | 2800.0 |
| 2008-07-02 07:25:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2679 | 6.2679 | 5600.0 |
| 2008-07-02 07:27:00 | AAPL | Stock | 6.275 | 6.275 | 6.275 | 6.275 | 11340.0 |
| 2008-07-02 07:28:00 | AAPL | Stock | 6.275 | 6.275 | 6.275 | 6.275 | 11200.0 |
| 2008-07-02 07:29:00 | AAPL | Stock | 6.2821 | 6.2821 | 6.2821 | 6.2821 | 7000.0 |
| 2008-07-02 07:32:00 | AAPL | Stock | 6.2786 | 6.2786 | 6.2786 | 6.2786 | 19572.0 |
| 2008-07-02 07:35:00 | AAPL | Stock | 6.2786 | 6.2786 | 6.2786 | 6.2786 | 7420.0 |
| 2008-07-02 07:36:00 | AAPL | Stock | 6.275 | 6.275 | 6.275 | 6.275 | 5460.0 |
| 2008-07-02 07:38:00 | AAPL | Stock | 6.2643 | 6.2643 | 6.2643 | 6.2643 | 21000.0 |
| 2008-07-02 07:42:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 11060.0 |
| 2008-07-02 07:48:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 2800.0 |
| 2008-07-02 07:49:00 | AAPL | Stock | 6.2646 | 6.2646 | 6.2643 | 6.2643 | 25844.0 |
| 2008-07-02 07:50:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 2800.0 |
| 2008-07-02 07:53:00 | AAPL | Stock | 6.275 | 6.275 | 6.275 | 6.275 | 4900.0 |
| 2008-07-02 07:54:00 | AAPL | Stock | 6.275 | 6.275 | 6.275 | 6.275 | 22540.0 |
| 2008-07-02 07:56:00 | AAPL | Stock | 6.275 | 6.275 | 6.275 | 6.275 | 5600.0 |
| 2008-07-02 07:58:00 | AAPL | Stock | 6.2768 | 6.2786 | 6.2729 | 6.2729 | 49140.0 |
| 2008-07-02 08:00:00 | AAPL | Stock | 6.2679 | 6.2764 | 6.2629 | 6.2714 | 113344.0 |
| 2008-07-02 08:01:00 | AAPL | Stock | 6.2725 | 6.2725 | 6.2679 | 6.2679 | 81900.0 |
| 2008-07-02 08:02:00 | AAPL | Stock | 6.2689 | 6.2707 | 6.2682 | 6.2689 | 16800.0 |
| 2008-07-02 08:03:00 | AAPL | Stock | 6.2696 | 6.2714 | 6.2679 | 6.2714 | 47600.0 |
| 2008-07-02 08:04:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.27 | 6.2714 | 18200.0 |
| 2008-07-02 08:05:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2696 | 6.2696 | 58072.0 |
| 2008-07-02 08:06:00 | AAPL | Stock | 6.2686 | 6.2686 | 6.265 | 6.265 | 123200.0 |
| 2008-07-02 08:07:00 | AAPL | Stock | 6.2657 | 6.2668 | 6.2632 | 6.2632 | 37464.0 |
| 2008-07-02 08:08:00 | AAPL | Stock | 6.2661 | 6.2693 | 6.2629 | 6.2664 | 45864.0 |
| 2008-07-02 08:09:00 | AAPL | Stock | 6.2693 | 6.2714 | 6.2693 | 6.27 | 60200.0 |
| 2008-07-02 08:10:00 | AAPL | Stock | 6.2711 | 6.2768 | 6.27 | 6.2754 | 59276.0 |
| 2008-07-02 08:11:00 | AAPL | Stock | 6.2757 | 6.2775 | 6.2736 | 6.2761 | 170800.0 |
| 2008-07-02 08:12:00 | AAPL | Stock | 6.2743 | 6.2757 | 6.2718 | 6.2718 | 95340.0 |
| 2008-07-02 08:13:00 | AAPL | Stock | 6.2736 | 6.2736 | 6.2732 | 6.2732 | 21000.0 |
| 2008-07-02 08:14:00 | AAPL | Stock | 6.2721 | 6.2721 | 6.2714 | 6.2714 | 5600.0 |
| 2008-07-02 08:15:00 | AAPL | Stock | 6.2714 | 6.2739 | 6.2679 | 6.2679 | 366100.0 |
| 2008-07-02 08:16:00 | AAPL | Stock | 6.2675 | 6.2679 | 6.2636 | 6.2679 | 44800.0 |
| 2008-07-02 08:17:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2636 | 6.2679 | 240380.0 |
| 2008-07-02 08:18:00 | AAPL | Stock | 6.2675 | 6.2679 | 6.2621 | 6.2621 | 67200.0 |
| 2008-07-02 08:19:00 | AAPL | Stock | 6.2607 | 6.2607 | 6.2543 | 6.2554 | 148792.0 |
| 2008-07-02 08:20:00 | AAPL | Stock | 6.2554 | 6.2554 | 6.25 | 6.25 | 67704.0 |
| 2008-07-02 08:21:00 | AAPL | Stock | 6.2525 | 6.2536 | 6.2446 | 6.2496 | 178416.0 |
| 2008-07-02 08:22:00 | AAPL | Stock | 6.2446 | 6.2518 | 6.2446 | 6.2514 | 19600.0 |
| 2008-07-02 08:23:00 | AAPL | Stock | 6.2571 | 6.2571 | 6.255 | 6.255 | 23996.0 |
| 2008-07-02 08:24:00 | AAPL | Stock | 6.2529 | 6.2564 | 6.2521 | 6.2564 | 8400.0 |
| 2008-07-02 08:25:00 | AAPL | Stock | 6.2586 | 6.2586 | 6.2586 | 6.2586 | 5600.0 |
| 2008-07-02 08:26:00 | AAPL | Stock | 6.2586 | 6.2593 | 6.2586 | 6.2593 | 28000.0 |
| 2008-07-02 08:27:00 | AAPL | Stock | 6.2582 | 6.2621 | 6.2582 | 6.2621 | 30828.0 |
| 2008-07-02 08:28:00 | AAPL | Stock | 6.2625 | 6.2636 | 6.2607 | 6.2607 | 36400.0 |
| 2008-07-02 08:29:00 | AAPL | Stock | 6.2589 | 6.2607 | 6.2589 | 6.2607 | 50400.0 |
| 2008-07-02 08:30:00 | AAPL | Stock | 6.2607 | 6.2646 | 6.2607 | 6.2646 | 73808.0 |
| 2008-07-02 08:31:00 | AAPL | Stock | 6.2643 | 6.2643 | 6.2643 | 6.2643 | 23828.0 |
> showing 50 of 1,075,113 rows — these rows as CSV