PREVIEW / stock_30min / 2011-10-06

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-06.parquet
  size:    1.4 MB
  rows:    73,546
  symbols: 3,473

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
2011-10-06 07:00:00	AAPL	Stock	13.2143	13.4286	13.2143	13.3921	4572204.0
2011-10-06 07:30:00	AAPL	Stock	13.3875	13.3875	13.3214	13.3268	3133116.0
2011-10-06 08:00:00	AAPL	Stock	13.3039	13.4189	13.2639	13.3857	10991568.0
2011-10-06 08:30:00	AAPL	Stock	13.3886	13.4761	13.3661	13.4643	9133376.0
2011-10-06 09:00:00	AAPL	Stock	13.4646	13.4696	13.3271	13.3289	10697540.0
2011-10-06 09:30:00	AAPL	Stock	13.3354	13.5268	13.3064	13.4564	135628108.0
2011-10-06 10:00:00	AAPL	Stock	13.4621	13.6786	13.4196	13.6532	100587368.0
2011-10-06 10:30:00	AAPL	Stock	13.6532	13.7421	13.62	13.6214	70306292.0
2011-10-06 11:00:00	AAPL	Stock	13.6225	13.7086	13.5854	13.6525	41134996.0
2011-10-06 11:30:00	AAPL	Stock	13.6525	13.6943	13.6168	13.6318	27626536.0
2011-10-06 12:00:00	AAPL	Stock	13.6322	13.6761	13.6232	13.6586	20887384.0
2011-10-06 12:30:00	AAPL	Stock	13.6557	13.6693	13.4521	13.4646	56146272.0
2011-10-06 13:00:00	AAPL	Stock	13.4643	13.5168	13.3621	13.3653	45208884.0
2011-10-06 13:30:00	AAPL	Stock	13.3679	13.4211	13.2787	13.4066	66222492.0
2011-10-06 14:00:00	AAPL	Stock	13.4043	13.5018	13.3639	13.4373	47996368.0
2011-10-06 14:30:00	AAPL	Stock	13.4382	13.4629	13.3571	13.4475	34042876.0
2011-10-06 15:00:00	AAPL	Stock	13.4529	13.4993	13.3596	13.3861	49345800.0
2011-10-06 15:30:00	AAPL	Stock	13.3861	13.4914	13.3768	13.4754	56234248.0
2011-10-06 16:00:00	AAPL	Stock	13.4736	13.5386	13.3895	13.4571	10041108.0
2011-10-06 16:30:00	AAPL	Stock	13.4557	13.4657	13.4554	13.4636	375284.0
2011-10-06 17:00:00	AAPL	Stock	13.4625	13.4775	13.4593	13.4593	166460.0
2011-10-06 17:30:00	AAPL	Stock	13.4593	13.5089	13.42	13.4264	676060.0
2011-10-06 18:00:00	AAPL	Stock	13.4286	13.4775	13.41	13.4286	201460.0
2011-10-06 18:30:00	AAPL	Stock	13.4339	13.4554	13.4339	13.4375	50344.0
2011-10-06 19:00:00	AAPL	Stock	13.4411	13.4425	13.4304	13.4304	35140.0
2011-10-06 19:30:00	AAPL	Stock	13.4286	13.4536	13.4171	13.4464	90216.0
2011-10-06 07:00:00	MSFT	Stock	26.08	26.08	26.03	26.07	1300.0
2011-10-06 07:30:00	MSFT	Stock	26.0	26.06	26.0	26.0	5100.0
2011-10-06 08:00:00	MSFT	Stock	26.0	26.06	26.0	26.03	15872.0
2011-10-06 08:30:00	MSFT	Stock	26.03	26.09	25.99	26.0	21340.0
2011-10-06 09:00:00	MSFT	Stock	26.02	26.02	25.88	25.9	88242.0
2011-10-06 09:30:00	MSFT	Stock	25.91	25.98	25.7	25.92	6488892.0
2011-10-06 10:00:00	MSFT	Stock	25.92	26.08	25.87	26.024	4397272.0
2011-10-06 10:30:00	MSFT	Stock	26.03	26.19	26.015	26.07	3585777.0
2011-10-06 11:00:00	MSFT	Stock	26.07	26.24	26.02	26.22	3167344.0
2011-10-06 11:30:00	MSFT	Stock	26.22	26.29	26.15	26.21	2626384.0
2011-10-06 12:00:00	MSFT	Stock	26.2	26.3	26.17	26.3	2195598.0
2011-10-06 12:30:00	MSFT	Stock	26.295	26.34	26.26	26.29	2917874.0
2011-10-06 13:00:00	MSFT	Stock	26.29	26.325	26.215	26.23	2033620.0
2011-10-06 13:30:00	MSFT	Stock	26.23	26.37	26.21	26.312	2472904.0
2011-10-06 14:00:00	MSFT	Stock	26.32	26.4	26.28	26.372	2312001.0
2011-10-06 14:30:00	MSFT	Stock	26.37	26.4	26.2	26.23	3362827.0
2011-10-06 15:00:00	MSFT	Stock	26.24	26.27	26.14	26.152	3640036.0
2011-10-06 15:30:00	MSFT	Stock	26.145	26.36	26.13	26.35	9618606.0
2011-10-06 16:00:00	MSFT	Stock	26.34	26.38	26.155	26.34	5514498.0
2011-10-06 16:30:00	MSFT	Stock	26.24	26.34	26.14	26.27	18425.0
2011-10-06 17:00:00	MSFT	Stock	26.27	26.34	26.24	26.24	11328.0
2011-10-06 17:30:00	MSFT	Stock	26.26	26.26	25.89	26.24	22857.0
2011-10-06 18:00:00	MSFT	Stock	26.34	26.34	26.25	26.25	25008.0
2011-10-06 18:30:00	MSFT	Stock	26.23	26.23	26.23	26.23	200.0

> showing 50 of 73,546 rows — these rows as CSV

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