PREVIEW / stock_30min / 2016-01-04

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-04.parquet
  size:    1.6 MB
  rows:    85,531
  symbols: 3,395

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
2016-01-04 04:00:00	AAPL	Stock	26.3625	26.3625	25.875	25.915	105992.0
2016-01-04 04:30:00	AAPL	Stock	25.9275	25.95	25.85	25.85	36092.0
2016-01-04 05:00:00	AAPL	Stock	25.8875	25.9125	25.87	25.9	19364.0
2016-01-04 05:30:00	AAPL	Stock	25.925	25.9425	25.875	25.92	8808.0
2016-01-04 06:00:00	AAPL	Stock	25.9225	25.9225	25.82	25.82	95608.0
2016-01-04 06:30:00	AAPL	Stock	25.8475	25.85	25.75	25.75	58920.0
2016-01-04 07:00:00	AAPL	Stock	25.75	25.7875	25.7025	25.7775	260416.0
2016-01-04 07:30:00	AAPL	Stock	25.795	25.825	25.755	25.825	148504.0
2016-01-04 08:00:00	AAPL	Stock	25.825	25.895	25.725	25.805	829924.0
2016-01-04 08:30:00	AAPL	Stock	25.81	25.815	25.7	25.75	590364.0
2016-01-04 09:00:00	AAPL	Stock	25.75	25.775	25.595	25.605	894040.0
2016-01-04 09:30:00	AAPL	Stock	25.6525	25.9225	25.5	25.673	37220524.0
2016-01-04 10:00:00	AAPL	Stock	25.67	25.8975	25.595	25.82	19290220.0
2016-01-04 10:30:00	AAPL	Stock	25.8215	25.9838	25.7525	25.8355	15546808.0
2016-01-04 11:00:00	AAPL	Stock	25.8325	25.8675	25.625	25.856	12943580.0
2016-01-04 11:30:00	AAPL	Stock	25.855	25.975	25.8012	25.9575	10004928.0
2016-01-04 12:00:00	AAPL	Stock	25.96	26.0125	25.9225	25.9675	9096336.0
2016-01-04 12:30:00	AAPL	Stock	25.9688	26.2225	25.9525	26.1955	13169928.0
2016-01-04 13:00:00	AAPL	Stock	26.195	26.2475	26.1425	26.1675	10690684.0
2016-01-04 13:30:00	AAPL	Stock	26.165	26.2025	26.0775	26.16	8751132.0
2016-01-04 14:00:00	AAPL	Stock	26.16	26.342	26.1025	26.3075	14038860.0
2016-01-04 14:30:00	AAPL	Stock	26.305	26.3198	26.1475	26.1875	9096860.0
2016-01-04 15:00:00	AAPL	Stock	26.1875	26.1875	25.9575	26.0125	11864592.0
2016-01-04 15:30:00	AAPL	Stock	26.0125	26.34	26.005	26.3325	19660240.0
2016-01-04 16:00:00	AAPL	Stock	26.3375	26.4125	25.7192	26.39	20199136.0
2016-01-04 16:30:00	AAPL	Stock	26.39	26.425	26.3375	26.3875	194896.0
2016-01-04 17:00:00	AAPL	Stock	26.38	26.4375	26.3725	26.395	105012.0
2016-01-04 17:30:00	AAPL	Stock	26.3875	26.42	26.3875	26.4075	16408.0
2016-01-04 18:00:00	AAPL	Stock	26.4175	26.43	26.4075	26.43	26044.0
2016-01-04 18:30:00	AAPL	Stock	26.425	26.435	26.4025	26.435	36604.0
2016-01-04 19:00:00	AAPL	Stock	26.435	26.4425	26.415	26.4425	38012.0
2016-01-04 19:30:00	AAPL	Stock	26.4275	26.45	26.425	26.435	52596.0
2016-01-04 04:00:00	MSFT	Stock	55.48	55.48	55.48	55.48	100.0
2016-01-04 04:30:00	MSFT	Stock	54.65	54.65	54.55	54.55	776.0
2016-01-04 06:30:00	MSFT	Stock	54.49	54.49	54.49	54.49	500.0
2016-01-04 07:00:00	MSFT	Stock	54.36	54.41	54.31	54.31	6369.0
2016-01-04 07:30:00	MSFT	Stock	54.3	54.45	54.21	54.4	4450.0
2016-01-04 08:00:00	MSFT	Stock	54.45	54.7	54.21	54.6	13215.0
2016-01-04 08:30:00	MSFT	Stock	54.51	54.56	54.35	54.5	16795.0
2016-01-04 09:00:00	MSFT	Stock	54.5	54.5	54.28	54.33	62609.0
2016-01-04 09:30:00	MSFT	Stock	54.37	54.54	53.9	54.47	6212523.0
2016-01-04 10:00:00	MSFT	Stock	54.46	54.465	53.82	53.825	4571920.0
2016-01-04 10:30:00	MSFT	Stock	53.83	53.89	53.45	53.485	3765357.0
2016-01-04 11:00:00	MSFT	Stock	53.49	53.72	53.39	53.68	3105163.0
2016-01-04 11:30:00	MSFT	Stock	53.67	53.92	53.59	53.83	2788195.0
2016-01-04 12:00:00	MSFT	Stock	53.83	53.83	53.66	53.77	2416510.0
2016-01-04 12:30:00	MSFT	Stock	53.76	53.96	53.68	53.936	2576223.0
2016-01-04 13:00:00	MSFT	Stock	53.94	54.08	53.885	53.99	2435061.0
2016-01-04 13:30:00	MSFT	Stock	53.99	54.04	53.91	53.945	1779961.0
2016-01-04 14:00:00	MSFT	Stock	53.94	54.15	53.84	54.086	2302278.0

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

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