PREVIEW / stock_30min / 2012-06-04

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-04.parquet
  size:    1.4 MB
  rows:    76,034
  symbols: 3,532

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-06-04 04:00:00	AAPL	Stock	19.9643	19.9643	19.8625	19.8893	78288.0
2012-06-04 04:30:00	AAPL	Stock	19.8536	19.8571	19.8529	19.8571	34020.0
2012-06-04 05:00:00	AAPL	Stock	19.8571	19.8857	19.8571	19.8857	33600.0
2012-06-04 05:30:00	AAPL	Stock	19.8929	19.9286	19.8929	19.9107	31276.0
2012-06-04 06:00:00	AAPL	Stock	19.9321	19.9643	19.9321	19.9639	67900.0
2012-06-04 06:30:00	AAPL	Stock	19.9643	20.0357	19.9643	20.0357	64960.0
2012-06-04 07:00:00	AAPL	Stock	20.0357	20.0536	20.0	20.0321	179340.0
2012-06-04 07:30:00	AAPL	Stock	20.0179	20.0864	19.9843	20.0664	401716.0
2012-06-04 08:00:00	AAPL	Stock	20.0625	20.1236	19.9821	20.0946	1344280.0
2012-06-04 08:30:00	AAPL	Stock	20.0946	20.1061	20.0393	20.0646	1200556.0
2012-06-04 09:00:00	AAPL	Stock	20.0636	20.0979	20.0504	20.0546	1005536.0
2012-06-04 09:30:00	AAPL	Stock	20.0536	20.2071	19.7775	19.8214	88091332.0
2012-06-04 10:00:00	AAPL	Stock	19.8204	19.8736	19.5893	19.7875	87467548.0
2012-06-04 10:30:00	AAPL	Stock	19.7882	19.9536	19.7568	19.8661	39810008.0
2012-06-04 11:00:00	AAPL	Stock	19.8571	19.8989	19.7204	19.7457	26549376.0
2012-06-04 11:30:00	AAPL	Stock	19.7396	19.8	19.6682	19.6714	22414532.0
2012-06-04 12:00:00	AAPL	Stock	19.6686	19.7411	19.625	19.658	22616776.0
2012-06-04 12:30:00	AAPL	Stock	19.6504	19.7429	19.6329	19.7103	19532492.0
2012-06-04 13:00:00	AAPL	Stock	19.7036	19.8411	19.7007	19.7361	26037116.0
2012-06-04 13:30:00	AAPL	Stock	19.7396	19.8964	19.7257	19.895	19929252.0
2012-06-04 14:00:00	AAPL	Stock	19.8929	20.0607	19.8479	20.015	41186012.0
2012-06-04 14:30:00	AAPL	Stock	20.0179	20.1883	19.9732	20.0642	55133428.0
2012-06-04 15:00:00	AAPL	Stock	20.0591	20.1032	19.9382	20.0364	32867240.0
2012-06-04 15:30:00	AAPL	Stock	20.0361	20.1546	19.9507	20.1532	55327048.0
2012-06-04 16:00:00	AAPL	Stock	20.1529	20.1532	19.7544	20.1243	10487848.0
2012-06-04 16:30:00	AAPL	Stock	20.1214	20.1532	19.8076	20.1375	2328788.0
2012-06-04 17:00:00	AAPL	Stock	20.0354	20.1532	20.0354	20.14	116760.0
2012-06-04 17:30:00	AAPL	Stock	20.1386	20.1421	20.1182	20.1354	180068.0
2012-06-04 18:00:00	AAPL	Stock	20.1346	20.1411	20.1279	20.14	95060.0
2012-06-04 18:30:00	AAPL	Stock	20.1407	20.1571	20.135	20.1357	435820.0
2012-06-04 19:00:00	AAPL	Stock	20.1286	20.1418	20.1286	20.1418	115836.0
2012-06-04 19:30:00	AAPL	Stock	20.1407	20.1529	20.1407	20.1429	193956.0
2012-06-04 04:00:00	MSFT	Stock	28.37	28.37	28.35	28.35	300.0
2012-06-04 06:30:00	MSFT	Stock	28.58	28.58	28.48	28.48	1000.0
2012-06-04 07:00:00	MSFT	Stock	28.44	28.44	28.44	28.44	500.0
2012-06-04 07:30:00	MSFT	Stock	28.45	28.48	28.45	28.48	3449.0
2012-06-04 08:00:00	MSFT	Stock	28.52	28.52	28.45	28.46	7565.0
2012-06-04 08:30:00	MSFT	Stock	28.47	28.51	28.42	28.45	14375.0
2012-06-04 09:00:00	MSFT	Stock	28.46	28.65	28.46	28.64	21218.0
2012-06-04 09:30:00	MSFT	Stock	28.63	28.78	28.39	28.41	5198955.0
2012-06-04 10:00:00	MSFT	Stock	28.42	28.645	28.32	28.6	4574620.0
2012-06-04 10:30:00	MSFT	Stock	28.597	28.605	28.5	28.51	2680054.0
2012-06-04 11:00:00	MSFT	Stock	28.51	28.52	28.4	28.44	2156897.0
2012-06-04 11:30:00	MSFT	Stock	28.44	28.48	28.38	28.42	2284545.0
2012-06-04 12:00:00	MSFT	Stock	28.41	28.45	28.385	28.43	1818350.0
2012-06-04 12:30:00	MSFT	Stock	28.42	28.475	28.37	28.42	2227155.0
2012-06-04 13:00:00	MSFT	Stock	28.42	28.49	28.38	28.4	1639937.0
2012-06-04 13:30:00	MSFT	Stock	28.405	28.42	28.33	28.41	2670417.0
2012-06-04 14:00:00	MSFT	Stock	28.41	28.51	28.35	28.48	3236383.0
2012-06-04 14:30:00	MSFT	Stock	28.47	28.57	28.43	28.434	2547239.0

> showing 50 of 76,034 rows — these rows as CSV

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