PREVIEW / stock_30min / 2015-03-18

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-18.parquet
  size:    1.6 MB
  rows:    83,571
  symbols: 3,496

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-03-18 04:00:00	AAPL	Stock	31.775	31.825	31.775	31.79	9300.0
2015-03-18 04:30:00	AAPL	Stock	31.835	31.8525	31.835	31.85	8152.0
2015-03-18 05:00:00	AAPL	Stock	31.8525	31.8675	31.85	31.8675	22760.0
2015-03-18 05:30:00	AAPL	Stock	31.865	31.87	31.855	31.87	13832.0
2015-03-18 06:00:00	AAPL	Stock	31.855	31.8875	31.845	31.875	42952.0
2015-03-18 06:30:00	AAPL	Stock	31.8625	31.875	31.7825	31.845	71824.0
2015-03-18 07:00:00	AAPL	Stock	31.825	31.85	31.7575	31.775	87724.0
2015-03-18 07:30:00	AAPL	Stock	31.775	31.7775	31.725	31.725	96428.0
2015-03-18 08:00:00	AAPL	Stock	31.76	31.845	31.675	31.7425	401504.0
2015-03-18 08:30:00	AAPL	Stock	31.73	31.7725	31.7175	31.7375	157728.0
2015-03-18 09:00:00	AAPL	Stock	31.7422	31.8175	31.715	31.755	317360.0
2015-03-18 09:30:00	AAPL	Stock	31.7575	31.82	31.6025	31.7425	22514912.0
2015-03-18 10:00:00	AAPL	Stock	31.745	31.975	31.7212	31.9675	19416352.0
2015-03-18 10:30:00	AAPL	Stock	31.97	31.9725	31.85	31.92	11317612.0
2015-03-18 11:00:00	AAPL	Stock	31.92	31.955	31.875	31.88	7649680.0
2015-03-18 11:30:00	AAPL	Stock	31.88	31.905	31.775	31.8138	8284592.0
2015-03-18 12:00:00	AAPL	Stock	31.8125	31.82	31.695	31.7285	7058040.0
2015-03-18 12:30:00	AAPL	Stock	31.7275	31.78	31.6875	31.6925	5808952.0
2015-03-18 13:00:00	AAPL	Stock	31.69	31.695	31.6312	31.6675	6970100.0
2015-03-18 13:30:00	AAPL	Stock	31.6688	31.7925	31.5925	31.7675	8325116.0
2015-03-18 14:00:00	AAPL	Stock	31.7675	32.1	31.7275	32.0525	34392892.0
2015-03-18 14:30:00	AAPL	Stock	32.0525	32.145	32.0175	32.095	20607976.0
2015-03-18 15:00:00	AAPL	Stock	32.0925	32.29	32.0725	32.21	23763304.0
2015-03-18 15:30:00	AAPL	Stock	32.2112	32.2425	32.0975	32.1175	23806860.0
2015-03-18 16:00:00	AAPL	Stock	32.1175	32.163	31.7375	32.1175	46581560.0
2015-03-18 16:30:00	AAPL	Stock	32.12	32.1575	31.882	32.145	103120.0
2015-03-18 17:00:00	AAPL	Stock	32.145	32.1575	32.1175	32.1475	144236.0
2015-03-18 17:30:00	AAPL	Stock	32.1478	32.165	32.1475	32.165	72068.0
2015-03-18 18:00:00	AAPL	Stock	32.1725	32.205	32.1175	32.175	244684.0
2015-03-18 18:30:00	AAPL	Stock	32.17	32.195	32.17	32.185	44688.0
2015-03-18 19:00:00	AAPL	Stock	32.185	32.205	32.17	32.205	122056.0
2015-03-18 19:30:00	AAPL	Stock	32.19	32.205	32.19	32.195	83304.0
2015-03-18 04:30:00	MSFT	Stock	41.67	41.67	41.67	41.67	200.0
2015-03-18 05:30:00	MSFT	Stock	41.56	41.7	41.53	41.7	800.0
2015-03-18 06:30:00	MSFT	Stock	41.52	41.52	41.46	41.46	400.0
2015-03-18 07:30:00	MSFT	Stock	41.47	41.47	41.44	41.44	500.0
2015-03-18 08:00:00	MSFT	Stock	41.45	41.59	41.4	41.44	5164.0
2015-03-18 08:30:00	MSFT	Stock	41.44	41.49	41.35	41.4	4682.0
2015-03-18 09:00:00	MSFT	Stock	41.39	41.54	41.36	41.5	13826.0
2015-03-18 09:30:00	MSFT	Stock	41.49	41.685	41.33	41.55	3533223.0
2015-03-18 10:00:00	MSFT	Stock	41.54	41.82	41.5	41.725	2575154.0
2015-03-18 10:30:00	MSFT	Stock	41.73	41.96	41.64	41.96	2466654.0
2015-03-18 11:00:00	MSFT	Stock	41.96	42.02	41.89	41.91	2323219.0
2015-03-18 11:30:00	MSFT	Stock	41.9	42.0	41.76	41.88	1700821.0
2015-03-18 12:00:00	MSFT	Stock	41.875	41.96	41.85	41.93	1495953.0
2015-03-18 12:30:00	MSFT	Stock	41.93	42.1	41.92	42.01	1459809.0
2015-03-18 13:00:00	MSFT	Stock	42.004	42.05	41.94	42.01	1720137.0
2015-03-18 13:30:00	MSFT	Stock	42.005	42.02	41.88	41.93	1671186.0
2015-03-18 14:00:00	MSFT	Stock	41.92	42.7	41.92	42.61	6130200.0
2015-03-18 14:30:00	MSFT	Stock	42.61	42.75	42.49	42.6	3162704.0

> showing 50 of 83,571 rows — these rows as CSV

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