PREVIEW / stock_30min / 2018-04-12

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-12.parquet
  size:    1.6 MB
  rows:    81,980
  symbols: 2,849

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
2018-04-12 04:30:00	AAPL	Stock	43.125	43.125	43.1025	43.1025	1600.0
2018-04-12 05:00:00	AAPL	Stock	43.1025	43.1025	43.1025	43.1025	600.0
2018-04-12 05:30:00	AAPL	Stock	43.05	43.0525	43.05	43.0525	2084.0
2018-04-12 06:00:00	AAPL	Stock	43.005	43.175	43.0	43.175	4420.0
2018-04-12 06:30:00	AAPL	Stock	43.175	43.2625	43.175	43.2625	6296.0
2018-04-12 07:00:00	AAPL	Stock	43.25	43.5	43.25	43.4625	263412.0
2018-04-12 07:30:00	AAPL	Stock	43.47	43.475	43.415	43.425	57996.0
2018-04-12 08:00:00	AAPL	Stock	43.45	43.48	43.3375	43.375	114652.0
2018-04-12 08:30:00	AAPL	Stock	43.39	43.46	43.38	43.425	107084.0
2018-04-12 09:00:00	AAPL	Stock	43.4175	43.485	43.3275	43.3275	255352.0
2018-04-12 09:30:00	AAPL	Stock	43.35	43.6325	43.26	43.6175	13738244.0
2018-04-12 10:00:00	AAPL	Stock	43.62	43.6875	43.549	43.6375	6761668.0
2018-04-12 10:30:00	AAPL	Stock	43.64	43.6775	43.555	43.59	6488028.0
2018-04-12 11:00:00	AAPL	Stock	43.5875	43.715	43.5675	43.6475	5190140.0
2018-04-12 11:30:00	AAPL	Stock	43.642	43.7	43.5275	43.64	5686172.0
2018-04-12 12:00:00	AAPL	Stock	43.6375	43.6825	43.565	43.6675	3493688.0
2018-04-12 12:30:00	AAPL	Stock	43.67	43.715	43.615	43.7038	3174256.0
2018-04-12 13:00:00	AAPL	Stock	43.705	43.7175	43.4575	43.47	4990012.0
2018-04-12 13:30:00	AAPL	Stock	43.465	43.61	43.425	43.5125	4026720.0
2018-04-12 14:00:00	AAPL	Stock	43.5125	43.685	43.49	43.64	3797496.0
2018-04-12 14:30:00	AAPL	Stock	43.6425	43.7025	43.5722	43.685	2990400.0
2018-04-12 15:00:00	AAPL	Stock	43.6875	43.75	43.655	43.73	4761760.0
2018-04-12 15:30:00	AAPL	Stock	43.7275	43.745	43.53	43.54	9772984.0
2018-04-12 16:00:00	AAPL	Stock	43.5375	43.57	43.53	43.535	7270292.0
2018-04-12 16:30:00	AAPL	Stock	43.535	43.55	43.525	43.55	216644.0
2018-04-12 17:00:00	AAPL	Stock	43.5375	43.5625	43.535	43.5625	7680.0
2018-04-12 17:30:00	AAPL	Stock	43.5775	43.585	43.555	43.555	6280.0
2018-04-12 18:00:00	AAPL	Stock	43.5575	43.56	43.5	43.5	34812.0
2018-04-12 18:30:00	AAPL	Stock	43.51	43.51	43.4525	43.4525	15140.0
2018-04-12 19:00:00	AAPL	Stock	43.4525	43.525	43.43	43.4375	11240.0
2018-04-12 19:30:00	AAPL	Stock	43.4325	43.5	43.4325	43.495	42484.0
2018-04-12 04:30:00	MSFT	Stock	92.09	92.09	92.0	92.0	300.0
2018-04-12 06:00:00	MSFT	Stock	92.0	92.0	92.0	92.0	200.0
2018-04-12 07:00:00	MSFT	Stock	92.45	92.6	92.4	92.4	5602.0
2018-04-12 07:30:00	MSFT	Stock	92.49	92.5	92.34	92.5	15546.0
2018-04-12 08:00:00	MSFT	Stock	92.52	92.58	92.05	92.45	16080.0
2018-04-12 08:30:00	MSFT	Stock	92.44	92.5	92.33	92.45	8937.0
2018-04-12 09:00:00	MSFT	Stock	92.45	92.6	92.4	92.54	20045.0
2018-04-12 09:30:00	MSFT	Stock	92.54	93.61	92.43	93.6	2843149.0
2018-04-12 10:00:00	MSFT	Stock	93.59	93.85	93.39	93.66	1568119.0
2018-04-12 10:30:00	MSFT	Stock	93.67	93.78	93.36	93.51	1454155.0
2018-04-12 11:00:00	MSFT	Stock	93.49	93.705	93.325	93.54	1763931.0
2018-04-12 11:30:00	MSFT	Stock	93.55	93.71	93.2	93.435	1071659.0
2018-04-12 12:00:00	MSFT	Stock	93.44	93.53	93.254	93.495	670848.0
2018-04-12 12:30:00	MSFT	Stock	93.5	93.73	93.46	93.695	821462.0
2018-04-12 13:00:00	MSFT	Stock	93.69	93.775	92.9	92.93	1594124.0
2018-04-12 13:30:00	MSFT	Stock	92.92	93.25	92.84	93.1	1248595.0
2018-04-12 14:00:00	MSFT	Stock	93.1	93.62	93.04	93.545	1355829.0
2018-04-12 14:30:00	MSFT	Stock	93.55	93.7	93.355	93.68	890399.0
2018-04-12 15:00:00	MSFT	Stock	93.67	94.04	93.59	94.01	1345239.0

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

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