PREVIEW / stock_5min / 2011-11-03
file: by_date/stock_5min/2011/2011-11-03.parquet size: 4.9 MB rows: 331,131 symbols: 3,509
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-11-03 04:00:00 | AAPL | Stock | 13.9936 | 13.9936 | 13.9936 | 13.9936 | 2800.0 |
| 2011-11-03 04:05:00 | AAPL | Stock | 14.0429 | 14.0429 | 14.0429 | 14.0429 | 5600.0 |
| 2011-11-03 04:10:00 | AAPL | Stock | 14.0607 | 14.0607 | 14.0571 | 14.0571 | 11200.0 |
| 2011-11-03 04:15:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 140000.0 |
| 2011-11-03 04:20:00 | AAPL | Stock | 14.0536 | 14.0536 | 14.0357 | 14.0357 | 106400.0 |
| 2011-11-03 04:25:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 2800.0 |
| 2011-11-03 04:30:00 | AAPL | Stock | 14.0536 | 14.0714 | 14.0536 | 14.0714 | 14000.0 |
| 2011-11-03 04:35:00 | AAPL | Stock | 14.0679 | 14.0711 | 14.0679 | 14.0711 | 11200.0 |
| 2011-11-03 04:40:00 | AAPL | Stock | 14.0714 | 14.0714 | 14.0679 | 14.0679 | 14000.0 |
| 2011-11-03 04:45:00 | AAPL | Stock | 14.0714 | 14.0714 | 14.0714 | 14.0714 | 4200.0 |
| 2011-11-03 04:50:00 | AAPL | Stock | 14.0704 | 14.0714 | 14.0704 | 14.0714 | 47600.0 |
| 2011-11-03 05:00:00 | AAPL | Stock | 14.0857 | 14.0893 | 14.0857 | 14.0893 | 19600.0 |
| 2011-11-03 05:05:00 | AAPL | Stock | 14.0964 | 14.1071 | 14.0964 | 14.1071 | 47040.0 |
| 2011-11-03 05:10:00 | AAPL | Stock | 14.1214 | 14.1214 | 14.1214 | 14.1214 | 2800.0 |
| 2011-11-03 05:20:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1296 | 14.1414 | 15400.0 |
| 2011-11-03 05:30:00 | AAPL | Stock | 14.1075 | 14.1075 | 14.1075 | 14.1075 | 5600.0 |
| 2011-11-03 05:40:00 | AAPL | Stock | 14.1086 | 14.1086 | 14.1036 | 14.1036 | 25200.0 |
| 2011-11-03 05:50:00 | AAPL | Stock | 14.1346 | 14.1607 | 14.1346 | 14.1607 | 64400.0 |
| 2011-11-03 05:55:00 | AAPL | Stock | 14.17 | 14.17 | 14.17 | 14.17 | 2800.0 |
| 2011-11-03 06:00:00 | AAPL | Stock | 14.1768 | 14.1786 | 14.1768 | 14.1786 | 11200.0 |
| 2011-11-03 06:05:00 | AAPL | Stock | 14.1929 | 14.2143 | 14.1929 | 14.2143 | 11200.0 |
| 2011-11-03 06:15:00 | AAPL | Stock | 14.2075 | 14.2075 | 14.2075 | 14.2075 | 2800.0 |
| 2011-11-03 06:20:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 2800.0 |
| 2011-11-03 06:35:00 | AAPL | Stock | 14.2143 | 14.2143 | 14.2143 | 14.2143 | 8400.0 |
| 2011-11-03 06:45:00 | AAPL | Stock | 14.2139 | 14.2139 | 14.2139 | 14.2139 | 2800.0 |
| 2011-11-03 07:00:00 | AAPL | Stock | 14.2139 | 14.2146 | 14.2139 | 14.2143 | 36400.0 |
| 2011-11-03 07:05:00 | AAPL | Stock | 14.2011 | 14.2057 | 14.1993 | 14.1993 | 58800.0 |
| 2011-11-03 07:10:00 | AAPL | Stock | 14.195 | 14.195 | 14.18 | 14.18 | 5600.0 |
| 2011-11-03 07:15:00 | AAPL | Stock | 14.1796 | 14.1796 | 14.1796 | 14.1796 | 2800.0 |
| 2011-11-03 07:20:00 | AAPL | Stock | 14.1893 | 14.2218 | 14.1893 | 14.2214 | 65240.0 |
| 2011-11-03 07:25:00 | AAPL | Stock | 14.2339 | 14.2339 | 14.2321 | 14.2321 | 20160.0 |
| 2011-11-03 07:30:00 | AAPL | Stock | 14.2289 | 14.2304 | 14.2289 | 14.2304 | 15260.0 |
| 2011-11-03 07:35:00 | AAPL | Stock | 14.2304 | 14.2304 | 14.2143 | 14.2143 | 60284.0 |
| 2011-11-03 07:40:00 | AAPL | Stock | 14.2282 | 14.25 | 14.2282 | 14.2429 | 74144.0 |
| 2011-11-03 07:45:00 | AAPL | Stock | 14.2496 | 14.2496 | 14.2286 | 14.2286 | 33600.0 |
| 2011-11-03 07:50:00 | AAPL | Stock | 14.2354 | 14.2389 | 14.2354 | 14.2389 | 35420.0 |
| 2011-11-03 07:55:00 | AAPL | Stock | 14.235 | 14.235 | 14.235 | 14.235 | 2800.0 |
| 2011-11-03 08:00:00 | AAPL | Stock | 14.2268 | 14.2389 | 14.2182 | 14.2389 | 202188.0 |
| 2011-11-03 08:05:00 | AAPL | Stock | 14.2389 | 14.2393 | 14.2357 | 14.2393 | 29400.0 |
| 2011-11-03 08:10:00 | AAPL | Stock | 14.2393 | 14.2625 | 14.2346 | 14.2346 | 589960.0 |
| 2011-11-03 08:15:00 | AAPL | Stock | 14.2525 | 14.2675 | 14.2525 | 14.2607 | 150724.0 |
| 2011-11-03 08:20:00 | AAPL | Stock | 14.2571 | 14.2679 | 14.25 | 14.2671 | 95228.0 |
| 2011-11-03 08:25:00 | AAPL | Stock | 14.2671 | 14.2782 | 14.2671 | 14.2739 | 206220.0 |
| 2011-11-03 08:30:00 | AAPL | Stock | 14.2732 | 14.2814 | 14.2625 | 14.2679 | 183372.0 |
| 2011-11-03 08:35:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2586 | 14.2643 | 209916.0 |
| 2011-11-03 08:40:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.25 | 14.2532 | 117936.0 |
| 2011-11-03 08:45:00 | AAPL | Stock | 14.2611 | 14.3121 | 14.2521 | 14.2857 | 1319248.0 |
| 2011-11-03 08:50:00 | AAPL | Stock | 14.2839 | 14.2893 | 14.2718 | 14.2893 | 258552.0 |
| 2011-11-03 08:55:00 | AAPL | Stock | 14.2911 | 14.3164 | 14.29 | 14.3107 | 282044.0 |
| 2011-11-03 09:00:00 | AAPL | Stock | 14.3111 | 14.3143 | 14.25 | 14.2575 | 551236.0 |
> showing 50 of 331,131 rows — these rows as CSV