PREVIEW / stock_30min / 2017-09-27

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-27.parquet
  size:    1.7 MB
  rows:    84,639
  symbols: 2,967

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-09-27 04:00:00	AAPL	Stock	38.4275	38.4275	38.4275	38.4275	400.0
2017-09-27 04:30:00	AAPL	Stock	38.485	38.56	38.485	38.56	800.0
2017-09-27 05:00:00	AAPL	Stock	38.49	38.55	38.49	38.5025	5688.0
2017-09-27 05:30:00	AAPL	Stock	38.5	38.545	38.5	38.52	4644.0
2017-09-27 06:00:00	AAPL	Stock	38.465	38.5175	38.4625	38.5175	2400.0
2017-09-27 06:30:00	AAPL	Stock	38.5	38.575	38.5	38.575	62292.0
2017-09-27 07:00:00	AAPL	Stock	38.56	38.6625	38.275	38.3875	356676.0
2017-09-27 07:30:00	AAPL	Stock	38.405	38.4175	38.335	38.335	100460.0
2017-09-27 08:00:00	AAPL	Stock	38.5375	38.6225	38.3375	38.425	403344.0
2017-09-27 08:30:00	AAPL	Stock	38.4025	38.4575	38.3775	38.405	202388.0
2017-09-27 09:00:00	AAPL	Stock	38.39	38.4725	38.35	38.4475	576492.0
2017-09-27 09:30:00	AAPL	Stock	38.45	38.6675	38.4025	38.6025	20352820.0
2017-09-27 10:00:00	AAPL	Stock	38.605	38.655	38.4925	38.6093	8642816.0
2017-09-27 10:30:00	AAPL	Stock	38.6125	38.635	38.465	38.525	7227144.0
2017-09-27 11:00:00	AAPL	Stock	38.525	38.575	38.485	38.5425	4966560.0
2017-09-27 11:30:00	AAPL	Stock	38.5425	38.55	38.44	38.48	4799604.0
2017-09-27 12:00:00	AAPL	Stock	38.4825	38.483	38.385	38.445	3791900.0
2017-09-27 12:30:00	AAPL	Stock	38.445	38.55	38.4225	38.535	3455852.0
2017-09-27 13:00:00	AAPL	Stock	38.535	38.54	38.46	38.4875	3404792.0
2017-09-27 13:30:00	AAPL	Stock	38.4875	38.555	38.4775	38.5525	2647780.0
2017-09-27 14:00:00	AAPL	Stock	38.555	38.6798	38.554	38.625	5407912.0
2017-09-27 14:30:00	AAPL	Stock	38.624	38.6438	38.5575	38.5725	3352320.0
2017-09-27 15:00:00	AAPL	Stock	38.5772	38.6575	38.5712	38.6338	4596704.0
2017-09-27 15:30:00	AAPL	Stock	38.635	38.67	38.535	38.55	8675968.0
2017-09-27 16:00:00	AAPL	Stock	38.555	38.5875	38.55	38.56	8394908.0
2017-09-27 16:30:00	AAPL	Stock	38.575	38.5825	38.525	38.525	347436.0
2017-09-27 17:00:00	AAPL	Stock	38.525	38.545	38.5225	38.525	10816.0
2017-09-27 17:30:00	AAPL	Stock	38.5275	38.545	38.5225	38.5325	6896.0
2017-09-27 18:00:00	AAPL	Stock	38.53	38.5575	38.5	38.525	342016.0
2017-09-27 18:30:00	AAPL	Stock	38.525	38.525	38.5075	38.5125	7424.0
2017-09-27 19:00:00	AAPL	Stock	38.525	38.525	38.5175	38.525	4624.0
2017-09-27 19:30:00	AAPL	Stock	38.525	38.525	38.5125	38.515	37372.0
2017-09-27 05:00:00	MSFT	Stock	73.99	73.99	73.99	73.99	100.0
2017-09-27 06:00:00	MSFT	Stock	73.56	73.56	73.56	73.56	4880.0
2017-09-27 07:00:00	MSFT	Stock	73.49	73.49	73.49	73.49	1347.0
2017-09-27 07:30:00	MSFT	Stock	73.6	73.6	73.6	73.6	250.0
2017-09-27 08:00:00	MSFT	Stock	73.55	73.55	73.5	73.5	1100.0
2017-09-27 08:30:00	MSFT	Stock	73.59	73.59	73.51	73.55	816.0
2017-09-27 09:00:00	MSFT	Stock	73.59	73.67	73.53	73.67	6805.0
2017-09-27 09:30:00	MSFT	Stock	73.62	73.9	73.5	73.64	1589849.0
2017-09-27 10:00:00	MSFT	Stock	73.64	73.7	73.42	73.475	1433156.0
2017-09-27 10:30:00	MSFT	Stock	73.475	73.49	73.17	73.37	1349410.0
2017-09-27 11:00:00	MSFT	Stock	73.37	73.59	73.29	73.51	773023.0
2017-09-27 11:30:00	MSFT	Stock	73.52	73.56	73.41	73.45	798135.0
2017-09-27 12:00:00	MSFT	Stock	73.445	73.52	73.35	73.49	638423.0
2017-09-27 12:30:00	MSFT	Stock	73.49	73.6	73.38	73.595	639316.0
2017-09-27 13:00:00	MSFT	Stock	73.6	73.8	73.56	73.785	997424.0
2017-09-27 13:30:00	MSFT	Stock	73.785	73.825	73.65	73.78	686599.0
2017-09-27 14:00:00	MSFT	Stock	73.78	74.08	73.75	74.07	1219622.0
2017-09-27 14:30:00	MSFT	Stock	74.065	74.11	73.985	74.0	815524.0

> showing 50 of 84,639 rows — these rows as CSV

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