PREVIEW / stock_1hour / 2012-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-31.parquet
  size:    934 KB
  rows:    44,101
  symbols: 3,501

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-07-31 04:00:00	AAPL	Stock	21.4107	21.4107	21.4107	21.4107	14000.0
2012-07-31 05:00:00	AAPL	Stock	21.4286	21.4643	21.4286	21.4643	37100.0
2012-07-31 06:00:00	AAPL	Stock	21.4643	21.4643	21.4089	21.4214	57120.0
2012-07-31 07:00:00	AAPL	Stock	21.4196	21.5339	21.3929	21.5011	1277584.0
2012-07-31 08:00:00	AAPL	Stock	21.4932	21.5768	21.4196	21.5468	4165000.0
2012-07-31 09:00:00	AAPL	Stock	21.5496	21.7154	21.5164	21.6686	97425300.0
2012-07-31 10:00:00	AAPL	Stock	21.6704	21.8311	21.6114	21.7821	94369072.0
2012-07-31 11:00:00	AAPL	Stock	21.7843	21.8114	21.7071	21.7196	51683688.0
2012-07-31 12:00:00	AAPL	Stock	21.715	21.7625	21.6643	21.7039	33432560.0
2012-07-31 13:00:00	AAPL	Stock	21.7025	21.825	21.6936	21.7993	47634552.0
2012-07-31 14:00:00	AAPL	Stock	21.7954	21.8454	21.7771	21.7854	43843016.0
2012-07-31 15:00:00	AAPL	Stock	21.7854	21.8464	21.7461	21.8129	65179184.0
2012-07-31 16:00:00	AAPL	Stock	21.8114	21.8261	21.6929	21.7968	14419104.0
2012-07-31 17:00:00	AAPL	Stock	21.795	21.8129	21.7907	21.7982	549416.0
2012-07-31 18:00:00	AAPL	Stock	21.7982	21.8054	21.795	21.8054	218204.0
2012-07-31 19:00:00	AAPL	Stock	21.8025	21.8071	21.7861	21.7929	287616.0
2012-07-31 07:00:00	MSFT	Stock	29.75	29.75	29.75	29.75	200.0
2012-07-31 08:00:00	MSFT	Stock	29.62	29.74	29.62	29.7	11510.0
2012-07-31 09:00:00	MSFT	Stock	29.65	29.71	29.39	29.53	5265885.0
2012-07-31 10:00:00	MSFT	Stock	29.53	29.66	29.46	29.58	7147965.0
2012-07-31 11:00:00	MSFT	Stock	29.581	29.64	29.49	29.49	4376034.0
2012-07-31 12:00:00	MSFT	Stock	29.5	29.5	29.33	29.42	4572703.0
2012-07-31 13:00:00	MSFT	Stock	29.41	29.53	29.38	29.495	2547636.0
2012-07-31 14:00:00	MSFT	Stock	29.495	29.59	29.48	29.518	3437709.0
2012-07-31 15:00:00	MSFT	Stock	29.515	29.58	29.45	29.46	6115612.0
2012-07-31 16:00:00	MSFT	Stock	29.46	29.607	29.4	29.47	3426070.0
2012-07-31 17:00:00	MSFT	Stock	29.46	29.47	29.4	29.45	85731.0
2012-07-31 18:00:00	MSFT	Stock	29.47	29.47	29.45	29.45	1810.0
2012-07-31 19:00:00	MSFT	Stock	29.47	29.47	29.45	29.45	687.0
2012-07-31 08:00:00	NVDA	Stock	0.3353	0.3353	0.3353	0.3353	40000.0
2012-07-31 09:00:00	NVDA	Stock	0.3353	0.3382	0.3333	0.3345	30709640.0
2012-07-31 10:00:00	NVDA	Stock	0.3348	0.3422	0.3328	0.3415	104810600.0
2012-07-31 11:00:00	NVDA	Stock	0.3413	0.3433	0.34	0.341	55787800.0
2012-07-31 12:00:00	NVDA	Stock	0.3409	0.3409	0.3388	0.3398	57848440.0
2012-07-31 13:00:00	NVDA	Stock	0.3399	0.341	0.3378	0.3385	30950040.0
2012-07-31 14:00:00	NVDA	Stock	0.3385	0.3402	0.3385	0.339	26141080.0
2012-07-31 15:00:00	NVDA	Stock	0.3388	0.3393	0.3379	0.3382	49184600.0
2012-07-31 16:00:00	NVDA	Stock	0.3385	0.3398	0.3368	0.3385	31231880.0
2012-07-31 17:00:00	NVDA	Stock	0.3385	0.3385	0.3385	0.3385	205880.0
2012-07-31 06:00:00	AMZN	Stock	11.8875	12.037	11.85	11.85	20260.0
2012-07-31 08:00:00	AMZN	Stock	11.8625	11.885	11.785	11.842	374440.0
2012-07-31 09:00:00	AMZN	Stock	11.84	11.84	11.638	11.659	12449120.0
2012-07-31 10:00:00	AMZN	Stock	11.658	11.7325	11.5805	11.7005	15818900.0
2012-07-31 11:00:00	AMZN	Stock	11.703	11.767	11.695	11.7295	10095740.0
2012-07-31 12:00:00	AMZN	Stock	11.731	11.731	11.651	11.6564	5399640.0
2012-07-31 13:00:00	AMZN	Stock	11.657	11.713	11.645	11.7	4362840.0
2012-07-31 14:00:00	AMZN	Stock	11.6955	11.7475	11.6785	11.6785	5400280.0
2012-07-31 15:00:00	AMZN	Stock	11.6835	11.6905	11.643	11.6625	9414480.0
2012-07-31 16:00:00	AMZN	Stock	11.659	11.714	11.651	11.655	1532660.0
2012-07-31 17:00:00	AMZN	Stock	11.655	11.665	11.653	11.665	100960.0

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

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