PREVIEW / stock_30min / 2016-04-12

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-12.parquet
  size:    1.6 MB
  rows:    81,628
  symbols: 3,345

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
2016-04-12 04:30:00	AAPL	Stock	27.215	27.255	27.215	27.23	1600.0
2016-04-12 05:00:00	AAPL	Stock	27.29	27.295	27.29	27.295	2116.0
2016-04-12 05:30:00	AAPL	Stock	27.3375	27.3375	27.3375	27.3375	400.0
2016-04-12 06:00:00	AAPL	Stock	27.34	27.3425	27.34	27.3425	2800.0
2016-04-12 06:30:00	AAPL	Stock	27.3625	27.3675	27.325	27.325	13104.0
2016-04-12 07:00:00	AAPL	Stock	27.3375	27.3575	27.285	27.3125	22940.0
2016-04-12 07:30:00	AAPL	Stock	27.3125	27.325	27.3125	27.32	9780.0
2016-04-12 08:00:00	AAPL	Stock	27.33	27.36	27.31	27.345	99064.0
2016-04-12 08:30:00	AAPL	Stock	27.345	27.4125	27.345	27.365	121780.0
2016-04-12 09:00:00	AAPL	Stock	27.36	27.4125	27.3475	27.3475	316228.0
2016-04-12 09:30:00	AAPL	Stock	27.3425	27.5025	27.28	27.2825	16955016.0
2016-04-12 10:00:00	AAPL	Stock	27.285	27.3475	27.165	27.2175	9995556.0
2016-04-12 10:30:00	AAPL	Stock	27.2128	27.435	27.2075	27.3948	12078352.0
2016-04-12 11:00:00	AAPL	Stock	27.395	27.5375	27.365	27.4692	7573520.0
2016-04-12 11:30:00	AAPL	Stock	27.47	27.4925	27.4075	27.42	4759028.0
2016-04-12 12:00:00	AAPL	Stock	27.425	27.47	27.4	27.4575	3577820.0
2016-04-12 12:30:00	AAPL	Stock	27.46	27.4975	27.45	27.46	4049648.0
2016-04-12 13:00:00	AAPL	Stock	27.465	27.473	27.41	27.4375	3400780.0
2016-04-12 13:30:00	AAPL	Stock	27.4375	27.5	27.3925	27.495	4955768.0
2016-04-12 14:00:00	AAPL	Stock	27.4948	27.575	27.4675	27.5575	7065504.0
2016-04-12 14:30:00	AAPL	Stock	27.555	27.5725	27.5325	27.5688	4604984.0
2016-04-12 15:00:00	AAPL	Stock	27.5675	27.625	27.5638	27.595	6351268.0
2016-04-12 15:30:00	AAPL	Stock	27.595	27.6175	27.5675	27.61	9630244.0
2016-04-12 16:00:00	AAPL	Stock	27.61	27.62	27.585	27.595	4080132.0
2016-04-12 16:30:00	AAPL	Stock	27.5925	27.5925	27.575	27.5875	31608.0
2016-04-12 17:00:00	AAPL	Stock	27.5875	27.5975	27.5875	27.5875	11428.0
2016-04-12 17:30:00	AAPL	Stock	27.585	27.61	27.585	27.595	9800.0
2016-04-12 18:00:00	AAPL	Stock	27.595	27.5975	27.58	27.59	14368.0
2016-04-12 18:30:00	AAPL	Stock	27.59	27.5975	27.5875	27.5975	12000.0
2016-04-12 19:00:00	AAPL	Stock	27.6	27.615	27.595	27.595	21008.0
2016-04-12 19:30:00	AAPL	Stock	27.6	27.615	27.6	27.615	44432.0
2016-04-12 07:30:00	MSFT	Stock	54.42	54.42	54.42	54.42	100.0
2016-04-12 08:00:00	MSFT	Stock	54.5	54.59	54.45	54.54	2595.0
2016-04-12 08:30:00	MSFT	Stock	54.52	54.52	54.46	54.46	18650.0
2016-04-12 09:00:00	MSFT	Stock	54.46	54.46	54.31	54.31	17411.0
2016-04-12 09:30:00	MSFT	Stock	54.37	54.44	54.06	54.09	2720051.0
2016-04-12 10:00:00	MSFT	Stock	54.085	54.21	53.76	53.9	2266089.0
2016-04-12 10:30:00	MSFT	Stock	53.89	54.18	53.88	54.12	2431860.0
2016-04-12 11:00:00	MSFT	Stock	54.12	54.39	54.06	54.3	2189190.0
2016-04-12 11:30:00	MSFT	Stock	54.305	54.44	54.23	54.27	1381004.0
2016-04-12 12:00:00	MSFT	Stock	54.28	54.39	54.275	54.385	728840.0
2016-04-12 12:30:00	MSFT	Stock	54.38	54.58	54.375	54.52	1315274.0
2016-04-12 13:00:00	MSFT	Stock	54.516	54.52	54.325	54.35	831811.0
2016-04-12 13:30:00	MSFT	Stock	54.35	54.52	54.331	54.5	997220.0
2016-04-12 14:00:00	MSFT	Stock	54.51	54.54	54.07	54.495	1058335.0
2016-04-12 14:30:00	MSFT	Stock	54.495	54.659	54.47	54.571	1241409.0
2016-04-12 15:00:00	MSFT	Stock	54.57	54.78	54.555	54.665	1480083.0
2016-04-12 15:30:00	MSFT	Stock	54.66	54.73	54.493	54.65	2525489.0
2016-04-12 16:00:00	MSFT	Stock	54.66	54.69	54.55	54.65	1203359.0
2016-04-12 17:30:00	MSFT	Stock	54.55	54.6	54.55	54.6	250.0

> showing 50 of 81,628 rows — these rows as CSV

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