PREVIEW / stock_5min / 2012-05-11
file: by_date/stock_5min/2012/2012-05-11.parquet size: 4.8 MB rows: 324,483 symbols: 3,518
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-05-11 04:35:00 | AAPL | Stock | 20.3093 | 20.3093 | 20.3 | 20.3 | 11200.0 |
| 2012-05-11 04:40:00 | AAPL | Stock | 20.3093 | 20.3093 | 20.3093 | 20.3093 | 5600.0 |
| 2012-05-11 05:15:00 | AAPL | Stock | 20.3093 | 20.3093 | 20.3093 | 20.3093 | 5600.0 |
| 2012-05-11 06:05:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 8400.0 |
| 2012-05-11 06:10:00 | AAPL | Stock | 20.3036 | 20.3093 | 20.3036 | 20.3093 | 5600.0 |
| 2012-05-11 06:15:00 | AAPL | Stock | 20.3093 | 20.3214 | 20.3093 | 20.3214 | 51100.0 |
| 2012-05-11 06:20:00 | AAPL | Stock | 20.3143 | 20.3304 | 20.3143 | 20.3304 | 18480.0 |
| 2012-05-11 06:35:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 6160.0 |
| 2012-05-11 06:50:00 | AAPL | Stock | 20.2739 | 20.2739 | 20.2407 | 20.2407 | 16800.0 |
| 2012-05-11 06:55:00 | AAPL | Stock | 20.2571 | 20.2721 | 20.2571 | 20.2721 | 22400.0 |
| 2012-05-11 07:00:00 | AAPL | Stock | 20.2786 | 20.2786 | 20.2786 | 20.2786 | 5600.0 |
| 2012-05-11 07:10:00 | AAPL | Stock | 20.2782 | 20.2782 | 20.2782 | 20.2782 | 2800.0 |
| 2012-05-11 07:15:00 | AAPL | Stock | 20.2596 | 20.26 | 20.25 | 20.25 | 65156.0 |
| 2012-05-11 07:20:00 | AAPL | Stock | 20.25 | 20.25 | 20.2321 | 20.2321 | 103740.0 |
| 2012-05-11 07:25:00 | AAPL | Stock | 20.25 | 20.25 | 20.2339 | 20.2429 | 127652.0 |
| 2012-05-11 07:30:00 | AAPL | Stock | 20.2464 | 20.2679 | 20.2411 | 20.2679 | 187488.0 |
| 2012-05-11 07:35:00 | AAPL | Stock | 20.2621 | 20.2954 | 20.2539 | 20.2854 | 147140.0 |
| 2012-05-11 07:40:00 | AAPL | Stock | 20.2614 | 20.2782 | 20.2554 | 20.2621 | 85540.0 |
| 2012-05-11 07:45:00 | AAPL | Stock | 20.2636 | 20.2754 | 20.2529 | 20.2575 | 201040.0 |
| 2012-05-11 07:50:00 | AAPL | Stock | 20.2575 | 20.2679 | 20.25 | 20.2679 | 248080.0 |
| 2012-05-11 07:55:00 | AAPL | Stock | 20.2625 | 20.2786 | 20.2625 | 20.2786 | 66052.0 |
| 2012-05-11 08:00:00 | AAPL | Stock | 20.2786 | 20.2864 | 20.2489 | 20.2757 | 288820.0 |
| 2012-05-11 08:05:00 | AAPL | Stock | 20.2768 | 20.2857 | 20.2679 | 20.2679 | 81368.0 |
| 2012-05-11 08:10:00 | AAPL | Stock | 20.2643 | 20.2679 | 20.2329 | 20.2496 | 401156.0 |
| 2012-05-11 08:15:00 | AAPL | Stock | 20.2493 | 20.2496 | 20.2361 | 20.2361 | 95900.0 |
| 2012-05-11 08:20:00 | AAPL | Stock | 20.2393 | 20.2464 | 20.225 | 20.2275 | 122780.0 |
| 2012-05-11 08:25:00 | AAPL | Stock | 20.2286 | 20.2286 | 20.1964 | 20.2143 | 265860.0 |
| 2012-05-11 08:30:00 | AAPL | Stock | 20.2143 | 20.2146 | 20.1286 | 20.1286 | 562156.0 |
| 2012-05-11 08:35:00 | AAPL | Stock | 20.1386 | 20.1761 | 20.125 | 20.1696 | 558404.0 |
| 2012-05-11 08:40:00 | AAPL | Stock | 20.1743 | 20.1768 | 20.1 | 20.1007 | 792064.0 |
| 2012-05-11 08:45:00 | AAPL | Stock | 20.1007 | 20.1064 | 20.0536 | 20.0796 | 1885800.0 |
| 2012-05-11 08:50:00 | AAPL | Stock | 20.0754 | 20.1357 | 20.075 | 20.1071 | 1701896.0 |
| 2012-05-11 08:55:00 | AAPL | Stock | 20.1157 | 20.145 | 20.1079 | 20.1211 | 1515752.0 |
| 2012-05-11 09:00:00 | AAPL | Stock | 20.1239 | 20.1239 | 20.0871 | 20.0939 | 741104.0 |
| 2012-05-11 09:05:00 | AAPL | Stock | 20.1071 | 20.1089 | 20.0804 | 20.1071 | 566664.0 |
| 2012-05-11 09:10:00 | AAPL | Stock | 20.1054 | 20.1125 | 20.1004 | 20.1071 | 1377432.0 |
| 2012-05-11 09:15:00 | AAPL | Stock | 20.1071 | 20.1189 | 20.1011 | 20.1064 | 325108.0 |
| 2012-05-11 09:20:00 | AAPL | Stock | 20.1071 | 20.1225 | 20.1011 | 20.1146 | 609224.0 |
| 2012-05-11 09:25:00 | AAPL | Stock | 20.1161 | 20.1825 | 20.1011 | 20.1825 | 1784916.0 |
| 2012-05-11 09:30:00 | AAPL | Stock | 20.1825 | 20.2571 | 20.1554 | 20.2204 | 20168764.0 |
| 2012-05-11 09:35:00 | AAPL | Stock | 20.2257 | 20.2657 | 20.1825 | 20.2154 | 11933656.0 |
| 2012-05-11 09:40:00 | AAPL | Stock | 20.2157 | 20.2821 | 20.2114 | 20.2525 | 8859424.0 |
| 2012-05-11 09:45:00 | AAPL | Stock | 20.2525 | 20.2896 | 20.2286 | 20.2618 | 8466332.0 |
| 2012-05-11 09:50:00 | AAPL | Stock | 20.2661 | 20.275 | 20.2379 | 20.275 | 6837880.0 |
| 2012-05-11 09:55:00 | AAPL | Stock | 20.2736 | 20.3186 | 20.2404 | 20.2436 | 11168164.0 |
| 2012-05-11 10:00:00 | AAPL | Stock | 20.2479 | 20.3164 | 20.2407 | 20.2868 | 6837320.0 |
| 2012-05-11 10:05:00 | AAPL | Stock | 20.2886 | 20.3014 | 20.2697 | 20.2854 | 3491068.0 |
| 2012-05-11 10:10:00 | AAPL | Stock | 20.2854 | 20.3136 | 20.2832 | 20.2975 | 5699092.0 |
| 2012-05-11 10:15:00 | AAPL | Stock | 20.2993 | 20.4029 | 20.2904 | 20.3639 | 14560784.0 |
| 2012-05-11 10:20:00 | AAPL | Stock | 20.3654 | 20.4 | 20.3654 | 20.3889 | 7800072.0 |
> showing 50 of 324,483 rows — these rows as CSV