PREVIEW / stock_1hour / 2012-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-11.parquet
  size:    943 KB
  rows:    44,676
  symbols: 3,525

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-04-11 04:00:00	AAPL	Stock	22.5714	22.625	22.5214	22.6071	138432.0
2012-04-11 05:00:00	AAPL	Stock	22.6232	22.6607	22.6214	22.6607	40124.0
2012-04-11 06:00:00	AAPL	Stock	22.7071	22.7461	22.6964	22.7054	250236.0
2012-04-11 07:00:00	AAPL	Stock	22.7107	22.75	22.7043	22.7179	1602552.0
2012-04-11 08:00:00	AAPL	Stock	22.72	22.7461	22.655	22.7014	4763892.0
2012-04-11 09:00:00	AAPL	Stock	22.6961	22.7454	22.5236	22.6286	106719144.0
2012-04-11 10:00:00	AAPL	Stock	22.6271	22.6714	22.5536	22.6268	83003648.0
2012-04-11 11:00:00	AAPL	Stock	22.6279	22.6532	22.4204	22.4475	87833172.0
2012-04-11 12:00:00	AAPL	Stock	22.4436	22.5089	22.2893	22.4179	118092632.0
2012-04-11 13:00:00	AAPL	Stock	22.4214	22.5075	22.3879	22.4518	44183720.0
2012-04-11 14:00:00	AAPL	Stock	22.4496	22.4786	22.2622	22.3586	88221784.0
2012-04-11 15:00:00	AAPL	Stock	22.36	22.4068	22.2725	22.3611	92574916.0
2012-04-11 16:00:00	AAPL	Stock	22.3611	22.4823	22.3217	22.3611	55708016.0
2012-04-11 17:00:00	AAPL	Stock	22.3821	22.4004	22.321	22.3979	624680.0
2012-04-11 18:00:00	AAPL	Stock	22.3929	22.4036	22.3857	22.3986	292320.0
2012-04-11 19:00:00	AAPL	Stock	22.3925	22.4018	22.3643	22.3643	475916.0
2012-04-11 06:00:00	MSFT	Stock	30.76	30.77	30.76	30.77	1500.0
2012-04-11 07:00:00	MSFT	Stock	30.77	30.79	30.77	30.79	1743.0
2012-04-11 08:00:00	MSFT	Stock	30.76	30.79	30.47	30.54	190962.0
2012-04-11 09:00:00	MSFT	Stock	30.54	30.55	30.34	30.4	6055702.0
2012-04-11 10:00:00	MSFT	Stock	30.398	30.5	30.36	30.42	7435528.0
2012-04-11 11:00:00	MSFT	Stock	30.42	30.44	30.29	30.3	5147881.0
2012-04-11 12:00:00	MSFT	Stock	30.292	30.42	30.28	30.4	3775312.0
2012-04-11 13:00:00	MSFT	Stock	30.39	30.42	30.33	30.36	3435496.0
2012-04-11 14:00:00	MSFT	Stock	30.355	30.4	30.27	30.38	3660861.0
2012-04-11 15:00:00	MSFT	Stock	30.385	30.4	30.23	30.35	9919171.0
2012-04-11 16:00:00	MSFT	Stock	30.34	30.44	30.25	30.34	2916906.0
2012-04-11 17:00:00	MSFT	Stock	30.4	30.419	30.32	30.33	28396.0
2012-04-11 18:00:00	MSFT	Stock	30.36	30.37	30.33	30.33	866.0
2012-04-11 19:00:00	MSFT	Stock	30.37	30.39	30.31	30.31	1500.0
2012-04-11 07:00:00	NVDA	Stock	0.3592	0.3592	0.3592	0.3592	4000.0
2012-04-11 08:00:00	NVDA	Stock	0.3588	0.3588	0.3578	0.3588	204000.0
2012-04-11 09:00:00	NVDA	Stock	0.3588	0.361	0.3575	0.359	42106360.0
2012-04-11 10:00:00	NVDA	Stock	0.359	0.3662	0.359	0.3645	102460680.0
2012-04-11 11:00:00	NVDA	Stock	0.3646	0.3652	0.3622	0.3625	42745080.0
2012-04-11 12:00:00	NVDA	Stock	0.3625	0.3632	0.3615	0.3632	23308240.0
2012-04-11 13:00:00	NVDA	Stock	0.3631	0.3638	0.3622	0.3628	25268960.0
2012-04-11 14:00:00	NVDA	Stock	0.3628	0.3628	0.36	0.3608	29777600.0
2012-04-11 15:00:00	NVDA	Stock	0.3608	0.3611	0.3575	0.3585	87771400.0
2012-04-11 16:00:00	NVDA	Stock	0.3585	0.3616	0.3585	0.3585	3959680.0
2012-04-11 19:00:00	NVDA	Stock	0.3595	0.3595	0.3595	0.3595	12000.0
2012-04-11 07:00:00	AMZN	Stock	9.4335	9.4625	9.4335	9.4625	16300.0
2012-04-11 08:00:00	AMZN	Stock	9.455	9.494	9.35	9.4625	200940.0
2012-04-11 09:00:00	AMZN	Stock	9.4685	9.545	9.44	9.5335	13504820.0
2012-04-11 10:00:00	AMZN	Stock	9.5315	9.5985	9.511	9.5735	17399880.0
2012-04-11 11:00:00	AMZN	Stock	9.574	9.58	9.488	9.494	11281360.0
2012-04-11 12:00:00	AMZN	Stock	9.493	9.498	9.422	9.4602	7425240.0
2012-04-11 13:00:00	AMZN	Stock	9.4585	9.4775	9.438	9.4445	4186940.0
2012-04-11 14:00:00	AMZN	Stock	9.446	9.458	9.3395	9.3934	12810960.0
2012-04-11 15:00:00	AMZN	Stock	9.396	9.4365	9.368	9.3985	15473220.0

> showing 50 of 44,676 rows — these rows as CSV

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