PREVIEW / stock_5min / 2013-07-15
file: by_date/stock_5min/2013/2013-07-15.parquet size: 5.1 MB rows: 339,064 symbols: 3,513
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-07-15 04:00:00 | AAPL | Stock | 15.2586 | 15.2586 | 15.2586 | 15.2586 | 5600.0 |
| 2013-07-15 06:25:00 | AAPL | Stock | 15.2329 | 15.2329 | 15.2329 | 15.2329 | 2800.0 |
| 2013-07-15 07:00:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 2800.0 |
| 2013-07-15 07:20:00 | AAPL | Stock | 15.2325 | 15.2325 | 15.2325 | 15.2325 | 3668.0 |
| 2013-07-15 07:35:00 | AAPL | Stock | 15.2232 | 15.2232 | 15.2232 | 15.2232 | 5880.0 |
| 2013-07-15 07:40:00 | AAPL | Stock | 15.2146 | 15.2146 | 15.2086 | 15.2086 | 5600.0 |
| 2013-07-15 07:55:00 | AAPL | Stock | 15.1993 | 15.1993 | 15.1989 | 15.1989 | 5600.0 |
| 2013-07-15 08:00:00 | AAPL | Stock | 15.1807 | 15.2321 | 15.1786 | 15.1896 | 200816.0 |
| 2013-07-15 08:05:00 | AAPL | Stock | 15.1796 | 15.1893 | 15.1732 | 15.1857 | 86744.0 |
| 2013-07-15 08:10:00 | AAPL | Stock | 15.1864 | 15.1864 | 15.1696 | 15.1786 | 209328.0 |
| 2013-07-15 08:15:00 | AAPL | Stock | 15.1893 | 15.1907 | 15.1779 | 15.1904 | 109480.0 |
| 2013-07-15 08:20:00 | AAPL | Stock | 15.2032 | 15.2032 | 15.1893 | 15.1911 | 59892.0 |
| 2013-07-15 08:25:00 | AAPL | Stock | 15.1989 | 15.1989 | 15.1911 | 15.1982 | 21000.0 |
| 2013-07-15 08:30:00 | AAPL | Stock | 15.1982 | 15.1982 | 15.1929 | 15.1982 | 33292.0 |
| 2013-07-15 08:35:00 | AAPL | Stock | 15.1982 | 15.2036 | 15.195 | 15.195 | 78064.0 |
| 2013-07-15 08:40:00 | AAPL | Stock | 15.1982 | 15.2139 | 15.1964 | 15.2118 | 164360.0 |
| 2013-07-15 08:45:00 | AAPL | Stock | 15.2107 | 15.2107 | 15.2107 | 15.2107 | 2800.0 |
| 2013-07-15 08:50:00 | AAPL | Stock | 15.1968 | 15.1968 | 15.1968 | 15.1968 | 2800.0 |
| 2013-07-15 08:55:00 | AAPL | Stock | 15.2054 | 15.215 | 15.2054 | 15.2146 | 106064.0 |
| 2013-07-15 09:00:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2089 | 15.2089 | 53200.0 |
| 2013-07-15 09:05:00 | AAPL | Stock | 15.2011 | 15.2071 | 15.2011 | 15.2054 | 21784.0 |
| 2013-07-15 09:10:00 | AAPL | Stock | 15.2054 | 15.2143 | 15.2054 | 15.2143 | 43540.0 |
| 2013-07-15 09:20:00 | AAPL | Stock | 15.2 | 15.2129 | 15.2 | 15.2121 | 21728.0 |
| 2013-07-15 09:25:00 | AAPL | Stock | 15.2071 | 15.2071 | 15.1714 | 15.1943 | 341376.0 |
| 2013-07-15 09:30:00 | AAPL | Stock | 15.1796 | 15.2261 | 15.1714 | 15.1932 | 9726108.0 |
| 2013-07-15 09:35:00 | AAPL | Stock | 15.1934 | 15.2596 | 15.1889 | 15.22 | 7154084.0 |
| 2013-07-15 09:40:00 | AAPL | Stock | 15.2222 | 15.2554 | 15.2189 | 15.2526 | 4064872.0 |
| 2013-07-15 09:45:00 | AAPL | Stock | 15.2534 | 15.3143 | 15.2407 | 15.2804 | 9648184.0 |
| 2013-07-15 09:50:00 | AAPL | Stock | 15.2857 | 15.3129 | 15.2829 | 15.3 | 3860556.0 |
| 2013-07-15 09:55:00 | AAPL | Stock | 15.3021 | 15.3143 | 15.2764 | 15.2914 | 2917432.0 |
| 2013-07-15 10:00:00 | AAPL | Stock | 15.2929 | 15.2982 | 15.2629 | 15.2711 | 4576236.0 |
| 2013-07-15 10:05:00 | AAPL | Stock | 15.2736 | 15.2986 | 15.2647 | 15.2965 | 2288160.0 |
| 2013-07-15 10:10:00 | AAPL | Stock | 15.2996 | 15.3461 | 15.2975 | 15.3454 | 7475412.0 |
| 2013-07-15 10:15:00 | AAPL | Stock | 15.3443 | 15.3807 | 15.3384 | 15.3763 | 10383940.0 |
| 2013-07-15 10:20:00 | AAPL | Stock | 15.3754 | 15.3814 | 15.3411 | 15.3732 | 4888240.0 |
| 2013-07-15 10:25:00 | AAPL | Stock | 15.3757 | 15.4089 | 15.3693 | 15.3882 | 6759648.0 |
| 2013-07-15 10:30:00 | AAPL | Stock | 15.3869 | 15.4036 | 15.3571 | 15.4005 | 3392732.0 |
| 2013-07-15 10:35:00 | AAPL | Stock | 15.3996 | 15.4093 | 15.3811 | 15.4003 | 3154844.0 |
| 2013-07-15 10:40:00 | AAPL | Stock | 15.3988 | 15.4079 | 15.3679 | 15.3679 | 3700536.0 |
| 2013-07-15 10:45:00 | AAPL | Stock | 15.3686 | 15.3782 | 15.3429 | 15.3489 | 3548440.0 |
| 2013-07-15 10:50:00 | AAPL | Stock | 15.3518 | 15.3518 | 15.3139 | 15.32 | 4688068.0 |
| 2013-07-15 10:55:00 | AAPL | Stock | 15.3214 | 15.3457 | 15.3186 | 15.3368 | 3911236.0 |
| 2013-07-15 11:00:00 | AAPL | Stock | 15.3382 | 15.3436 | 15.325 | 15.3346 | 2741704.0 |
| 2013-07-15 11:05:00 | AAPL | Stock | 15.3346 | 15.3407 | 15.3143 | 15.3161 | 2325456.0 |
| 2013-07-15 11:10:00 | AAPL | Stock | 15.3179 | 15.3357 | 15.3154 | 15.3307 | 1623972.0 |
| 2013-07-15 11:15:00 | AAPL | Stock | 15.3308 | 15.3571 | 15.3308 | 15.3514 | 2233924.0 |
| 2013-07-15 11:20:00 | AAPL | Stock | 15.3482 | 15.3664 | 15.3418 | 15.3636 | 1744876.0 |
| 2013-07-15 11:25:00 | AAPL | Stock | 15.3664 | 15.3814 | 15.3607 | 15.373 | 2082360.0 |
| 2013-07-15 11:30:00 | AAPL | Stock | 15.3736 | 15.3821 | 15.3525 | 15.3571 | 1979292.0 |
| 2013-07-15 11:35:00 | AAPL | Stock | 15.3571 | 15.3575 | 15.3264 | 15.3439 | 1986124.0 |
> showing 50 of 339,064 rows — these rows as CSV