PREVIEW / stock_30min / 2016-03-18

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-18.parquet
  size:    1.6 MB
  rows:    83,316
  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-18 04:30:00	AAPL	Stock	26.48	26.48	26.48	26.48	440.0
2016-03-18 05:00:00	AAPL	Stock	26.48	26.48	26.48	26.48	2840.0
2016-03-18 06:00:00	AAPL	Stock	26.48	26.48	26.48	26.48	680.0
2016-03-18 06:30:00	AAPL	Stock	26.48	26.48	26.48	26.48	5468.0
2016-03-18 07:00:00	AAPL	Stock	26.48	26.6125	26.48	26.6	52404.0
2016-03-18 07:30:00	AAPL	Stock	26.5875	26.5875	26.5575	26.5625	25152.0
2016-03-18 08:00:00	AAPL	Stock	26.55	26.5825	26.5	26.5825	132744.0
2016-03-18 08:30:00	AAPL	Stock	26.5825	26.6	26.55	26.5675	90776.0
2016-03-18 09:00:00	AAPL	Stock	26.5625	26.6625	26.54	26.6	2375316.0
2016-03-18 09:30:00	AAPL	Stock	26.59	26.625	26.3528	26.3775	49355616.0
2016-03-18 10:00:00	AAPL	Stock	26.3752	26.4725	26.37	26.4325	8576264.0
2016-03-18 10:30:00	AAPL	Stock	26.4325	26.495	26.4025	26.4725	7008240.0
2016-03-18 11:00:00	AAPL	Stock	26.4725	26.533	26.465	26.4825	7012852.0
2016-03-18 11:30:00	AAPL	Stock	26.485	26.4975	26.425	26.4425	5622948.0
2016-03-18 12:00:00	AAPL	Stock	26.445	26.4725	26.415	26.4665	5406920.0
2016-03-18 12:30:00	AAPL	Stock	26.465	26.475	26.435	26.465	4384208.0
2016-03-18 13:00:00	AAPL	Stock	26.467	26.4675	26.425	26.4288	6085788.0
2016-03-18 13:30:00	AAPL	Stock	26.43	26.445	26.2975	26.4235	8243516.0
2016-03-18 14:00:00	AAPL	Stock	26.4225	26.4725	26.4025	26.4475	5631432.0
2016-03-18 14:30:00	AAPL	Stock	26.45	26.4725	26.4175	26.4275	4030224.0
2016-03-18 15:00:00	AAPL	Stock	26.43	26.5	26.4288	26.4638	6413420.0
2016-03-18 15:30:00	AAPL	Stock	26.465	26.495	26.4325	26.4775	16343668.0
2016-03-18 16:00:00	AAPL	Stock	26.48	26.4975	26.4688	26.475	22572012.0
2016-03-18 16:30:00	AAPL	Stock	26.475	26.4975	26.375	26.425	483956.0
2016-03-18 17:00:00	AAPL	Stock	26.4325	26.45	26.4125	26.42	29128.0
2016-03-18 17:30:00	AAPL	Stock	26.4225	26.48	26.4225	26.4375	2359240.0
2016-03-18 18:00:00	AAPL	Stock	26.4425	26.4625	26.4375	26.455	13320.0
2016-03-18 18:30:00	AAPL	Stock	26.4525	26.4525	26.4425	26.4425	16156.0
2016-03-18 19:00:00	AAPL	Stock	26.4425	26.46	26.4375	26.4525	24660.0
2016-03-18 19:30:00	AAPL	Stock	26.4425	26.4525	26.44	26.4425	25552.0
2016-03-18 07:30:00	MSFT	Stock	54.95	54.96	54.95	54.96	1498.0
2016-03-18 08:00:00	MSFT	Stock	54.75	54.8	54.7	54.7	1850.0
2016-03-18 08:30:00	MSFT	Stock	54.93	54.93	54.93	54.93	200.0
2016-03-18 09:00:00	MSFT	Stock	54.8	54.99	54.63	54.86	744095.0
2016-03-18 09:30:00	MSFT	Stock	54.85	54.97	53.8	54.029	16935629.0
2016-03-18 10:00:00	MSFT	Stock	54.02	54.22	53.81	53.87	3250976.0
2016-03-18 10:30:00	MSFT	Stock	53.88	54.07	53.85	54.015	2398250.0
2016-03-18 11:00:00	MSFT	Stock	54.01	54.35	54.0	54.215	2498937.0
2016-03-18 11:30:00	MSFT	Stock	54.215	54.23	54.04	54.15	1533867.0
2016-03-18 12:00:00	MSFT	Stock	54.15	54.165	53.92	53.92	1678538.0
2016-03-18 12:30:00	MSFT	Stock	53.928	54.06	53.855	54.06	1598652.0
2016-03-18 13:00:00	MSFT	Stock	54.055	54.06	53.71	53.735	1801362.0
2016-03-18 13:30:00	MSFT	Stock	53.73	53.745	53.465	53.575	2386613.0
2016-03-18 14:00:00	MSFT	Stock	53.58	53.69	53.53	53.56	1820799.0
2016-03-18 14:30:00	MSFT	Stock	53.566	53.69	53.445	53.615	1469199.0
2016-03-18 15:00:00	MSFT	Stock	53.62	53.898	53.615	53.68	2114652.0
2016-03-18 15:30:00	MSFT	Stock	53.685	53.81	53.48	53.49	6360780.0
2016-03-18 16:00:00	MSFT	Stock	53.49	54.001	53.4	53.49	17154727.0
2016-03-18 16:30:00	MSFT	Stock	53.49	53.49	53.36	53.41	72657.0
2016-03-18 17:00:00	MSFT	Stock	53.49	53.49	53.45	53.45	93510.0

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

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