PREVIEW / stock_30min / 2012-02-09

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-09.parquet
  size:    1.4 MB
  rows:    76,455
  symbols: 3,546

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-02-09 04:00:00	AAPL	Stock	17.0754	17.0754	17.05	17.0604	40600.0
2012-02-09 04:30:00	AAPL	Stock	17.1007	17.1007	17.0632	17.0632	92288.0
2012-02-09 05:00:00	AAPL	Stock	17.0825	17.0825	17.0804	17.0804	11200.0
2012-02-09 05:30:00	AAPL	Stock	17.0736	17.0736	17.0714	17.0714	14000.0
2012-02-09 06:00:00	AAPL	Stock	17.0632	17.0714	17.05	17.0714	38556.0
2012-02-09 06:30:00	AAPL	Stock	17.0625	17.0679	17.0357	17.0357	68824.0
2012-02-09 07:00:00	AAPL	Stock	17.0382	17.0643	17.0357	17.0643	165396.0
2012-02-09 07:30:00	AAPL	Stock	17.0571	17.0954	17.0557	17.0775	529200.0
2012-02-09 08:00:00	AAPL	Stock	17.0714	17.1321	16.9893	17.1279	2090760.0
2012-02-09 08:30:00	AAPL	Stock	17.1289	17.1507	17.1089	17.1464	3767372.0
2012-02-09 09:00:00	AAPL	Stock	17.1482	17.1914	17.1429	17.1768	4250680.0
2012-02-09 09:30:00	AAPL	Stock	17.1732	17.3579	17.1625	17.3485	136733436.0
2012-02-09 10:00:00	AAPL	Stock	17.3486	17.4	17.2243	17.3239	85282568.0
2012-02-09 10:30:00	AAPL	Stock	17.3214	17.4979	17.2979	17.4625	80352020.0
2012-02-09 11:00:00	AAPL	Stock	17.4629	17.6754	17.4518	17.6361	135001916.0
2012-02-09 11:30:00	AAPL	Stock	17.6311	17.6829	17.5829	17.6253	69175764.0
2012-02-09 12:00:00	AAPL	Stock	17.6229	17.7411	17.6229	17.6885	73053316.0
2012-02-09 12:30:00	AAPL	Stock	17.6861	17.7219	17.6621	17.6796	35615608.0
2012-02-09 13:00:00	AAPL	Stock	17.6816	17.6818	17.5957	17.6421	47958148.0
2012-02-09 13:30:00	AAPL	Stock	17.6407	17.6536	17.5864	17.6012	26057052.0
2012-02-09 14:00:00	AAPL	Stock	17.6019	17.6664	17.5982	17.6611	30888620.0
2012-02-09 14:30:00	AAPL	Stock	17.6611	17.6964	17.6379	17.683	31230416.0
2012-02-09 15:00:00	AAPL	Stock	17.6837	17.6882	17.6357	17.6711	29929312.0
2012-02-09 15:30:00	AAPL	Stock	17.6704	17.6711	17.5729	17.6129	63648200.0
2012-02-09 16:00:00	AAPL	Stock	17.6132	17.6797	17.5289	17.6268	10892392.0
2012-02-09 16:30:00	AAPL	Stock	17.6264	17.6339	17.613	17.6321	303800.0
2012-02-09 17:00:00	AAPL	Stock	17.6282	17.6339	17.6132	17.6179	353528.0
2012-02-09 17:30:00	AAPL	Stock	17.6093	17.6139	17.5914	17.6071	467712.0
2012-02-09 18:00:00	AAPL	Stock	17.6071	17.6421	17.6	17.6339	624456.0
2012-02-09 18:30:00	AAPL	Stock	17.6339	17.6421	17.6304	17.6375	279832.0
2012-02-09 19:00:00	AAPL	Stock	17.6375	17.6432	17.6343	17.6389	344960.0
2012-02-09 19:30:00	AAPL	Stock	17.6404	17.6675	17.6375	17.6675	803180.0
2012-02-09 07:00:00	MSFT	Stock	30.55	30.55	30.55	30.55	3310.0
2012-02-09 07:30:00	MSFT	Stock	30.48	30.55	30.48	30.55	6096.0
2012-02-09 08:00:00	MSFT	Stock	30.58	30.65	30.52	30.62	18103.0
2012-02-09 08:30:00	MSFT	Stock	30.6	30.63	30.51	30.63	24246.0
2012-02-09 09:00:00	MSFT	Stock	30.59	30.64	30.56	30.64	16973.0
2012-02-09 09:30:00	MSFT	Stock	30.64	30.75	30.59	30.655	5178883.0
2012-02-09 10:00:00	MSFT	Stock	30.66	30.69	30.5	30.532	4516100.0
2012-02-09 10:30:00	MSFT	Stock	30.535	30.61	30.52	30.59	3613077.0
2012-02-09 11:00:00	MSFT	Stock	30.59	30.61	30.48	30.49	2666694.0
2012-02-09 11:30:00	MSFT	Stock	30.49	30.69	30.48	30.65	3786382.0
2012-02-09 12:00:00	MSFT	Stock	30.65	30.72	30.59	30.595	3890527.0
2012-02-09 12:30:00	MSFT	Stock	30.59	30.66	30.59	30.65	1393433.0
2012-02-09 13:00:00	MSFT	Stock	30.65	30.8	30.624	30.78	3671617.0
2012-02-09 13:30:00	MSFT	Stock	30.787	30.79	30.73	30.74	2173657.0
2012-02-09 14:00:00	MSFT	Stock	30.75	30.76	30.68	30.715	1911134.0
2012-02-09 14:30:00	MSFT	Stock	30.72	30.75	30.69	30.719	2069626.0
2012-02-09 15:00:00	MSFT	Stock	30.72	30.78	30.7	30.75	2229066.0
2012-02-09 15:30:00	MSFT	Stock	30.75	30.78	30.71	30.77	7330579.0

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

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