PREVIEW / stock_30min / 2016-08-02

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-02.parquet
  size:    1.6 MB
  rows:    82,301
  symbols: 3,244

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-08-02 04:00:00	AAPL	Stock	26.5	26.5	26.375	26.41	5300.0
2016-08-02 04:30:00	AAPL	Stock	26.3775	26.395	26.375	26.395	7992.0
2016-08-02 05:00:00	AAPL	Stock	26.395	26.395	26.395	26.395	800.0
2016-08-02 05:30:00	AAPL	Stock	26.36	26.3875	26.36	26.3875	6400.0
2016-08-02 06:00:00	AAPL	Stock	26.4125	26.45	26.39	26.45	11964.0
2016-08-02 06:30:00	AAPL	Stock	26.45	26.4625	26.38	26.4125	25060.0
2016-08-02 07:00:00	AAPL	Stock	26.4125	26.4625	26.4125	26.425	68020.0
2016-08-02 07:30:00	AAPL	Stock	26.4375	26.4575	26.4	26.4	46980.0
2016-08-02 08:00:00	AAPL	Stock	26.435	26.455	26.405	26.44	195104.0
2016-08-02 08:30:00	AAPL	Stock	26.44	26.4525	26.435	26.435	64336.0
2016-08-02 09:00:00	AAPL	Stock	26.4375	26.4525	26.385	26.39	231840.0
2016-08-02 09:30:00	AAPL	Stock	26.5125	26.5175	26.2975	26.335	21894416.0
2016-08-02 10:00:00	AAPL	Stock	26.335	26.3525	26.1875	26.245	14754700.0
2016-08-02 10:30:00	AAPL	Stock	26.245	26.2725	26.1275	26.1325	12611512.0
2016-08-02 11:00:00	AAPL	Stock	26.1325	26.1925	26.125	26.1525	8084968.0
2016-08-02 11:30:00	AAPL	Stock	26.1502	26.1588	26.0625	26.1075	7727456.0
2016-08-02 12:00:00	AAPL	Stock	26.1075	26.5125	26.0712	26.12	5581276.0
2016-08-02 12:30:00	AAPL	Stock	26.12	26.125	26.05	26.0585	4917616.0
2016-08-02 13:00:00	AAPL	Stock	26.06	26.0662	26.0	26.0625	7165600.0
2016-08-02 13:30:00	AAPL	Stock	26.0625	26.125	26.05	26.105	5698428.0
2016-08-02 14:00:00	AAPL	Stock	26.105	26.1875	26.0725	26.175	6543984.0
2016-08-02 14:30:00	AAPL	Stock	26.175	26.1875	26.1152	26.12	5234708.0
2016-08-02 15:00:00	AAPL	Stock	26.12	26.1595	26.0975	26.1238	5113360.0
2016-08-02 15:30:00	AAPL	Stock	26.1225	26.155	26.1	26.1175	10329876.0
2016-08-02 16:00:00	AAPL	Stock	26.1175	26.175	26.0925	26.12	5118580.0
2016-08-02 16:30:00	AAPL	Stock	26.125	26.13	26.12	26.12	1006596.0
2016-08-02 17:00:00	AAPL	Stock	26.1225	26.1275	26.12	26.12	93580.0
2016-08-02 17:30:00	AAPL	Stock	26.125	26.125	26.1175	26.125	13640.0
2016-08-02 18:00:00	AAPL	Stock	26.1225	26.13	26.1125	26.1125	72952.0
2016-08-02 18:30:00	AAPL	Stock	26.1075	26.1175	26.1075	26.1075	17272.0
2016-08-02 19:00:00	AAPL	Stock	26.1175	26.1175	26.1125	26.1125	13924.0
2016-08-02 19:30:00	AAPL	Stock	26.11	26.11	26.1	26.1025	10700.0
2016-08-02 06:30:00	MSFT	Stock	56.19	56.38	55.93	56.38	2298.0
2016-08-02 07:00:00	MSFT	Stock	56.45	56.45	56.45	56.45	250.0
2016-08-02 07:30:00	MSFT	Stock	56.55	56.55	56.55	56.55	848.0
2016-08-02 08:00:00	MSFT	Stock	56.46	56.6	56.46	56.6	1456.0
2016-08-02 08:30:00	MSFT	Stock	56.65	56.71	56.64	56.64	5388.0
2016-08-02 09:00:00	MSFT	Stock	56.65	56.84	56.58	56.84	90603.0
2016-08-02 09:30:00	MSFT	Stock	56.84	56.9	56.58	56.75	5032208.0
2016-08-02 10:00:00	MSFT	Stock	56.755	56.81	56.6	56.63	3375572.0
2016-08-02 10:30:00	MSFT	Stock	56.63	56.72	56.34	56.41	3188072.0
2016-08-02 11:00:00	MSFT	Stock	56.4	56.496	56.32	56.451	1991358.0
2016-08-02 11:30:00	MSFT	Stock	56.45	56.605	56.385	56.505	1531207.0
2016-08-02 12:00:00	MSFT	Stock	56.505	56.62	56.5	56.55	1118987.0
2016-08-02 12:30:00	MSFT	Stock	56.55	56.67	56.493	56.559	1939073.0
2016-08-02 13:00:00	MSFT	Stock	56.55	56.57	56.31	56.415	2463046.0
2016-08-02 13:30:00	MSFT	Stock	56.411	56.54	56.39	56.505	1426072.0
2016-08-02 14:00:00	MSFT	Stock	56.51	56.7	56.5	56.65	1776058.0
2016-08-02 14:30:00	MSFT	Stock	56.65	56.7	56.53	56.63	1867295.0
2016-08-02 15:00:00	MSFT	Stock	56.63	56.689	56.54	56.585	2296949.0

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

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