PREVIEW / stock_30min / 2016-03-29

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-29.parquet
  size:    1.6 MB
  rows:    82,835
  symbols: 3,361

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
2016-03-29 04:00:00	AAPL	Stock	26.385	26.415	26.3175	26.415	35868.0
2016-03-29 05:00:00	AAPL	Stock	26.345	26.345	26.345	26.345	1600.0
2016-03-29 05:30:00	AAPL	Stock	26.305	26.3275	26.2975	26.3275	9400.0
2016-03-29 06:00:00	AAPL	Stock	26.325	26.325	26.3125	26.3125	2480.0
2016-03-29 06:30:00	AAPL	Stock	26.305	26.305	26.28	26.28	6456.0
2016-03-29 07:00:00	AAPL	Stock	26.2325	26.2325	26.18	26.2175	17680.0
2016-03-29 07:30:00	AAPL	Stock	26.2075	26.25	26.2075	26.2475	8776.0
2016-03-29 08:00:00	AAPL	Stock	26.25	26.25	26.21	26.2375	27340.0
2016-03-29 08:30:00	AAPL	Stock	26.25	26.265	26.2375	26.2625	98944.0
2016-03-29 09:00:00	AAPL	Stock	26.2525	26.2875	26.225	26.225	168736.0
2016-03-29 09:30:00	AAPL	Stock	26.2225	26.495	26.22	26.4845	13035168.0
2016-03-29 10:00:00	AAPL	Stock	26.4845	26.5625	26.4475	26.5238	9706088.0
2016-03-29 10:30:00	AAPL	Stock	26.5248	26.71	26.52	26.6925	11721536.0
2016-03-29 11:00:00	AAPL	Stock	26.6925	26.74	26.625	26.65	7019512.0
2016-03-29 11:30:00	AAPL	Stock	26.65	26.705	26.5925	26.6818	6203208.0
2016-03-29 12:00:00	AAPL	Stock	26.6788	26.8125	26.6725	26.8025	7736232.0
2016-03-29 12:30:00	AAPL	Stock	26.8015	26.84	26.7775	26.8075	7720060.0
2016-03-29 13:00:00	AAPL	Stock	26.8075	26.826	26.75	26.81	4509168.0
2016-03-29 13:30:00	AAPL	Stock	26.8082	26.875	26.7925	26.8612	5936752.0
2016-03-29 14:00:00	AAPL	Stock	26.8618	26.9325	26.8425	26.9	7602544.0
2016-03-29 14:30:00	AAPL	Stock	26.9	26.94	26.865	26.89	5520280.0
2016-03-29 15:00:00	AAPL	Stock	26.8875	26.9475	26.88	26.92	5319564.0
2016-03-29 15:30:00	AAPL	Stock	26.92	26.9375	26.8825	26.92	12222824.0
2016-03-29 16:00:00	AAPL	Stock	26.92	26.93	26.9	26.9075	9328056.0
2016-03-29 16:30:00	AAPL	Stock	26.9125	26.93	26.9125	26.9225	54796.0
2016-03-29 17:00:00	AAPL	Stock	26.9125	26.92	26.895	26.895	211244.0
2016-03-29 17:30:00	AAPL	Stock	26.895	26.9125	26.8925	26.9	7200.0
2016-03-29 18:00:00	AAPL	Stock	26.8975	26.92	26.8975	26.91	20600.0
2016-03-29 18:30:00	AAPL	Stock	26.91	26.92	26.91	26.915	22960.0
2016-03-29 19:00:00	AAPL	Stock	26.9125	26.93	26.9125	26.93	31752.0
2016-03-29 19:30:00	AAPL	Stock	26.9325	26.9425	26.93	26.93	27048.0
2016-03-29 04:30:00	MSFT	Stock	53.54	53.54	53.54	53.54	100.0
2016-03-29 05:00:00	MSFT	Stock	53.57	53.57	53.57	53.57	100.0
2016-03-29 05:30:00	MSFT	Stock	53.57	53.57	53.13	53.13	600.0
2016-03-29 07:30:00	MSFT	Stock	53.4	53.4	53.4	53.4	100.0
2016-03-29 08:00:00	MSFT	Stock	53.4	53.4	53.4	53.4	149.0
2016-03-29 08:30:00	MSFT	Stock	53.39	53.43	53.39	53.43	200.0
2016-03-29 09:00:00	MSFT	Stock	53.44	53.64	53.44	53.64	14966.0
2016-03-29 09:30:00	MSFT	Stock	53.66	53.77	53.45	53.65	1553825.0
2016-03-29 10:00:00	MSFT	Stock	53.65	54.0	53.61	53.975	1104040.0
2016-03-29 10:30:00	MSFT	Stock	53.98	54.15	53.96	54.11	1347834.0
2016-03-29 11:00:00	MSFT	Stock	54.11	54.32	54.1	54.29	1216009.0
2016-03-29 11:30:00	MSFT	Stock	54.29	54.32	54.11	54.217	1081290.0
2016-03-29 12:00:00	MSFT	Stock	54.22	54.6	54.19	54.57	1607649.0
2016-03-29 12:30:00	MSFT	Stock	54.56	54.8	54.55	54.695	1536789.0
2016-03-29 13:00:00	MSFT	Stock	54.7	54.74	54.56	54.58	937702.0
2016-03-29 13:30:00	MSFT	Stock	54.585	54.59	54.43	54.5	879091.0
2016-03-29 14:00:00	MSFT	Stock	54.51	54.8	54.47	54.77	1514579.0
2016-03-29 14:30:00	MSFT	Stock	54.775	54.86	54.67	54.725	1433709.0
2016-03-29 15:00:00	MSFT	Stock	54.72	54.845	54.68	54.764	1511120.0

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

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