PREVIEW / stock_30min / 2015-07-13

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-13.parquet
  size:    1.6 MB
  rows:    82,920
  symbols: 3,498

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-07-13 04:00:00	AAPL	Stock	31.25	31.25	30.825	31.0175	32720.0
2015-07-13 04:30:00	AAPL	Stock	31.045	31.125	31.045	31.125	22072.0
2015-07-13 05:00:00	AAPL	Stock	31.1475	31.1775	31.125	31.1375	16600.0
2015-07-13 05:30:00	AAPL	Stock	31.1725	31.25	31.1525	31.2	80244.0
2015-07-13 06:00:00	AAPL	Stock	31.2475	31.2475	31.1925	31.22	46148.0
2015-07-13 06:30:00	AAPL	Stock	31.23	31.2475	31.22	31.22	58888.0
2015-07-13 07:00:00	AAPL	Stock	31.225	31.2625	31.1925	31.22	212968.0
2015-07-13 07:30:00	AAPL	Stock	31.2075	31.2375	31.1925	31.2	110592.0
2015-07-13 08:00:00	AAPL	Stock	31.215	31.2575	31.1425	31.23	846588.0
2015-07-13 08:30:00	AAPL	Stock	31.2275	31.2375	31.2025	31.2325	425540.0
2015-07-13 09:00:00	AAPL	Stock	31.2325	31.2575	31.1875	31.2575	1162808.0
2015-07-13 09:30:00	AAPL	Stock	31.225	31.265	31.08	31.135	28268840.0
2015-07-13 10:00:00	AAPL	Stock	31.135	31.1975	31.13	31.135	11271036.0
2015-07-13 10:30:00	AAPL	Stock	31.13	31.1825	31.115	31.14	6983864.0
2015-07-13 11:00:00	AAPL	Stock	31.14	31.2375	31.135	31.225	7406484.0
2015-07-13 11:30:00	AAPL	Stock	31.2275	31.31	31.2175	31.3	10451676.0
2015-07-13 12:00:00	AAPL	Stock	31.295	31.3725	31.2925	31.3525	8139744.0
2015-07-13 12:30:00	AAPL	Stock	31.3525	31.3538	31.31	31.325	4126088.0
2015-07-13 13:00:00	AAPL	Stock	31.325	31.4092	31.3202	31.385	5667488.0
2015-07-13 13:30:00	AAPL	Stock	31.3852	31.4075	31.345	31.3688	4270788.0
2015-07-13 14:00:00	AAPL	Stock	31.3688	31.4272	31.3675	31.4025	5227316.0
2015-07-13 14:30:00	AAPL	Stock	31.4	31.4275	31.3575	31.4025	5397292.0
2015-07-13 15:00:00	AAPL	Stock	31.405	31.4325	31.3875	31.43	5418468.0
2015-07-13 15:30:00	AAPL	Stock	31.43	31.4388	31.3875	31.4125	14286788.0
2015-07-13 16:00:00	AAPL	Stock	31.41	31.43	31.1608	31.415	19781840.0
2015-07-13 16:30:00	AAPL	Stock	31.43	31.45	31.27	31.4	264344.0
2015-07-13 17:00:00	AAPL	Stock	31.3875	31.4175	31.3	31.415	89764.0
2015-07-13 17:30:00	AAPL	Stock	31.415	31.43	31.4125	31.4275	36148.0
2015-07-13 18:00:00	AAPL	Stock	31.42	31.4225	31.4075	31.4175	22772.0
2015-07-13 18:30:00	AAPL	Stock	31.415	31.4375	31.4125	31.4125	27064.0
2015-07-13 19:00:00	AAPL	Stock	31.415	31.45	31.4125	31.445	36516.0
2015-07-13 19:30:00	AAPL	Stock	31.4475	31.4675	31.4375	31.4675	80216.0
2015-07-13 04:00:00	MSFT	Stock	44.61	44.61	44.61	44.61	175.0
2015-07-13 06:30:00	MSFT	Stock	44.94	44.94	44.94	44.94	100.0
2015-07-13 07:30:00	MSFT	Stock	44.88	44.93	44.88	44.93	250.0
2015-07-13 08:00:00	MSFT	Stock	44.86	44.86	44.86	44.86	100.0
2015-07-13 08:30:00	MSFT	Stock	44.85	44.85	44.85	44.85	850.0
2015-07-13 09:00:00	MSFT	Stock	44.85	45.0	44.8	45.0	40894.0
2015-07-13 09:30:00	MSFT	Stock	44.99	45.53	44.95	45.49	3943914.0
2015-07-13 10:00:00	MSFT	Stock	45.49	45.59	45.38	45.519	2803425.0
2015-07-13 10:30:00	MSFT	Stock	45.515	45.61	45.493	45.51	1583359.0
2015-07-13 11:00:00	MSFT	Stock	45.505	45.55	45.36	45.395	1484525.0
2015-07-13 11:30:00	MSFT	Stock	45.39	45.55	45.39	45.55	1139971.0
2015-07-13 12:00:00	MSFT	Stock	45.54	45.56	45.43	45.53	1024224.0
2015-07-13 12:30:00	MSFT	Stock	45.53	45.54	45.44	45.475	1065262.0
2015-07-13 13:00:00	MSFT	Stock	45.48	45.53	45.43	45.52	997150.0
2015-07-13 13:30:00	MSFT	Stock	45.52	45.56	45.44	45.496	996612.0
2015-07-13 14:00:00	MSFT	Stock	45.495	45.58	45.46	45.535	1244769.0
2015-07-13 14:30:00	MSFT	Stock	45.531	45.59	45.5	45.57	1240659.0
2015-07-13 15:00:00	MSFT	Stock	45.58	45.59	45.51	45.59	1660172.0

> showing 50 of 82,920 rows — these rows as CSV

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