PREVIEW / stock_30min / 2013-06-07

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-07.parquet
  size:    1.5 MB
  rows:    78,549
  symbols: 3,529

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-06-07 04:00:00	AAPL	Stock	15.675	15.675	15.675	15.675	8400.0
2013-06-07 05:00:00	AAPL	Stock	15.6514	15.6514	15.6429	15.6429	17612.0
2013-06-07 05:30:00	AAPL	Stock	15.6429	15.6429	15.6429	15.6429	14280.0
2013-06-07 06:00:00	AAPL	Stock	15.6518	15.6518	15.6518	15.6518	9800.0
2013-06-07 07:00:00	AAPL	Stock	15.6607	15.6786	15.6429	15.65	64400.0
2013-06-07 07:30:00	AAPL	Stock	15.6429	15.6429	15.5914	15.6071	206920.0
2013-06-07 08:00:00	AAPL	Stock	15.6239	15.6682	15.5893	15.6071	677684.0
2013-06-07 08:30:00	AAPL	Stock	15.6043	15.6857	15.5868	15.6571	2868908.0
2013-06-07 09:00:00	AAPL	Stock	15.6482	15.6657	15.5586	15.5789	1700720.0
2013-06-07 09:30:00	AAPL	Stock	15.5936	15.6304	15.4561	15.5054	69194160.0
2013-06-07 10:00:00	AAPL	Stock	15.5039	15.6107	15.4621	15.5811	47866532.0
2013-06-07 10:30:00	AAPL	Stock	15.5789	15.6696	15.5675	15.6046	42460012.0
2013-06-07 11:00:00	AAPL	Stock	15.6057	15.6586	15.6036	15.625	17759476.0
2013-06-07 11:30:00	AAPL	Stock	15.6264	15.6382	15.5682	15.6157	15293908.0
2013-06-07 12:00:00	AAPL	Stock	15.6143	15.6364	15.5939	15.6364	9680608.0
2013-06-07 12:30:00	AAPL	Stock	15.6354	15.7857	15.6111	15.7671	31820264.0
2013-06-07 13:00:00	AAPL	Stock	15.7672	15.83	15.75	15.7639	34424376.0
2013-06-07 13:30:00	AAPL	Stock	15.7639	15.7757	15.7343	15.7643	15325184.0
2013-06-07 14:00:00	AAPL	Stock	15.7614	15.7696	15.6986	15.7175	16724540.0
2013-06-07 14:30:00	AAPL	Stock	15.7179	15.7746	15.7104	15.7618	12436144.0
2013-06-07 15:00:00	AAPL	Stock	15.7614	15.7725	15.7396	15.7518	12920544.0
2013-06-07 15:30:00	AAPL	Stock	15.7514	15.7929	15.7414	15.7839	36986852.0
2013-06-07 16:00:00	AAPL	Stock	15.7843	15.7925	15.6502	15.7754	32475352.0
2013-06-07 16:30:00	AAPL	Stock	15.7761	15.7925	15.6446	15.6446	280196.0
2013-06-07 17:00:00	AAPL	Stock	15.7821	15.7857	15.7821	15.7857	35924.0
2013-06-07 17:30:00	AAPL	Stock	15.7857	15.8036	15.7857	15.8036	151648.0
2013-06-07 18:00:00	AAPL	Stock	15.8054	15.8125	15.8054	15.8104	52052.0
2013-06-07 18:30:00	AAPL	Stock	15.8125	15.825	15.8107	15.8214	91140.0
2013-06-07 19:00:00	AAPL	Stock	15.8214	15.8214	15.8161	15.8161	42000.0
2013-06-07 19:30:00	AAPL	Stock	15.8214	15.8304	15.8161	15.8304	75348.0
2013-06-07 05:30:00	MSFT	Stock	34.81	34.81	34.79	34.79	500.0
2013-06-07 07:00:00	MSFT	Stock	34.79	34.79	34.79	34.79	500.0
2013-06-07 07:30:00	MSFT	Stock	34.9	34.9	34.9	34.9	100.0
2013-06-07 08:00:00	MSFT	Stock	34.8	34.91	34.8	34.8	6500.0
2013-06-07 08:30:00	MSFT	Stock	34.94	35.1	34.94	35.09	73216.0
2013-06-07 09:00:00	MSFT	Stock	35.09	35.29	34.96	35.19	54411.0
2013-06-07 09:30:00	MSFT	Stock	35.25	35.4	35.06	35.4	4197310.0
2013-06-07 10:00:00	MSFT	Stock	35.4	35.48	35.33	35.415	3725628.0
2013-06-07 10:30:00	MSFT	Stock	35.415	35.5	35.4	35.46	2297236.0
2013-06-07 11:00:00	MSFT	Stock	35.455	35.56	35.44	35.56	2171971.0
2013-06-07 11:30:00	MSFT	Stock	35.56	35.565	35.44	35.48	2661236.0
2013-06-07 12:00:00	MSFT	Stock	35.48	35.5	35.45	35.49	1230111.0
2013-06-07 12:30:00	MSFT	Stock	35.48	35.5	35.45	35.46	1182421.0
2013-06-07 13:00:00	MSFT	Stock	35.46	35.51	35.39	35.395	1641388.0
2013-06-07 13:30:00	MSFT	Stock	35.395	35.52	35.38	35.48	1540690.0
2013-06-07 14:00:00	MSFT	Stock	35.49	35.52	35.44	35.465	1302312.0
2013-06-07 14:30:00	MSFT	Stock	35.465	35.52	35.43	35.48	1626487.0
2013-06-07 15:00:00	MSFT	Stock	35.482	35.605	35.48	35.58	2407551.0
2013-06-07 15:30:00	MSFT	Stock	35.58	35.78	35.54	35.66	8257881.0
2013-06-07 16:00:00	MSFT	Stock	35.65	35.68	35.503	35.67	5073042.0

> showing 50 of 78,549 rows — these rows as CSV

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