PREVIEW / stock_1min / 2008-08-22
file: by_date/stock_1min/2008/2008-08-22.parquet size: 11.5 MB rows: 934,565 symbols: 2,676
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-08-22 07:08:00 | AAPL | Stock | 6.2346 | 6.2346 | 6.2346 | 6.2346 | 9520.0 |
| 2008-08-22 07:30:00 | AAPL | Stock | 6.2711 | 6.2711 | 6.2711 | 6.2711 | 5460.0 |
| 2008-08-22 07:35:00 | AAPL | Stock | 6.265 | 6.2679 | 6.265 | 6.2679 | 35868.0 |
| 2008-08-22 07:38:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2679 | 6.2679 | 56000.0 |
| 2008-08-22 07:40:00 | AAPL | Stock | 6.2714 | 6.2786 | 6.2714 | 6.2786 | 42112.0 |
| 2008-08-22 07:41:00 | AAPL | Stock | 6.2786 | 6.2786 | 6.2786 | 6.2786 | 103488.0 |
| 2008-08-22 07:51:00 | AAPL | Stock | 6.2768 | 6.2768 | 6.2757 | 6.2757 | 56000.0 |
| 2008-08-22 07:53:00 | AAPL | Stock | 6.2764 | 6.2786 | 6.2764 | 6.2786 | 105308.0 |
| 2008-08-22 07:54:00 | AAPL | Stock | 6.2786 | 6.2786 | 6.2786 | 6.2786 | 84000.0 |
| 2008-08-22 07:55:00 | AAPL | Stock | 6.2786 | 6.2786 | 6.2786 | 6.2786 | 9800.0 |
| 2008-08-22 07:56:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2679 | 6.2679 | 5600.0 |
| 2008-08-22 07:58:00 | AAPL | Stock | 6.2771 | 6.2771 | 6.2771 | 6.2771 | 5600.0 |
| 2008-08-22 08:00:00 | AAPL | Stock | 6.2682 | 6.2696 | 6.2593 | 6.2593 | 145600.0 |
| 2008-08-22 08:02:00 | AAPL | Stock | 6.2671 | 6.2679 | 6.26 | 6.2679 | 28000.0 |
| 2008-08-22 08:03:00 | AAPL | Stock | 6.2643 | 6.2675 | 6.2607 | 6.2675 | 30800.0 |
| 2008-08-22 08:04:00 | AAPL | Stock | 6.2679 | 6.2732 | 6.2675 | 6.2732 | 130200.0 |
| 2008-08-22 08:05:00 | AAPL | Stock | 6.2725 | 6.275 | 6.2718 | 6.275 | 11200.0 |
| 2008-08-22 08:06:00 | AAPL | Stock | 6.275 | 6.275 | 6.2679 | 6.2704 | 45752.0 |
| 2008-08-22 08:07:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2679 | 6.2679 | 56000.0 |
| 2008-08-22 08:08:00 | AAPL | Stock | 6.2704 | 6.2714 | 6.2704 | 6.2707 | 42560.0 |
| 2008-08-22 08:09:00 | AAPL | Stock | 6.2707 | 6.2707 | 6.2682 | 6.2682 | 16800.0 |
| 2008-08-22 08:10:00 | AAPL | Stock | 6.2696 | 6.2714 | 6.2696 | 6.2714 | 92400.0 |
| 2008-08-22 08:11:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2679 | 6.2714 | 154840.0 |
| 2008-08-22 08:12:00 | AAPL | Stock | 6.2732 | 6.2732 | 6.2732 | 6.2732 | 30968.0 |
| 2008-08-22 08:13:00 | AAPL | Stock | 6.2746 | 6.2746 | 6.2732 | 6.2732 | 23940.0 |
| 2008-08-22 08:16:00 | AAPL | Stock | 6.2682 | 6.2732 | 6.2679 | 6.2696 | 113400.0 |
| 2008-08-22 08:17:00 | AAPL | Stock | 6.2729 | 6.275 | 6.2729 | 6.275 | 170800.0 |
| 2008-08-22 08:18:00 | AAPL | Stock | 6.275 | 6.275 | 6.275 | 6.275 | 4200.0 |
| 2008-08-22 08:19:00 | AAPL | Stock | 6.2746 | 6.2746 | 6.2743 | 6.2743 | 14000.0 |
| 2008-08-22 08:21:00 | AAPL | Stock | 6.2746 | 6.2746 | 6.2696 | 6.2696 | 13020.0 |
| 2008-08-22 08:22:00 | AAPL | Stock | 6.27 | 6.27 | 6.2696 | 6.2696 | 5600.0 |
| 2008-08-22 08:23:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 14000.0 |
| 2008-08-22 08:25:00 | AAPL | Stock | 6.2696 | 6.2696 | 6.2696 | 6.2696 | 2800.0 |
| 2008-08-22 08:26:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 28000.0 |
| 2008-08-22 08:27:00 | AAPL | Stock | 6.2696 | 6.2714 | 6.2679 | 6.2693 | 51240.0 |
| 2008-08-22 08:28:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 62160.0 |
| 2008-08-22 08:32:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 34300.0 |
| 2008-08-22 08:36:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2679 | 6.2679 | 14000.0 |
| 2008-08-22 08:37:00 | AAPL | Stock | 6.2646 | 6.2646 | 6.2643 | 6.2643 | 13720.0 |
| 2008-08-22 08:40:00 | AAPL | Stock | 6.2671 | 6.2671 | 6.2671 | 6.2671 | 14000.0 |
| 2008-08-22 08:41:00 | AAPL | Stock | 6.2679 | 6.2696 | 6.2679 | 6.2696 | 16800.0 |
| 2008-08-22 08:42:00 | AAPL | Stock | 6.2696 | 6.2714 | 6.2693 | 6.2693 | 19600.0 |
| 2008-08-22 08:43:00 | AAPL | Stock | 6.2729 | 6.2729 | 6.2714 | 6.2714 | 8400.0 |
| 2008-08-22 08:44:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 11200.0 |
| 2008-08-22 08:45:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2643 | 6.2643 | 42980.0 |
| 2008-08-22 08:46:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2643 | 6.2643 | 34020.0 |
| 2008-08-22 08:47:00 | AAPL | Stock | 6.2661 | 6.2661 | 6.2661 | 6.2661 | 5600.0 |
| 2008-08-22 08:48:00 | AAPL | Stock | 6.2661 | 6.2661 | 6.2661 | 6.2661 | 12600.0 |
| 2008-08-22 08:50:00 | AAPL | Stock | 6.2661 | 6.2661 | 6.2661 | 6.2661 | 16800.0 |
| 2008-08-22 08:51:00 | AAPL | Stock | 6.2664 | 6.2668 | 6.2664 | 6.2664 | 11200.0 |
> showing 50 of 934,565 rows — these rows as CSV