PREVIEW / stock_30min / 2015-04-24

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-24.parquet
  size:    1.6 MB
  rows:    81,636
  symbols: 3,520

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-04-24 04:00:00	AAPL	Stock	32.625	32.635	32.5225	32.605	37592.0
2015-04-24 04:30:00	AAPL	Stock	32.59	32.6125	32.59	32.59	13856.0
2015-04-24 05:00:00	AAPL	Stock	32.59	32.59	32.59	32.59	1200.0
2015-04-24 05:30:00	AAPL	Stock	32.59	32.59	32.55	32.55	30928.0
2015-04-24 06:00:00	AAPL	Stock	32.5275	32.5625	32.5	32.5125	29276.0
2015-04-24 06:30:00	AAPL	Stock	32.525	32.55	32.5125	32.55	22592.0
2015-04-24 07:00:00	AAPL	Stock	32.56	32.6125	32.535	32.61	100832.0
2015-04-24 07:30:00	AAPL	Stock	32.6075	32.6075	32.525	32.5625	81312.0
2015-04-24 08:00:00	AAPL	Stock	32.5625	32.625	32.5025	32.6125	538664.0
2015-04-24 08:30:00	AAPL	Stock	32.6	32.625	32.59	32.6225	512880.0
2015-04-24 09:00:00	AAPL	Stock	32.625	32.6625	32.6075	32.61	1066356.0
2015-04-24 09:30:00	AAPL	Stock	32.6225	32.6575	32.4375	32.5375	30345360.0
2015-04-24 10:00:00	AAPL	Stock	32.54	32.5573	32.3975	32.46	16569192.0
2015-04-24 10:30:00	AAPL	Stock	32.46	32.475	32.33	32.355	13935436.0
2015-04-24 11:00:00	AAPL	Stock	32.355	32.45	32.3075	32.4475	9817344.0
2015-04-24 11:30:00	AAPL	Stock	32.4475	32.485	32.4375	32.455	7232896.0
2015-04-24 12:00:00	AAPL	Stock	32.455	32.567	32.445	32.5475	9859572.0
2015-04-24 12:30:00	AAPL	Stock	32.5475	32.59	32.4175	32.455	12031088.0
2015-04-24 13:00:00	AAPL	Stock	32.4575	32.5375	32.44	32.5212	6017040.0
2015-04-24 13:30:00	AAPL	Stock	32.52	32.5275	32.47	32.475	4385936.0
2015-04-24 14:00:00	AAPL	Stock	32.4775	32.4975	32.4325	32.4925	6278816.0
2015-04-24 14:30:00	AAPL	Stock	32.4925	32.52	32.455	32.495	6354576.0
2015-04-24 15:00:00	AAPL	Stock	32.495	32.5175	32.465	32.5088	7585808.0
2015-04-24 15:30:00	AAPL	Stock	32.5088	32.5775	32.5	32.57	17915796.0
2015-04-24 16:00:00	AAPL	Stock	32.57	32.59	32.5625	32.585	10174028.0
2015-04-24 16:30:00	AAPL	Stock	32.5825	32.615	32.58	32.595	288240.0
2015-04-24 17:00:00	AAPL	Stock	32.5875	32.5975	32.5825	32.5925	98344.0
2015-04-24 17:30:00	AAPL	Stock	32.59	32.6225	32.5875	32.615	202588.0
2015-04-24 18:00:00	AAPL	Stock	32.6175	32.635	32.61	32.635	291888.0
2015-04-24 18:30:00	AAPL	Stock	32.6375	32.64	32.6275	32.6325	326724.0
2015-04-24 19:00:00	AAPL	Stock	32.6325	32.6375	32.6275	32.6325	89000.0
2015-04-24 19:30:00	AAPL	Stock	32.635	32.64	32.6225	32.64	216664.0
2015-04-24 04:00:00	MSFT	Stock	44.67	44.67	44.49	44.49	2100.0
2015-04-24 04:30:00	MSFT	Stock	44.57	44.64	44.55	44.64	3600.0
2015-04-24 05:00:00	MSFT	Stock	44.65	44.65	44.65	44.65	993.0
2015-04-24 05:30:00	MSFT	Stock	44.65	44.65	44.59	44.59	1000.0
2015-04-24 06:00:00	MSFT	Stock	44.57	44.57	44.24	44.24	14745.0
2015-04-24 06:30:00	MSFT	Stock	44.4	44.9	44.4	44.73	61269.0
2015-04-24 07:00:00	MSFT	Stock	44.8	45.05	44.72	44.77	107113.0
2015-04-24 07:30:00	MSFT	Stock	44.78	45.24	44.78	45.2	144513.0
2015-04-24 08:00:00	MSFT	Stock	45.2	45.47	44.72	45.45	418175.0
2015-04-24 08:30:00	MSFT	Stock	45.45	45.69	45.34	45.55	563800.0
2015-04-24 09:00:00	MSFT	Stock	45.55	45.75	45.33	45.68	1335992.0
2015-04-24 09:30:00	MSFT	Stock	45.66	46.44	45.65	46.11	24580222.0
2015-04-24 10:00:00	MSFT	Stock	46.11	46.68	46.01	46.449	11986703.0
2015-04-24 10:30:00	MSFT	Stock	46.44	46.84	46.37	46.835	8470801.0
2015-04-24 11:00:00	MSFT	Stock	46.84	46.94	46.72	46.88	7439295.0
2015-04-24 11:30:00	MSFT	Stock	46.88	47.31	46.87	47.12	8395417.0
2015-04-24 12:00:00	MSFT	Stock	47.13	47.44	47.11	47.38	4983667.0
2015-04-24 12:30:00	MSFT	Stock	47.37	47.49	47.24	47.415	5812764.0

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

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