PREVIEW / stock_5min / 2012-01-31
file: by_date/stock_5min/2012/2012-01-31.parquet size: 4.9 MB rows: 327,112 symbols: 3,527
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-31 04:15:00 | AAPL | Stock | 16.3039 | 16.3039 | 16.2857 | 16.2857 | 5600.0 |
| 2012-01-31 04:20:00 | AAPL | Stock | 16.305 | 16.305 | 16.305 | 16.305 | 4508.0 |
| 2012-01-31 04:35:00 | AAPL | Stock | 16.3036 | 16.3132 | 16.3036 | 16.3036 | 11200.0 |
| 2012-01-31 04:40:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.3036 | 16.3036 | 14000.0 |
| 2012-01-31 04:45:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 14000.0 |
| 2012-01-31 04:50:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 8260.0 |
| 2012-01-31 05:05:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 16884.0 |
| 2012-01-31 05:20:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 8400.0 |
| 2012-01-31 05:25:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.3036 | 16.3036 | 14000.0 |
| 2012-01-31 05:35:00 | AAPL | Stock | 16.3032 | 16.3032 | 16.3032 | 16.3032 | 14000.0 |
| 2012-01-31 05:40:00 | AAPL | Stock | 16.3014 | 16.3032 | 16.3014 | 16.3032 | 13636.0 |
| 2012-01-31 05:55:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.3036 | 16.3036 | 5600.0 |
| 2012-01-31 06:00:00 | AAPL | Stock | 16.3036 | 16.3175 | 16.3036 | 16.3175 | 26600.0 |
| 2012-01-31 06:40:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2814 | 16.2814 | 29400.0 |
| 2012-01-31 06:45:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 8400.0 |
| 2012-01-31 06:55:00 | AAPL | Stock | 16.285 | 16.285 | 16.2718 | 16.285 | 22400.0 |
| 2012-01-31 07:00:00 | AAPL | Stock | 16.285 | 16.285 | 16.2429 | 16.2521 | 55020.0 |
| 2012-01-31 07:05:00 | AAPL | Stock | 16.2554 | 16.2554 | 16.2536 | 16.2536 | 5936.0 |
| 2012-01-31 07:10:00 | AAPL | Stock | 16.2643 | 16.2679 | 16.2579 | 16.2679 | 42896.0 |
| 2012-01-31 07:15:00 | AAPL | Stock | 16.275 | 16.2764 | 16.275 | 16.2764 | 8400.0 |
| 2012-01-31 07:20:00 | AAPL | Stock | 16.275 | 16.2843 | 16.275 | 16.2768 | 63028.0 |
| 2012-01-31 07:25:00 | AAPL | Stock | 16.2768 | 16.285 | 16.275 | 16.285 | 95200.0 |
| 2012-01-31 07:30:00 | AAPL | Stock | 16.2846 | 16.2921 | 16.2846 | 16.285 | 78960.0 |
| 2012-01-31 07:35:00 | AAPL | Stock | 16.2804 | 16.285 | 16.2793 | 16.2846 | 112000.0 |
| 2012-01-31 07:40:00 | AAPL | Stock | 16.2857 | 16.2943 | 16.2804 | 16.2804 | 53732.0 |
| 2012-01-31 07:45:00 | AAPL | Stock | 16.2807 | 16.2854 | 16.2643 | 16.2643 | 126504.0 |
| 2012-01-31 07:50:00 | AAPL | Stock | 16.2625 | 16.2679 | 16.2589 | 16.2679 | 78540.0 |
| 2012-01-31 07:55:00 | AAPL | Stock | 16.2543 | 16.2589 | 16.2536 | 16.2539 | 97776.0 |
| 2012-01-31 08:00:00 | AAPL | Stock | 16.2521 | 16.2768 | 16.2521 | 16.2714 | 253008.0 |
| 2012-01-31 08:05:00 | AAPL | Stock | 16.2725 | 16.275 | 16.2696 | 16.2725 | 116396.0 |
| 2012-01-31 08:10:00 | AAPL | Stock | 16.275 | 16.2771 | 16.2718 | 16.2718 | 75460.0 |
| 2012-01-31 08:15:00 | AAPL | Stock | 16.2696 | 16.2704 | 16.2629 | 16.2675 | 92204.0 |
| 2012-01-31 08:20:00 | AAPL | Stock | 16.2679 | 16.2707 | 16.2643 | 16.2643 | 100380.0 |
| 2012-01-31 08:25:00 | AAPL | Stock | 16.2661 | 16.2743 | 16.2607 | 16.2714 | 246512.0 |
| 2012-01-31 08:30:00 | AAPL | Stock | 16.2729 | 16.2739 | 16.2643 | 16.2682 | 110880.0 |
| 2012-01-31 08:35:00 | AAPL | Stock | 16.2682 | 16.2736 | 16.2625 | 16.2661 | 78372.0 |
| 2012-01-31 08:40:00 | AAPL | Stock | 16.2679 | 16.2746 | 16.2661 | 16.2732 | 163128.0 |
| 2012-01-31 08:45:00 | AAPL | Stock | 16.2679 | 16.2729 | 16.2679 | 16.2707 | 146384.0 |
| 2012-01-31 08:50:00 | AAPL | Stock | 16.2714 | 16.2732 | 16.2589 | 16.2607 | 150220.0 |
| 2012-01-31 08:55:00 | AAPL | Stock | 16.2607 | 16.2675 | 16.2607 | 16.2625 | 92904.0 |
| 2012-01-31 09:00:00 | AAPL | Stock | 16.2643 | 16.2643 | 16.2521 | 16.2543 | 214620.0 |
| 2012-01-31 09:05:00 | AAPL | Stock | 16.2564 | 16.2589 | 16.2539 | 16.2539 | 184380.0 |
| 2012-01-31 09:10:00 | AAPL | Stock | 16.2539 | 16.2643 | 16.2539 | 16.2625 | 250628.0 |
| 2012-01-31 09:15:00 | AAPL | Stock | 16.2589 | 16.2711 | 16.2589 | 16.2711 | 240072.0 |
| 2012-01-31 09:20:00 | AAPL | Stock | 16.2711 | 16.2786 | 16.2686 | 16.2714 | 220416.0 |
| 2012-01-31 09:25:00 | AAPL | Stock | 16.2714 | 16.2811 | 16.2679 | 16.2746 | 752164.0 |
| 2012-01-31 09:30:00 | AAPL | Stock | 16.2739 | 16.3018 | 16.2561 | 16.2986 | 26544700.0 |
| 2012-01-31 09:35:00 | AAPL | Stock | 16.2968 | 16.3412 | 16.2968 | 16.3304 | 16640316.0 |
| 2012-01-31 09:40:00 | AAPL | Stock | 16.3346 | 16.3371 | 16.2857 | 16.3125 | 11130112.0 |
| 2012-01-31 09:45:00 | AAPL | Stock | 16.3124 | 16.3379 | 16.2996 | 16.3266 | 9452380.0 |
> showing 50 of 327,112 rows — these rows as CSV