PREVIEW / stock_5min / 2013-04-15
file: by_date/stock_5min/2013/2013-04-15.parquet size: 5.2 MB rows: 343,116 symbols: 3,500
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 |
|---|---|---|---|---|---|---|---|
| 2013-04-15 05:25:00 | AAPL | Stock | 15.2889 | 15.2889 | 15.2889 | 15.2889 | 5600.0 |
| 2013-04-15 06:10:00 | AAPL | Stock | 15.25 | 15.25 | 15.2496 | 15.2496 | 5600.0 |
| 2013-04-15 06:15:00 | AAPL | Stock | 15.2486 | 15.2486 | 15.2486 | 15.2486 | 2800.0 |
| 2013-04-15 06:20:00 | AAPL | Stock | 15.2486 | 15.2486 | 15.2486 | 15.2486 | 2800.0 |
| 2013-04-15 06:30:00 | AAPL | Stock | 15.2493 | 15.2496 | 15.2493 | 15.2496 | 5600.0 |
| 2013-04-15 06:35:00 | AAPL | Stock | 15.2546 | 15.2546 | 15.2546 | 15.2546 | 3808.0 |
| 2013-04-15 07:05:00 | AAPL | Stock | 15.2507 | 15.2507 | 15.2507 | 15.2507 | 5600.0 |
| 2013-04-15 07:10:00 | AAPL | Stock | 15.2514 | 15.2639 | 15.2386 | 15.2571 | 16800.0 |
| 2013-04-15 07:15:00 | AAPL | Stock | 15.2504 | 15.2571 | 15.2493 | 15.2571 | 35252.0 |
| 2013-04-15 07:20:00 | AAPL | Stock | 15.2418 | 15.2418 | 15.2321 | 15.2386 | 35420.0 |
| 2013-04-15 07:30:00 | AAPL | Stock | 15.2371 | 15.2482 | 15.2371 | 15.2482 | 22960.0 |
| 2013-04-15 07:40:00 | AAPL | Stock | 15.25 | 15.25 | 15.2368 | 15.2425 | 23016.0 |
| 2013-04-15 07:45:00 | AAPL | Stock | 15.2425 | 15.2429 | 15.2425 | 15.2425 | 14000.0 |
| 2013-04-15 07:50:00 | AAPL | Stock | 15.2429 | 15.2429 | 15.2429 | 15.2429 | 47600.0 |
| 2013-04-15 07:55:00 | AAPL | Stock | 15.2482 | 15.25 | 15.2482 | 15.25 | 50400.0 |
| 2013-04-15 08:00:00 | AAPL | Stock | 15.2629 | 15.3214 | 15.2386 | 15.2721 | 137564.0 |
| 2013-04-15 08:05:00 | AAPL | Stock | 15.2729 | 15.2804 | 15.2729 | 15.2789 | 37800.0 |
| 2013-04-15 08:10:00 | AAPL | Stock | 15.2793 | 15.2821 | 15.2757 | 15.2757 | 37492.0 |
| 2013-04-15 08:15:00 | AAPL | Stock | 15.2679 | 15.2696 | 15.2482 | 15.2536 | 138964.0 |
| 2013-04-15 08:20:00 | AAPL | Stock | 15.2536 | 15.2646 | 15.2536 | 15.2646 | 5600.0 |
| 2013-04-15 08:25:00 | AAPL | Stock | 15.2539 | 15.2539 | 15.2507 | 15.2518 | 14000.0 |
| 2013-04-15 08:30:00 | AAPL | Stock | 15.2729 | 15.2729 | 15.2604 | 15.2643 | 27944.0 |
| 2013-04-15 08:35:00 | AAPL | Stock | 15.2554 | 15.2554 | 15.2554 | 15.2554 | 4340.0 |
| 2013-04-15 08:40:00 | AAPL | Stock | 15.2607 | 15.275 | 15.2607 | 15.275 | 57400.0 |
| 2013-04-15 08:45:00 | AAPL | Stock | 15.2679 | 15.2693 | 15.2664 | 15.2664 | 33264.0 |
| 2013-04-15 08:50:00 | AAPL | Stock | 15.2593 | 15.2593 | 15.2536 | 15.2589 | 78512.0 |
| 2013-04-15 08:55:00 | AAPL | Stock | 15.2575 | 15.2589 | 15.2575 | 15.2589 | 7840.0 |
| 2013-04-15 09:00:00 | AAPL | Stock | 15.2536 | 15.2571 | 15.2486 | 15.2486 | 62776.0 |
| 2013-04-15 09:05:00 | AAPL | Stock | 15.2504 | 15.2518 | 15.2386 | 15.2386 | 60144.0 |
| 2013-04-15 09:10:00 | AAPL | Stock | 15.2346 | 15.2425 | 15.2257 | 15.2425 | 95480.0 |
| 2013-04-15 09:15:00 | AAPL | Stock | 15.2554 | 15.2554 | 15.25 | 15.25 | 19068.0 |
| 2013-04-15 09:20:00 | AAPL | Stock | 15.2436 | 15.255 | 15.2436 | 15.2543 | 26628.0 |
| 2013-04-15 09:25:00 | AAPL | Stock | 15.2543 | 15.2543 | 15.2411 | 15.2421 | 68208.0 |
| 2013-04-15 09:30:00 | AAPL | Stock | 15.2425 | 15.25 | 15.1964 | 15.23 | 10939096.0 |
| 2013-04-15 09:35:00 | AAPL | Stock | 15.23 | 15.2584 | 15.2193 | 15.2411 | 6039740.0 |
| 2013-04-15 09:40:00 | AAPL | Stock | 15.243 | 15.2818 | 15.2354 | 15.2771 | 5847212.0 |
| 2013-04-15 09:45:00 | AAPL | Stock | 15.2771 | 15.2771 | 15.2089 | 15.2182 | 8658860.0 |
| 2013-04-15 09:50:00 | AAPL | Stock | 15.2164 | 15.2304 | 15.1968 | 15.2218 | 5697860.0 |
| 2013-04-15 09:55:00 | AAPL | Stock | 15.2189 | 15.2429 | 15.2182 | 15.2375 | 3188920.0 |
| 2013-04-15 10:00:00 | AAPL | Stock | 15.2361 | 15.2407 | 15.1879 | 15.1968 | 5158664.0 |
| 2013-04-15 10:05:00 | AAPL | Stock | 15.1968 | 15.2046 | 15.1486 | 15.1929 | 8441300.0 |
| 2013-04-15 10:10:00 | AAPL | Stock | 15.1918 | 15.1929 | 15.1657 | 15.192 | 4399892.0 |
| 2013-04-15 10:15:00 | AAPL | Stock | 15.1929 | 15.1961 | 15.1743 | 15.1764 | 3745168.0 |
| 2013-04-15 10:20:00 | AAPL | Stock | 15.1764 | 15.1936 | 15.1643 | 15.1671 | 2641996.0 |
| 2013-04-15 10:25:00 | AAPL | Stock | 15.1731 | 15.1731 | 15.1507 | 15.1641 | 4019820.0 |
| 2013-04-15 10:30:00 | AAPL | Stock | 15.1625 | 15.1634 | 15.1361 | 15.1496 | 5327252.0 |
| 2013-04-15 10:35:00 | AAPL | Stock | 15.1482 | 15.1564 | 15.1329 | 15.1489 | 4828124.0 |
| 2013-04-15 10:40:00 | AAPL | Stock | 15.1489 | 15.1729 | 15.1321 | 15.1707 | 3453268.0 |
| 2013-04-15 10:45:00 | AAPL | Stock | 15.1725 | 15.19 | 15.1571 | 15.1751 | 4771312.0 |
| 2013-04-15 10:50:00 | AAPL | Stock | 15.1786 | 15.2029 | 15.1774 | 15.1909 | 3150616.0 |
> showing 50 of 343,116 rows — these rows as CSV