PREVIEW / stock_5min / 2010-11-10
file: by_date/stock_5min/2010/2010-11-10.parquet size: 4.9 MB rows: 331,999 symbols: 3,510
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-11-10 05:10:00 | AAPL | Stock | 11.3018 | 11.3018 | 11.3018 | 11.3018 | 5600.0 |
| 2010-11-10 05:15:00 | AAPL | Stock | 11.305 | 11.3368 | 11.305 | 11.3368 | 11200.0 |
| 2010-11-10 05:40:00 | AAPL | Stock | 11.3036 | 11.3036 | 11.3036 | 11.3036 | 2800.0 |
| 2010-11-10 06:00:00 | AAPL | Stock | 11.3025 | 11.305 | 11.3025 | 11.305 | 8400.0 |
| 2010-11-10 06:05:00 | AAPL | Stock | 11.3189 | 11.3189 | 11.3189 | 11.3189 | 14000.0 |
| 2010-11-10 06:10:00 | AAPL | Stock | 11.3082 | 11.3082 | 11.3082 | 11.3082 | 28000.0 |
| 2010-11-10 06:15:00 | AAPL | Stock | 11.3082 | 11.3082 | 11.3082 | 11.3082 | 2800.0 |
| 2010-11-10 06:20:00 | AAPL | Stock | 11.3082 | 11.3082 | 11.3082 | 11.3082 | 2800.0 |
| 2010-11-10 06:25:00 | AAPL | Stock | 11.3054 | 11.3054 | 11.3054 | 11.3054 | 5600.0 |
| 2010-11-10 06:35:00 | AAPL | Stock | 11.3054 | 11.3189 | 11.3054 | 11.3189 | 8400.0 |
| 2010-11-10 06:45:00 | AAPL | Stock | 11.3189 | 11.3189 | 11.3189 | 11.3189 | 13916.0 |
| 2010-11-10 06:55:00 | AAPL | Stock | 11.3114 | 11.3114 | 11.3114 | 11.3114 | 2800.0 |
| 2010-11-10 07:00:00 | AAPL | Stock | 11.3054 | 11.3425 | 11.3054 | 11.3425 | 22400.0 |
| 2010-11-10 07:05:00 | AAPL | Stock | 11.34 | 11.3404 | 11.34 | 11.34 | 24640.0 |
| 2010-11-10 07:10:00 | AAPL | Stock | 11.3114 | 11.3114 | 11.3114 | 11.3114 | 2800.0 |
| 2010-11-10 07:15:00 | AAPL | Stock | 11.3118 | 11.3118 | 11.3118 | 11.3118 | 2800.0 |
| 2010-11-10 07:20:00 | AAPL | Stock | 11.3118 | 11.3196 | 11.3054 | 11.3054 | 53200.0 |
| 2010-11-10 07:25:00 | AAPL | Stock | 11.3025 | 11.3025 | 11.3025 | 11.3025 | 7700.0 |
| 2010-11-10 07:30:00 | AAPL | Stock | 11.3182 | 11.3182 | 11.3036 | 11.3036 | 8400.0 |
| 2010-11-10 07:40:00 | AAPL | Stock | 11.3 | 11.3 | 11.2864 | 11.2864 | 25200.0 |
| 2010-11-10 07:50:00 | AAPL | Stock | 11.2825 | 11.2843 | 11.2793 | 11.2793 | 89600.0 |
| 2010-11-10 07:55:00 | AAPL | Stock | 11.2793 | 11.3032 | 11.2793 | 11.2993 | 30800.0 |
| 2010-11-10 08:00:00 | AAPL | Stock | 11.2857 | 11.2946 | 11.2857 | 11.2939 | 360836.0 |
| 2010-11-10 08:05:00 | AAPL | Stock | 11.2943 | 11.2946 | 11.2857 | 11.2857 | 203700.0 |
| 2010-11-10 08:10:00 | AAPL | Stock | 11.2857 | 11.2868 | 11.2786 | 11.2786 | 142100.0 |
| 2010-11-10 08:15:00 | AAPL | Stock | 11.28 | 11.3036 | 11.28 | 11.2982 | 277676.0 |
| 2010-11-10 08:20:00 | AAPL | Stock | 11.2961 | 11.2975 | 11.2946 | 11.2946 | 29960.0 |
| 2010-11-10 08:25:00 | AAPL | Stock | 11.2964 | 11.3111 | 11.2946 | 11.3089 | 159432.0 |
| 2010-11-10 08:30:00 | AAPL | Stock | 11.3132 | 11.3171 | 11.3043 | 11.3043 | 428120.0 |
| 2010-11-10 08:35:00 | AAPL | Stock | 11.3071 | 11.3071 | 11.2982 | 11.2982 | 90860.0 |
| 2010-11-10 08:40:00 | AAPL | Stock | 11.2979 | 11.3243 | 11.2979 | 11.32 | 487872.0 |
| 2010-11-10 08:45:00 | AAPL | Stock | 11.3186 | 11.3304 | 11.3186 | 11.3286 | 398300.0 |
| 2010-11-10 08:50:00 | AAPL | Stock | 11.3293 | 11.3304 | 11.3211 | 11.3211 | 131432.0 |
| 2010-11-10 08:55:00 | AAPL | Stock | 11.3161 | 11.3161 | 11.3036 | 11.3057 | 167020.0 |
| 2010-11-10 09:00:00 | AAPL | Stock | 11.3104 | 11.3196 | 11.3071 | 11.3193 | 114352.0 |
| 2010-11-10 09:05:00 | AAPL | Stock | 11.3207 | 11.3282 | 11.315 | 11.3282 | 106204.0 |
| 2010-11-10 09:10:00 | AAPL | Stock | 11.3261 | 11.3311 | 11.3229 | 11.3304 | 119280.0 |
| 2010-11-10 09:15:00 | AAPL | Stock | 11.3257 | 11.3279 | 11.3214 | 11.3214 | 70000.0 |
| 2010-11-10 09:20:00 | AAPL | Stock | 11.3257 | 11.3304 | 11.3218 | 11.3268 | 131040.0 |
| 2010-11-10 09:25:00 | AAPL | Stock | 11.3221 | 11.3243 | 11.3096 | 11.3096 | 156660.0 |
| 2010-11-10 09:30:00 | AAPL | Stock | 11.31 | 11.3389 | 11.2604 | 11.2829 | 18906608.0 |
| 2010-11-10 09:35:00 | AAPL | Stock | 11.2804 | 11.2818 | 11.2524 | 11.2771 | 11640860.0 |
| 2010-11-10 09:40:00 | AAPL | Stock | 11.2771 | 11.2782 | 11.2193 | 11.2643 | 17921680.0 |
| 2010-11-10 09:45:00 | AAPL | Stock | 11.2643 | 11.2768 | 11.2514 | 11.2529 | 6459152.0 |
| 2010-11-10 09:50:00 | AAPL | Stock | 11.2514 | 11.265 | 11.2379 | 11.2546 | 7897596.0 |
| 2010-11-10 09:55:00 | AAPL | Stock | 11.2525 | 11.2629 | 11.2321 | 11.2586 | 9674504.0 |
| 2010-11-10 10:00:00 | AAPL | Stock | 11.2571 | 11.2589 | 11.2393 | 11.2435 | 6889540.0 |
| 2010-11-10 10:05:00 | AAPL | Stock | 11.2421 | 11.2421 | 11.2018 | 11.2125 | 13537440.0 |
| 2010-11-10 10:10:00 | AAPL | Stock | 11.2124 | 11.2321 | 11.1982 | 11.2279 | 8584100.0 |
| 2010-11-10 10:15:00 | AAPL | Stock | 11.2293 | 11.2336 | 11.2207 | 11.2268 | 4640384.0 |
> showing 50 of 331,999 rows — these rows as CSV