PREVIEW / stock_30min / 2015-10-08

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-08.parquet
  size:    1.6 MB
  rows:    80,556
  symbols: 3,423

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-10-08 04:00:00	AAPL	Stock	27.5275	27.56	27.5125	27.5125	17320.0
2015-10-08 04:30:00	AAPL	Stock	27.5125	27.5625	27.5125	27.56	19016.0
2015-10-08 05:00:00	AAPL	Stock	27.55	27.58	27.55	27.58	4452.0
2015-10-08 06:00:00	AAPL	Stock	27.6125	27.6125	27.58	27.595	5600.0
2015-10-08 06:30:00	AAPL	Stock	27.575	27.5775	27.575	27.575	9796.0
2015-10-08 07:00:00	AAPL	Stock	27.6075	27.61	27.6	27.6	17900.0
2015-10-08 07:30:00	AAPL	Stock	27.61	27.6725	27.6025	27.65	35180.0
2015-10-08 08:00:00	AAPL	Stock	27.635	27.67	27.5775	27.6275	111020.0
2015-10-08 08:30:00	AAPL	Stock	27.65	27.65	27.5775	27.5975	132268.0
2015-10-08 09:00:00	AAPL	Stock	27.5825	27.5975	27.5325	27.535	319116.0
2015-10-08 09:30:00	AAPL	Stock	27.5475	27.5475	27.23	27.2525	35930444.0
2015-10-08 10:00:00	AAPL	Stock	27.25	27.285	27.1125	27.2138	28672508.0
2015-10-08 10:30:00	AAPL	Stock	27.2148	27.295	27.175	27.245	13830540.0
2015-10-08 11:00:00	AAPL	Stock	27.245	27.275	27.1125	27.2475	15396504.0
2015-10-08 11:30:00	AAPL	Stock	27.25	27.275	27.175	27.23	9543440.0
2015-10-08 12:00:00	AAPL	Stock	27.23	27.2575	27.0875	27.1025	12259676.0
2015-10-08 12:30:00	AAPL	Stock	27.1022	27.175	27.0525	27.1175	11108584.0
2015-10-08 13:00:00	AAPL	Stock	27.116	27.22	27.105	27.1875	8747304.0
2015-10-08 13:30:00	AAPL	Stock	27.185	27.2075	27.135	27.194	6315964.0
2015-10-08 14:00:00	AAPL	Stock	27.1928	27.3325	27.135	27.24	20045792.0
2015-10-08 14:30:00	AAPL	Stock	27.2375	27.415	27.2375	27.3875	15632024.0
2015-10-08 15:00:00	AAPL	Stock	27.3875	27.535	27.3075	27.3375	22704372.0
2015-10-08 15:30:00	AAPL	Stock	27.3362	27.3875	27.295	27.375	19961740.0
2015-10-08 16:00:00	AAPL	Stock	27.375	27.375	27.262	27.3625	9977792.0
2015-10-08 16:30:00	AAPL	Stock	27.3525	27.37	27.3375	27.36	49476.0
2015-10-08 17:00:00	AAPL	Stock	27.3575	27.3725	27.3575	27.3625	27168.0
2015-10-08 17:30:00	AAPL	Stock	27.37	27.375	27.3625	27.3625	27476.0
2015-10-08 18:00:00	AAPL	Stock	27.3725	27.3725	27.3575	27.37	9264.0
2015-10-08 18:30:00	AAPL	Stock	27.37	27.37	27.3525	27.3625	17948.0
2015-10-08 19:00:00	AAPL	Stock	27.3625	27.3625	27.3525	27.3525	14188.0
2015-10-08 19:30:00	AAPL	Stock	27.3525	27.3625	27.35	27.3625	35244.0
2015-10-08 04:00:00	MSFT	Stock	46.57	46.57	46.57	46.57	200.0
2015-10-08 04:30:00	MSFT	Stock	46.55	46.55	46.55	46.55	100.0
2015-10-08 05:00:00	MSFT	Stock	46.5	46.65	46.5	46.65	20097.0
2015-10-08 05:30:00	MSFT	Stock	46.65	46.65	46.65	46.65	100.0
2015-10-08 06:30:00	MSFT	Stock	46.76	46.76	46.76	46.76	300.0
2015-10-08 08:00:00	MSFT	Stock	46.65	46.65	46.65	46.65	100.0
2015-10-08 08:30:00	MSFT	Stock	46.63	46.63	46.54	46.54	2250.0
2015-10-08 09:00:00	MSFT	Stock	46.67	46.7	46.59	46.59	1050.0
2015-10-08 09:30:00	MSFT	Stock	46.55	47.01	46.55	46.98	3605226.0
2015-10-08 10:00:00	MSFT	Stock	46.98	46.988	46.72	46.76	1560806.0
2015-10-08 10:30:00	MSFT	Stock	46.75	46.87	46.64	46.7	1899396.0
2015-10-08 11:00:00	MSFT	Stock	46.7	46.711	46.5	46.6	1826279.0
2015-10-08 11:30:00	MSFT	Stock	46.6	46.95	46.6	46.93	1210142.0
2015-10-08 12:00:00	MSFT	Stock	46.935	47.0	46.8	46.83	1580168.0
2015-10-08 12:30:00	MSFT	Stock	46.83	46.98	46.81	46.89	1463539.0
2015-10-08 13:00:00	MSFT	Stock	46.89	46.985	46.82	46.96	962139.0
2015-10-08 13:30:00	MSFT	Stock	46.96	47.0	46.87	46.94	924746.0
2015-10-08 14:00:00	MSFT	Stock	46.94	47.09	46.83	46.965	3453163.0
2015-10-08 14:30:00	MSFT	Stock	46.96	47.25	46.945	47.2	2499904.0

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

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