PREVIEW / stock_5min / 2010-09-08
file: by_date/stock_5min/2010/2010-09-08.parquet size: 4.5 MB rows: 310,643 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 |
|---|---|---|---|---|---|---|---|
| 2010-09-08 04:05:00 | AAPL | Stock | 9.1968 | 9.1968 | 9.1968 | 9.1968 | 2800.0 |
| 2010-09-08 04:50:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 2800.0 |
| 2010-09-08 05:05:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 8400.0 |
| 2010-09-08 05:10:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 4760.0 |
| 2010-09-08 05:45:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 9240.0 |
| 2010-09-08 06:45:00 | AAPL | Stock | 9.2286 | 9.2286 | 9.2161 | 9.2161 | 12040.0 |
| 2010-09-08 06:50:00 | AAPL | Stock | 9.2143 | 9.2143 | 9.2143 | 9.2143 | 6440.0 |
| 2010-09-08 07:05:00 | AAPL | Stock | 9.2221 | 9.2282 | 9.2221 | 9.2282 | 15960.0 |
| 2010-09-08 07:10:00 | AAPL | Stock | 9.2286 | 9.2429 | 9.2286 | 9.2321 | 8400.0 |
| 2010-09-08 07:15:00 | AAPL | Stock | 9.2411 | 9.25 | 9.2411 | 9.25 | 50400.0 |
| 2010-09-08 07:20:00 | AAPL | Stock | 9.25 | 9.25 | 9.2411 | 9.2411 | 19600.0 |
| 2010-09-08 07:25:00 | AAPL | Stock | 9.25 | 9.25 | 9.2496 | 9.25 | 40740.0 |
| 2010-09-08 07:30:00 | AAPL | Stock | 9.25 | 9.25 | 9.2418 | 9.2418 | 22400.0 |
| 2010-09-08 07:40:00 | AAPL | Stock | 9.2418 | 9.2489 | 9.2418 | 9.2489 | 44800.0 |
| 2010-09-08 07:45:00 | AAPL | Stock | 9.25 | 9.25 | 9.25 | 9.25 | 2800.0 |
| 2010-09-08 07:55:00 | AAPL | Stock | 9.25 | 9.3043 | 9.25 | 9.2875 | 224140.0 |
| 2010-09-08 08:00:00 | AAPL | Stock | 9.2896 | 9.3018 | 9.2546 | 9.2932 | 1382752.0 |
| 2010-09-08 08:05:00 | AAPL | Stock | 9.2939 | 9.3075 | 9.2911 | 9.3 | 609168.0 |
| 2010-09-08 08:10:00 | AAPL | Stock | 9.3 | 9.3036 | 9.295 | 9.2964 | 277396.0 |
| 2010-09-08 08:15:00 | AAPL | Stock | 9.2968 | 9.2993 | 9.2864 | 9.2932 | 459956.0 |
| 2010-09-08 08:20:00 | AAPL | Stock | 9.2929 | 9.2932 | 9.2868 | 9.2904 | 145320.0 |
| 2010-09-08 08:25:00 | AAPL | Stock | 9.2879 | 9.29 | 9.2821 | 9.2843 | 339836.0 |
| 2010-09-08 08:30:00 | AAPL | Stock | 9.2836 | 9.2854 | 9.2793 | 9.2814 | 217980.0 |
| 2010-09-08 08:35:00 | AAPL | Stock | 9.2807 | 9.2821 | 9.2739 | 9.275 | 321664.0 |
| 2010-09-08 08:40:00 | AAPL | Stock | 9.2782 | 9.2782 | 9.2689 | 9.2693 | 238420.0 |
| 2010-09-08 08:45:00 | AAPL | Stock | 9.2714 | 9.2761 | 9.2679 | 9.2693 | 150080.0 |
| 2010-09-08 08:50:00 | AAPL | Stock | 9.2679 | 9.2714 | 9.2668 | 9.2682 | 180320.0 |
| 2010-09-08 08:55:00 | AAPL | Stock | 9.2682 | 9.2682 | 9.2661 | 9.2661 | 91700.0 |
| 2010-09-08 09:00:00 | AAPL | Stock | 9.2707 | 9.2718 | 9.2643 | 9.2679 | 148400.0 |
| 2010-09-08 09:05:00 | AAPL | Stock | 9.2654 | 9.2675 | 9.2589 | 9.2643 | 137760.0 |
| 2010-09-08 09:10:00 | AAPL | Stock | 9.2675 | 9.2679 | 9.2607 | 9.2668 | 131992.0 |
| 2010-09-08 09:15:00 | AAPL | Stock | 9.2664 | 9.2682 | 9.2643 | 9.2682 | 117376.0 |
| 2010-09-08 09:20:00 | AAPL | Stock | 9.2707 | 9.2786 | 9.2693 | 9.2786 | 64120.0 |
| 2010-09-08 09:25:00 | AAPL | Stock | 9.2789 | 9.28 | 9.2714 | 9.2786 | 180404.0 |
| 2010-09-08 09:30:00 | AAPL | Stock | 9.2779 | 9.2857 | 9.2696 | 9.2714 | 21683872.0 |
| 2010-09-08 09:35:00 | AAPL | Stock | 9.2711 | 9.2779 | 9.2536 | 9.268 | 12275648.0 |
| 2010-09-08 09:40:00 | AAPL | Stock | 9.2675 | 9.3025 | 9.2664 | 9.2993 | 17480736.0 |
| 2010-09-08 09:45:00 | AAPL | Stock | 9.3 | 9.3125 | 9.2982 | 9.3036 | 11080384.0 |
| 2010-09-08 09:50:00 | AAPL | Stock | 9.3036 | 9.3068 | 9.2907 | 9.3064 | 11275600.0 |
| 2010-09-08 09:55:00 | AAPL | Stock | 9.3061 | 9.3411 | 9.3061 | 9.3411 | 15977108.0 |
| 2010-09-08 10:00:00 | AAPL | Stock | 9.3407 | 9.3525 | 9.3293 | 9.3454 | 13838720.0 |
| 2010-09-08 10:05:00 | AAPL | Stock | 9.3454 | 9.3568 | 9.3357 | 9.3556 | 10322508.0 |
| 2010-09-08 10:10:00 | AAPL | Stock | 9.355 | 9.3636 | 9.35 | 9.3525 | 16120888.0 |
| 2010-09-08 10:15:00 | AAPL | Stock | 9.3525 | 9.3664 | 9.3425 | 9.354 | 9002420.0 |
| 2010-09-08 10:20:00 | AAPL | Stock | 9.3539 | 9.3661 | 9.3429 | 9.355 | 10286248.0 |
| 2010-09-08 10:25:00 | AAPL | Stock | 9.3554 | 9.3636 | 9.3486 | 9.3514 | 5992252.0 |
| 2010-09-08 10:30:00 | AAPL | Stock | 9.3514 | 9.3679 | 9.3482 | 9.3541 | 7884548.0 |
| 2010-09-08 10:35:00 | AAPL | Stock | 9.3546 | 9.36 | 9.3521 | 9.3525 | 5590032.0 |
| 2010-09-08 10:40:00 | AAPL | Stock | 9.3529 | 9.3632 | 9.35 | 9.3589 | 5465068.0 |
| 2010-09-08 10:45:00 | AAPL | Stock | 9.3589 | 9.3661 | 9.3514 | 9.3546 | 5013484.0 |
> showing 50 of 310,643 rows — these rows as CSV