PREVIEW / stock_5min / 2013-10-04
file: by_date/stock_5min/2013/2013-10-04.parquet size: 5.0 MB rows: 335,194 symbols: 3,522
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-10-04 04:00:00 | AAPL | Stock | 17.2814 | 17.2814 | 17.2814 | 17.2814 | 7840.0 |
| 2013-10-04 04:45:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.3214 | 17.3214 | 30660.0 |
| 2013-10-04 05:25:00 | AAPL | Stock | 17.3375 | 17.3375 | 17.3375 | 17.3375 | 2800.0 |
| 2013-10-04 05:35:00 | AAPL | Stock | 17.3282 | 17.3282 | 17.3282 | 17.3282 | 13860.0 |
| 2013-10-04 05:45:00 | AAPL | Stock | 17.3396 | 17.3536 | 17.3396 | 17.3536 | 33600.0 |
| 2013-10-04 06:00:00 | AAPL | Stock | 17.3457 | 17.3457 | 17.3457 | 17.3457 | 2800.0 |
| 2013-10-04 06:10:00 | AAPL | Stock | 17.3507 | 17.3507 | 17.3457 | 17.3457 | 9800.0 |
| 2013-10-04 06:30:00 | AAPL | Stock | 17.3496 | 17.3496 | 17.3496 | 17.3496 | 2800.0 |
| 2013-10-04 06:35:00 | AAPL | Stock | 17.3525 | 17.3525 | 17.3525 | 17.3525 | 2800.0 |
| 2013-10-04 06:45:00 | AAPL | Stock | 17.3464 | 17.3464 | 17.3464 | 17.3464 | 2800.0 |
| 2013-10-04 06:50:00 | AAPL | Stock | 17.3518 | 17.3557 | 17.3518 | 17.3557 | 12600.0 |
| 2013-10-04 06:55:00 | AAPL | Stock | 17.3532 | 17.3557 | 17.3532 | 17.3557 | 12712.0 |
| 2013-10-04 07:00:00 | AAPL | Stock | 17.35 | 17.3618 | 17.35 | 17.3571 | 11200.0 |
| 2013-10-04 07:10:00 | AAPL | Stock | 17.3571 | 17.3571 | 17.3436 | 17.3436 | 22400.0 |
| 2013-10-04 07:15:00 | AAPL | Stock | 17.3386 | 17.3386 | 17.3357 | 17.3357 | 25200.0 |
| 2013-10-04 07:20:00 | AAPL | Stock | 17.3321 | 17.3321 | 17.3321 | 17.3321 | 2800.0 |
| 2013-10-04 07:25:00 | AAPL | Stock | 17.3321 | 17.3321 | 17.3193 | 17.3193 | 28308.0 |
| 2013-10-04 07:30:00 | AAPL | Stock | 17.3125 | 17.3125 | 17.2914 | 17.2964 | 99456.0 |
| 2013-10-04 07:40:00 | AAPL | Stock | 17.3 | 17.3 | 17.2964 | 17.2964 | 13692.0 |
| 2013-10-04 07:45:00 | AAPL | Stock | 17.2964 | 17.2964 | 17.2857 | 17.2857 | 24276.0 |
| 2013-10-04 07:55:00 | AAPL | Stock | 17.2964 | 17.3036 | 17.2964 | 17.3036 | 8484.0 |
| 2013-10-04 08:00:00 | AAPL | Stock | 17.3036 | 17.37 | 17.25 | 17.3196 | 203476.0 |
| 2013-10-04 08:05:00 | AAPL | Stock | 17.3079 | 17.3086 | 17.3 | 17.3036 | 138040.0 |
| 2013-10-04 08:10:00 | AAPL | Stock | 17.3143 | 17.3157 | 17.2929 | 17.3036 | 84252.0 |
| 2013-10-04 08:15:00 | AAPL | Stock | 17.3146 | 17.3146 | 17.3146 | 17.3146 | 2800.0 |
| 2013-10-04 08:20:00 | AAPL | Stock | 17.3107 | 17.3161 | 17.3071 | 17.3089 | 162288.0 |
| 2013-10-04 08:25:00 | AAPL | Stock | 17.3139 | 17.3189 | 17.2639 | 17.3004 | 805364.0 |
| 2013-10-04 08:30:00 | AAPL | Stock | 17.3007 | 17.3021 | 17.25 | 17.2675 | 211680.0 |
| 2013-10-04 08:35:00 | AAPL | Stock | 17.2643 | 17.2643 | 17.2518 | 17.2639 | 52640.0 |
| 2013-10-04 08:40:00 | AAPL | Stock | 17.275 | 17.2921 | 17.275 | 17.2768 | 24528.0 |
| 2013-10-04 08:45:00 | AAPL | Stock | 17.2821 | 17.2857 | 17.2821 | 17.2857 | 11284.0 |
| 2013-10-04 08:50:00 | AAPL | Stock | 17.2829 | 17.2857 | 17.2829 | 17.2857 | 19600.0 |
| 2013-10-04 08:55:00 | AAPL | Stock | 17.2857 | 17.2946 | 17.2839 | 17.2946 | 47600.0 |
| 2013-10-04 09:00:00 | AAPL | Stock | 17.2921 | 17.2929 | 17.2732 | 17.2768 | 123340.0 |
| 2013-10-04 09:05:00 | AAPL | Stock | 17.2854 | 17.2911 | 17.2854 | 17.2893 | 98000.0 |
| 2013-10-04 09:10:00 | AAPL | Stock | 17.2857 | 17.2932 | 17.2857 | 17.2932 | 64652.0 |
| 2013-10-04 09:15:00 | AAPL | Stock | 17.2882 | 17.2907 | 17.2861 | 17.2861 | 14000.0 |
| 2013-10-04 09:20:00 | AAPL | Stock | 17.2925 | 17.2925 | 17.2771 | 17.2857 | 134820.0 |
| 2013-10-04 09:25:00 | AAPL | Stock | 17.2861 | 17.2893 | 17.2554 | 17.2643 | 244412.0 |
| 2013-10-04 09:30:00 | AAPL | Stock | 17.2807 | 17.3071 | 17.2032 | 17.2425 | 13051052.0 |
| 2013-10-04 09:35:00 | AAPL | Stock | 17.24 | 17.2486 | 17.1661 | 17.1719 | 9028712.0 |
| 2013-10-04 09:40:00 | AAPL | Stock | 17.1721 | 17.2054 | 17.1686 | 17.1857 | 6615672.0 |
| 2013-10-04 09:45:00 | AAPL | Stock | 17.1854 | 17.1961 | 17.1539 | 17.1896 | 7857556.0 |
| 2013-10-04 09:50:00 | AAPL | Stock | 17.1936 | 17.2071 | 17.1557 | 17.1657 | 5391904.0 |
| 2013-10-04 09:55:00 | AAPL | Stock | 17.1639 | 17.1689 | 17.1075 | 17.1304 | 11075904.0 |
| 2013-10-04 10:00:00 | AAPL | Stock | 17.1307 | 17.1311 | 17.0929 | 17.1182 | 8606080.0 |
| 2013-10-04 10:05:00 | AAPL | Stock | 17.1182 | 17.1643 | 17.1154 | 17.1521 | 5663952.0 |
| 2013-10-04 10:10:00 | AAPL | Stock | 17.152 | 17.1857 | 17.152 | 17.1725 | 4889080.0 |
| 2013-10-04 10:15:00 | AAPL | Stock | 17.1711 | 17.1971 | 17.1711 | 17.1944 | 4767980.0 |
| 2013-10-04 10:20:00 | AAPL | Stock | 17.1918 | 17.1971 | 17.1672 | 17.1696 | 2488500.0 |
> showing 50 of 335,194 rows — these rows as CSV