PREVIEW / stock_30min / 2012-08-24

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-24.parquet
  size:    1.4 MB
  rows:    72,581
  symbols: 3,445

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-24 04:00:00	AAPL	Stock	23.6786	23.6786	23.5939	23.5939	11200.0
2012-08-24 06:00:00	AAPL	Stock	23.625	23.625	23.5929	23.6079	16800.0
2012-08-24 07:00:00	AAPL	Stock	23.625	23.6429	23.5361	23.5361	169904.0
2012-08-24 07:30:00	AAPL	Stock	23.525	23.6525	23.525	23.6339	206584.0
2012-08-24 08:00:00	AAPL	Stock	23.6261	23.6521	23.5357	23.6057	701708.0
2012-08-24 08:30:00	AAPL	Stock	23.6004	23.6389	23.5296	23.5307	2099412.0
2012-08-24 09:00:00	AAPL	Stock	23.5389	23.5875	23.5336	23.5607	1243872.0
2012-08-24 09:30:00	AAPL	Stock	23.5614	23.6139	23.4125	23.4893	74459644.0
2012-08-24 10:00:00	AAPL	Stock	23.4896	23.6896	23.4804	23.6763	41450080.0
2012-08-24 10:30:00	AAPL	Stock	23.6736	23.7886	23.6464	23.7146	49592060.0
2012-08-24 11:00:00	AAPL	Stock	23.7204	23.7814	23.6946	23.7568	30487688.0
2012-08-24 11:30:00	AAPL	Stock	23.7625	23.8161	23.7556	23.787	23985668.0
2012-08-24 12:00:00	AAPL	Stock	23.7854	23.8296	23.7654	23.8286	16461088.0
2012-08-24 12:30:00	AAPL	Stock	23.8279	23.91	23.8132	23.9068	26596640.0
2012-08-24 13:00:00	AAPL	Stock	23.9096	23.91	23.8057	23.8214	22708896.0
2012-08-24 13:30:00	AAPL	Stock	23.8214	23.8814	23.8161	23.825	19818456.0
2012-08-24 14:00:00	AAPL	Stock	23.8281	23.8496	23.7929	23.8236	12080124.0
2012-08-24 14:30:00	AAPL	Stock	23.8226	23.8264	23.7968	23.805	7962640.0
2012-08-24 15:00:00	AAPL	Stock	23.8064	23.8071	23.7039	23.7654	34344940.0
2012-08-24 15:30:00	AAPL	Stock	23.7625	23.7725	23.6218	23.685	48747132.0
2012-08-24 16:00:00	AAPL	Stock	23.6911	23.8331	23.6464	23.6979	8879528.0
2012-08-24 16:30:00	AAPL	Stock	23.7014	23.7408	23.6918	23.6968	640080.0
2012-08-24 17:00:00	AAPL	Stock	23.6971	23.6971	23.6707	23.6707	314300.0
2012-08-24 17:30:00	AAPL	Stock	23.6793	23.6936	23.6679	23.6932	86660.0
2012-08-24 18:00:00	AAPL	Stock	23.6932	23.7221	23.6932	23.7221	333508.0
2012-08-24 18:30:00	AAPL	Stock	23.7232	24.0086	23.7182	24.0	2334976.0
2012-08-24 19:00:00	AAPL	Stock	24.0	24.1407	23.9646	24.125	4160520.0
2012-08-24 19:30:00	AAPL	Stock	24.125	24.125	24.0768	24.1054	2124332.0
2012-08-24 08:00:00	MSFT	Stock	30.07	30.19	30.07	30.19	2400.0
2012-08-24 08:30:00	MSFT	Stock	30.19	30.25	30.15	30.16	3550.0
2012-08-24 09:00:00	MSFT	Stock	30.13	30.29	30.13	30.25	10043.0
2012-08-24 09:30:00	MSFT	Stock	30.25	30.28	30.18	30.2	2738058.0
2012-08-24 10:00:00	MSFT	Stock	30.2	30.35	30.195	30.31	2006121.0
2012-08-24 10:30:00	MSFT	Stock	30.315	30.455	30.31	30.4	1771363.0
2012-08-24 11:00:00	MSFT	Stock	30.4	30.53	30.37	30.45	2269973.0
2012-08-24 11:30:00	MSFT	Stock	30.45	30.48	30.38	30.39	1090440.0
2012-08-24 12:00:00	MSFT	Stock	30.395	30.48	30.38	30.47	1306332.0
2012-08-24 12:30:00	MSFT	Stock	30.47	30.48	30.42	30.465	788414.0
2012-08-24 13:00:00	MSFT	Stock	30.466	30.47	30.405	30.415	679435.0
2012-08-24 13:30:00	MSFT	Stock	30.419	30.57	30.41	30.523	1576927.0
2012-08-24 14:00:00	MSFT	Stock	30.52	30.54	30.47	30.5	1060443.0
2012-08-24 14:30:00	MSFT	Stock	30.505	30.51	30.46	30.48	753594.0
2012-08-24 15:00:00	MSFT	Stock	30.485	30.55	30.46	30.53	1737111.0
2012-08-24 15:30:00	MSFT	Stock	30.527	30.63	30.48	30.56	3278650.0
2012-08-24 16:00:00	MSFT	Stock	30.56	30.58	30.425	30.56	1724915.0
2012-08-24 16:30:00	MSFT	Stock	30.53	30.575	30.51	30.56	9985.0
2012-08-24 17:00:00	MSFT	Stock	30.51	30.55	30.51	30.51	980.0
2012-08-24 17:30:00	MSFT	Stock	30.56	30.56	30.56	30.56	5310.0
2012-08-24 18:30:00	MSFT	Stock	30.51	30.51	30.5	30.5	1000.0
2012-08-24 19:00:00	MSFT	Stock	30.56	30.56	30.56	30.56	170.0

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

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