PREVIEW / stock_5min / 2011-01-12
file: by_date/stock_5min/2011/2011-01-12.parquet size: 4.9 MB rows: 331,033 symbols: 3,520
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-12 04:00:00 | AAPL | Stock | 12.2679 | 12.2857 | 12.2679 | 12.2857 | 12600.0 |
| 2011-01-12 04:20:00 | AAPL | Stock | 12.2893 | 12.2896 | 12.2893 | 12.2896 | 5600.0 |
| 2011-01-12 04:35:00 | AAPL | Stock | 12.2893 | 12.2893 | 12.2893 | 12.2893 | 2800.0 |
| 2011-01-12 04:55:00 | AAPL | Stock | 12.2893 | 12.2893 | 12.2893 | 12.2893 | 2800.0 |
| 2011-01-12 05:00:00 | AAPL | Stock | 12.285 | 12.285 | 12.2679 | 12.2679 | 14000.0 |
| 2011-01-12 05:10:00 | AAPL | Stock | 12.2911 | 12.2914 | 12.2911 | 12.2914 | 8400.0 |
| 2011-01-12 05:15:00 | AAPL | Stock | 12.3 | 12.3 | 12.3 | 12.3 | 2800.0 |
| 2011-01-12 05:20:00 | AAPL | Stock | 12.2996 | 12.2996 | 12.2996 | 12.2996 | 2800.0 |
| 2011-01-12 05:25:00 | AAPL | Stock | 12.2971 | 12.2971 | 12.2971 | 12.2971 | 2800.0 |
| 2011-01-12 05:40:00 | AAPL | Stock | 12.3143 | 12.3143 | 12.3143 | 12.3143 | 2800.0 |
| 2011-01-12 05:45:00 | AAPL | Stock | 12.2929 | 12.3161 | 12.2929 | 12.2929 | 11200.0 |
| 2011-01-12 05:50:00 | AAPL | Stock | 12.2929 | 12.2929 | 12.2929 | 12.2929 | 8400.0 |
| 2011-01-12 05:55:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 2800.0 |
| 2011-01-12 06:15:00 | AAPL | Stock | 12.2893 | 12.2893 | 12.2893 | 12.2893 | 8400.0 |
| 2011-01-12 06:20:00 | AAPL | Stock | 12.2893 | 12.2893 | 12.2893 | 12.2893 | 11200.0 |
| 2011-01-12 06:25:00 | AAPL | Stock | 12.2929 | 12.2929 | 12.2929 | 12.2929 | 2800.0 |
| 2011-01-12 06:35:00 | AAPL | Stock | 12.2893 | 12.2893 | 12.2893 | 12.2893 | 2800.0 |
| 2011-01-12 06:45:00 | AAPL | Stock | 12.2936 | 12.2936 | 12.2936 | 12.2936 | 2800.0 |
| 2011-01-12 06:50:00 | AAPL | Stock | 12.2786 | 12.2786 | 12.2732 | 12.2732 | 8400.0 |
| 2011-01-12 07:00:00 | AAPL | Stock | 12.2736 | 12.2857 | 12.2736 | 12.2768 | 61460.0 |
| 2011-01-12 07:05:00 | AAPL | Stock | 12.2764 | 12.2836 | 12.2764 | 12.2768 | 81200.0 |
| 2011-01-12 07:10:00 | AAPL | Stock | 12.2775 | 12.2789 | 12.2775 | 12.2786 | 30800.0 |
| 2011-01-12 07:15:00 | AAPL | Stock | 12.2839 | 12.2839 | 12.2764 | 12.2764 | 5600.0 |
| 2011-01-12 07:20:00 | AAPL | Stock | 12.2854 | 12.2854 | 12.2854 | 12.2854 | 28000.0 |
| 2011-01-12 07:25:00 | AAPL | Stock | 12.2854 | 12.2854 | 12.2854 | 12.2854 | 25200.0 |
| 2011-01-12 07:30:00 | AAPL | Stock | 12.2821 | 12.2821 | 12.2814 | 12.2818 | 11200.0 |
| 2011-01-12 07:35:00 | AAPL | Stock | 12.2821 | 12.2821 | 12.2679 | 12.2693 | 81200.0 |
| 2011-01-12 07:40:00 | AAPL | Stock | 12.2729 | 12.2729 | 12.2607 | 12.2607 | 61516.0 |
| 2011-01-12 07:45:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2643 | 12.2643 | 30800.0 |
| 2011-01-12 07:50:00 | AAPL | Stock | 12.2668 | 12.2668 | 12.2607 | 12.2607 | 100688.0 |
| 2011-01-12 07:55:00 | AAPL | Stock | 12.2554 | 12.2571 | 12.25 | 12.2507 | 126476.0 |
| 2011-01-12 08:00:00 | AAPL | Stock | 12.25 | 12.2729 | 12.2464 | 12.2621 | 305620.0 |
| 2011-01-12 08:05:00 | AAPL | Stock | 12.2589 | 12.2607 | 12.2554 | 12.2554 | 56000.0 |
| 2011-01-12 08:10:00 | AAPL | Stock | 12.2571 | 12.2571 | 12.2393 | 12.2393 | 128688.0 |
| 2011-01-12 08:15:00 | AAPL | Stock | 12.2479 | 12.2554 | 12.2429 | 12.2554 | 77980.0 |
| 2011-01-12 08:20:00 | AAPL | Stock | 12.2554 | 12.2589 | 12.2507 | 12.2571 | 202440.0 |
| 2011-01-12 08:25:00 | AAPL | Stock | 12.2586 | 12.2639 | 12.2586 | 12.2589 | 156632.0 |
| 2011-01-12 08:30:00 | AAPL | Stock | 12.2589 | 12.2754 | 12.2511 | 12.2754 | 220248.0 |
| 2011-01-12 08:35:00 | AAPL | Stock | 12.27 | 12.2743 | 12.2661 | 12.2714 | 299460.0 |
| 2011-01-12 08:40:00 | AAPL | Stock | 12.2679 | 12.2732 | 12.2625 | 12.2732 | 334264.0 |
| 2011-01-12 08:45:00 | AAPL | Stock | 12.2746 | 12.2746 | 12.2643 | 12.2679 | 142576.0 |
| 2011-01-12 08:50:00 | AAPL | Stock | 12.2661 | 12.2661 | 12.2643 | 12.2643 | 36120.0 |
| 2011-01-12 08:55:00 | AAPL | Stock | 12.2607 | 12.2607 | 12.2539 | 12.2543 | 174636.0 |
| 2011-01-12 09:00:00 | AAPL | Stock | 12.2518 | 12.2518 | 12.2446 | 12.2446 | 211400.0 |
| 2011-01-12 09:05:00 | AAPL | Stock | 12.2464 | 12.2464 | 12.2329 | 12.2429 | 381024.0 |
| 2011-01-12 09:10:00 | AAPL | Stock | 12.2446 | 12.2536 | 12.2432 | 12.2518 | 276248.0 |
| 2011-01-12 09:15:00 | AAPL | Stock | 12.2507 | 12.2536 | 12.2489 | 12.2489 | 209188.0 |
| 2011-01-12 09:20:00 | AAPL | Stock | 12.2493 | 12.25 | 12.2464 | 12.2468 | 135492.0 |
| 2011-01-12 09:25:00 | AAPL | Stock | 12.2464 | 12.2664 | 12.2332 | 12.2654 | 789516.0 |
| 2011-01-12 09:30:00 | AAPL | Stock | 12.2664 | 12.2693 | 12.2143 | 12.2375 | 16736468.0 |
> showing 50 of 331,033 rows — these rows as CSV