PREVIEW / stock_30min / 2016-09-12

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-12.parquet
  size:    1.6 MB
  rows:    83,556
  symbols: 3,239

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-09-12 04:00:00	AAPL	Stock	25.5025	25.5625	25.5025	25.5175	32480.0
2016-09-12 04:30:00	AAPL	Stock	25.515	25.515	25.4775	25.51	40352.0
2016-09-12 05:00:00	AAPL	Stock	25.55	25.55	25.55	25.55	3596.0
2016-09-12 05:30:00	AAPL	Stock	25.575	25.575	25.5	25.5	14072.0
2016-09-12 06:00:00	AAPL	Stock	25.5025	25.5025	25.475	25.475	28400.0
2016-09-12 06:30:00	AAPL	Stock	25.4625	25.4925	25.455	25.49	25964.0
2016-09-12 07:00:00	AAPL	Stock	25.4925	25.55	25.4925	25.525	120656.0
2016-09-12 07:30:00	AAPL	Stock	25.5275	25.645	25.5	25.6375	82500.0
2016-09-12 08:00:00	AAPL	Stock	25.6375	25.6875	25.45	25.65	397560.0
2016-09-12 08:30:00	AAPL	Stock	25.68	25.7375	25.6525	25.6925	197144.0
2016-09-12 09:00:00	AAPL	Stock	25.6925	25.7375	25.6625	25.6625	397336.0
2016-09-12 09:30:00	AAPL	Stock	25.6625	26.075	25.6325	26.0588	32712960.0
2016-09-12 10:00:00	AAPL	Stock	26.058	26.1725	26.0478	26.115	15520888.0
2016-09-12 10:30:00	AAPL	Stock	26.1175	26.1812	26.0625	26.15	10137824.0
2016-09-12 11:00:00	AAPL	Stock	26.15	26.25	26.15	26.1938	9258212.0
2016-09-12 11:30:00	AAPL	Stock	26.1925	26.215	26.125	26.1338	7296612.0
2016-09-12 12:00:00	AAPL	Stock	26.1338	26.15	26.085	26.1388	6401236.0
2016-09-12 12:30:00	AAPL	Stock	26.14	26.225	26.1175	26.19	6228496.0
2016-09-12 13:00:00	AAPL	Stock	26.19	26.2275	26.0825	26.1	9116852.0
2016-09-12 13:30:00	AAPL	Stock	26.1025	26.2525	26.0575	26.24	9515724.0
2016-09-12 14:00:00	AAPL	Stock	26.2375	26.3025	26.2278	26.295	8416796.0
2016-09-12 14:30:00	AAPL	Stock	26.2925	26.375	26.2925	26.365	8050352.0
2016-09-12 15:00:00	AAPL	Stock	26.3675	26.3925	26.325	26.355	8720644.0
2016-09-12 15:30:00	AAPL	Stock	26.356	26.43	26.3475	26.36	19898732.0
2016-09-12 16:00:00	AAPL	Stock	26.3625	26.4025	26.1635	26.36	14364120.0
2016-09-12 16:30:00	AAPL	Stock	26.3625	26.375	26.36	26.365	26780.0
2016-09-12 17:00:00	AAPL	Stock	26.3625	26.38	26.3625	26.3775	78940.0
2016-09-12 17:30:00	AAPL	Stock	26.3925	26.405	26.3625	26.4	95556.0
2016-09-12 18:00:00	AAPL	Stock	26.4	26.4075	26.36	26.4	238836.0
2016-09-12 18:30:00	AAPL	Stock	26.4025	26.4375	26.4	26.4325	105120.0
2016-09-12 19:00:00	AAPL	Stock	26.425	26.4325	26.4225	26.4325	33876.0
2016-09-12 19:30:00	AAPL	Stock	26.4325	26.45	26.42	26.4275	98388.0
2016-09-12 04:00:00	MSFT	Stock	55.8	55.8	55.42	55.42	300.0
2016-09-12 04:30:00	MSFT	Stock	55.86	55.86	55.86	55.86	100.0
2016-09-12 07:00:00	MSFT	Stock	55.72	55.73	55.72	55.73	1110.0
2016-09-12 07:30:00	MSFT	Stock	55.8	55.9	55.75	55.9	4801.0
2016-09-12 08:00:00	MSFT	Stock	55.85	55.96	55.7	55.95	8309.0
2016-09-12 08:30:00	MSFT	Stock	55.91	56.09	55.91	56.09	9447.0
2016-09-12 09:00:00	MSFT	Stock	56.0	56.0	55.89	55.89	15009.0
2016-09-12 09:30:00	MSFT	Stock	55.85	56.24	55.61	56.17	3543152.0
2016-09-12 10:00:00	MSFT	Stock	56.17	56.45	56.11	56.4	1725466.0
2016-09-12 10:30:00	MSFT	Stock	56.4	56.5	56.28	56.395	1279254.0
2016-09-12 11:00:00	MSFT	Stock	56.395	56.52	56.315	56.39	1263307.0
2016-09-12 11:30:00	MSFT	Stock	56.397	56.45	56.27	56.435	1304059.0
2016-09-12 12:00:00	MSFT	Stock	56.435	56.44	56.35	56.42	1021857.0
2016-09-12 12:30:00	MSFT	Stock	56.42	56.7	56.4	56.655	1386985.0
2016-09-12 13:00:00	MSFT	Stock	56.66	56.92	56.58	56.61	2076471.0
2016-09-12 13:30:00	MSFT	Stock	56.62	57.0	56.535	56.97	1415734.0
2016-09-12 14:00:00	MSFT	Stock	56.96	57.09	56.94	57.02	1304380.0
2016-09-12 14:30:00	MSFT	Stock	57.03	57.165	57.0	57.057	1405314.0

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

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