PREVIEW / stock_30min / 2015-09-08

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-08.parquet
  size:    1.6 MB
  rows:    84,134
  symbols: 3,468

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-08 04:00:00	AAPL	Stock	27.97	27.98	27.855	27.8925	19024.0
2015-09-08 04:30:00	AAPL	Stock	27.8625	28.0	27.855	28.0	23148.0
2015-09-08 05:00:00	AAPL	Stock	28.0	28.0	27.985	28.0	34564.0
2015-09-08 05:30:00	AAPL	Stock	28.0	28.0625	28.0	28.0425	14132.0
2015-09-08 06:00:00	AAPL	Stock	28.055	28.0625	28.0	28.025	63616.0
2015-09-08 06:30:00	AAPL	Stock	28.025	28.025	27.9725	28.0025	127108.0
2015-09-08 07:00:00	AAPL	Stock	27.99	28.0125	27.865	27.875	173692.0
2015-09-08 07:30:00	AAPL	Stock	27.9175	27.9475	27.8125	27.8125	136928.0
2015-09-08 08:00:00	AAPL	Stock	27.8375	28.0625	27.715	27.85	877452.0
2015-09-08 08:30:00	AAPL	Stock	27.845	28.0	27.8275	27.8375	546880.0
2015-09-08 09:00:00	AAPL	Stock	27.845	27.9375	27.82	27.92	737948.0
2015-09-08 09:30:00	AAPL	Stock	27.9125	28.14	27.79	28.03	33274676.0
2015-09-08 10:00:00	AAPL	Stock	28.03	28.12	27.9425	28.0125	17429792.0
2015-09-08 10:30:00	AAPL	Stock	28.0125	28.0475	27.8825	27.9325	12997508.0
2015-09-08 11:00:00	AAPL	Stock	27.9325	27.9825	27.8838	27.96	8236460.0
2015-09-08 11:30:00	AAPL	Stock	27.9625	27.9925	27.8425	27.87	9302840.0
2015-09-08 12:00:00	AAPL	Stock	27.87	27.96	27.83	27.9588	8463836.0
2015-09-08 12:30:00	AAPL	Stock	27.96	27.9725	27.7575	27.7725	9399420.0
2015-09-08 13:00:00	AAPL	Stock	27.7678	27.7958	27.58	27.6525	15537496.0
2015-09-08 13:30:00	AAPL	Stock	27.655	27.7175	27.605	27.71	9856032.0
2015-09-08 14:00:00	AAPL	Stock	27.7125	27.82	27.7062	27.7925	10969944.0
2015-09-08 14:30:00	AAPL	Stock	27.7925	27.8325	27.7375	27.76	11777392.0
2015-09-08 15:00:00	AAPL	Stock	27.76	27.905	27.7378	27.9025	10573988.0
2015-09-08 15:30:00	AAPL	Stock	27.9025	28.0775	27.88	28.0775	24887340.0
2015-09-08 16:00:00	AAPL	Stock	28.0775	28.1	28.035	28.1	15413592.0
2015-09-08 16:30:00	AAPL	Stock	28.0925	28.12	27.8878	28.1075	244280.0
2015-09-08 17:00:00	AAPL	Stock	28.1075	28.1425	28.09	28.1375	153156.0
2015-09-08 17:30:00	AAPL	Stock	28.14	28.15	28.115	28.125	103932.0
2015-09-08 18:00:00	AAPL	Stock	28.115	28.1225	28.1025	28.1125	82776.0
2015-09-08 18:30:00	AAPL	Stock	28.1075	28.115	28.0875	28.11	32376.0
2015-09-08 19:00:00	AAPL	Stock	28.11	28.135	28.1	28.1125	80488.0
2015-09-08 19:30:00	AAPL	Stock	28.1025	28.165	28.1025	28.1475	213040.0
2015-09-08 04:00:00	MSFT	Stock	43.36	43.36	43.36	43.36	100.0
2015-09-08 05:00:00	MSFT	Stock	43.18	43.18	43.18	43.18	500.0
2015-09-08 05:30:00	MSFT	Stock	43.48	43.48	43.48	43.48	100.0
2015-09-08 06:30:00	MSFT	Stock	43.5	43.5	43.5	43.5	200.0
2015-09-08 07:00:00	MSFT	Stock	43.54	43.54	43.46	43.46	1100.0
2015-09-08 07:30:00	MSFT	Stock	43.5	43.5	43.35	43.36	1200.0
2015-09-08 08:00:00	MSFT	Stock	43.26	43.46	43.1	43.18	7724.0
2015-09-08 08:30:00	MSFT	Stock	43.2	43.35	43.2	43.35	6840.0
2015-09-08 09:00:00	MSFT	Stock	43.33	43.38	43.24	43.29	4641.0
2015-09-08 09:30:00	MSFT	Stock	43.3	44.0	43.29	43.98	4559246.0
2015-09-08 10:00:00	MSFT	Stock	43.98	43.99	43.7	43.87	2576090.0
2015-09-08 10:30:00	MSFT	Stock	43.87	43.9	43.47	43.66	2384112.0
2015-09-08 11:00:00	MSFT	Stock	43.66	43.7	43.47	43.57	1743468.0
2015-09-08 11:30:00	MSFT	Stock	43.575	43.621	43.285	43.32	1714404.0
2015-09-08 12:00:00	MSFT	Stock	43.32	43.56	43.28	43.55	1145718.0
2015-09-08 12:30:00	MSFT	Stock	43.55	43.57	43.41	43.44	1162815.0
2015-09-08 13:00:00	MSFT	Stock	43.45	43.49	43.2	43.238	1170355.0
2015-09-08 13:30:00	MSFT	Stock	43.245	43.45	43.205	43.43	1175316.0

> showing 50 of 84,134 rows — these rows as CSV

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