PREVIEW / stock_5min / 2009-05-14
file: by_date/stock_5min/2009/2009-05-14.parquet size: 4.5 MB rows: 314,170 symbols: 3,312
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-05-14 07:10:00 | AAPL | Stock | 4.2532 | 4.2532 | 4.2532 | 4.2532 | 2800.0 |
| 2009-05-14 07:15:00 | AAPL | Stock | 4.25 | 4.25 | 4.25 | 4.25 | 17220.0 |
| 2009-05-14 07:20:00 | AAPL | Stock | 4.25 | 4.2532 | 4.25 | 4.2532 | 13580.0 |
| 2009-05-14 07:25:00 | AAPL | Stock | 4.2496 | 4.2496 | 4.2496 | 4.2496 | 2800.0 |
| 2009-05-14 07:30:00 | AAPL | Stock | 4.2496 | 4.2496 | 4.2496 | 4.2496 | 5600.0 |
| 2009-05-14 07:35:00 | AAPL | Stock | 4.2496 | 4.25 | 4.2496 | 4.25 | 46900.0 |
| 2009-05-14 07:45:00 | AAPL | Stock | 4.2746 | 4.2746 | 4.2746 | 4.2746 | 2800.0 |
| 2009-05-14 07:50:00 | AAPL | Stock | 4.2746 | 4.2836 | 4.2689 | 4.2818 | 39200.0 |
| 2009-05-14 07:55:00 | AAPL | Stock | 4.275 | 4.2857 | 4.275 | 4.2857 | 47600.0 |
| 2009-05-14 08:00:00 | AAPL | Stock | 4.2707 | 4.2768 | 4.2707 | 4.2714 | 32788.0 |
| 2009-05-14 08:05:00 | AAPL | Stock | 4.2714 | 4.2714 | 4.2607 | 4.2625 | 245168.0 |
| 2009-05-14 08:10:00 | AAPL | Stock | 4.2643 | 4.2643 | 4.2593 | 4.2625 | 46172.0 |
| 2009-05-14 08:15:00 | AAPL | Stock | 4.2589 | 4.2625 | 4.2589 | 4.2604 | 22988.0 |
| 2009-05-14 08:20:00 | AAPL | Stock | 4.2625 | 4.2629 | 4.2618 | 4.2618 | 22400.0 |
| 2009-05-14 08:25:00 | AAPL | Stock | 4.2639 | 4.2643 | 4.2607 | 4.2607 | 77924.0 |
| 2009-05-14 08:30:00 | AAPL | Stock | 4.2636 | 4.2636 | 4.25 | 4.2625 | 715764.0 |
| 2009-05-14 08:35:00 | AAPL | Stock | 4.2636 | 4.2714 | 4.2636 | 4.2679 | 401744.0 |
| 2009-05-14 08:40:00 | AAPL | Stock | 4.2679 | 4.2732 | 4.2679 | 4.2732 | 60900.0 |
| 2009-05-14 08:45:00 | AAPL | Stock | 4.27 | 4.2761 | 4.2693 | 4.2714 | 41804.0 |
| 2009-05-14 08:50:00 | AAPL | Stock | 4.2711 | 4.2732 | 4.2711 | 4.2714 | 56000.0 |
| 2009-05-14 08:55:00 | AAPL | Stock | 4.2725 | 4.2725 | 4.2643 | 4.2643 | 130312.0 |
| 2009-05-14 09:00:00 | AAPL | Stock | 4.2654 | 4.2661 | 4.2654 | 4.2661 | 28000.0 |
| 2009-05-14 09:05:00 | AAPL | Stock | 4.2664 | 4.2675 | 4.2654 | 4.2654 | 176680.0 |
| 2009-05-14 09:10:00 | AAPL | Stock | 4.2639 | 4.2643 | 4.2636 | 4.2643 | 193200.0 |
| 2009-05-14 09:15:00 | AAPL | Stock | 4.2643 | 4.2832 | 4.2614 | 4.2807 | 213920.0 |
| 2009-05-14 09:20:00 | AAPL | Stock | 4.2786 | 4.2836 | 4.275 | 4.2821 | 166908.0 |
| 2009-05-14 09:25:00 | AAPL | Stock | 4.2839 | 4.2921 | 4.2736 | 4.2768 | 910140.0 |
| 2009-05-14 09:30:00 | AAPL | Stock | 4.2768 | 4.3168 | 4.275 | 4.3032 | 15318100.0 |
| 2009-05-14 09:35:00 | AAPL | Stock | 4.3036 | 4.3036 | 4.2761 | 4.2882 | 15554224.0 |
| 2009-05-14 09:40:00 | AAPL | Stock | 4.2879 | 4.3154 | 4.2818 | 4.3132 | 13156780.0 |
| 2009-05-14 09:45:00 | AAPL | Stock | 4.3132 | 4.3154 | 4.2875 | 4.2875 | 8347668.0 |
| 2009-05-14 09:50:00 | AAPL | Stock | 4.2871 | 4.2996 | 4.2757 | 4.2843 | 8041572.0 |
| 2009-05-14 09:55:00 | AAPL | Stock | 4.2812 | 4.3121 | 4.2804 | 4.3109 | 8034768.0 |
| 2009-05-14 10:00:00 | AAPL | Stock | 4.3118 | 4.3268 | 4.31 | 4.3221 | 12912816.0 |
| 2009-05-14 10:05:00 | AAPL | Stock | 4.3221 | 4.3321 | 4.3125 | 4.3293 | 10778964.0 |
| 2009-05-14 10:10:00 | AAPL | Stock | 4.3296 | 4.3375 | 4.3214 | 4.3271 | 9133852.0 |
| 2009-05-14 10:15:00 | AAPL | Stock | 4.3271 | 4.3304 | 4.3146 | 4.32 | 6547324.0 |
| 2009-05-14 10:20:00 | AAPL | Stock | 4.3202 | 4.35 | 4.3201 | 4.3364 | 10731252.0 |
| 2009-05-14 10:25:00 | AAPL | Stock | 4.3346 | 4.3396 | 4.3318 | 4.3361 | 5239780.0 |
| 2009-05-14 10:30:00 | AAPL | Stock | 4.3361 | 4.3457 | 4.3304 | 4.342 | 4513908.0 |
| 2009-05-14 10:35:00 | AAPL | Stock | 4.3421 | 4.3446 | 4.3386 | 4.3386 | 4425484.0 |
| 2009-05-14 10:40:00 | AAPL | Stock | 4.3391 | 4.3429 | 4.3296 | 4.3325 | 5167484.0 |
| 2009-05-14 10:45:00 | AAPL | Stock | 4.3321 | 4.3364 | 4.3311 | 4.3321 | 4319140.0 |
| 2009-05-14 10:50:00 | AAPL | Stock | 4.3321 | 4.3429 | 4.3318 | 4.3364 | 3711764.0 |
| 2009-05-14 10:55:00 | AAPL | Stock | 4.3368 | 4.3482 | 4.3343 | 4.3461 | 4190676.0 |
| 2009-05-14 11:00:00 | AAPL | Stock | 4.3461 | 4.3571 | 4.3439 | 4.3532 | 5367516.0 |
| 2009-05-14 11:05:00 | AAPL | Stock | 4.3529 | 4.3593 | 4.3486 | 4.3507 | 4010888.0 |
| 2009-05-14 11:10:00 | AAPL | Stock | 4.3507 | 4.3661 | 4.3507 | 4.3643 | 5164096.0 |
| 2009-05-14 11:15:00 | AAPL | Stock | 4.3643 | 4.3739 | 4.3643 | 4.3714 | 6663664.0 |
| 2009-05-14 11:20:00 | AAPL | Stock | 4.3721 | 4.3736 | 4.3586 | 4.3596 | 5294688.0 |
> showing 50 of 314,170 rows — these rows as CSV