PREVIEW / stock_30min / 2017-02-06

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-06.parquet
  size:    1.6 MB
  rows:    81,544
  symbols: 3,106

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-02-06 04:00:00	AAPL	Stock	32.25	32.25	32.215	32.25	4468.0
2017-02-06 04:30:00	AAPL	Stock	32.2225	32.2225	32.2225	32.2225	1200.0
2017-02-06 05:00:00	AAPL	Stock	32.2375	32.2375	32.2375	32.2375	400.0
2017-02-06 05:30:00	AAPL	Stock	32.2375	32.275	32.2275	32.275	17016.0
2017-02-06 06:00:00	AAPL	Stock	32.295	32.2975	32.2475	32.2475	18380.0
2017-02-06 06:30:00	AAPL	Stock	32.26	32.27	32.225	32.25	10120.0
2017-02-06 07:00:00	AAPL	Stock	32.25	32.2625	32.235	32.235	31884.0
2017-02-06 07:30:00	AAPL	Stock	32.23	32.25	32.2125	32.2125	25380.0
2017-02-06 08:00:00	AAPL	Stock	32.225	32.25	32.185	32.2075	128744.0
2017-02-06 08:30:00	AAPL	Stock	32.2	32.2125	32.1775	32.1975	81120.0
2017-02-06 09:00:00	AAPL	Stock	32.2	32.25	32.1675	32.25	192476.0
2017-02-06 09:30:00	AAPL	Stock	32.2825	32.53	32.23	32.5275	19516724.0
2017-02-06 10:00:00	AAPL	Stock	32.53	32.6175	32.495	32.61	12405708.0
2017-02-06 10:30:00	AAPL	Stock	32.6088	32.6125	32.5275	32.5288	6846312.0
2017-02-06 11:00:00	AAPL	Stock	32.5275	32.5675	32.525	32.5525	5211476.0
2017-02-06 11:30:00	AAPL	Stock	32.5525	32.5575	32.4725	32.51	6493596.0
2017-02-06 12:00:00	AAPL	Stock	32.5075	32.5513	32.5025	32.5405	3796004.0
2017-02-06 12:30:00	AAPL	Stock	32.5425	32.61	32.53	32.605	5773960.0
2017-02-06 13:00:00	AAPL	Stock	32.6062	32.625	32.5675	32.58	4325468.0
2017-02-06 13:30:00	AAPL	Stock	32.58	32.5825	32.525	32.545	4530576.0
2017-02-06 14:00:00	AAPL	Stock	32.545	32.5625	32.53	32.5365	3203284.0
2017-02-06 14:30:00	AAPL	Stock	32.535	32.5875	32.5125	32.5725	4897048.0
2017-02-06 15:00:00	AAPL	Stock	32.5725	32.5737	32.5225	32.5475	4764836.0
2017-02-06 15:30:00	AAPL	Stock	32.5475	32.5925	32.5425	32.5725	10214568.0
2017-02-06 16:00:00	AAPL	Stock	32.5725	32.585	32.5425	32.57	5517224.0
2017-02-06 16:30:00	AAPL	Stock	32.57	32.5725	32.56	32.5625	8980.0
2017-02-06 17:00:00	AAPL	Stock	32.5675	32.5725	32.5625	32.5625	8000.0
2017-02-06 17:30:00	AAPL	Stock	32.55	32.5725	32.55	32.5725	6552.0
2017-02-06 18:00:00	AAPL	Stock	32.5725	32.575	32.5688	32.5688	53964.0
2017-02-06 18:30:00	AAPL	Stock	32.5725	32.5825	32.5675	32.5675	10920.0
2017-02-06 19:00:00	AAPL	Stock	32.5775	32.5825	32.575	32.575	10000.0
2017-02-06 19:30:00	AAPL	Stock	32.5675	32.5725	32.5625	32.5675	36248.0
2017-02-06 04:30:00	MSFT	Stock	63.67	63.67	63.67	63.67	322.0
2017-02-06 05:00:00	MSFT	Stock	63.67	63.68	63.67	63.68	243.0
2017-02-06 05:30:00	MSFT	Stock	63.68	63.8	63.6	63.6	7611.0
2017-02-06 07:00:00	MSFT	Stock	63.44	63.44	63.44	63.44	1000.0
2017-02-06 07:30:00	MSFT	Stock	63.48	63.48	63.48	63.48	2955.0
2017-02-06 08:00:00	MSFT	Stock	63.35	63.54	63.35	63.5	2332.0
2017-02-06 08:30:00	MSFT	Stock	63.54	63.54	63.41	63.41	1766.0
2017-02-06 09:00:00	MSFT	Stock	63.41	63.5	63.41	63.46	6699.0
2017-02-06 09:30:00	MSFT	Stock	63.5	63.55	63.14	63.24	1820303.0
2017-02-06 10:00:00	MSFT	Stock	63.25	63.41	63.21	63.37	916348.0
2017-02-06 10:30:00	MSFT	Stock	63.36	63.386	63.31	63.34	924788.0
2017-02-06 11:00:00	MSFT	Stock	63.34	63.51	63.28	63.5	1010377.0
2017-02-06 11:30:00	MSFT	Stock	63.508	63.52	63.4	63.464	733060.0
2017-02-06 12:00:00	MSFT	Stock	63.46	63.47	63.38	63.405	480138.0
2017-02-06 12:30:00	MSFT	Stock	63.41	63.49	63.33	63.435	1101863.0
2017-02-06 13:00:00	MSFT	Stock	63.44	63.47	63.38	63.435	953629.0
2017-02-06 13:30:00	MSFT	Stock	63.43	63.495	63.39	63.475	755864.0
2017-02-06 14:00:00	MSFT	Stock	63.47	63.519	63.45	63.5	754891.0

> showing 50 of 81,544 rows — these rows as CSV

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