PREVIEW / stock_30min / 2014-11-26

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-26.parquet
  size:    1.6 MB
  rows:    81,922
  symbols: 3,567

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-11-26 04:00:00	AAPL	Stock	29.5	29.555	29.5	29.51	21440.0
2014-11-26 04:30:00	AAPL	Stock	29.5125	29.515	29.5	29.5	19640.0
2014-11-26 05:00:00	AAPL	Stock	29.4975	29.5	29.475	29.5	4200.0
2014-11-26 05:30:00	AAPL	Stock	29.4875	29.5025	29.4675	29.475	10980.0
2014-11-26 06:00:00	AAPL	Stock	29.465	29.495	29.4625	29.495	46392.0
2014-11-26 06:30:00	AAPL	Stock	29.49	29.5	29.4875	29.5	11460.0
2014-11-26 07:00:00	AAPL	Stock	29.4925	29.5	29.475	29.4775	81444.0
2014-11-26 07:30:00	AAPL	Stock	29.475	29.505	29.455	29.465	112628.0
2014-11-26 08:00:00	AAPL	Stock	29.485	29.59	29.4	29.5275	502700.0
2014-11-26 08:30:00	AAPL	Stock	29.515	29.56	29.475	29.535	351604.0
2014-11-26 09:00:00	AAPL	Stock	29.52	29.5375	29.465	29.48	249804.0
2014-11-26 09:30:00	AAPL	Stock	29.4825	29.7475	29.4575	29.6882	28367296.0
2014-11-26 10:00:00	AAPL	Stock	29.6888	29.775	29.61	29.757	16844592.0
2014-11-26 10:30:00	AAPL	Stock	29.755	29.765	29.6415	29.68	12296180.0
2014-11-26 11:00:00	AAPL	Stock	29.6782	29.755	29.6782	29.7072	9782864.0
2014-11-26 11:30:00	AAPL	Stock	29.705	29.72	29.58	29.595	8577064.0
2014-11-26 12:00:00	AAPL	Stock	29.5975	29.6325	29.53	29.535	8885048.0
2014-11-26 12:30:00	AAPL	Stock	29.535	29.685	29.525	29.635	8457820.0
2014-11-26 13:00:00	AAPL	Stock	29.6375	29.7025	29.635	29.6425	4396644.0
2014-11-26 13:30:00	AAPL	Stock	29.645	29.655	29.5925	29.5975	5841008.0
2014-11-26 14:00:00	AAPL	Stock	29.6025	29.6525	29.5975	29.63	4921412.0
2014-11-26 14:30:00	AAPL	Stock	29.6312	29.655	29.6275	29.64	4668036.0
2014-11-26 15:00:00	AAPL	Stock	29.64	29.6875	29.62	29.684	5966108.0
2014-11-26 15:30:00	AAPL	Stock	29.685	29.76	29.68	29.7475	18521332.0
2014-11-26 16:00:00	AAPL	Stock	29.75	29.7525	29.6642	29.7475	12476764.0
2014-11-26 16:30:00	AAPL	Stock	29.7475	29.76	29.7475	29.755	114000.0
2014-11-26 17:00:00	AAPL	Stock	29.7575	29.765	29.7525	29.765	113384.0
2014-11-26 17:30:00	AAPL	Stock	29.765	29.775	29.7575	29.7725	46228.0
2014-11-26 18:00:00	AAPL	Stock	29.775	29.785	29.7725	29.78	59096.0
2014-11-26 18:30:00	AAPL	Stock	29.78	29.7825	29.78	29.78	40236.0
2014-11-26 19:00:00	AAPL	Stock	29.78	29.785	29.765	29.785	29296.0
2014-11-26 19:30:00	AAPL	Stock	29.7825	29.7875	29.7775	29.785	97948.0
2014-11-26 04:00:00	MSFT	Stock	47.53	47.53	47.53	47.53	200.0
2014-11-26 06:00:00	MSFT	Stock	47.49	47.49	47.49	47.49	200.0
2014-11-26 07:30:00	MSFT	Stock	47.55	47.55	47.55	47.55	100.0
2014-11-26 08:00:00	MSFT	Stock	47.6	47.6	47.52	47.52	1600.0
2014-11-26 08:30:00	MSFT	Stock	47.52	47.52	47.49	47.5	5157.0
2014-11-26 09:00:00	MSFT	Stock	47.5	47.5	47.48	47.49	907.0
2014-11-26 09:30:00	MSFT	Stock	47.49	47.51	47.28	47.3	2919106.0
2014-11-26 10:00:00	MSFT	Stock	47.31	47.39	47.28	47.37	1943338.0
2014-11-26 10:30:00	MSFT	Stock	47.37	47.485	47.35	47.455	2019347.0
2014-11-26 11:00:00	MSFT	Stock	47.46	47.565	47.44	47.49	1860703.0
2014-11-26 11:30:00	MSFT	Stock	47.485	47.55	47.44	47.53	1354146.0
2014-11-26 12:00:00	MSFT	Stock	47.53	47.86	47.5	47.85	1401852.0
2014-11-26 12:30:00	MSFT	Stock	47.85	47.94	47.81	47.9	1544295.0
2014-11-26 13:00:00	MSFT	Stock	47.9	47.91	47.82	47.87	854728.0
2014-11-26 13:30:00	MSFT	Stock	47.87	47.99	47.87	47.96	849380.0
2014-11-26 14:00:00	MSFT	Stock	47.97	47.98	47.91	47.96	730821.0
2014-11-26 14:30:00	MSFT	Stock	47.96	47.98	47.82	47.825	984489.0
2014-11-26 15:00:00	MSFT	Stock	47.82	47.84	47.79	47.818	1165571.0

> showing 50 of 81,922 rows — these rows as CSV

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