PREVIEW / stock_30min / 2014-06-16

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-16.parquet
  size:    1.6 MB
  rows:    81,596
  symbols: 3,543

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-06-16 04:00:00	AAPL	Stock	22.85	22.85	22.725	22.725	12400.0
2014-06-16 04:30:00	AAPL	Stock	22.7375	22.82	22.7375	22.82	9748.0
2014-06-16 05:00:00	AAPL	Stock	22.7625	22.7625	22.7625	22.7625	1464.0
2014-06-16 05:30:00	AAPL	Stock	22.825	22.825	22.825	22.825	8000.0
2014-06-16 06:00:00	AAPL	Stock	22.8025	22.825	22.8025	22.815	6280.0
2014-06-16 06:30:00	AAPL	Stock	22.8375	22.8625	22.8375	22.84	18800.0
2014-06-16 07:00:00	AAPL	Stock	22.8625	22.8725	22.8475	22.85	47968.0
2014-06-16 07:30:00	AAPL	Stock	22.8625	22.87	22.8575	22.8625	17300.0
2014-06-16 08:00:00	AAPL	Stock	22.8575	22.91	22.805	22.87	414460.0
2014-06-16 08:30:00	AAPL	Stock	22.87	22.925	22.87	22.9125	260440.0
2014-06-16 09:00:00	AAPL	Stock	22.9125	22.925	22.8725	22.89	418004.0
2014-06-16 09:30:00	AAPL	Stock	22.8875	23.0625	22.8625	23.0325	26403116.0
2014-06-16 10:00:00	AAPL	Stock	23.035	23.1875	23.0345	23.095	18323068.0
2014-06-16 10:30:00	AAPL	Stock	23.095	23.1455	23.0625	23.12	9341832.0
2014-06-16 11:00:00	AAPL	Stock	23.1175	23.1225	22.9475	22.9925	12293912.0
2014-06-16 11:30:00	AAPL	Stock	22.99	23.0075	22.935	23.0045	8196884.0
2014-06-16 12:00:00	AAPL	Stock	23.004	23.065	22.9875	23.045	6703248.0
2014-06-16 12:30:00	AAPL	Stock	23.045	23.065	23.0125	23.0197	4077312.0
2014-06-16 13:00:00	AAPL	Stock	23.0175	23.05	22.995	23.01	4999448.0
2014-06-16 13:30:00	AAPL	Stock	23.0118	23.0425	22.9275	22.9575	5306224.0
2014-06-16 14:00:00	AAPL	Stock	22.955	23.01	22.95	23.01	5275800.0
2014-06-16 14:30:00	AAPL	Stock	23.0098	23.075	23.0	23.025	6299200.0
2014-06-16 15:00:00	AAPL	Stock	23.0225	23.0325	22.9725	22.9875	5339168.0
2014-06-16 15:30:00	AAPL	Stock	22.9875	23.0625	22.9775	23.0425	11542216.0
2014-06-16 16:00:00	AAPL	Stock	23.05	23.07	23.04	23.06	5847464.0
2014-06-16 16:30:00	AAPL	Stock	23.06	23.0675	23.0575	23.0575	61980.0
2014-06-16 17:00:00	AAPL	Stock	23.0625	23.0675	23.0575	23.0675	36632.0
2014-06-16 17:30:00	AAPL	Stock	23.0675	23.0875	23.0675	23.0775	38392.0
2014-06-16 18:00:00	AAPL	Stock	23.0825	23.0825	23.0725	23.0825	62600.0
2014-06-16 18:30:00	AAPL	Stock	23.0825	23.0825	23.075	23.075	28848.0
2014-06-16 19:00:00	AAPL	Stock	23.075	23.0775	23.075	23.075	23548.0
2014-06-16 19:30:00	AAPL	Stock	23.075	23.0775	23.0675	23.0675	51236.0
2014-06-16 07:00:00	MSFT	Stock	41.39	41.4	41.38	41.4	1000.0
2014-06-16 08:00:00	MSFT	Stock	41.25	41.25	41.25	41.25	125.0
2014-06-16 08:30:00	MSFT	Stock	41.19	41.24	41.19	41.24	2760.0
2014-06-16 09:00:00	MSFT	Stock	41.24	41.24	41.01	41.04	31560.0
2014-06-16 09:30:00	MSFT	Stock	41.04	41.45	41.04	41.448	3284782.0
2014-06-16 10:00:00	MSFT	Stock	41.44	41.597	41.41	41.55	1845435.0
2014-06-16 10:30:00	MSFT	Stock	41.545	41.59	41.53	41.55	1374933.0
2014-06-16 11:00:00	MSFT	Stock	41.55	41.55	41.27	41.285	1172164.0
2014-06-16 11:30:00	MSFT	Stock	41.28	41.29	41.16	41.274	1021032.0
2014-06-16 12:00:00	MSFT	Stock	41.27	41.525	41.265	41.5	1011084.0
2014-06-16 12:30:00	MSFT	Stock	41.501	41.51	41.31	41.4	635971.0
2014-06-16 13:00:00	MSFT	Stock	41.395	41.53	41.37	41.52	797233.0
2014-06-16 13:30:00	MSFT	Stock	41.53	41.55	41.38	41.42	967801.0
2014-06-16 14:00:00	MSFT	Stock	41.415	41.58	41.38	41.57	1151755.0
2014-06-16 14:30:00	MSFT	Stock	41.57	41.61	41.53	41.54	1142562.0
2014-06-16 15:00:00	MSFT	Stock	41.53	41.55	41.43	41.43	1520983.0
2014-06-16 15:30:00	MSFT	Stock	41.43	41.52	41.43	41.49	3461087.0
2014-06-16 16:00:00	MSFT	Stock	41.5	41.51	41.46	41.5	3518858.0

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

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