PREVIEW / stock_30min / 2012-03-19

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-19.parquet
  size:    1.4 MB
  rows:    76,569
  symbols: 3,539

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-03-19 04:00:00	AAPL	Stock	21.625	21.625	21.2321	21.4107	796376.0
2012-03-19 04:30:00	AAPL	Stock	21.4107	21.4375	21.4036	21.4375	290164.0
2012-03-19 05:00:00	AAPL	Stock	21.4604	21.4786	21.4321	21.4643	250992.0
2012-03-19 05:30:00	AAPL	Stock	21.4643	21.4643	21.4286	21.4636	186060.0
2012-03-19 06:00:00	AAPL	Stock	21.4643	21.5357	21.4643	21.5268	142632.0
2012-03-19 06:30:00	AAPL	Stock	21.5357	21.5714	21.4911	21.4911	493192.0
2012-03-19 07:00:00	AAPL	Stock	21.5536	21.7275	21.5286	21.6071	4629520.0
2012-03-19 07:30:00	AAPL	Stock	21.6068	21.6068	21.39	21.39	4964372.0
2012-03-19 08:00:00	AAPL	Stock	21.3929	21.6072	21.2665	21.4043	10100748.0
2012-03-19 08:30:00	AAPL	Stock	21.0357	21.3929	20.6589	21.1071	22051820.0
2012-03-19 09:00:00	AAPL	Stock	21.1071	21.3743	21.0611	21.3707	27089244.0
2012-03-19 09:30:00	AAPL	Stock	21.3707	21.3929	21.1117	21.22	143916276.0
2012-03-19 10:00:00	AAPL	Stock	21.2246	21.2279	21.0375	21.1193	99474620.0
2012-03-19 10:30:00	AAPL	Stock	21.1193	21.2277	21.1179	21.1961	52272976.0
2012-03-19 11:00:00	AAPL	Stock	21.2	21.2221	21.1557	21.1804	42594832.0
2012-03-19 11:30:00	AAPL	Stock	21.1815	21.2857	21.1786	21.2804	48504792.0
2012-03-19 12:00:00	AAPL	Stock	21.2796	21.3661	21.2715	21.3591	45957604.0
2012-03-19 12:30:00	AAPL	Stock	21.3579	21.4286	21.3436	21.4068	72222668.0
2012-03-19 13:00:00	AAPL	Stock	21.4029	21.4254	21.3571	21.3849	39531548.0
2012-03-19 13:30:00	AAPL	Stock	21.385	21.4046	21.2618	21.3207	47261676.0
2012-03-19 14:00:00	AAPL	Stock	21.319	21.3875	21.3161	21.3711	30179716.0
2012-03-19 14:30:00	AAPL	Stock	21.3714	21.4018	21.36	21.3814	29514352.0
2012-03-19 15:00:00	AAPL	Stock	21.3789	21.4007	21.3054	21.3507	45320772.0
2012-03-19 15:30:00	AAPL	Stock	21.3511	21.4918	21.3114	21.4721	101469984.0
2012-03-19 16:00:00	AAPL	Stock	21.4643	21.4979	21.2931	21.4979	9361548.0
2012-03-19 16:30:00	AAPL	Stock	21.4975	21.63	21.2622	21.5821	7213024.0
2012-03-19 17:00:00	AAPL	Stock	21.5821	21.6025	21.4836	21.5514	2182992.0
2012-03-19 17:30:00	AAPL	Stock	21.55	21.5536	21.53	21.5489	656572.0
2012-03-19 18:00:00	AAPL	Stock	21.5571	21.5921	21.5529	21.5839	791504.0
2012-03-19 18:30:00	AAPL	Stock	21.5871	21.5979	21.5804	21.5821	545776.0
2012-03-19 19:00:00	AAPL	Stock	21.5786	21.5971	21.5736	21.5964	525448.0
2012-03-19 19:30:00	AAPL	Stock	21.5921	21.5982	21.5893	21.5936	784868.0
2012-03-19 04:30:00	MSFT	Stock	32.5	32.5	32.5	32.5	262.0
2012-03-19 06:30:00	MSFT	Stock	32.45	32.45	32.38	32.38	500.0
2012-03-19 07:00:00	MSFT	Stock	32.46	32.54	32.45	32.53	4200.0
2012-03-19 07:30:00	MSFT	Stock	32.54	32.6	32.54	32.54	6500.0
2012-03-19 08:00:00	MSFT	Stock	32.5	32.57	32.5	32.57	10956.0
2012-03-19 08:30:00	MSFT	Stock	32.57	32.59	32.5	32.5	11932.0
2012-03-19 09:00:00	MSFT	Stock	32.54	32.6	32.5	32.52	20775.0
2012-03-19 09:30:00	MSFT	Stock	32.55	32.61	32.4	32.54	3241966.0
2012-03-19 10:00:00	MSFT	Stock	32.55	32.55	32.33	32.341	3638039.0
2012-03-19 10:30:00	MSFT	Stock	32.35	32.35	32.28	32.306	2171438.0
2012-03-19 11:00:00	MSFT	Stock	32.31	32.31	32.17	32.2	4040421.0
2012-03-19 11:30:00	MSFT	Stock	32.2	32.31	32.16	32.27	4971088.0
2012-03-19 12:00:00	MSFT	Stock	32.28	32.37	32.27	32.3	4235570.0
2012-03-19 12:30:00	MSFT	Stock	32.299	32.35	32.23	32.239	2615307.0
2012-03-19 13:00:00	MSFT	Stock	32.235	32.37	32.23	32.36	2241512.0
2012-03-19 13:30:00	MSFT	Stock	32.37	32.4	32.29	32.34	2317970.0
2012-03-19 14:00:00	MSFT	Stock	32.34	32.38	32.3	32.36	1421404.0
2012-03-19 14:30:00	MSFT	Stock	32.37	32.37	32.28	32.297	1793899.0

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

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