PREVIEW / stock_30min / 2016-03-16

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-16.parquet
  size:    1.6 MB
  rows:    81,167
  symbols: 3,313

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-03-16 04:30:00	AAPL	Stock	26.175	26.175	26.15	26.15	4340.0
2016-03-16 05:00:00	AAPL	Stock	26.165	26.1825	26.165	26.1775	2800.0
2016-03-16 05:30:00	AAPL	Stock	26.175	26.1975	26.175	26.175	4928.0
2016-03-16 06:00:00	AAPL	Stock	26.175	26.175	26.1625	26.1625	11268.0
2016-03-16 06:30:00	AAPL	Stock	26.1925	26.215	26.1625	26.21	13000.0
2016-03-16 07:00:00	AAPL	Stock	26.1875	26.195	26.1775	26.195	8900.0
2016-03-16 07:30:00	AAPL	Stock	26.1875	26.1875	26.1375	26.1375	28268.0
2016-03-16 08:00:00	AAPL	Stock	26.165	26.2	26.145	26.1525	119556.0
2016-03-16 08:30:00	AAPL	Stock	26.155	26.1725	26.1025	26.1375	95584.0
2016-03-16 09:00:00	AAPL	Stock	26.145	26.17	26.0875	26.1225	323424.0
2016-03-16 09:30:00	AAPL	Stock	26.1225	26.3075	26.1225	26.3	16080964.0
2016-03-16 10:00:00	AAPL	Stock	26.3	26.3225	26.24	26.2675	9986016.0
2016-03-16 10:30:00	AAPL	Stock	26.27	26.35	26.2675	26.3132	7826788.0
2016-03-16 11:00:00	AAPL	Stock	26.3138	26.35	26.3025	26.3462	6319388.0
2016-03-16 11:30:00	AAPL	Stock	26.3475	26.355	26.3225	26.3445	7465596.0
2016-03-16 12:00:00	AAPL	Stock	26.344	26.3575	26.315	26.3388	4783148.0
2016-03-16 12:30:00	AAPL	Stock	26.34	26.445	26.3275	26.3678	11009388.0
2016-03-16 13:00:00	AAPL	Stock	26.37	26.3925	26.295	26.3075	4922276.0
2016-03-16 13:30:00	AAPL	Stock	26.3088	26.335	26.2525	26.325	6413204.0
2016-03-16 14:00:00	AAPL	Stock	26.325	26.52	26.325	26.425	15079200.0
2016-03-16 14:30:00	AAPL	Stock	26.425	26.545	26.4162	26.48	11788816.0
2016-03-16 15:00:00	AAPL	Stock	26.48	26.5625	26.4775	26.51	10288536.0
2016-03-16 15:30:00	AAPL	Stock	26.5075	26.5775	26.43	26.4925	19267868.0
2016-03-16 16:00:00	AAPL	Stock	26.4925	26.505	26.125	26.2825	6803080.0
2016-03-16 16:30:00	AAPL	Stock	26.2825	26.375	26.255	26.3125	291288.0
2016-03-16 17:00:00	AAPL	Stock	26.3125	26.4925	26.2875	26.2975	161516.0
2016-03-16 17:30:00	AAPL	Stock	26.3075	26.3075	26.2825	26.3	24800.0
2016-03-16 18:00:00	AAPL	Stock	26.315	26.345	26.315	26.315	71004.0
2016-03-16 18:30:00	AAPL	Stock	26.325	26.3625	26.325	26.35	50644.0
2016-03-16 19:00:00	AAPL	Stock	26.37	26.37	26.35	26.3625	36648.0
2016-03-16 19:30:00	AAPL	Stock	26.3625	26.375	26.3525	26.36	36040.0
2016-03-16 05:30:00	MSFT	Stock	53.7	53.74	53.7	53.74	400.0
2016-03-16 06:30:00	MSFT	Stock	53.73	53.73	53.73	53.73	700.0
2016-03-16 07:00:00	MSFT	Stock	53.69	53.69	53.69	53.69	150.0
2016-03-16 08:00:00	MSFT	Stock	53.58	53.7	53.5	53.58	2539.0
2016-03-16 08:30:00	MSFT	Stock	53.5	53.57	53.24	53.53	41977.0
2016-03-16 09:00:00	MSFT	Stock	53.53	53.53	53.39	53.44	34952.0
2016-03-16 09:30:00	MSFT	Stock	53.45	53.65	53.4	53.57	2066402.0
2016-03-16 10:00:00	MSFT	Stock	53.57	53.7	53.465	53.615	1816029.0
2016-03-16 10:30:00	MSFT	Stock	53.605	53.829	53.56	53.79	1452874.0
2016-03-16 11:00:00	MSFT	Stock	53.782	53.9	53.755	53.874	1408129.0
2016-03-16 11:30:00	MSFT	Stock	53.87	54.31	53.87	54.01	2482298.0
2016-03-16 12:00:00	MSFT	Stock	54.011	54.06	53.91	53.966	1161503.0
2016-03-16 12:30:00	MSFT	Stock	53.97	53.99	53.6	53.68	1033013.0
2016-03-16 13:00:00	MSFT	Stock	53.68	53.805	53.63	53.72	874484.0
2016-03-16 13:30:00	MSFT	Stock	53.721	53.88	53.7	53.86	886562.0
2016-03-16 14:00:00	MSFT	Stock	53.87	54.44	53.86	54.175	2681740.0
2016-03-16 14:30:00	MSFT	Stock	54.179	54.38	54.11	54.135	2165011.0
2016-03-16 15:00:00	MSFT	Stock	54.135	54.47	54.13	54.4	2827650.0
2016-03-16 15:30:00	MSFT	Stock	54.4	54.6	54.24	54.35	5566757.0

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

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