PREVIEW / stock_5min / 2012-09-10
file: by_date/stock_5min/2012/2012-09-10.parquet size: 4.7 MB rows: 316,353 symbols: 3,468
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-10 04:20:00 | AAPL | Stock | 24.295 | 24.295 | 24.295 | 24.295 | 2800.0 |
| 2012-09-10 04:25:00 | AAPL | Stock | 24.295 | 24.295 | 24.295 | 24.295 | 2800.0 |
| 2012-09-10 04:55:00 | AAPL | Stock | 24.3 | 24.3 | 24.3 | 24.3 | 6048.0 |
| 2012-09-10 05:20:00 | AAPL | Stock | 24.3036 | 24.3036 | 24.3036 | 24.3036 | 2800.0 |
| 2012-09-10 05:30:00 | AAPL | Stock | 24.3236 | 24.3236 | 24.3236 | 24.3236 | 2800.0 |
| 2012-09-10 05:35:00 | AAPL | Stock | 24.3057 | 24.3057 | 24.3057 | 24.3057 | 2800.0 |
| 2012-09-10 06:05:00 | AAPL | Stock | 24.3214 | 24.3214 | 24.3054 | 24.3054 | 13720.0 |
| 2012-09-10 06:40:00 | AAPL | Stock | 24.3314 | 24.3321 | 24.3314 | 24.3321 | 8400.0 |
| 2012-09-10 06:45:00 | AAPL | Stock | 24.3179 | 24.3246 | 24.3125 | 24.3125 | 23436.0 |
| 2012-09-10 06:50:00 | AAPL | Stock | 24.3107 | 24.3214 | 24.3107 | 24.3214 | 5600.0 |
| 2012-09-10 07:00:00 | AAPL | Stock | 24.3179 | 24.3246 | 24.3 | 24.3 | 63000.0 |
| 2012-09-10 07:05:00 | AAPL | Stock | 24.3004 | 24.3004 | 24.2932 | 24.2932 | 14840.0 |
| 2012-09-10 07:10:00 | AAPL | Stock | 24.3125 | 24.3189 | 24.3125 | 24.3189 | 14364.0 |
| 2012-09-10 07:15:00 | AAPL | Stock | 24.3196 | 24.3196 | 24.305 | 24.31 | 74760.0 |
| 2012-09-10 07:20:00 | AAPL | Stock | 24.3164 | 24.3164 | 24.31 | 24.31 | 19600.0 |
| 2012-09-10 07:25:00 | AAPL | Stock | 24.3107 | 24.3157 | 24.3071 | 24.3143 | 33880.0 |
| 2012-09-10 07:30:00 | AAPL | Stock | 24.3136 | 24.3171 | 24.3107 | 24.3139 | 43904.0 |
| 2012-09-10 07:35:00 | AAPL | Stock | 24.3179 | 24.3318 | 24.3179 | 24.325 | 93240.0 |
| 2012-09-10 07:40:00 | AAPL | Stock | 24.3229 | 24.3304 | 24.3214 | 24.3296 | 51800.0 |
| 2012-09-10 07:45:00 | AAPL | Stock | 24.3296 | 24.3296 | 24.325 | 24.325 | 72352.0 |
| 2012-09-10 07:50:00 | AAPL | Stock | 24.3271 | 24.3293 | 24.3271 | 24.3293 | 5600.0 |
| 2012-09-10 07:55:00 | AAPL | Stock | 24.325 | 24.3293 | 24.3214 | 24.3293 | 24080.0 |
| 2012-09-10 08:00:00 | AAPL | Stock | 24.3261 | 24.3354 | 24.3143 | 24.3354 | 314440.0 |
| 2012-09-10 08:05:00 | AAPL | Stock | 24.3371 | 24.3514 | 24.3357 | 24.3375 | 128604.0 |
| 2012-09-10 08:10:00 | AAPL | Stock | 24.3393 | 24.3429 | 24.3307 | 24.3307 | 63364.0 |
| 2012-09-10 08:15:00 | AAPL | Stock | 24.3354 | 24.3364 | 24.3214 | 24.3221 | 194040.0 |
| 2012-09-10 08:20:00 | AAPL | Stock | 24.3221 | 24.3293 | 24.3107 | 24.3161 | 194768.0 |
| 2012-09-10 08:25:00 | AAPL | Stock | 24.3107 | 24.3179 | 24.2857 | 24.2857 | 543088.0 |
| 2012-09-10 08:30:00 | AAPL | Stock | 24.2857 | 24.2954 | 24.2857 | 24.2929 | 71008.0 |
| 2012-09-10 08:35:00 | AAPL | Stock | 24.295 | 24.2954 | 24.2857 | 24.2893 | 62552.0 |
| 2012-09-10 08:40:00 | AAPL | Stock | 24.2911 | 24.2961 | 24.2879 | 24.2893 | 182308.0 |
| 2012-09-10 08:45:00 | AAPL | Stock | 24.2929 | 24.2943 | 24.2857 | 24.2943 | 66864.0 |
| 2012-09-10 08:50:00 | AAPL | Stock | 24.2904 | 24.2939 | 24.2768 | 24.2768 | 144088.0 |
| 2012-09-10 08:55:00 | AAPL | Stock | 24.2736 | 24.2796 | 24.2675 | 24.2736 | 221676.0 |
| 2012-09-10 09:00:00 | AAPL | Stock | 24.2714 | 24.29 | 24.2714 | 24.29 | 144648.0 |
| 2012-09-10 09:05:00 | AAPL | Stock | 24.29 | 24.2964 | 24.29 | 24.2911 | 179144.0 |
| 2012-09-10 09:10:00 | AAPL | Stock | 24.2882 | 24.2882 | 24.2786 | 24.2857 | 164696.0 |
| 2012-09-10 09:15:00 | AAPL | Stock | 24.2857 | 24.2857 | 24.2768 | 24.2857 | 256508.0 |
| 2012-09-10 09:20:00 | AAPL | Stock | 24.2857 | 24.2954 | 24.2839 | 24.295 | 99204.0 |
| 2012-09-10 09:25:00 | AAPL | Stock | 24.2954 | 24.3143 | 24.2889 | 24.2929 | 193284.0 |
| 2012-09-10 09:30:00 | AAPL | Stock | 24.295 | 24.4032 | 24.2893 | 24.3929 | 18653880.0 |
| 2012-09-10 09:35:00 | AAPL | Stock | 24.3991 | 24.4014 | 24.3468 | 24.3482 | 8998752.0 |
| 2012-09-10 09:40:00 | AAPL | Stock | 24.3482 | 24.3506 | 24.2871 | 24.3168 | 9630600.0 |
| 2012-09-10 09:45:00 | AAPL | Stock | 24.3108 | 24.3382 | 24.27 | 24.3204 | 8661380.0 |
| 2012-09-10 09:50:00 | AAPL | Stock | 24.315 | 24.3571 | 24.2793 | 24.3082 | 8791832.0 |
| 2012-09-10 09:55:00 | AAPL | Stock | 24.305 | 24.3204 | 24.2368 | 24.2393 | 10661448.0 |
| 2012-09-10 10:00:00 | AAPL | Stock | 24.2429 | 24.2661 | 24.2179 | 24.235 | 8159228.0 |
| 2012-09-10 10:05:00 | AAPL | Stock | 24.2396 | 24.2482 | 24.2143 | 24.2346 | 7749952.0 |
| 2012-09-10 10:10:00 | AAPL | Stock | 24.2343 | 24.2371 | 24.1536 | 24.1771 | 11125212.0 |
| 2012-09-10 10:15:00 | AAPL | Stock | 24.1754 | 24.2039 | 24.1675 | 24.1875 | 6918212.0 |
> showing 50 of 316,353 rows — these rows as CSV