PREVIEW / stock_30min / 2016-05-09

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-09.parquet
  size:    1.6 MB
  rows:    83,435
  symbols: 3,310

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-05-09 04:00:00	AAPL	Stock	23.1925	23.1925	23.1925	23.1925	1028.0
2016-05-09 04:30:00	AAPL	Stock	23.2375	23.2375	23.2375	23.2375	48000.0
2016-05-09 05:00:00	AAPL	Stock	23.2275	23.2275	23.2275	23.2275	1400.0
2016-05-09 05:30:00	AAPL	Stock	23.25	23.25	23.25	23.25	952.0
2016-05-09 06:00:00	AAPL	Stock	23.2575	23.2675	23.24	23.24	6760.0
2016-05-09 06:30:00	AAPL	Stock	23.2575	23.26	23.25	23.25	2800.0
2016-05-09 07:00:00	AAPL	Stock	23.2625	23.2625	23.225	23.225	27240.0
2016-05-09 07:30:00	AAPL	Stock	23.23	23.235	23.215	23.23	26600.0
2016-05-09 08:00:00	AAPL	Stock	23.25	23.2825	23.215	23.255	344684.0
2016-05-09 08:30:00	AAPL	Stock	23.27	23.275	23.225	23.225	200052.0
2016-05-09 09:00:00	AAPL	Stock	23.225	23.26	23.2175	23.26	262688.0
2016-05-09 09:30:00	AAPL	Stock	23.25	23.3725	23.1475	23.32	20733112.0
2016-05-09 10:00:00	AAPL	Stock	23.3175	23.4425	23.285	23.3548	12367112.0
2016-05-09 10:30:00	AAPL	Stock	23.355	23.435	23.3315	23.3825	7819680.0
2016-05-09 11:00:00	AAPL	Stock	23.3825	23.42	23.3225	23.365	6987888.0
2016-05-09 11:30:00	AAPL	Stock	23.365	23.395	23.3375	23.3475	4637084.0
2016-05-09 12:00:00	AAPL	Stock	23.3475	23.3575	23.2925	23.318	4866972.0
2016-05-09 12:30:00	AAPL	Stock	23.3188	23.33	23.255	23.2578	4372364.0
2016-05-09 13:00:00	AAPL	Stock	23.26	23.2825	23.215	23.2295	5307784.0
2016-05-09 13:30:00	AAPL	Stock	23.2298	23.245	23.1825	23.1875	6430668.0
2016-05-09 14:00:00	AAPL	Stock	23.1855	23.2212	23.155	23.2075	7091564.0
2016-05-09 14:30:00	AAPL	Stock	23.21	23.31	23.175	23.2838	7912012.0
2016-05-09 15:00:00	AAPL	Stock	23.2838	23.32	23.2575	23.2642	7676060.0
2016-05-09 15:30:00	AAPL	Stock	23.265	23.2825	23.175	23.1975	12642888.0
2016-05-09 16:00:00	AAPL	Stock	23.1975	23.2615	23.1925	23.2075	10705216.0
2016-05-09 16:30:00	AAPL	Stock	23.1975	23.1975	23.1675	23.18	25984.0
2016-05-09 17:00:00	AAPL	Stock	23.2002	23.2002	23.175	23.18	125664.0
2016-05-09 17:30:00	AAPL	Stock	23.18	23.2025	23.1775	23.195	22844.0
2016-05-09 18:00:00	AAPL	Stock	23.205	23.205	23.1775	23.1775	13748.0
2016-05-09 18:30:00	AAPL	Stock	23.175	23.18	23.17	23.17	8224.0
2016-05-09 19:00:00	AAPL	Stock	23.165	23.17	23.1625	23.17	16764.0
2016-05-09 19:30:00	AAPL	Stock	23.165	23.165	23.1575	23.1625	14884.0
2016-05-09 04:30:00	MSFT	Stock	50.44	50.44	50.44	50.44	200.0
2016-05-09 05:00:00	MSFT	Stock	50.49	50.49	50.49	50.49	200.0
2016-05-09 07:00:00	MSFT	Stock	50.5	50.55	50.5	50.55	6090.0
2016-05-09 07:30:00	MSFT	Stock	50.55	50.55	50.55	50.55	6300.0
2016-05-09 08:00:00	MSFT	Stock	50.55	50.6	50.5	50.55	11289.0
2016-05-09 08:30:00	MSFT	Stock	50.55	50.65	50.39	50.56	19540.0
2016-05-09 09:00:00	MSFT	Stock	50.58	50.58	50.43	50.51	14409.0
2016-05-09 09:30:00	MSFT	Stock	50.55	50.58	50.36	50.55	2193299.0
2016-05-09 10:00:00	MSFT	Stock	50.56	50.585	50.25	50.27	1437631.0
2016-05-09 10:30:00	MSFT	Stock	50.27	50.31	50.08	50.11	1205464.0
2016-05-09 11:00:00	MSFT	Stock	50.104	50.19	50.0	50.175	1296421.0
2016-05-09 11:30:00	MSFT	Stock	50.175	50.345	50.131	50.22	930982.0
2016-05-09 12:00:00	MSFT	Stock	50.22	50.31	50.16	50.26	992526.0
2016-05-09 12:30:00	MSFT	Stock	50.25	50.27	50.18	50.195	456115.0
2016-05-09 13:00:00	MSFT	Stock	50.19	50.25	50.15	50.195	730555.0
2016-05-09 13:30:00	MSFT	Stock	50.2	50.24	50.15	50.155	595316.0
2016-05-09 14:00:00	MSFT	Stock	50.156	50.2	50.068	50.164	863484.0
2016-05-09 14:30:00	MSFT	Stock	50.16	50.305	50.16	50.295	834555.0

> showing 50 of 83,435 rows — these rows as CSV

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