PREVIEW / stock_30min / 2012-10-31

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-31.parquet
  size:    1.4 MB
  rows:    75,959
  symbols: 3,495

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-10-31 04:30:00	AAPL	Stock	21.5357	21.5357	21.5357	21.5357	8456.0
2012-10-31 05:30:00	AAPL	Stock	21.5482	21.5689	21.5482	21.5689	12880.0
2012-10-31 06:00:00	AAPL	Stock	21.5482	21.5482	21.5157	21.5357	14700.0
2012-10-31 06:30:00	AAPL	Stock	21.5536	21.5536	21.5536	21.5536	17164.0
2012-10-31 07:00:00	AAPL	Stock	21.5289	21.5289	21.3754	21.4286	763840.0
2012-10-31 07:30:00	AAPL	Stock	21.4289	21.4586	21.3929	21.4179	256956.0
2012-10-31 08:00:00	AAPL	Stock	21.4161	21.4232	21.2975	21.3089	1295252.0
2012-10-31 08:30:00	AAPL	Stock	21.3036	21.3318	21.2921	21.3214	1720516.0
2012-10-31 09:00:00	AAPL	Stock	21.325	21.3343	21.2211	21.2211	1407812.0
2012-10-31 09:30:00	AAPL	Stock	21.2211	21.25	20.9893	21.1246	114044364.0
2012-10-31 10:00:00	AAPL	Stock	21.1246	21.2014	21.0193	21.1964	47630548.0
2012-10-31 10:30:00	AAPL	Stock	21.1964	21.1964	21.0714	21.1339	31724000.0
2012-10-31 11:00:00	AAPL	Stock	21.1382	21.3018	21.0714	21.2596	36328404.0
2012-10-31 11:30:00	AAPL	Stock	21.26	21.3393	21.151	21.1853	28947968.0
2012-10-31 12:00:00	AAPL	Stock	21.1771	21.2593	21.1036	21.1804	22553384.0
2012-10-31 12:30:00	AAPL	Stock	21.1765	21.3161	21.1739	21.3004	19061952.0
2012-10-31 13:00:00	AAPL	Stock	21.3004	21.3089	21.2143	21.285	16871596.0
2012-10-31 13:30:00	AAPL	Stock	21.285	21.3036	21.2514	21.2893	12307764.0
2012-10-31 14:00:00	AAPL	Stock	21.2921	21.4254	21.2857	21.4018	32467428.0
2012-10-31 14:30:00	AAPL	Stock	21.4018	21.4986	21.3621	21.3932	32870432.0
2012-10-31 15:00:00	AAPL	Stock	21.4004	21.4286	21.2754	21.3754	30344916.0
2012-10-31 15:30:00	AAPL	Stock	21.3764	21.3814	21.2007	21.2586	47740980.0
2012-10-31 16:00:00	AAPL	Stock	21.2536	21.4686	21.0	21.2439	16159080.0
2012-10-31 16:30:00	AAPL	Stock	21.2439	21.377	21.1989	21.2036	536872.0
2012-10-31 17:00:00	AAPL	Stock	21.2143	21.2614	21.2107	21.2182	206388.0
2012-10-31 17:30:00	AAPL	Stock	21.2304	21.2446	21.2257	21.2257	100156.0
2012-10-31 18:00:00	AAPL	Stock	21.2275	21.2304	21.2086	21.2275	80640.0
2012-10-31 18:30:00	AAPL	Stock	21.2332	21.2332	21.2071	21.2179	155008.0
2012-10-31 19:00:00	AAPL	Stock	21.2107	21.2232	21.2093	21.2186	98140.0
2012-10-31 19:30:00	AAPL	Stock	21.2143	21.2196	21.2071	21.2139	112308.0
2012-10-31 05:30:00	MSFT	Stock	28.55	28.57	28.55	28.57	700.0
2012-10-31 06:00:00	MSFT	Stock	28.63	28.63	28.56	28.56	11909.0
2012-10-31 06:30:00	MSFT	Stock	28.54	28.56	28.52	28.52	400.0
2012-10-31 07:00:00	MSFT	Stock	28.52	28.55	28.5	28.55	5200.0
2012-10-31 07:30:00	MSFT	Stock	28.56	28.61	28.54	28.55	5294.0
2012-10-31 08:00:00	MSFT	Stock	28.55	28.57	28.43	28.43	36335.0
2012-10-31 08:30:00	MSFT	Stock	28.43	28.45	28.37	28.43	13342.0
2012-10-31 09:00:00	MSFT	Stock	28.45	28.55	28.45	28.53	32427.0
2012-10-31 09:30:00	MSFT	Stock	28.53	28.88	28.5	28.725	9466698.0
2012-10-31 10:00:00	MSFT	Stock	28.72	28.77	28.63	28.66	5252565.0
2012-10-31 10:30:00	MSFT	Stock	28.66	28.69	28.6	28.63	6273109.0
2012-10-31 11:00:00	MSFT	Stock	28.63	28.66	28.57	28.65	6132923.0
2012-10-31 11:30:00	MSFT	Stock	28.65	28.7	28.61	28.68	4649012.0
2012-10-31 12:00:00	MSFT	Stock	28.67	28.68	28.6	28.615	4270622.0
2012-10-31 12:30:00	MSFT	Stock	28.615	28.63	28.56	28.59	3306033.0
2012-10-31 13:00:00	MSFT	Stock	28.59	28.63	28.58	28.62	2887262.0
2012-10-31 13:30:00	MSFT	Stock	28.62	28.64	28.56	28.6	2148050.0
2012-10-31 14:00:00	MSFT	Stock	28.598	28.61	28.56	28.59	2510164.0
2012-10-31 14:30:00	MSFT	Stock	28.6	28.6	28.52	28.54	4444573.0
2012-10-31 15:00:00	MSFT	Stock	28.532	28.63	28.51	28.58	4715500.0

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

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