PREVIEW / stock_30min / 2016-10-19

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-19.parquet
  size:    1.5 MB
  rows:    79,935
  symbols: 3,200

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-10-19 04:00:00	AAPL	Stock	29.27	29.27	29.27	29.27	400.0
2016-10-19 04:30:00	AAPL	Stock	29.2675	29.315	29.25	29.315	1200.0
2016-10-19 05:00:00	AAPL	Stock	29.315	29.315	29.315	29.315	2800.0
2016-10-19 06:00:00	AAPL	Stock	29.3575	29.3575	29.3425	29.3575	7452.0
2016-10-19 06:30:00	AAPL	Stock	29.3675	29.3675	29.3675	29.3675	1600.0
2016-10-19 07:00:00	AAPL	Stock	29.3775	29.4125	29.375	29.4125	5128.0
2016-10-19 07:30:00	AAPL	Stock	29.3875	29.4375	29.3775	29.4375	30324.0
2016-10-19 08:00:00	AAPL	Stock	29.425	29.4362	29.3	29.4	205864.0
2016-10-19 08:30:00	AAPL	Stock	29.4075	29.415	29.33	29.355	319388.0
2016-10-19 09:00:00	AAPL	Stock	29.3425	29.3525	29.3	29.335	184700.0
2016-10-19 09:30:00	AAPL	Stock	29.3125	29.44	29.285	29.4112	11837808.0
2016-10-19 10:00:00	AAPL	Stock	29.41	29.4125	29.3362	29.3725	6279940.0
2016-10-19 10:30:00	AAPL	Stock	29.3725	29.39	29.3145	29.36	5730360.0
2016-10-19 11:00:00	AAPL	Stock	29.36	29.36	28.45	29.28	6321196.0
2016-10-19 11:30:00	AAPL	Stock	29.28	29.3125	29.2425	29.26	5189980.0
2016-10-19 12:00:00	AAPL	Stock	29.2588	29.3075	29.2275	29.305	3465420.0
2016-10-19 12:30:00	AAPL	Stock	29.3025	29.335	29.296	29.3275	3052700.0
2016-10-19 13:00:00	AAPL	Stock	29.33	29.385	29.33	29.3838	3120880.0
2016-10-19 13:30:00	AAPL	Stock	29.385	29.395	29.34	29.35	2974100.0
2016-10-19 14:00:00	AAPL	Stock	29.3488	29.3775	29.325	29.3358	3367352.0
2016-10-19 14:30:00	AAPL	Stock	29.3365	29.3388	29.2625	29.305	6180452.0
2016-10-19 15:00:00	AAPL	Stock	29.3075	29.32	29.2738	29.28	3952216.0
2016-10-19 15:30:00	AAPL	Stock	29.28	29.295	29.255	29.28	7007260.0
2016-10-19 16:00:00	AAPL	Stock	29.28	29.325	29.2725	29.315	4368648.0
2016-10-19 16:30:00	AAPL	Stock	29.315	29.315	29.2875	29.2875	20112.0
2016-10-19 17:00:00	AAPL	Stock	29.2875	29.295	29.185	29.22	173296.0
2016-10-19 17:30:00	AAPL	Stock	29.22	29.28	29.22	29.24	66236.0
2016-10-19 18:00:00	AAPL	Stock	29.25	29.255	29.2375	29.2375	14240.0
2016-10-19 18:30:00	AAPL	Stock	29.2475	29.26	29.24	29.26	8444.0
2016-10-19 19:00:00	AAPL	Stock	29.2625	29.2725	29.2625	29.265	14400.0
2016-10-19 19:30:00	AAPL	Stock	29.265	29.265	29.235	29.2575	42376.0
2016-10-19 05:00:00	MSFT	Stock	57.52	57.52	57.52	57.52	400.0
2016-10-19 06:30:00	MSFT	Stock	57.46	57.46	57.46	57.46	2700.0
2016-10-19 07:00:00	MSFT	Stock	57.46	57.48	57.46	57.47	2200.0
2016-10-19 07:30:00	MSFT	Stock	57.47	57.47	57.47	57.47	1000.0
2016-10-19 08:00:00	MSFT	Stock	57.47	57.49	57.45	57.49	11956.0
2016-10-19 08:30:00	MSFT	Stock	57.5	57.58	57.5	57.55	1677.0
2016-10-19 09:00:00	MSFT	Stock	57.55	57.55	57.5	57.55	6100.0
2016-10-19 09:30:00	MSFT	Stock	57.47	57.58	57.395	57.475	2806967.0
2016-10-19 10:00:00	MSFT	Stock	57.475	57.74	57.47	57.68	1856440.0
2016-10-19 10:30:00	MSFT	Stock	57.69	57.84	57.68	57.775	1412371.0
2016-10-19 11:00:00	MSFT	Stock	57.775	57.79	57.47	57.54	1494903.0
2016-10-19 11:30:00	MSFT	Stock	57.54	57.6	57.5	57.52	792920.0
2016-10-19 12:00:00	MSFT	Stock	57.525	57.56	57.5	57.525	629400.0
2016-10-19 12:30:00	MSFT	Stock	57.525	57.58	57.5	57.553	1005861.0
2016-10-19 13:00:00	MSFT	Stock	57.56	57.64	57.53	57.62	719608.0
2016-10-19 13:30:00	MSFT	Stock	57.62	57.67	57.56	57.57	885837.0
2016-10-19 14:00:00	MSFT	Stock	57.57	57.63	57.55	57.58	826136.0
2016-10-19 14:30:00	MSFT	Stock	57.575	57.64	57.54	57.625	934848.0
2016-10-19 15:00:00	MSFT	Stock	57.63	57.67	57.61	57.63	1208204.0

> showing 50 of 79,935 rows — these rows as CSV

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