PREVIEW / stock_1min / 2010-08-06
file: by_date/stock_1min/2010/2010-08-06.parquet size: 12.4 MB rows: 945,720 symbols: 2,801
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-06 07:25:00 | AAPL | Stock | 9.3479 | 9.3479 | 9.3479 | 9.3479 | 3360.0 |
| 2010-08-06 08:00:00 | AAPL | Stock | 9.3432 | 9.3529 | 9.3432 | 9.3529 | 10780.0 |
| 2010-08-06 08:01:00 | AAPL | Stock | 9.3396 | 9.3396 | 9.3393 | 9.3393 | 5600.0 |
| 2010-08-06 08:02:00 | AAPL | Stock | 9.3357 | 9.3357 | 9.3357 | 9.3357 | 7280.0 |
| 2010-08-06 08:03:00 | AAPL | Stock | 9.3375 | 9.3375 | 9.3357 | 9.3357 | 10892.0 |
| 2010-08-06 08:04:00 | AAPL | Stock | 9.3361 | 9.3361 | 9.3361 | 9.3361 | 2800.0 |
| 2010-08-06 08:07:00 | AAPL | Stock | 9.3371 | 9.3432 | 9.3371 | 9.3432 | 8400.0 |
| 2010-08-06 08:08:00 | AAPL | Stock | 9.3425 | 9.3425 | 9.3425 | 9.3425 | 2800.0 |
| 2010-08-06 08:09:00 | AAPL | Stock | 9.3368 | 9.3368 | 9.3368 | 9.3368 | 5600.0 |
| 2010-08-06 08:12:00 | AAPL | Stock | 9.3364 | 9.3364 | 9.3293 | 9.3293 | 16800.0 |
| 2010-08-06 08:14:00 | AAPL | Stock | 9.3232 | 9.3282 | 9.3157 | 9.3157 | 66976.0 |
| 2010-08-06 08:15:00 | AAPL | Stock | 9.3207 | 9.3218 | 9.3207 | 9.3218 | 17304.0 |
| 2010-08-06 08:16:00 | AAPL | Stock | 9.3218 | 9.3218 | 9.3207 | 9.3207 | 28000.0 |
| 2010-08-06 08:17:00 | AAPL | Stock | 9.3332 | 9.3332 | 9.3332 | 9.3332 | 12264.0 |
| 2010-08-06 08:18:00 | AAPL | Stock | 9.3289 | 9.3289 | 9.3289 | 9.3289 | 2800.0 |
| 2010-08-06 08:19:00 | AAPL | Stock | 9.3254 | 9.33 | 9.3232 | 9.33 | 19600.0 |
| 2010-08-06 08:20:00 | AAPL | Stock | 9.3214 | 9.3214 | 9.3214 | 9.3214 | 11900.0 |
| 2010-08-06 08:21:00 | AAPL | Stock | 9.3286 | 9.3286 | 9.3286 | 9.3286 | 2800.0 |
| 2010-08-06 08:22:00 | AAPL | Stock | 9.325 | 9.325 | 9.325 | 9.325 | 4900.0 |
| 2010-08-06 08:23:00 | AAPL | Stock | 9.325 | 9.325 | 9.325 | 9.325 | 2800.0 |
| 2010-08-06 08:24:00 | AAPL | Stock | 9.3264 | 9.3268 | 9.3264 | 9.3268 | 9800.0 |
| 2010-08-06 08:25:00 | AAPL | Stock | 9.3286 | 9.3286 | 9.3268 | 9.3268 | 19600.0 |
| 2010-08-06 08:26:00 | AAPL | Stock | 9.3254 | 9.3254 | 9.3254 | 9.3254 | 3360.0 |
| 2010-08-06 08:27:00 | AAPL | Stock | 9.3286 | 9.3286 | 9.3179 | 9.3179 | 43680.0 |
| 2010-08-06 08:28:00 | AAPL | Stock | 9.3175 | 9.3214 | 9.3175 | 9.3214 | 52220.0 |
| 2010-08-06 08:29:00 | AAPL | Stock | 9.3214 | 9.3221 | 9.3214 | 9.3214 | 66584.0 |
| 2010-08-06 08:30:00 | AAPL | Stock | 9.3214 | 9.3339 | 9.2732 | 9.3054 | 555772.0 |
| 2010-08-06 08:31:00 | AAPL | Stock | 9.2857 | 9.3021 | 9.2821 | 9.29 | 365400.0 |
| 2010-08-06 08:32:00 | AAPL | Stock | 9.2914 | 9.3132 | 9.2914 | 9.3021 | 172788.0 |
| 2010-08-06 08:33:00 | AAPL | Stock | 9.3036 | 9.3175 | 9.2946 | 9.3036 | 173880.0 |
| 2010-08-06 08:34:00 | AAPL | Stock | 9.3071 | 9.3079 | 9.3021 | 9.3021 | 68320.0 |
| 2010-08-06 08:35:00 | AAPL | Stock | 9.3018 | 9.3111 | 9.2821 | 9.2857 | 343728.0 |
| 2010-08-06 08:36:00 | AAPL | Stock | 9.2857 | 9.2886 | 9.2771 | 9.2864 | 167776.0 |
| 2010-08-06 08:37:00 | AAPL | Stock | 9.285 | 9.2879 | 9.2786 | 9.28 | 249480.0 |
| 2010-08-06 08:38:00 | AAPL | Stock | 9.2793 | 9.2804 | 9.2729 | 9.2782 | 132720.0 |
| 2010-08-06 08:39:00 | AAPL | Stock | 9.2825 | 9.2857 | 9.2786 | 9.2846 | 415660.0 |
| 2010-08-06 08:40:00 | AAPL | Stock | 9.2825 | 9.2857 | 9.2818 | 9.285 | 69832.0 |
| 2010-08-06 08:41:00 | AAPL | Stock | 9.2914 | 9.2925 | 9.2818 | 9.2818 | 103600.0 |
| 2010-08-06 08:42:00 | AAPL | Stock | 9.2825 | 9.2832 | 9.2768 | 9.2775 | 116788.0 |
| 2010-08-06 08:43:00 | AAPL | Stock | 9.2804 | 9.2821 | 9.275 | 9.2821 | 78904.0 |
| 2010-08-06 08:44:00 | AAPL | Stock | 9.2811 | 9.2932 | 9.2804 | 9.2857 | 170800.0 |
| 2010-08-06 08:45:00 | AAPL | Stock | 9.2904 | 9.3018 | 9.2857 | 9.2982 | 374780.0 |
| 2010-08-06 08:46:00 | AAPL | Stock | 9.2946 | 9.2964 | 9.2918 | 9.2918 | 53200.0 |
| 2010-08-06 08:47:00 | AAPL | Stock | 9.2929 | 9.2996 | 9.2929 | 9.2986 | 72128.0 |
| 2010-08-06 08:48:00 | AAPL | Stock | 9.2982 | 9.3018 | 9.2961 | 9.3018 | 70420.0 |
| 2010-08-06 08:49:00 | AAPL | Stock | 9.2989 | 9.3025 | 9.2929 | 9.2968 | 199500.0 |
| 2010-08-06 08:50:00 | AAPL | Stock | 9.2957 | 9.3 | 9.2954 | 9.2982 | 63224.0 |
| 2010-08-06 08:51:00 | AAPL | Stock | 9.2957 | 9.2979 | 9.2943 | 9.2964 | 57400.0 |
| 2010-08-06 08:52:00 | AAPL | Stock | 9.2957 | 9.3004 | 9.2957 | 9.2986 | 73276.0 |
| 2010-08-06 08:53:00 | AAPL | Stock | 9.2964 | 9.2982 | 9.2964 | 9.2982 | 19600.0 |
> showing 50 of 945,720 rows — these rows as CSV