PREVIEW / stock_5min / 2014-05-05
file: by_date/stock_5min/2014/2014-05-05.parquet size: 5.3 MB rows: 356,764 symbols: 3,547
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-05-05 04:45:00 | AAPL | Stock | 21.1096 | 21.1096 | 21.1096 | 21.1096 | 5600.0 |
| 2014-05-05 05:05:00 | AAPL | Stock | 21.0396 | 21.0396 | 21.0396 | 21.0396 | 2800.0 |
| 2014-05-05 05:35:00 | AAPL | Stock | 21.0286 | 21.0286 | 21.0286 | 21.0286 | 2800.0 |
| 2014-05-05 06:25:00 | AAPL | Stock | 21.0039 | 21.0039 | 21.0004 | 21.0004 | 5600.0 |
| 2014-05-05 06:45:00 | AAPL | Stock | 21.0314 | 21.0314 | 21.0314 | 21.0314 | 2800.0 |
| 2014-05-05 06:55:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 4200.0 |
| 2014-05-05 07:00:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0304 | 21.0357 | 11200.0 |
| 2014-05-05 07:10:00 | AAPL | Stock | 21.0179 | 21.0182 | 21.0179 | 21.0179 | 8400.0 |
| 2014-05-05 07:15:00 | AAPL | Stock | 21.025 | 21.0357 | 21.025 | 21.0357 | 5600.0 |
| 2014-05-05 07:20:00 | AAPL | Stock | 21.0429 | 21.05 | 21.0429 | 21.05 | 11788.0 |
| 2014-05-05 07:25:00 | AAPL | Stock | 21.0536 | 21.0536 | 21.0471 | 21.0471 | 15176.0 |
| 2014-05-05 07:30:00 | AAPL | Stock | 21.0471 | 21.0471 | 21.0471 | 21.0471 | 2800.0 |
| 2014-05-05 07:35:00 | AAPL | Stock | 21.0571 | 21.0714 | 21.0571 | 21.0714 | 12600.0 |
| 2014-05-05 07:45:00 | AAPL | Stock | 21.0786 | 21.0786 | 21.0632 | 21.0632 | 10556.0 |
| 2014-05-05 07:50:00 | AAPL | Stock | 21.0764 | 21.0768 | 21.0682 | 21.0768 | 23800.0 |
| 2014-05-05 07:55:00 | AAPL | Stock | 21.0768 | 21.0961 | 21.0725 | 21.0961 | 36400.0 |
| 2014-05-05 08:00:00 | AAPL | Stock | 21.0961 | 21.0979 | 21.0071 | 21.0839 | 261324.0 |
| 2014-05-05 08:05:00 | AAPL | Stock | 21.075 | 21.0964 | 21.075 | 21.0964 | 98392.0 |
| 2014-05-05 08:10:00 | AAPL | Stock | 21.0982 | 21.0982 | 21.0971 | 21.0971 | 8400.0 |
| 2014-05-05 08:15:00 | AAPL | Stock | 21.0964 | 21.1143 | 21.0964 | 21.1143 | 85624.0 |
| 2014-05-05 08:20:00 | AAPL | Stock | 21.1036 | 21.1036 | 21.1036 | 21.1036 | 2800.0 |
| 2014-05-05 08:25:00 | AAPL | Stock | 21.0989 | 21.1104 | 21.0964 | 21.0964 | 25816.0 |
| 2014-05-05 08:30:00 | AAPL | Stock | 21.1025 | 21.105 | 21.0929 | 21.0964 | 72688.0 |
| 2014-05-05 08:35:00 | AAPL | Stock | 21.0929 | 21.0929 | 21.0804 | 21.0825 | 28280.0 |
| 2014-05-05 08:45:00 | AAPL | Stock | 21.0857 | 21.0921 | 21.0857 | 21.0875 | 14000.0 |
| 2014-05-05 08:50:00 | AAPL | Stock | 21.0857 | 21.0868 | 21.0839 | 21.0839 | 57092.0 |
| 2014-05-05 08:55:00 | AAPL | Stock | 21.085 | 21.085 | 21.0786 | 21.0839 | 16856.0 |
| 2014-05-05 09:00:00 | AAPL | Stock | 21.0804 | 21.0804 | 21.0775 | 21.0775 | 22400.0 |
| 2014-05-05 09:05:00 | AAPL | Stock | 21.0836 | 21.0836 | 21.0757 | 21.0761 | 63000.0 |
| 2014-05-05 09:10:00 | AAPL | Stock | 21.0743 | 21.0793 | 21.0714 | 21.0714 | 100408.0 |
| 2014-05-05 09:15:00 | AAPL | Stock | 21.0693 | 21.0721 | 21.0632 | 21.0714 | 35280.0 |
| 2014-05-05 09:20:00 | AAPL | Stock | 21.0786 | 21.0839 | 21.0786 | 21.0839 | 44828.0 |
| 2014-05-05 09:25:00 | AAPL | Stock | 21.0768 | 21.0825 | 21.0618 | 21.0693 | 343924.0 |
| 2014-05-05 09:30:00 | AAPL | Stock | 21.0764 | 21.1821 | 21.0714 | 21.1734 | 9720788.0 |
| 2014-05-05 09:35:00 | AAPL | Stock | 21.1718 | 21.2129 | 21.1607 | 21.1911 | 5992700.0 |
| 2014-05-05 09:40:00 | AAPL | Stock | 21.1907 | 21.1964 | 21.1307 | 21.1475 | 6474636.0 |
| 2014-05-05 09:45:00 | AAPL | Stock | 21.1475 | 21.1814 | 21.1446 | 21.1543 | 3419724.0 |
| 2014-05-05 09:50:00 | AAPL | Stock | 21.1496 | 21.2296 | 21.1475 | 21.2082 | 5422984.0 |
| 2014-05-05 09:55:00 | AAPL | Stock | 21.2121 | 21.2471 | 21.2075 | 21.2471 | 4511108.0 |
| 2014-05-05 10:00:00 | AAPL | Stock | 21.2471 | 21.2857 | 21.2443 | 21.2807 | 6775664.0 |
| 2014-05-05 10:05:00 | AAPL | Stock | 21.2831 | 21.2857 | 21.2404 | 21.2679 | 4299876.0 |
| 2014-05-05 10:10:00 | AAPL | Stock | 21.2711 | 21.2757 | 21.2464 | 21.2743 | 3766980.0 |
| 2014-05-05 10:15:00 | AAPL | Stock | 21.2743 | 21.3196 | 21.2715 | 21.3026 | 5225416.0 |
| 2014-05-05 10:20:00 | AAPL | Stock | 21.3054 | 21.345 | 21.2971 | 21.3392 | 5771360.0 |
| 2014-05-05 10:25:00 | AAPL | Stock | 21.3371 | 21.3514 | 21.3004 | 21.3143 | 3702552.0 |
| 2014-05-05 10:30:00 | AAPL | Stock | 21.3118 | 21.3304 | 21.2946 | 21.3071 | 2305380.0 |
| 2014-05-05 10:35:00 | AAPL | Stock | 21.3054 | 21.3214 | 21.2882 | 21.3004 | 2086252.0 |
| 2014-05-05 10:40:00 | AAPL | Stock | 21.3004 | 21.3495 | 21.2986 | 21.3336 | 2936584.0 |
| 2014-05-05 10:45:00 | AAPL | Stock | 21.3429 | 21.3564 | 21.3268 | 21.3368 | 2433816.0 |
| 2014-05-05 10:50:00 | AAPL | Stock | 21.3382 | 21.3714 | 21.3382 | 21.3632 | 3166380.0 |
> showing 50 of 356,764 rows — these rows as CSV