PREVIEW / stock_30min / 2015-09-11

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-11.parquet
  size:    1.5 MB
  rows:    80,858
  symbols: 3,451

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-11 04:00:00	AAPL	Stock	28.045	28.045	28.0	28.0	6000.0
2015-09-11 04:30:00	AAPL	Stock	27.975	27.975	27.95	27.95	1600.0
2015-09-11 05:00:00	AAPL	Stock	27.9375	27.975	27.9375	27.975	2000.0
2015-09-11 05:30:00	AAPL	Stock	27.9875	27.9975	27.9375	27.9975	14516.0
2015-09-11 06:00:00	AAPL	Stock	28.0	28.0125	27.9875	27.9975	20024.0
2015-09-11 06:30:00	AAPL	Stock	27.99	28.0	27.95	27.95	9308.0
2015-09-11 07:00:00	AAPL	Stock	27.9375	28.035	27.9375	28.0	46652.0
2015-09-11 07:30:00	AAPL	Stock	27.9825	28.0	27.97	27.9825	58672.0
2015-09-11 08:00:00	AAPL	Stock	27.9775	28.095	27.9375	28.0675	305152.0
2015-09-11 08:30:00	AAPL	Stock	28.06	28.0625	27.9875	27.995	199868.0
2015-09-11 09:00:00	AAPL	Stock	27.9925	28.0	27.92	27.9275	657408.0
2015-09-11 09:30:00	AAPL	Stock	27.9475	28.115	27.94	28.0	24645032.0
2015-09-11 10:00:00	AAPL	Stock	28.0	28.0725	27.9575	28.0025	13063108.0
2015-09-11 10:30:00	AAPL	Stock	28.0	28.15	27.9825	28.08	11359880.0
2015-09-11 11:00:00	AAPL	Stock	28.08	28.0925	27.995	28.0525	8570872.0
2015-09-11 11:30:00	AAPL	Stock	28.05	28.15	27.9975	28.13	9525292.0
2015-09-11 12:00:00	AAPL	Stock	28.1325	28.2375	28.1275	28.2375	11032272.0
2015-09-11 12:30:00	AAPL	Stock	28.235	28.3275	28.225	28.31	11512708.0
2015-09-11 13:00:00	AAPL	Stock	28.31	28.33	28.2	28.2338	8677604.0
2015-09-11 13:30:00	AAPL	Stock	28.2322	28.3575	28.205	28.3212	9502304.0
2015-09-11 14:00:00	AAPL	Stock	28.32	28.42	28.265	28.4125	12708152.0
2015-09-11 14:30:00	AAPL	Stock	28.4125	28.525	28.3125	28.45	18159468.0
2015-09-11 15:00:00	AAPL	Stock	28.4512	28.5425	28.4512	28.5025	15408812.0
2015-09-11 15:30:00	AAPL	Stock	28.505	28.55	28.4675	28.55	21280692.0
2015-09-11 16:00:00	AAPL	Stock	28.55	28.5525	28.5	28.505	10239040.0
2015-09-11 16:30:00	AAPL	Stock	28.5025	28.5525	28.4875	28.5175	261820.0
2015-09-11 17:00:00	AAPL	Stock	28.52	28.525	28.5	28.5175	115400.0
2015-09-11 17:30:00	AAPL	Stock	28.51	28.54	28.5075	28.53	129812.0
2015-09-11 18:00:00	AAPL	Stock	28.54	28.55	28.52	28.55	76068.0
2015-09-11 18:30:00	AAPL	Stock	28.55	28.56	28.545	28.5575	36372.0
2015-09-11 19:00:00	AAPL	Stock	28.5525	28.5625	28.5375	28.56	91028.0
2015-09-11 19:30:00	AAPL	Stock	28.56	28.575	28.56	28.5725	114956.0
2015-09-11 08:00:00	MSFT	Stock	43.1	43.1	43.1	43.1	450.0
2015-09-11 08:30:00	MSFT	Stock	43.1	43.15	43.05	43.1	6901.0
2015-09-11 09:00:00	MSFT	Stock	43.1	43.24	43.05	43.14	11000.0
2015-09-11 09:30:00	MSFT	Stock	43.14	43.29	42.94	43.12	2637926.0
2015-09-11 10:00:00	MSFT	Stock	43.12	43.275	43.07	43.139	1504425.0
2015-09-11 10:30:00	MSFT	Stock	43.13	43.33	43.085	43.085	1450714.0
2015-09-11 11:00:00	MSFT	Stock	43.09	43.22	43.05	43.19	1205464.0
2015-09-11 11:30:00	MSFT	Stock	43.2	43.38	43.14	43.33	1136291.0
2015-09-11 12:00:00	MSFT	Stock	43.33	43.5	43.3	43.48	1209817.0
2015-09-11 12:30:00	MSFT	Stock	43.477	43.58	43.39	43.55	937600.0
2015-09-11 13:00:00	MSFT	Stock	43.555	43.59	43.31	43.315	985291.0
2015-09-11 13:30:00	MSFT	Stock	43.315	43.46	43.26	43.37	816367.0
2015-09-11 14:00:00	MSFT	Stock	43.364	43.46	43.3	43.365	824078.0
2015-09-11 14:30:00	MSFT	Stock	43.37	43.52	43.364	43.42	1104185.0
2015-09-11 15:00:00	MSFT	Stock	43.42	43.47	43.33	43.375	1820706.0
2015-09-11 15:30:00	MSFT	Stock	43.37	43.48	43.28	43.48	4551691.0
2015-09-11 16:00:00	MSFT	Stock	43.48	43.48	43.39	43.45	5090274.0
2015-09-11 16:30:00	MSFT	Stock	43.45	43.5	43.45	43.5	588.0

> showing 50 of 80,858 rows — these rows as CSV

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