PREVIEW / stock_30min / 2014-02-27

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-27.parquet
  size:    1.6 MB
  rows:    82,236
  symbols: 3,541

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
2014-02-27 04:00:00	AAPL	Stock	18.4964	18.4964	18.4161	18.4161	35476.0
2014-02-27 04:30:00	AAPL	Stock	18.5054	18.5054	18.3764	18.3764	34664.0
2014-02-27 05:00:00	AAPL	Stock	18.3929	18.3929	18.3929	18.3929	2800.0
2014-02-27 06:00:00	AAPL	Stock	18.4196	18.4196	18.3629	18.3746	22708.0
2014-02-27 06:30:00	AAPL	Stock	18.3736	18.3886	18.3736	18.375	16800.0
2014-02-27 07:00:00	AAPL	Stock	18.375	18.4546	18.375	18.4546	92568.0
2014-02-27 07:30:00	AAPL	Stock	18.4357	18.4357	18.4036	18.4125	198464.0
2014-02-27 08:00:00	AAPL	Stock	18.4268	18.4286	18.375	18.4286	461020.0
2014-02-27 08:30:00	AAPL	Stock	18.4364	18.4639	18.4364	18.4464	479080.0
2014-02-27 09:00:00	AAPL	Stock	18.4429	18.5104	18.4429	18.4771	968436.0
2014-02-27 09:30:00	AAPL	Stock	18.4707	18.5857	18.4304	18.5756	39209576.0
2014-02-27 10:00:00	AAPL	Stock	18.5757	18.6882	18.5719	18.6775	29055068.0
2014-02-27 10:30:00	AAPL	Stock	18.6814	18.7443	18.6607	18.6989	16298128.0
2014-02-27 11:00:00	AAPL	Stock	18.7021	18.7086	18.6307	18.6629	13843592.0
2014-02-27 11:30:00	AAPL	Stock	18.6654	18.6818	18.6496	18.6664	9621976.0
2014-02-27 12:00:00	AAPL	Stock	18.6653	18.7454	18.655	18.7404	11769296.0
2014-02-27 12:30:00	AAPL	Stock	18.7414	18.8179	18.7375	18.8075	17377696.0
2014-02-27 13:00:00	AAPL	Stock	18.8082	18.8107	18.7593	18.8064	9129092.0
2014-02-27 13:30:00	AAPL	Stock	18.8064	18.8582	18.7975	18.8557	15260000.0
2014-02-27 14:00:00	AAPL	Stock	18.8561	18.885	18.8389	18.8479	15206800.0
2014-02-27 14:30:00	AAPL	Stock	18.8421	18.8487	18.7971	18.845	10245424.0
2014-02-27 15:00:00	AAPL	Stock	18.8438	18.8639	18.8079	18.8093	9150372.0
2014-02-27 15:30:00	AAPL	Stock	18.8136	18.8554	18.7904	18.8446	23082220.0
2014-02-27 16:00:00	AAPL	Stock	18.8454	18.8607	18.5082	18.8489	21758520.0
2014-02-27 16:30:00	AAPL	Stock	18.8604	18.8604	18.8454	18.85	585424.0
2014-02-27 17:00:00	AAPL	Stock	18.8571	18.8607	18.8491	18.8571	239960.0
2014-02-27 17:30:00	AAPL	Stock	18.8571	18.8607	18.8521	18.8521	79604.0
2014-02-27 18:00:00	AAPL	Stock	18.8518	18.8568	18.8518	18.8518	95480.0
2014-02-27 18:30:00	AAPL	Stock	18.8561	18.8571	18.85	18.85	32032.0
2014-02-27 19:00:00	AAPL	Stock	18.8561	18.8571	18.8561	18.8571	43988.0
2014-02-27 19:30:00	AAPL	Stock	18.8454	18.8611	18.8454	18.8607	89796.0
2014-02-27 06:30:00	MSFT	Stock	37.35	37.35	37.35	37.35	200.0
2014-02-27 07:00:00	MSFT	Stock	37.39	37.39	37.39	37.39	305.0
2014-02-27 08:00:00	MSFT	Stock	37.3	37.3	37.25	37.3	2812.0
2014-02-27 08:30:00	MSFT	Stock	37.25	37.39	37.25	37.38	8187.0
2014-02-27 09:00:00	MSFT	Stock	37.39	37.44	37.39	37.44	3300.0
2014-02-27 09:30:00	MSFT	Stock	37.45	37.45	37.23	37.279	3897630.0
2014-02-27 10:00:00	MSFT	Stock	37.28	37.42	37.23	37.4	2349780.0
2014-02-27 10:30:00	MSFT	Stock	37.41	37.54	37.38	37.495	2660462.0
2014-02-27 11:00:00	MSFT	Stock	37.495	37.6	37.47	37.5	2518989.0
2014-02-27 11:30:00	MSFT	Stock	37.51	37.53	37.46	37.53	1630001.0
2014-02-27 12:00:00	MSFT	Stock	37.525	37.605	37.49	37.59	1327784.0
2014-02-27 12:30:00	MSFT	Stock	37.595	37.63	37.57	37.605	964603.0
2014-02-27 13:00:00	MSFT	Stock	37.61	37.68	37.59	37.67	769346.0
2014-02-27 13:30:00	MSFT	Stock	37.67	37.8	37.66	37.8	1998609.0
2014-02-27 14:00:00	MSFT	Stock	37.8	37.815	37.65	37.652	892940.0
2014-02-27 14:30:00	MSFT	Stock	37.655	37.765	37.62	37.755	2083932.0
2014-02-27 15:00:00	MSFT	Stock	37.76	37.8	37.73	37.765	2409804.0
2014-02-27 15:30:00	MSFT	Stock	37.765	37.89	37.69	37.87	5885512.0
2014-02-27 16:00:00	MSFT	Stock	37.88	37.88	37.524	37.85	2728251.0

> showing 50 of 82,236 rows — these rows as CSV

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