PREVIEW / stock_5min / 2011-10-19
file: by_date/stock_5min/2011/2011-10-19.parquet size: 4.6 MB rows: 314,501 symbols: 3,495
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-10-19 04:00:00 | AAPL | Stock | 14.1471 | 14.2857 | 14.1471 | 14.2857 | 103320.0 |
| 2011-10-19 04:05:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 8400.0 |
| 2011-10-19 04:10:00 | AAPL | Stock | 14.2679 | 14.2736 | 14.2593 | 14.2643 | 15400.0 |
| 2011-10-19 04:15:00 | AAPL | Stock | 14.2582 | 14.2818 | 14.2582 | 14.2804 | 14700.0 |
| 2011-10-19 04:20:00 | AAPL | Stock | 14.2725 | 14.2907 | 14.2725 | 14.2907 | 14000.0 |
| 2011-10-19 04:25:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 2800.0 |
| 2011-10-19 04:30:00 | AAPL | Stock | 14.2921 | 14.3032 | 14.2921 | 14.3032 | 8400.0 |
| 2011-10-19 04:35:00 | AAPL | Stock | 14.3032 | 14.3032 | 14.3032 | 14.3032 | 5600.0 |
| 2011-10-19 04:40:00 | AAPL | Stock | 14.3057 | 14.3057 | 14.3057 | 14.3057 | 5600.0 |
| 2011-10-19 04:45:00 | AAPL | Stock | 14.3214 | 14.3232 | 14.3214 | 14.3232 | 83440.0 |
| 2011-10-19 04:55:00 | AAPL | Stock | 14.3054 | 14.3175 | 14.3054 | 14.3175 | 8400.0 |
| 2011-10-19 05:00:00 | AAPL | Stock | 14.3196 | 14.3196 | 14.3125 | 14.3193 | 44380.0 |
| 2011-10-19 05:05:00 | AAPL | Stock | 14.3193 | 14.3232 | 14.3193 | 14.3214 | 15820.0 |
| 2011-10-19 05:10:00 | AAPL | Stock | 14.3232 | 14.3232 | 14.3232 | 14.3232 | 44968.0 |
| 2011-10-19 05:20:00 | AAPL | Stock | 14.3125 | 14.3279 | 14.3125 | 14.3279 | 40600.0 |
| 2011-10-19 05:25:00 | AAPL | Stock | 14.3286 | 14.3286 | 14.3154 | 14.3154 | 114100.0 |
| 2011-10-19 05:30:00 | AAPL | Stock | 14.3114 | 14.3211 | 14.3114 | 14.3125 | 16800.0 |
| 2011-10-19 05:35:00 | AAPL | Stock | 14.3021 | 14.3021 | 14.3021 | 14.3021 | 5600.0 |
| 2011-10-19 05:40:00 | AAPL | Stock | 14.3064 | 14.3064 | 14.3064 | 14.3064 | 2800.0 |
| 2011-10-19 05:45:00 | AAPL | Stock | 14.3064 | 14.3064 | 14.3064 | 14.3064 | 3500.0 |
| 2011-10-19 05:50:00 | AAPL | Stock | 14.2964 | 14.2964 | 14.2868 | 14.2868 | 30800.0 |
| 2011-10-19 05:55:00 | AAPL | Stock | 14.3286 | 14.3286 | 14.3071 | 14.3071 | 5600.0 |
| 2011-10-19 06:00:00 | AAPL | Stock | 14.3107 | 14.3286 | 14.3107 | 14.3286 | 34300.0 |
| 2011-10-19 06:05:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 2800.0 |
| 2011-10-19 06:10:00 | AAPL | Stock | 14.3143 | 14.3304 | 14.3143 | 14.3304 | 5600.0 |
| 2011-10-19 06:15:00 | AAPL | Stock | 14.3086 | 14.3086 | 14.2857 | 14.2939 | 64400.0 |
| 2011-10-19 06:25:00 | AAPL | Stock | 14.2954 | 14.2954 | 14.2954 | 14.2954 | 2800.0 |
| 2011-10-19 06:30:00 | AAPL | Stock | 14.2857 | 14.3118 | 14.2857 | 14.3104 | 42280.0 |
| 2011-10-19 06:35:00 | AAPL | Stock | 14.3179 | 14.3179 | 14.3179 | 14.3179 | 2800.0 |
| 2011-10-19 06:45:00 | AAPL | Stock | 14.3354 | 14.3504 | 14.3257 | 14.3504 | 25200.0 |
| 2011-10-19 06:50:00 | AAPL | Stock | 14.3357 | 14.3571 | 14.3357 | 14.3393 | 62272.0 |
| 2011-10-19 06:55:00 | AAPL | Stock | 14.34 | 14.3864 | 14.34 | 14.3864 | 114968.0 |
| 2011-10-19 07:00:00 | AAPL | Stock | 14.3882 | 14.3907 | 14.3054 | 14.355 | 587272.0 |
| 2011-10-19 07:05:00 | AAPL | Stock | 14.355 | 14.4296 | 14.3482 | 14.4289 | 614040.0 |
| 2011-10-19 07:10:00 | AAPL | Stock | 14.4446 | 14.4561 | 14.3336 | 14.3336 | 410536.0 |
| 2011-10-19 07:15:00 | AAPL | Stock | 14.3486 | 14.3571 | 14.2929 | 14.3136 | 407344.0 |
| 2011-10-19 07:20:00 | AAPL | Stock | 14.3 | 14.3107 | 14.1964 | 14.2107 | 1017604.0 |
| 2011-10-19 07:25:00 | AAPL | Stock | 14.2107 | 14.2179 | 14.1964 | 14.2114 | 792344.0 |
| 2011-10-19 07:30:00 | AAPL | Stock | 14.2143 | 14.2454 | 14.1975 | 14.2211 | 524300.0 |
| 2011-10-19 07:35:00 | AAPL | Stock | 14.2229 | 14.2782 | 14.215 | 14.2775 | 414988.0 |
| 2011-10-19 07:40:00 | AAPL | Stock | 14.2814 | 14.3211 | 14.2771 | 14.3107 | 696612.0 |
| 2011-10-19 07:45:00 | AAPL | Stock | 14.3107 | 14.3143 | 14.2682 | 14.3139 | 813484.0 |
| 2011-10-19 07:50:00 | AAPL | Stock | 14.3121 | 14.3214 | 14.2982 | 14.2982 | 193060.0 |
| 2011-10-19 07:55:00 | AAPL | Stock | 14.2986 | 14.3068 | 14.2768 | 14.2857 | 400680.0 |
| 2011-10-19 08:00:00 | AAPL | Stock | 14.2893 | 14.3214 | 14.2257 | 14.3168 | 1672776.0 |
| 2011-10-19 08:05:00 | AAPL | Stock | 14.3179 | 14.3214 | 14.2854 | 14.2854 | 1681120.0 |
| 2011-10-19 08:10:00 | AAPL | Stock | 14.2854 | 14.2857 | 14.2379 | 14.2425 | 1127672.0 |
| 2011-10-19 08:15:00 | AAPL | Stock | 14.2432 | 14.2939 | 14.2411 | 14.2871 | 1192716.0 |
| 2011-10-19 08:20:00 | AAPL | Stock | 14.2861 | 14.2993 | 14.2696 | 14.2768 | 637896.0 |
| 2011-10-19 08:25:00 | AAPL | Stock | 14.2818 | 14.285 | 14.2686 | 14.2768 | 669900.0 |
> showing 50 of 314,501 rows — these rows as CSV