PREVIEW / stock_30min / 2015-07-07

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-07.parquet
  size:    1.6 MB
  rows:    83,392
  symbols: 3,501

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-07-07 04:00:00	AAPL	Stock	31.61	31.7325	31.61	31.7	20400.0
2015-07-07 04:30:00	AAPL	Stock	31.74	31.7475	31.675	31.695	17200.0
2015-07-07 05:00:00	AAPL	Stock	31.6625	31.6675	31.6275	31.6275	10000.0
2015-07-07 05:30:00	AAPL	Stock	31.6725	31.6725	31.6	31.6025	14460.0
2015-07-07 06:00:00	AAPL	Stock	31.625	31.6275	31.6025	31.6025	4360.0
2015-07-07 06:30:00	AAPL	Stock	31.6	31.615	31.6	31.61	11084.0
2015-07-07 07:00:00	AAPL	Stock	31.595	31.595	31.5075	31.5325	56584.0
2015-07-07 07:30:00	AAPL	Stock	31.5425	31.57	31.4875	31.4875	29144.0
2015-07-07 08:00:00	AAPL	Stock	31.4875	31.575	31.4125	31.4675	296612.0
2015-07-07 08:30:00	AAPL	Stock	31.4575	31.595	31.455	31.5125	167052.0
2015-07-07 09:00:00	AAPL	Stock	31.5125	31.52	31.465	31.48	174304.0
2015-07-07 09:30:00	AAPL	Stock	31.485	31.5375	31.335	31.355	16543340.0
2015-07-07 10:00:00	AAPL	Stock	31.3525	31.36	31.2525	31.2562	13128288.0
2015-07-07 10:30:00	AAPL	Stock	31.2575	31.2752	31.0862	31.1615	20850084.0
2015-07-07 11:00:00	AAPL	Stock	31.1625	31.185	31.04	31.0525	12625640.0
2015-07-07 11:30:00	AAPL	Stock	31.0525	31.1775	30.9425	31.1308	18469972.0
2015-07-07 12:00:00	AAPL	Stock	31.1325	31.145	31.04	31.075	7610708.0
2015-07-07 12:30:00	AAPL	Stock	31.0725	31.2375	31.05	31.215	9527436.0
2015-07-07 13:00:00	AAPL	Stock	31.2175	31.325	31.1675	31.265	9105388.0
2015-07-07 13:30:00	AAPL	Stock	31.265	31.2725	31.2012	31.2325	7202584.0
2015-07-07 14:00:00	AAPL	Stock	31.2338	31.2725	31.1925	31.2332	5520340.0
2015-07-07 14:30:00	AAPL	Stock	31.2338	31.43	31.2238	31.4218	12251452.0
2015-07-07 15:00:00	AAPL	Stock	31.4212	31.4375	31.3675	31.4112	11863852.0
2015-07-07 15:30:00	AAPL	Stock	31.41	31.4325	31.3175	31.4225	15250604.0
2015-07-07 16:00:00	AAPL	Stock	31.4225	31.435	31.225	31.405	5531412.0
2015-07-07 16:30:00	AAPL	Stock	31.4225	31.4225	31.4	31.4	35676.0
2015-07-07 17:00:00	AAPL	Stock	31.4	31.405	31.36	31.365	44288.0
2015-07-07 17:30:00	AAPL	Stock	31.3992	31.4	31.3675	31.3775	19172.0
2015-07-07 18:00:00	AAPL	Stock	31.38	31.38	31.3525	31.3575	22740.0
2015-07-07 18:30:00	AAPL	Stock	31.3575	31.38	31.3575	31.38	32096.0
2015-07-07 19:00:00	AAPL	Stock	31.395	31.4225	31.34	31.35	549088.0
2015-07-07 19:30:00	AAPL	Stock	31.35	31.3618	31.3425	31.345	29504.0
2015-07-07 05:30:00	MSFT	Stock	44.82	44.82	44.82	44.82	300.0
2015-07-07 06:30:00	MSFT	Stock	44.51	44.51	44.5	44.5	800.0
2015-07-07 07:00:00	MSFT	Stock	44.5	44.5	44.5	44.5	500.0
2015-07-07 08:00:00	MSFT	Stock	44.5	44.55	44.5	44.55	500.0
2015-07-07 08:30:00	MSFT	Stock	44.56	45.66	44.5	44.62	27298.0
2015-07-07 09:00:00	MSFT	Stock	44.55	44.55	44.34	44.34	15777.0
2015-07-07 09:30:00	MSFT	Stock	44.38	44.49	43.85	43.89	4148311.0
2015-07-07 10:00:00	MSFT	Stock	43.885	43.94	43.77	43.805	3614614.0
2015-07-07 10:30:00	MSFT	Stock	43.81	43.84	43.64	43.655	3205452.0
2015-07-07 11:00:00	MSFT	Stock	43.66	43.68	43.44	43.46	3020918.0
2015-07-07 11:30:00	MSFT	Stock	43.47	43.75	43.32	43.64	2904498.0
2015-07-07 12:00:00	MSFT	Stock	43.64	43.69	43.52	43.55	1719901.0
2015-07-07 12:30:00	MSFT	Stock	43.55	44.03	43.53	43.98	2461346.0
2015-07-07 13:00:00	MSFT	Stock	43.985	44.19	43.975	43.993	1702286.0
2015-07-07 13:30:00	MSFT	Stock	44.0	44.03	43.925	43.95	1083764.0
2015-07-07 14:00:00	MSFT	Stock	43.95	44.0	43.85	43.885	996729.0
2015-07-07 14:30:00	MSFT	Stock	43.885	44.38	43.86	44.37	2001051.0
2015-07-07 15:00:00	MSFT	Stock	44.37	44.47	44.26	44.375	2377296.0

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

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