PREVIEW / stock_30min / 2017-06-26

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-26.parquet
  size:    1.6 MB
  rows:    82,425
  symbols: 3,029

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-26 05:00:00	AAPL	Stock	36.6925	36.6925	36.6925	36.6925	3888.0
2017-06-26 06:00:00	AAPL	Stock	36.65	36.68	36.65	36.68	6000.0
2017-06-26 06:30:00	AAPL	Stock	36.675	36.675	36.65	36.6525	3216.0
2017-06-26 07:00:00	AAPL	Stock	36.6725	36.6875	36.665	36.6825	110676.0
2017-06-26 07:30:00	AAPL	Stock	36.6875	36.785	36.6875	36.7625	42180.0
2017-06-26 08:00:00	AAPL	Stock	36.755	36.8125	36.665	36.79	250108.0
2017-06-26 08:30:00	AAPL	Stock	36.775	36.8075	36.7625	36.8075	90912.0
2017-06-26 09:00:00	AAPL	Stock	36.8075	36.825	36.775	36.7975	146552.0
2017-06-26 09:30:00	AAPL	Stock	36.7925	37.07	36.7925	36.99	15112948.0
2017-06-26 10:00:00	AAPL	Stock	36.9925	37.0	36.775	36.875	9262484.0
2017-06-26 10:30:00	AAPL	Stock	36.8728	36.8845	36.54	36.625	10156012.0
2017-06-26 11:00:00	AAPL	Stock	36.625	36.63	36.4	36.4588	9195596.0
2017-06-26 11:30:00	AAPL	Stock	36.4575	36.49	36.345	36.4688	7067580.0
2017-06-26 12:00:00	AAPL	Stock	36.4675	36.495	36.4025	36.427	3811480.0
2017-06-26 12:30:00	AAPL	Stock	36.4275	36.6225	36.4275	36.5825	4542840.0
2017-06-26 13:00:00	AAPL	Stock	36.5825	36.5915	36.5075	36.575	2571924.0
2017-06-26 13:30:00	AAPL	Stock	36.5725	36.6025	36.5225	36.55	2472532.0
2017-06-26 14:00:00	AAPL	Stock	36.55	36.565	36.4338	36.46	3725832.0
2017-06-26 14:30:00	AAPL	Stock	36.4612	36.5095	36.4475	36.4873	2472904.0
2017-06-26 15:00:00	AAPL	Stock	36.4875	36.515	36.425	36.4918	4087908.0
2017-06-26 15:30:00	AAPL	Stock	36.49	36.5175	36.4175	36.45	9415928.0
2017-06-26 16:00:00	AAPL	Stock	36.455	36.5	36.45	36.4625	9678680.0
2017-06-26 16:30:00	AAPL	Stock	36.4625	36.475	36.4625	36.475	12688.0
2017-06-26 17:00:00	AAPL	Stock	36.475	36.4925	36.465	36.485	32504.0
2017-06-26 17:30:00	AAPL	Stock	36.49	36.49	36.4675	36.4675	8852.0
2017-06-26 18:00:00	AAPL	Stock	36.47	36.475	36.455	36.475	22944.0
2017-06-26 18:30:00	AAPL	Stock	36.47	36.475	36.4575	36.475	2320.0
2017-06-26 19:00:00	AAPL	Stock	36.4875	36.4875	36.4625	36.4625	4276.0
2017-06-26 19:30:00	AAPL	Stock	36.47	36.4725	36.47	36.47	8080.0
2017-06-26 07:30:00	MSFT	Stock	71.45	71.51	71.4	71.51	9398.0
2017-06-26 08:00:00	MSFT	Stock	71.36	71.59	71.35	71.55	4509.0
2017-06-26 08:30:00	MSFT	Stock	71.53	71.55	71.53	71.55	2351.0
2017-06-26 09:00:00	MSFT	Stock	71.54	71.54	71.37	71.37	3158.0
2017-06-26 09:30:00	MSFT	Stock	71.4	71.71	71.38	71.51	2308130.0
2017-06-26 10:00:00	MSFT	Stock	71.52	71.57	71.31	71.515	1772994.0
2017-06-26 10:30:00	MSFT	Stock	71.51	71.53	70.89	71.0	1510095.0
2017-06-26 11:00:00	MSFT	Stock	71.0	71.04	70.76	70.84	1007587.0
2017-06-26 11:30:00	MSFT	Stock	70.84	70.96	70.7	70.89	938625.0
2017-06-26 12:00:00	MSFT	Stock	70.89	70.94	70.735	70.805	666747.0
2017-06-26 12:30:00	MSFT	Stock	70.8	71.016	70.78	70.963	645927.0
2017-06-26 13:00:00	MSFT	Stock	70.97	70.98	70.77	70.84	820582.0
2017-06-26 13:30:00	MSFT	Stock	70.84	70.9	70.76	70.81	566456.0
2017-06-26 14:00:00	MSFT	Stock	70.81	70.83	70.66	70.735	681720.0
2017-06-26 14:30:00	MSFT	Stock	70.73	70.81	70.616	70.64	773214.0
2017-06-26 15:00:00	MSFT	Stock	70.64	70.7	70.53	70.65	1785000.0
2017-06-26 15:30:00	MSFT	Stock	70.65	70.675	70.445	70.52	2299429.0
2017-06-26 16:00:00	MSFT	Stock	70.53	70.54	70.49	70.54	2402996.0
2017-06-26 16:30:00	MSFT	Stock	70.54	70.6	70.54	70.6	550.0
2017-06-26 17:30:00	MSFT	Stock	70.51	70.53	70.51	70.53	98396.0
2017-06-26 04:00:00	NVDA	Stock	3.874	3.874	3.8725	3.8725	51280.0

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

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