PREVIEW / stock_30min / 2015-02-18

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-18.parquet
  size:    1.6 MB
  rows:    82,982
  symbols: 3,527

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
2015-02-18 04:00:00	AAPL	Stock	32.1125	32.1125	32.0375	32.08	20760.0
2015-02-18 04:30:00	AAPL	Stock	32.08	32.08	32.05	32.08	34456.0
2015-02-18 05:00:00	AAPL	Stock	32.0825	32.09	32.075	32.0775	20028.0
2015-02-18 05:30:00	AAPL	Stock	32.0875	32.13	32.075	32.13	36232.0
2015-02-18 06:00:00	AAPL	Stock	32.075	32.075	32.0025	32.005	62052.0
2015-02-18 06:30:00	AAPL	Stock	32.0225	32.0225	31.98	31.98	6672.0
2015-02-18 07:00:00	AAPL	Stock	31.98	32.0375	31.975	32.0	88776.0
2015-02-18 07:30:00	AAPL	Stock	32.0	32.015	31.9625	31.9875	70100.0
2015-02-18 08:00:00	AAPL	Stock	31.99	32.03	31.85	31.92	553868.0
2015-02-18 08:30:00	AAPL	Stock	31.905	31.91	31.84	31.8875	440764.0
2015-02-18 09:00:00	AAPL	Stock	31.8875	31.95	31.85	31.9075	368008.0
2015-02-18 09:30:00	AAPL	Stock	31.895	32.0725	31.8625	32.0075	24824084.0
2015-02-18 10:00:00	AAPL	Stock	32.0075	32.045	31.8825	31.9235	16871172.0
2015-02-18 10:30:00	AAPL	Stock	31.9225	32.0675	31.9075	32.045	15142364.0
2015-02-18 11:00:00	AAPL	Stock	32.045	32.0488	31.96	32.005	8673508.0
2015-02-18 11:30:00	AAPL	Stock	32.005	32.0225	31.97	31.9775	6634788.0
2015-02-18 12:00:00	AAPL	Stock	31.9775	32.0125	31.9628	31.9975	6807248.0
2015-02-18 12:30:00	AAPL	Stock	31.9975	31.9975	31.91	31.9325	7717464.0
2015-02-18 13:00:00	AAPL	Stock	31.9325	31.9625	31.925	31.9375	5067132.0
2015-02-18 13:30:00	AAPL	Stock	31.9375	31.955	31.9125	31.925	5046648.0
2015-02-18 14:00:00	AAPL	Stock	31.9275	32.0175	31.9225	31.9375	11591872.0
2015-02-18 14:30:00	AAPL	Stock	31.935	31.9975	31.8875	31.995	8497728.0
2015-02-18 15:00:00	AAPL	Stock	31.9975	32.195	31.9962	32.1625	20486224.0
2015-02-18 15:30:00	AAPL	Stock	32.1625	32.185	32.1025	32.18	16646832.0
2015-02-18 16:00:00	AAPL	Stock	32.1788	32.1875	31.8632	31.9825	10908960.0
2015-02-18 16:30:00	AAPL	Stock	32.1675	32.18	31.9888	32.15	158016.0
2015-02-18 17:00:00	AAPL	Stock	31.9938	32.18	31.9628	32.14	1834516.0
2015-02-18 17:30:00	AAPL	Stock	32.145	32.1775	32.14	32.145	443696.0
2015-02-18 18:00:00	AAPL	Stock	32.15	32.1788	32.135	32.1475	206268.0
2015-02-18 18:30:00	AAPL	Stock	32.1475	32.155	32.135	32.145	17488.0
2015-02-18 19:00:00	AAPL	Stock	32.1575	32.1575	32.135	32.135	52096.0
2015-02-18 19:30:00	AAPL	Stock	32.1375	32.155	32.13	32.1475	40476.0
2015-02-18 06:00:00	MSFT	Stock	43.45	43.45	43.45	43.45	200.0
2015-02-18 07:30:00	MSFT	Stock	43.57	43.57	43.57	43.57	200.0
2015-02-18 08:00:00	MSFT	Stock	43.56	43.56	43.5	43.5	2420.0
2015-02-18 08:30:00	MSFT	Stock	43.5	43.5	43.46	43.47	3689.0
2015-02-18 09:00:00	MSFT	Stock	43.46	43.63	43.45	43.63	27229.0
2015-02-18 09:30:00	MSFT	Stock	43.59	43.635	43.39	43.47	3750762.0
2015-02-18 10:00:00	MSFT	Stock	43.475	43.51	43.39	43.445	1917908.0
2015-02-18 10:30:00	MSFT	Stock	43.445	43.55	43.415	43.51	2245815.0
2015-02-18 11:00:00	MSFT	Stock	43.515	43.54	43.49	43.515	1034207.0
2015-02-18 11:30:00	MSFT	Stock	43.52	43.61	43.5	43.58	1396833.0
2015-02-18 12:00:00	MSFT	Stock	43.585	43.61	43.51	43.55	959390.0
2015-02-18 12:30:00	MSFT	Stock	43.54	43.57	43.5	43.51	963446.0
2015-02-18 13:00:00	MSFT	Stock	43.51	43.53	43.49	43.53	1709220.0
2015-02-18 13:30:00	MSFT	Stock	43.525	43.59	43.49	43.56	1368326.0
2015-02-18 14:00:00	MSFT	Stock	43.555	43.69	43.53	43.58	1361290.0
2015-02-18 14:30:00	MSFT	Stock	43.58	43.61	43.56	43.585	1201516.0
2015-02-18 15:00:00	MSFT	Stock	43.59	43.7	43.59	43.64	1736989.0
2015-02-18 15:30:00	MSFT	Stock	43.64	43.66	43.48	43.53	3746913.0

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

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