PREVIEW / stock_30min / 2016-03-28

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-28.parquet
  size:    1.5 MB
  rows:    80,490
  symbols: 3,350

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-03-28 04:00:00	AAPL	Stock	26.375	26.375	26.375	26.375	400.0
2016-03-28 04:30:00	AAPL	Stock	26.47	26.475	26.415	26.415	1808.0
2016-03-28 06:30:00	AAPL	Stock	26.475	26.4925	26.475	26.4925	4800.0
2016-03-28 07:00:00	AAPL	Stock	26.4775	26.57	26.4775	26.545	33052.0
2016-03-28 07:30:00	AAPL	Stock	26.545	26.545	26.4875	26.4875	11944.0
2016-03-28 08:00:00	AAPL	Stock	26.4875	26.57	26.455	26.5	66944.0
2016-03-28 08:30:00	AAPL	Stock	26.4975	26.5125	26.48	26.485	60412.0
2016-03-28 09:00:00	AAPL	Stock	26.495	26.56	26.485	26.4875	218560.0
2016-03-28 09:30:00	AAPL	Stock	26.5	26.5475	26.305	26.3925	12049180.0
2016-03-28 10:00:00	AAPL	Stock	26.39	26.48	26.3425	26.4225	6577464.0
2016-03-28 10:30:00	AAPL	Stock	26.4225	26.4675	26.3575	26.3888	4223332.0
2016-03-28 11:00:00	AAPL	Stock	26.3875	26.405	26.345	26.3775	3632408.0
2016-03-28 11:30:00	AAPL	Stock	26.3775	26.44	26.355	26.4362	3420676.0
2016-03-28 12:00:00	AAPL	Stock	26.4388	26.4475	26.3475	26.36	3257416.0
2016-03-28 12:30:00	AAPL	Stock	26.36	26.39	26.3475	26.3778	3491692.0
2016-03-28 13:00:00	AAPL	Stock	26.3788	26.385	26.315	26.325	3194152.0
2016-03-28 13:30:00	AAPL	Stock	26.3262	26.3675	26.3125	26.35	3464504.0
2016-03-28 14:00:00	AAPL	Stock	26.3525	26.3775	26.33	26.3625	3408224.0
2016-03-28 14:30:00	AAPL	Stock	26.3625	26.3625	26.2875	26.33	3366308.0
2016-03-28 15:00:00	AAPL	Stock	26.33	26.37	26.3188	26.33	3800820.0
2016-03-28 15:30:00	AAPL	Stock	26.33	26.345	26.265	26.2975	9283896.0
2016-03-28 16:00:00	AAPL	Stock	26.2975	26.3275	26.2625	26.27	6461828.0
2016-03-28 16:30:00	AAPL	Stock	26.275	26.285	26.2475	26.285	134464.0
2016-03-28 17:00:00	AAPL	Stock	26.2825	26.29	26.27	26.29	13036.0
2016-03-28 17:30:00	AAPL	Stock	26.29	26.3	26.265	26.2775	66968.0
2016-03-28 18:00:00	AAPL	Stock	26.2825	26.2825	26.2625	26.2675	20892.0
2016-03-28 18:30:00	AAPL	Stock	26.27	26.275	26.2675	26.275	20604.0
2016-03-28 19:00:00	AAPL	Stock	26.275	26.2775	26.275	26.275	13872.0
2016-03-28 19:30:00	AAPL	Stock	26.275	26.28	26.275	26.275	26232.0
2016-03-28 04:00:00	MSFT	Stock	54.4	54.4	54.4	54.4	600.0
2016-03-28 06:00:00	MSFT	Stock	54.49	54.49	54.49	54.49	195.0
2016-03-28 08:00:00	MSFT	Stock	54.4	54.4	54.34	54.34	300.0
2016-03-28 08:30:00	MSFT	Stock	54.34	54.34	54.26	54.27	3200.0
2016-03-28 09:00:00	MSFT	Stock	54.28	54.31	54.21	54.21	17597.0
2016-03-28 09:30:00	MSFT	Stock	54.24	54.29	53.705	53.78	1737083.0
2016-03-28 10:00:00	MSFT	Stock	53.77	53.83	53.65	53.83	1041862.0
2016-03-28 10:30:00	MSFT	Stock	53.82	53.83	53.61	53.705	740469.0
2016-03-28 11:00:00	MSFT	Stock	53.71	53.81	53.6	53.715	752458.0
2016-03-28 11:30:00	MSFT	Stock	53.715	53.76	53.665	53.68	676895.0
2016-03-28 12:00:00	MSFT	Stock	53.69	53.72	53.62	53.704	529340.0
2016-03-28 12:30:00	MSFT	Stock	53.706	53.805	53.7	53.705	954322.0
2016-03-28 13:00:00	MSFT	Stock	53.708	53.708	53.51	53.514	753737.0
2016-03-28 13:30:00	MSFT	Stock	53.51	53.6	53.48	53.58	810335.0
2016-03-28 14:00:00	MSFT	Stock	53.59	53.71	53.56	53.56	843356.0
2016-03-28 14:30:00	MSFT	Stock	53.56	53.59	53.33	53.424	1206512.0
2016-03-28 15:00:00	MSFT	Stock	53.42	53.53	53.41	53.44	987371.0
2016-03-28 15:30:00	MSFT	Stock	53.44	53.57	53.38	53.54	2636069.0
2016-03-28 16:00:00	MSFT	Stock	53.54	53.58	53.54	53.58	2108558.0
2016-03-28 16:30:00	MSFT	Stock	53.57	53.57	53.54	53.56	11500.0
2016-03-28 17:00:00	MSFT	Stock	53.56	53.56	53.56	53.56	125.0

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

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