PREVIEW / stock_30min / 2014-02-14

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-14.parquet
  size:    1.6 MB
  rows:    80,776
  symbols: 3,536

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
2014-02-14 04:00:00	AAPL	Stock	19.4432	19.4461	19.4432	19.4461	5600.0
2014-02-14 06:30:00	AAPL	Stock	19.45	19.4821	19.45	19.4821	25200.0
2014-02-14 07:00:00	AAPL	Stock	19.4857	19.5364	19.4804	19.4804	183932.0
2014-02-14 07:30:00	AAPL	Stock	19.4807	19.5071	19.4732	19.4839	166796.0
2014-02-14 08:00:00	AAPL	Stock	19.4793	19.5493	19.4664	19.4821	641676.0
2014-02-14 08:30:00	AAPL	Stock	19.4821	19.4911	19.4668	19.4668	422688.0
2014-02-14 09:00:00	AAPL	Stock	19.4679	19.4761	19.3589	19.37	1199044.0
2014-02-14 09:30:00	AAPL	Stock	19.3889	19.4993	19.3611	19.4268	52005072.0
2014-02-14 10:00:00	AAPL	Stock	19.4311	19.4586	19.3779	19.42	18918144.0
2014-02-14 10:30:00	AAPL	Stock	19.4232	19.4336	19.3289	19.3582	24954776.0
2014-02-14 11:00:00	AAPL	Stock	19.3571	19.4407	19.3496	19.4336	14443352.0
2014-02-14 11:30:00	AAPL	Stock	19.4355	19.4614	19.4179	19.4429	13314756.0
2014-02-14 12:00:00	AAPL	Stock	19.4411	19.445	19.3814	19.3861	10085684.0
2014-02-14 12:30:00	AAPL	Stock	19.3864	19.3979	19.3571	19.3693	10608388.0
2014-02-14 13:00:00	AAPL	Stock	19.3686	19.4286	19.3661	19.3986	9883412.0
2014-02-14 13:30:00	AAPL	Stock	19.4007	19.4189	19.3941	19.4071	6434848.0
2014-02-14 14:00:00	AAPL	Stock	19.4064	19.45	19.4061	19.4302	9193800.0
2014-02-14 14:30:00	AAPL	Stock	19.4297	19.4561	19.4229	19.4286	8855364.0
2014-02-14 15:00:00	AAPL	Stock	19.4293	19.4318	19.3821	19.3907	15681568.0
2014-02-14 15:30:00	AAPL	Stock	19.3907	19.4286	19.3786	19.4243	24831604.0
2014-02-14 16:00:00	AAPL	Stock	19.4282	19.4425	19.409	19.4425	8651944.0
2014-02-14 16:30:00	AAPL	Stock	19.4361	19.4536	19.4282	19.4536	419328.0
2014-02-14 17:00:00	AAPL	Stock	19.4536	19.4571	19.4464	19.4504	101696.0
2014-02-14 17:30:00	AAPL	Stock	19.4411	19.4411	19.4282	19.4393	63980.0
2014-02-14 18:00:00	AAPL	Stock	19.4386	19.4429	19.4386	19.4429	10864.0
2014-02-14 18:30:00	AAPL	Stock	19.4439	19.4454	19.4354	19.4446	42616.0
2014-02-14 19:00:00	AAPL	Stock	19.4375	19.4375	19.4286	19.4286	32508.0
2014-02-14 19:30:00	AAPL	Stock	19.4304	19.4446	19.4304	19.4446	72716.0
2014-02-14 07:00:00	MSFT	Stock	37.54	37.54	37.54	37.54	508.0
2014-02-14 08:00:00	MSFT	Stock	37.53	37.57	37.52	37.57	1980.0
2014-02-14 08:30:00	MSFT	Stock	37.57	37.57	37.54	37.57	550.0
2014-02-14 09:00:00	MSFT	Stock	37.62	37.62	37.35	37.39	16587.0
2014-02-14 09:30:00	MSFT	Stock	37.39	37.555	37.33	37.45	5195452.0
2014-02-14 10:00:00	MSFT	Stock	37.45	37.64	37.43	37.54	2647838.0
2014-02-14 10:30:00	MSFT	Stock	37.547	37.56	37.41	37.46	1948390.0
2014-02-14 11:00:00	MSFT	Stock	37.46	37.66	37.45	37.66	1433909.0
2014-02-14 11:30:00	MSFT	Stock	37.65	37.68	37.6	37.635	1351270.0
2014-02-14 12:00:00	MSFT	Stock	37.64	37.65	37.59	37.64	1042379.0
2014-02-14 12:30:00	MSFT	Stock	37.634	37.68	37.58	37.655	1795140.0
2014-02-14 13:00:00	MSFT	Stock	37.65	37.68	37.59	37.6	1276531.0
2014-02-14 13:30:00	MSFT	Stock	37.6	37.68	37.58	37.65	1312290.0
2014-02-14 14:00:00	MSFT	Stock	37.66	37.68	37.65	37.65	934259.0
2014-02-14 14:30:00	MSFT	Stock	37.65	37.78	37.65	37.775	1483762.0
2014-02-14 15:00:00	MSFT	Stock	37.77	37.78	37.66	37.7	1582371.0
2014-02-14 15:30:00	MSFT	Stock	37.705	37.71	37.58	37.61	3557373.0
2014-02-14 16:00:00	MSFT	Stock	37.62	37.67	37.554	37.62	3153576.0
2014-02-14 16:30:00	MSFT	Stock	37.6	37.683	37.56	37.59	70322.0
2014-02-14 17:00:00	MSFT	Stock	37.676	37.676	37.676	37.676	560.0
2014-02-14 18:00:00	MSFT	Stock	37.62	37.62	37.62	37.62	392.0
2014-02-14 18:30:00	MSFT	Stock	37.65	37.65	37.65	37.65	608.0

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

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