PREVIEW / stock_30min / 2015-10-20

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-20.parquet
  size:    1.5 MB
  rows:    80,065
  symbols: 3,423

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-10-20 04:30:00	AAPL	Stock	27.8325	27.8325	27.8125	27.8125	1200.0
2015-10-20 05:00:00	AAPL	Stock	27.805	27.805	27.805	27.805	1200.0
2015-10-20 06:00:00	AAPL	Stock	27.8675	27.8675	27.8675	27.8675	800.0
2015-10-20 06:30:00	AAPL	Stock	27.8625	27.865	27.8625	27.865	2596.0
2015-10-20 07:00:00	AAPL	Stock	27.8675	27.885	27.8575	27.875	15936.0
2015-10-20 07:30:00	AAPL	Stock	27.87	27.9	27.87	27.8925	14692.0
2015-10-20 08:00:00	AAPL	Stock	27.8825	28.04	27.8675	28.02	306932.0
2015-10-20 08:30:00	AAPL	Stock	28.04	28.05	28.005	28.0375	282124.0
2015-10-20 09:00:00	AAPL	Stock	28.0375	28.085	27.685	27.7925	2635344.0
2015-10-20 09:30:00	AAPL	Stock	27.835	28.085	27.705	28.045	24629448.0
2015-10-20 10:00:00	AAPL	Stock	28.045	28.4075	28.0375	28.3705	32019736.0
2015-10-20 10:30:00	AAPL	Stock	28.37	28.4738	28.3525	28.43	18228660.0
2015-10-20 11:00:00	AAPL	Stock	28.4298	28.445	28.29	28.4225	13949820.0
2015-10-20 11:30:00	AAPL	Stock	28.4225	28.4825	28.3375	28.4125	12593644.0
2015-10-20 12:00:00	AAPL	Stock	28.4078	28.5425	28.3825	28.49	13913364.0
2015-10-20 12:30:00	AAPL	Stock	28.4885	28.5175	28.3875	28.512	9783020.0
2015-10-20 13:00:00	AAPL	Stock	28.51	28.5112	28.3725	28.3975	8580224.0
2015-10-20 13:30:00	AAPL	Stock	28.395	28.4375	28.35	28.424	6725076.0
2015-10-20 14:00:00	AAPL	Stock	28.4225	28.475	28.3875	28.4588	5382396.0
2015-10-20 14:30:00	AAPL	Stock	28.4575	28.475	28.405	28.425	7058900.0
2015-10-20 15:00:00	AAPL	Stock	28.425	28.4825	28.38	28.4635	7398448.0
2015-10-20 15:30:00	AAPL	Stock	28.4625	28.4825	28.4	28.45	14808272.0
2015-10-20 16:00:00	AAPL	Stock	28.4425	28.4625	28.35	28.35	6634948.0
2015-10-20 16:30:00	AAPL	Stock	28.355	28.4425	28.3425	28.365	153800.0
2015-10-20 17:00:00	AAPL	Stock	28.3775	28.3875	28.35	28.3875	21264.0
2015-10-20 17:30:00	AAPL	Stock	28.3975	28.4	28.39	28.4	26924.0
2015-10-20 18:00:00	AAPL	Stock	28.3975	28.4025	28.37	28.3775	5544.0
2015-10-20 18:30:00	AAPL	Stock	28.3875	28.395	28.3675	28.3825	11184.0
2015-10-20 19:00:00	AAPL	Stock	28.3825	28.4	28.3825	28.4	16752.0
2015-10-20 19:30:00	AAPL	Stock	28.4	28.405	28.385	28.385	33808.0
2015-10-20 07:00:00	MSFT	Stock	47.55	47.55	47.55	47.55	600.0
2015-10-20 07:30:00	MSFT	Stock	47.55	47.55	47.55	47.55	400.0
2015-10-20 08:00:00	MSFT	Stock	47.55	47.6	47.5	47.6	3290.0
2015-10-20 08:30:00	MSFT	Stock	47.59	47.6	47.54	47.54	6778.0
2015-10-20 09:00:00	MSFT	Stock	47.5	47.59	47.43	47.44	41581.0
2015-10-20 09:30:00	MSFT	Stock	47.47	47.54	47.02	47.485	5085956.0
2015-10-20 10:00:00	MSFT	Stock	47.49	47.575	47.46	47.53	1779684.0
2015-10-20 10:30:00	MSFT	Stock	47.525	47.55	47.35	47.49	1994880.0
2015-10-20 11:00:00	MSFT	Stock	47.485	47.49	47.25	47.418	1681150.0
2015-10-20 11:30:00	MSFT	Stock	47.42	47.69	47.37	47.64	1716091.0
2015-10-20 12:00:00	MSFT	Stock	47.64	47.79	47.5	47.65	1384810.0
2015-10-20 12:30:00	MSFT	Stock	47.65	47.74	47.53	47.717	1183002.0
2015-10-20 13:00:00	MSFT	Stock	47.71	47.77	47.6	47.655	893013.0
2015-10-20 13:30:00	MSFT	Stock	47.65	47.7	47.6	47.645	1283324.0
2015-10-20 14:00:00	MSFT	Stock	47.645	47.76	47.63	47.755	1079444.0
2015-10-20 14:30:00	MSFT	Stock	47.75	47.78	47.7	47.725	1437668.0
2015-10-20 15:00:00	MSFT	Stock	47.727	47.75	47.62	47.694	1801807.0
2015-10-20 15:30:00	MSFT	Stock	47.7	47.81	47.56	47.77	4502502.0
2015-10-20 16:00:00	MSFT	Stock	47.77	47.8	47.68	47.77	3482289.0
2015-10-20 16:30:00	MSFT	Stock	47.72	47.77	47.72	47.73	50335.0

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

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