PREVIEW / stock_5min / 2011-02-04
file: by_date/stock_5min/2011/2011-02-04.parquet size: 4.8 MB rows: 327,458 symbols: 3,521
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-02-04 05:10:00 | AAPL | Stock | 12.2979 | 12.2979 | 12.2979 | 12.2979 | 2800.0 |
| 2011-02-04 05:25:00 | AAPL | Stock | 12.2979 | 12.2979 | 12.2979 | 12.2979 | 3220.0 |
| 2011-02-04 05:35:00 | AAPL | Stock | 12.2979 | 12.2979 | 12.2979 | 12.2979 | 3220.0 |
| 2011-02-04 06:00:00 | AAPL | Stock | 12.2946 | 12.2946 | 12.2946 | 12.2946 | 14000.0 |
| 2011-02-04 07:00:00 | AAPL | Stock | 12.2911 | 12.2911 | 12.2857 | 12.2857 | 5600.0 |
| 2011-02-04 07:15:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 22400.0 |
| 2011-02-04 07:20:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 16800.0 |
| 2011-02-04 07:25:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2761 | 12.2786 | 42000.0 |
| 2011-02-04 07:30:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 33600.0 |
| 2011-02-04 07:35:00 | AAPL | Stock | 12.2875 | 12.2875 | 12.2857 | 12.2857 | 17500.0 |
| 2011-02-04 07:40:00 | AAPL | Stock | 12.2893 | 12.3071 | 12.2893 | 12.3071 | 35420.0 |
| 2011-02-04 07:45:00 | AAPL | Stock | 12.3107 | 12.3282 | 12.3071 | 12.3282 | 111524.0 |
| 2011-02-04 07:50:00 | AAPL | Stock | 12.3179 | 12.3179 | 12.3179 | 12.3179 | 2800.0 |
| 2011-02-04 07:55:00 | AAPL | Stock | 12.3039 | 12.3164 | 12.3039 | 12.3164 | 5600.0 |
| 2011-02-04 08:00:00 | AAPL | Stock | 12.315 | 12.315 | 12.2786 | 12.2857 | 435848.0 |
| 2011-02-04 08:05:00 | AAPL | Stock | 12.2857 | 12.2914 | 12.2782 | 12.2854 | 92400.0 |
| 2011-02-04 08:10:00 | AAPL | Stock | 12.2821 | 12.2893 | 12.2804 | 12.2893 | 99820.0 |
| 2011-02-04 08:15:00 | AAPL | Stock | 12.2864 | 12.3179 | 12.2846 | 12.3143 | 533120.0 |
| 2011-02-04 08:20:00 | AAPL | Stock | 12.3114 | 12.3143 | 12.2954 | 12.2971 | 122500.0 |
| 2011-02-04 08:25:00 | AAPL | Stock | 12.3004 | 12.3025 | 12.2946 | 12.3025 | 48440.0 |
| 2011-02-04 08:30:00 | AAPL | Stock | 12.3 | 12.3139 | 12.26 | 12.2964 | 1302644.0 |
| 2011-02-04 08:35:00 | AAPL | Stock | 12.2964 | 12.2993 | 12.2811 | 12.2811 | 459956.0 |
| 2011-02-04 08:40:00 | AAPL | Stock | 12.2804 | 12.3 | 12.2789 | 12.2946 | 219520.0 |
| 2011-02-04 08:45:00 | AAPL | Stock | 12.2946 | 12.2946 | 12.2893 | 12.2893 | 86800.0 |
| 2011-02-04 08:50:00 | AAPL | Stock | 12.2911 | 12.3 | 12.29 | 12.3 | 77672.0 |
| 2011-02-04 08:55:00 | AAPL | Stock | 12.2979 | 12.2979 | 12.2861 | 12.2875 | 89320.0 |
| 2011-02-04 09:00:00 | AAPL | Stock | 12.2911 | 12.2911 | 12.2861 | 12.2893 | 88900.0 |
| 2011-02-04 09:05:00 | AAPL | Stock | 12.2893 | 12.2893 | 12.2821 | 12.2857 | 218260.0 |
| 2011-02-04 09:10:00 | AAPL | Stock | 12.2839 | 12.2964 | 12.2839 | 12.2964 | 243292.0 |
| 2011-02-04 09:15:00 | AAPL | Stock | 12.2946 | 12.2946 | 12.2875 | 12.2929 | 180600.0 |
| 2011-02-04 09:20:00 | AAPL | Stock | 12.2864 | 12.2946 | 12.2857 | 12.2929 | 125440.0 |
| 2011-02-04 09:25:00 | AAPL | Stock | 12.2914 | 12.295 | 12.2664 | 12.2718 | 340032.0 |
| 2011-02-04 09:30:00 | AAPL | Stock | 12.2732 | 12.3536 | 12.2682 | 12.3496 | 21713776.0 |
| 2011-02-04 09:35:00 | AAPL | Stock | 12.3493 | 12.3496 | 12.3047 | 12.3049 | 12656224.0 |
| 2011-02-04 09:40:00 | AAPL | Stock | 12.3068 | 12.3204 | 12.2861 | 12.3096 | 8553188.0 |
| 2011-02-04 09:45:00 | AAPL | Stock | 12.3114 | 12.3157 | 12.2975 | 12.31 | 7001176.0 |
| 2011-02-04 09:50:00 | AAPL | Stock | 12.3075 | 12.3404 | 12.307 | 12.3393 | 9296952.0 |
| 2011-02-04 09:55:00 | AAPL | Stock | 12.3393 | 12.3571 | 12.3293 | 12.3571 | 9783088.0 |
| 2011-02-04 10:00:00 | AAPL | Stock | 12.3554 | 12.3714 | 12.3543 | 12.3714 | 11936876.0 |
| 2011-02-04 10:05:00 | AAPL | Stock | 12.3679 | 12.3714 | 12.3486 | 12.3564 | 6190520.0 |
| 2011-02-04 10:10:00 | AAPL | Stock | 12.3564 | 12.3582 | 12.3304 | 12.3393 | 5057388.0 |
| 2011-02-04 10:15:00 | AAPL | Stock | 12.339 | 12.3507 | 12.3321 | 12.3507 | 5262404.0 |
| 2011-02-04 10:20:00 | AAPL | Stock | 12.35 | 12.3643 | 12.3486 | 12.3632 | 5151860.0 |
| 2011-02-04 10:25:00 | AAPL | Stock | 12.3629 | 12.3679 | 12.3554 | 12.3614 | 5903772.0 |
| 2011-02-04 10:30:00 | AAPL | Stock | 12.3607 | 12.3654 | 12.3507 | 12.3518 | 3734920.0 |
| 2011-02-04 10:35:00 | AAPL | Stock | 12.3514 | 12.3536 | 12.3425 | 12.3484 | 3741836.0 |
| 2011-02-04 10:40:00 | AAPL | Stock | 12.3484 | 12.3511 | 12.3286 | 12.3379 | 4596480.0 |
| 2011-02-04 10:45:00 | AAPL | Stock | 12.3382 | 12.3446 | 12.325 | 12.3393 | 5466412.0 |
| 2011-02-04 10:50:00 | AAPL | Stock | 12.3418 | 12.3429 | 12.305 | 12.3057 | 7422100.0 |
| 2011-02-04 10:55:00 | AAPL | Stock | 12.3071 | 12.3318 | 12.3043 | 12.3172 | 5426680.0 |
> showing 50 of 327,458 rows — these rows as CSV