PREVIEW / stock_30min / 2015-04-09

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-09.parquet
  size:    1.6 MB
  rows:    80,988
  symbols: 3,496

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-09 04:00:00	AAPL	Stock	31.4125	31.4125	31.4	31.4	27904.0
2015-04-09 04:30:00	AAPL	Stock	31.385	31.385	31.355	31.355	13880.0
2015-04-09 05:00:00	AAPL	Stock	31.3825	31.41	31.3825	31.41	800.0
2015-04-09 05:30:00	AAPL	Stock	31.38	31.38	31.38	31.38	800.0
2015-04-09 06:00:00	AAPL	Stock	31.4325	31.435	31.4	31.42	16632.0
2015-04-09 06:30:00	AAPL	Stock	31.4275	31.44	31.425	31.44	6000.0
2015-04-09 07:00:00	AAPL	Stock	31.45	31.5525	31.45	31.525	48220.0
2015-04-09 07:30:00	AAPL	Stock	31.525	31.55	31.5	31.5275	46648.0
2015-04-09 08:00:00	AAPL	Stock	31.5375	31.545	31.43	31.5175	311952.0
2015-04-09 08:30:00	AAPL	Stock	31.5325	31.54	31.4875	31.5075	184280.0
2015-04-09 09:00:00	AAPL	Stock	31.5125	31.52	31.45	31.465	307376.0
2015-04-09 09:30:00	AAPL	Stock	31.465	31.57	31.2675	31.3488	19741256.0
2015-04-09 10:00:00	AAPL	Stock	31.3525	31.4175	31.2825	31.3675	10274832.0
2015-04-09 10:30:00	AAPL	Stock	31.3725	31.3872	31.2375	31.3175	10361784.0
2015-04-09 11:00:00	AAPL	Stock	31.3175	31.3225	31.165	31.2588	10910460.0
2015-04-09 11:30:00	AAPL	Stock	31.2575	31.33	31.2425	31.32	5766024.0
2015-04-09 12:00:00	AAPL	Stock	31.3225	31.4175	31.2992	31.389	5547308.0
2015-04-09 12:30:00	AAPL	Stock	31.3925	31.4075	31.355	31.3612	3766460.0
2015-04-09 13:00:00	AAPL	Stock	31.3625	31.3775	31.325	31.3415	3305724.0
2015-04-09 13:30:00	AAPL	Stock	31.3412	31.349	31.285	31.322	4231312.0
2015-04-09 14:00:00	AAPL	Stock	31.321	31.345	31.3	31.3325	3169096.0
2015-04-09 14:30:00	AAPL	Stock	31.3325	31.475	31.3202	31.475	6092060.0
2015-04-09 15:00:00	AAPL	Stock	31.4725	31.6125	31.4525	31.6075	12673096.0
2015-04-09 15:30:00	AAPL	Stock	31.61	31.645	31.515	31.64	16129492.0
2015-04-09 16:00:00	AAPL	Stock	31.64	31.7025	31.6125	31.695	7212384.0
2015-04-09 16:30:00	AAPL	Stock	31.695	31.7125	31.69	31.7	314716.0
2015-04-09 17:00:00	AAPL	Stock	31.71	31.71	31.6775	31.68	92796.0
2015-04-09 17:30:00	AAPL	Stock	31.68	31.6975	31.675	31.68	136532.0
2015-04-09 18:00:00	AAPL	Stock	31.68	31.685	31.6625	31.67	24340.0
2015-04-09 18:30:00	AAPL	Stock	31.67	31.6875	31.67	31.6725	23232.0
2015-04-09 19:00:00	AAPL	Stock	31.6675	31.675	31.6625	31.6675	46012.0
2015-04-09 19:30:00	AAPL	Stock	31.6625	31.675	31.65	31.675	116420.0
2015-04-09 04:00:00	MSFT	Stock	41.45	41.45	41.45	41.45	200.0
2015-04-09 07:30:00	MSFT	Stock	41.38	41.38	41.38	41.38	400.0
2015-04-09 08:00:00	MSFT	Stock	41.4	41.4	41.32	41.32	1725.0
2015-04-09 08:30:00	MSFT	Stock	41.33	41.38	41.3	41.38	1850.0
2015-04-09 09:00:00	MSFT	Stock	41.25	41.3	41.08	41.17	7748.0
2015-04-09 09:30:00	MSFT	Stock	41.25	41.6	41.25	41.45	2828211.0
2015-04-09 10:00:00	MSFT	Stock	41.46	41.54	41.41	41.47	2189120.0
2015-04-09 10:30:00	MSFT	Stock	41.465	41.48	41.39	41.461	1778436.0
2015-04-09 11:00:00	MSFT	Stock	41.46	41.48	41.39	41.47	1620770.0
2015-04-09 11:30:00	MSFT	Stock	41.47	41.52	41.46	41.5	1069282.0
2015-04-09 12:00:00	MSFT	Stock	41.5	41.62	41.475	41.57	1322534.0
2015-04-09 12:30:00	MSFT	Stock	41.58	41.58	41.515	41.541	1033563.0
2015-04-09 13:00:00	MSFT	Stock	41.55	41.59	41.5	41.555	1245601.0
2015-04-09 13:30:00	MSFT	Stock	41.55	41.57	41.48	41.485	915709.0
2015-04-09 14:00:00	MSFT	Stock	41.485	41.51	41.42	41.445	1308326.0
2015-04-09 14:30:00	MSFT	Stock	41.445	41.5	41.42	41.45	1468994.0
2015-04-09 15:00:00	MSFT	Stock	41.456	41.55	41.415	41.52	2547598.0
2015-04-09 15:30:00	MSFT	Stock	41.525	41.53	41.42	41.48	3207292.0

> showing 50 of 80,988 rows — these rows as CSV

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