PREVIEW / stock_30min / 2014-07-21

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-21.parquet
  size:    1.6 MB
  rows:    82,346
  symbols: 3,570

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
2014-07-21 04:00:00	AAPL	Stock	23.625	23.75	23.5625	23.75	55140.0
2014-07-21 04:30:00	AAPL	Stock	23.75	23.79	23.75	23.79	8400.0
2014-07-21 05:00:00	AAPL	Stock	23.7875	23.8125	23.775	23.8	33640.0
2014-07-21 05:30:00	AAPL	Stock	23.815	23.815	23.775	23.7925	25744.0
2014-07-21 06:00:00	AAPL	Stock	23.7925	23.8	23.75	23.75	24916.0
2014-07-21 06:30:00	AAPL	Stock	23.7625	23.785	23.7225	23.735	87500.0
2014-07-21 07:00:00	AAPL	Stock	23.7375	23.7625	23.7125	23.75	63496.0
2014-07-21 07:30:00	AAPL	Stock	23.7525	23.8	23.7225	23.78	192168.0
2014-07-21 08:00:00	AAPL	Stock	23.7625	23.7875	23.6175	23.6575	863000.0
2014-07-21 08:30:00	AAPL	Stock	23.6625	23.7	23.6425	23.6625	346496.0
2014-07-21 09:00:00	AAPL	Stock	23.6625	23.7525	23.635	23.745	609852.0
2014-07-21 09:30:00	AAPL	Stock	23.7475	23.75	23.5225	23.5675	28513468.0
2014-07-21 10:00:00	AAPL	Stock	23.5675	23.5775	23.5025	23.5738	12408864.0
2014-07-21 10:30:00	AAPL	Stock	23.5748	23.5775	23.44	23.4418	11481592.0
2014-07-21 11:00:00	AAPL	Stock	23.441	23.5575	23.43	23.535	10138020.0
2014-07-21 11:30:00	AAPL	Stock	23.535	23.5475	23.4775	23.515	7801708.0
2014-07-21 12:00:00	AAPL	Stock	23.5175	23.5487	23.4825	23.5052	7769192.0
2014-07-21 12:30:00	AAPL	Stock	23.5075	23.5275	23.5075	23.5088	4300132.0
2014-07-21 13:00:00	AAPL	Stock	23.5075	23.54	23.495	23.5338	6250656.0
2014-07-21 13:30:00	AAPL	Stock	23.5338	23.5625	23.51	23.5625	6386108.0
2014-07-21 14:00:00	AAPL	Stock	23.5625	23.585	23.5075	23.5118	7144544.0
2014-07-21 14:30:00	AAPL	Stock	23.51	23.5325	23.49	23.515	5638456.0
2014-07-21 15:00:00	AAPL	Stock	23.515	23.5325	23.5055	23.5188	5728308.0
2014-07-21 15:30:00	AAPL	Stock	23.5175	23.5275	23.47	23.485	17883892.0
2014-07-21 16:00:00	AAPL	Stock	23.4875	23.5487	23.475	23.505	5703272.0
2014-07-21 16:30:00	AAPL	Stock	23.505	23.525	23.4828	23.5175	296752.0
2014-07-21 17:00:00	AAPL	Stock	23.52	23.54	23.4875	23.54	215128.0
2014-07-21 17:30:00	AAPL	Stock	23.54	23.5425	23.515	23.5175	194584.0
2014-07-21 18:00:00	AAPL	Stock	23.52	23.53	23.515	23.5275	51960.0
2014-07-21 18:30:00	AAPL	Stock	23.5175	23.5475	23.4875	23.5475	392668.0
2014-07-21 19:00:00	AAPL	Stock	23.5475	23.5525	23.535	23.55	143336.0
2014-07-21 19:30:00	AAPL	Stock	23.55	23.55	23.5025	23.5325	178772.0
2014-07-21 07:00:00	MSFT	Stock	44.67	44.67	44.47	44.47	320.0
2014-07-21 08:00:00	MSFT	Stock	44.53	44.66	44.5	44.5	1712.0
2014-07-21 08:30:00	MSFT	Stock	44.54	44.56	44.54	44.56	3067.0
2014-07-21 09:00:00	MSFT	Stock	44.56	44.6	44.56	44.57	3750.0
2014-07-21 09:30:00	MSFT	Stock	44.55	44.56	44.22	44.4	4759876.0
2014-07-21 10:00:00	MSFT	Stock	44.39	44.41	44.3	44.34	3510303.0
2014-07-21 10:30:00	MSFT	Stock	44.34	44.41	44.31	44.325	1849178.0
2014-07-21 11:00:00	MSFT	Stock	44.32	44.59	44.3	44.565	1632443.0
2014-07-21 11:30:00	MSFT	Stock	44.57	44.74	44.56	44.68	1592376.0
2014-07-21 12:00:00	MSFT	Stock	44.67	44.67	44.57	44.6	1333577.0
2014-07-21 12:30:00	MSFT	Stock	44.595	44.82	44.59	44.81	2010907.0
2014-07-21 13:00:00	MSFT	Stock	44.81	45.02	44.795	45.01	3255854.0
2014-07-21 13:30:00	MSFT	Stock	45.01	45.09	44.965	45.04	2389672.0
2014-07-21 14:00:00	MSFT	Stock	45.019	45.16	44.99	45.11	2291248.0
2014-07-21 14:30:00	MSFT	Stock	45.105	45.16	45.02	45.04	1972474.0
2014-07-21 15:00:00	MSFT	Stock	45.04	45.04	44.96	45.03	2282328.0
2014-07-21 15:30:00	MSFT	Stock	45.03	45.07	44.83	44.835	3582869.0
2014-07-21 16:00:00	MSFT	Stock	44.835	44.9	44.69	44.835	2852413.0

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

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