PREVIEW / stock_1min / 2013-03-14
file: by_date/stock_1min/2013/2013-03-14.parquet size: 13.2 MB rows: 979,599 symbols: 2,801
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-03-14 04:25:00 | AAPL | Stock | 15.3464 | 15.3464 | 15.3464 | 15.3464 | 2800.0 |
| 2013-03-14 04:52:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 21840.0 |
| 2013-03-14 06:30:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 14000.0 |
| 2013-03-14 06:33:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 2800.0 |
| 2013-03-14 06:43:00 | AAPL | Stock | 15.3589 | 15.3589 | 15.3589 | 15.3589 | 5572.0 |
| 2013-03-14 06:46:00 | AAPL | Stock | 15.3589 | 15.3589 | 15.3571 | 15.3571 | 11200.0 |
| 2013-03-14 06:47:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 5600.0 |
| 2013-03-14 06:51:00 | AAPL | Stock | 15.3329 | 15.3329 | 15.3329 | 15.3329 | 5600.0 |
| 2013-03-14 07:01:00 | AAPL | Stock | 15.3464 | 15.3464 | 15.3414 | 15.3464 | 16800.0 |
| 2013-03-14 07:16:00 | AAPL | Stock | 15.3429 | 15.3461 | 15.3429 | 15.3461 | 6720.0 |
| 2013-03-14 07:22:00 | AAPL | Stock | 15.3504 | 15.3504 | 15.35 | 15.35 | 11200.0 |
| 2013-03-14 07:29:00 | AAPL | Stock | 15.3571 | 15.3607 | 15.3571 | 15.3607 | 5600.0 |
| 2013-03-14 07:37:00 | AAPL | Stock | 15.3568 | 15.3568 | 15.3568 | 15.3568 | 10500.0 |
| 2013-03-14 07:40:00 | AAPL | Stock | 15.3486 | 15.3486 | 15.3482 | 15.3482 | 5600.0 |
| 2013-03-14 07:41:00 | AAPL | Stock | 15.3564 | 15.3568 | 15.3564 | 15.3568 | 11200.0 |
| 2013-03-14 07:43:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 2800.0 |
| 2013-03-14 07:45:00 | AAPL | Stock | 15.3518 | 15.3518 | 15.3518 | 15.3518 | 2800.0 |
| 2013-03-14 07:46:00 | AAPL | Stock | 15.3557 | 15.3679 | 15.3557 | 15.3675 | 44800.0 |
| 2013-03-14 07:49:00 | AAPL | Stock | 15.375 | 15.375 | 15.375 | 15.375 | 13916.0 |
| 2013-03-14 07:50:00 | AAPL | Stock | 15.3875 | 15.4107 | 15.3782 | 15.4107 | 155988.0 |
| 2013-03-14 07:51:00 | AAPL | Stock | 15.4429 | 15.5171 | 15.4286 | 15.5021 | 218176.0 |
| 2013-03-14 07:52:00 | AAPL | Stock | 15.5043 | 15.5214 | 15.4821 | 15.4821 | 83664.0 |
| 2013-03-14 07:53:00 | AAPL | Stock | 15.4664 | 15.4929 | 15.4621 | 15.4696 | 89600.0 |
| 2013-03-14 07:54:00 | AAPL | Stock | 15.4804 | 15.5 | 15.4679 | 15.4821 | 139944.0 |
| 2013-03-14 07:55:00 | AAPL | Stock | 15.47 | 15.4764 | 15.4679 | 15.4729 | 193368.0 |
| 2013-03-14 07:56:00 | AAPL | Stock | 15.4661 | 15.4893 | 15.4646 | 15.4821 | 113400.0 |
| 2013-03-14 07:57:00 | AAPL | Stock | 15.4821 | 15.4954 | 15.4707 | 15.4721 | 98168.0 |
| 2013-03-14 07:58:00 | AAPL | Stock | 15.4743 | 15.4743 | 15.4679 | 15.4679 | 44324.0 |
| 2013-03-14 07:59:00 | AAPL | Stock | 15.4643 | 15.4646 | 15.4579 | 15.4614 | 73500.0 |
| 2013-03-14 08:00:00 | AAPL | Stock | 15.4557 | 15.5236 | 15.375 | 15.4821 | 691320.0 |
| 2013-03-14 08:01:00 | AAPL | Stock | 15.4732 | 15.4732 | 15.4679 | 15.4679 | 75824.0 |
| 2013-03-14 08:02:00 | AAPL | Stock | 15.4682 | 15.475 | 15.4679 | 15.475 | 33236.0 |
| 2013-03-14 08:03:00 | AAPL | Stock | 15.4818 | 15.4818 | 15.4714 | 15.4729 | 88200.0 |
| 2013-03-14 08:04:00 | AAPL | Stock | 15.4732 | 15.4743 | 15.4679 | 15.4679 | 116284.0 |
| 2013-03-14 08:05:00 | AAPL | Stock | 15.4743 | 15.475 | 15.4682 | 15.475 | 73556.0 |
| 2013-03-14 08:06:00 | AAPL | Stock | 15.4732 | 15.4732 | 15.4464 | 15.4464 | 171528.0 |
| 2013-03-14 08:07:00 | AAPL | Stock | 15.4618 | 15.4618 | 15.4571 | 15.4571 | 79380.0 |
| 2013-03-14 08:08:00 | AAPL | Stock | 15.4643 | 15.4732 | 15.4589 | 15.4732 | 61656.0 |
| 2013-03-14 08:09:00 | AAPL | Stock | 15.4764 | 15.4764 | 15.4679 | 15.4689 | 36428.0 |
| 2013-03-14 08:10:00 | AAPL | Stock | 15.4682 | 15.4786 | 15.4682 | 15.4696 | 66584.0 |
| 2013-03-14 08:11:00 | AAPL | Stock | 15.4696 | 15.475 | 15.4696 | 15.475 | 14000.0 |
| 2013-03-14 08:12:00 | AAPL | Stock | 15.4668 | 15.4746 | 15.4643 | 15.4714 | 70196.0 |
| 2013-03-14 08:13:00 | AAPL | Stock | 15.4736 | 15.4821 | 15.4736 | 15.475 | 223104.0 |
| 2013-03-14 08:14:00 | AAPL | Stock | 15.4746 | 15.4807 | 15.4732 | 15.4732 | 9800.0 |
| 2013-03-14 08:15:00 | AAPL | Stock | 15.4804 | 15.4818 | 15.4718 | 15.4818 | 70784.0 |
| 2013-03-14 08:16:00 | AAPL | Stock | 15.4821 | 15.4946 | 15.4821 | 15.4946 | 104020.0 |
| 2013-03-14 08:17:00 | AAPL | Stock | 15.4954 | 15.4954 | 15.4893 | 15.4954 | 101332.0 |
| 2013-03-14 08:18:00 | AAPL | Stock | 15.49 | 15.4954 | 15.4889 | 15.4929 | 183204.0 |
| 2013-03-14 08:19:00 | AAPL | Stock | 15.4893 | 15.4939 | 15.4846 | 15.4893 | 58128.0 |
| 2013-03-14 08:20:00 | AAPL | Stock | 15.485 | 15.4954 | 15.485 | 15.4954 | 89796.0 |
> showing 50 of 979,599 rows — these rows as CSV