PREVIEW / stock_30min / 2014-11-14

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-14.parquet
  size:    1.6 MB
  rows:    82,346
  symbols: 3,565

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
2014-11-14 04:00:00	AAPL	Stock	28.215	28.2625	28.215	28.25	16660.0
2014-11-14 04:30:00	AAPL	Stock	28.2625	28.2625	28.2625	28.2625	1440.0
2014-11-14 05:00:00	AAPL	Stock	28.2475	28.25	28.2475	28.25	1200.0
2014-11-14 05:30:00	AAPL	Stock	28.2625	28.2625	28.2625	28.2625	1600.0
2014-11-14 06:00:00	AAPL	Stock	28.2625	28.2625	28.25	28.255	35756.0
2014-11-14 06:30:00	AAPL	Stock	28.255	28.26	28.215	28.26	18760.0
2014-11-14 07:00:00	AAPL	Stock	28.245	28.2675	28.215	28.2675	77460.0
2014-11-14 07:30:00	AAPL	Stock	28.26	28.27	28.22	28.2475	69904.0
2014-11-14 08:00:00	AAPL	Stock	28.235	28.275	28.0625	28.215	339092.0
2014-11-14 08:30:00	AAPL	Stock	28.215	28.2475	28.21	28.2475	219360.0
2014-11-14 09:00:00	AAPL	Stock	28.2475	28.3225	28.2175	28.285	756080.0
2014-11-14 09:30:00	AAPL	Stock	28.2825	28.4075	28.2625	28.345	28616316.0
2014-11-14 10:00:00	AAPL	Stock	28.3425	28.4725	28.335	28.4125	22893044.0
2014-11-14 10:30:00	AAPL	Stock	28.4125	28.5025	28.3475	28.5	16723080.0
2014-11-14 11:00:00	AAPL	Stock	28.4975	28.5	28.445	28.4685	9699716.0
2014-11-14 11:30:00	AAPL	Stock	28.4675	28.49	28.43	28.45	6629004.0
2014-11-14 12:00:00	AAPL	Stock	28.45	28.52	28.4475	28.4975	9779400.0
2014-11-14 12:30:00	AAPL	Stock	28.495	28.505	28.475	28.48	4842596.0
2014-11-14 13:00:00	AAPL	Stock	28.4775	28.5	28.4525	28.4762	5743680.0
2014-11-14 13:30:00	AAPL	Stock	28.475	28.4875	28.44	28.4475	4191680.0
2014-11-14 14:00:00	AAPL	Stock	28.445	28.47	28.3975	28.4675	7111320.0
2014-11-14 14:30:00	AAPL	Stock	28.465	28.475	28.4445	28.4725	4691688.0
2014-11-14 15:00:00	AAPL	Stock	28.4725	28.5175	28.4675	28.515	9572908.0
2014-11-14 15:30:00	AAPL	Stock	28.515	28.5475	28.4925	28.5475	19508084.0
2014-11-14 16:00:00	AAPL	Stock	28.545	28.5625	28.205	28.5625	8596044.0
2014-11-14 16:30:00	AAPL	Stock	28.5625	28.575	28.4632	28.57	388048.0
2014-11-14 17:00:00	AAPL	Stock	28.565	28.5775	28.545	28.575	934392.0
2014-11-14 17:30:00	AAPL	Stock	28.575	28.5825	28.545	28.5825	793520.0
2014-11-14 18:00:00	AAPL	Stock	28.575	28.5825	28.545	28.5725	99964.0
2014-11-14 18:30:00	AAPL	Stock	28.5725	28.5825	28.5675	28.5825	37444.0
2014-11-14 19:00:00	AAPL	Stock	28.575	28.5825	28.575	28.58	12420.0
2014-11-14 19:30:00	AAPL	Stock	28.58	28.6	28.5775	28.6	108696.0
2014-11-14 07:00:00	MSFT	Stock	49.61	49.61	49.61	49.61	100.0
2014-11-14 07:30:00	MSFT	Stock	49.55	49.56	49.55	49.55	1642.0
2014-11-14 08:00:00	MSFT	Stock	49.53	49.55	49.51	49.51	5000.0
2014-11-14 08:30:00	MSFT	Stock	49.6	49.6	49.6	49.6	1500.0
2014-11-14 09:00:00	MSFT	Stock	49.6	49.8	49.55	49.75	67347.0
2014-11-14 09:30:00	MSFT	Stock	49.74	50.045	49.61	49.7	5959538.0
2014-11-14 10:00:00	MSFT	Stock	49.7	49.857	49.65	49.76	1561099.0
2014-11-14 10:30:00	MSFT	Stock	49.75	49.94	49.625	49.81	1784235.0
2014-11-14 11:00:00	MSFT	Stock	49.82	49.9	49.79	49.804	1881629.0
2014-11-14 11:30:00	MSFT	Stock	49.8	49.83	49.74	49.79	1118207.0
2014-11-14 12:00:00	MSFT	Stock	49.795	49.82	49.7	49.75	1045428.0
2014-11-14 12:30:00	MSFT	Stock	49.75	49.76	49.66	49.68	1107798.0
2014-11-14 13:00:00	MSFT	Stock	49.685	49.685	49.57	49.585	1117129.0
2014-11-14 13:30:00	MSFT	Stock	49.585	49.67	49.52	49.54	1146177.0
2014-11-14 14:00:00	MSFT	Stock	49.54	49.545	49.39	49.467	1922575.0
2014-11-14 14:30:00	MSFT	Stock	49.47	49.51	49.43	49.46	1349547.0
2014-11-14 15:00:00	MSFT	Stock	49.47	49.56	49.435	49.56	1437663.0
2014-11-14 15:30:00	MSFT	Stock	49.56	49.63	49.45	49.58	3451964.0

> showing 50 of 82,346 rows — these rows as CSV

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