PREVIEW / stock_30min / 2016-06-20

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-20.parquet
  size:    1.6 MB
  rows:    82,767
  symbols: 3,295

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
2016-06-20 04:00:00	AAPL	Stock	23.8625	24.0875	23.8625	24.08	13624.0
2016-06-20 04:30:00	AAPL	Stock	24.075	24.0875	24.075	24.0875	4000.0
2016-06-20 05:00:00	AAPL	Stock	24.075	24.1	24.075	24.1	5504.0
2016-06-20 05:30:00	AAPL	Stock	24.095	24.0975	24.0825	24.0975	14064.0
2016-06-20 06:00:00	AAPL	Stock	24.0875	24.0875	24.065	24.075	15828.0
2016-06-20 06:30:00	AAPL	Stock	24.075	24.095	24.065	24.0875	14912.0
2016-06-20 07:00:00	AAPL	Stock	24.1	24.12	24.075	24.0825	92632.0
2016-06-20 07:30:00	AAPL	Stock	24.0825	24.1125	24.025	24.0475	121268.0
2016-06-20 08:00:00	AAPL	Stock	24.0475	24.1125	24.0	24.025	406432.0
2016-06-20 08:30:00	AAPL	Stock	24.025	24.0375	23.9825	23.9975	339684.0
2016-06-20 09:00:00	AAPL	Stock	23.99	24.0825	23.975	24.005	503104.0
2016-06-20 09:30:00	AAPL	Stock	24.005	24.1425	24.0	24.0725	23351132.0
2016-06-20 10:00:00	AAPL	Stock	24.075	24.1375	24.03	24.0575	12799096.0
2016-06-20 10:30:00	AAPL	Stock	24.06	24.095	24.055	24.0575	8673644.0
2016-06-20 11:00:00	AAPL	Stock	24.055	24.0622	23.99	23.9988	9006080.0
2016-06-20 11:30:00	AAPL	Stock	24.0	24.0015	23.905	23.9422	9138796.0
2016-06-20 12:00:00	AAPL	Stock	23.9422	23.99	23.935	23.985	6776468.0
2016-06-20 12:30:00	AAPL	Stock	23.985	23.9975	23.9575	23.9925	5018980.0
2016-06-20 13:00:00	AAPL	Stock	23.9925	24.01	23.9575	23.9775	5416680.0
2016-06-20 13:30:00	AAPL	Stock	23.9765	24.0175	23.965	23.9875	4424384.0
2016-06-20 14:00:00	AAPL	Stock	23.988	24.005	23.9375	23.945	4986072.0
2016-06-20 14:30:00	AAPL	Stock	23.945	23.995	23.94	23.9675	4867868.0
2016-06-20 15:00:00	AAPL	Stock	23.9675	23.9725	23.8175	23.8238	9578664.0
2016-06-20 15:30:00	AAPL	Stock	23.823	23.8825	23.7575	23.775	14711436.0
2016-06-20 16:00:00	AAPL	Stock	23.775	23.9725	23.7675	23.9725	6890732.0
2016-06-20 16:30:00	AAPL	Stock	23.775	23.845	23.7675	23.845	1596952.0
2016-06-20 17:00:00	AAPL	Stock	23.85	23.85	23.785	23.785	18184.0
2016-06-20 17:30:00	AAPL	Stock	23.785	23.825	23.78	23.8175	45932.0
2016-06-20 18:00:00	AAPL	Stock	23.8175	23.8175	23.7975	23.7975	61984.0
2016-06-20 18:30:00	AAPL	Stock	23.7975	23.8125	23.79	23.8125	15068.0
2016-06-20 19:00:00	AAPL	Stock	23.79	23.8125	23.79	23.8	9600.0
2016-06-20 19:30:00	AAPL	Stock	23.79	23.79	23.77	23.77	34996.0
2016-06-20 07:00:00	MSFT	Stock	50.6	50.61	50.6	50.61	700.0
2016-06-20 07:30:00	MSFT	Stock	50.7	50.7	50.7	50.7	2055.0
2016-06-20 08:00:00	MSFT	Stock	50.74	50.74	50.62	50.67	2993.0
2016-06-20 08:30:00	MSFT	Stock	50.62	50.67	50.62	50.62	4028.0
2016-06-20 09:00:00	MSFT	Stock	50.54	50.76	50.52	50.65	58318.0
2016-06-20 09:30:00	MSFT	Stock	50.64	50.83	50.48	50.595	4740454.0
2016-06-20 10:00:00	MSFT	Stock	50.59	50.645	50.47	50.471	3711811.0
2016-06-20 10:30:00	MSFT	Stock	50.48	50.56	50.43	50.485	3196534.0
2016-06-20 11:00:00	MSFT	Stock	50.48	50.72	50.48	50.71	2603256.0
2016-06-20 11:30:00	MSFT	Stock	50.71	50.73	50.46	50.55	1634653.0
2016-06-20 12:00:00	MSFT	Stock	50.54	50.55	50.37	50.46	1939922.0
2016-06-20 12:30:00	MSFT	Stock	50.47	50.59	50.46	50.55	1200089.0
2016-06-20 13:00:00	MSFT	Stock	50.54	50.605	50.47	50.56	1398208.0
2016-06-20 13:30:00	MSFT	Stock	50.55	50.65	50.51	50.595	876355.0
2016-06-20 14:00:00	MSFT	Stock	50.592	50.64	50.495	50.55	1211289.0
2016-06-20 14:30:00	MSFT	Stock	50.54	50.62	50.52	50.605	1385671.0
2016-06-20 15:00:00	MSFT	Stock	50.608	50.62	50.25	50.27	2440020.0
2016-06-20 15:30:00	MSFT	Stock	50.27	50.31	50.03	50.07	4254743.0

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

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