PREVIEW / stock_1min / 2009-01-07
file: by_date/stock_1min/2009/2009-01-07.parquet size: 12.5 MB rows: 968,728 symbols: 2,694
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-07 07:58:00 | AAPL | Stock | 3.2875 | 3.2875 | 3.2875 | 3.2875 | 23800.0 |
| 2009-01-07 08:00:00 | AAPL | Stock | 3.3 | 3.3007 | 3.29 | 3.29 | 34104.0 |
| 2009-01-07 08:02:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2946 | 3.2946 | 14000.0 |
| 2009-01-07 08:03:00 | AAPL | Stock | 3.2904 | 3.2904 | 3.2857 | 3.2857 | 128184.0 |
| 2009-01-07 08:04:00 | AAPL | Stock | 3.2825 | 3.2857 | 3.2821 | 3.2857 | 31752.0 |
| 2009-01-07 08:05:00 | AAPL | Stock | 3.2854 | 3.2854 | 3.2854 | 3.2854 | 2800.0 |
| 2009-01-07 08:06:00 | AAPL | Stock | 3.2857 | 3.2861 | 3.2854 | 3.2854 | 19964.0 |
| 2009-01-07 08:07:00 | AAPL | Stock | 3.2857 | 3.2861 | 3.2857 | 3.2861 | 18480.0 |
| 2009-01-07 08:08:00 | AAPL | Stock | 3.2861 | 3.2861 | 3.2857 | 3.2857 | 14000.0 |
| 2009-01-07 08:09:00 | AAPL | Stock | 3.2821 | 3.2857 | 3.2821 | 3.2821 | 44800.0 |
| 2009-01-07 08:10:00 | AAPL | Stock | 3.2825 | 3.2825 | 3.2771 | 3.2771 | 22400.0 |
| 2009-01-07 08:11:00 | AAPL | Stock | 3.2718 | 3.2793 | 3.2704 | 3.2793 | 48832.0 |
| 2009-01-07 08:12:00 | AAPL | Stock | 3.2786 | 3.2786 | 3.2757 | 3.2757 | 17500.0 |
| 2009-01-07 08:13:00 | AAPL | Stock | 3.2761 | 3.2764 | 3.2761 | 3.2764 | 9800.0 |
| 2009-01-07 08:14:00 | AAPL | Stock | 3.28 | 3.2804 | 3.28 | 3.2804 | 8400.0 |
| 2009-01-07 08:15:00 | AAPL | Stock | 3.2786 | 3.2821 | 3.2779 | 3.2821 | 184940.0 |
| 2009-01-07 08:16:00 | AAPL | Stock | 3.2764 | 3.2771 | 3.2714 | 3.2764 | 100800.0 |
| 2009-01-07 08:17:00 | AAPL | Stock | 3.2804 | 3.2804 | 3.2768 | 3.2768 | 42000.0 |
| 2009-01-07 08:18:00 | AAPL | Stock | 3.2761 | 3.2768 | 3.275 | 3.2764 | 75936.0 |
| 2009-01-07 08:19:00 | AAPL | Stock | 3.2764 | 3.2764 | 3.2714 | 3.2736 | 57400.0 |
| 2009-01-07 08:20:00 | AAPL | Stock | 3.2718 | 3.2768 | 3.2718 | 3.2768 | 25200.0 |
| 2009-01-07 08:21:00 | AAPL | Stock | 3.2739 | 3.2739 | 3.2714 | 3.2718 | 26908.0 |
| 2009-01-07 08:24:00 | AAPL | Stock | 3.2736 | 3.2736 | 3.2736 | 3.2736 | 2800.0 |
| 2009-01-07 08:25:00 | AAPL | Stock | 3.2736 | 3.2736 | 3.2736 | 3.2736 | 2800.0 |
| 2009-01-07 08:26:00 | AAPL | Stock | 3.2757 | 3.2779 | 3.2757 | 3.2779 | 8400.0 |
| 2009-01-07 08:27:00 | AAPL | Stock | 3.2779 | 3.2779 | 3.2779 | 3.2779 | 2800.0 |
| 2009-01-07 08:28:00 | AAPL | Stock | 3.2807 | 3.2821 | 3.2807 | 3.2821 | 30800.0 |
| 2009-01-07 08:29:00 | AAPL | Stock | 3.2786 | 3.2786 | 3.2786 | 3.2786 | 6300.0 |
| 2009-01-07 08:31:00 | AAPL | Stock | 3.2789 | 3.2804 | 3.2782 | 3.2804 | 42840.0 |
| 2009-01-07 08:32:00 | AAPL | Stock | 3.2786 | 3.28 | 3.2779 | 3.28 | 21000.0 |
| 2009-01-07 08:33:00 | AAPL | Stock | 3.2793 | 3.28 | 3.2793 | 3.28 | 37800.0 |
| 2009-01-07 08:34:00 | AAPL | Stock | 3.2818 | 3.2821 | 3.2814 | 3.2814 | 61600.0 |
| 2009-01-07 08:36:00 | AAPL | Stock | 3.2814 | 3.2843 | 3.2814 | 3.2821 | 31500.0 |
| 2009-01-07 08:37:00 | AAPL | Stock | 3.2836 | 3.2836 | 3.2821 | 3.2821 | 19600.0 |
| 2009-01-07 08:38:00 | AAPL | Stock | 3.2825 | 3.2825 | 3.2804 | 3.2814 | 35364.0 |
| 2009-01-07 08:39:00 | AAPL | Stock | 3.2811 | 3.2811 | 3.2793 | 3.2793 | 14000.0 |
| 2009-01-07 08:40:00 | AAPL | Stock | 3.28 | 3.28 | 3.2786 | 3.28 | 20020.0 |
| 2009-01-07 08:41:00 | AAPL | Stock | 3.2821 | 3.2836 | 3.2811 | 3.2836 | 76300.0 |
| 2009-01-07 08:42:00 | AAPL | Stock | 3.2843 | 3.2843 | 3.2836 | 3.2836 | 119308.0 |
| 2009-01-07 08:43:00 | AAPL | Stock | 3.2825 | 3.2825 | 3.2825 | 3.2825 | 8400.0 |
| 2009-01-07 08:44:00 | AAPL | Stock | 3.2821 | 3.2825 | 3.2818 | 3.2821 | 83720.0 |
| 2009-01-07 08:45:00 | AAPL | Stock | 3.2804 | 3.2804 | 3.28 | 3.28 | 28000.0 |
| 2009-01-07 08:46:00 | AAPL | Stock | 3.2818 | 3.2882 | 3.2818 | 3.2882 | 99820.0 |
| 2009-01-07 08:47:00 | AAPL | Stock | 3.2871 | 3.2879 | 3.2857 | 3.2857 | 36400.0 |
| 2009-01-07 08:48:00 | AAPL | Stock | 3.2882 | 3.2893 | 3.2882 | 3.2893 | 47600.0 |
| 2009-01-07 08:49:00 | AAPL | Stock | 3.2932 | 3.2936 | 3.2932 | 3.2936 | 21280.0 |
| 2009-01-07 08:50:00 | AAPL | Stock | 3.2932 | 3.2932 | 3.2925 | 3.2932 | 56700.0 |
| 2009-01-07 08:51:00 | AAPL | Stock | 3.2961 | 3.2964 | 3.2957 | 3.2957 | 75600.0 |
| 2009-01-07 08:52:00 | AAPL | Stock | 3.2957 | 3.2961 | 3.2946 | 3.2961 | 22400.0 |
| 2009-01-07 08:53:00 | AAPL | Stock | 3.2932 | 3.2939 | 3.2911 | 3.2929 | 39172.0 |
> showing 50 of 968,728 rows — these rows as CSV