PREVIEW / stock_30min / 2012-08-31

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-31.parquet
  size:    1.4 MB
  rows:    72,824
  symbols: 3,455

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-08-31 04:00:00	AAPL	Stock	23.6436	23.6457	23.6286	23.6286	19824.0
2012-08-31 04:30:00	AAPL	Stock	23.6321	23.6321	23.6229	23.6229	11200.0
2012-08-31 05:00:00	AAPL	Stock	23.6214	23.6286	23.6214	23.6286	8680.0
2012-08-31 05:30:00	AAPL	Stock	23.6464	23.675	23.6464	23.675	30800.0
2012-08-31 06:00:00	AAPL	Stock	23.6786	23.6954	23.6786	23.6954	9800.0
2012-08-31 07:00:00	AAPL	Stock	23.75	23.8214	23.7464	23.7854	326676.0
2012-08-31 07:30:00	AAPL	Stock	23.7768	23.8136	23.775	23.8136	303548.0
2012-08-31 08:00:00	AAPL	Stock	23.8125	23.8464	23.7857	23.835	1143100.0
2012-08-31 08:30:00	AAPL	Stock	23.8325	23.8571	23.8171	23.8393	1491196.0
2012-08-31 09:00:00	AAPL	Stock	23.8389	23.8393	23.8054	23.8271	1287804.0
2012-08-31 09:30:00	AAPL	Stock	23.8229	23.8571	23.7186	23.735	38832304.0
2012-08-31 10:00:00	AAPL	Stock	23.735	23.7493	23.4732	23.6268	68693324.0
2012-08-31 10:30:00	AAPL	Stock	23.6304	23.8114	23.598	23.8057	36295896.0
2012-08-31 11:00:00	AAPL	Stock	23.8071	23.8786	23.795	23.8136	30545340.0
2012-08-31 11:30:00	AAPL	Stock	23.8164	23.8239	23.7143	23.7257	20544188.0
2012-08-31 12:00:00	AAPL	Stock	23.7214	23.7493	23.655	23.7214	17990336.0
2012-08-31 12:30:00	AAPL	Stock	23.7211	23.7582	23.7021	23.7257	10164168.0
2012-08-31 13:00:00	AAPL	Stock	23.7243	23.7389	23.6311	23.6417	12257364.0
2012-08-31 13:30:00	AAPL	Stock	23.6429	23.6964	23.6293	23.6718	10929548.0
2012-08-31 14:00:00	AAPL	Stock	23.6697	23.75	23.6546	23.7439	11998924.0
2012-08-31 14:30:00	AAPL	Stock	23.7436	23.7464	23.7071	23.725	10255084.0
2012-08-31 15:00:00	AAPL	Stock	23.7282	23.7321	23.6789	23.7257	13757492.0
2012-08-31 15:30:00	AAPL	Stock	23.7257	23.775	23.6932	23.7579	33039832.0
2012-08-31 16:00:00	AAPL	Stock	23.7474	23.7669	23.7139	23.7521	13234088.0
2012-08-31 16:30:00	AAPL	Stock	23.75	23.7589	23.7166	23.7532	1410248.0
2012-08-31 17:00:00	AAPL	Stock	23.7518	23.7536	23.7507	23.7507	57764.0
2012-08-31 17:30:00	AAPL	Stock	23.7554	23.7589	23.7521	23.7521	114100.0
2012-08-31 18:00:00	AAPL	Stock	23.7521	23.7554	23.7514	23.7554	44128.0
2012-08-31 18:30:00	AAPL	Stock	23.7536	23.7618	23.7464	23.7536	147448.0
2012-08-31 19:00:00	AAPL	Stock	23.7536	23.7596	23.7525	23.7596	32200.0
2012-08-31 19:30:00	AAPL	Stock	23.7571	23.76	23.75	23.75	121688.0
2012-08-31 06:30:00	MSFT	Stock	30.4	30.4	30.4	30.4	100.0
2012-08-31 07:30:00	MSFT	Stock	30.54	30.54	30.53	30.53	200.0
2012-08-31 08:00:00	MSFT	Stock	30.5	30.55	30.47	30.5	6900.0
2012-08-31 08:30:00	MSFT	Stock	30.52	30.59	30.32	30.57	52700.0
2012-08-31 09:00:00	MSFT	Stock	30.56	30.61	30.32	30.61	43450.0
2012-08-31 09:30:00	MSFT	Stock	30.6	30.73	30.57	30.615	2977287.0
2012-08-31 10:00:00	MSFT	Stock	30.61	30.7	30.38	30.65	4583694.0
2012-08-31 10:30:00	MSFT	Stock	30.655	30.8	30.6	30.78	2950273.0
2012-08-31 11:00:00	MSFT	Stock	30.79	30.909	30.77	30.805	3043795.0
2012-08-31 11:30:00	MSFT	Stock	30.8	30.89	30.78	30.88	3159650.0
2012-08-31 12:00:00	MSFT	Stock	30.87	30.96	30.765	30.79	2359101.0
2012-08-31 12:30:00	MSFT	Stock	30.78	30.81	30.73	30.79	1035069.0
2012-08-31 13:00:00	MSFT	Stock	30.79	30.795	30.69	30.765	1400179.0
2012-08-31 13:30:00	MSFT	Stock	30.77	30.815	30.74	30.81	1153317.0
2012-08-31 14:00:00	MSFT	Stock	30.81	30.96	30.8	30.935	1508504.0
2012-08-31 14:30:00	MSFT	Stock	30.93	30.95	30.91	30.935	1545231.0
2012-08-31 15:00:00	MSFT	Stock	30.93	30.935	30.77	30.815	1735957.0
2012-08-31 15:30:00	MSFT	Stock	30.81	30.94	30.755	30.81	5101101.0
2012-08-31 16:00:00	MSFT	Stock	30.815	30.912	30.767	30.83	2951357.0

> showing 50 of 72,824 rows — these rows as CSV

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