PREVIEW / stock_30min / 2011-06-21

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-21.parquet
  size:    1.4 MB
  rows:    76,881
  symbols: 3,560

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
2011-06-21 04:00:00	AAPL	Stock	11.2679	11.2907	11.2679	11.2907	14000.0
2011-06-21 04:30:00	AAPL	Stock	11.2907	11.2907	11.2875	11.2875	5600.0
2011-06-21 05:30:00	AAPL	Stock	11.2789	11.2789	11.2789	11.2789	2800.0
2011-06-21 06:00:00	AAPL	Stock	11.2586	11.275	11.2586	11.275	25200.0
2011-06-21 06:30:00	AAPL	Stock	11.2739	11.2818	11.265	11.28	42000.0
2011-06-21 07:00:00	AAPL	Stock	11.285	11.3304	11.285	11.3304	195944.0
2011-06-21 07:30:00	AAPL	Stock	11.3361	11.3693	11.3325	11.3493	630672.0
2011-06-21 08:00:00	AAPL	Stock	11.3464	11.3525	11.2614	11.3446	1072848.0
2011-06-21 08:30:00	AAPL	Stock	11.3411	11.3443	11.3104	11.3375	1049216.0
2011-06-21 09:00:00	AAPL	Stock	11.3375	11.3379	11.2979	11.3129	1027908.0
2011-06-21 09:30:00	AAPL	Stock	11.3129	11.4057	11.2571	11.3856	92231300.0
2011-06-21 10:00:00	AAPL	Stock	11.3854	11.4725	11.3799	11.4489	57382780.0
2011-06-21 10:30:00	AAPL	Stock	11.45	11.5625	11.4464	11.5396	64726228.0
2011-06-21 11:00:00	AAPL	Stock	11.5396	11.5714	11.528	11.5514	38961412.0
2011-06-21 11:30:00	AAPL	Stock	11.5514	11.5932	11.5504	11.5663	33227376.0
2011-06-21 12:00:00	AAPL	Stock	11.5665	11.5764	11.5382	11.5546	25423412.0
2011-06-21 12:30:00	AAPL	Stock	11.5543	11.5796	11.5436	11.5714	16892792.0
2011-06-21 13:00:00	AAPL	Stock	11.5709	11.605	11.5621	11.5939	19463696.0
2011-06-21 13:30:00	AAPL	Stock	11.5936	11.6064	11.5722	11.5871	21053592.0
2011-06-21 14:00:00	AAPL	Stock	11.5875	11.6104	11.5843	11.5957	19740196.0
2011-06-21 14:30:00	AAPL	Stock	11.5977	11.6357	11.5932	11.6215	22595608.0
2011-06-21 15:00:00	AAPL	Stock	11.6232	11.6318	11.6036	11.6064	21211316.0
2011-06-21 15:30:00	AAPL	Stock	11.6061	11.6193	11.5679	11.6168	42903588.0
2011-06-21 16:00:00	AAPL	Stock	11.6179	11.625	11.2614	11.6179	9462572.0
2011-06-21 16:30:00	AAPL	Stock	11.6192	11.6196	11.6101	11.6179	507836.0
2011-06-21 17:00:00	AAPL	Stock	11.6207	11.6211	11.6071	11.6107	100716.0
2011-06-21 17:30:00	AAPL	Stock	11.6107	11.6286	11.6014	11.6179	254100.0
2011-06-21 18:00:00	AAPL	Stock	11.6179	11.625	11.5982	11.6179	374472.0
2011-06-21 18:30:00	AAPL	Stock	11.6125	11.6125	11.6054	11.6125	30240.0
2011-06-21 19:00:00	AAPL	Stock	11.6143	11.6161	11.6079	11.6143	27356.0
2011-06-21 19:30:00	AAPL	Stock	11.6143	11.6179	11.6	11.6154	223888.0
2011-06-21 06:30:00	MSFT	Stock	24.6	24.6	24.6	24.6	900.0
2011-06-21 07:00:00	MSFT	Stock	24.6	24.6	24.5	24.5	300.0
2011-06-21 07:30:00	MSFT	Stock	24.62	24.62	24.56	24.56	1500.0
2011-06-21 08:00:00	MSFT	Stock	24.59	24.62	24.47	24.61	19945.0
2011-06-21 08:30:00	MSFT	Stock	24.6	24.62	24.57	24.57	39393.0
2011-06-21 09:00:00	MSFT	Stock	24.57	24.61	24.5	24.53	29228.0
2011-06-21 09:30:00	MSFT	Stock	24.53	24.65	24.4	24.61	5759129.0
2011-06-21 10:00:00	MSFT	Stock	24.61	24.78	24.59	24.74	3840301.0
2011-06-21 10:30:00	MSFT	Stock	24.737	24.8	24.68	24.77	2827231.0
2011-06-21 11:00:00	MSFT	Stock	24.77	24.85	24.76	24.82	3752287.0
2011-06-21 11:30:00	MSFT	Stock	24.82	24.86	24.76	24.8	2731364.0
2011-06-21 12:00:00	MSFT	Stock	24.8	24.807	24.75	24.77	2428734.0
2011-06-21 12:30:00	MSFT	Stock	24.779	24.82	24.75	24.77	1896020.0
2011-06-21 13:00:00	MSFT	Stock	24.76	24.77	24.72	24.74	2848710.0
2011-06-21 13:30:00	MSFT	Stock	24.73	24.75	24.68	24.735	2088320.0
2011-06-21 14:00:00	MSFT	Stock	24.73	24.75	24.68	24.692	2309484.0
2011-06-21 14:30:00	MSFT	Stock	24.695	24.81	24.69	24.77	2330436.0
2011-06-21 15:00:00	MSFT	Stock	24.78	24.8	24.72	24.725	2194130.0
2011-06-21 15:30:00	MSFT	Stock	24.72	24.77	24.69	24.76	5834569.0

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

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