PREVIEW / stock_30min / 2013-09-19

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-19.parquet
  size:    1.5 MB
  rows:    80,597
  symbols: 3,525

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-09-19 04:00:00	AAPL	Stock	16.7543	16.7543	16.6625	16.7104	72660.0
2013-09-19 04:30:00	AAPL	Stock	16.6946	16.7054	16.6639	16.6793	137928.0
2013-09-19 05:00:00	AAPL	Stock	16.6964	16.7143	16.6964	16.7143	47600.0
2013-09-19 05:30:00	AAPL	Stock	16.7286	16.7286	16.7286	16.7286	2800.0
2013-09-19 06:00:00	AAPL	Stock	16.7286	16.7286	16.6804	16.6804	8400.0
2013-09-19 06:30:00	AAPL	Stock	16.6961	16.7071	16.695	16.7071	97720.0
2013-09-19 07:00:00	AAPL	Stock	16.7107	16.7621	16.7054	16.7621	485324.0
2013-09-19 07:30:00	AAPL	Stock	16.7536	16.7536	16.7325	16.75	374864.0
2013-09-19 08:00:00	AAPL	Stock	16.75	16.8246	16.7143	16.7807	2500372.0
2013-09-19 08:30:00	AAPL	Stock	16.7804	16.8143	16.7721	16.8	1766968.0
2013-09-19 09:00:00	AAPL	Stock	16.7993	16.83	16.7921	16.8214	1887312.0
2013-09-19 09:30:00	AAPL	Stock	16.8107	16.9071	16.7589	16.9	83818476.0
2013-09-19 10:00:00	AAPL	Stock	16.9	16.9596	16.89	16.9186	50979824.0
2013-09-19 10:30:00	AAPL	Stock	16.92	16.9232	16.8661	16.9071	24710056.0
2013-09-19 11:00:00	AAPL	Stock	16.9071	16.9157	16.8857	16.9029	16036160.0
2013-09-19 11:30:00	AAPL	Stock	16.9029	16.9096	16.8821	16.8914	15737456.0
2013-09-19 12:00:00	AAPL	Stock	16.8936	16.9939	16.8886	16.9804	30341080.0
2013-09-19 12:30:00	AAPL	Stock	16.9793	16.9818	16.9521	16.963	13004376.0
2013-09-19 13:00:00	AAPL	Stock	16.9629	16.9721	16.9536	16.9632	11975936.0
2013-09-19 13:30:00	AAPL	Stock	16.9632	16.9649	16.9071	16.9254	18475800.0
2013-09-19 14:00:00	AAPL	Stock	16.9246	16.9661	16.9196	16.9561	12547724.0
2013-09-19 14:30:00	AAPL	Stock	16.9554	16.9668	16.9336	16.9618	11434332.0
2013-09-19 15:00:00	AAPL	Stock	16.9604	16.9729	16.9443	16.9546	15886108.0
2013-09-19 15:30:00	AAPL	Stock	16.9535	16.9539	16.8407	16.8679	65970352.0
2013-09-19 16:00:00	AAPL	Stock	16.8741	16.9607	16.6169	16.8511	18743144.0
2013-09-19 16:30:00	AAPL	Stock	16.8561	16.8818	16.8036	16.8107	1593760.0
2013-09-19 17:00:00	AAPL	Stock	16.8204	16.8286	16.82	16.8218	184100.0
2013-09-19 17:30:00	AAPL	Stock	16.8186	16.8679	16.8036	16.8193	435680.0
2013-09-19 18:00:00	AAPL	Stock	16.8214	16.8214	16.8018	16.8146	63560.0
2013-09-19 18:30:00	AAPL	Stock	16.8204	16.8243	16.8075	16.8204	66444.0
2013-09-19 19:00:00	AAPL	Stock	16.8179	16.8211	16.8054	16.8089	86716.0
2013-09-19 19:30:00	AAPL	Stock	16.8154	16.8157	16.775	16.7857	651420.0
2013-09-19 06:00:00	MSFT	Stock	33.53	33.54	33.43	33.54	1400.0
2013-09-19 06:30:00	MSFT	Stock	33.5	33.5	33.5	33.5	1000.0
2013-09-19 07:00:00	MSFT	Stock	33.5	33.5	33.45	33.48	1638.0
2013-09-19 07:30:00	MSFT	Stock	33.4	33.42	33.4	33.4	1840.0
2013-09-19 08:00:00	MSFT	Stock	33.4	33.4	33.33	33.4	18205.0
2013-09-19 08:30:00	MSFT	Stock	33.43	33.45	33.41	33.44	10946.0
2013-09-19 09:00:00	MSFT	Stock	33.43	33.48	33.42	33.48	19175.0
2013-09-19 09:30:00	MSFT	Stock	33.48	33.68	33.42	33.64	6810236.0
2013-09-19 10:00:00	MSFT	Stock	33.65	33.65	33.41	33.53	3188913.0
2013-09-19 10:30:00	MSFT	Stock	33.53	33.55	33.47	33.5	2032312.0
2013-09-19 11:00:00	MSFT	Stock	33.5	33.53	33.465	33.49	1792326.0
2013-09-19 11:30:00	MSFT	Stock	33.49	33.51	33.415	33.5	1923096.0
2013-09-19 12:00:00	MSFT	Stock	33.5	33.54	33.47	33.479	1291316.0
2013-09-19 12:30:00	MSFT	Stock	33.48	33.51	33.47	33.49	901328.0
2013-09-19 13:00:00	MSFT	Stock	33.49	33.53	33.4	33.425	1718574.0
2013-09-19 13:30:00	MSFT	Stock	33.43	33.45	33.33	33.33	1531149.0
2013-09-19 14:00:00	MSFT	Stock	33.33	33.43	33.32	33.426	1669582.0
2013-09-19 14:30:00	MSFT	Stock	33.42	33.53	33.42	33.53	1593954.0

> showing 50 of 80,597 rows — these rows as CSV

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