PREVIEW / stock_30min / 2011-12-14

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-14.parquet
  size:    1.4 MB
  rows:    76,608
  symbols: 3,530

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-12-14 04:00:00	AAPL	Stock	13.9054	13.9054	13.9011	13.9011	11200.0
2011-12-14 04:30:00	AAPL	Stock	13.9004	13.9014	13.9004	13.9014	5600.0
2011-12-14 05:00:00	AAPL	Stock	13.9146	13.9146	13.9146	13.9146	2800.0
2011-12-14 06:00:00	AAPL	Stock	13.8929	13.8929	13.8821	13.8821	11200.0
2011-12-14 06:30:00	AAPL	Stock	13.8857	13.8857	13.8857	13.8857	23800.0
2011-12-14 07:00:00	AAPL	Stock	13.8536	13.8536	13.85	13.85	5600.0
2011-12-14 07:30:00	AAPL	Stock	13.8571	13.9039	13.8571	13.8754	73500.0
2011-12-14 08:00:00	AAPL	Stock	13.8768	13.935	13.875	13.935	613788.0
2011-12-14 08:30:00	AAPL	Stock	13.9346	13.9443	13.9018	13.9021	603176.0
2011-12-14 09:00:00	AAPL	Stock	13.9021	13.9021	13.8061	13.8114	1896300.0
2011-12-14 09:30:00	AAPL	Stock	13.8179	13.835	13.6539	13.7098	80156720.0
2011-12-14 10:00:00	AAPL	Stock	13.7057	13.7111	13.5943	13.6414	47985056.0
2011-12-14 10:30:00	AAPL	Stock	13.6461	13.6696	13.5946	13.6107	27891276.0
2011-12-14 11:00:00	AAPL	Stock	13.6076	13.6339	13.5425	13.5504	27096328.0
2011-12-14 11:30:00	AAPL	Stock	13.5511	13.5589	13.4886	13.5214	30464560.0
2011-12-14 12:00:00	AAPL	Stock	13.5225	13.5804	13.5036	13.5268	22235864.0
2011-12-14 12:30:00	AAPL	Stock	13.5271	13.5692	13.5254	13.5537	17024140.0
2011-12-14 13:00:00	AAPL	Stock	13.5582	13.6214	13.5571	13.6161	22998024.0
2011-12-14 13:30:00	AAPL	Stock	13.6161	13.6161	13.5545	13.5611	12182324.0
2011-12-14 14:00:00	AAPL	Stock	13.5618	13.5893	13.5321	13.5812	16427264.0
2011-12-14 14:30:00	AAPL	Stock	13.5807	13.5811	13.5268	13.5321	16741900.0
2011-12-14 15:00:00	AAPL	Stock	13.5343	13.5782	13.5086	13.5682	24768548.0
2011-12-14 15:30:00	AAPL	Stock	13.5686	13.6071	13.5514	13.5725	36867516.0
2011-12-14 16:00:00	AAPL	Stock	13.5743	13.6155	13.5697	13.5768	16630964.0
2011-12-14 16:30:00	AAPL	Stock	13.5736	13.601	13.5714	13.5732	258804.0
2011-12-14 17:00:00	AAPL	Stock	13.5732	13.5782	13.5554	13.5654	486136.0
2011-12-14 17:30:00	AAPL	Stock	13.5607	13.5782	13.5607	13.5611	783692.0
2011-12-14 18:00:00	AAPL	Stock	13.5632	13.5782	13.5364	13.5396	133252.0
2011-12-14 18:30:00	AAPL	Stock	13.5375	13.5571	13.5346	13.5357	128464.0
2011-12-14 19:00:00	AAPL	Stock	13.5357	13.5571	13.5357	13.55	88956.0
2011-12-14 19:30:00	AAPL	Stock	13.5404	13.5446	13.5354	13.5393	60312.0
2011-12-14 08:00:00	MSFT	Stock	25.73	25.79	25.71	25.75	4038.0
2011-12-14 08:30:00	MSFT	Stock	25.71	25.71	25.67	25.71	2500.0
2011-12-14 09:00:00	MSFT	Stock	25.66	25.7	25.61	25.7	48777.0
2011-12-14 09:30:00	MSFT	Stock	25.72	25.86	25.63	25.83	5203685.0
2011-12-14 10:00:00	MSFT	Stock	25.82	25.83	25.61	25.69	4736708.0
2011-12-14 10:30:00	MSFT	Stock	25.69	25.77	25.61	25.625	3076014.0
2011-12-14 11:00:00	MSFT	Stock	25.62	25.7	25.61	25.61	3397190.0
2011-12-14 11:30:00	MSFT	Stock	25.615	25.69	25.57	25.67	3116359.0
2011-12-14 12:00:00	MSFT	Stock	25.67	25.71	25.65	25.658	2375858.0
2011-12-14 12:30:00	MSFT	Stock	25.65	25.72	25.62	25.638	2117887.0
2011-12-14 13:00:00	MSFT	Stock	25.64	25.7	25.62	25.664	1951256.0
2011-12-14 13:30:00	MSFT	Stock	25.67	25.74	25.63	25.645	2410479.0
2011-12-14 14:00:00	MSFT	Stock	25.64	25.69	25.61	25.67	2434802.0
2011-12-14 14:30:00	MSFT	Stock	25.675	25.68	25.57	25.605	3375311.0
2011-12-14 15:00:00	MSFT	Stock	25.6	25.72	25.57	25.652	4315662.0
2011-12-14 15:30:00	MSFT	Stock	25.655	25.69	25.57	25.58	5478733.0
2011-12-14 16:00:00	MSFT	Stock	25.59	25.76	25.57	25.59	2438369.0
2011-12-14 16:30:00	MSFT	Stock	25.59	25.661	25.59	25.65	91781.0
2011-12-14 17:00:00	MSFT	Stock	25.6	25.6	25.59	25.59	89231.0

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

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