PREVIEW / stock_30min / 2015-02-13

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-13.parquet
  size:    1.6 MB
  rows:    82,619
  symbols: 3,525

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
2015-02-13 04:00:00	AAPL	Stock	31.59	31.79	31.59	31.745	109372.0
2015-02-13 04:30:00	AAPL	Stock	31.73	31.7575	31.73	31.7575	18600.0
2015-02-13 05:00:00	AAPL	Stock	31.7675	31.7925	31.7525	31.7875	29200.0
2015-02-13 05:30:00	AAPL	Stock	31.7875	31.825	31.775	31.775	43052.0
2015-02-13 06:00:00	AAPL	Stock	31.775	31.775	31.75	31.775	59492.0
2015-02-13 06:30:00	AAPL	Stock	31.7875	31.825	31.74	31.7725	56396.0
2015-02-13 07:00:00	AAPL	Stock	31.77	31.8	31.7525	31.77	112900.0
2015-02-13 07:30:00	AAPL	Stock	31.76	31.77	31.7275	31.7325	139100.0
2015-02-13 08:00:00	AAPL	Stock	31.745	31.7875	31.55	31.73	613596.0
2015-02-13 08:30:00	AAPL	Stock	31.73	31.8125	31.725	31.77	579516.0
2015-02-13 09:00:00	AAPL	Stock	31.7725	31.8275	31.7475	31.8275	1775768.0
2015-02-13 09:30:00	AAPL	Stock	31.82	31.82	31.57	31.6512	32853008.0
2015-02-13 10:00:00	AAPL	Stock	31.655	31.6975	31.5425	31.5775	18999444.0
2015-02-13 10:30:00	AAPL	Stock	31.5775	31.59	31.4125	31.52	22183080.0
2015-02-13 11:00:00	AAPL	Stock	31.52	31.5775	31.465	31.475	10673320.0
2015-02-13 11:30:00	AAPL	Stock	31.4725	31.57	31.4525	31.5625	8780420.0
2015-02-13 12:00:00	AAPL	Stock	31.5625	31.585	31.505	31.5625	6794928.0
2015-02-13 12:30:00	AAPL	Stock	31.5625	31.5775	31.5275	31.5425	5353208.0
2015-02-13 13:00:00	AAPL	Stock	31.54	31.6262	31.5075	31.5075	8994656.0
2015-02-13 13:30:00	AAPL	Stock	31.5075	31.5125	31.415	31.4875	10716452.0
2015-02-13 14:00:00	AAPL	Stock	31.485	31.5225	31.45	31.505	6435604.0
2015-02-13 14:30:00	AAPL	Stock	31.5025	31.5775	31.4825	31.565	7792448.0
2015-02-13 15:00:00	AAPL	Stock	31.565	31.7	31.56	31.6675	14419632.0
2015-02-13 15:30:00	AAPL	Stock	31.6675	31.8075	31.6588	31.77	31900936.0
2015-02-13 16:00:00	AAPL	Stock	31.77	31.77	31.5382	31.7525	7826572.0
2015-02-13 16:30:00	AAPL	Stock	31.7525	31.77	31.5188	31.755	266684.0
2015-02-13 17:00:00	AAPL	Stock	31.5488	31.775	31.5488	31.77	743380.0
2015-02-13 17:30:00	AAPL	Stock	31.7725	31.7875	31.7675	31.78	239036.0
2015-02-13 18:00:00	AAPL	Stock	31.78	31.8	31.775	31.7972	157468.0
2015-02-13 18:30:00	AAPL	Stock	31.7875	31.7975	31.7775	31.795	126480.0
2015-02-13 19:00:00	AAPL	Stock	31.7925	31.7975	31.77	31.795	313060.0
2015-02-13 19:30:00	AAPL	Stock	31.7925	31.8075	31.7875	31.8075	107544.0
2015-02-13 06:00:00	MSFT	Stock	43.19	43.19	43.18	43.18	1680.0
2015-02-13 06:30:00	MSFT	Stock	43.18	43.19	43.18	43.19	906.0
2015-02-13 07:00:00	MSFT	Stock	43.18	43.18	43.18	43.18	200.0
2015-02-13 07:30:00	MSFT	Stock	43.18	43.18	43.18	43.18	250.0
2015-02-13 08:00:00	MSFT	Stock	43.17	43.18	43.13	43.18	7749.0
2015-02-13 08:30:00	MSFT	Stock	43.19	43.27	43.19	43.24	9393.0
2015-02-13 09:00:00	MSFT	Stock	43.22	43.44	43.22	43.38	54230.0
2015-02-13 09:30:00	MSFT	Stock	43.38	43.39	43.15	43.28	4301294.0
2015-02-13 10:00:00	MSFT	Stock	43.27	43.44	43.17	43.308	5770428.0
2015-02-13 10:30:00	MSFT	Stock	43.31	43.33	43.2	43.285	2500369.0
2015-02-13 11:00:00	MSFT	Stock	43.285	43.44	43.28	43.405	2564029.0
2015-02-13 11:30:00	MSFT	Stock	43.41	43.49	43.33	43.462	1896964.0
2015-02-13 12:00:00	MSFT	Stock	43.467	43.55	43.46	43.54	1344269.0
2015-02-13 12:30:00	MSFT	Stock	43.545	43.66	43.54	43.61	1800630.0
2015-02-13 13:00:00	MSFT	Stock	43.61	43.7	43.61	43.675	1790873.0
2015-02-13 13:30:00	MSFT	Stock	43.675	43.68	43.55	43.565	2222727.0
2015-02-13 14:00:00	MSFT	Stock	43.57	43.62	43.56	43.595	1671193.0
2015-02-13 14:30:00	MSFT	Stock	43.59	43.65	43.58	43.625	1791356.0

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

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