PREVIEW / stock_30min / 2017-02-15

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-15.parquet
  size:    1.6 MB
  rows:    82,941
  symbols: 3,111

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-02-15 04:00:00	AAPL	Stock	33.925	33.97	33.9	33.94	13852.0
2017-02-15 04:30:00	AAPL	Stock	33.9625	33.995	33.9625	33.995	34416.0
2017-02-15 05:00:00	AAPL	Stock	34.0025	34.0925	34.0	34.0725	29752.0
2017-02-15 05:30:00	AAPL	Stock	34.0375	34.0375	34.0	34.0	22848.0
2017-02-15 06:00:00	AAPL	Stock	34.0	34.025	33.98	34.025	51856.0
2017-02-15 06:30:00	AAPL	Stock	33.995	34.0025	33.9125	33.925	114632.0
2017-02-15 07:00:00	AAPL	Stock	33.925	33.96	33.885	33.885	174636.0
2017-02-15 07:30:00	AAPL	Stock	33.88	33.95	33.875	33.875	147868.0
2017-02-15 08:00:00	AAPL	Stock	33.8875	34.025	33.675	33.9325	361356.0
2017-02-15 08:30:00	AAPL	Stock	33.9375	33.9375	33.845	33.885	304768.0
2017-02-15 09:00:00	AAPL	Stock	33.885	33.9225	33.84	33.8825	471096.0
2017-02-15 09:30:00	AAPL	Stock	33.88	34.0675	33.855	34.0462	29225496.0
2017-02-15 10:00:00	AAPL	Stock	34.0475	34.0475	33.812	33.85	14777864.0
2017-02-15 10:30:00	AAPL	Stock	33.8525	33.8988	33.8025	33.81	10253424.0
2017-02-15 11:00:00	AAPL	Stock	33.8075	33.865	33.745	33.83	10016068.0
2017-02-15 11:30:00	AAPL	Stock	33.83	33.8338	33.735	33.7712	7125232.0
2017-02-15 12:00:00	AAPL	Stock	33.77	33.7925	33.7175	33.7665	6527144.0
2017-02-15 12:30:00	AAPL	Stock	33.7675	33.775	33.7225	33.735	5137040.0
2017-02-15 13:00:00	AAPL	Stock	33.7375	33.7618	33.655	33.74	5884016.0
2017-02-15 13:30:00	AAPL	Stock	33.74	33.825	33.73	33.775	4626972.0
2017-02-15 14:00:00	AAPL	Stock	33.776	33.8125	33.755	33.805	3297040.0
2017-02-15 14:30:00	AAPL	Stock	33.805	33.845	33.795	33.815	3592580.0
2017-02-15 15:00:00	AAPL	Stock	33.8175	33.845	33.795	33.8375	3791884.0
2017-02-15 15:30:00	AAPL	Stock	33.8362	33.88	33.835	33.8775	10803368.0
2017-02-15 16:00:00	AAPL	Stock	33.875	33.895	33.855	33.8825	6922372.0
2017-02-15 16:30:00	AAPL	Stock	33.8825	33.8975	33.8775	33.8825	98424.0
2017-02-15 17:00:00	AAPL	Stock	33.8825	33.8825	33.8575	33.8575	12640.0
2017-02-15 17:30:00	AAPL	Stock	33.8825	33.885	33.8525	33.8575	36804.0
2017-02-15 18:00:00	AAPL	Stock	33.875	33.8925	33.8625	33.8875	43452.0
2017-02-15 18:30:00	AAPL	Stock	33.89	33.89	33.88	33.89	20536.0
2017-02-15 19:00:00	AAPL	Stock	33.885	33.89	33.88	33.8875	30008.0
2017-02-15 19:30:00	AAPL	Stock	33.895	33.895	33.8775	33.895	23188.0
2017-02-15 04:00:00	MSFT	Stock	64.93	64.93	64.93	64.93	300.0
2017-02-15 07:30:00	MSFT	Stock	64.55	64.55	64.55	64.55	1370.0
2017-02-15 08:00:00	MSFT	Stock	64.64	64.64	64.55	64.64	3967.0
2017-02-15 08:30:00	MSFT	Stock	64.56	64.56	64.55	64.55	3723.0
2017-02-15 09:00:00	MSFT	Stock	64.55	64.62	64.49	64.49	17599.0
2017-02-15 09:30:00	MSFT	Stock	64.49	64.52	64.21	64.26	1700078.0
2017-02-15 10:00:00	MSFT	Stock	64.26	64.28	64.155	64.21	974878.0
2017-02-15 10:30:00	MSFT	Stock	64.2	64.28	64.195	64.24	778859.0
2017-02-15 11:00:00	MSFT	Stock	64.24	64.48	64.21	64.435	909611.0
2017-02-15 11:30:00	MSFT	Stock	64.435	64.46	64.2	64.37	1231283.0
2017-02-15 12:00:00	MSFT	Stock	64.38	64.405	64.31	64.32	465957.0
2017-02-15 12:30:00	MSFT	Stock	64.315	64.44	64.31	64.41	565296.0
2017-02-15 13:00:00	MSFT	Stock	64.415	64.52	64.39	64.518	703817.0
2017-02-15 13:30:00	MSFT	Stock	64.515	64.54	64.455	64.48	579962.0
2017-02-15 14:00:00	MSFT	Stock	64.48	64.56	64.405	64.505	776160.0
2017-02-15 14:30:00	MSFT	Stock	64.51	64.555	64.46	64.545	796875.0
2017-02-15 15:00:00	MSFT	Stock	64.55	64.57	64.5	64.505	1027529.0
2017-02-15 15:30:00	MSFT	Stock	64.51	64.56	64.44	64.53	2279653.0

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

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