PREVIEW / stock_30min / 2013-05-10

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-10.parquet
  size:    1.5 MB
  rows:    77,046
  symbols: 3,510

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
2013-05-10 04:30:00	AAPL	Stock	16.3332	16.3482	16.3332	16.3336	103600.0
2013-05-10 05:00:00	AAPL	Stock	16.3336	16.3336	16.3336	16.3336	5600.0
2013-05-10 06:30:00	AAPL	Stock	16.3339	16.3339	16.3339	16.3339	2800.0
2013-05-10 07:00:00	AAPL	Stock	16.3471	16.4086	16.3396	16.3929	402444.0
2013-05-10 07:30:00	AAPL	Stock	16.3761	16.3761	16.3414	16.3571	120960.0
2013-05-10 08:00:00	AAPL	Stock	16.375	16.4089	16.3404	16.3625	843360.0
2013-05-10 08:30:00	AAPL	Stock	16.3625	16.3661	16.3432	16.3536	362516.0
2013-05-10 09:00:00	AAPL	Stock	16.35	16.3625	16.3446	16.355	962528.0
2013-05-10 09:30:00	AAPL	Stock	16.3554	16.4182	16.2696	16.3094	55456016.0
2013-05-10 10:00:00	AAPL	Stock	16.3082	16.35	16.1639	16.1904	45897040.0
2013-05-10 10:30:00	AAPL	Stock	16.1906	16.1914	16.0886	16.1361	51568832.0
2013-05-10 11:00:00	AAPL	Stock	16.1371	16.2107	16.125	16.1675	26501524.0
2013-05-10 11:30:00	AAPL	Stock	16.1693	16.2021	16.1429	16.1442	16129680.0
2013-05-10 12:00:00	AAPL	Stock	16.1439	16.165	16.1221	16.1417	15236788.0
2013-05-10 12:30:00	AAPL	Stock	16.1411	16.1554	16.1164	16.1282	9007796.0
2013-05-10 13:00:00	AAPL	Stock	16.1282	16.165	16.1242	16.1504	12440456.0
2013-05-10 13:30:00	AAPL	Stock	16.1507	16.1554	16.1186	16.1268	10102316.0
2013-05-10 14:00:00	AAPL	Stock	16.1268	16.1654	16.1239	16.1595	10997952.0
2013-05-10 14:30:00	AAPL	Stock	16.1596	16.1857	16.1479	16.1689	14816060.0
2013-05-10 15:00:00	AAPL	Stock	16.1689	16.1725	16.14	16.1464	13046348.0
2013-05-10 15:30:00	AAPL	Stock	16.1457	16.1782	16.1021	16.1743	35975744.0
2013-05-10 16:00:00	AAPL	Stock	16.1775	16.2014	16.1695	16.1857	11227328.0
2013-05-10 16:30:00	AAPL	Stock	16.1807	16.1964	16.166	16.1893	529452.0
2013-05-10 17:00:00	AAPL	Stock	16.1882	16.1889	16.1804	16.1804	56952.0
2013-05-10 17:30:00	AAPL	Stock	16.1825	16.1825	16.1793	16.1804	63336.0
2013-05-10 18:00:00	AAPL	Stock	16.1789	16.1829	16.1768	16.1829	84028.0
2013-05-10 18:30:00	AAPL	Stock	16.1771	16.1871	16.1768	16.1871	69076.0
2013-05-10 19:00:00	AAPL	Stock	16.1829	16.1989	16.1829	16.1964	54992.0
2013-05-10 19:30:00	AAPL	Stock	16.1964	16.2032	16.1929	16.1982	114520.0
2013-05-10 08:00:00	MSFT	Stock	32.6	32.65	32.6	32.65	4300.0
2013-05-10 08:30:00	MSFT	Stock	32.61	32.62	32.57	32.57	5900.0
2013-05-10 09:00:00	MSFT	Stock	32.56	32.62	32.56	32.57	13000.0
2013-05-10 09:30:00	MSFT	Stock	32.67	32.67	32.32	32.555	5077516.0
2013-05-10 10:00:00	MSFT	Stock	32.55	32.72	32.55	32.6	3546036.0
2013-05-10 10:30:00	MSFT	Stock	32.59	32.66	32.485	32.621	3166737.0
2013-05-10 11:00:00	MSFT	Stock	32.62	32.64	32.545	32.59	2186783.0
2013-05-10 11:30:00	MSFT	Stock	32.585	32.61	32.51	32.56	2833013.0
2013-05-10 12:00:00	MSFT	Stock	32.56	32.64	32.54	32.605	1655992.0
2013-05-10 12:30:00	MSFT	Stock	32.6	32.63	32.57	32.59	1241597.0
2013-05-10 13:00:00	MSFT	Stock	32.6	32.64	32.59	32.622	1158729.0
2013-05-10 13:30:00	MSFT	Stock	32.63	32.65	32.59	32.63	1256391.0
2013-05-10 14:00:00	MSFT	Stock	32.625	32.65	32.61	32.626	1290624.0
2013-05-10 14:30:00	MSFT	Stock	32.62	32.65	32.58	32.6	1373916.0
2013-05-10 15:00:00	MSFT	Stock	32.6	32.65	32.57	32.63	1812385.0
2013-05-10 15:30:00	MSFT	Stock	32.625	32.69	32.59	32.686	5480585.0
2013-05-10 16:00:00	MSFT	Stock	32.68	32.72	32.6	32.69	2581422.0
2013-05-10 16:30:00	MSFT	Stock	32.696	32.72	32.59	32.69	26911.0
2013-05-10 17:00:00	MSFT	Stock	32.69	32.69	32.69	32.69	11493.0
2013-05-10 17:30:00	MSFT	Stock	32.73	32.73	32.71	32.72	740.0
2013-05-10 18:30:00	MSFT	Stock	32.71	32.71	32.71	32.71	130.0

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

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