PREVIEW / stock_30min / 2016-08-17

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-17.parquet
  size:    1.6 MB
  rows:    81,360
  symbols: 3,238

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-08-17 04:00:00	AAPL	Stock	27.4075	27.4075	27.4075	27.4075	960.0
2016-08-17 04:30:00	AAPL	Stock	27.3725	27.3775	27.3725	27.375	4696.0
2016-08-17 06:00:00	AAPL	Stock	27.375	27.375	27.375	27.375	800.0
2016-08-17 06:30:00	AAPL	Stock	27.375	27.375	27.375	27.375	4400.0
2016-08-17 07:00:00	AAPL	Stock	27.36	27.36	27.3325	27.3475	9844.0
2016-08-17 07:30:00	AAPL	Stock	27.3425	27.3875	27.34	27.375	14988.0
2016-08-17 08:00:00	AAPL	Stock	27.3725	27.375	27.325	27.33	167520.0
2016-08-17 08:30:00	AAPL	Stock	27.335	27.335	27.275	27.275	292432.0
2016-08-17 09:00:00	AAPL	Stock	27.275	27.2925	27.215	27.275	201192.0
2016-08-17 09:30:00	AAPL	Stock	27.275	27.3125	27.085	27.1525	18332900.0
2016-08-17 10:00:00	AAPL	Stock	27.1525	27.1875	27.115	27.1825	7606948.0
2016-08-17 10:30:00	AAPL	Stock	27.185	27.215	27.1325	27.1475	6743828.0
2016-08-17 11:00:00	AAPL	Stock	27.145	27.21	27.14	27.16	3881724.0
2016-08-17 11:30:00	AAPL	Stock	27.16	27.1625	27.13	27.1515	4624004.0
2016-08-17 12:00:00	AAPL	Stock	27.15	27.2	27.1475	27.1938	4561788.0
2016-08-17 12:30:00	AAPL	Stock	27.1925	27.3075	27.1775	27.2812	6043500.0
2016-08-17 13:00:00	AAPL	Stock	27.2825	27.3	27.255	27.265	4093004.0
2016-08-17 13:30:00	AAPL	Stock	27.2668	27.315	27.2625	27.2775	3669428.0
2016-08-17 14:00:00	AAPL	Stock	27.2775	27.3425	27.2	27.3075	7067124.0
2016-08-17 14:30:00	AAPL	Stock	27.3075	27.315	27.2525	27.2775	4561228.0
2016-08-17 15:00:00	AAPL	Stock	27.2775	27.2825	27.2138	27.2728	5505632.0
2016-08-17 15:30:00	AAPL	Stock	27.275	27.3288	27.2725	27.3	8747964.0
2016-08-17 16:00:00	AAPL	Stock	27.305	27.31	27.28	27.3025	3914556.0
2016-08-17 16:30:00	AAPL	Stock	27.3075	27.32	27.295	27.32	48736.0
2016-08-17 17:00:00	AAPL	Stock	27.3175	27.325	27.3125	27.325	14096.0
2016-08-17 17:30:00	AAPL	Stock	27.32	27.32	27.305	27.305	14312.0
2016-08-17 18:00:00	AAPL	Stock	27.305	27.3225	27.305	27.3125	21600.0
2016-08-17 18:30:00	AAPL	Stock	27.3125	27.3125	27.3075	27.3125	20632.0
2016-08-17 19:00:00	AAPL	Stock	27.3025	27.3125	27.25	27.2975	12460.0
2016-08-17 19:30:00	AAPL	Stock	27.3025	27.315	27.3025	27.3075	3200.0
2016-08-17 06:30:00	MSFT	Stock	57.44	57.44	57.44	57.44	500.0
2016-08-17 08:00:00	MSFT	Stock	57.45	57.45	57.44	57.44	1851.0
2016-08-17 09:00:00	MSFT	Stock	57.58	57.6	57.55	57.55	10576.0
2016-08-17 09:30:00	MSFT	Stock	57.54	57.55	57.24	57.355	1808935.0
2016-08-17 10:00:00	MSFT	Stock	57.355	57.36	57.29	57.35	896326.0
2016-08-17 10:30:00	MSFT	Stock	57.35	57.44	57.33	57.37	1180007.0
2016-08-17 11:00:00	MSFT	Stock	57.37	57.415	57.29	57.29	736703.0
2016-08-17 11:30:00	MSFT	Stock	57.295	57.33	57.26	57.289	725092.0
2016-08-17 12:00:00	MSFT	Stock	57.28	57.31	57.23	57.305	791906.0
2016-08-17 12:30:00	MSFT	Stock	57.305	57.6	57.3	57.57	1122014.0
2016-08-17 13:00:00	MSFT	Stock	57.57	57.59	57.49	57.52	1067307.0
2016-08-17 13:30:00	MSFT	Stock	57.51	57.63	57.445	57.464	1320158.0
2016-08-17 14:00:00	MSFT	Stock	57.465	57.68	57.33	57.58	1738012.0
2016-08-17 14:30:00	MSFT	Stock	57.58	57.6	57.47	57.56	948280.0
2016-08-17 15:00:00	MSFT	Stock	57.555	57.567	57.43	57.515	1394940.0
2016-08-17 15:30:00	MSFT	Stock	57.515	57.59	57.49	57.56	2273958.0
2016-08-17 16:00:00	MSFT	Stock	57.56	57.56	57.53	57.53	1297176.0
2016-08-17 17:00:00	MSFT	Stock	57.54	57.54	57.54	57.54	2000.0
2016-08-17 18:00:00	MSFT	Stock	57.57	57.57	57.57	57.57	100.0
2016-08-17 19:30:00	MSFT	Stock	57.57	57.57	57.57	57.57	500.0

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

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