PREVIEW / stock_30min / 2015-01-05

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-05.parquet
  size:    1.6 MB
  rows:    83,624
  symbols: 3,543

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-01-05 04:00:00	AAPL	Stock	27.3225	27.3225	27.305	27.305	1800.0
2015-01-05 04:30:00	AAPL	Stock	27.3	27.3	27.28	27.28	2800.0
2015-01-05 05:00:00	AAPL	Stock	27.3	27.3	27.28	27.28	2276.0
2015-01-05 05:30:00	AAPL	Stock	27.2825	27.3	27.1375	27.28	57600.0
2015-01-05 06:00:00	AAPL	Stock	27.2875	27.3	27.25	27.25	20976.0
2015-01-05 06:30:00	AAPL	Stock	27.2625	27.3	27.225	27.225	12480.0
2015-01-05 07:00:00	AAPL	Stock	27.25	27.275	27.25	27.2725	16400.0
2015-01-05 07:30:00	AAPL	Stock	27.29	27.3	27.275	27.2875	18848.0
2015-01-05 08:00:00	AAPL	Stock	27.29	27.3	27.25	27.25	205292.0
2015-01-05 08:30:00	AAPL	Stock	27.25	27.26	27.1375	27.1475	315368.0
2015-01-05 09:00:00	AAPL	Stock	27.155	27.175	27.05	27.0725	486744.0
2015-01-05 09:30:00	AAPL	Stock	27.0725	27.1625	26.8525	26.8938	31831192.0
2015-01-05 10:00:00	AAPL	Stock	26.8925	27.0475	26.8325	26.99	16173748.0
2015-01-05 10:30:00	AAPL	Stock	26.99	26.99	26.8525	26.855	14525320.0
2015-01-05 11:00:00	AAPL	Stock	26.8562	26.8825	26.665	26.695	20565176.0
2015-01-05 11:30:00	AAPL	Stock	26.6938	26.7438	26.6375	26.7182	13838624.0
2015-01-05 12:00:00	AAPL	Stock	26.7175	26.745	26.645	26.655	9198160.0
2015-01-05 12:30:00	AAPL	Stock	26.655	26.73	26.61	26.6688	10834024.0
2015-01-05 13:00:00	AAPL	Stock	26.6675	26.6875	26.575	26.6038	8664408.0
2015-01-05 13:30:00	AAPL	Stock	26.605	26.67	26.59	26.601	7960712.0
2015-01-05 14:00:00	AAPL	Stock	26.6	26.63	26.4525	26.48	15967872.0
2015-01-05 14:30:00	AAPL	Stock	26.4825	26.4975	26.3525	26.4088	13942292.0
2015-01-05 15:00:00	AAPL	Stock	26.4075	26.5575	26.38	26.5125	13827176.0
2015-01-05 15:30:00	AAPL	Stock	26.51	26.6325	26.46	26.5625	23257788.0
2015-01-05 16:00:00	AAPL	Stock	26.5625	27.3912	26.5135	26.6125	31161316.0
2015-01-05 16:30:00	AAPL	Stock	26.6175	26.7292	26.5625	26.65	203256.0
2015-01-05 17:00:00	AAPL	Stock	26.65	26.65	26.625	26.6325	1613452.0
2015-01-05 17:30:00	AAPL	Stock	26.6175	26.6325	26.5925	26.5925	52796.0
2015-01-05 18:00:00	AAPL	Stock	26.6075	26.6275	26.5625	26.625	82068.0
2015-01-05 18:30:00	AAPL	Stock	26.625	26.6275	26.59	26.59	24960.0
2015-01-05 19:00:00	AAPL	Stock	26.6	26.61	26.6	26.6	25388.0
2015-01-05 19:30:00	AAPL	Stock	26.6	26.61	26.565	26.59	81856.0
2015-01-05 05:30:00	MSFT	Stock	46.65	46.7	46.64	46.7	700.0
2015-01-05 07:00:00	MSFT	Stock	46.67	46.67	46.67	46.67	1000.0
2015-01-05 07:30:00	MSFT	Stock	46.61	46.66	46.6	46.61	11300.0
2015-01-05 08:00:00	MSFT	Stock	46.61	46.61	46.51	46.51	12000.0
2015-01-05 08:30:00	MSFT	Stock	46.52	46.52	46.43	46.45	17725.0
2015-01-05 09:00:00	MSFT	Stock	46.45	46.48	46.29	46.41	55556.0
2015-01-05 09:30:00	MSFT	Stock	46.37	46.73	46.3	46.45	4627902.0
2015-01-05 10:00:00	MSFT	Stock	46.44	46.57	46.39	46.51	2897200.0
2015-01-05 10:30:00	MSFT	Stock	46.5	46.54	46.35	46.48	2427947.0
2015-01-05 11:00:00	MSFT	Stock	46.47	46.495	46.26	46.28	1943489.0
2015-01-05 11:30:00	MSFT	Stock	46.28	46.49	46.275	46.38	1434771.0
2015-01-05 12:00:00	MSFT	Stock	46.384	46.49	46.35	46.41	1793070.0
2015-01-05 12:30:00	MSFT	Stock	46.41	46.43	46.3	46.36	1583848.0
2015-01-05 13:00:00	MSFT	Stock	46.36	46.37	46.25	46.3	1310836.0
2015-01-05 13:30:00	MSFT	Stock	46.3	46.435	46.29	46.4	1225194.0
2015-01-05 14:00:00	MSFT	Stock	46.395	46.41	46.25	46.33	1772651.0
2015-01-05 14:30:00	MSFT	Stock	46.33	46.475	46.25	46.385	1879970.0
2015-01-05 15:00:00	MSFT	Stock	46.39	46.625	46.38	46.495	2471138.0

> showing 50 of 83,624 rows — these rows as CSV

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