PREVIEW / stock_30min / 2014-09-30

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-30.parquet
  size:    1.6 MB
  rows:    84,271
  symbols: 3,567

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-09-30 04:00:00	AAPL	Stock	25.0275	25.085	25.0275	25.0725	27640.0
2014-09-30 04:30:00	AAPL	Stock	25.0725	25.12	25.0725	25.095	9760.0
2014-09-30 05:00:00	AAPL	Stock	25.0875	25.13	25.075	25.11	5136.0
2014-09-30 05:30:00	AAPL	Stock	25.125	25.14	25.1	25.1	17240.0
2014-09-30 06:00:00	AAPL	Stock	25.1	25.1	25.0825	25.1	51720.0
2014-09-30 06:30:00	AAPL	Stock	25.09	25.155	25.0875	25.155	184376.0
2014-09-30 07:00:00	AAPL	Stock	25.1525	25.2675	25.15	25.25	231988.0
2014-09-30 07:30:00	AAPL	Stock	25.25	25.2675	25.205	25.2125	242840.0
2014-09-30 08:00:00	AAPL	Stock	25.225	25.285	25.0275	25.275	776492.0
2014-09-30 08:30:00	AAPL	Stock	25.27	25.3125	25.25	25.25	696356.0
2014-09-30 09:00:00	AAPL	Stock	25.2525	25.2575	25.19	25.2075	516012.0
2014-09-30 09:30:00	AAPL	Stock	25.21	25.3575	25.135	25.225	32102020.0
2014-09-30 10:00:00	AAPL	Stock	25.2225	25.315	25.1325	25.2525	18948084.0
2014-09-30 10:30:00	AAPL	Stock	25.2525	25.3475	25.25	25.3275	12892048.0
2014-09-30 11:00:00	AAPL	Stock	25.325	25.385	25.315	25.3553	15334272.0
2014-09-30 11:30:00	AAPL	Stock	25.355	25.38	25.28	25.325	9651736.0
2014-09-30 12:00:00	AAPL	Stock	25.3225	25.3275	25.215	25.2375	10513716.0
2014-09-30 12:30:00	AAPL	Stock	25.2375	25.27	25.1775	25.2472	8275984.0
2014-09-30 13:00:00	AAPL	Stock	25.245	25.325	25.245	25.2512	8173936.0
2014-09-30 13:30:00	AAPL	Stock	25.25	25.28	25.1625	25.229	9824584.0
2014-09-30 14:00:00	AAPL	Stock	25.2275	25.229	25.1325	25.2075	10671328.0
2014-09-30 14:30:00	AAPL	Stock	25.2068	25.2425	25.185	25.224	6615340.0
2014-09-30 15:00:00	AAPL	Stock	25.225	25.285	25.185	25.2775	9436348.0
2014-09-30 15:30:00	AAPL	Stock	25.28	25.2925	25.1875	25.1875	22190328.0
2014-09-30 16:00:00	AAPL	Stock	25.1888	25.375	25.1525	25.1525	15773976.0
2014-09-30 16:30:00	AAPL	Stock	25.1625	25.1882	25.15	25.165	1513024.0
2014-09-30 17:00:00	AAPL	Stock	25.1525	25.165	25.145	25.1625	177116.0
2014-09-30 17:30:00	AAPL	Stock	25.1725	25.1875	25.1375	25.1375	93216.0
2014-09-30 18:00:00	AAPL	Stock	25.1375	25.155	25.115	25.125	308780.0
2014-09-30 18:30:00	AAPL	Stock	25.125	25.135	25.1175	25.1325	54004.0
2014-09-30 19:00:00	AAPL	Stock	25.125	25.1325	25.1175	25.13	30656.0
2014-09-30 19:30:00	AAPL	Stock	25.135	25.145	25.1175	25.12	58620.0
2014-09-30 08:00:00	MSFT	Stock	46.55	46.55	46.55	46.55	1000.0
2014-09-30 08:30:00	MSFT	Stock	46.55	46.55	46.55	46.55	165.0
2014-09-30 09:00:00	MSFT	Stock	46.55	46.55	46.3	46.36	19300.0
2014-09-30 09:30:00	MSFT	Stock	46.37	46.44	46.13	46.23	4273962.0
2014-09-30 10:00:00	MSFT	Stock	46.23	46.27	46.11	46.23	1674883.0
2014-09-30 10:30:00	MSFT	Stock	46.23	46.409	46.22	46.38	2202560.0
2014-09-30 11:00:00	MSFT	Stock	46.38	46.476	46.33	46.45	2523970.0
2014-09-30 11:30:00	MSFT	Stock	46.45	46.47	46.32	46.365	1602730.0
2014-09-30 12:00:00	MSFT	Stock	46.365	46.41	46.23	46.26	1195499.0
2014-09-30 12:30:00	MSFT	Stock	46.26	46.3	46.19	46.235	1155050.0
2014-09-30 13:00:00	MSFT	Stock	46.235	46.35	46.23	46.287	846523.0
2014-09-30 13:30:00	MSFT	Stock	46.285	46.301	46.1	46.11	1372987.0
2014-09-30 14:00:00	MSFT	Stock	46.11	46.12	46.01	46.11	1969494.0
2014-09-30 14:30:00	MSFT	Stock	46.11	46.28	46.09	46.2	1405450.0
2014-09-30 15:00:00	MSFT	Stock	46.21	46.275	46.13	46.22	1754235.0
2014-09-30 15:30:00	MSFT	Stock	46.23	46.38	46.21	46.36	5205842.0
2014-09-30 16:00:00	MSFT	Stock	46.36	46.4	46.28	46.28	4283708.0
2014-09-30 16:30:00	MSFT	Stock	46.3	46.3	46.3	46.3	408.0

> showing 50 of 84,271 rows — these rows as CSV

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