PREVIEW / stock_1min / 2011-06-03
file: by_date/stock_1min/2011/2011-06-03.parquet size: 13.7 MB rows: 1,033,186 symbols: 2,882
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-03 04:02:00 | AAPL | Stock | 12.3571 | 12.365 | 12.3571 | 12.365 | 8400.0 |
| 2011-06-03 04:12:00 | AAPL | Stock | 12.365 | 12.365 | 12.365 | 12.365 | 2800.0 |
| 2011-06-03 04:37:00 | AAPL | Stock | 12.3629 | 12.3629 | 12.3575 | 12.3575 | 9100.0 |
| 2011-06-03 06:05:00 | AAPL | Stock | 12.3575 | 12.3575 | 12.3575 | 12.3575 | 24500.0 |
| 2011-06-03 06:06:00 | AAPL | Stock | 12.3532 | 12.3532 | 12.3532 | 12.3532 | 28000.0 |
| 2011-06-03 06:07:00 | AAPL | Stock | 12.3479 | 12.3479 | 12.3393 | 12.3393 | 8400.0 |
| 2011-06-03 06:11:00 | AAPL | Stock | 12.3554 | 12.3554 | 12.3554 | 12.3554 | 9660.0 |
| 2011-06-03 07:37:00 | AAPL | Stock | 12.34 | 12.34 | 12.34 | 12.34 | 3136.0 |
| 2011-06-03 07:39:00 | AAPL | Stock | 12.35 | 12.35 | 12.35 | 12.35 | 2800.0 |
| 2011-06-03 07:40:00 | AAPL | Stock | 12.3554 | 12.3554 | 12.35 | 12.35 | 14840.0 |
| 2011-06-03 07:51:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3393 | 12.3393 | 36204.0 |
| 2011-06-03 07:54:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 16800.0 |
| 2011-06-03 08:00:00 | AAPL | Stock | 12.3375 | 12.3393 | 12.3375 | 12.3389 | 31948.0 |
| 2011-06-03 08:01:00 | AAPL | Stock | 12.3321 | 12.3321 | 12.3321 | 12.3321 | 2800.0 |
| 2011-06-03 08:02:00 | AAPL | Stock | 12.3314 | 12.3314 | 12.3314 | 12.3314 | 14000.0 |
| 2011-06-03 08:03:00 | AAPL | Stock | 12.3286 | 12.3286 | 12.3286 | 12.3286 | 23268.0 |
| 2011-06-03 08:04:00 | AAPL | Stock | 12.3286 | 12.3286 | 12.3286 | 12.3286 | 2800.0 |
| 2011-06-03 08:05:00 | AAPL | Stock | 12.3268 | 12.3275 | 12.3268 | 12.3268 | 8428.0 |
| 2011-06-03 08:06:00 | AAPL | Stock | 12.3268 | 12.3268 | 12.3268 | 12.3268 | 2800.0 |
| 2011-06-03 08:07:00 | AAPL | Stock | 12.3257 | 12.3257 | 12.3214 | 12.3214 | 61600.0 |
| 2011-06-03 08:08:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 5600.0 |
| 2011-06-03 08:09:00 | AAPL | Stock | 12.3143 | 12.3143 | 12.3107 | 12.3107 | 38920.0 |
| 2011-06-03 08:10:00 | AAPL | Stock | 12.3107 | 12.3107 | 12.3107 | 12.3107 | 11200.0 |
| 2011-06-03 08:12:00 | AAPL | Stock | 12.3143 | 12.3214 | 12.3143 | 12.3214 | 26320.0 |
| 2011-06-03 08:14:00 | AAPL | Stock | 12.3211 | 12.3211 | 12.3204 | 12.3204 | 23800.0 |
| 2011-06-03 08:17:00 | AAPL | Stock | 12.3179 | 12.3204 | 12.3143 | 12.3143 | 22540.0 |
| 2011-06-03 08:18:00 | AAPL | Stock | 12.3179 | 12.3261 | 12.3161 | 12.3261 | 47040.0 |
| 2011-06-03 08:19:00 | AAPL | Stock | 12.3261 | 12.3261 | 12.3196 | 12.3196 | 14000.0 |
| 2011-06-03 08:20:00 | AAPL | Stock | 12.3232 | 12.3232 | 12.3207 | 12.3221 | 25620.0 |
| 2011-06-03 08:21:00 | AAPL | Stock | 12.3346 | 12.3489 | 12.3346 | 12.3489 | 14000.0 |
| 2011-06-03 08:22:00 | AAPL | Stock | 12.3482 | 12.3525 | 12.3482 | 12.3525 | 14000.0 |
| 2011-06-03 08:23:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3179 | 12.3179 | 84000.0 |
| 2011-06-03 08:25:00 | AAPL | Stock | 12.3389 | 12.3389 | 12.3389 | 12.3389 | 2800.0 |
| 2011-06-03 08:27:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3239 | 12.3239 | 17220.0 |
| 2011-06-03 08:28:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 23128.0 |
| 2011-06-03 08:30:00 | AAPL | Stock | 12.3179 | 12.3214 | 12.2718 | 12.2857 | 331184.0 |
| 2011-06-03 08:31:00 | AAPL | Stock | 12.2857 | 12.2993 | 12.2768 | 12.2857 | 50624.0 |
| 2011-06-03 08:32:00 | AAPL | Stock | 12.2857 | 12.3214 | 12.2779 | 12.3054 | 240884.0 |
| 2011-06-03 08:33:00 | AAPL | Stock | 12.3121 | 12.3121 | 12.2946 | 12.2946 | 100800.0 |
| 2011-06-03 08:34:00 | AAPL | Stock | 12.2911 | 12.3064 | 12.2911 | 12.2918 | 38836.0 |
| 2011-06-03 08:35:00 | AAPL | Stock | 12.2932 | 12.2936 | 12.2857 | 12.2893 | 59668.0 |
| 2011-06-03 08:36:00 | AAPL | Stock | 12.2893 | 12.2893 | 12.27 | 12.2704 | 198240.0 |
| 2011-06-03 08:37:00 | AAPL | Stock | 12.2836 | 12.2839 | 12.2679 | 12.2768 | 113540.0 |
| 2011-06-03 08:38:00 | AAPL | Stock | 12.2764 | 12.2854 | 12.2536 | 12.2618 | 296072.0 |
| 2011-06-03 08:39:00 | AAPL | Stock | 12.2557 | 12.2654 | 12.2532 | 12.2589 | 44800.0 |
| 2011-06-03 08:40:00 | AAPL | Stock | 12.2593 | 12.2682 | 12.2586 | 12.2654 | 75068.0 |
| 2011-06-03 08:41:00 | AAPL | Stock | 12.2654 | 12.2718 | 12.2643 | 12.2643 | 55776.0 |
| 2011-06-03 08:42:00 | AAPL | Stock | 12.2746 | 12.2746 | 12.2679 | 12.2743 | 19600.0 |
| 2011-06-03 08:43:00 | AAPL | Stock | 12.2746 | 12.2746 | 12.2746 | 12.2746 | 11200.0 |
| 2011-06-03 08:44:00 | AAPL | Stock | 12.2732 | 12.2857 | 12.2732 | 12.2839 | 249144.0 |
> showing 50 of 1,033,186 rows — these rows as CSV