PREVIEW / stock_1min / 2010-09-30
file: by_date/stock_1min/2010/2010-09-30.parquet size: 13.1 MB rows: 978,703 symbols: 2,835
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-09-30 04:22:00 | AAPL | Stock | 10.2607 | 10.2607 | 10.2607 | 10.2607 | 2800.0 |
| 2010-09-30 07:40:00 | AAPL | Stock | 10.2611 | 10.2611 | 10.2611 | 10.2611 | 2800.0 |
| 2010-09-30 07:42:00 | AAPL | Stock | 10.2611 | 10.2611 | 10.2589 | 10.2589 | 7056.0 |
| 2010-09-30 08:00:00 | AAPL | Stock | 10.2586 | 10.2586 | 10.2586 | 10.2586 | 5740.0 |
| 2010-09-30 08:01:00 | AAPL | Stock | 10.2561 | 10.2561 | 10.2561 | 10.2561 | 2800.0 |
| 2010-09-30 08:04:00 | AAPL | Stock | 10.2475 | 10.2475 | 10.2475 | 10.2475 | 8400.0 |
| 2010-09-30 08:05:00 | AAPL | Stock | 10.2579 | 10.2579 | 10.2579 | 10.2579 | 2800.0 |
| 2010-09-30 08:06:00 | AAPL | Stock | 10.2475 | 10.2475 | 10.2475 | 10.2475 | 5040.0 |
| 2010-09-30 08:07:00 | AAPL | Stock | 10.2536 | 10.2582 | 10.2536 | 10.2579 | 36120.0 |
| 2010-09-30 08:08:00 | AAPL | Stock | 10.2582 | 10.2589 | 10.2579 | 10.2589 | 50120.0 |
| 2010-09-30 08:10:00 | AAPL | Stock | 10.2579 | 10.2579 | 10.2571 | 10.2571 | 25200.0 |
| 2010-09-30 08:11:00 | AAPL | Stock | 10.2586 | 10.2586 | 10.2586 | 10.2586 | 5600.0 |
| 2010-09-30 08:12:00 | AAPL | Stock | 10.2589 | 10.2589 | 10.2589 | 10.2589 | 8960.0 |
| 2010-09-30 08:13:00 | AAPL | Stock | 10.2589 | 10.2618 | 10.2589 | 10.2607 | 24080.0 |
| 2010-09-30 08:14:00 | AAPL | Stock | 10.2618 | 10.2671 | 10.2618 | 10.2671 | 26600.0 |
| 2010-09-30 08:15:00 | AAPL | Stock | 10.2668 | 10.2668 | 10.2618 | 10.2618 | 19600.0 |
| 2010-09-30 08:16:00 | AAPL | Stock | 10.2621 | 10.2621 | 10.2621 | 10.2621 | 5600.0 |
| 2010-09-30 08:17:00 | AAPL | Stock | 10.2629 | 10.2629 | 10.2611 | 10.2611 | 47600.0 |
| 2010-09-30 08:18:00 | AAPL | Stock | 10.2621 | 10.2661 | 10.2607 | 10.2661 | 16800.0 |
| 2010-09-30 08:19:00 | AAPL | Stock | 10.2661 | 10.2661 | 10.2611 | 10.2611 | 15400.0 |
| 2010-09-30 08:20:00 | AAPL | Stock | 10.2664 | 10.2711 | 10.2643 | 10.2679 | 89320.0 |
| 2010-09-30 08:21:00 | AAPL | Stock | 10.2711 | 10.2711 | 10.2711 | 10.2711 | 2800.0 |
| 2010-09-30 08:22:00 | AAPL | Stock | 10.2729 | 10.2796 | 10.2725 | 10.2796 | 28980.0 |
| 2010-09-30 08:23:00 | AAPL | Stock | 10.2764 | 10.2793 | 10.275 | 10.275 | 182980.0 |
| 2010-09-30 08:24:00 | AAPL | Stock | 10.2679 | 10.2743 | 10.2679 | 10.2732 | 46480.0 |
| 2010-09-30 08:27:00 | AAPL | Stock | 10.2739 | 10.275 | 10.2679 | 10.2679 | 79044.0 |
| 2010-09-30 08:28:00 | AAPL | Stock | 10.2732 | 10.2732 | 10.2646 | 10.2679 | 33320.0 |
| 2010-09-30 08:29:00 | AAPL | Stock | 10.2679 | 10.2679 | 10.2643 | 10.2643 | 18760.0 |
| 2010-09-30 08:30:00 | AAPL | Stock | 10.2679 | 10.2982 | 10.2679 | 10.2936 | 548940.0 |
| 2010-09-30 08:31:00 | AAPL | Stock | 10.2936 | 10.3036 | 10.2893 | 10.3018 | 315364.0 |
| 2010-09-30 08:32:00 | AAPL | Stock | 10.3021 | 10.3136 | 10.3018 | 10.3086 | 211148.0 |
| 2010-09-30 08:33:00 | AAPL | Stock | 10.3107 | 10.3143 | 10.3018 | 10.3021 | 251664.0 |
| 2010-09-30 08:34:00 | AAPL | Stock | 10.3071 | 10.3125 | 10.3018 | 10.3093 | 124516.0 |
| 2010-09-30 08:35:00 | AAPL | Stock | 10.3093 | 10.3214 | 10.3093 | 10.3214 | 259448.0 |
| 2010-09-30 08:36:00 | AAPL | Stock | 10.3214 | 10.3282 | 10.3214 | 10.3218 | 146832.0 |
| 2010-09-30 08:37:00 | AAPL | Stock | 10.3218 | 10.3229 | 10.3189 | 10.3214 | 53368.0 |
| 2010-09-30 08:38:00 | AAPL | Stock | 10.3196 | 10.3214 | 10.3125 | 10.3125 | 131600.0 |
| 2010-09-30 08:39:00 | AAPL | Stock | 10.3125 | 10.3175 | 10.3125 | 10.3161 | 41160.0 |
| 2010-09-30 08:40:00 | AAPL | Stock | 10.3161 | 10.3161 | 10.3143 | 10.3157 | 10528.0 |
| 2010-09-30 08:41:00 | AAPL | Stock | 10.3096 | 10.3096 | 10.3036 | 10.3039 | 53928.0 |
| 2010-09-30 08:42:00 | AAPL | Stock | 10.3075 | 10.3075 | 10.3075 | 10.3075 | 14000.0 |
| 2010-09-30 08:43:00 | AAPL | Stock | 10.3139 | 10.3139 | 10.3139 | 10.3139 | 5404.0 |
| 2010-09-30 08:44:00 | AAPL | Stock | 10.3161 | 10.3204 | 10.3161 | 10.3204 | 12600.0 |
| 2010-09-30 08:45:00 | AAPL | Stock | 10.3179 | 10.3211 | 10.3171 | 10.3211 | 40712.0 |
| 2010-09-30 08:46:00 | AAPL | Stock | 10.3207 | 10.3207 | 10.3179 | 10.3179 | 25816.0 |
| 2010-09-30 08:47:00 | AAPL | Stock | 10.3204 | 10.3211 | 10.3146 | 10.3146 | 73080.0 |
| 2010-09-30 08:48:00 | AAPL | Stock | 10.3161 | 10.3161 | 10.3129 | 10.3136 | 49308.0 |
| 2010-09-30 08:49:00 | AAPL | Stock | 10.3136 | 10.3143 | 10.3129 | 10.3143 | 36400.0 |
| 2010-09-30 08:51:00 | AAPL | Stock | 10.3157 | 10.3171 | 10.3139 | 10.3171 | 98700.0 |
| 2010-09-30 08:52:00 | AAPL | Stock | 10.3168 | 10.3168 | 10.3054 | 10.3125 | 47684.0 |
> showing 50 of 978,703 rows — these rows as CSV