PREVIEW / stock_30min / 2012-07-13

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-13.parquet
  size:    1.4 MB
  rows:    73,397
  symbols: 3,491

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-07-13 06:30:00	AAPL	Stock	21.4536	21.4889	21.4536	21.4821	32200.0
2012-07-13 07:00:00	AAPL	Stock	21.4821	21.4821	21.4286	21.4321	80080.0
2012-07-13 07:30:00	AAPL	Stock	21.4536	21.4643	21.4461	21.4504	194824.0
2012-07-13 08:00:00	AAPL	Stock	21.4464	21.4979	21.4286	21.4979	763336.0
2012-07-13 08:30:00	AAPL	Stock	21.5	21.5461	21.4214	21.5357	1348956.0
2012-07-13 09:00:00	AAPL	Stock	21.5389	21.5411	21.5132	21.5339	1757616.0
2012-07-13 09:30:00	AAPL	Stock	21.5339	21.5893	21.4286	21.5358	53773272.0
2012-07-13 10:00:00	AAPL	Stock	21.5396	21.5679	21.4821	21.506	29631392.0
2012-07-13 10:30:00	AAPL	Stock	21.5071	21.5607	21.4961	21.5221	15719228.0
2012-07-13 11:00:00	AAPL	Stock	21.5186	21.5304	21.4743	21.4786	13774292.0
2012-07-13 11:30:00	AAPL	Stock	21.4821	21.5304	21.4821	21.5282	14642040.0
2012-07-13 12:00:00	AAPL	Stock	21.525	21.6071	21.5243	21.5692	25130588.0
2012-07-13 12:30:00	AAPL	Stock	21.5696	21.5921	21.5696	21.5846	10027276.0
2012-07-13 13:00:00	AAPL	Stock	21.5867	21.6579	21.5811	21.62	21549332.0
2012-07-13 13:30:00	AAPL	Stock	21.6204	21.6536	21.5982	21.6229	15547084.0
2012-07-13 14:00:00	AAPL	Stock	21.6263	21.6489	21.605	21.6279	14824404.0
2012-07-13 14:30:00	AAPL	Stock	21.6286	21.6543	21.6186	21.6543	10453688.0
2012-07-13 15:00:00	AAPL	Stock	21.6543	21.6854	21.6353	21.6382	27736296.0
2012-07-13 15:30:00	AAPL	Stock	21.6375	21.6421	21.5929	21.6	37775192.0
2012-07-13 16:00:00	AAPL	Stock	21.6061	21.6075	21.5172	21.6064	12663868.0
2012-07-13 16:30:00	AAPL	Stock	21.6064	21.6324	21.6054	21.6054	345968.0
2012-07-13 17:00:00	AAPL	Stock	21.6079	21.6079	21.6057	21.6075	84952.0
2012-07-13 17:30:00	AAPL	Stock	21.6068	21.6068	21.5911	21.6043	69272.0
2012-07-13 18:00:00	AAPL	Stock	21.6061	21.6061	21.6039	21.6061	23016.0
2012-07-13 18:30:00	AAPL	Stock	21.6054	21.61	21.6039	21.61	50260.0
2012-07-13 19:00:00	AAPL	Stock	21.6071	21.6121	21.6071	21.6121	55048.0
2012-07-13 19:30:00	AAPL	Stock	21.6121	21.6161	21.6071	21.6071	70560.0
2012-07-13 07:00:00	MSFT	Stock	28.77	28.77	28.77	28.77	200.0
2012-07-13 08:00:00	MSFT	Stock	28.7	28.78	28.67	28.69	21487.0
2012-07-13 08:30:00	MSFT	Stock	28.7	28.75	28.69	28.72	2778.0
2012-07-13 09:00:00	MSFT	Stock	28.72	28.87	28.7	28.79	51455.0
2012-07-13 09:30:00	MSFT	Stock	28.76	29.14	28.72	29.134	4773661.0
2012-07-13 10:00:00	MSFT	Stock	29.14	29.33	29.1	29.15	3235619.0
2012-07-13 10:30:00	MSFT	Stock	29.16	29.26	29.14	29.205	2306776.0
2012-07-13 11:00:00	MSFT	Stock	29.21	29.24	29.19	29.2	1870452.0
2012-07-13 11:30:00	MSFT	Stock	29.2	29.24	29.16	29.221	2239297.0
2012-07-13 12:00:00	MSFT	Stock	29.23	29.25	29.19	29.21	1965720.0
2012-07-13 12:30:00	MSFT	Stock	29.21	29.22	29.17	29.19	1315047.0
2012-07-13 13:00:00	MSFT	Stock	29.19	29.24	29.19	29.205	1055055.0
2012-07-13 13:30:00	MSFT	Stock	29.2	29.29	29.2	29.28	2217920.0
2012-07-13 14:00:00	MSFT	Stock	29.288	29.33	29.27	29.3	2544457.0
2012-07-13 14:30:00	MSFT	Stock	29.295	29.33	29.25	29.27	1864973.0
2012-07-13 15:00:00	MSFT	Stock	29.265	29.41	29.26	29.355	3520115.0
2012-07-13 15:30:00	MSFT	Stock	29.355	29.48	29.35	29.4	7641902.0
2012-07-13 16:00:00	MSFT	Stock	29.39	29.43	29.186	29.42	1892393.0
2012-07-13 16:30:00	MSFT	Stock	29.43	29.44	29.34	29.44	13300.0
2012-07-13 17:00:00	MSFT	Stock	29.44	29.44	29.42	29.44	850.0
2012-07-13 17:30:00	MSFT	Stock	29.42	29.42	29.41	29.41	2917.0
2012-07-13 18:00:00	MSFT	Stock	29.41	29.41	29.41	29.41	2000.0
2012-07-13 18:30:00	MSFT	Stock	29.41	29.44	29.41	29.44	1400.0

> showing 50 of 73,397 rows — these rows as CSV

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