PREVIEW / stock_30min / 2015-09-30

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-30.parquet
  size:    1.6 MB
  rows:    82,599
  symbols: 3,460

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-09-30 04:00:00	AAPL	Stock	27.5	27.615	27.5	27.615	15748.0
2015-09-30 04:30:00	AAPL	Stock	27.62	27.62	27.5875	27.5925	23196.0
2015-09-30 05:00:00	AAPL	Stock	27.5925	27.6225	27.5725	27.5825	139052.0
2015-09-30 05:30:00	AAPL	Stock	27.57	27.5925	27.525	27.5925	28124.0
2015-09-30 06:00:00	AAPL	Stock	27.59	27.5925	27.5625	27.575	47172.0
2015-09-30 06:30:00	AAPL	Stock	27.575	27.5975	27.5725	27.5825	55840.0
2015-09-30 07:00:00	AAPL	Stock	27.575	27.58	27.5	27.5625	225908.0
2015-09-30 07:30:00	AAPL	Stock	27.56	27.595	27.48	27.5825	255220.0
2015-09-30 08:00:00	AAPL	Stock	27.5825	27.6575	27.485	27.6125	887740.0
2015-09-30 08:30:00	AAPL	Stock	27.6125	27.62	27.5325	27.55	302668.0
2015-09-30 09:00:00	AAPL	Stock	27.55	27.6	27.53	27.565	765504.0
2015-09-30 09:30:00	AAPL	Stock	27.565	27.675	27.45	27.5225	35204392.0
2015-09-30 10:00:00	AAPL	Stock	27.5225	27.835	27.515	27.825	20701976.0
2015-09-30 10:30:00	AAPL	Stock	27.8228	27.885	27.755	27.79	15573524.0
2015-09-30 11:00:00	AAPL	Stock	27.7875	27.81	27.6875	27.7372	10784452.0
2015-09-30 11:30:00	AAPL	Stock	27.7375	27.765	27.455	27.5175	16152548.0
2015-09-30 12:00:00	AAPL	Stock	27.52	27.54	27.2875	27.4262	19081140.0
2015-09-30 12:30:00	AAPL	Stock	27.4275	27.44	27.25	27.3022	14988572.0
2015-09-30 13:00:00	AAPL	Stock	27.3012	27.4675	27.295	27.4162	12608088.0
2015-09-30 13:30:00	AAPL	Stock	27.4152	27.4875	27.3432	27.4175	9386548.0
2015-09-30 14:00:00	AAPL	Stock	27.4162	27.4338	27.27	27.3175	14324632.0
2015-09-30 14:30:00	AAPL	Stock	27.32	27.43	27.1825	27.3975	16549600.0
2015-09-30 15:00:00	AAPL	Stock	27.3975	27.4425	27.3275	27.38	11472028.0
2015-09-30 15:30:00	AAPL	Stock	27.3825	27.5725	27.365	27.5725	27567144.0
2015-09-30 16:00:00	AAPL	Stock	27.575	27.5755	27.395	27.4125	18923344.0
2015-09-30 16:30:00	AAPL	Stock	27.405	27.43	27.395	27.415	221852.0
2015-09-30 17:00:00	AAPL	Stock	27.4225	27.4625	27.415	27.4375	84736.0
2015-09-30 17:30:00	AAPL	Stock	27.45	27.45	27.425	27.4425	25508.0
2015-09-30 18:00:00	AAPL	Stock	27.4375	27.46	27.4225	27.46	42544.0
2015-09-30 18:30:00	AAPL	Stock	27.46	27.4625	27.4525	27.46	18184.0
2015-09-30 19:00:00	AAPL	Stock	27.455	27.4825	27.455	27.4725	25044.0
2015-09-30 19:30:00	AAPL	Stock	27.475	27.475	27.45	27.4575	63292.0
2015-09-30 04:00:00	MSFT	Stock	43.8	43.8	43.8	43.8	250.0
2015-09-30 06:30:00	MSFT	Stock	43.97	44.0	43.97	44.0	1380.0
2015-09-30 07:00:00	MSFT	Stock	43.94	44.0	43.92	44.0	5737.0
2015-09-30 07:30:00	MSFT	Stock	44.1	44.18	44.06	44.09	23025.0
2015-09-30 08:00:00	MSFT	Stock	44.02	44.1	43.95	43.95	23783.0
2015-09-30 08:30:00	MSFT	Stock	43.95	43.95	43.81	43.89	13122.0
2015-09-30 09:00:00	MSFT	Stock	43.89	43.9	43.8	43.8	34414.0
2015-09-30 09:30:00	MSFT	Stock	43.88	44.02	43.72	43.79	3090567.0
2015-09-30 10:00:00	MSFT	Stock	43.795	43.98	43.76	43.84	1576338.0
2015-09-30 10:30:00	MSFT	Stock	43.84	43.96	43.77	43.86	1289119.0
2015-09-30 11:00:00	MSFT	Stock	43.85	43.96	43.83	43.91	1305463.0
2015-09-30 11:30:00	MSFT	Stock	43.91	43.98	43.78	43.86	1290975.0
2015-09-30 12:00:00	MSFT	Stock	43.855	43.875	43.78	43.837	1205858.0
2015-09-30 12:30:00	MSFT	Stock	43.84	43.87	43.66	43.73	1569427.0
2015-09-30 13:00:00	MSFT	Stock	43.73	43.98	43.73	43.98	1064886.0
2015-09-30 13:30:00	MSFT	Stock	43.98	44.2	43.95	44.195	1271811.0
2015-09-30 14:00:00	MSFT	Stock	44.192	44.28	44.04	44.27	1315260.0
2015-09-30 14:30:00	MSFT	Stock	44.27	44.3	44.1	44.24	1044376.0

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

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