PREVIEW / stock_1hour / 2013-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-16.parquet
  size:    993 KB
  rows:    45,904
  symbols: 3,497

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-16 04:00:00	AAPL	Stock	15.2786	15.2786	15.2786	15.2786	7140.0
2013-07-16 06:00:00	AAPL	Stock	15.2857	15.2857	15.2857	15.2857	2800.0
2013-07-16 07:00:00	AAPL	Stock	15.2475	15.3	15.2457	15.2457	42448.0
2013-07-16 08:00:00	AAPL	Stock	15.2432	15.25	15.2304	15.2464	746676.0
2013-07-16 09:00:00	AAPL	Stock	15.2457	15.3121	15.1489	15.2239	42436576.0
2013-07-16 10:00:00	AAPL	Stock	15.2279	15.2775	15.19	15.2332	34525092.0
2013-07-16 11:00:00	AAPL	Stock	15.2326	15.2675	15.2232	15.2504	20176604.0
2013-07-16 12:00:00	AAPL	Stock	15.2504	15.3171	15.245	15.3036	20187972.0
2013-07-16 13:00:00	AAPL	Stock	15.3054	15.3554	15.2886	15.3543	24439464.0
2013-07-16 14:00:00	AAPL	Stock	15.3543	15.3589	15.3054	15.3293	18104800.0
2013-07-16 15:00:00	AAPL	Stock	15.3293	15.3825	15.3075	15.3675	42860720.0
2013-07-16 16:00:00	AAPL	Stock	15.3675	15.375	15.2232	15.3546	8999844.0
2013-07-16 17:00:00	AAPL	Stock	15.3571	15.3643	15.3554	15.3571	1563212.0
2013-07-16 18:00:00	AAPL	Stock	15.3632	15.3646	15.3589	15.3646	53200.0
2013-07-16 19:00:00	AAPL	Stock	15.3593	15.3611	15.3218	15.3407	349048.0
2013-07-16 08:00:00	MSFT	Stock	36.1	36.2	36.1	36.17	262033.0
2013-07-16 09:00:00	MSFT	Stock	36.11	36.2	35.96	36.17	4888072.0
2013-07-16 10:00:00	MSFT	Stock	36.17	36.32	36.15	36.24	5013095.0
2013-07-16 11:00:00	MSFT	Stock	36.24	36.25	36.11	36.25	5776090.0
2013-07-16 12:00:00	MSFT	Stock	36.24	36.29	36.19	36.245	2950939.0
2013-07-16 13:00:00	MSFT	Stock	36.24	36.43	36.24	36.37	3566271.0
2013-07-16 14:00:00	MSFT	Stock	36.373	36.42	36.25	36.26	3789328.0
2013-07-16 15:00:00	MSFT	Stock	36.26	36.31	36.15	36.255	7361191.0
2013-07-16 16:00:00	MSFT	Stock	36.3	36.31	36.122	36.25	2337908.0
2013-07-16 17:00:00	MSFT	Stock	36.26	36.32	36.24	36.32	380.0
2013-07-16 18:00:00	MSFT	Stock	36.27	36.27	36.27	36.27	100.0
2013-07-16 19:00:00	MSFT	Stock	36.29	36.29	36.29	36.29	100.0
2013-07-16 09:00:00	NVDA	Stock	0.3675	0.3685	0.366	0.3684	16201160.0
2013-07-16 10:00:00	NVDA	Stock	0.3685	0.3692	0.365	0.3655	38783720.0
2013-07-16 11:00:00	NVDA	Stock	0.3655	0.3662	0.3649	0.3658	22071400.0
2013-07-16 12:00:00	NVDA	Stock	0.3658	0.3665	0.3655	0.366	15146240.0
2013-07-16 13:00:00	NVDA	Stock	0.366	0.3675	0.366	0.3674	12202240.0
2013-07-16 14:00:00	NVDA	Stock	0.3674	0.3688	0.3673	0.3678	18926680.0
2013-07-16 15:00:00	NVDA	Stock	0.3678	0.3685	0.367	0.3672	32550400.0
2013-07-16 16:00:00	NVDA	Stock	0.3675	0.3675	0.367	0.367	6343120.0
2013-07-16 19:00:00	NVDA	Stock	0.367	0.367	0.367	0.367	10000.0
2013-07-16 06:00:00	AMZN	Stock	15.3495	15.3535	15.3495	15.35	10000.0
2013-07-16 07:00:00	AMZN	Stock	15.3545	15.3595	15.3545	15.3595	4000.0
2013-07-16 08:00:00	AMZN	Stock	15.355	15.3625	15.325	15.3285	188400.0
2013-07-16 09:00:00	AMZN	Stock	15.3285	15.4695	15.309	15.365	12945860.0
2013-07-16 10:00:00	AMZN	Stock	15.359	15.4275	15.338	15.3876	6816380.0
2013-07-16 11:00:00	AMZN	Stock	15.386	15.411	15.3175	15.3275	7974120.0
2013-07-16 12:00:00	AMZN	Stock	15.327	15.343	15.2968	15.3105	4385340.0
2013-07-16 13:00:00	AMZN	Stock	15.3085	15.375	15.2756	15.34	5580240.0
2013-07-16 14:00:00	AMZN	Stock	15.3405	15.387	15.3255	15.332	5986900.0
2013-07-16 15:00:00	AMZN	Stock	15.3342	15.3723	15.3086	15.3435	6500160.0
2013-07-16 16:00:00	AMZN	Stock	15.3435	15.3562	15.308	15.349	2318400.0
2013-07-16 17:00:00	AMZN	Stock	15.349	15.349	15.33	15.3435	45400.0
2013-07-16 18:00:00	AMZN	Stock	15.3445	15.3445	15.3445	15.3445	2000.0
2013-07-16 19:00:00	AMZN	Stock	15.35	15.35	15.35	15.35	7540.0

> showing 50 of 45,904 rows — these rows as CSV

> unlock the full archive -- $79 one-time