PREVIEW / stock_1min / 2013-04-18
file: by_date/stock_1min/2013/2013-04-18.parquet size: 13.3 MB rows: 985,659 symbols: 2,799
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-04-18 04:23:00 | AAPL | Stock | 14.37 | 14.37 | 14.37 | 14.37 | 2800.0 |
| 2013-04-18 05:02:00 | AAPL | Stock | 14.3864 | 14.3871 | 14.3864 | 14.3871 | 26040.0 |
| 2013-04-18 05:04:00 | AAPL | Stock | 14.3921 | 14.3921 | 14.3921 | 14.3921 | 10612.0 |
| 2013-04-18 05:23:00 | AAPL | Stock | 14.3996 | 14.3996 | 14.3996 | 14.3996 | 2800.0 |
| 2013-04-18 05:46:00 | AAPL | Stock | 14.425 | 14.425 | 14.425 | 14.425 | 2800.0 |
| 2013-04-18 05:49:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 5600.0 |
| 2013-04-18 05:59:00 | AAPL | Stock | 14.4375 | 14.4375 | 14.4375 | 14.4375 | 2800.0 |
| 2013-04-18 06:04:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 2800.0 |
| 2013-04-18 06:11:00 | AAPL | Stock | 14.4375 | 14.4375 | 14.4375 | 14.4375 | 5600.0 |
| 2013-04-18 06:30:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 26768.0 |
| 2013-04-18 06:35:00 | AAPL | Stock | 14.4039 | 14.4039 | 14.4039 | 14.4039 | 9856.0 |
| 2013-04-18 06:37:00 | AAPL | Stock | 14.42 | 14.4268 | 14.42 | 14.4268 | 6804.0 |
| 2013-04-18 06:50:00 | AAPL | Stock | 14.4111 | 14.4111 | 14.4111 | 14.4111 | 2800.0 |
| 2013-04-18 06:51:00 | AAPL | Stock | 14.4096 | 14.4096 | 14.4096 | 14.4096 | 5236.0 |
| 2013-04-18 06:53:00 | AAPL | Stock | 14.4089 | 14.4096 | 14.4089 | 14.4096 | 11620.0 |
| 2013-04-18 06:56:00 | AAPL | Stock | 14.4018 | 14.4286 | 14.4018 | 14.4286 | 52388.0 |
| 2013-04-18 07:00:00 | AAPL | Stock | 14.4139 | 14.4471 | 14.4139 | 14.4471 | 50680.0 |
| 2013-04-18 07:01:00 | AAPL | Stock | 14.4468 | 14.4471 | 14.4468 | 14.4471 | 8400.0 |
| 2013-04-18 07:02:00 | AAPL | Stock | 14.4536 | 14.4643 | 14.4532 | 14.4643 | 77140.0 |
| 2013-04-18 07:03:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4714 | 14.4714 | 47544.0 |
| 2013-04-18 07:04:00 | AAPL | Stock | 14.4714 | 14.4714 | 14.4714 | 14.4714 | 5600.0 |
| 2013-04-18 07:05:00 | AAPL | Stock | 14.4643 | 14.4761 | 14.4643 | 14.4761 | 29652.0 |
| 2013-04-18 07:06:00 | AAPL | Stock | 14.4761 | 14.4761 | 14.4761 | 14.4761 | 2800.0 |
| 2013-04-18 07:08:00 | AAPL | Stock | 14.485 | 14.485 | 14.485 | 14.485 | 5600.0 |
| 2013-04-18 07:11:00 | AAPL | Stock | 14.4804 | 14.4814 | 14.4804 | 14.4804 | 13216.0 |
| 2013-04-18 07:12:00 | AAPL | Stock | 14.4846 | 14.4846 | 14.4846 | 14.4846 | 5600.0 |
| 2013-04-18 07:13:00 | AAPL | Stock | 14.4914 | 14.5086 | 14.4914 | 14.5086 | 19600.0 |
| 2013-04-18 07:14:00 | AAPL | Stock | 14.5089 | 14.5093 | 14.5089 | 14.5093 | 28000.0 |
| 2013-04-18 07:15:00 | AAPL | Stock | 14.5171 | 14.5171 | 14.5018 | 14.5125 | 10640.0 |
| 2013-04-18 07:16:00 | AAPL | Stock | 14.5018 | 14.5018 | 14.4964 | 14.4964 | 17976.0 |
| 2013-04-18 07:17:00 | AAPL | Stock | 14.4961 | 14.4971 | 14.4961 | 14.4971 | 12180.0 |
| 2013-04-18 07:18:00 | AAPL | Stock | 14.4993 | 14.5 | 14.4993 | 14.5 | 14840.0 |
| 2013-04-18 07:19:00 | AAPL | Stock | 14.5107 | 14.5107 | 14.5107 | 14.5107 | 2800.0 |
| 2013-04-18 07:21:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 4200.0 |
| 2013-04-18 07:23:00 | AAPL | Stock | 14.4911 | 14.4911 | 14.4911 | 14.4911 | 2800.0 |
| 2013-04-18 07:29:00 | AAPL | Stock | 14.4911 | 14.4911 | 14.4911 | 14.4911 | 5096.0 |
| 2013-04-18 07:31:00 | AAPL | Stock | 14.4907 | 14.4907 | 14.4821 | 14.4821 | 13972.0 |
| 2013-04-18 07:32:00 | AAPL | Stock | 14.4875 | 14.4875 | 14.4875 | 14.4875 | 2800.0 |
| 2013-04-18 07:33:00 | AAPL | Stock | 14.4779 | 14.4779 | 14.4725 | 14.4725 | 22400.0 |
| 2013-04-18 07:35:00 | AAPL | Stock | 14.475 | 14.4843 | 14.475 | 14.4843 | 5600.0 |
| 2013-04-18 07:36:00 | AAPL | Stock | 14.475 | 14.475 | 14.475 | 14.475 | 2800.0 |
| 2013-04-18 07:38:00 | AAPL | Stock | 14.4732 | 14.4732 | 14.4643 | 14.4643 | 46200.0 |
| 2013-04-18 07:40:00 | AAPL | Stock | 14.4507 | 14.4518 | 14.4507 | 14.4518 | 5600.0 |
| 2013-04-18 07:41:00 | AAPL | Stock | 14.4518 | 14.4521 | 14.4518 | 14.4518 | 8400.0 |
| 2013-04-18 07:42:00 | AAPL | Stock | 14.4604 | 14.4604 | 14.4604 | 14.4604 | 2800.0 |
| 2013-04-18 07:43:00 | AAPL | Stock | 14.4643 | 14.4696 | 14.4643 | 14.4696 | 23800.0 |
| 2013-04-18 07:44:00 | AAPL | Stock | 14.4814 | 14.5089 | 14.4743 | 14.5089 | 186620.0 |
| 2013-04-18 07:45:00 | AAPL | Stock | 14.51 | 14.5182 | 14.4932 | 14.4993 | 136332.0 |
| 2013-04-18 07:46:00 | AAPL | Stock | 14.4996 | 14.4996 | 14.4996 | 14.4996 | 4200.0 |
| 2013-04-18 07:47:00 | AAPL | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 9800.0 |
> showing 50 of 985,659 rows — these rows as CSV