PREVIEW / stock_30min / 2017-07-21

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-21.parquet
  size:    1.6 MB
  rows:    81,216
  symbols: 2,992

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-07-21 04:30:00	AAPL	Stock	37.58	37.58	37.58	37.58	1292.0
2017-07-21 06:00:00	AAPL	Stock	37.6	37.6	37.58	37.58	5292.0
2017-07-21 06:30:00	AAPL	Stock	37.5625	37.5625	37.4625	37.525	11324.0
2017-07-21 07:00:00	AAPL	Stock	37.55	37.55	37.525	37.5425	1688.0
2017-07-21 07:30:00	AAPL	Stock	37.5425	37.5575	37.5275	37.5275	5940.0
2017-07-21 08:00:00	AAPL	Stock	37.55	37.55	37.505	37.54	41792.0
2017-07-21 08:30:00	AAPL	Stock	37.5425	37.56	37.525	37.5425	41180.0
2017-07-21 09:00:00	AAPL	Stock	37.52	37.5675	37.375	37.56	855036.0
2017-07-21 09:30:00	AAPL	Stock	37.56	37.56	37.22	37.385	22184140.0
2017-07-21 10:00:00	AAPL	Stock	37.3875	37.44	37.3475	37.4	5667136.0
2017-07-21 10:30:00	AAPL	Stock	37.405	37.5125	37.4	37.419	4487244.0
2017-07-21 11:00:00	AAPL	Stock	37.42	37.49	37.34	37.49	4904824.0
2017-07-21 11:30:00	AAPL	Stock	37.4925	37.4975	37.4425	37.49	3423440.0
2017-07-21 12:00:00	AAPL	Stock	37.4925	37.545	37.47	37.525	2849652.0
2017-07-21 12:30:00	AAPL	Stock	37.5262	37.585	37.5125	37.5782	2170156.0
2017-07-21 13:00:00	AAPL	Stock	37.58	37.61	37.523	37.54	2675408.0
2017-07-21 13:30:00	AAPL	Stock	37.5402	37.545	37.4975	37.525	2222116.0
2017-07-21 14:00:00	AAPL	Stock	37.5238	37.525	37.48	37.505	2158888.0
2017-07-21 14:30:00	AAPL	Stock	37.5025	37.5325	37.4925	37.5112	2420492.0
2017-07-21 15:00:00	AAPL	Stock	37.5125	37.5425	37.4825	37.505	3054668.0
2017-07-21 15:30:00	AAPL	Stock	37.5075	37.5825	37.495	37.575	12652444.0
2017-07-21 16:00:00	AAPL	Stock	37.5825	37.5825	37.3375	37.5625	11443100.0
2017-07-21 16:30:00	AAPL	Stock	37.5725	37.575	37.5378	37.5475	96080.0
2017-07-21 17:00:00	AAPL	Stock	37.55	37.5625	37.55	37.5625	5884.0
2017-07-21 17:30:00	AAPL	Stock	37.55	37.5625	37.535	37.535	43876.0
2017-07-21 18:00:00	AAPL	Stock	37.5275	37.54	37.5275	37.54	8800.0
2017-07-21 18:30:00	AAPL	Stock	37.545	37.545	37.5275	37.5275	2200.0
2017-07-21 19:00:00	AAPL	Stock	37.56	37.5625	37.56	37.5625	8400.0
2017-07-21 19:30:00	AAPL	Stock	37.5675	37.5725	37.5325	37.5325	20080.0
2017-07-21 04:00:00	MSFT	Stock	74.44	75.4	74.44	75.4	9068.0
2017-07-21 04:30:00	MSFT	Stock	75.4	75.5	75.3	75.3	2532.0
2017-07-21 05:00:00	MSFT	Stock	75.0	75.09	74.89	74.89	2789.0
2017-07-21 05:30:00	MSFT	Stock	74.82	74.82	74.63	74.63	3390.0
2017-07-21 06:00:00	MSFT	Stock	74.75	74.92	74.6	74.6	23283.0
2017-07-21 06:30:00	MSFT	Stock	74.64	74.68	74.16	74.54	26622.0
2017-07-21 07:00:00	MSFT	Stock	74.42	74.75	74.4	74.4	59070.0
2017-07-21 07:30:00	MSFT	Stock	74.41	74.75	74.3	74.3	70774.0
2017-07-21 08:00:00	MSFT	Stock	74.27	74.8	73.4	73.84	774298.0
2017-07-21 08:30:00	MSFT	Stock	73.82	74.35	73.75	73.84	521037.0
2017-07-21 09:00:00	MSFT	Stock	73.84	74.09	73.19	73.52	1183217.0
2017-07-21 09:30:00	MSFT	Stock	73.52	74.29	73.31	73.89	12582587.0
2017-07-21 10:00:00	MSFT	Stock	73.89	74.16	73.66	73.93	4470087.0
2017-07-21 10:30:00	MSFT	Stock	73.93	74.03	73.67	73.765	2079308.0
2017-07-21 11:00:00	MSFT	Stock	73.765	73.78	73.55	73.76	2177715.0
2017-07-21 11:30:00	MSFT	Stock	73.76	73.85	73.57	73.835	1718289.0
2017-07-21 12:00:00	MSFT	Stock	73.835	73.84	73.61	73.625	1511229.0
2017-07-21 12:30:00	MSFT	Stock	73.625	73.71	73.35	73.537	2070112.0
2017-07-21 13:00:00	MSFT	Stock	73.53	73.6	73.33	73.385	1387618.0
2017-07-21 13:30:00	MSFT	Stock	73.387	73.41	73.2	73.345	1427264.0
2017-07-21 14:00:00	MSFT	Stock	73.34	73.36	73.17	73.295	1148862.0

> showing 50 of 81,216 rows — these rows as CSV

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