PREVIEW / stock_30min / 2015-05-06

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-06.parquet
  size:    1.6 MB
  rows:    83,708
  symbols: 3,520

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-05-06 04:00:00	AAPL	Stock	31.495	31.5125	31.4625	31.465	33464.0
2015-05-06 04:30:00	AAPL	Stock	31.5	31.53	31.5	31.53	23980.0
2015-05-06 05:00:00	AAPL	Stock	31.54	31.54	31.54	31.54	944.0
2015-05-06 05:30:00	AAPL	Stock	31.5575	31.5675	31.555	31.5675	15188.0
2015-05-06 06:00:00	AAPL	Stock	31.55	31.5625	31.54	31.55	13068.0
2015-05-06 06:30:00	AAPL	Stock	31.545	31.5525	31.5225	31.5325	29508.0
2015-05-06 07:00:00	AAPL	Stock	31.545	31.575	31.5325	31.5725	108208.0
2015-05-06 07:30:00	AAPL	Stock	31.575	31.7	31.575	31.6875	415736.0
2015-05-06 08:00:00	AAPL	Stock	31.6825	31.7275	31.5325	31.6775	749432.0
2015-05-06 08:30:00	AAPL	Stock	31.6725	31.7275	31.65	31.6575	451764.0
2015-05-06 09:00:00	AAPL	Stock	31.67	31.7	31.45	31.6875	422120.0
2015-05-06 09:30:00	AAPL	Stock	31.64	31.6875	31.0675	31.13	46500132.0
2015-05-06 10:00:00	AAPL	Stock	31.13	31.135	30.84	31.0175	42991048.0
2015-05-06 10:30:00	AAPL	Stock	31.0225	31.3475	30.9525	31.325	28267548.0
2015-05-06 11:00:00	AAPL	Stock	31.3275	31.4475	31.205	31.325	20058396.0
2015-05-06 11:30:00	AAPL	Stock	31.3152	31.365	31.2175	31.295	9887136.0
2015-05-06 12:00:00	AAPL	Stock	31.295	31.2975	31.11	31.155	10440628.0
2015-05-06 12:30:00	AAPL	Stock	31.1575	31.1825	31.0575	31.0925	7468032.0
2015-05-06 13:00:00	AAPL	Stock	31.094	31.1075	30.99	31.01	9537612.0
2015-05-06 13:30:00	AAPL	Stock	31.01	31.03	30.905	31.0	11866792.0
2015-05-06 14:00:00	AAPL	Stock	31.0012	31.035	30.92	30.985	11691900.0
2015-05-06 14:30:00	AAPL	Stock	30.985	31.01	30.905	31.006	13048492.0
2015-05-06 15:00:00	AAPL	Stock	31.005	31.135	30.965	31.135	16336032.0
2015-05-06 15:30:00	AAPL	Stock	31.1325	31.2825	31.0812	31.2712	25802676.0
2015-05-06 16:00:00	AAPL	Stock	31.2725	31.361	31.153	31.2775	4866396.0
2015-05-06 16:30:00	AAPL	Stock	31.2778	31.295	31.15	31.295	81324.0
2015-05-06 17:00:00	AAPL	Stock	31.2875	31.2975	31.28	31.2925	48288.0
2015-05-06 17:30:00	AAPL	Stock	31.2925	31.295	31.285	31.285	19256.0
2015-05-06 18:00:00	AAPL	Stock	31.285	31.295	31.2775	31.285	75604.0
2015-05-06 18:30:00	AAPL	Stock	31.285	31.3	31.2825	31.295	82832.0
2015-05-06 19:00:00	AAPL	Stock	31.29	31.3125	31.2875	31.295	57204.0
2015-05-06 19:30:00	AAPL	Stock	31.295	31.3125	31.2775	31.3125	50012.0
2015-05-06 06:00:00	MSFT	Stock	47.71	47.71	47.71	47.71	1000.0
2015-05-06 06:30:00	MSFT	Stock	47.6	47.63	47.51	47.51	700.0
2015-05-06 07:00:00	MSFT	Stock	47.59	47.6	47.59	47.6	3000.0
2015-05-06 07:30:00	MSFT	Stock	47.57	47.69	47.57	47.69	9010.0
2015-05-06 08:00:00	MSFT	Stock	47.66	47.75	47.52	47.65	31034.0
2015-05-06 08:30:00	MSFT	Stock	47.65	47.7	47.6	47.629	14937.0
2015-05-06 09:00:00	MSFT	Stock	47.64	47.7	47.45	47.45	58631.0
2015-05-06 09:30:00	MSFT	Stock	47.57	47.77	46.85	46.91	6467771.0
2015-05-06 10:00:00	MSFT	Stock	46.92	46.945	46.63	46.759	5134209.0
2015-05-06 10:30:00	MSFT	Stock	46.76	46.85	46.58	46.69	3137750.0
2015-05-06 11:00:00	MSFT	Stock	46.69	46.8	46.57	46.715	3107256.0
2015-05-06 11:30:00	MSFT	Stock	46.72	46.84	46.68	46.81	2756114.0
2015-05-06 12:00:00	MSFT	Stock	46.81	46.82	46.68	46.72	1734659.0
2015-05-06 12:30:00	MSFT	Stock	46.715	46.77	46.6	46.627	2246991.0
2015-05-06 13:00:00	MSFT	Stock	46.63	46.81	46.6	46.6	1502081.0
2015-05-06 13:30:00	MSFT	Stock	46.6	46.63	46.36	46.48	2411401.0
2015-05-06 14:00:00	MSFT	Stock	46.49	46.51	46.25	46.34	2899514.0
2015-05-06 14:30:00	MSFT	Stock	46.34	46.35	46.09	46.215	3963829.0

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

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