PREVIEW / stock_30min / 2017-06-22

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-22.parquet
  size:    1.6 MB
  rows:    80,881
  symbols: 3,023

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
2017-06-22 04:00:00	AAPL	Stock	36.5225	36.5225	36.5225	36.5225	800.0
2017-06-22 04:30:00	AAPL	Stock	36.4925	36.4925	36.4875	36.4875	1716.0
2017-06-22 06:00:00	AAPL	Stock	36.485	36.485	36.455	36.455	3624.0
2017-06-22 06:30:00	AAPL	Stock	36.45	36.45	36.45	36.45	1140.0
2017-06-22 07:00:00	AAPL	Stock	36.47	36.47	36.47	36.47	400.0
2017-06-22 07:30:00	AAPL	Stock	36.46	36.46	36.4125	36.4475	24092.0
2017-06-22 08:00:00	AAPL	Stock	36.45	36.465	36.4175	36.465	53980.0
2017-06-22 08:30:00	AAPL	Stock	36.475	36.48	36.4475	36.4475	32312.0
2017-06-22 09:00:00	AAPL	Stock	36.4475	36.5	36.405	36.4375	39388.0
2017-06-22 09:30:00	AAPL	Stock	36.4375	36.4925	36.28	36.3325	8539228.0
2017-06-22 10:00:00	AAPL	Stock	36.335	36.425	36.2925	36.3175	5099224.0
2017-06-22 10:30:00	AAPL	Stock	36.3175	36.4475	36.28	36.38	5493036.0
2017-06-22 11:00:00	AAPL	Stock	36.38	36.3938	36.295	36.355	3177488.0
2017-06-22 11:30:00	AAPL	Stock	36.3575	36.3658	36.29	36.3425	3220604.0
2017-06-22 12:00:00	AAPL	Stock	36.34	36.395	36.31	36.3852	1858300.0
2017-06-22 12:30:00	AAPL	Stock	36.3875	36.61	36.365	36.5875	4965660.0
2017-06-22 13:00:00	AAPL	Stock	36.5892	36.675	36.57	36.5775	5138208.0
2017-06-22 13:30:00	AAPL	Stock	36.5798	36.62	36.56	36.605	2303976.0
2017-06-22 14:00:00	AAPL	Stock	36.605	36.63	36.56	36.5825	2692204.0
2017-06-22 14:30:00	AAPL	Stock	36.58	36.6125	36.565	36.5775	2180340.0
2017-06-22 15:00:00	AAPL	Stock	36.5775	36.5825	36.4988	36.517	4438644.0
2017-06-22 15:30:00	AAPL	Stock	36.5168	36.5338	36.38	36.4075	8159492.0
2017-06-22 16:00:00	AAPL	Stock	36.41	36.41	36.3975	36.4075	11271916.0
2017-06-22 16:30:00	AAPL	Stock	36.4075	36.4925	36.4	36.42	126368.0
2017-06-22 17:00:00	AAPL	Stock	36.4025	36.4125	36.4025	36.4125	23152.0
2017-06-22 17:30:00	AAPL	Stock	36.4125	36.4125	36.4075	36.4075	6364.0
2017-06-22 18:00:00	AAPL	Stock	36.4125	36.4125	36.4125	36.4125	9272.0
2017-06-22 18:30:00	AAPL	Stock	36.4025	36.41	36.4025	36.4075	5720.0
2017-06-22 19:00:00	AAPL	Stock	36.4075	36.4125	36.3975	36.4125	38192.0
2017-06-22 19:30:00	AAPL	Stock	36.425	36.4275	36.41	36.41	16744.0
2017-06-22 07:00:00	MSFT	Stock	70.6	70.6	70.6	70.6	400.0
2017-06-22 07:30:00	MSFT	Stock	70.65	70.65	70.65	70.65	100.0
2017-06-22 08:00:00	MSFT	Stock	70.6	70.78	70.6	70.68	4985.0
2017-06-22 08:30:00	MSFT	Stock	70.61	70.74	70.61	70.7	17517.0
2017-06-22 09:00:00	MSFT	Stock	70.7	70.7	70.31	70.39	41331.0
2017-06-22 09:30:00	MSFT	Stock	70.39	70.59	69.84	69.91	3440940.0
2017-06-22 10:00:00	MSFT	Stock	69.92	69.93	69.71	69.891	2228842.0
2017-06-22 10:30:00	MSFT	Stock	69.89	70.07	69.84	69.96	1938158.0
2017-06-22 11:00:00	MSFT	Stock	69.97	70.015	69.85	69.985	1496268.0
2017-06-22 11:30:00	MSFT	Stock	69.985	70.13	69.94	70.0	1611044.0
2017-06-22 12:00:00	MSFT	Stock	69.995	70.026	69.87	69.984	834841.0
2017-06-22 12:30:00	MSFT	Stock	69.99	70.085	69.97	70.0	1377418.0
2017-06-22 13:00:00	MSFT	Stock	70.0	70.29	69.97	70.279	1243895.0
2017-06-22 13:30:00	MSFT	Stock	70.28	70.35	70.19	70.345	669511.0
2017-06-22 14:00:00	MSFT	Stock	70.35	70.475	70.335	70.385	816438.0
2017-06-22 14:30:00	MSFT	Stock	70.38	70.45	70.27	70.37	778326.0
2017-06-22 15:00:00	MSFT	Stock	70.37	70.46	70.34	70.415	1018065.0
2017-06-22 15:30:00	MSFT	Stock	70.415	70.45	70.25	70.26	2277681.0
2017-06-22 16:00:00	MSFT	Stock	70.26	70.26	70.17	70.17	1249518.0
2017-06-22 16:30:00	MSFT	Stock	70.26	70.26	70.26	70.26	331896.0

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

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