PREVIEW / stock_5min / 2013-05-16
file: by_date/stock_5min/2013/2013-05-16.parquet size: 5.1 MB rows: 336,980 symbols: 3,517
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-05-16 04:10:00 | AAPL | Stock | 15.2464 | 15.2464 | 15.2464 | 15.2464 | 2800.0 |
| 2013-05-16 04:20:00 | AAPL | Stock | 15.2464 | 15.2464 | 15.2464 | 15.2464 | 5600.0 |
| 2013-05-16 04:50:00 | AAPL | Stock | 15.2461 | 15.2461 | 15.2343 | 15.2343 | 5600.0 |
| 2013-05-16 04:55:00 | AAPL | Stock | 15.2343 | 15.2343 | 15.2343 | 15.2343 | 2800.0 |
| 2013-05-16 05:15:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 25200.0 |
| 2013-05-16 05:20:00 | AAPL | Stock | 15.2393 | 15.2393 | 15.2393 | 15.2393 | 2800.0 |
| 2013-05-16 05:45:00 | AAPL | Stock | 15.2161 | 15.2161 | 15.2143 | 15.2143 | 5740.0 |
| 2013-05-16 06:10:00 | AAPL | Stock | 15.2246 | 15.2246 | 15.2246 | 15.2246 | 2800.0 |
| 2013-05-16 06:25:00 | AAPL | Stock | 15.2246 | 15.2246 | 15.1839 | 15.1839 | 25200.0 |
| 2013-05-16 06:30:00 | AAPL | Stock | 15.1832 | 15.1832 | 15.1832 | 15.1832 | 19600.0 |
| 2013-05-16 06:50:00 | AAPL | Stock | 15.1925 | 15.1925 | 15.1925 | 15.1925 | 2800.0 |
| 2013-05-16 07:00:00 | AAPL | Stock | 15.1904 | 15.1904 | 15.1904 | 15.1904 | 2800.0 |
| 2013-05-16 07:05:00 | AAPL | Stock | 15.205 | 15.2246 | 15.205 | 15.2179 | 21196.0 |
| 2013-05-16 07:10:00 | AAPL | Stock | 15.2396 | 15.2457 | 15.2396 | 15.2457 | 15400.0 |
| 2013-05-16 07:20:00 | AAPL | Stock | 15.2446 | 15.2589 | 15.2446 | 15.2589 | 37380.0 |
| 2013-05-16 07:25:00 | AAPL | Stock | 15.2679 | 15.2682 | 15.2679 | 15.2682 | 28000.0 |
| 2013-05-16 07:30:00 | AAPL | Stock | 15.2682 | 15.2775 | 15.2661 | 15.2775 | 23800.0 |
| 2013-05-16 07:35:00 | AAPL | Stock | 15.2757 | 15.2796 | 15.2689 | 15.2696 | 84000.0 |
| 2013-05-16 07:40:00 | AAPL | Stock | 15.28 | 15.2807 | 15.27 | 15.27 | 16800.0 |
| 2013-05-16 07:45:00 | AAPL | Stock | 15.27 | 15.27 | 15.2571 | 15.2571 | 19600.0 |
| 2013-05-16 07:50:00 | AAPL | Stock | 15.2632 | 15.2632 | 15.2486 | 15.2514 | 28000.0 |
| 2013-05-16 07:55:00 | AAPL | Stock | 15.25 | 15.25 | 15.2232 | 15.2321 | 39452.0 |
| 2013-05-16 08:00:00 | AAPL | Stock | 15.2329 | 15.2668 | 15.1904 | 15.2093 | 241528.0 |
| 2013-05-16 08:05:00 | AAPL | Stock | 15.2089 | 15.2118 | 15.1286 | 15.1425 | 540932.0 |
| 2013-05-16 08:10:00 | AAPL | Stock | 15.1393 | 15.1689 | 15.125 | 15.1621 | 289548.0 |
| 2013-05-16 08:15:00 | AAPL | Stock | 15.1679 | 15.1743 | 15.1607 | 15.1696 | 70616.0 |
| 2013-05-16 08:20:00 | AAPL | Stock | 15.1746 | 15.1929 | 15.1714 | 15.1814 | 263424.0 |
| 2013-05-16 08:25:00 | AAPL | Stock | 15.1886 | 15.2232 | 15.1886 | 15.2232 | 211484.0 |
| 2013-05-16 08:30:00 | AAPL | Stock | 15.2196 | 15.2232 | 15.1875 | 15.2043 | 304052.0 |
| 2013-05-16 08:35:00 | AAPL | Stock | 15.1964 | 15.2018 | 15.1946 | 15.2018 | 41160.0 |
| 2013-05-16 08:40:00 | AAPL | Stock | 15.1946 | 15.2 | 15.1889 | 15.1964 | 176372.0 |
| 2013-05-16 08:45:00 | AAPL | Stock | 15.1964 | 15.2011 | 15.1893 | 15.1979 | 119336.0 |
| 2013-05-16 08:50:00 | AAPL | Stock | 15.2046 | 15.205 | 15.1929 | 15.1964 | 141960.0 |
| 2013-05-16 08:55:00 | AAPL | Stock | 15.1964 | 15.1964 | 15.1893 | 15.1893 | 59892.0 |
| 2013-05-16 09:00:00 | AAPL | Stock | 15.1896 | 15.1929 | 15.1696 | 15.1721 | 324660.0 |
| 2013-05-16 09:05:00 | AAPL | Stock | 15.1761 | 15.1771 | 15.1643 | 15.1714 | 303016.0 |
| 2013-05-16 09:10:00 | AAPL | Stock | 15.175 | 15.2011 | 15.175 | 15.1868 | 224140.0 |
| 2013-05-16 09:15:00 | AAPL | Stock | 15.1929 | 15.1929 | 15.1864 | 15.1925 | 67480.0 |
| 2013-05-16 09:20:00 | AAPL | Stock | 15.1821 | 15.1871 | 15.175 | 15.1786 | 226212.0 |
| 2013-05-16 09:25:00 | AAPL | Stock | 15.1786 | 15.1925 | 15.1071 | 15.1161 | 1336944.0 |
| 2013-05-16 09:30:00 | AAPL | Stock | 15.1271 | 15.1607 | 15.0204 | 15.0243 | 33231884.0 |
| 2013-05-16 09:35:00 | AAPL | Stock | 15.0218 | 15.0886 | 14.9607 | 15.0221 | 25291028.0 |
| 2013-05-16 09:40:00 | AAPL | Stock | 15.0243 | 15.0668 | 14.9918 | 15.0575 | 15653036.0 |
| 2013-05-16 09:45:00 | AAPL | Stock | 15.0604 | 15.2375 | 15.04 | 15.13 | 22180564.0 |
| 2013-05-16 09:50:00 | AAPL | Stock | 15.1311 | 15.1729 | 15.0839 | 15.1621 | 10950968.0 |
| 2013-05-16 09:55:00 | AAPL | Stock | 15.1611 | 15.2679 | 15.1379 | 15.2607 | 13448232.0 |
| 2013-05-16 10:00:00 | AAPL | Stock | 15.2621 | 15.28 | 15.2057 | 15.2521 | 13093248.0 |
| 2013-05-16 10:05:00 | AAPL | Stock | 15.2539 | 15.3307 | 15.25 | 15.3268 | 16331616.0 |
| 2013-05-16 10:10:00 | AAPL | Stock | 15.3268 | 15.4396 | 15.3268 | 15.415 | 24855684.0 |
| 2013-05-16 10:15:00 | AAPL | Stock | 15.4165 | 15.5071 | 15.4133 | 15.4868 | 21719656.0 |
> showing 50 of 336,980 rows — these rows as CSV