PREVIEW / stock_30min / 2011-08-31

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-31.parquet
  size:    1.4 MB
  rows:    77,468
  symbols: 3,542

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-08-31 04:00:00	AAPL	Stock	13.9461	13.9804	13.9461	13.9804	16800.0
2011-08-31 05:00:00	AAPL	Stock	14.0079	14.0079	14.0079	14.0079	2800.0
2011-08-31 05:30:00	AAPL	Stock	14.0036	14.0039	14.0036	14.0039	8400.0
2011-08-31 06:00:00	AAPL	Stock	14.0039	14.0139	14.0039	14.0139	5600.0
2011-08-31 06:30:00	AAPL	Stock	14.0079	14.0079	14.0039	14.0039	17780.0
2011-08-31 07:00:00	AAPL	Stock	14.0	14.0	13.9482	13.9496	253820.0
2011-08-31 07:30:00	AAPL	Stock	13.9561	13.9811	13.9557	13.9579	374892.0
2011-08-31 08:00:00	AAPL	Stock	13.9586	13.9843	13.9396	13.9771	1909992.0
2011-08-31 08:30:00	AAPL	Stock	13.975	13.9811	13.9282	13.9761	1930068.0
2011-08-31 09:00:00	AAPL	Stock	13.9764	13.9843	13.9468	13.9518	1319752.0
2011-08-31 09:30:00	AAPL	Stock	13.9521	14.0029	13.9007	13.9189	66849076.0
2011-08-31 10:00:00	AAPL	Stock	13.9193	13.9554	13.8839	13.93	48264468.0
2011-08-31 10:30:00	AAPL	Stock	13.9293	13.9396	13.8747	13.8789	31109400.0
2011-08-31 11:00:00	AAPL	Stock	13.8791	13.9054	13.7975	13.825	39916632.0
2011-08-31 11:30:00	AAPL	Stock	13.8221	13.8292	13.7143	13.7146	48304228.0
2011-08-31 12:00:00	AAPL	Stock	13.7143	13.8282	13.7143	13.7986	33937400.0
2011-08-31 12:30:00	AAPL	Stock	13.7993	13.8304	13.7686	13.8004	20531588.0
2011-08-31 13:00:00	AAPL	Stock	13.7996	13.8118	13.7571	13.7661	16548532.0
2011-08-31 13:30:00	AAPL	Stock	13.7661	13.785	13.7189	13.72	20117300.0
2011-08-31 14:00:00	AAPL	Stock	13.719	13.7379	13.6736	13.7175	34829844.0
2011-08-31 14:30:00	AAPL	Stock	13.7175	13.73	13.655	13.6911	28607992.0
2011-08-31 15:00:00	AAPL	Stock	13.6907	13.7357	13.6379	13.6946	46287528.0
2011-08-31 15:30:00	AAPL	Stock	13.695	13.7482	13.6786	13.7432	53375168.0
2011-08-31 16:00:00	AAPL	Stock	13.7396	13.8864	13.7054	13.7439	22211700.0
2011-08-31 16:30:00	AAPL	Stock	13.7439	13.814	13.7165	13.75	781816.0
2011-08-31 17:00:00	AAPL	Stock	13.7518	13.7518	13.7286	13.7439	1478540.0
2011-08-31 17:30:00	AAPL	Stock	13.7375	13.7446	13.735	13.7446	173320.0
2011-08-31 18:00:00	AAPL	Stock	13.745	13.75	13.7396	13.7439	113820.0
2011-08-31 18:30:00	AAPL	Stock	13.7493	13.75	13.7446	13.7446	73920.0
2011-08-31 19:00:00	AAPL	Stock	13.7496	13.7536	13.7482	13.7518	43120.0
2011-08-31 19:30:00	AAPL	Stock	13.7518	13.7625	13.7518	13.7525	64120.0
2011-08-31 05:30:00	MSFT	Stock	26.27	26.3	26.27	26.3	700.0
2011-08-31 07:00:00	MSFT	Stock	26.26	26.31	26.16	26.25	5115.0
2011-08-31 07:30:00	MSFT	Stock	26.27	26.3	26.27	26.3	2105.0
2011-08-31 08:00:00	MSFT	Stock	26.27	26.36	26.27	26.36	11043.0
2011-08-31 08:30:00	MSFT	Stock	26.36	26.38	26.23	26.37	62217.0
2011-08-31 09:00:00	MSFT	Stock	26.36	26.38	26.28	26.31	52711.0
2011-08-31 09:30:00	MSFT	Stock	26.29	26.5	26.26	26.457	5845235.0
2011-08-31 10:00:00	MSFT	Stock	26.45	26.63	26.44	26.602	4533902.0
2011-08-31 10:30:00	MSFT	Stock	26.61	26.69	26.58	26.671	4551366.0
2011-08-31 11:00:00	MSFT	Stock	26.675	26.71	26.61	26.659	4728090.0
2011-08-31 11:30:00	MSFT	Stock	26.65	26.68	26.57	26.58	4235483.0
2011-08-31 12:00:00	MSFT	Stock	26.57	26.62	26.535	26.57	3090728.0
2011-08-31 12:30:00	MSFT	Stock	26.575	26.62	26.56	26.607	2021556.0
2011-08-31 13:00:00	MSFT	Stock	26.601	26.62	26.55	26.583	2201963.0
2011-08-31 13:30:00	MSFT	Stock	26.58	26.61	26.45	26.489	2982215.0
2011-08-31 14:00:00	MSFT	Stock	26.49	26.54	26.41	26.525	2493608.0
2011-08-31 14:30:00	MSFT	Stock	26.522	26.53	26.4	26.5	3106028.0
2011-08-31 15:00:00	MSFT	Stock	26.5	26.6	26.4	26.53	3281250.0
2011-08-31 15:30:00	MSFT	Stock	26.525	26.63	26.48	26.595	8699152.0

> showing 50 of 77,468 rows — these rows as CSV

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