PREVIEW / stock_30min / 2012-03-06

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-06.parquet
  size:    1.4 MB
  rows:    76,849
  symbols: 3,513

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-03-06 04:00:00	AAPL	Stock	18.9543	18.9611	18.9521	18.9611	16800.0
2012-03-06 04:30:00	AAPL	Stock	18.9643	18.9643	18.9286	18.9464	46900.0
2012-03-06 05:00:00	AAPL	Stock	18.9286	18.9286	18.9196	18.9196	52080.0
2012-03-06 05:30:00	AAPL	Stock	18.9214	18.9214	18.8796	18.8857	96460.0
2012-03-06 06:00:00	AAPL	Stock	18.8754	18.8754	18.8143	18.8143	93800.0
2012-03-06 06:30:00	AAPL	Stock	18.8036	18.8286	18.7518	18.7714	318108.0
2012-03-06 07:00:00	AAPL	Stock	18.7786	18.8929	18.7786	18.8571	784308.0
2012-03-06 07:30:00	AAPL	Stock	18.8561	18.8893	18.8393	18.8768	727272.0
2012-03-06 08:00:00	AAPL	Stock	18.8786	18.9089	18.8518	18.8982	3071040.0
2012-03-06 08:30:00	AAPL	Stock	18.8986	18.8986	18.8579	18.8654	2620212.0
2012-03-06 09:00:00	AAPL	Stock	18.8664	18.8696	18.7004	18.7007	7933016.0
2012-03-06 09:30:00	AAPL	Stock	18.7129	18.7143	18.4365	18.6257	175219240.0
2012-03-06 10:00:00	AAPL	Stock	18.6279	18.6757	18.5625	18.6514	67280052.0
2012-03-06 10:30:00	AAPL	Stock	18.6554	18.7943	18.6354	18.7556	59687656.0
2012-03-06 11:00:00	AAPL	Stock	18.7532	19.0321	18.7393	19.0246	93991940.0
2012-03-06 11:30:00	AAPL	Stock	19.0243	19.0604	18.8443	18.9286	80117520.0
2012-03-06 12:00:00	AAPL	Stock	18.9311	18.9857	18.8079	18.8329	47220320.0
2012-03-06 12:30:00	AAPL	Stock	18.8325	18.9404	18.8314	18.8589	41376944.0
2012-03-06 13:00:00	AAPL	Stock	18.8625	18.9296	18.8171	18.86	33562004.0
2012-03-06 13:30:00	AAPL	Stock	18.8649	18.9382	18.8471	18.8621	31143224.0
2012-03-06 14:00:00	AAPL	Stock	18.8611	18.9086	18.8036	18.835	26925752.0
2012-03-06 14:30:00	AAPL	Stock	18.8336	18.8807	18.8143	18.8382	24185644.0
2012-03-06 15:00:00	AAPL	Stock	18.8371	18.9346	18.8361	18.9095	36848728.0
2012-03-06 15:30:00	AAPL	Stock	18.9096	18.9729	18.8839	18.9375	52911796.0
2012-03-06 16:00:00	AAPL	Stock	18.9379	18.9439	18.7965	18.9268	9790760.0
2012-03-06 16:30:00	AAPL	Stock	18.9218	18.9379	18.8977	18.9196	540120.0
2012-03-06 17:00:00	AAPL	Stock	18.9154	18.9286	18.915	18.9196	260148.0
2012-03-06 17:30:00	AAPL	Stock	18.9182	18.9236	18.9157	18.9214	217392.0
2012-03-06 18:00:00	AAPL	Stock	18.9229	18.925	18.9179	18.9214	75432.0
2012-03-06 18:30:00	AAPL	Stock	18.9218	18.9243	18.9179	18.9214	74900.0
2012-03-06 19:00:00	AAPL	Stock	18.9214	18.9243	18.92	18.9243	114520.0
2012-03-06 19:30:00	AAPL	Stock	18.9239	18.9636	18.9211	18.9636	869484.0
2012-03-06 07:00:00	MSFT	Stock	31.62	31.67	31.61	31.61	2800.0
2012-03-06 07:30:00	MSFT	Stock	31.66	31.66	31.51	31.51	1300.0
2012-03-06 08:00:00	MSFT	Stock	31.6	31.6	31.5	31.53	13224.0
2012-03-06 08:30:00	MSFT	Stock	31.52	31.54	31.45	31.45	30309.0
2012-03-06 09:00:00	MSFT	Stock	31.45	31.54	31.33	31.5	88675.0
2012-03-06 09:30:00	MSFT	Stock	31.45	31.98	31.45	31.84	10346001.0
2012-03-06 10:00:00	MSFT	Stock	31.845	31.88	31.72	31.75	4835467.0
2012-03-06 10:30:00	MSFT	Stock	31.755	31.82	31.61	31.71	4682489.0
2012-03-06 11:00:00	MSFT	Stock	31.71	31.78	31.67	31.74	2418900.0
2012-03-06 11:30:00	MSFT	Stock	31.73	31.75	31.55	31.605	3729629.0
2012-03-06 12:00:00	MSFT	Stock	31.61	31.625	31.49	31.51	2994491.0
2012-03-06 12:30:00	MSFT	Stock	31.51	31.62	31.51	31.59	1801376.0
2012-03-06 13:00:00	MSFT	Stock	31.585	31.675	31.58	31.62	1575698.0
2012-03-06 13:30:00	MSFT	Stock	31.61	31.7	31.61	31.655	2062967.0
2012-03-06 14:00:00	MSFT	Stock	31.655	31.68	31.56	31.57	2728160.0
2012-03-06 14:30:00	MSFT	Stock	31.57	31.61	31.52	31.572	2223291.0
2012-03-06 15:00:00	MSFT	Stock	31.57	31.62	31.515	31.52	3322691.0
2012-03-06 15:30:00	MSFT	Stock	31.53	31.63	31.52	31.56	5814662.0

> showing 50 of 76,849 rows — these rows as CSV

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