PREVIEW / stock_1min / 2005-05-11
file: by_date/stock_1min/2005/2005-05-11.parquet size: 6.7 MB rows: 551,880 symbols: 1,621
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-11 05:26:00 | AAPL | Stock | 1.3 | 1.3 | 1.3 | 1.3 | 11200.0 |
| 2005-05-11 07:14:00 | AAPL | Stock | 1.2764 | 1.2764 | 1.2764 | 1.2764 | 2800.0 |
| 2005-05-11 07:25:00 | AAPL | Stock | 1.2729 | 1.2729 | 1.2729 | 1.2729 | 70000.0 |
| 2005-05-11 07:29:00 | AAPL | Stock | 1.2714 | 1.2714 | 1.2714 | 1.2714 | 5600.0 |
| 2005-05-11 07:36:00 | AAPL | Stock | 1.2729 | 1.2729 | 1.2729 | 1.2729 | 39200.0 |
| 2005-05-11 07:37:00 | AAPL | Stock | 1.2729 | 1.2729 | 1.2729 | 1.2729 | 84000.0 |
| 2005-05-11 07:42:00 | AAPL | Stock | 1.2732 | 1.2732 | 1.2732 | 1.2732 | 154000.0 |
| 2005-05-11 07:44:00 | AAPL | Stock | 1.2732 | 1.2732 | 1.2732 | 1.2732 | 25200.0 |
| 2005-05-11 07:56:00 | AAPL | Stock | 1.2714 | 1.2714 | 1.2714 | 1.2714 | 8400.0 |
| 2005-05-11 07:58:00 | AAPL | Stock | 1.2714 | 1.2714 | 1.2714 | 1.2714 | 2800.0 |
| 2005-05-11 08:00:00 | AAPL | Stock | 1.2746 | 1.275 | 1.2714 | 1.2714 | 120400.0 |
| 2005-05-11 08:01:00 | AAPL | Stock | 1.2714 | 1.2746 | 1.2714 | 1.2743 | 849800.0 |
| 2005-05-11 08:02:00 | AAPL | Stock | 1.2746 | 1.275 | 1.2732 | 1.2732 | 284200.0 |
| 2005-05-11 08:03:00 | AAPL | Stock | 1.2732 | 1.275 | 1.2732 | 1.275 | 927500.0 |
| 2005-05-11 08:04:00 | AAPL | Stock | 1.275 | 1.2804 | 1.275 | 1.2789 | 935480.0 |
| 2005-05-11 08:05:00 | AAPL | Stock | 1.2793 | 1.2821 | 1.2786 | 1.2821 | 515200.0 |
| 2005-05-11 08:06:00 | AAPL | Stock | 1.2821 | 1.2821 | 1.2818 | 1.2821 | 294700.0 |
| 2005-05-11 08:07:00 | AAPL | Stock | 1.2811 | 1.2814 | 1.2807 | 1.2814 | 61600.0 |
| 2005-05-11 08:08:00 | AAPL | Stock | 1.2807 | 1.2807 | 1.2807 | 1.2807 | 5600.0 |
| 2005-05-11 08:09:00 | AAPL | Stock | 1.2793 | 1.2793 | 1.2768 | 1.2768 | 67200.0 |
| 2005-05-11 08:10:00 | AAPL | Stock | 1.2757 | 1.2768 | 1.275 | 1.275 | 172900.0 |
| 2005-05-11 08:11:00 | AAPL | Stock | 1.2786 | 1.2786 | 1.2768 | 1.2786 | 67200.0 |
| 2005-05-11 08:12:00 | AAPL | Stock | 1.2786 | 1.2786 | 1.2768 | 1.2786 | 39200.0 |
| 2005-05-11 08:13:00 | AAPL | Stock | 1.2757 | 1.2757 | 1.2754 | 1.2754 | 28000.0 |
| 2005-05-11 08:14:00 | AAPL | Stock | 1.2768 | 1.2768 | 1.2768 | 1.2768 | 97720.0 |
| 2005-05-11 08:15:00 | AAPL | Stock | 1.2768 | 1.2768 | 1.2768 | 1.2768 | 11200.0 |
| 2005-05-11 08:16:00 | AAPL | Stock | 1.2768 | 1.2768 | 1.2768 | 1.2768 | 2800.0 |
| 2005-05-11 08:17:00 | AAPL | Stock | 1.2768 | 1.2768 | 1.2768 | 1.2768 | 5600.0 |
| 2005-05-11 08:18:00 | AAPL | Stock | 1.2779 | 1.2782 | 1.2779 | 1.2782 | 28000.0 |
| 2005-05-11 08:19:00 | AAPL | Stock | 1.2775 | 1.2779 | 1.2775 | 1.2779 | 8400.0 |
| 2005-05-11 08:20:00 | AAPL | Stock | 1.2771 | 1.2771 | 1.275 | 1.2754 | 124600.0 |
| 2005-05-11 08:21:00 | AAPL | Stock | 1.2757 | 1.2757 | 1.2757 | 1.2757 | 14000.0 |
| 2005-05-11 08:22:00 | AAPL | Stock | 1.2761 | 1.2761 | 1.2729 | 1.2729 | 284760.0 |
| 2005-05-11 08:23:00 | AAPL | Stock | 1.2729 | 1.2739 | 1.2714 | 1.2739 | 282800.0 |
| 2005-05-11 08:24:00 | AAPL | Stock | 1.2736 | 1.2736 | 1.2736 | 1.2736 | 5040.0 |
| 2005-05-11 08:25:00 | AAPL | Stock | 1.2739 | 1.275 | 1.2739 | 1.2746 | 8400.0 |
| 2005-05-11 08:27:00 | AAPL | Stock | 1.2739 | 1.2739 | 1.2732 | 1.2732 | 66080.0 |
| 2005-05-11 08:28:00 | AAPL | Stock | 1.2721 | 1.2721 | 1.2721 | 1.2721 | 5600.0 |
| 2005-05-11 08:29:00 | AAPL | Stock | 1.2736 | 1.2736 | 1.2721 | 1.2732 | 36400.0 |
| 2005-05-11 08:30:00 | AAPL | Stock | 1.2718 | 1.2721 | 1.2714 | 1.2721 | 84000.0 |
| 2005-05-11 08:31:00 | AAPL | Stock | 1.2714 | 1.2718 | 1.2714 | 1.2718 | 44660.0 |
| 2005-05-11 08:32:00 | AAPL | Stock | 1.2714 | 1.2718 | 1.2714 | 1.2718 | 30800.0 |
| 2005-05-11 08:33:00 | AAPL | Stock | 1.2714 | 1.2714 | 1.2714 | 1.2714 | 11060.0 |
| 2005-05-11 08:34:00 | AAPL | Stock | 1.2714 | 1.2721 | 1.2714 | 1.2718 | 111720.0 |
| 2005-05-11 08:35:00 | AAPL | Stock | 1.2732 | 1.2746 | 1.2729 | 1.2743 | 208040.0 |
| 2005-05-11 08:36:00 | AAPL | Stock | 1.2746 | 1.275 | 1.2743 | 1.275 | 25200.0 |
| 2005-05-11 08:37:00 | AAPL | Stock | 1.275 | 1.2757 | 1.275 | 1.2757 | 11200.0 |
| 2005-05-11 08:38:00 | AAPL | Stock | 1.2764 | 1.2771 | 1.2757 | 1.2757 | 134400.0 |
| 2005-05-11 08:39:00 | AAPL | Stock | 1.2768 | 1.2768 | 1.2768 | 1.2768 | 8400.0 |
| 2005-05-11 08:40:00 | AAPL | Stock | 1.2768 | 1.2768 | 1.2764 | 1.2764 | 42000.0 |
> showing 50 of 551,880 rows — these rows as CSV