PREVIEW / stock_30min / 2015-04-27

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-27.parquet
  size:    1.6 MB
  rows:    83,815
  symbols: 3,524

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-04-27 04:00:00	AAPL	Stock	32.745	32.8	32.7	32.755	48208.0
2015-04-27 04:30:00	AAPL	Stock	32.765	32.775	32.7375	32.775	41136.0
2015-04-27 05:00:00	AAPL	Stock	32.775	32.775	32.7375	32.7375	51136.0
2015-04-27 05:30:00	AAPL	Stock	32.7375	32.77	32.735	32.77	27648.0
2015-04-27 06:00:00	AAPL	Stock	32.775	32.775	32.75	32.775	181720.0
2015-04-27 06:30:00	AAPL	Stock	32.775	32.7975	32.75	32.795	59596.0
2015-04-27 07:00:00	AAPL	Stock	32.795	32.8975	32.785	32.8475	515180.0
2015-04-27 07:30:00	AAPL	Stock	32.845	32.93	32.8375	32.9	269720.0
2015-04-27 08:00:00	AAPL	Stock	32.8975	33.12	32.625	33.1	2568124.0
2015-04-27 08:30:00	AAPL	Stock	33.09	33.11	33.0125	33.0125	1495072.0
2015-04-27 09:00:00	AAPL	Stock	33.0125	33.125	32.99	33.09	1709736.0
2015-04-27 09:30:00	AAPL	Stock	33.0775	33.25	33.0	33.244	50972336.0
2015-04-27 10:00:00	AAPL	Stock	33.245	33.2825	33.1425	33.1912	22598632.0
2015-04-27 10:30:00	AAPL	Stock	33.1918	33.23	33.165	33.1725	13614684.0
2015-04-27 11:00:00	AAPL	Stock	33.171	33.205	33.0875	33.18	15607412.0
2015-04-27 11:30:00	AAPL	Stock	33.185	33.205	33.14	33.1412	9677088.0
2015-04-27 12:00:00	AAPL	Stock	33.1412	33.2	33.13	33.1938	12243708.0
2015-04-27 12:30:00	AAPL	Stock	33.1932	33.23	33.1412	33.19	11309640.0
2015-04-27 13:00:00	AAPL	Stock	33.19	33.19	33.1075	33.18	12393268.0
2015-04-27 13:30:00	AAPL	Stock	33.1825	33.1875	33.0275	33.0625	12704228.0
2015-04-27 14:00:00	AAPL	Stock	33.0625	33.1125	32.7875	32.885	29285988.0
2015-04-27 14:30:00	AAPL	Stock	32.8838	32.9425	32.81	32.8975	18691964.0
2015-04-27 15:00:00	AAPL	Stock	32.8975	33.0025	32.8	32.9975	26103844.0
2015-04-27 15:30:00	AAPL	Stock	32.9975	33.1725	32.975	33.1725	42149016.0
2015-04-27 16:00:00	AAPL	Stock	33.1625	33.33	33.125	33.315	17482240.0
2015-04-27 16:30:00	AAPL	Stock	33.32	34.0	32.4775	33.6625	32684076.0
2015-04-27 17:00:00	AAPL	Stock	33.6625	33.815	33.57	33.6	7381628.0
2015-04-27 17:30:00	AAPL	Stock	33.59	33.6875	33.5325	33.6075	2664772.0
2015-04-27 18:00:00	AAPL	Stock	33.6	33.6125	33.5625	33.605	1525824.0
2015-04-27 18:30:00	AAPL	Stock	33.6025	33.655	33.59	33.61	896848.0
2015-04-27 19:00:00	AAPL	Stock	33.6	33.6075	33.56	33.565	503212.0
2015-04-27 19:30:00	AAPL	Stock	33.5625	33.6075	33.55	33.605	881308.0
2015-04-27 04:00:00	MSFT	Stock	48.5	48.5	47.59	47.69	2700.0
2015-04-27 04:30:00	MSFT	Stock	47.64	47.65	47.58	47.65	5230.0
2015-04-27 05:00:00	MSFT	Stock	47.57	47.57	47.57	47.57	750.0
2015-04-27 05:30:00	MSFT	Stock	47.59	47.65	47.5	47.57	2421.0
2015-04-27 06:00:00	MSFT	Stock	47.58	47.62	47.58	47.6	1778.0
2015-04-27 06:30:00	MSFT	Stock	47.63	47.71	47.6	47.6	18850.0
2015-04-27 07:00:00	MSFT	Stock	47.65	47.7	47.6	47.62	18303.0
2015-04-27 07:30:00	MSFT	Stock	47.61	47.67	47.61	47.67	12907.0
2015-04-27 08:00:00	MSFT	Stock	47.66	47.73	47.54	47.54	32831.0
2015-04-27 08:30:00	MSFT	Stock	47.54	47.87	47.51	47.55	48707.0
2015-04-27 09:00:00	MSFT	Stock	47.55	47.7	47.21	47.31	238370.0
2015-04-27 09:30:00	MSFT	Stock	47.23	47.7	47.2	47.665	8822189.0
2015-04-27 10:00:00	MSFT	Stock	47.66	47.74	47.41	47.48	4789926.0
2015-04-27 10:30:00	MSFT	Stock	47.48	47.57	47.28	47.54	4190372.0
2015-04-27 11:00:00	MSFT	Stock	47.55	47.78	47.49	47.645	3503005.0
2015-04-27 11:30:00	MSFT	Stock	47.64	47.88	47.64	47.81	3678118.0
2015-04-27 12:00:00	MSFT	Stock	47.817	48.07	47.785	48.055	3840889.0
2015-04-27 12:30:00	MSFT	Stock	48.06	48.13	47.72	47.755	3429575.0

> showing 50 of 83,815 rows — these rows as CSV

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