PREVIEW / stock_30min / 2011-01-07

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-07.parquet
  size:    1.4 MB
  rows:    74,762
  symbols: 3,516

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-01-07 04:00:00	AAPL	Stock	11.9468	11.9611	11.9468	11.9611	11200.0
2011-01-07 04:30:00	AAPL	Stock	11.9189	11.9189	11.9189	11.9189	2800.0
2011-01-07 05:00:00	AAPL	Stock	11.9489	11.9489	11.9489	11.9489	2800.0
2011-01-07 06:30:00	AAPL	Stock	11.9543	11.9543	11.9543	11.9543	2800.0
2011-01-07 07:00:00	AAPL	Stock	11.9393	11.9714	11.9393	11.9464	201992.0
2011-01-07 07:30:00	AAPL	Stock	11.9543	11.9543	11.9286	11.9393	84448.0
2011-01-07 08:00:00	AAPL	Stock	11.9382	11.9382	11.9179	11.9257	543144.0
2011-01-07 08:30:00	AAPL	Stock	11.9214	11.9321	11.8693	11.9143	1674848.0
2011-01-07 09:00:00	AAPL	Stock	11.9179	11.9361	11.9179	11.9318	1048460.0
2011-01-07 09:30:00	AAPL	Stock	11.9318	11.9418	11.8725	11.9014	38915996.0
2011-01-07 10:00:00	AAPL	Stock	11.9014	11.9675	11.8986	11.9661	32442452.0
2011-01-07 10:30:00	AAPL	Stock	11.9657	11.9861	11.9357	11.9461	34199256.0
2011-01-07 11:00:00	AAPL	Stock	11.9457	11.9518	11.9225	11.9243	18027016.0
2011-01-07 11:30:00	AAPL	Stock	11.9243	11.9339	11.8943	11.9321	19859056.0
2011-01-07 12:00:00	AAPL	Stock	11.9314	11.9357	11.9061	11.9079	9068836.0
2011-01-07 12:30:00	AAPL	Stock	11.9064	11.9129	11.8536	11.8979	30669184.0
2011-01-07 13:00:00	AAPL	Stock	11.9004	11.9282	11.885	11.9136	15987944.0
2011-01-07 13:30:00	AAPL	Stock	11.9136	11.9304	11.9075	11.9194	10983952.0
2011-01-07 14:00:00	AAPL	Stock	11.9207	11.9368	11.9168	11.9275	10825416.0
2011-01-07 14:30:00	AAPL	Stock	11.9275	11.9486	11.92	11.9357	10571764.0
2011-01-07 15:00:00	AAPL	Stock	11.9357	11.9757	11.9339	11.9632	20543460.0
2011-01-07 15:30:00	AAPL	Stock	11.9643	12.0125	11.9586	12.0046	39708116.0
2011-01-07 16:00:00	AAPL	Stock	12.0079	12.0304	11.9336	12.0282	7307804.0
2011-01-07 16:30:00	AAPL	Stock	12.0271	12.0304	11.9221	12.0304	171444.0
2011-01-07 17:00:00	AAPL	Stock	12.0311	12.0982	12.0311	12.0789	2521512.0
2011-01-07 17:30:00	AAPL	Stock	12.0736	12.0839	12.0632	12.0786	790132.0
2011-01-07 18:00:00	AAPL	Stock	12.0804	12.0821	12.0043	12.0768	533204.0
2011-01-07 18:30:00	AAPL	Stock	12.0736	12.0864	12.0732	12.0764	283976.0
2011-01-07 19:00:00	AAPL	Stock	12.0793	12.0807	12.0736	12.0768	302484.0
2011-01-07 19:30:00	AAPL	Stock	12.0786	12.0804	12.0679	12.075	247548.0
2011-01-07 04:00:00	MSFT	Stock	28.6	28.6	28.6	28.6	100.0
2011-01-07 05:00:00	MSFT	Stock	28.6	28.6	28.55	28.55	900.0
2011-01-07 06:00:00	MSFT	Stock	28.58	28.58	28.58	28.58	400.0
2011-01-07 06:30:00	MSFT	Stock	28.66	28.66	28.6	28.62	600.0
2011-01-07 07:00:00	MSFT	Stock	28.62	28.7	28.44	28.55	12200.0
2011-01-07 07:30:00	MSFT	Stock	28.63	28.68	28.63	28.68	4400.0
2011-01-07 08:00:00	MSFT	Stock	28.69	28.75	28.66	28.68	25906.0
2011-01-07 08:30:00	MSFT	Stock	28.69	28.78	28.67	28.77	72137.0
2011-01-07 09:00:00	MSFT	Stock	28.77	28.8	28.65	28.65	137338.0
2011-01-07 09:30:00	MSFT	Stock	28.65	28.74	28.42	28.55	10945398.0
2011-01-07 10:00:00	MSFT	Stock	28.56	28.57	28.45	28.47	5163226.0
2011-01-07 10:30:00	MSFT	Stock	28.462	28.53	28.44	28.465	5153917.0
2011-01-07 11:00:00	MSFT	Stock	28.46	28.47	28.32	28.339	4398210.0
2011-01-07 11:30:00	MSFT	Stock	28.34	28.43	28.28	28.429	3916119.0
2011-01-07 12:00:00	MSFT	Stock	28.42	28.56	28.41	28.47	4037420.0
2011-01-07 12:30:00	MSFT	Stock	28.465	28.48	28.25	28.36	6131034.0
2011-01-07 13:00:00	MSFT	Stock	28.36	28.37	28.25	28.27	3220162.0
2011-01-07 13:30:00	MSFT	Stock	28.26	28.34	28.26	28.32	2034766.0
2011-01-07 14:00:00	MSFT	Stock	28.32	28.39	28.28	28.355	2654651.0
2011-01-07 14:30:00	MSFT	Stock	28.35	28.45	28.31	28.415	2891158.0

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

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