PREVIEW / stock_30min / 2019-06-04

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-04.parquet
  size:    1.7 MB
  rows:    85,188
  symbols: 2,601

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
2019-06-04 04:00:00	AAPL	Stock	43.575	43.6	43.525	43.5325	18368.0
2019-06-04 04:30:00	AAPL	Stock	43.6	43.6875	43.56	43.675	29984.0
2019-06-04 05:00:00	AAPL	Stock	43.7425	43.7425	43.61	43.6825	19248.0
2019-06-04 05:30:00	AAPL	Stock	43.6	43.6975	43.6	43.6875	20576.0
2019-06-04 06:00:00	AAPL	Stock	43.7125	43.745	43.7025	43.745	20000.0
2019-06-04 06:30:00	AAPL	Stock	43.7125	43.7125	43.5925	43.5925	5800.0
2019-06-04 07:00:00	AAPL	Stock	43.625	43.69	43.45	43.5025	171920.0
2019-06-04 07:30:00	AAPL	Stock	43.5025	43.8	43.475	43.675	142740.0
2019-06-04 08:00:00	AAPL	Stock	43.6125	43.8725	43.45	43.8125	387972.0
2019-06-04 08:30:00	AAPL	Stock	43.8225	43.8425	43.75	43.8025	255300.0
2019-06-04 09:00:00	AAPL	Stock	43.805	43.9475	43.8	43.8425	237836.0
2019-06-04 09:30:00	AAPL	Stock	43.86	44.1	43.63	44.0255	17420124.0
2019-06-04 10:00:00	AAPL	Stock	44.025	44.3575	43.8575	44.3575	9472716.0
2019-06-04 10:30:00	AAPL	Stock	44.355	44.725	44.3425	44.5675	9384164.0
2019-06-04 11:00:00	AAPL	Stock	44.5625	44.9375	44.53	44.9135	9114124.0
2019-06-04 11:30:00	AAPL	Stock	44.915	44.9315	44.625	44.6325	7266748.0
2019-06-04 12:00:00	AAPL	Stock	44.6325	44.6725	44.4925	44.542	5507484.0
2019-06-04 12:30:00	AAPL	Stock	44.5425	44.695	44.4975	44.6572	5307384.0
2019-06-04 13:00:00	AAPL	Stock	44.655	44.7	44.48	44.64	3946372.0
2019-06-04 13:30:00	AAPL	Stock	44.64	44.9025	44.62	44.8787	5463572.0
2019-06-04 14:00:00	AAPL	Stock	44.88	44.9	44.69	44.6975	4036304.0
2019-06-04 14:30:00	AAPL	Stock	44.6975	44.8225	44.675	44.7627	3501896.0
2019-06-04 15:00:00	AAPL	Stock	44.7675	44.94	44.7675	44.905	4633116.0
2019-06-04 15:30:00	AAPL	Stock	44.905	44.9575	44.7975	44.9175	10172716.0
2019-06-04 16:00:00	AAPL	Stock	44.91	44.975	44.8	44.91	9559720.0
2019-06-04 16:30:00	AAPL	Stock	44.95	44.975	44.9375	44.975	23736.0
2019-06-04 17:00:00	AAPL	Stock	44.975	45.055	44.975	45.055	55652.0
2019-06-04 17:30:00	AAPL	Stock	45.0692	45.0875	45.03	45.04	25944.0
2019-06-04 18:00:00	AAPL	Stock	45.0625	45.2	45.0625	45.2	47832.0
2019-06-04 18:30:00	AAPL	Stock	45.1875	45.1925	45.12	45.165	33416.0
2019-06-04 19:00:00	AAPL	Stock	45.14	45.2375	45.135	45.15	49796.0
2019-06-04 19:30:00	AAPL	Stock	45.15	45.375	45.15	45.375	140576.0
2019-06-04 04:00:00	MSFT	Stock	120.28	120.58	120.25	120.58	400.0
2019-06-04 04:30:00	MSFT	Stock	120.62	120.62	120.25	120.47	11769.0
2019-06-04 05:00:00	MSFT	Stock	120.47	120.51	120.47	120.49	464.0
2019-06-04 05:30:00	MSFT	Stock	120.49	121.0	120.49	120.9	5640.0
2019-06-04 06:00:00	MSFT	Stock	120.9	120.9	120.8	120.8	500.0
2019-06-04 06:30:00	MSFT	Stock	120.8	120.8	120.45	120.57	2757.0
2019-06-04 07:00:00	MSFT	Stock	120.5	120.8	120.34	120.49	17654.0
2019-06-04 07:30:00	MSFT	Stock	120.49	121.0	120.45	120.84	29803.0
2019-06-04 08:00:00	MSFT	Stock	120.55	121.3	120.13	121.15	51177.0
2019-06-04 08:30:00	MSFT	Stock	121.28	121.4	121.02	121.18	29690.0
2019-06-04 09:00:00	MSFT	Stock	121.15	121.48	121.07	121.27	40988.0
2019-06-04 09:30:00	MSFT	Stock	121.29	122.08	120.652	121.338	3924577.0
2019-06-04 10:00:00	MSFT	Stock	121.31	122.146	121.2	122.022	2569798.0
2019-06-04 10:30:00	MSFT	Stock	122.028	122.09	121.49	121.9	2167130.0
2019-06-04 11:00:00	MSFT	Stock	121.9	122.61	121.8	122.46	2029653.0
2019-06-04 11:30:00	MSFT	Stock	122.46	122.66	122.24	122.37	1298426.0
2019-06-04 12:00:00	MSFT	Stock	122.38	122.45	122.046	122.165	983523.0
2019-06-04 12:30:00	MSFT	Stock	122.17	122.59	122.07	122.48	969337.0

> showing 50 of 85,188 rows — these rows as CSV

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