PREVIEW / stock_5min / 2013-04-08
file: by_date/stock_5min/2013/2013-04-08.parquet size: 4.9 MB rows: 326,569 symbols: 3,492
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-08 04:00:00 | AAPL | Stock | 15.1779 | 15.1779 | 15.1779 | 15.1779 | 11704.0 |
| 2013-04-08 04:15:00 | AAPL | Stock | 15.2371 | 15.2371 | 15.2371 | 15.2371 | 2800.0 |
| 2013-04-08 04:45:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2411 | 15.2411 | 2800.0 |
| 2013-04-08 04:50:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2411 | 15.2411 | 2800.0 |
| 2013-04-08 05:05:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2321 | 15.2321 | 8400.0 |
| 2013-04-08 05:40:00 | AAPL | Stock | 15.2264 | 15.2371 | 15.2264 | 15.2371 | 8400.0 |
| 2013-04-08 05:50:00 | AAPL | Stock | 15.2379 | 15.2379 | 15.2379 | 15.2379 | 5600.0 |
| 2013-04-08 05:55:00 | AAPL | Stock | 15.2379 | 15.2468 | 15.2379 | 15.2468 | 25200.0 |
| 2013-04-08 06:00:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 5600.0 |
| 2013-04-08 06:20:00 | AAPL | Stock | 15.2571 | 15.2571 | 15.2571 | 15.2571 | 2940.0 |
| 2013-04-08 06:25:00 | AAPL | Stock | 15.25 | 15.2704 | 15.2436 | 15.2679 | 28000.0 |
| 2013-04-08 06:50:00 | AAPL | Stock | 15.2446 | 15.2446 | 15.2446 | 15.2446 | 2800.0 |
| 2013-04-08 06:55:00 | AAPL | Stock | 15.2607 | 15.2607 | 15.2596 | 15.2596 | 11200.0 |
| 2013-04-08 07:00:00 | AAPL | Stock | 15.25 | 15.25 | 15.1821 | 15.2411 | 88704.0 |
| 2013-04-08 07:05:00 | AAPL | Stock | 15.2482 | 15.2764 | 15.2418 | 15.2418 | 43400.0 |
| 2013-04-08 07:10:00 | AAPL | Stock | 15.2511 | 15.2857 | 15.2511 | 15.2857 | 92512.0 |
| 2013-04-08 07:15:00 | AAPL | Stock | 15.3036 | 15.3132 | 15.2857 | 15.3071 | 57120.0 |
| 2013-04-08 07:20:00 | AAPL | Stock | 15.3071 | 15.3211 | 15.3071 | 15.3211 | 30660.0 |
| 2013-04-08 07:25:00 | AAPL | Stock | 15.3211 | 15.33 | 15.3036 | 15.3036 | 142268.0 |
| 2013-04-08 07:30:00 | AAPL | Stock | 15.2946 | 15.2946 | 15.2718 | 15.2718 | 56000.0 |
| 2013-04-08 07:35:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.2721 | 15.2721 | 11200.0 |
| 2013-04-08 07:40:00 | AAPL | Stock | 15.2804 | 15.2875 | 15.2804 | 15.2875 | 38388.0 |
| 2013-04-08 07:45:00 | AAPL | Stock | 15.2682 | 15.2768 | 15.2682 | 15.2768 | 25648.0 |
| 2013-04-08 07:50:00 | AAPL | Stock | 15.2732 | 15.2732 | 15.2732 | 15.2732 | 2996.0 |
| 2013-04-08 07:55:00 | AAPL | Stock | 15.2618 | 15.2618 | 15.2607 | 15.2611 | 25088.0 |
| 2013-04-08 08:00:00 | AAPL | Stock | 15.2525 | 15.3214 | 15.2221 | 15.2768 | 345240.0 |
| 2013-04-08 08:05:00 | AAPL | Stock | 15.2768 | 15.28 | 15.2636 | 15.275 | 28980.0 |
| 2013-04-08 08:10:00 | AAPL | Stock | 15.275 | 15.275 | 15.2643 | 15.2643 | 76132.0 |
| 2013-04-08 08:15:00 | AAPL | Stock | 15.2643 | 15.2646 | 15.2518 | 15.2607 | 155120.0 |
| 2013-04-08 08:20:00 | AAPL | Stock | 15.2625 | 15.2646 | 15.2364 | 15.2375 | 146356.0 |
| 2013-04-08 08:25:00 | AAPL | Stock | 15.2336 | 15.2336 | 15.2182 | 15.2182 | 187264.0 |
| 2013-04-08 08:30:00 | AAPL | Stock | 15.2214 | 15.2307 | 15.1982 | 15.2 | 264628.0 |
| 2013-04-08 08:35:00 | AAPL | Stock | 15.2 | 15.2143 | 15.2 | 15.2139 | 164080.0 |
| 2013-04-08 08:40:00 | AAPL | Stock | 15.2125 | 15.2143 | 15.2011 | 15.2011 | 120820.0 |
| 2013-04-08 08:45:00 | AAPL | Stock | 15.2021 | 15.2079 | 15.1946 | 15.2018 | 121604.0 |
| 2013-04-08 08:50:00 | AAPL | Stock | 15.2004 | 15.2011 | 15.1814 | 15.1814 | 205212.0 |
| 2013-04-08 08:55:00 | AAPL | Stock | 15.1814 | 15.1911 | 15.1539 | 15.1768 | 812196.0 |
| 2013-04-08 09:00:00 | AAPL | Stock | 15.1768 | 15.1893 | 15.1768 | 15.1861 | 180208.0 |
| 2013-04-08 09:05:00 | AAPL | Stock | 15.1857 | 15.1871 | 15.1732 | 15.1732 | 334964.0 |
| 2013-04-08 09:10:00 | AAPL | Stock | 15.1764 | 15.1764 | 15.1632 | 15.1632 | 248724.0 |
| 2013-04-08 09:15:00 | AAPL | Stock | 15.1696 | 15.1782 | 15.155 | 15.1575 | 320544.0 |
| 2013-04-08 09:20:00 | AAPL | Stock | 15.1521 | 15.175 | 15.1521 | 15.175 | 167440.0 |
| 2013-04-08 09:25:00 | AAPL | Stock | 15.1739 | 15.1864 | 15.1589 | 15.1714 | 448364.0 |
| 2013-04-08 09:30:00 | AAPL | Stock | 15.1714 | 15.2496 | 15.1429 | 15.23 | 18235056.0 |
| 2013-04-08 09:35:00 | AAPL | Stock | 15.23 | 15.2679 | 15.1993 | 15.2439 | 10903200.0 |
| 2013-04-08 09:40:00 | AAPL | Stock | 15.25 | 15.2607 | 15.2054 | 15.2079 | 6152300.0 |
| 2013-04-08 09:45:00 | AAPL | Stock | 15.2077 | 15.2304 | 15.1823 | 15.2032 | 5870256.0 |
| 2013-04-08 09:50:00 | AAPL | Stock | 15.1978 | 15.2186 | 15.1786 | 15.2075 | 4260144.0 |
| 2013-04-08 09:55:00 | AAPL | Stock | 15.2062 | 15.2214 | 15.1857 | 15.2066 | 3663884.0 |
| 2013-04-08 10:00:00 | AAPL | Stock | 15.2061 | 15.2095 | 15.1825 | 15.1993 | 2529240.0 |
> showing 50 of 326,569 rows — these rows as CSV