PREVIEW / stock_5min / 2012-03-15
file: by_date/stock_5min/2012/2012-03-15.parquet size: 4.9 MB rows: 330,489 symbols: 3,515
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-03-15 04:00:00 | AAPL | Stock | 21.3036 | 21.3571 | 21.2496 | 21.3393 | 86800.0 |
| 2012-03-15 04:05:00 | AAPL | Stock | 21.3393 | 21.3393 | 21.2857 | 21.2939 | 33460.0 |
| 2012-03-15 04:10:00 | AAPL | Stock | 21.2904 | 21.2929 | 21.2868 | 21.2893 | 50400.0 |
| 2012-03-15 04:15:00 | AAPL | Stock | 21.2714 | 21.2857 | 21.2607 | 21.2679 | 52136.0 |
| 2012-03-15 04:20:00 | AAPL | Stock | 21.2818 | 21.2818 | 21.2679 | 21.2679 | 36680.0 |
| 2012-03-15 04:25:00 | AAPL | Stock | 21.2589 | 21.2589 | 21.2589 | 21.2589 | 2800.0 |
| 2012-03-15 04:30:00 | AAPL | Stock | 21.2625 | 21.2714 | 21.1857 | 21.2071 | 81200.0 |
| 2012-03-15 04:35:00 | AAPL | Stock | 21.2346 | 21.2346 | 21.2346 | 21.2346 | 5600.0 |
| 2012-03-15 04:40:00 | AAPL | Stock | 21.2839 | 21.2839 | 21.2839 | 21.2839 | 5600.0 |
| 2012-03-15 04:45:00 | AAPL | Stock | 21.2804 | 21.2836 | 21.2804 | 21.2832 | 18648.0 |
| 2012-03-15 04:50:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 5600.0 |
| 2012-03-15 04:55:00 | AAPL | Stock | 21.2861 | 21.2861 | 21.2857 | 21.2857 | 11200.0 |
| 2012-03-15 05:00:00 | AAPL | Stock | 21.2875 | 21.2875 | 21.2875 | 21.2875 | 7840.0 |
| 2012-03-15 05:10:00 | AAPL | Stock | 21.3107 | 21.3107 | 21.3 | 21.3 | 5600.0 |
| 2012-03-15 05:15:00 | AAPL | Stock | 21.3168 | 21.3168 | 21.3168 | 21.3168 | 2800.0 |
| 2012-03-15 05:25:00 | AAPL | Stock | 21.3 | 21.3 | 21.295 | 21.3 | 66640.0 |
| 2012-03-15 05:30:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 25200.0 |
| 2012-03-15 05:35:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 32340.0 |
| 2012-03-15 05:40:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 22680.0 |
| 2012-03-15 05:45:00 | AAPL | Stock | 21.2904 | 21.3 | 21.2904 | 21.3 | 11200.0 |
| 2012-03-15 05:50:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 5880.0 |
| 2012-03-15 06:00:00 | AAPL | Stock | 21.2893 | 21.2893 | 21.2893 | 21.2893 | 8400.0 |
| 2012-03-15 06:05:00 | AAPL | Stock | 21.2893 | 21.2893 | 21.2857 | 21.2857 | 28000.0 |
| 2012-03-15 06:15:00 | AAPL | Stock | 21.2786 | 21.2786 | 21.2786 | 21.2786 | 2800.0 |
| 2012-03-15 06:25:00 | AAPL | Stock | 21.2679 | 21.2679 | 21.2679 | 21.2679 | 5600.0 |
| 2012-03-15 06:35:00 | AAPL | Stock | 21.2696 | 21.2696 | 21.2696 | 21.2696 | 11200.0 |
| 2012-03-15 06:45:00 | AAPL | Stock | 21.2893 | 21.2964 | 21.2893 | 21.2964 | 12992.0 |
| 2012-03-15 06:50:00 | AAPL | Stock | 21.29 | 21.29 | 21.29 | 21.29 | 5600.0 |
| 2012-03-15 06:55:00 | AAPL | Stock | 21.2857 | 21.2964 | 21.2786 | 21.2929 | 48440.0 |
| 2012-03-15 07:00:00 | AAPL | Stock | 21.2929 | 21.3086 | 21.2786 | 21.3036 | 356944.0 |
| 2012-03-15 07:05:00 | AAPL | Stock | 21.3 | 21.3493 | 21.2964 | 21.3489 | 231560.0 |
| 2012-03-15 07:10:00 | AAPL | Stock | 21.3396 | 21.3396 | 21.2893 | 21.3136 | 312816.0 |
| 2012-03-15 07:15:00 | AAPL | Stock | 21.3036 | 21.3121 | 21.2968 | 21.2968 | 53256.0 |
| 2012-03-15 07:20:00 | AAPL | Stock | 21.2964 | 21.3107 | 21.2929 | 21.3107 | 191520.0 |
| 2012-03-15 07:25:00 | AAPL | Stock | 21.3043 | 21.3354 | 21.3039 | 21.3318 | 258496.0 |
| 2012-03-15 07:30:00 | AAPL | Stock | 21.3214 | 21.3304 | 21.3111 | 21.3296 | 131600.0 |
| 2012-03-15 07:35:00 | AAPL | Stock | 21.3304 | 21.3304 | 21.3129 | 21.3304 | 148484.0 |
| 2012-03-15 07:40:00 | AAPL | Stock | 21.3304 | 21.3571 | 21.3236 | 21.3289 | 360584.0 |
| 2012-03-15 07:45:00 | AAPL | Stock | 21.3336 | 21.3393 | 21.3036 | 21.3143 | 254800.0 |
| 2012-03-15 07:50:00 | AAPL | Stock | 21.3107 | 21.3179 | 21.2807 | 21.2857 | 408548.0 |
| 2012-03-15 07:55:00 | AAPL | Stock | 21.2857 | 21.3132 | 21.2714 | 21.2825 | 273980.0 |
| 2012-03-15 08:00:00 | AAPL | Stock | 21.2768 | 21.3536 | 21.2732 | 21.345 | 1954316.0 |
| 2012-03-15 08:05:00 | AAPL | Stock | 21.3493 | 21.375 | 21.3429 | 21.3468 | 1805384.0 |
| 2012-03-15 08:10:00 | AAPL | Stock | 21.3457 | 21.3625 | 21.3418 | 21.3482 | 785456.0 |
| 2012-03-15 08:15:00 | AAPL | Stock | 21.3436 | 21.3521 | 21.3339 | 21.3511 | 887040.0 |
| 2012-03-15 08:20:00 | AAPL | Stock | 21.3464 | 21.3793 | 21.3429 | 21.3707 | 652820.0 |
| 2012-03-15 08:25:00 | AAPL | Stock | 21.3704 | 21.3882 | 21.3611 | 21.3832 | 1034376.0 |
| 2012-03-15 08:30:00 | AAPL | Stock | 21.3846 | 21.4079 | 21.3793 | 21.4054 | 1849400.0 |
| 2012-03-15 08:35:00 | AAPL | Stock | 21.4011 | 21.4011 | 21.36 | 21.3818 | 1571220.0 |
| 2012-03-15 08:40:00 | AAPL | Stock | 21.3811 | 21.3893 | 21.3621 | 21.3736 | 970564.0 |
> showing 50 of 330,489 rows — these rows as CSV