PREVIEW / stock_1min / 2012-03-06
file: by_date/stock_1min/2012/2012-03-06.parquet size: 13.8 MB rows: 1,029,772 symbols: 2,842
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-06 04:24:00 | AAPL | Stock | 18.9543 | 18.9543 | 18.9543 | 18.9543 | 2800.0 |
| 2012-03-06 04:25:00 | AAPL | Stock | 18.9554 | 18.9554 | 18.9554 | 18.9554 | 2800.0 |
| 2012-03-06 04:29:00 | AAPL | Stock | 18.9521 | 18.9611 | 18.9521 | 18.9611 | 11200.0 |
| 2012-03-06 04:30:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 19600.0 |
| 2012-03-06 04:36:00 | AAPL | Stock | 18.9429 | 18.9429 | 18.9286 | 18.9286 | 24500.0 |
| 2012-03-06 04:39:00 | AAPL | Stock | 18.9464 | 18.9464 | 18.9464 | 18.9464 | 2800.0 |
| 2012-03-06 05:13:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 8120.0 |
| 2012-03-06 05:15:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 33600.0 |
| 2012-03-06 05:21:00 | AAPL | Stock | 18.9196 | 18.9268 | 18.9196 | 18.9268 | 7560.0 |
| 2012-03-06 05:22:00 | AAPL | Stock | 18.9196 | 18.9196 | 18.9196 | 18.9196 | 2800.0 |
| 2012-03-06 05:30:00 | AAPL | Stock | 18.9214 | 18.9214 | 18.9196 | 18.9196 | 17500.0 |
| 2012-03-06 05:31:00 | AAPL | Stock | 18.9107 | 18.9107 | 18.9107 | 18.9107 | 13300.0 |
| 2012-03-06 05:33:00 | AAPL | Stock | 18.9107 | 18.9107 | 18.9071 | 18.9071 | 11200.0 |
| 2012-03-06 05:34:00 | AAPL | Stock | 18.9021 | 18.9071 | 18.9021 | 18.9071 | 24500.0 |
| 2012-03-06 05:45:00 | AAPL | Stock | 18.8946 | 18.8946 | 18.8796 | 18.8796 | 24360.0 |
| 2012-03-06 05:47:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 2800.0 |
| 2012-03-06 05:53:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8857 | 18.8857 | 2800.0 |
| 2012-03-06 06:00:00 | AAPL | Stock | 18.8754 | 18.8754 | 18.8754 | 18.8754 | 2800.0 |
| 2012-03-06 06:04:00 | AAPL | Stock | 18.8732 | 18.8732 | 18.8679 | 18.8679 | 12600.0 |
| 2012-03-06 06:08:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 7000.0 |
| 2012-03-06 06:09:00 | AAPL | Stock | 18.8571 | 18.8575 | 18.8571 | 18.8575 | 8400.0 |
| 2012-03-06 06:12:00 | AAPL | Stock | 18.8529 | 18.8529 | 18.85 | 18.85 | 8400.0 |
| 2012-03-06 06:13:00 | AAPL | Stock | 18.825 | 18.825 | 18.825 | 18.825 | 11200.0 |
| 2012-03-06 06:14:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 2800.0 |
| 2012-03-06 06:19:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 2800.0 |
| 2012-03-06 06:20:00 | AAPL | Stock | 18.8482 | 18.8482 | 18.8482 | 18.8482 | 2800.0 |
| 2012-03-06 06:27:00 | AAPL | Stock | 18.8393 | 18.8521 | 18.8393 | 18.8393 | 14000.0 |
| 2012-03-06 06:28:00 | AAPL | Stock | 18.8393 | 18.8521 | 18.8143 | 18.8143 | 21000.0 |
| 2012-03-06 06:30:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8021 | 18.8021 | 11200.0 |
| 2012-03-06 06:31:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 5936.0 |
| 2012-03-06 06:36:00 | AAPL | Stock | 18.8286 | 18.8286 | 18.8286 | 18.8286 | 11200.0 |
| 2012-03-06 06:37:00 | AAPL | Stock | 18.8218 | 18.8218 | 18.8218 | 18.8218 | 5600.0 |
| 2012-03-06 06:41:00 | AAPL | Stock | 18.8107 | 18.8107 | 18.8107 | 18.8107 | 7112.0 |
| 2012-03-06 06:44:00 | AAPL | Stock | 18.8107 | 18.8107 | 18.8107 | 18.8107 | 2800.0 |
| 2012-03-06 06:45:00 | AAPL | Stock | 18.8107 | 18.8107 | 18.8036 | 18.8036 | 30520.0 |
| 2012-03-06 06:46:00 | AAPL | Stock | 18.8107 | 18.8107 | 18.8107 | 18.8107 | 2800.0 |
| 2012-03-06 06:47:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 5600.0 |
| 2012-03-06 06:48:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 2800.0 |
| 2012-03-06 06:49:00 | AAPL | Stock | 18.8111 | 18.8211 | 18.8107 | 18.8211 | 42000.0 |
| 2012-03-06 06:50:00 | AAPL | Stock | 18.8107 | 18.8107 | 18.8036 | 18.8036 | 42000.0 |
| 2012-03-06 06:51:00 | AAPL | Stock | 18.8064 | 18.8064 | 18.8039 | 18.8039 | 30800.0 |
| 2012-03-06 06:52:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.7654 | 18.7654 | 67200.0 |
| 2012-03-06 06:53:00 | AAPL | Stock | 18.7654 | 18.7654 | 18.7518 | 18.7518 | 18340.0 |
| 2012-03-06 06:54:00 | AAPL | Stock | 18.7639 | 18.7639 | 18.7639 | 18.7639 | 14000.0 |
| 2012-03-06 06:55:00 | AAPL | Stock | 18.7679 | 18.7768 | 18.7679 | 18.7768 | 9800.0 |
| 2012-03-06 06:56:00 | AAPL | Stock | 18.7768 | 18.7768 | 18.7768 | 18.7768 | 4200.0 |
| 2012-03-06 06:59:00 | AAPL | Stock | 18.7714 | 18.7714 | 18.7714 | 18.7714 | 4200.0 |
| 2012-03-06 07:00:00 | AAPL | Stock | 18.7786 | 18.8036 | 18.7786 | 18.8036 | 22400.0 |
| 2012-03-06 07:01:00 | AAPL | Stock | 18.8121 | 18.8121 | 18.7946 | 18.8036 | 30800.0 |
| 2012-03-06 07:02:00 | AAPL | Stock | 18.8107 | 18.825 | 18.8071 | 18.8182 | 87836.0 |
> showing 50 of 1,029,772 rows — these rows as CSV