PREVIEW / stock_30min / 2014-07-18

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-18.parquet
  size:    1.6 MB
  rows:    82,355
  symbols: 3,560

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
2014-07-18 04:00:00	AAPL	Stock	23.285	23.33	23.285	23.285	4556.0
2014-07-18 04:30:00	AAPL	Stock	23.2875	23.2875	23.285	23.285	2476.0
2014-07-18 06:00:00	AAPL	Stock	23.2825	23.2875	23.2825	23.2875	11424.0
2014-07-18 06:30:00	AAPL	Stock	23.3	23.3625	23.3	23.3625	24512.0
2014-07-18 07:00:00	AAPL	Stock	23.3725	23.425	23.3725	23.425	88468.0
2014-07-18 07:30:00	AAPL	Stock	23.4125	23.415	23.35	23.3775	128440.0
2014-07-18 08:00:00	AAPL	Stock	23.375	23.4325	23.27	23.3938	534888.0
2014-07-18 08:30:00	AAPL	Stock	23.395	23.4	23.3675	23.3725	267564.0
2014-07-18 09:00:00	AAPL	Stock	23.3775	23.4225	23.35	23.405	889416.0
2014-07-18 09:30:00	AAPL	Stock	23.405	23.45	23.275	23.33	35875544.0
2014-07-18 10:00:00	AAPL	Stock	23.33	23.37	23.255	23.3625	14876100.0
2014-07-18 10:30:00	AAPL	Stock	23.3645	23.46	23.35	23.4505	10737552.0
2014-07-18 11:00:00	AAPL	Stock	23.45	23.5335	23.4425	23.45	13004304.0
2014-07-18 11:30:00	AAPL	Stock	23.4525	23.525	23.415	23.51	8189220.0
2014-07-18 12:00:00	AAPL	Stock	23.5112	23.5625	23.485	23.5575	6537496.0
2014-07-18 12:30:00	AAPL	Stock	23.5575	23.62	23.5462	23.59	10025328.0
2014-07-18 13:00:00	AAPL	Stock	23.59	23.595	23.5125	23.5502	6093240.0
2014-07-18 13:30:00	AAPL	Stock	23.55	23.62	23.5425	23.6028	6226564.0
2014-07-18 14:00:00	AAPL	Stock	23.6075	23.685	23.6025	23.6575	7901800.0
2014-07-18 14:30:00	AAPL	Stock	23.6575	23.6725	23.5925	23.6075	7407276.0
2014-07-18 15:00:00	AAPL	Stock	23.61	23.66	23.61	23.61	8030652.0
2014-07-18 15:30:00	AAPL	Stock	23.61	23.62	23.5062	23.6075	27136540.0
2014-07-18 16:00:00	AAPL	Stock	23.6075	23.6175	23.5018	23.5825	21292216.0
2014-07-18 16:30:00	AAPL	Stock	23.575	23.6122	23.401	23.5775	1067444.0
2014-07-18 17:00:00	AAPL	Stock	23.5775	23.6075	23.5675	23.5675	620532.0
2014-07-18 17:30:00	AAPL	Stock	23.5675	23.6075	23.5675	23.58	173152.0
2014-07-18 18:00:00	AAPL	Stock	23.58	23.5925	23.58	23.5875	65252.0
2014-07-18 18:30:00	AAPL	Stock	23.5875	23.6075	23.5875	23.5875	125964.0
2014-07-18 19:00:00	AAPL	Stock	23.59	23.605	23.5875	23.6	76656.0
2014-07-18 19:30:00	AAPL	Stock	23.6075	23.625	23.6075	23.625	94600.0
2014-07-18 05:30:00	MSFT	Stock	44.5	44.5	44.5	44.5	100.0
2014-07-18 07:00:00	MSFT	Stock	44.45	44.45	44.45	44.45	900.0
2014-07-18 07:30:00	MSFT	Stock	44.5	44.5	44.5	44.5	100.0
2014-07-18 08:00:00	MSFT	Stock	44.5	44.62	44.45	44.62	4143.0
2014-07-18 08:30:00	MSFT	Stock	44.6	44.63	44.55	44.59	3300.0
2014-07-18 09:00:00	MSFT	Stock	44.54	44.67	44.47	44.65	91548.0
2014-07-18 09:30:00	MSFT	Stock	44.65	44.84	44.5	44.7	8888466.0
2014-07-18 10:00:00	MSFT	Stock	44.71	44.77	44.315	44.406	5451107.0
2014-07-18 10:30:00	MSFT	Stock	44.4	44.505	44.25	44.5	2603787.0
2014-07-18 11:00:00	MSFT	Stock	44.505	44.59	44.425	44.44	2322062.0
2014-07-18 11:30:00	MSFT	Stock	44.44	44.46	44.34	44.41	2077481.0
2014-07-18 12:00:00	MSFT	Stock	44.41	44.43	44.35	44.41	1618456.0
2014-07-18 12:30:00	MSFT	Stock	44.4	44.42	44.35	44.385	919568.0
2014-07-18 13:00:00	MSFT	Stock	44.383	44.4	44.28	44.34	1051164.0
2014-07-18 13:30:00	MSFT	Stock	44.335	44.41	44.32	44.39	1312156.0
2014-07-18 14:00:00	MSFT	Stock	44.38	44.52	44.34	44.5	1718208.0
2014-07-18 14:30:00	MSFT	Stock	44.495	44.585	44.48	44.52	1886617.0
2014-07-18 15:00:00	MSFT	Stock	44.53	44.62	44.47	44.485	2933131.0
2014-07-18 15:30:00	MSFT	Stock	44.485	44.72	44.45	44.715	5792895.0
2014-07-18 16:00:00	MSFT	Stock	44.71	44.74	44.53	44.71	3484164.0

> showing 50 of 82,355 rows — these rows as CSV

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