PREVIEW / stock_30min / 2014-12-10

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-10.parquet
  size:    1.6 MB
  rows:    84,845
  symbols: 3,545

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-12-10 04:00:00	AAPL	Stock	28.59	28.6025	28.59	28.6	17600.0
2014-12-10 04:30:00	AAPL	Stock	28.5875	28.645	28.5875	28.645	10292.0
2014-12-10 05:00:00	AAPL	Stock	28.655	28.675	28.6075	28.62	14768.0
2014-12-10 06:00:00	AAPL	Stock	28.605	28.66	28.575	28.66	67692.0
2014-12-10 06:30:00	AAPL	Stock	28.67	28.675	28.6025	28.65	63760.0
2014-12-10 07:00:00	AAPL	Stock	28.6375	28.65	28.5825	28.6425	83208.0
2014-12-10 07:30:00	AAPL	Stock	28.6425	28.6425	28.5525	28.6	145268.0
2014-12-10 08:00:00	AAPL	Stock	28.5975	28.6475	28.53	28.5775	253164.0
2014-12-10 08:30:00	AAPL	Stock	28.5875	28.6475	28.585	28.6375	484684.0
2014-12-10 09:00:00	AAPL	Stock	28.6475	28.65	28.58	28.6025	344784.0
2014-12-10 09:30:00	AAPL	Stock	28.6025	28.7125	28.2795	28.3882	27594372.0
2014-12-10 10:00:00	AAPL	Stock	28.39	28.445	28.265	28.2675	12396784.0
2014-12-10 10:30:00	AAPL	Stock	28.2675	28.435	28.19	28.4175	13948492.0
2014-12-10 11:00:00	AAPL	Stock	28.42	28.4275	28.3325	28.39	7309532.0
2014-12-10 11:30:00	AAPL	Stock	28.3875	28.4375	28.31	28.4025	6403732.0
2014-12-10 12:00:00	AAPL	Stock	28.4025	28.4025	28.265	28.2925	5984784.0
2014-12-10 12:30:00	AAPL	Stock	28.2925	28.335	28.2525	28.2598	5097724.0
2014-12-10 13:00:00	AAPL	Stock	28.2588	28.3688	28.23	28.36	7628788.0
2014-12-10 13:30:00	AAPL	Stock	28.36	28.37	28.1275	28.1325	8833296.0
2014-12-10 14:00:00	AAPL	Stock	28.135	28.18	28.0025	28.0425	10654412.0
2014-12-10 14:30:00	AAPL	Stock	28.0425	28.0875	27.95	27.9525	13204104.0
2014-12-10 15:00:00	AAPL	Stock	27.955	28.0938	27.885	28.0888	12022976.0
2014-12-10 15:30:00	AAPL	Stock	28.0925	28.1262	27.885	27.99	23238744.0
2014-12-10 16:00:00	AAPL	Stock	27.9875	28.3308	27.9742	28.3308	7809244.0
2014-12-10 16:30:00	AAPL	Stock	27.9875	28.0	27.9775	27.9825	445504.0
2014-12-10 17:00:00	AAPL	Stock	27.9775	27.99	27.97	27.9875	61200.0
2014-12-10 17:30:00	AAPL	Stock	28.2395	28.2395	27.9875	28.0025	85764.0
2014-12-10 18:00:00	AAPL	Stock	28.0075	28.455	27.97	27.995	41892.0
2014-12-10 18:30:00	AAPL	Stock	27.9775	27.9875	27.9675	27.985	39208.0
2014-12-10 19:00:00	AAPL	Stock	27.985	27.9975	27.9575	27.9675	30596.0
2014-12-10 19:30:00	AAPL	Stock	27.96	27.9875	27.945	27.97	101328.0
2014-12-10 09:00:00	MSFT	Stock	47.46	47.55	47.46	47.55	28236.0
2014-12-10 09:30:00	MSFT	Stock	47.55	47.59	47.11	47.11	2783914.0
2014-12-10 10:00:00	MSFT	Stock	47.12	47.18	46.94	47.105	2690115.0
2014-12-10 10:30:00	MSFT	Stock	47.11	47.39	46.99	47.39	2027346.0
2014-12-10 11:00:00	MSFT	Stock	47.39	47.41	47.29	47.3	1430055.0
2014-12-10 11:30:00	MSFT	Stock	47.31	47.66	47.27	47.615	1498501.0
2014-12-10 12:00:00	MSFT	Stock	47.61	47.61	47.29	47.33	1124380.0
2014-12-10 12:30:00	MSFT	Stock	47.34	47.396	47.294	47.325	726249.0
2014-12-10 13:00:00	MSFT	Stock	47.32	47.36	47.24	47.32	894977.0
2014-12-10 13:30:00	MSFT	Stock	47.33	47.34	46.94	46.95	1562210.0
2014-12-10 14:00:00	MSFT	Stock	46.95	46.97	46.7	46.83	2237670.0
2014-12-10 14:30:00	MSFT	Stock	46.834	46.915	46.75	46.8	1715561.0
2014-12-10 15:00:00	MSFT	Stock	46.8	46.99	46.75	46.945	1632317.0
2014-12-10 15:30:00	MSFT	Stock	46.945	47.02	46.8	46.92	4845174.0
2014-12-10 16:00:00	MSFT	Stock	46.9	47.08	46.88	46.9	3678840.0
2014-12-10 16:30:00	MSFT	Stock	46.9	46.93	46.9	46.93	97625.0
2014-12-10 17:00:00	MSFT	Stock	46.9	46.9	46.9	46.9	2599.0
2014-12-10 17:30:00	MSFT	Stock	46.91	46.91	46.89	46.89	1002.0
2014-12-10 18:00:00	MSFT	Stock	47.245	47.245	46.9	46.9	68097.0

> showing 50 of 84,845 rows — these rows as CSV

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