PREVIEW / stock_30min / 2013-12-18

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-18.parquet
  size:    1.6 MB
  rows:    83,090
  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
2013-12-18 04:00:00	AAPL	Stock	19.8554	19.8554	19.7886	19.7886	42000.0
2013-12-18 04:30:00	AAPL	Stock	19.7925	19.7925	19.75	19.7504	102676.0
2013-12-18 05:30:00	AAPL	Stock	19.7604	19.7732	19.7575	19.7621	22400.0
2013-12-18 06:00:00	AAPL	Stock	19.7618	19.7675	19.7321	19.7675	87920.0
2013-12-18 06:30:00	AAPL	Stock	19.7321	19.7321	19.5136	19.5604	616084.0
2013-12-18 07:00:00	AAPL	Stock	19.5536	19.5854	19.4464	19.5536	837788.0
2013-12-18 07:30:00	AAPL	Stock	19.5589	19.6186	19.5286	19.5754	1415316.0
2013-12-18 08:00:00	AAPL	Stock	19.5754	19.6304	19.4879	19.5964	2450392.0
2013-12-18 08:30:00	AAPL	Stock	19.5964	19.5982	19.5354	19.5882	3117100.0
2013-12-18 09:00:00	AAPL	Stock	19.5893	19.7625	19.5786	19.6321	4124764.0
2013-12-18 09:30:00	AAPL	Stock	19.63	19.6768	19.4111	19.4643	89106892.0
2013-12-18 10:00:00	AAPL	Stock	19.4668	19.5804	19.4384	19.5339	44308880.0
2013-12-18 10:30:00	AAPL	Stock	19.5357	19.5814	19.4707	19.4714	22889048.0
2013-12-18 11:00:00	AAPL	Stock	19.4711	19.5143	19.4554	19.4851	16128308.0
2013-12-18 11:30:00	AAPL	Stock	19.4843	19.4854	19.3571	19.4093	27295800.0
2013-12-18 12:00:00	AAPL	Stock	19.4039	19.4286	19.3325	19.4086	24315620.0
2013-12-18 12:30:00	AAPL	Stock	19.4043	19.4089	19.3429	19.3568	16086336.0
2013-12-18 13:00:00	AAPL	Stock	19.3554	19.3575	19.2429	19.3204	26498192.0
2013-12-18 13:30:00	AAPL	Stock	19.3256	19.3586	19.2986	19.3146	14817208.0
2013-12-18 14:00:00	AAPL	Stock	19.3146	19.5139	19.2429	19.46	53463340.0
2013-12-18 14:30:00	AAPL	Stock	19.4554	19.5968	19.4554	19.5182	34232156.0
2013-12-18 15:00:00	AAPL	Stock	19.5231	19.6375	19.5	19.5886	28808472.0
2013-12-18 15:30:00	AAPL	Stock	19.5868	19.6946	19.5848	19.6696	43346492.0
2013-12-18 16:00:00	AAPL	Stock	19.6704	19.6786	19.4911	19.6482	15818180.0
2013-12-18 16:30:00	AAPL	Stock	19.65	19.6775	19.514	19.6646	638372.0
2013-12-18 17:00:00	AAPL	Stock	19.6643	19.6704	19.6518	19.6704	281988.0
2013-12-18 17:30:00	AAPL	Stock	19.66	19.6704	19.6536	19.6696	85568.0
2013-12-18 18:00:00	AAPL	Stock	19.6643	19.6729	19.6554	19.6646	249452.0
2013-12-18 18:30:00	AAPL	Stock	19.6721	19.6721	19.665	19.6696	91280.0
2013-12-18 19:00:00	AAPL	Stock	19.6629	19.6696	19.6582	19.6611	47096.0
2013-12-18 19:30:00	AAPL	Stock	19.6571	19.6714	19.6571	19.6571	167888.0
2013-12-18 07:00:00	MSFT	Stock	36.52	36.52	36.45	36.45	5900.0
2013-12-18 07:30:00	MSFT	Stock	36.6	36.6	36.6	36.6	1000.0
2013-12-18 08:00:00	MSFT	Stock	36.52	36.52	36.32	36.33	22030.0
2013-12-18 08:30:00	MSFT	Stock	36.36	36.44	36.36	36.38	22360.0
2013-12-18 09:00:00	MSFT	Stock	36.36	36.39	36.33	36.37	58098.0
2013-12-18 09:30:00	MSFT	Stock	36.37	36.39	36.17	36.18	5401464.0
2013-12-18 10:00:00	MSFT	Stock	36.175	36.22	36.11	36.215	2910769.0
2013-12-18 10:30:00	MSFT	Stock	36.21	36.25	35.94	36.027	6065968.0
2013-12-18 11:00:00	MSFT	Stock	36.025	36.05	35.91	36.01	2408705.0
2013-12-18 11:30:00	MSFT	Stock	36.01	36.06	35.94	35.96	1661407.0
2013-12-18 12:00:00	MSFT	Stock	35.966	35.99	35.9	35.935	1633409.0
2013-12-18 12:30:00	MSFT	Stock	35.94	35.95	35.68	35.85	3352754.0
2013-12-18 13:00:00	MSFT	Stock	35.85	35.856	35.675	35.83	2815404.0
2013-12-18 13:30:00	MSFT	Stock	35.825	35.95	35.77	35.92	2121264.0
2013-12-18 14:00:00	MSFT	Stock	35.9	36.18	35.53	36.1	4752753.0
2013-12-18 14:30:00	MSFT	Stock	36.1	36.396	36.08	36.2	5284657.0
2013-12-18 15:00:00	MSFT	Stock	36.21	36.4	36.14	36.36	3152925.0
2013-12-18 15:30:00	MSFT	Stock	36.36	36.6	36.35	36.57	8712726.0
2013-12-18 16:00:00	MSFT	Stock	36.57	36.6	36.5	36.54	8171483.0

> showing 50 of 83,090 rows — these rows as CSV

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