PREVIEW / stock_30min / 2015-09-25

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-25.parquet
  size:    1.6 MB
  rows:    82,036
  symbols: 3,460

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
2015-09-25 04:00:00	AAPL	Stock	28.935	29.0175	28.935	29.01	23084.0
2015-09-25 04:30:00	AAPL	Stock	28.975	29.05	28.975	29.05	34020.0
2015-09-25 05:00:00	AAPL	Stock	29.0275	29.1125	29.0275	29.0625	24772.0
2015-09-25 05:30:00	AAPL	Stock	29.1025	29.1125	29.05	29.0975	9856.0
2015-09-25 06:00:00	AAPL	Stock	29.075	29.1025	29.0075	29.075	87148.0
2015-09-25 06:30:00	AAPL	Stock	29.055	29.07	29.0075	29.05	32284.0
2015-09-25 07:00:00	AAPL	Stock	29.055	29.1225	29.055	29.075	205192.0
2015-09-25 07:30:00	AAPL	Stock	29.09	29.105	29.05	29.075	172096.0
2015-09-25 08:00:00	AAPL	Stock	29.1	29.125	29.04	29.075	1003600.0
2015-09-25 08:30:00	AAPL	Stock	29.07	29.0925	29.0475	29.0675	560488.0
2015-09-25 09:00:00	AAPL	Stock	29.0625	29.1075	29.0	29.0925	737168.0
2015-09-25 09:30:00	AAPL	Stock	29.11	29.1725	28.9288	29.02	29940660.0
2015-09-25 10:00:00	AAPL	Stock	29.0225	29.04	28.8125	28.8875	18792652.0
2015-09-25 10:30:00	AAPL	Stock	28.89	28.96	28.8175	28.9425	12528656.0
2015-09-25 11:00:00	AAPL	Stock	28.9425	28.9925	28.9075	28.9725	9173156.0
2015-09-25 11:30:00	AAPL	Stock	28.9722	28.9775	28.8	28.8525	9921776.0
2015-09-25 12:00:00	AAPL	Stock	28.8548	28.855	28.675	28.715	12728340.0
2015-09-25 12:30:00	AAPL	Stock	28.715	28.8832	28.715	28.855	8998324.0
2015-09-25 13:00:00	AAPL	Stock	28.8575	29.004	28.785	28.8775	12261676.0
2015-09-25 13:30:00	AAPL	Stock	28.88	28.925	28.7825	28.8075	7729092.0
2015-09-25 14:00:00	AAPL	Stock	28.81	28.8775	28.7	28.7325	11558208.0
2015-09-25 14:30:00	AAPL	Stock	28.73	28.7675	28.57	28.715	17727348.0
2015-09-25 15:00:00	AAPL	Stock	28.715	28.7475	28.505	28.715	20301012.0
2015-09-25 15:30:00	AAPL	Stock	28.715	28.81	28.6675	28.6875	24336528.0
2015-09-25 16:00:00	AAPL	Stock	28.6775	28.7025	28.6775	28.7025	10847812.0
2015-09-25 16:30:00	AAPL	Stock	28.6975	28.6975	28.6625	28.6775	73544.0
2015-09-25 17:00:00	AAPL	Stock	28.6775	28.6875	28.6775	28.685	49900.0
2015-09-25 17:30:00	AAPL	Stock	28.685	28.685	28.63	28.66	26748.0
2015-09-25 18:00:00	AAPL	Stock	28.66	28.675	28.65	28.66	32368.0
2015-09-25 18:30:00	AAPL	Stock	28.6625	28.685	28.5	28.645	47636.0
2015-09-25 19:00:00	AAPL	Stock	28.6375	28.675	28.6375	28.6725	40936.0
2015-09-25 19:30:00	AAPL	Stock	28.675	28.69	28.6625	28.68	48160.0
2015-09-25 05:00:00	MSFT	Stock	44.49	44.49	44.49	44.49	100.0
2015-09-25 06:00:00	MSFT	Stock	44.24	44.24	44.24	44.24	700.0
2015-09-25 07:00:00	MSFT	Stock	44.21	44.21	44.21	44.21	200.0
2015-09-25 07:30:00	MSFT	Stock	44.4	44.4	44.4	44.4	200.0
2015-09-25 08:00:00	MSFT	Stock	44.42	44.42	44.32	44.32	3085.0
2015-09-25 08:30:00	MSFT	Stock	44.35	44.36	44.33	44.33	2969.0
2015-09-25 09:00:00	MSFT	Stock	44.32	44.51	44.26	44.51	48389.0
2015-09-25 09:30:00	MSFT	Stock	44.41	44.73	44.28	44.65	3460450.0
2015-09-25 10:00:00	MSFT	Stock	44.65	44.71	44.51	44.525	2149036.0
2015-09-25 10:30:00	MSFT	Stock	44.521	44.71	44.48	44.704	1499767.0
2015-09-25 11:00:00	MSFT	Stock	44.7	44.73	44.595	44.675	1488531.0
2015-09-25 11:30:00	MSFT	Stock	44.68	44.685	44.47	44.584	1534022.0
2015-09-25 12:00:00	MSFT	Stock	44.58	44.58	44.37	44.48	889673.0
2015-09-25 12:30:00	MSFT	Stock	44.48	44.575	44.46	44.57	755816.0
2015-09-25 13:00:00	MSFT	Stock	44.57	44.68	44.5	44.51	1373246.0
2015-09-25 13:30:00	MSFT	Stock	44.51	44.53	44.288	44.46	1445944.0
2015-09-25 14:00:00	MSFT	Stock	44.46	44.58	44.22	44.24	1435630.0
2015-09-25 14:30:00	MSFT	Stock	44.23	44.28	43.965	44.08	2012662.0

> showing 50 of 82,036 rows — these rows as CSV

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