PREVIEW / stock_30min / 2016-08-19

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-19.parquet
  size:    1.6 MB
  rows:    80,339
  symbols: 3,258

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-19 04:00:00	AAPL	Stock	27.255	27.255	27.24	27.24	6944.0
2016-08-19 04:30:00	AAPL	Stock	27.2175	27.2175	27.1975	27.1975	2000.0
2016-08-19 05:30:00	AAPL	Stock	27.2225	27.2225	27.215	27.215	2400.0
2016-08-19 06:00:00	AAPL	Stock	27.25	27.25	27.25	27.25	400.0
2016-08-19 06:30:00	AAPL	Stock	27.2525	27.2525	27.24	27.24	5504.0
2016-08-19 07:00:00	AAPL	Stock	27.2425	27.25	27.2425	27.25	5800.0
2016-08-19 07:30:00	AAPL	Stock	27.245	27.25	27.225	27.2375	46760.0
2016-08-19 08:00:00	AAPL	Stock	27.22	27.265	27.22	27.2525	125904.0
2016-08-19 08:30:00	AAPL	Stock	27.24	27.2625	27.24	27.25	45100.0
2016-08-19 09:00:00	AAPL	Stock	27.25	27.2675	27.18	27.2025	238964.0
2016-08-19 09:30:00	AAPL	Stock	27.195	27.2175	27.09	27.205	20260716.0
2016-08-19 10:00:00	AAPL	Stock	27.205	27.305	27.1688	27.3025	9057764.0
2016-08-19 10:30:00	AAPL	Stock	27.305	27.3475	27.2575	27.3435	9100504.0
2016-08-19 11:00:00	AAPL	Stock	27.3438	27.385	27.3225	27.37	5605612.0
2016-08-19 11:30:00	AAPL	Stock	27.371	27.3975	27.345	27.393	5381688.0
2016-08-19 12:00:00	AAPL	Stock	27.395	27.4225	27.385	27.3925	3922384.0
2016-08-19 12:30:00	AAPL	Stock	27.3925	27.4125	27.2975	27.33	5476972.0
2016-08-19 13:00:00	AAPL	Stock	27.33	27.335	27.2875	27.3078	4259604.0
2016-08-19 13:30:00	AAPL	Stock	27.3075	27.3325	27.295	27.3112	3703008.0
2016-08-19 14:00:00	AAPL	Stock	27.31	27.335	27.27	27.285	3771928.0
2016-08-19 14:30:00	AAPL	Stock	27.285	27.3125	27.265	27.2962	4069524.0
2016-08-19 15:00:00	AAPL	Stock	27.2975	27.3325	27.29	27.3225	4383592.0
2016-08-19 15:30:00	AAPL	Stock	27.3238	27.35	27.3175	27.34	8061736.0
2016-08-19 16:00:00	AAPL	Stock	27.3388	27.36	27.3	27.335	6165220.0
2016-08-19 16:30:00	AAPL	Stock	27.335	27.39	27.335	27.35	148180.0
2016-08-19 17:00:00	AAPL	Stock	27.36	27.375	27.35	27.35	55620.0
2016-08-19 17:30:00	AAPL	Stock	27.345	27.3525	27.345	27.3525	9420.0
2016-08-19 18:00:00	AAPL	Stock	27.345	27.35	27.345	27.35	3620.0
2016-08-19 18:30:00	AAPL	Stock	27.35	27.3675	27.34	27.34	238944.0
2016-08-19 19:00:00	AAPL	Stock	27.3525	27.3525	27.3525	27.3525	1200.0
2016-08-19 19:30:00	AAPL	Stock	27.3625	27.3625	27.35	27.355	18016.0
2016-08-19 04:30:00	MSFT	Stock	57.5	57.5	57.5	57.5	2000.0
2016-08-19 07:30:00	MSFT	Stock	57.42	57.43	57.42	57.43	400.0
2016-08-19 08:00:00	MSFT	Stock	57.45	57.45	57.45	57.45	8160.0
2016-08-19 08:30:00	MSFT	Stock	57.45	57.47	57.45	57.46	3439.0
2016-08-19 09:00:00	MSFT	Stock	57.5	57.5	57.34	57.43	15254.0
2016-08-19 09:30:00	MSFT	Stock	57.5	57.5	57.244	57.28	3498540.0
2016-08-19 10:00:00	MSFT	Stock	57.28	57.63	57.2	57.625	1242385.0
2016-08-19 10:30:00	MSFT	Stock	57.625	57.73	57.55	57.605	1389753.0
2016-08-19 11:00:00	MSFT	Stock	57.6	57.71	57.585	57.695	782437.0
2016-08-19 11:30:00	MSFT	Stock	57.695	57.705	57.6	57.68	577785.0
2016-08-19 12:00:00	MSFT	Stock	57.675	57.725	57.61	57.635	487799.0
2016-08-19 12:30:00	MSFT	Stock	57.63	57.636	57.4	57.46	782609.0
2016-08-19 13:00:00	MSFT	Stock	57.45	57.5	57.42	57.46	575180.0
2016-08-19 13:30:00	MSFT	Stock	57.47	57.57	57.42	57.505	629468.0
2016-08-19 14:00:00	MSFT	Stock	57.505	57.57	57.5	57.52	471566.0
2016-08-19 14:30:00	MSFT	Stock	57.53	57.62	57.52	57.594	609536.0
2016-08-19 15:00:00	MSFT	Stock	57.6	57.68	57.58	57.64	779893.0
2016-08-19 15:30:00	MSFT	Stock	57.65	57.66	57.56	57.62	1707022.0
2016-08-19 16:00:00	MSFT	Stock	57.61	57.62	57.52	57.53	2792413.0

> showing 50 of 80,339 rows — these rows as CSV

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