PREVIEW / stock_5min / 2009-02-19
file: by_date/stock_5min/2009/2009-02-19.parquet size: 4.3 MB rows: 302,415 symbols: 3,323
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-19 07:00:00 | AAPL | Stock | 3.3168 | 3.3168 | 3.3161 | 3.3161 | 126840.0 |
| 2009-02-19 07:05:00 | AAPL | Stock | 3.3161 | 3.3161 | 3.3157 | 3.3161 | 56560.0 |
| 2009-02-19 07:20:00 | AAPL | Stock | 3.3214 | 3.3214 | 3.3214 | 3.3214 | 5600.0 |
| 2009-02-19 07:30:00 | AAPL | Stock | 3.3214 | 3.3329 | 3.3214 | 3.3286 | 54320.0 |
| 2009-02-19 07:35:00 | AAPL | Stock | 3.3304 | 3.3339 | 3.3304 | 3.3304 | 36428.0 |
| 2009-02-19 07:40:00 | AAPL | Stock | 3.3268 | 3.3268 | 3.3179 | 3.3204 | 173656.0 |
| 2009-02-19 07:45:00 | AAPL | Stock | 3.3261 | 3.3261 | 3.3239 | 3.3239 | 19404.0 |
| 2009-02-19 07:50:00 | AAPL | Stock | 3.3232 | 3.33 | 3.3204 | 3.3214 | 131096.0 |
| 2009-02-19 07:55:00 | AAPL | Stock | 3.3214 | 3.3214 | 3.3214 | 3.3214 | 184800.0 |
| 2009-02-19 08:00:00 | AAPL | Stock | 3.3261 | 3.3704 | 3.3236 | 3.3293 | 455224.0 |
| 2009-02-19 08:05:00 | AAPL | Stock | 3.3293 | 3.3293 | 3.3214 | 3.3282 | 215712.0 |
| 2009-02-19 08:10:00 | AAPL | Stock | 3.3264 | 3.3296 | 3.3236 | 3.3296 | 70840.0 |
| 2009-02-19 08:15:00 | AAPL | Stock | 3.3296 | 3.3304 | 3.3264 | 3.3304 | 150248.0 |
| 2009-02-19 08:20:00 | AAPL | Stock | 3.3339 | 3.3339 | 3.33 | 3.3304 | 204372.0 |
| 2009-02-19 08:25:00 | AAPL | Stock | 3.33 | 3.33 | 3.3214 | 3.3214 | 206920.0 |
| 2009-02-19 08:30:00 | AAPL | Stock | 3.3243 | 3.325 | 3.3218 | 3.3236 | 98000.0 |
| 2009-02-19 08:35:00 | AAPL | Stock | 3.3268 | 3.3704 | 3.3232 | 3.3704 | 2538508.0 |
| 2009-02-19 08:40:00 | AAPL | Stock | 3.3304 | 3.3332 | 3.3304 | 3.3332 | 30800.0 |
| 2009-02-19 08:45:00 | AAPL | Stock | 3.3339 | 3.3339 | 3.3286 | 3.3339 | 193732.0 |
| 2009-02-19 08:50:00 | AAPL | Stock | 3.3332 | 3.3375 | 3.3332 | 3.3361 | 104216.0 |
| 2009-02-19 08:55:00 | AAPL | Stock | 3.3361 | 3.3443 | 3.3361 | 3.3443 | 80696.0 |
| 2009-02-19 09:00:00 | AAPL | Stock | 3.3421 | 3.3429 | 3.3357 | 3.3371 | 423332.0 |
| 2009-02-19 09:05:00 | AAPL | Stock | 3.3429 | 3.3568 | 3.3375 | 3.3375 | 247744.0 |
| 2009-02-19 09:10:00 | AAPL | Stock | 3.3393 | 3.3418 | 3.3304 | 3.3321 | 471296.0 |
| 2009-02-19 09:15:00 | AAPL | Stock | 3.3314 | 3.3318 | 3.3264 | 3.3307 | 223104.0 |
| 2009-02-19 09:20:00 | AAPL | Stock | 3.3307 | 3.3379 | 3.3304 | 3.3364 | 356776.0 |
| 2009-02-19 09:25:00 | AAPL | Stock | 3.3361 | 3.3393 | 3.3268 | 3.3332 | 1243508.0 |
| 2009-02-19 09:30:00 | AAPL | Stock | 3.3346 | 3.3661 | 3.3214 | 3.3239 | 22419796.0 |
| 2009-02-19 09:35:00 | AAPL | Stock | 3.3232 | 3.3432 | 3.3125 | 3.3129 | 19588268.0 |
| 2009-02-19 09:40:00 | AAPL | Stock | 3.3129 | 3.3264 | 3.3043 | 3.3046 | 24462228.0 |
| 2009-02-19 09:45:00 | AAPL | Stock | 3.305 | 3.3082 | 3.2864 | 3.2864 | 19937988.0 |
| 2009-02-19 09:50:00 | AAPL | Stock | 3.2871 | 3.2896 | 3.2775 | 3.2893 | 25819584.0 |
| 2009-02-19 09:55:00 | AAPL | Stock | 3.2893 | 3.31 | 3.2857 | 3.3096 | 21061012.0 |
| 2009-02-19 10:00:00 | AAPL | Stock | 3.3096 | 3.3189 | 3.3004 | 3.3168 | 16502864.0 |
| 2009-02-19 10:05:00 | AAPL | Stock | 3.3164 | 3.3168 | 3.3043 | 3.3136 | 11223576.0 |
| 2009-02-19 10:10:00 | AAPL | Stock | 3.3139 | 3.3182 | 3.3089 | 3.3096 | 10594472.0 |
| 2009-02-19 10:15:00 | AAPL | Stock | 3.3093 | 3.3121 | 3.2957 | 3.2982 | 11574220.0 |
| 2009-02-19 10:20:00 | AAPL | Stock | 3.2982 | 3.3032 | 3.2868 | 3.2871 | 16780260.0 |
| 2009-02-19 10:25:00 | AAPL | Stock | 3.2875 | 3.2925 | 3.2782 | 3.2914 | 13615784.0 |
| 2009-02-19 10:30:00 | AAPL | Stock | 3.2914 | 3.2929 | 3.275 | 3.2757 | 15746472.0 |
| 2009-02-19 10:35:00 | AAPL | Stock | 3.2757 | 3.2768 | 3.2632 | 3.2693 | 17453268.0 |
| 2009-02-19 10:40:00 | AAPL | Stock | 3.2692 | 3.2782 | 3.2664 | 3.2782 | 10058244.0 |
| 2009-02-19 10:45:00 | AAPL | Stock | 3.2782 | 3.2825 | 3.2632 | 3.2636 | 12289256.0 |
| 2009-02-19 10:50:00 | AAPL | Stock | 3.2636 | 3.2646 | 3.2507 | 3.2514 | 14130928.0 |
| 2009-02-19 10:55:00 | AAPL | Stock | 3.2518 | 3.2627 | 3.2482 | 3.2489 | 12065536.0 |
| 2009-02-19 11:00:00 | AAPL | Stock | 3.2482 | 3.2604 | 3.2461 | 3.2586 | 15055516.0 |
| 2009-02-19 11:05:00 | AAPL | Stock | 3.2586 | 3.265 | 3.2564 | 3.2646 | 12317648.0 |
| 2009-02-19 11:10:00 | AAPL | Stock | 3.2646 | 3.2729 | 3.2629 | 3.2714 | 9543632.0 |
| 2009-02-19 11:15:00 | AAPL | Stock | 3.2707 | 3.2761 | 3.2675 | 3.2736 | 6795348.0 |
| 2009-02-19 11:20:00 | AAPL | Stock | 3.2739 | 3.2768 | 3.2636 | 3.2661 | 8308300.0 |
> showing 50 of 302,415 rows — these rows as CSV