PREVIEW / stock_30min / 2013-08-13

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-13.parquet
  size:    1.5 MB
  rows:    79,892
  symbols: 3,512

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-08-13 04:30:00	AAPL	Stock	16.76	16.76	16.7579	16.7579	8400.0
2013-08-13 05:00:00	AAPL	Stock	16.7571	16.7857	16.75	16.7857	70000.0
2013-08-13 05:30:00	AAPL	Stock	16.7664	16.7679	16.7571	16.7571	38360.0
2013-08-13 06:00:00	AAPL	Stock	16.7571	16.7571	16.7536	16.7571	25200.0
2013-08-13 06:30:00	AAPL	Stock	16.7661	16.7679	16.7557	16.7557	29344.0
2013-08-13 07:00:00	AAPL	Stock	16.7643	16.7964	16.7589	16.7711	272552.0
2013-08-13 07:30:00	AAPL	Stock	16.7714	16.7857	16.7679	16.7736	350308.0
2013-08-13 08:00:00	AAPL	Stock	16.7736	16.8161	16.7593	16.8	2014852.0
2013-08-13 08:30:00	AAPL	Stock	16.7971	16.8157	16.7893	16.8107	974288.0
2013-08-13 09:00:00	AAPL	Stock	16.8121	16.8318	16.8082	16.82	1663536.0
2013-08-13 09:30:00	AAPL	Stock	16.82	16.9389	16.7864	16.8446	80536848.0
2013-08-13 10:00:00	AAPL	Stock	16.8436	16.8482	16.7161	16.8332	52754996.0
2013-08-13 10:30:00	AAPL	Stock	16.8304	16.8746	16.81	16.8421	21664076.0
2013-08-13 11:00:00	AAPL	Stock	16.8421	16.9026	16.8321	16.8931	17223528.0
2013-08-13 11:30:00	AAPL	Stock	16.8931	16.9154	16.8779	16.8809	15067808.0
2013-08-13 12:00:00	AAPL	Stock	16.8807	16.9607	16.8665	16.9595	23366392.0
2013-08-13 12:30:00	AAPL	Stock	16.9607	16.9636	16.925	16.9377	20247164.0
2013-08-13 13:00:00	AAPL	Stock	16.9375	16.9821	16.9279	16.9789	19309976.0
2013-08-13 13:30:00	AAPL	Stock	16.9782	16.9911	16.9432	16.9704	16131500.0
2013-08-13 14:00:00	AAPL	Stock	16.9704	17.3089	16.97	17.2393	127584184.0
2013-08-13 14:30:00	AAPL	Stock	17.2393	17.4532	17.2364	17.4262	192346560.0
2013-08-13 15:00:00	AAPL	Stock	17.4264	17.6414	17.4079	17.6186	133855624.0
2013-08-13 15:30:00	AAPL	Stock	17.6207	17.6664	17.4286	17.4904	132659940.0
2013-08-13 16:00:00	AAPL	Stock	17.4884	17.4986	16.7634	17.4893	13406876.0
2013-08-13 16:30:00	AAPL	Stock	17.4893	17.6162	17.4864	17.5236	700028.0
2013-08-13 17:00:00	AAPL	Stock	17.525	17.5643	17.4846	17.5621	2547496.0
2013-08-13 17:30:00	AAPL	Stock	17.5607	17.5693	17.4846	17.5682	655172.0
2013-08-13 18:00:00	AAPL	Stock	17.5696	17.6125	17.5657	17.6014	911736.0
2013-08-13 18:30:00	AAPL	Stock	17.6032	17.6107	17.5857	17.6089	584528.0
2013-08-13 19:00:00	AAPL	Stock	17.6068	17.6354	17.6	17.6239	970452.0
2013-08-13 19:30:00	AAPL	Stock	17.6239	17.655	17.6186	17.6357	933128.0
2013-08-13 04:00:00	MSFT	Stock	32.87	32.87	32.87	32.87	100.0
2013-08-13 05:00:00	MSFT	Stock	32.81	32.81	32.7	32.7	1700.0
2013-08-13 05:30:00	MSFT	Stock	32.75	32.75	32.75	32.75	610.0
2013-08-13 06:00:00	MSFT	Stock	32.72	32.72	32.61	32.68	13469.0
2013-08-13 06:30:00	MSFT	Stock	32.75	32.75	32.63	32.63	3700.0
2013-08-13 07:00:00	MSFT	Stock	32.62	32.65	32.41	32.55	4891.0
2013-08-13 07:30:00	MSFT	Stock	32.58	32.59	32.57	32.57	21979.0
2013-08-13 08:00:00	MSFT	Stock	32.57	32.6	32.57	32.58	13620.0
2013-08-13 08:30:00	MSFT	Stock	32.58	32.59	32.52	32.52	367490.0
2013-08-13 09:00:00	MSFT	Stock	32.52	32.52	32.45	32.5	278242.0
2013-08-13 09:30:00	MSFT	Stock	32.5	32.51	32.26	32.47	6030920.0
2013-08-13 10:00:00	MSFT	Stock	32.47	32.5	32.35	32.38	5642305.0
2013-08-13 10:30:00	MSFT	Stock	32.37	32.38	32.25	32.26	3709042.0
2013-08-13 11:00:00	MSFT	Stock	32.26	32.3	32.21	32.23	1975061.0
2013-08-13 11:30:00	MSFT	Stock	32.225	32.335	32.22	32.27	2043626.0
2013-08-13 12:00:00	MSFT	Stock	32.27	32.39	32.23	32.39	1716852.0
2013-08-13 12:30:00	MSFT	Stock	32.39	32.43	32.32	32.39	1763769.0
2013-08-13 13:00:00	MSFT	Stock	32.395	32.55	32.38	32.52	1683812.0
2013-08-13 13:30:00	MSFT	Stock	32.52	32.53	32.4	32.408	1075895.0

> showing 50 of 79,892 rows — these rows as CSV

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