PREVIEW / stock_30min / 2017-05-02

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-02.parquet
  size:    1.6 MB
  rows:    81,657
  symbols: 3,070

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
2017-05-02 04:00:00	AAPL	Stock	36.645	36.7	36.6375	36.6575	22524.0
2017-05-02 05:00:00	AAPL	Stock	36.6575	36.6575	36.6	36.6375	6456.0
2017-05-02 05:30:00	AAPL	Stock	36.6625	36.685	36.655	36.685	5484.0
2017-05-02 06:00:00	AAPL	Stock	36.685	36.73	36.685	36.6875	14472.0
2017-05-02 06:30:00	AAPL	Stock	36.6875	36.7125	36.6875	36.6875	19280.0
2017-05-02 07:00:00	AAPL	Stock	36.7025	36.7325	36.6375	36.6375	165004.0
2017-05-02 07:30:00	AAPL	Stock	36.64	36.7425	36.64	36.7175	139236.0
2017-05-02 08:00:00	AAPL	Stock	36.725	36.835	36.66	36.8125	587516.0
2017-05-02 08:30:00	AAPL	Stock	36.8125	36.82	36.78	36.8125	218564.0
2017-05-02 09:00:00	AAPL	Stock	36.8125	36.885	36.775	36.885	765016.0
2017-05-02 09:30:00	AAPL	Stock	36.885	36.9225	36.745	36.8475	21324804.0
2017-05-02 10:00:00	AAPL	Stock	36.85	36.9	36.7625	36.815	10396800.0
2017-05-02 10:30:00	AAPL	Stock	36.8175	36.945	36.8075	36.9138	7379740.0
2017-05-02 11:00:00	AAPL	Stock	36.9125	37.0225	36.9125	36.9775	10575180.0
2017-05-02 11:30:00	AAPL	Stock	36.975	36.989	36.8925	36.9233	7372036.0
2017-05-02 12:00:00	AAPL	Stock	36.9238	36.965	36.87	36.879	5900296.0
2017-05-02 12:30:00	AAPL	Stock	36.8787	36.9125	36.8425	36.8525	4754144.0
2017-05-02 13:00:00	AAPL	Stock	36.855	36.87	36.755	36.7608	6656244.0
2017-05-02 13:30:00	AAPL	Stock	36.76	36.8025	36.71	36.7403	7473992.0
2017-05-02 14:00:00	AAPL	Stock	36.74	36.8475	36.7375	36.8175	7180284.0
2017-05-02 14:30:00	AAPL	Stock	36.815	36.845	36.8125	36.8162	6235340.0
2017-05-02 15:00:00	AAPL	Stock	36.8175	36.91	36.8125	36.9025	9617896.0
2017-05-02 15:30:00	AAPL	Stock	36.9015	36.9025	36.8275	36.8675	20431772.0
2017-05-02 16:00:00	AAPL	Stock	36.8675	37.25	36.8625	36.95	7995432.0
2017-05-02 16:30:00	AAPL	Stock	36.95	37.09	36.075	36.1	11337412.0
2017-05-02 17:00:00	AAPL	Stock	36.1	36.3125	35.9525	36.11	3541856.0
2017-05-02 17:30:00	AAPL	Stock	36.11	36.175	36.0	36.0625	984464.0
2017-05-02 18:00:00	AAPL	Stock	36.0625	36.155	36.0375	36.1325	415988.0
2017-05-02 18:30:00	AAPL	Stock	36.125	36.22	36.125	36.1625	638368.0
2017-05-02 19:00:00	AAPL	Stock	36.165	36.24	36.1625	36.2325	297552.0
2017-05-02 19:30:00	AAPL	Stock	36.2325	36.25	36.1775	36.2	323836.0
2017-05-02 04:00:00	MSFT	Stock	69.6	69.6	69.6	69.6	299.0
2017-05-02 06:00:00	MSFT	Stock	69.58	69.58	69.58	69.58	100.0
2017-05-02 06:30:00	MSFT	Stock	69.58	69.6	69.58	69.6	3567.0
2017-05-02 07:00:00	MSFT	Stock	69.59	69.59	69.59	69.59	158.0
2017-05-02 07:30:00	MSFT	Stock	69.54	69.54	69.54	69.54	100.0
2017-05-02 08:00:00	MSFT	Stock	69.59	69.65	69.59	69.65	1538.0
2017-05-02 08:30:00	MSFT	Stock	69.62	69.67	69.62	69.62	7209.0
2017-05-02 09:00:00	MSFT	Stock	69.61	69.74	69.6	69.71	8496.0
2017-05-02 09:30:00	MSFT	Stock	69.71	69.71	69.27	69.36	2671118.0
2017-05-02 10:00:00	MSFT	Stock	69.36	69.47	69.33	69.415	1906896.0
2017-05-02 10:30:00	MSFT	Stock	69.415	69.48	69.36	69.465	1412279.0
2017-05-02 11:00:00	MSFT	Stock	69.46	69.5	69.41	69.465	1124633.0
2017-05-02 11:30:00	MSFT	Stock	69.46	69.55	69.44	69.455	842381.0
2017-05-02 12:00:00	MSFT	Stock	69.46	69.63	69.455	69.625	1147181.0
2017-05-02 12:30:00	MSFT	Stock	69.63	69.685	69.58	69.65	778880.0
2017-05-02 13:00:00	MSFT	Stock	69.65	69.71	69.61	69.635	571193.0
2017-05-02 13:30:00	MSFT	Stock	69.63	69.67	69.59	69.6	711955.0
2017-05-02 14:00:00	MSFT	Stock	69.605	69.65	69.57	69.588	820197.0
2017-05-02 14:30:00	MSFT	Stock	69.585	69.61	69.45	69.46	1430991.0

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

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