PREVIEW / stock_30min / 2015-11-19

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-19.parquet
  size:    1.6 MB
  rows:    81,635
  symbols: 3,425

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-11-19 04:00:00	AAPL	Stock	29.45	29.4625	29.435	29.4575	21288.0
2015-11-19 04:30:00	AAPL	Stock	29.4525	29.465	29.435	29.465	12080.0
2015-11-19 05:00:00	AAPL	Stock	29.4625	29.465	29.455	29.4625	3792.0
2015-11-19 05:30:00	AAPL	Stock	29.4625	29.4625	29.435	29.4575	6360.0
2015-11-19 06:00:00	AAPL	Stock	29.465	29.5225	29.465	29.51	40640.0
2015-11-19 06:30:00	AAPL	Stock	29.5025	29.535	29.46	29.46	100512.0
2015-11-19 07:00:00	AAPL	Stock	29.465	29.495	29.3875	29.4275	272716.0
2015-11-19 07:30:00	AAPL	Stock	29.45	29.4725	29.2525	29.305	256268.0
2015-11-19 08:00:00	AAPL	Stock	29.305	29.49	29.265	29.295	435616.0
2015-11-19 08:30:00	AAPL	Stock	29.295	29.345	29.2775	29.3	298012.0
2015-11-19 09:00:00	AAPL	Stock	29.3125	29.45	29.2925	29.4225	936628.0
2015-11-19 09:30:00	AAPL	Stock	29.42	29.49	29.19	29.3375	24922848.0
2015-11-19 10:00:00	AAPL	Stock	29.3475	29.4918	29.3	29.475	14097644.0
2015-11-19 10:30:00	AAPL	Stock	29.475	29.6375	29.45	29.6302	14776624.0
2015-11-19 11:00:00	AAPL	Stock	29.63	29.7375	29.375	29.7275	12133512.0
2015-11-19 11:30:00	AAPL	Stock	29.7275	29.7575	29.64	29.689	10732428.0
2015-11-19 12:00:00	AAPL	Stock	29.6975	29.855	29.69	29.8375	11746464.0
2015-11-19 12:30:00	AAPL	Stock	29.8375	29.9075	29.805	29.873	9899884.0
2015-11-19 13:00:00	AAPL	Stock	29.875	29.9375	29.8025	29.805	9598988.0
2015-11-19 13:30:00	AAPL	Stock	29.806	29.8375	29.7475	29.78	8558456.0
2015-11-19 14:00:00	AAPL	Stock	29.78	29.8025	29.6625	29.7488	8026268.0
2015-11-19 14:30:00	AAPL	Stock	29.7475	29.8478	29.7325	29.815	7324368.0
2015-11-19 15:00:00	AAPL	Stock	29.815	29.815	29.6975	29.781	7449656.0
2015-11-19 15:30:00	AAPL	Stock	29.7825	29.82	29.685	29.695	13506260.0
2015-11-19 16:00:00	AAPL	Stock	29.695	29.7225	29.375	29.695	7194896.0
2015-11-19 16:30:00	AAPL	Stock	29.695	29.7	29.65	29.675	248144.0
2015-11-19 17:00:00	AAPL	Stock	29.675	29.675	29.6	29.6	65612.0
2015-11-19 17:30:00	AAPL	Stock	29.6	29.635	29.6	29.6125	26444.0
2015-11-19 18:00:00	AAPL	Stock	29.6	29.615	29.59	29.6025	21564.0
2015-11-19 18:30:00	AAPL	Stock	29.615	29.6175	29.61	29.6175	42672.0
2015-11-19 19:00:00	AAPL	Stock	29.6175	29.6175	29.6075	29.615	27820.0
2015-11-19 19:30:00	AAPL	Stock	29.6175	29.6175	29.6	29.6175	62848.0
2015-11-19 07:00:00	MSFT	Stock	53.89	53.93	53.89	53.93	1200.0
2015-11-19 07:30:00	MSFT	Stock	53.93	53.93	53.93	53.93	4000.0
2015-11-19 08:00:00	MSFT	Stock	53.93	53.95	53.89	53.9	7700.0
2015-11-19 08:30:00	MSFT	Stock	53.93	53.95	53.89	53.89	12300.0
2015-11-19 09:00:00	MSFT	Stock	53.95	54.09	53.86	54.08	29149.0
2015-11-19 09:30:00	MSFT	Stock	53.99	54.48	53.781	54.4	3537274.0
2015-11-19 10:00:00	MSFT	Stock	54.4	54.53	54.25	54.35	2409898.0
2015-11-19 10:30:00	MSFT	Stock	54.35	54.45	54.25	54.385	2018049.0
2015-11-19 11:00:00	MSFT	Stock	54.38	54.66	54.36	54.6	1673416.0
2015-11-19 11:30:00	MSFT	Stock	54.6	54.61	54.18	54.234	1737756.0
2015-11-19 12:00:00	MSFT	Stock	54.24	54.37	54.24	54.33	1380553.0
2015-11-19 12:30:00	MSFT	Stock	54.33	54.5	54.32	54.476	1584703.0
2015-11-19 13:00:00	MSFT	Stock	54.47	54.54	54.38	54.46	1267514.0
2015-11-19 13:30:00	MSFT	Stock	54.455	54.54	54.4	54.45	1184893.0
2015-11-19 14:00:00	MSFT	Stock	54.46	54.46	54.27	54.3	1537236.0
2015-11-19 14:30:00	MSFT	Stock	54.29	54.32	54.01	54.06	1616481.0
2015-11-19 15:00:00	MSFT	Stock	54.06	54.16	53.87	54.135	2045273.0
2015-11-19 15:30:00	MSFT	Stock	54.14	54.18	53.92	53.94	2689522.0

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

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