PREVIEW / stock_30min / 2012-05-29

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-29.parquet
  size:    1.4 MB
  rows:    75,406
  symbols: 3,528

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
2012-05-29 04:00:00	AAPL	Stock	20.29	20.3304	20.29	20.3304	8400.0
2012-05-29 04:30:00	AAPL	Stock	20.33	20.3304	20.33	20.3304	19880.0
2012-05-29 05:30:00	AAPL	Stock	20.2929	20.2929	20.2321	20.2321	32200.0
2012-05-29 06:00:00	AAPL	Stock	20.1857	20.1857	20.1857	20.1857	5600.0
2012-05-29 06:30:00	AAPL	Stock	20.2004	20.2004	20.2004	20.2004	4620.0
2012-05-29 07:00:00	AAPL	Stock	20.2071	20.2407	20.2071	20.2386	107100.0
2012-05-29 07:30:00	AAPL	Stock	20.2264	20.2571	20.2221	20.2489	253540.0
2012-05-29 08:00:00	AAPL	Stock	20.2364	20.2889	20.2179	20.2668	1437380.0
2012-05-29 08:30:00	AAPL	Stock	20.2671	20.3011	20.2671	20.3	670096.0
2012-05-29 09:00:00	AAPL	Stock	20.3025	20.3896	20.2789	20.3807	2478952.0
2012-05-29 09:30:00	AAPL	Stock	20.3868	20.3929	20.2261	20.2936	61406520.0
2012-05-29 10:00:00	AAPL	Stock	20.2836	20.4807	20.2371	20.4389	57734180.0
2012-05-29 10:30:00	AAPL	Stock	20.4439	20.5	20.3932	20.4361	33145364.0
2012-05-29 11:00:00	AAPL	Stock	20.4361	20.4529	20.3689	20.45	18691036.0
2012-05-29 11:30:00	AAPL	Stock	20.4486	20.4486	20.2786	20.2854	29818460.0
2012-05-29 12:00:00	AAPL	Stock	20.2814	20.3157	20.1896	20.2939	26659612.0
2012-05-29 12:30:00	AAPL	Stock	20.2982	20.3475	20.2512	20.3071	15198680.0
2012-05-29 13:00:00	AAPL	Stock	20.3079	20.3421	20.2736	20.2864	13481972.0
2012-05-29 13:30:00	AAPL	Stock	20.2819	20.3696	20.2357	20.3496	16994768.0
2012-05-29 14:00:00	AAPL	Stock	20.3504	20.3918	20.3243	20.3711	15797040.0
2012-05-29 14:30:00	AAPL	Stock	20.3671	20.4257	20.3293	20.4019	15643320.0
2012-05-29 15:00:00	AAPL	Stock	20.4043	20.4225	20.3575	20.3857	16584176.0
2012-05-29 15:30:00	AAPL	Stock	20.3871	20.4586	20.3396	20.4379	41028316.0
2012-05-29 16:00:00	AAPL	Stock	20.4382	20.4518	20.3543	20.4404	7799568.0
2012-05-29 16:30:00	AAPL	Stock	20.4396	20.4607	20.3803	20.4589	366744.0
2012-05-29 17:00:00	AAPL	Stock	20.4579	20.4589	20.3687	20.4536	574700.0
2012-05-29 17:30:00	AAPL	Stock	20.4404	20.4464	20.4393	20.4464	46172.0
2012-05-29 18:00:00	AAPL	Stock	20.4457	20.4482	20.4386	20.4482	107772.0
2012-05-29 18:30:00	AAPL	Stock	20.4464	20.4464	20.4343	20.4346	148008.0
2012-05-29 19:00:00	AAPL	Stock	20.4321	20.4321	20.4064	20.4064	206668.0
2012-05-29 19:30:00	AAPL	Stock	20.4096	20.4196	20.4096	20.4196	95396.0
2012-05-29 07:30:00	MSFT	Stock	29.2	29.2	29.2	29.2	200.0
2012-05-29 08:00:00	MSFT	Stock	29.28	29.31	29.21	29.24	33260.0
2012-05-29 08:30:00	MSFT	Stock	29.3	29.35	29.24	29.31	12315.0
2012-05-29 09:00:00	MSFT	Stock	29.3	29.43	29.3	29.42	31040.0
2012-05-29 09:30:00	MSFT	Stock	29.38	29.47	29.22	29.41	4072634.0
2012-05-29 10:00:00	MSFT	Stock	29.41	29.7	29.37	29.65	4712675.0
2012-05-29 10:30:00	MSFT	Stock	29.657	29.72	29.57	29.61	2315460.0
2012-05-29 11:00:00	MSFT	Stock	29.61	29.62	29.5	29.54	1447283.0
2012-05-29 11:30:00	MSFT	Stock	29.54	29.55	29.33	29.406	2992099.0
2012-05-29 12:00:00	MSFT	Stock	29.4	29.42	29.28	29.38	2896641.0
2012-05-29 12:30:00	MSFT	Stock	29.38	29.41	29.29	29.37	1358123.0
2012-05-29 13:00:00	MSFT	Stock	29.37	29.42	29.33	29.33	1455322.0
2012-05-29 13:30:00	MSFT	Stock	29.33	29.395	29.32	29.38	1574715.0
2012-05-29 14:00:00	MSFT	Stock	29.373	29.46	29.35	29.39	1625427.0
2012-05-29 14:30:00	MSFT	Stock	29.39	29.5	29.37	29.47	1384568.0
2012-05-29 15:00:00	MSFT	Stock	29.475	29.53	29.44	29.45	2055343.0
2012-05-29 15:30:00	MSFT	Stock	29.46	29.64	29.44	29.55	7224854.0
2012-05-29 16:00:00	MSFT	Stock	29.56	29.67	29.451	29.65	1937636.0
2012-05-29 16:30:00	MSFT	Stock	29.441	29.45	29.441	29.45	21000.0

> showing 50 of 75,406 rows — these rows as CSV

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