PREVIEW / stock_1min / 2007-07-27
file: by_date/stock_1min/2007/2007-07-27.parquet size: 12.8 MB rows: 1,033,408 symbols: 2,526
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-27 09:30:00 | AAPL | Stock | 5.2211 | 5.2275 | 5.2132 | 5.2164 | 13459264.0 |
| 2007-07-27 09:31:00 | AAPL | Stock | 5.2168 | 5.2289 | 5.2096 | 5.2289 | 6309912.0 |
| 2007-07-27 09:32:00 | AAPL | Stock | 5.2286 | 5.2571 | 5.2111 | 5.2111 | 8628228.0 |
| 2007-07-27 09:33:00 | AAPL | Stock | 5.2418 | 5.2679 | 5.2139 | 5.2604 | 8209488.0 |
| 2007-07-27 09:34:00 | AAPL | Stock | 5.2604 | 5.2771 | 5.2318 | 5.2661 | 7554092.0 |
| 2007-07-27 09:35:00 | AAPL | Stock | 5.2679 | 5.2754 | 5.25 | 5.2571 | 6027224.0 |
| 2007-07-27 09:36:00 | AAPL | Stock | 5.2593 | 5.2821 | 5.2514 | 5.2768 | 6258644.0 |
| 2007-07-27 09:37:00 | AAPL | Stock | 5.2775 | 5.2775 | 5.2514 | 5.2518 | 5538820.0 |
| 2007-07-27 09:38:00 | AAPL | Stock | 5.2514 | 5.2514 | 5.2293 | 5.2296 | 8353408.0 |
| 2007-07-27 09:39:00 | AAPL | Stock | 5.2296 | 5.2454 | 5.225 | 5.245 | 4941020.0 |
| 2007-07-27 09:40:00 | AAPL | Stock | 5.2443 | 5.2454 | 5.2286 | 5.2307 | 5514320.0 |
| 2007-07-27 09:41:00 | AAPL | Stock | 5.2307 | 5.2343 | 5.2139 | 5.2182 | 8730428.0 |
| 2007-07-27 09:42:00 | AAPL | Stock | 5.2182 | 5.2317 | 5.2157 | 5.2286 | 4394544.0 |
| 2007-07-27 09:43:00 | AAPL | Stock | 5.2286 | 5.2314 | 5.22 | 5.2304 | 5529020.0 |
| 2007-07-27 09:44:00 | AAPL | Stock | 5.2307 | 5.2411 | 5.2211 | 5.2407 | 6043744.0 |
| 2007-07-27 09:45:00 | AAPL | Stock | 5.2407 | 5.2571 | 5.2321 | 5.2507 | 9350208.0 |
| 2007-07-27 09:46:00 | AAPL | Stock | 5.25 | 5.2514 | 5.2393 | 5.2443 | 3369296.0 |
| 2007-07-27 09:47:00 | AAPL | Stock | 5.2443 | 5.2589 | 5.2418 | 5.2586 | 4940656.0 |
| 2007-07-27 09:48:00 | AAPL | Stock | 5.2584 | 5.2629 | 5.2529 | 5.2589 | 5297628.0 |
| 2007-07-27 09:49:00 | AAPL | Stock | 5.2589 | 5.2661 | 5.2575 | 5.2657 | 6132924.0 |
| 2007-07-27 09:50:00 | AAPL | Stock | 5.2661 | 5.2714 | 5.2564 | 5.2693 | 8531376.0 |
| 2007-07-27 09:51:00 | AAPL | Stock | 5.2696 | 5.275 | 5.2571 | 5.2639 | 4662224.0 |
| 2007-07-27 09:52:00 | AAPL | Stock | 5.2636 | 5.2768 | 5.2636 | 5.2757 | 3102736.0 |
| 2007-07-27 09:53:00 | AAPL | Stock | 5.2757 | 5.2839 | 5.2655 | 5.28 | 5867428.0 |
| 2007-07-27 09:54:00 | AAPL | Stock | 5.2807 | 5.2857 | 5.2757 | 5.2789 | 10266480.0 |
| 2007-07-27 09:55:00 | AAPL | Stock | 5.2775 | 5.2843 | 5.2768 | 5.2821 | 4204844.0 |
| 2007-07-27 09:56:00 | AAPL | Stock | 5.2821 | 5.2857 | 5.28 | 5.2836 | 5559904.0 |
| 2007-07-27 09:57:00 | AAPL | Stock | 5.2829 | 5.2846 | 5.2768 | 5.2832 | 3237108.0 |
| 2007-07-27 09:58:00 | AAPL | Stock | 5.2829 | 5.2854 | 5.2771 | 5.2775 | 4623304.0 |
| 2007-07-27 09:59:00 | AAPL | Stock | 5.2775 | 5.2818 | 5.2746 | 5.2793 | 4827312.0 |
| 2007-07-27 10:00:00 | AAPL | Stock | 5.279 | 5.2807 | 5.2629 | 5.2746 | 5499256.0 |
| 2007-07-27 10:01:00 | AAPL | Stock | 5.2764 | 5.2857 | 5.2743 | 5.2836 | 8734936.0 |
| 2007-07-27 10:02:00 | AAPL | Stock | 5.2832 | 5.2854 | 5.2796 | 5.2829 | 4033904.0 |
| 2007-07-27 10:03:00 | AAPL | Stock | 5.2825 | 5.2829 | 5.2725 | 5.2743 | 4521076.0 |
| 2007-07-27 10:04:00 | AAPL | Stock | 5.2743 | 5.2943 | 5.2736 | 5.2943 | 11160128.0 |
| 2007-07-27 10:05:00 | AAPL | Stock | 5.294 | 5.3125 | 5.2921 | 5.3107 | 12818540.0 |
| 2007-07-27 10:06:00 | AAPL | Stock | 5.3107 | 5.3164 | 5.3036 | 5.3107 | 11662504.0 |
| 2007-07-27 10:07:00 | AAPL | Stock | 5.3104 | 5.3186 | 5.3086 | 5.3118 | 7981400.0 |
| 2007-07-27 10:08:00 | AAPL | Stock | 5.3111 | 5.3129 | 5.3021 | 5.3054 | 5888960.0 |
| 2007-07-27 10:09:00 | AAPL | Stock | 5.3064 | 5.3071 | 5.2893 | 5.2964 | 5771892.0 |
| 2007-07-27 10:10:00 | AAPL | Stock | 5.2968 | 5.3125 | 5.2904 | 5.3125 | 5003012.0 |
| 2007-07-27 10:11:00 | AAPL | Stock | 5.3125 | 5.3125 | 5.2971 | 5.3014 | 5820500.0 |
| 2007-07-27 10:12:00 | AAPL | Stock | 5.3018 | 5.3104 | 5.2946 | 5.2968 | 3896256.0 |
| 2007-07-27 10:13:00 | AAPL | Stock | 5.2986 | 5.3021 | 5.2925 | 5.2932 | 4263476.0 |
| 2007-07-27 10:14:00 | AAPL | Stock | 5.2936 | 5.2939 | 5.2768 | 5.2868 | 6540464.0 |
| 2007-07-27 10:15:00 | AAPL | Stock | 5.285 | 5.2906 | 5.2789 | 5.2854 | 3669820.0 |
| 2007-07-27 10:16:00 | AAPL | Stock | 5.2875 | 5.2946 | 5.2839 | 5.2857 | 2670752.0 |
| 2007-07-27 10:17:00 | AAPL | Stock | 5.2857 | 5.2911 | 5.2836 | 5.2864 | 2413096.0 |
| 2007-07-27 10:18:00 | AAPL | Stock | 5.2871 | 5.2929 | 5.2843 | 5.2929 | 2713200.0 |
| 2007-07-27 10:19:00 | AAPL | Stock | 5.2929 | 5.3 | 5.2925 | 5.2968 | 3527580.0 |
> showing 50 of 1,033,408 rows — these rows as CSV