PREVIEW / stock_5min / 2011-11-07
file: by_date/stock_5min/2011/2011-11-07.parquet size: 4.8 MB rows: 322,658 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 |
|---|---|---|---|---|---|---|---|
| 2011-11-07 04:05:00 | AAPL | Stock | 14.2146 | 14.2146 | 14.2146 | 14.2146 | 5600.0 |
| 2011-11-07 05:00:00 | AAPL | Stock | 14.1786 | 14.1786 | 14.1786 | 14.1786 | 2800.0 |
| 2011-11-07 05:05:00 | AAPL | Stock | 14.2143 | 14.2143 | 14.2143 | 14.2143 | 2800.0 |
| 2011-11-07 07:10:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 2800.0 |
| 2011-11-07 07:40:00 | AAPL | Stock | 14.2536 | 14.2536 | 14.2536 | 14.2536 | 2800.0 |
| 2011-11-07 07:45:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 14000.0 |
| 2011-11-07 07:50:00 | AAPL | Stock | 14.2696 | 14.2786 | 14.2696 | 14.2786 | 36400.0 |
| 2011-11-07 07:55:00 | AAPL | Stock | 14.2814 | 14.2861 | 14.2696 | 14.2696 | 58800.0 |
| 2011-11-07 08:00:00 | AAPL | Stock | 14.2843 | 14.2871 | 14.2521 | 14.2839 | 100296.0 |
| 2011-11-07 08:05:00 | AAPL | Stock | 14.2818 | 14.2857 | 14.2679 | 14.2679 | 77840.0 |
| 2011-11-07 08:10:00 | AAPL | Stock | 14.2596 | 14.2661 | 14.2571 | 14.2661 | 78400.0 |
| 2011-11-07 08:15:00 | AAPL | Stock | 14.2679 | 14.2682 | 14.26 | 14.26 | 19600.0 |
| 2011-11-07 08:20:00 | AAPL | Stock | 14.2582 | 14.2718 | 14.2582 | 14.2636 | 25200.0 |
| 2011-11-07 08:25:00 | AAPL | Stock | 14.2636 | 14.2636 | 14.2493 | 14.2629 | 134708.0 |
| 2011-11-07 08:30:00 | AAPL | Stock | 14.2521 | 14.2604 | 14.2496 | 14.2507 | 120792.0 |
| 2011-11-07 08:35:00 | AAPL | Stock | 14.2393 | 14.2393 | 14.2332 | 14.235 | 25200.0 |
| 2011-11-07 08:50:00 | AAPL | Stock | 14.2361 | 14.25 | 14.2361 | 14.25 | 16800.0 |
| 2011-11-07 08:55:00 | AAPL | Stock | 14.25 | 14.2536 | 14.25 | 14.2536 | 22400.0 |
| 2011-11-07 09:00:00 | AAPL | Stock | 14.2536 | 14.2571 | 14.2521 | 14.2536 | 95200.0 |
| 2011-11-07 09:05:00 | AAPL | Stock | 14.2543 | 14.2714 | 14.2464 | 14.2679 | 237160.0 |
| 2011-11-07 09:10:00 | AAPL | Stock | 14.2675 | 14.2786 | 14.2675 | 14.275 | 139384.0 |
| 2011-11-07 09:15:00 | AAPL | Stock | 14.2821 | 14.2857 | 14.2764 | 14.2825 | 92876.0 |
| 2011-11-07 09:20:00 | AAPL | Stock | 14.2857 | 14.2861 | 14.2854 | 14.2861 | 19600.0 |
| 2011-11-07 09:25:00 | AAPL | Stock | 14.2857 | 14.3036 | 14.2775 | 14.2839 | 451416.0 |
| 2011-11-07 09:30:00 | AAPL | Stock | 14.2832 | 14.2846 | 14.2054 | 14.2243 | 11405576.0 |
| 2011-11-07 09:35:00 | AAPL | Stock | 14.2246 | 14.2307 | 14.1971 | 14.2054 | 9968420.0 |
| 2011-11-07 09:40:00 | AAPL | Stock | 14.2054 | 14.2314 | 14.1864 | 14.2214 | 10443692.0 |
| 2011-11-07 09:45:00 | AAPL | Stock | 14.2214 | 14.2446 | 14.2143 | 14.2154 | 7248556.0 |
| 2011-11-07 09:50:00 | AAPL | Stock | 14.2189 | 14.2543 | 14.2136 | 14.2539 | 5549208.0 |
| 2011-11-07 09:55:00 | AAPL | Stock | 14.2554 | 14.2671 | 14.2468 | 14.2536 | 5861296.0 |
| 2011-11-07 10:00:00 | AAPL | Stock | 14.2539 | 14.2596 | 14.2379 | 14.2546 | 4527684.0 |
| 2011-11-07 10:05:00 | AAPL | Stock | 14.2546 | 14.2593 | 14.2411 | 14.2582 | 3793720.0 |
| 2011-11-07 10:10:00 | AAPL | Stock | 14.2582 | 14.2711 | 14.2214 | 14.2257 | 5462212.0 |
| 2011-11-07 10:15:00 | AAPL | Stock | 14.2218 | 14.2389 | 14.2143 | 14.2254 | 3600492.0 |
| 2011-11-07 10:20:00 | AAPL | Stock | 14.2239 | 14.2321 | 14.2082 | 14.2304 | 3481968.0 |
| 2011-11-07 10:25:00 | AAPL | Stock | 14.225 | 14.2296 | 14.2143 | 14.2204 | 1671096.0 |
| 2011-11-07 10:30:00 | AAPL | Stock | 14.22 | 14.2321 | 14.2071 | 14.2193 | 3178000.0 |
| 2011-11-07 10:35:00 | AAPL | Stock | 14.2154 | 14.2264 | 14.1964 | 14.1967 | 4060728.0 |
| 2011-11-07 10:40:00 | AAPL | Stock | 14.1971 | 14.2129 | 14.1929 | 14.2089 | 4755660.0 |
| 2011-11-07 10:45:00 | AAPL | Stock | 14.2064 | 14.2175 | 14.1961 | 14.2029 | 2949324.0 |
| 2011-11-07 10:50:00 | AAPL | Stock | 14.2032 | 14.2048 | 14.1811 | 14.1812 | 4683000.0 |
| 2011-11-07 10:55:00 | AAPL | Stock | 14.1818 | 14.1836 | 14.1625 | 14.1704 | 12754420.0 |
| 2011-11-07 11:00:00 | AAPL | Stock | 14.1682 | 14.1786 | 14.1525 | 14.1596 | 7367444.0 |
| 2011-11-07 11:05:00 | AAPL | Stock | 14.1586 | 14.1875 | 14.1575 | 14.1775 | 4622044.0 |
| 2011-11-07 11:10:00 | AAPL | Stock | 14.1754 | 14.1875 | 14.1725 | 14.1804 | 4336220.0 |
| 2011-11-07 11:15:00 | AAPL | Stock | 14.1804 | 14.1875 | 14.1707 | 14.1793 | 3109680.0 |
| 2011-11-07 11:20:00 | AAPL | Stock | 14.1789 | 14.18 | 14.1607 | 14.1684 | 2903292.0 |
| 2011-11-07 11:25:00 | AAPL | Stock | 14.1696 | 14.1757 | 14.1568 | 14.1675 | 1937992.0 |
| 2011-11-07 11:30:00 | AAPL | Stock | 14.1675 | 14.17 | 14.1496 | 14.1567 | 2833964.0 |
| 2011-11-07 11:35:00 | AAPL | Stock | 14.1544 | 14.1661 | 14.1518 | 14.165 | 1885156.0 |
> showing 50 of 322,658 rows — these rows as CSV