PREVIEW / stock_30min / 2015-06-09

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-09.parquet
  size:    1.6 MB
  rows:    82,323
  symbols: 3,490

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-06-09 04:00:00	AAPL	Stock	32.025	32.045	32.025	32.025	17452.0
2015-06-09 04:30:00	AAPL	Stock	32.025	32.025	31.95	31.98	17316.0
2015-06-09 05:00:00	AAPL	Stock	31.94	31.94	31.9275	31.9275	992.0
2015-06-09 05:30:00	AAPL	Stock	31.8825	31.9	31.7825	31.7825	28056.0
2015-06-09 06:00:00	AAPL	Stock	31.8225	31.85	31.795	31.8425	21392.0
2015-06-09 06:30:00	AAPL	Stock	31.875	31.8875	31.845	31.8875	25180.0
2015-06-09 07:00:00	AAPL	Stock	31.895	31.945	31.8875	31.9125	75384.0
2015-06-09 07:30:00	AAPL	Stock	31.925	31.95	31.9025	31.905	47280.0
2015-06-09 08:00:00	AAPL	Stock	31.91	31.98	31.825	31.865	560412.0
2015-06-09 08:30:00	AAPL	Stock	31.8575	31.8575	31.65	31.6725	1461600.0
2015-06-09 09:00:00	AAPL	Stock	31.6675	31.7325	31.6225	31.67	1417772.0
2015-06-09 09:30:00	AAPL	Stock	31.67	31.805	31.5225	31.6325	37153428.0
2015-06-09 10:00:00	AAPL	Stock	31.6312	31.6475	31.405	31.455	29108936.0
2015-06-09 10:30:00	AAPL	Stock	31.4525	31.5725	31.4125	31.554	18272084.0
2015-06-09 11:00:00	AAPL	Stock	31.5525	31.625	31.5362	31.595	11825852.0
2015-06-09 11:30:00	AAPL	Stock	31.5925	31.66	31.5925	31.635	9273644.0
2015-06-09 12:00:00	AAPL	Stock	31.6325	31.65	31.57	31.6325	8100828.0
2015-06-09 12:30:00	AAPL	Stock	31.6325	31.885	31.62	31.883	16326176.0
2015-06-09 13:00:00	AAPL	Stock	31.88	32.02	31.88	32.0075	16314072.0
2015-06-09 13:30:00	AAPL	Stock	32.01	32.02	31.855	31.87	9407488.0
2015-06-09 14:00:00	AAPL	Stock	31.87	31.9275	31.84	31.92	8245136.0
2015-06-09 14:30:00	AAPL	Stock	31.9185	31.99	31.875	31.9175	8640668.0
2015-06-09 15:00:00	AAPL	Stock	31.915	31.9175	31.7825	31.805	10346684.0
2015-06-09 15:30:00	AAPL	Stock	31.805	31.895	31.7775	31.8525	15762724.0
2015-06-09 16:00:00	AAPL	Stock	31.855	31.865	31.3588	31.8578	9089876.0
2015-06-09 16:30:00	AAPL	Stock	31.8578	31.875	31.855	31.855	111256.0
2015-06-09 17:00:00	AAPL	Stock	31.8675	31.8675	31.86	31.86	15412.0
2015-06-09 17:30:00	AAPL	Stock	31.8625	31.865	31.85	31.865	33512.0
2015-06-09 18:00:00	AAPL	Stock	31.865	31.875	31.8625	31.875	20760.0
2015-06-09 18:30:00	AAPL	Stock	31.8775	31.8775	31.865	31.865	9380.0
2015-06-09 19:00:00	AAPL	Stock	31.865	31.875	31.8625	31.875	43076.0
2015-06-09 19:30:00	AAPL	Stock	31.8652	31.8875	31.8652	31.8872	18540.0
2015-06-09 07:30:00	MSFT	Stock	45.65	45.67	45.65	45.67	1490.0
2015-06-09 08:00:00	MSFT	Stock	45.71	45.71	45.64	45.66	6600.0
2015-06-09 08:30:00	MSFT	Stock	45.72	45.72	45.56	45.63	4700.0
2015-06-09 09:00:00	MSFT	Stock	45.68	45.75	45.68	45.75	18528.0
2015-06-09 09:30:00	MSFT	Stock	45.76	45.83	45.52	45.55	2632458.0
2015-06-09 10:00:00	MSFT	Stock	45.545	45.77	45.46	45.54	2628320.0
2015-06-09 10:30:00	MSFT	Stock	45.53	45.695	45.46	45.638	1963560.0
2015-06-09 11:00:00	MSFT	Stock	45.63	45.79	45.61	45.65	1381016.0
2015-06-09 11:30:00	MSFT	Stock	45.65	45.785	45.61	45.65	1073894.0
2015-06-09 12:00:00	MSFT	Stock	45.66	45.715	45.63	45.7	852568.0
2015-06-09 12:30:00	MSFT	Stock	45.695	45.89	45.66	45.87	1186413.0
2015-06-09 13:00:00	MSFT	Stock	45.87	45.94	45.805	45.87	974686.0
2015-06-09 13:30:00	MSFT	Stock	45.863	45.918	45.75	45.808	858682.0
2015-06-09 14:00:00	MSFT	Stock	45.8	45.84	45.72	45.81	657566.0
2015-06-09 14:30:00	MSFT	Stock	45.81	45.91	45.79	45.82	1114736.0
2015-06-09 15:00:00	MSFT	Stock	45.825	45.855	45.64	45.695	1218770.0
2015-06-09 15:30:00	MSFT	Stock	45.695	45.73	45.61	45.64	2494842.0
2015-06-09 16:00:00	MSFT	Stock	45.65	45.81	45.556	45.68	4106700.0

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

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