PREVIEW / stock_30min / 2014-06-26

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-26.parquet
  size:    1.5 MB
  rows:    80,697
  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-06-26 05:00:00	AAPL	Stock	22.59	22.59	22.59	22.59	400.0
2014-06-26 05:30:00	AAPL	Stock	22.6275	22.6275	22.6275	22.6275	1068.0
2014-06-26 06:00:00	AAPL	Stock	22.6375	22.675	22.6375	22.675	11672.0
2014-06-26 06:30:00	AAPL	Stock	22.67	22.67	22.635	22.65	12520.0
2014-06-26 07:00:00	AAPL	Stock	22.65	22.65	22.6325	22.65	31720.0
2014-06-26 07:30:00	AAPL	Stock	22.65	22.65	22.6325	22.635	9200.0
2014-06-26 08:00:00	AAPL	Stock	22.65	22.65	22.5925	22.5925	176264.0
2014-06-26 08:30:00	AAPL	Stock	22.5925	22.6025	22.5775	22.595	306240.0
2014-06-26 09:00:00	AAPL	Stock	22.5875	22.61	22.5875	22.6025	356724.0
2014-06-26 09:30:00	AAPL	Stock	22.595	22.635	22.45	22.4925	23444712.0
2014-06-26 10:00:00	AAPL	Stock	22.4925	22.525	22.4538	22.4925	13332660.0
2014-06-26 10:30:00	AAPL	Stock	22.4925	22.555	22.4625	22.5275	10135716.0
2014-06-26 11:00:00	AAPL	Stock	22.53	22.59	22.53	22.5588	8963368.0
2014-06-26 11:30:00	AAPL	Stock	22.565	22.575	22.5025	22.545	6139464.0
2014-06-26 12:00:00	AAPL	Stock	22.545	22.5575	22.5325	22.555	2892460.0
2014-06-26 12:30:00	AAPL	Stock	22.557	22.5775	22.54	22.54	3837660.0
2014-06-26 13:00:00	AAPL	Stock	22.54	22.575	22.54	22.5588	4880020.0
2014-06-26 13:30:00	AAPL	Stock	22.56	22.615	22.5325	22.5875	6743276.0
2014-06-26 14:00:00	AAPL	Stock	22.585	22.6125	22.5525	22.5725	4080140.0
2014-06-26 14:30:00	AAPL	Stock	22.5725	22.6125	22.555	22.605	4384848.0
2014-06-26 15:00:00	AAPL	Stock	22.6075	22.65	22.5875	22.6362	8035832.0
2014-06-26 15:30:00	AAPL	Stock	22.635	22.7625	22.63	22.73	19756116.0
2014-06-26 16:00:00	AAPL	Stock	22.725	22.74	22.5285	22.715	3282124.0
2014-06-26 16:30:00	AAPL	Stock	22.7225	22.725	22.7125	22.72	1562924.0
2014-06-26 17:00:00	AAPL	Stock	22.72	22.72	22.6228	22.7175	106836.0
2014-06-26 17:30:00	AAPL	Stock	22.7175	22.7275	22.7175	22.7275	244560.0
2014-06-26 18:00:00	AAPL	Stock	22.725	22.7275	22.72	22.725	20656.0
2014-06-26 18:30:00	AAPL	Stock	22.725	22.7275	22.7225	22.7225	21684.0
2014-06-26 19:00:00	AAPL	Stock	22.7275	22.7375	22.7225	22.7225	29420.0
2014-06-26 19:30:00	AAPL	Stock	22.7125	22.7425	22.7125	22.7425	64636.0
2014-06-26 06:30:00	MSFT	Stock	41.97	41.97	41.97	41.97	300.0
2014-06-26 07:30:00	MSFT	Stock	41.93	41.93	41.93	41.93	100.0
2014-06-26 08:00:00	MSFT	Stock	41.92	41.92	41.9	41.9	1000.0
2014-06-26 08:30:00	MSFT	Stock	41.91	41.91	41.85	41.85	9182.0
2014-06-26 09:00:00	MSFT	Stock	41.86	41.97	41.85	41.93	9534.0
2014-06-26 09:30:00	MSFT	Stock	41.93	41.94	41.51	41.53	4192518.0
2014-06-26 10:00:00	MSFT	Stock	41.53	41.66	41.49	41.58	2959324.0
2014-06-26 10:30:00	MSFT	Stock	41.58	41.585	41.5	41.51	1537247.0
2014-06-26 11:00:00	MSFT	Stock	41.505	41.55	41.495	41.51	1567017.0
2014-06-26 11:30:00	MSFT	Stock	41.52	41.52	41.46	41.48	1191445.0
2014-06-26 12:00:00	MSFT	Stock	41.48	41.5	41.43	41.5	970058.0
2014-06-26 12:30:00	MSFT	Stock	41.5	41.54	41.46	41.525	1080310.0
2014-06-26 13:00:00	MSFT	Stock	41.525	41.67	41.52	41.66	1028809.0
2014-06-26 13:30:00	MSFT	Stock	41.66	41.72	41.66	41.72	824228.0
2014-06-26 14:00:00	MSFT	Stock	41.712	41.73	41.57	41.64	1249333.0
2014-06-26 14:30:00	MSFT	Stock	41.64	41.71	41.61	41.655	542088.0
2014-06-26 15:00:00	MSFT	Stock	41.655	41.74	41.65	41.67	853616.0
2014-06-26 15:30:00	MSFT	Stock	41.67	41.75	41.66	41.73	3378605.0
2014-06-26 16:00:00	MSFT	Stock	41.72	41.766	41.583	41.71	1047942.0
2014-06-26 16:30:00	MSFT	Stock	41.71	41.72	41.71	41.72	471995.0

> showing 50 of 80,697 rows — these rows as CSV

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