PREVIEW / stock_5min / 2014-01-14
file: by_date/stock_5min/2014/2014-01-14.parquet size: 5.5 MB rows: 356,749 symbols: 3,521
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-14 06:00:00 | AAPL | Stock | 19.1482 | 19.1482 | 19.1482 | 19.1482 | 2800.0 |
| 2014-01-14 06:05:00 | AAPL | Stock | 19.1482 | 19.1482 | 19.1482 | 19.1482 | 2800.0 |
| 2014-01-14 06:40:00 | AAPL | Stock | 19.16 | 19.1607 | 19.16 | 19.1607 | 10920.0 |
| 2014-01-14 06:45:00 | AAPL | Stock | 19.1607 | 19.1668 | 19.1607 | 19.1668 | 8680.0 |
| 2014-01-14 06:50:00 | AAPL | Stock | 19.1707 | 19.1707 | 19.1575 | 19.1575 | 5600.0 |
| 2014-01-14 06:55:00 | AAPL | Stock | 19.1704 | 19.1704 | 19.1704 | 19.1704 | 2800.0 |
| 2014-01-14 07:00:00 | AAPL | Stock | 19.1704 | 19.1864 | 19.1704 | 19.1786 | 25424.0 |
| 2014-01-14 07:05:00 | AAPL | Stock | 19.1786 | 19.1864 | 19.1768 | 19.1864 | 23800.0 |
| 2014-01-14 07:10:00 | AAPL | Stock | 19.1875 | 19.1875 | 19.1875 | 19.1875 | 14616.0 |
| 2014-01-14 07:15:00 | AAPL | Stock | 19.1875 | 19.2146 | 19.1875 | 19.2146 | 33460.0 |
| 2014-01-14 07:20:00 | AAPL | Stock | 19.2186 | 19.25 | 19.2164 | 19.2496 | 57064.0 |
| 2014-01-14 07:25:00 | AAPL | Stock | 19.2471 | 19.2471 | 19.2471 | 19.2471 | 2800.0 |
| 2014-01-14 07:30:00 | AAPL | Stock | 19.2346 | 19.25 | 19.2346 | 19.25 | 26824.0 |
| 2014-01-14 07:35:00 | AAPL | Stock | 19.2429 | 19.255 | 19.2429 | 19.2468 | 86268.0 |
| 2014-01-14 07:40:00 | AAPL | Stock | 19.2504 | 19.2629 | 19.2504 | 19.2514 | 111440.0 |
| 2014-01-14 07:45:00 | AAPL | Stock | 19.2446 | 19.2446 | 19.2446 | 19.2446 | 15260.0 |
| 2014-01-14 07:50:00 | AAPL | Stock | 19.2493 | 19.2514 | 19.2493 | 19.2507 | 8400.0 |
| 2014-01-14 07:55:00 | AAPL | Stock | 19.2564 | 19.2679 | 19.2536 | 19.26 | 45080.0 |
| 2014-01-14 08:00:00 | AAPL | Stock | 19.2654 | 19.2654 | 19.1875 | 19.2357 | 448476.0 |
| 2014-01-14 08:05:00 | AAPL | Stock | 19.2332 | 19.2332 | 19.2179 | 19.22 | 163324.0 |
| 2014-01-14 08:10:00 | AAPL | Stock | 19.2221 | 19.2246 | 19.2143 | 19.2214 | 120232.0 |
| 2014-01-14 08:15:00 | AAPL | Stock | 19.2282 | 19.2289 | 19.2179 | 19.2215 | 105868.0 |
| 2014-01-14 08:20:00 | AAPL | Stock | 19.2232 | 19.2243 | 19.2154 | 19.2189 | 25200.0 |
| 2014-01-14 08:25:00 | AAPL | Stock | 19.2179 | 19.2179 | 19.1929 | 19.2032 | 130340.0 |
| 2014-01-14 08:30:00 | AAPL | Stock | 19.2043 | 19.2139 | 19.1996 | 19.2068 | 144536.0 |
| 2014-01-14 08:35:00 | AAPL | Stock | 19.1996 | 19.2136 | 19.1982 | 19.2136 | 85036.0 |
| 2014-01-14 08:40:00 | AAPL | Stock | 19.2143 | 19.2279 | 19.2107 | 19.2143 | 137732.0 |
| 2014-01-14 08:45:00 | AAPL | Stock | 19.2196 | 19.2225 | 19.2061 | 19.2079 | 71204.0 |
| 2014-01-14 08:50:00 | AAPL | Stock | 19.2082 | 19.2236 | 19.2082 | 19.2236 | 33600.0 |
| 2014-01-14 08:55:00 | AAPL | Stock | 19.2243 | 19.2321 | 19.2243 | 19.2311 | 95200.0 |
| 2014-01-14 09:00:00 | AAPL | Stock | 19.225 | 19.2296 | 19.2143 | 19.2154 | 127596.0 |
| 2014-01-14 09:05:00 | AAPL | Stock | 19.2171 | 19.2261 | 19.2154 | 19.2236 | 23100.0 |
| 2014-01-14 09:10:00 | AAPL | Stock | 19.2293 | 19.23 | 19.2175 | 19.2179 | 64400.0 |
| 2014-01-14 09:15:00 | AAPL | Stock | 19.2179 | 19.2239 | 19.2107 | 19.2143 | 121744.0 |
| 2014-01-14 09:20:00 | AAPL | Stock | 19.2146 | 19.2321 | 19.2146 | 19.2321 | 64176.0 |
| 2014-01-14 09:25:00 | AAPL | Stock | 19.2307 | 19.2429 | 19.2125 | 19.2179 | 401660.0 |
| 2014-01-14 09:30:00 | AAPL | Stock | 19.2154 | 19.3214 | 19.2143 | 19.2861 | 16615732.0 |
| 2014-01-14 09:35:00 | AAPL | Stock | 19.2918 | 19.3014 | 19.2143 | 19.2957 | 9829596.0 |
| 2014-01-14 09:40:00 | AAPL | Stock | 19.2957 | 19.3121 | 19.2629 | 19.2857 | 7638512.0 |
| 2014-01-14 09:45:00 | AAPL | Stock | 19.2875 | 19.2964 | 19.2696 | 19.2736 | 4314128.0 |
| 2014-01-14 09:50:00 | AAPL | Stock | 19.2725 | 19.2804 | 19.2021 | 19.2268 | 7197456.0 |
| 2014-01-14 09:55:00 | AAPL | Stock | 19.2229 | 19.2632 | 19.2229 | 19.2579 | 4208820.0 |
| 2014-01-14 10:00:00 | AAPL | Stock | 19.2587 | 19.2986 | 19.2579 | 19.2629 | 4093180.0 |
| 2014-01-14 10:05:00 | AAPL | Stock | 19.263 | 19.3118 | 19.2611 | 19.2961 | 4763164.0 |
| 2014-01-14 10:10:00 | AAPL | Stock | 19.3007 | 19.3607 | 19.2871 | 19.355 | 9789332.0 |
| 2014-01-14 10:15:00 | AAPL | Stock | 19.3568 | 19.3786 | 19.3373 | 19.3521 | 6716556.0 |
| 2014-01-14 10:20:00 | AAPL | Stock | 19.3536 | 19.375 | 19.3382 | 19.3493 | 4529812.0 |
| 2014-01-14 10:25:00 | AAPL | Stock | 19.3505 | 19.3782 | 19.3496 | 19.3611 | 3318140.0 |
| 2014-01-14 10:30:00 | AAPL | Stock | 19.3607 | 19.3636 | 19.3271 | 19.3532 | 2753800.0 |
| 2014-01-14 10:35:00 | AAPL | Stock | 19.3514 | 19.3675 | 19.3436 | 19.3446 | 2684584.0 |
> showing 50 of 356,749 rows — these rows as CSV