PREVIEW / stock_30min / 2016-12-12

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-12.parquet
  size:    1.6 MB
  rows:    83,632
  symbols: 3,164

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-12-12 04:00:00	AAPL	Stock	28.355	28.355	28.2175	28.2175	3936.0
2016-12-12 04:30:00	AAPL	Stock	28.2175	28.24	28.2125	28.24	4124.0
2016-12-12 05:00:00	AAPL	Stock	28.24	28.24	28.24	28.24	1520.0
2016-12-12 05:30:00	AAPL	Stock	28.24	28.24	28.24	28.24	1120.0
2016-12-12 06:00:00	AAPL	Stock	28.305	28.305	28.305	28.305	400.0
2016-12-12 06:30:00	AAPL	Stock	28.3025	28.315	28.2825	28.315	10980.0
2016-12-12 07:00:00	AAPL	Stock	28.3325	28.3375	28.29	28.3375	39572.0
2016-12-12 07:30:00	AAPL	Stock	28.335	28.335	28.295	28.32	30092.0
2016-12-12 08:00:00	AAPL	Stock	28.2875	28.38	28.2875	28.38	123036.0
2016-12-12 08:30:00	AAPL	Stock	28.38	28.4175	28.35	28.375	193808.0
2016-12-12 09:00:00	AAPL	Stock	28.3775	28.42	28.275	28.3325	249936.0
2016-12-12 09:30:00	AAPL	Stock	28.325	28.3338	28.1225	28.2575	21616440.0
2016-12-12 10:00:00	AAPL	Stock	28.2575	28.2758	28.15	28.1525	9182932.0
2016-12-12 10:30:00	AAPL	Stock	28.1525	28.2825	28.13	28.28	7871212.0
2016-12-12 11:00:00	AAPL	Stock	28.2812	28.285	28.2112	28.2162	4433836.0
2016-12-12 11:30:00	AAPL	Stock	28.2162	28.285	28.215	28.2525	5162328.0
2016-12-12 12:00:00	AAPL	Stock	28.2525	28.2525	28.171	28.2275	4473944.0
2016-12-12 12:30:00	AAPL	Stock	28.2275	28.26	28.2125	28.25	3675444.0
2016-12-12 13:00:00	AAPL	Stock	28.25	28.3225	28.2312	28.2312	3916712.0
2016-12-12 13:30:00	AAPL	Stock	28.2325	28.235	28.18	28.2085	3396596.0
2016-12-12 14:00:00	AAPL	Stock	28.21	28.235	28.1875	28.2338	3774196.0
2016-12-12 14:30:00	AAPL	Stock	28.2338	28.2775	28.23	28.2375	4356892.0
2016-12-12 15:00:00	AAPL	Stock	28.2375	28.2875	28.235	28.2788	4332748.0
2016-12-12 15:30:00	AAPL	Stock	28.2792	28.3275	28.255	28.3225	10325028.0
2016-12-12 16:00:00	AAPL	Stock	28.33	28.33	28.3	28.325	9333660.0
2016-12-12 16:30:00	AAPL	Stock	28.3125	28.315	28.3	28.3125	30268.0
2016-12-12 17:00:00	AAPL	Stock	28.3075	28.315	28.29	28.3	15364.0
2016-12-12 17:30:00	AAPL	Stock	28.295	28.3175	28.29	28.29	16816.0
2016-12-12 18:00:00	AAPL	Stock	28.3	28.3	28.2625	28.2625	7768.0
2016-12-12 18:30:00	AAPL	Stock	28.2975	28.2975	28.28	28.2825	3144.0
2016-12-12 19:00:00	AAPL	Stock	28.3	28.3	28.2775	28.3	3800.0
2016-12-12 19:30:00	AAPL	Stock	28.3	28.3	28.2825	28.2825	8600.0
2016-12-12 04:00:00	MSFT	Stock	61.95	61.95	61.95	61.95	100.0
2016-12-12 07:00:00	MSFT	Stock	61.73	61.73	61.73	61.73	400.0
2016-12-12 07:30:00	MSFT	Stock	61.73	61.75	61.73	61.75	309.0
2016-12-12 08:00:00	MSFT	Stock	61.75	61.95	61.75	61.95	3404.0
2016-12-12 08:30:00	MSFT	Stock	61.81	61.81	61.75	61.81	2939.0
2016-12-12 09:00:00	MSFT	Stock	61.79	61.92	61.66	61.92	30907.0
2016-12-12 09:30:00	MSFT	Stock	61.87	62.08	61.72	62.05	2937098.0
2016-12-12 10:00:00	MSFT	Stock	62.045	62.15	61.85	61.865	1758466.0
2016-12-12 10:30:00	MSFT	Stock	61.86	62.08	61.85	62.07	1066826.0
2016-12-12 11:00:00	MSFT	Stock	62.07	62.3	62.01	62.05	1348483.0
2016-12-12 11:30:00	MSFT	Stock	62.05	62.08	61.9	61.925	1064717.0
2016-12-12 12:00:00	MSFT	Stock	61.92	61.92	61.76	61.86	826506.0
2016-12-12 12:30:00	MSFT	Stock	61.87	61.955	61.835	61.92	792670.0
2016-12-12 13:00:00	MSFT	Stock	61.93	62.0	61.895	61.95	675870.0
2016-12-12 13:30:00	MSFT	Stock	61.95	61.96	61.79	61.835	780926.0
2016-12-12 14:00:00	MSFT	Stock	61.83	61.95	61.82	61.88	868766.0
2016-12-12 14:30:00	MSFT	Stock	61.88	61.98	61.85	61.96	760122.0
2016-12-12 15:00:00	MSFT	Stock	61.955	62.12	61.94	62.055	1112495.0

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

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