PREVIEW / stock_30min / 2012-08-16

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-16.parquet
  size:    1.4 MB
  rows:    74,083
  symbols: 3,440

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-08-16 04:00:00	AAPL	Stock	22.5539	22.5539	22.5361	22.5361	25200.0
2012-08-16 06:30:00	AAPL	Stock	22.5871	22.5889	22.5871	22.5889	5600.0
2012-08-16 07:00:00	AAPL	Stock	22.58	22.6	22.5611	22.5821	154980.0
2012-08-16 07:30:00	AAPL	Stock	22.5889	22.605	22.5889	22.6007	90244.0
2012-08-16 08:00:00	AAPL	Stock	22.5907	22.6071	22.5743	22.5821	474180.0
2012-08-16 08:30:00	AAPL	Stock	22.5832	22.6064	22.5643	22.5643	773892.0
2012-08-16 09:00:00	AAPL	Stock	22.5629	22.5714	22.5368	22.5411	620480.0
2012-08-16 09:30:00	AAPL	Stock	22.5411	22.6071	22.5179	22.5707	34489896.0
2012-08-16 10:00:00	AAPL	Stock	22.57	22.5846	22.5261	22.5768	19880252.0
2012-08-16 10:30:00	AAPL	Stock	22.5771	22.6571	22.5761	22.6564	24086076.0
2012-08-16 11:00:00	AAPL	Stock	22.6561	22.6821	22.6386	22.6561	22685572.0
2012-08-16 11:30:00	AAPL	Stock	22.6586	22.7268	22.6482	22.7048	22341172.0
2012-08-16 12:00:00	AAPL	Stock	22.7061	22.7211	22.6857	22.6879	14127708.0
2012-08-16 12:30:00	AAPL	Stock	22.6889	22.7096	22.6704	22.7086	12895456.0
2012-08-16 13:00:00	AAPL	Stock	22.7071	22.7071	22.675	22.6811	7094108.0
2012-08-16 13:30:00	AAPL	Stock	22.6821	22.6964	22.6604	22.6879	12132372.0
2012-08-16 14:00:00	AAPL	Stock	22.6879	22.7143	22.675	22.7014	13296024.0
2012-08-16 14:30:00	AAPL	Stock	22.6983	22.7414	22.6983	22.7179	19097036.0
2012-08-16 15:00:00	AAPL	Stock	22.7214	22.7332	22.7	22.7258	13974492.0
2012-08-16 15:30:00	AAPL	Stock	22.7275	22.7314	22.7036	22.725	26577880.0
2012-08-16 16:00:00	AAPL	Stock	22.725	22.7286	22.6567	22.7232	5572504.0
2012-08-16 16:30:00	AAPL	Stock	22.7257	22.7286	22.7186	22.725	767592.0
2012-08-16 17:00:00	AAPL	Stock	22.7239	22.7264	22.7214	22.7214	72884.0
2012-08-16 17:30:00	AAPL	Stock	22.7211	22.7239	22.7207	22.7207	46032.0
2012-08-16 18:00:00	AAPL	Stock	22.7207	22.7207	22.71	22.71	78456.0
2012-08-16 18:30:00	AAPL	Stock	22.7093	22.7093	22.6871	22.6911	96824.0
2012-08-16 19:00:00	AAPL	Stock	22.6996	22.6996	22.6964	22.6996	36372.0
2012-08-16 19:30:00	AAPL	Stock	22.6996	22.7	22.6825	22.6825	110936.0
2012-08-16 08:00:00	MSFT	Stock	30.27	30.27	30.25	30.25	2196.0
2012-08-16 08:30:00	MSFT	Stock	30.25	30.3	30.25	30.28	25600.0
2012-08-16 09:00:00	MSFT	Stock	30.25	30.35	30.25	30.34	32009.0
2012-08-16 09:30:00	MSFT	Stock	30.37	30.4	30.26	30.39	3516967.0
2012-08-16 10:00:00	MSFT	Stock	30.39	30.48	30.36	30.45	2669703.0
2012-08-16 10:30:00	MSFT	Stock	30.45	30.68	30.445	30.64	3777305.0
2012-08-16 11:00:00	MSFT	Stock	30.64	30.738	30.631	30.715	2522013.0
2012-08-16 11:30:00	MSFT	Stock	30.716	30.86	30.7	30.812	2818242.0
2012-08-16 12:00:00	MSFT	Stock	30.81	30.86	30.78	30.825	1813482.0
2012-08-16 12:30:00	MSFT	Stock	30.83	30.87	30.78	30.854	2002003.0
2012-08-16 13:00:00	MSFT	Stock	30.85	30.92	30.83	30.86	1816407.0
2012-08-16 13:30:00	MSFT	Stock	30.865	30.88	30.78	30.8	1551749.0
2012-08-16 14:00:00	MSFT	Stock	30.81	30.9	30.79	30.9	1765832.0
2012-08-16 14:30:00	MSFT	Stock	30.892	30.94	30.892	30.915	1854170.0
2012-08-16 15:00:00	MSFT	Stock	30.915	30.94	30.88	30.9	2035367.0
2012-08-16 15:30:00	MSFT	Stock	30.895	30.9	30.77	30.79	5003869.0
2012-08-16 16:00:00	MSFT	Stock	30.8	30.89	30.635	30.78	1834765.0
2012-08-16 16:30:00	MSFT	Stock	30.78	30.78	30.72	30.72	180926.0
2012-08-16 17:00:00	MSFT	Stock	30.77	30.8	30.77	30.8	2422.0
2012-08-16 17:30:00	MSFT	Stock	30.8	30.81	30.8	30.8	5822.0
2012-08-16 18:00:00	MSFT	Stock	30.8	30.8	30.8	30.8	120.0
2012-08-16 19:30:00	MSFT	Stock	30.78	30.78	30.72	30.72	1774.0

> showing 50 of 74,083 rows — these rows as CSV

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