PREVIEW / stock_1min / 2013-07-30
file: by_date/stock_1min/2013/2013-07-30.parquet size: 13.4 MB rows: 973,071 symbols: 2,869
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-30 04:00:00 | AAPL | Stock | 16.0461 | 16.0536 | 16.0461 | 16.0536 | 8400.0 |
| 2013-07-30 04:14:00 | AAPL | Stock | 16.0193 | 16.0193 | 16.0193 | 16.0193 | 2800.0 |
| 2013-07-30 06:43:00 | AAPL | Stock | 16.0289 | 16.0289 | 16.0289 | 16.0289 | 16968.0 |
| 2013-07-30 07:03:00 | AAPL | Stock | 16.0357 | 16.0432 | 16.0357 | 16.0432 | 15960.0 |
| 2013-07-30 07:07:00 | AAPL | Stock | 16.0411 | 16.0411 | 16.0407 | 16.0407 | 8400.0 |
| 2013-07-30 07:08:00 | AAPL | Stock | 16.0486 | 16.0536 | 16.0486 | 16.0536 | 28000.0 |
| 2013-07-30 07:09:00 | AAPL | Stock | 16.0536 | 16.0536 | 16.0536 | 16.0536 | 2800.0 |
| 2013-07-30 07:10:00 | AAPL | Stock | 16.0539 | 16.0539 | 16.0536 | 16.0536 | 19600.0 |
| 2013-07-30 07:11:00 | AAPL | Stock | 16.0486 | 16.0486 | 16.0486 | 16.0486 | 2800.0 |
| 2013-07-30 07:15:00 | AAPL | Stock | 16.0536 | 16.0536 | 16.0536 | 16.0536 | 8400.0 |
| 2013-07-30 07:16:00 | AAPL | Stock | 16.0607 | 16.0821 | 16.0607 | 16.0821 | 64652.0 |
| 2013-07-30 07:18:00 | AAPL | Stock | 16.0821 | 16.0893 | 16.0821 | 16.0893 | 40600.0 |
| 2013-07-30 07:21:00 | AAPL | Stock | 16.0821 | 16.0821 | 16.0714 | 16.0714 | 16968.0 |
| 2013-07-30 07:22:00 | AAPL | Stock | 16.065 | 16.0721 | 16.065 | 16.0721 | 5600.0 |
| 2013-07-30 07:23:00 | AAPL | Stock | 16.0714 | 16.0714 | 16.0643 | 16.0643 | 5824.0 |
| 2013-07-30 07:26:00 | AAPL | Stock | 16.0714 | 16.0714 | 16.0714 | 16.0714 | 2800.0 |
| 2013-07-30 07:27:00 | AAPL | Stock | 16.0714 | 16.0714 | 16.0714 | 16.0714 | 2800.0 |
| 2013-07-30 07:29:00 | AAPL | Stock | 16.075 | 16.075 | 16.075 | 16.075 | 11200.0 |
| 2013-07-30 07:30:00 | AAPL | Stock | 16.0793 | 16.08 | 16.0793 | 16.08 | 12040.0 |
| 2013-07-30 07:31:00 | AAPL | Stock | 16.08 | 16.0889 | 16.08 | 16.0889 | 22400.0 |
| 2013-07-30 07:32:00 | AAPL | Stock | 16.0789 | 16.0839 | 16.0786 | 16.0789 | 25900.0 |
| 2013-07-30 07:33:00 | AAPL | Stock | 16.0786 | 16.0786 | 16.0786 | 16.0786 | 28000.0 |
| 2013-07-30 07:35:00 | AAPL | Stock | 16.0882 | 16.0882 | 16.0882 | 16.0882 | 2800.0 |
| 2013-07-30 07:36:00 | AAPL | Stock | 16.0882 | 16.0882 | 16.0882 | 16.0882 | 2800.0 |
| 2013-07-30 07:37:00 | AAPL | Stock | 16.0882 | 16.0882 | 16.0882 | 16.0882 | 2800.0 |
| 2013-07-30 07:39:00 | AAPL | Stock | 16.0875 | 16.0875 | 16.0875 | 16.0875 | 2800.0 |
| 2013-07-30 07:42:00 | AAPL | Stock | 16.0821 | 16.0821 | 16.0782 | 16.0782 | 36372.0 |
| 2013-07-30 07:43:00 | AAPL | Stock | 16.0796 | 16.0796 | 16.0643 | 16.0643 | 53200.0 |
| 2013-07-30 07:44:00 | AAPL | Stock | 16.0643 | 16.0643 | 16.0643 | 16.0643 | 2800.0 |
| 2013-07-30 07:45:00 | AAPL | Stock | 16.0718 | 16.0718 | 16.0643 | 16.0643 | 27300.0 |
| 2013-07-30 07:50:00 | AAPL | Stock | 16.0718 | 16.0718 | 16.0679 | 16.0718 | 58800.0 |
| 2013-07-30 07:53:00 | AAPL | Stock | 16.0711 | 16.0718 | 16.0711 | 16.0718 | 13720.0 |
| 2013-07-30 07:55:00 | AAPL | Stock | 16.0786 | 16.0786 | 16.0786 | 16.0786 | 2800.0 |
| 2013-07-30 07:57:00 | AAPL | Stock | 16.0786 | 16.0786 | 16.0714 | 16.0714 | 25200.0 |
| 2013-07-30 07:58:00 | AAPL | Stock | 16.0679 | 16.0679 | 16.0679 | 16.0679 | 14000.0 |
| 2013-07-30 08:00:00 | AAPL | Stock | 16.0643 | 16.0804 | 16.0536 | 16.0536 | 204204.0 |
| 2013-07-30 08:01:00 | AAPL | Stock | 16.0464 | 16.0532 | 16.0464 | 16.0532 | 11200.0 |
| 2013-07-30 08:02:00 | AAPL | Stock | 16.0532 | 16.0536 | 15.9643 | 16.0446 | 72940.0 |
| 2013-07-30 08:03:00 | AAPL | Stock | 16.0446 | 16.0536 | 16.0446 | 16.0536 | 25088.0 |
| 2013-07-30 08:04:00 | AAPL | Stock | 16.0554 | 16.0554 | 16.0532 | 16.0532 | 9940.0 |
| 2013-07-30 08:06:00 | AAPL | Stock | 16.0468 | 16.0539 | 16.0468 | 16.0539 | 25340.0 |
| 2013-07-30 08:07:00 | AAPL | Stock | 16.0482 | 16.0518 | 16.0482 | 16.0482 | 26600.0 |
| 2013-07-30 08:08:00 | AAPL | Stock | 16.0468 | 16.0482 | 16.0468 | 16.0482 | 5600.0 |
| 2013-07-30 08:09:00 | AAPL | Stock | 16.0482 | 16.0482 | 16.0464 | 16.0464 | 15260.0 |
| 2013-07-30 08:10:00 | AAPL | Stock | 16.05 | 16.05 | 16.05 | 16.05 | 2800.0 |
| 2013-07-30 08:11:00 | AAPL | Stock | 16.0464 | 16.0464 | 16.0464 | 16.0464 | 5600.0 |
| 2013-07-30 08:14:00 | AAPL | Stock | 16.0536 | 16.0536 | 16.0536 | 16.0536 | 2800.0 |
| 2013-07-30 08:15:00 | AAPL | Stock | 16.055 | 16.055 | 16.055 | 16.055 | 2800.0 |
| 2013-07-30 08:17:00 | AAPL | Stock | 16.0593 | 16.0643 | 16.0593 | 16.0639 | 43764.0 |
| 2013-07-30 08:18:00 | AAPL | Stock | 16.0661 | 16.0679 | 16.0661 | 16.0679 | 61600.0 |
> showing 50 of 973,071 rows — these rows as CSV